pkg_zengin_head.sql

来自「日本pjman公司erp系统 银行支付的DB和VB代码 BASE」· SQL 代码 · 共 100 行

CREATE OR REPLACE PACKAGE PKG_ZENGIN IS 
	--慡嬧僿僢僟乕僩儔儞偵僨乕僞傪僙僢僩偡傞
	FUNCTION FUNC_SET_ZENGIN_HED(
		vcFURIKOMI_NO		VARCHAR2,
		vcGINKOU_CD			VARCHAR2,
		vcGINKOU_BUNRUI_KBN	VARCHAR2,
		vcFURIKOMI_MON		VARCHAR2,
		vcFURIKOMI_DAY		VARCHAR2,
		vcINS_RECORD		VARCHAR2,
		vcUPD_RECORD		VARCHAR2
	)
	RETURN NUMBER;
	
	--慡嬧僨乕僞娭楢僩儔儞偵僨乕僞傪僙僢僩偡傞
	FUNCTION FUNC_SET_ZENGIN_DATA_KANREN(
		vcFURIKOMI_NO		IN	VARCHAR2,
		vcGINKOU_CD			IN 	VARCHAR2, 
		vcDateFrom			IN 	VARCHAR2,
		vcDateTo			IN 	VARCHAR2,
		vcSHIHARAISAKI_CD	IN 	VARCHAR2,
		vcINS_RECORD		IN	VARCHAR2,
		vcUPD_RECORD		IN	VARCHAR2
	) RETURN NUMBER;

	--慡嬧僨乕僞僩儔儞偵僨乕僞傪僙僢僩偡傞
	FUNCTION FUNC_SET_ZENGIN_DATA(
		vcFURIKOMI_NO	VARCHAR2,
		vcINS_RECORD	VARCHAR2,
		vcUPD_RECORD	VARCHAR2
	)
	RETURN NUMBER;


	--慡嬧僨乕僞娭楢僩儔儞丄慡嬧僨乕僞僩儔儞丄慡嬧僿僢僟乕僩儔儞偺
	--壖怳崬No傪惓婯怳崬No偵峏怴偡傞
	FUNCTION FUNC_UPD_FURIKOMI_NO(
		vcKARI_FURIKOMI_NO	VARCHAR2,
		vcFURIKOMI_NO		VARCHAR2,
		--捛壛 2002/09/25 by 嶳嶈(NHT)
		vcFURIKOMI_YMD		VARCHAR2,
		--廔椆 2002/09/25 by 嶳嶈(NHT)
		vcUPD_RECORD		VARCHAR2
	)
	RETURN NUMBER;

	--慡嬧僿僢僟乕僩儔儞傪峏怴偡傞
	FUNCTION FUNC_UPD_ZENGIN_HED(
		vcFURIKOMI_NO		VARCHAR2,
		vcFURIKOMI_MON		VARCHAR2,
		vcFURIKOMI_DAY		VARCHAR2,
		vcUPD_RECORD		VARCHAR2
	)
	RETURN NUMBER;

	--慡嬧僨乕僞僩儔儞偐傜怳崬No偺嵟戝抣傪庢摼
	FUNCTION FUNC_GET_MAX_FURIKOMI_NO
	RETURN VARCHAR2;

	--慡嬧僨乕僞僩儔儞偍傛傃堷悢偐傜
	--嬧峴僔僗僥儉巟暐昞儚乕僋僥乕僽儖傪嶌惉偡傞
	FUNCTION FUNC_APW_GINKOU_SYSTEM(
		vcFURIKOMI_NO		VARCHAR2,
		vcFURIKOMI_YMD		VARCHAR2,
		vcGINKOU_CD			VARCHAR2,
		vcGINKOU_BUNRUI_KBN	VARCHAR2,
		vcUPD_RECORD		VARCHAR2
	)
	RETURN NUMBER;
		
	--慡嬧僿僢僟乕僩儔儞偺懳徾僨乕僞傪巟暐嵪傒乮嶍彍僼儔僌侾乯偵偡傞
	FUNCTION FUNC_DEL_ZENGIN_HED(
		vcFURIKOMI_NO		VARCHAR2,
		vcUPD_RECORD		VARCHAR2
	)
	RETURN NUMBER;

	--慡嬧僨乕僞僩儔儞偺懳徾僨乕僞傪巟暐嵪傒乮嶍彍僼儔僌侾乯偵偡傞
	FUNCTION FUNC_DEL_ZENGIN_DATA(
		vcFURIKOMI_NO		VARCHAR2,
		vcUPD_RECORD		VARCHAR2
	)
	RETURN NUMBER;

	--慡嬧僨乕僞娭楢僩儔儞偺懳徾僨乕僞傪巟暐嵪傒乮嶍彍僼儔僌侾乯偵偡傞
	FUNCTION FUNC_DEL_ZENGIN_DATA_KANREN(
		vcFURIKOMI_NO		VARCHAR2,
		vcUPD_RECORD		VARCHAR2
	)
	RETURN NUMBER;

	--巟暐僩儔儞丄枹暐僩儔儞偺懳徾僨乕僞傪巟暐嵪傒乮嶍彍僼儔僌侾乯偵偡傞
	FUNCTION FUNC_DEL_SHIHARAI_MIBARAI(
		vcFURIKOMI_NO		VARCHAR2,
		vcUPD_RECORD		VARCHAR2
	)
	RETURN NUMBER;

END PKG_ZENGIN;
/