📄 pkg_zengin_head.sql
字号:
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;
/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -