PACKAGE: APPS.LNS_DISB_HISTORIES_H_PKG

Source

1 PACKAGE LNS_DISB_HISTORIES_H_PKG AS
2 /* $Header: LNS_DSBHY_TBLH_S.pls 120.1 2005/07/01 08:31:33 scherkas noship $ */
3 
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 	X_DISB_HISTORY_ID		IN OUT NOCOPY NUMBER
7 	,P_DISB_LINE_ID		IN NUMBER
8 	,P_ATTEMPT_NUMBER		IN NUMBER	DEFAULT NULL
9 	,P_BANK_ACCOUNT_ID		IN NUMBER	DEFAULT NULL
10 	,P_PAYMENT_METHOD_CODE		IN VARCHAR2	DEFAULT NULL
11 	,P_REQUEST_DATE		IN DATE	DEFAULT NULL
12 	,P_PAYMENT_REQUEST_DATE		IN DATE	DEFAULT NULL
13 	,P_STATUS		IN VARCHAR2	DEFAULT NULL
14 	,P_MESSAGES		IN VARCHAR2	DEFAULT NULL
15 	,P_OBJECT_VERSION_NUMBER		IN NUMBER
16 	,P_CREATION_DATE		IN DATE	DEFAULT NULL
17 	,P_CREATED_BY		IN NUMBER	DEFAULT NULL
18 	,P_LAST_UPDATE_DATE		IN DATE	DEFAULT NULL
19 	,P_LAST_UPDATED_BY		IN NUMBER	DEFAULT NULL
20 	,P_LAST_UPDATE_LOGIN		IN NUMBER	DEFAULT NULL
21 );
22 
23 /* Update_Row procedure */
24 PROCEDURE Update_Row(
25 	P_DISB_HISTORY_ID		IN NUMBER
26 	,P_DISB_LINE_ID		IN NUMBER	DEFAULT NULL
27 	,P_ATTEMPT_NUMBER		IN NUMBER	DEFAULT NULL
28 	,P_BANK_ACCOUNT_ID		IN NUMBER	DEFAULT NULL
29 	,P_PAYMENT_METHOD_CODE		IN VARCHAR2	DEFAULT NULL
30 	,P_REQUEST_DATE		IN DATE	DEFAULT NULL
31 	,P_PAYMENT_REQUEST_DATE		IN DATE	DEFAULT NULL
32 	,P_STATUS		IN VARCHAR2	DEFAULT NULL
33 	,P_MESSAGES		IN VARCHAR2	DEFAULT NULL
34 	,P_OBJECT_VERSION_NUMBER		IN NUMBER	DEFAULT NULL
35 	,P_LAST_UPDATE_DATE		IN DATE	DEFAULT NULL
36 	,P_LAST_UPDATED_BY		IN NUMBER	DEFAULT NULL
37 	,P_LAST_UPDATE_LOGIN		IN NUMBER	DEFAULT NULL
38 );
39 
40 /* Delete_Row procedure */
41 PROCEDURE Delete_Row(P_DISB_HISTORY_ID IN NUMBER);
42 
43 /* Lock_Row procedure */
44 PROCEDURE Lock_Row(
45 	P_DISB_HISTORY_ID		IN NUMBER
46 	,P_DISB_LINE_ID		IN NUMBER	DEFAULT NULL
47 	,P_ATTEMPT_NUMBER		IN NUMBER	DEFAULT NULL
48 	,P_BANK_ACCOUNT_ID		IN NUMBER	DEFAULT NULL
49 	,P_PAYMENT_METHOD_CODE		IN VARCHAR2	DEFAULT NULL
50 	,P_REQUEST_DATE		IN DATE	DEFAULT NULL
51 	,P_PAYMENT_REQUEST_DATE		IN DATE	DEFAULT NULL
52 	,P_STATUS		IN VARCHAR2	DEFAULT NULL
53 	,P_MESSAGES		IN VARCHAR2	DEFAULT NULL
54 	,P_OBJECT_VERSION_NUMBER		IN NUMBER	DEFAULT NULL
55 	,P_CREATION_DATE		IN DATE	DEFAULT NULL
56 	,P_CREATED_BY		IN NUMBER	DEFAULT NULL
57 	,P_LAST_UPDATE_DATE		IN DATE	DEFAULT NULL
58 	,P_LAST_UPDATED_BY		IN NUMBER	DEFAULT NULL
59 	,P_LAST_UPDATE_LOGIN		IN NUMBER	DEFAULT NULL
60 );
61 END;
62