1 PACKAGE pnt_payment_items_pkg AUTHID CURRENT_USER AS
2 -- $Header: PNTPYITS.pls 120.0 2005/05/29 11:24:02 appldev noship $
3
4 PROCEDURE Insert_Row (
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_PAYMENT_ITEM_ID IN OUT NOCOPY NUMBER,
7 X_DUE_DATE IN DATE,
8 X_SET_OF_BOOKS_ID IN NUMBER,
9 X_CURRENCY_CODE IN VARCHAR2,
10 X_EXPORT_CURRENCY_CODE IN VARCHAR2,
11 X_RATE IN NUMBER,
12 X_PMT_ITEM_TYPE_LOOKUP_CODE IN VARCHAR2,
13 X_PAYMENT_SCHEDULE_ID IN NUMBER,
14 X_PAYMENT_TERM_ID IN OUT NOCOPY NUMBER,
15 X_VENDOR_ID IN NUMBER DEFAULT NULL,
16 X_CUSTOMER_ID IN NUMBER DEFAULT NULL,
17 X_VENDOR_SITE_ID IN NUMBER DEFAULT NULL,
18 X_CUSTOMER_SITE_USE_ID IN NUMBER DEFAULT NULL,
19 X_ACTUAL_AMOUNT IN NUMBER,
20 X_ACCOUNTED_AMOUNT IN NUMBER DEFAULT NULL,
21 X_ACCOUNTED_DATE IN DATE DEFAULT NULL,
22 X_EXPORT_CURRENCY_AMOUNT IN NUMBER,
23 X_ESTIMATED_AMOUNT IN NUMBER,
24 X_CREATION_DATE IN DATE,
25 X_CREATED_BY IN NUMBER,
26 X_LAST_UPDATE_DATE IN DATE,
27 X_LAST_UPDATED_BY IN NUMBER,
28 X_LAST_UPDATE_LOGIN IN NUMBER,
29 X_ENTERED_BY_LEASE IN VARCHAR2,
30 X_EXPORT_TO_AP_FLAG IN VARCHAR2 DEFAULT NULL,
31 X_EXPORT_TO_AR_FLAG IN VARCHAR2 DEFAULT NULL,
32 X_CUST_SHIP_SITE_ID IN NUMBER DEFAULT NULL,
33 x_org_id IN NUMBER,
34 x_comments IN VARCHAR2 DEFAULT NULL,
35 x_AP_INVOICE_NUM IN VARCHAR2 DEFAULT NULL,
36 x_GROUPING_RULE_ID IN NUMBER DEFAULT NULL,
37 x_ADJ_START_DATE IN DATE DEFAULT NULL,
38 x_ADJ_END_DATE IN DATE DEFAULT NULL,
39 x_LAST_ADJUSTMENT_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
40 x_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
41 x_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
42 x_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
43 x_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
44 x_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
45 x_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
46 x_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
47 x_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
48 x_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
49 x_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
50 x_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
51 x_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
52 x_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
53 x_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
54 x_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
55 x_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL
56 );
57
58 PROCEDURE Lock_Row (
59 X_PAYMENT_ITEM_ID IN NUMBER,
60 X_ESTIMATED_AMOUNT IN NUMBER,
61 X_ACTUAL_AMOUNT IN NUMBER,
62 X_PAYMENT_SCHEDULE_ID IN NUMBER,
63 X_DUE_DATE IN DATE,
64 X_RATE IN NUMBER,
65 X_COMMENTS IN VARCHAR2,
66 x_AP_INVOICE_NUM IN VARCHAR2 DEFAULT NULL,
67 x_GROUPING_RULE_ID IN NUMBER DEFAULT NULL,
68 x_ADJ_START_DATE IN DATE DEFAULT NULL,
69 x_ADJ_END_DATE IN DATE DEFAULT NULL,
70 x_LAST_ADJUSTMENT_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
71 x_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
72 x_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
73 x_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
74 x_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
75 x_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
76 x_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
77 x_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
78 x_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
79 x_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
80 x_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
81 x_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
82 x_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
83 x_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
84 x_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
85 x_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
86 x_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL
87 );
88
89 PROCEDURE Update_Row (
90 X_PAYMENT_ITEM_ID IN NUMBER,
91 X_DUE_DATE IN DATE,
92 X_VENDOR_ID IN NUMBER DEFAULT NULL,
93 X_CUSTOMER_ID IN NUMBER DEFAULT NULL,
94 X_VENDOR_SITE_ID IN NUMBER DEFAULT NULL,
95 X_CUSTOMER_SITE_USE_ID IN NUMBER DEFAULT NULL,
96 X_ESTIMATED_AMOUNT IN NUMBER,
97 X_ACTUAL_AMOUNT IN NUMBER,
98 X_ACCOUNTED_AMOUNT IN NUMBER DEFAULT NULL,
99 X_ACCOUNTED_DATE IN DATE DEFAULT NULL,
100 X_EXPORT_CURRENCY_AMOUNT IN NUMBER,
101 X_LAST_UPDATE_DATE IN DATE,
102 X_LAST_UPDATED_BY IN NUMBER,
103 X_LAST_UPDATE_LOGIN IN NUMBER,
104 X_PAYMENT_SCHEDULE_ID IN NUMBER,
105 X_ENTERED_BY_LEASE IN VARCHAR2,
106 X_EXPORT_TO_AP_FLAG IN VARCHAR2 DEFAULT NULL,
107 X_EXPORT_TO_AR_FLAG IN VARCHAR2 DEFAULT NULL,
108 X_CUST_SHIP_SITE_ID IN NUMBER DEFAULT NULL,
109 X_RATE IN NUMBER,
110 x_comments IN VARCHAR2 DEFAULT NULL,
111 x_AP_INVOICE_NUM IN VARCHAR2 DEFAULT NULL,
112 x_GROUPING_RULE_ID IN NUMBER DEFAULT NULL,
113 x_ADJ_START_DATE IN DATE DEFAULT NULL,
114 x_ADJ_END_DATE IN DATE DEFAULT NULL,
115 x_LAST_ADJUSTMENT_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
116 x_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
117 x_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
118 x_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
119 x_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
120 x_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
121 x_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
122 x_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
123 x_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
124 x_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
125 x_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
126 x_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
127 x_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
128 x_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
129 x_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
130 x_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
131 x_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL
132 );
133
134 PROCEDURE Delete_Row (
135 X_PAYMENT_ITEM_ID IN NUMBER
136 );
137
138 END pnt_payment_items_pkg;