1 PACKAGE LNS_DISB_LINES_PKG AUTHID CURRENT_USER AS
2 /* $Header: LNS_DSBLN_TBLH_S.pls 120.3 2011/10/25 20:35:39 scherkas ship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_DISB_LINE_ID IN OUT NOCOPY NUMBER
7 ,P_DISB_HEADER_ID IN NUMBER
8 ,P_DISB_LINE_NUMBER IN NUMBER DEFAULT NULL
9 ,P_LINE_AMOUNT IN NUMBER DEFAULT NULL
10 ,P_LINE_PERCENT IN NUMBER DEFAULT NULL
11 ,P_PAYEE_PARTY_ID IN NUMBER DEFAULT NULL
12 ,P_BANK_ACCOUNT_ID IN NUMBER DEFAULT NULL
13 ,P_PAYMENT_METHOD_CODE IN VARCHAR2 DEFAULT NULL
14 ,P_STATUS IN VARCHAR2 DEFAULT NULL
15 ,P_REQUEST_DATE IN DATE DEFAULT NULL
16 ,P_DISBURSEMENT_DATE IN DATE DEFAULT NULL
17 ,P_OBJECT_VERSION_NUMBER IN NUMBER
18 ,P_CREATION_DATE IN DATE DEFAULT NULL
19 ,P_CREATED_BY IN NUMBER DEFAULT NULL
20 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
21 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
22 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
23 ,P_INVOICE_INTERFACE_ID IN NUMBER DEFAULT NULL
24 ,P_INVOICE_ID IN NUMBER DEFAULT NULL
25 ,P_PARTY_SITE_ID IN NUMBER DEFAULT NULL
26 ,P_INCOME_TAX_REGION IN VARCHAR2 DEFAULT NULL
27 ,P_TYPE_1099 IN VARCHAR2 DEFAULT NULL
28 );
29
30 /* Update_Row procedure */
31 PROCEDURE Update_Row(
32 P_DISB_LINE_ID IN NUMBER
33 ,P_DISB_HEADER_ID IN NUMBER DEFAULT NULL
34 ,P_DISB_LINE_NUMBER IN NUMBER DEFAULT NULL
35 ,P_LINE_AMOUNT IN NUMBER DEFAULT NULL
36 ,P_LINE_PERCENT IN NUMBER DEFAULT NULL
37 ,P_PAYEE_PARTY_ID IN NUMBER DEFAULT NULL
38 ,P_BANK_ACCOUNT_ID IN NUMBER DEFAULT NULL
39 ,P_PAYMENT_METHOD_CODE IN VARCHAR2 DEFAULT NULL
40 ,P_STATUS IN VARCHAR2 DEFAULT NULL
41 ,P_REQUEST_DATE IN DATE DEFAULT NULL
42 ,P_DISBURSEMENT_DATE IN DATE DEFAULT NULL
43 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
44 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
45 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
46 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
47 ,P_INVOICE_INTERFACE_ID IN NUMBER DEFAULT NULL
48 ,P_INVOICE_ID IN NUMBER DEFAULT NULL
49 ,P_PARTY_SITE_ID IN NUMBER DEFAULT NULL
50 ,P_INCOME_TAX_REGION IN VARCHAR2 DEFAULT NULL
51 ,P_TYPE_1099 IN VARCHAR2 DEFAULT NULL
52 );
53
54 /* Delete_Row procedure */
55 PROCEDURE Delete_Row(P_DISB_LINE_ID IN NUMBER);
56
57 /* Lock_Row procedure */
58 PROCEDURE Lock_Row(
59 P_DISB_LINE_ID IN NUMBER
60 ,P_DISB_HEADER_ID IN NUMBER DEFAULT NULL
61 ,P_DISB_LINE_NUMBER IN NUMBER DEFAULT NULL
62 ,P_LINE_AMOUNT IN NUMBER DEFAULT NULL
63 ,P_LINE_PERCENT IN NUMBER DEFAULT NULL
64 ,P_PAYEE_PARTY_ID IN NUMBER DEFAULT NULL
65 ,P_BANK_ACCOUNT_ID IN NUMBER DEFAULT NULL
66 ,P_PAYMENT_METHOD_CODE IN VARCHAR2 DEFAULT NULL
67 ,P_STATUS IN VARCHAR2 DEFAULT NULL
68 ,P_REQUEST_DATE IN DATE DEFAULT NULL
69 ,P_DISBURSEMENT_DATE IN DATE DEFAULT NULL
70 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
71 ,P_CREATION_DATE IN DATE DEFAULT NULL
72 ,P_CREATED_BY IN NUMBER DEFAULT NULL
73 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
74 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
75 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
76 ,P_INVOICE_INTERFACE_ID IN NUMBER DEFAULT NULL
77 ,P_INVOICE_ID IN NUMBER DEFAULT NULL
78 ,P_PARTY_SITE_ID IN NUMBER DEFAULT NULL
79 ,P_INCOME_TAX_REGION IN VARCHAR2 DEFAULT NULL
80 ,P_TYPE_1099 IN VARCHAR2 DEFAULT NULL
81 );
82 END;
83
[Home] [Help]