[Home] [Help]
PACKAGE: APPS.FA_LPITEMS_EXPT_PKG
Source
1 PACKAGE FA_LPITEMS_EXPT_PKG AS
2 /* $Header: FAXLPTPS.pls 120.3 2005/06/24 02:08:51 lson noship $ */
3
4 /* This is a wrapper procedure for inserting rows into table
5 AP_INVOICES_INTERFACE. */
6 PROCEDURE Invoice_Insert_Row(
7
8 X_Invoice_ID IN NUMBER,
9 X_Invoice_Num IN VARCHAR2,
10 X_Vendor_ID IN NUMBER,
11 X_Vendor_Site_ID IN NUMBER,
12 X_Invoice_Amount IN NUMBER,
13 X_Invoice_Currency_Code IN VARCHAR2,
14 X_Source IN VARCHAR2,
15 X_Terms_ID IN NUMBER,
16 X_Last_Updated_by IN NUMBER,
17 X_Last_Update_Date IN DATE,
18 X_Last_Update_Login IN NUMBER,
19 X_Created_by IN NUMBER,
20 X_Creation_Date IN DATE,
21 X_GL_Date IN DATE,
22 X_Invoice_Date IN DATE,
23 X_Org_ID IN NUMBER,
24 X_LE_ID IN NUMBER,
25 X_LE_Name IN VARCHAR2,
26 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
27 );
28
29 /*This is a wrapper procedure for inserting rows into table
30 AP_INVOICE_LINES_INTERFACE.*/
31 PROCEDURE Invoice_Line_Insert_Row(
32
33 X_Invoice_ID IN NUMBER,
34 X_Invoice_Line_ID IN NUMBER,
35 X_Line_Number IN NUMBER,
36 X_Line_Type_Lookup_Code IN VARCHAR2 := 'ITEM',
37 X_Amount IN NUMBER,
38 X_Dist_Code_Combination_ID IN NUMBER,
39 X_Last_Updated_by IN NUMBER,
40 X_Last_Update_Date IN DATE,
41 X_Last_Update_Login IN NUMBER,
42 X_Created_by IN NUMBER,
43 X_Creation_Date IN DATE,
44 X_Accounting_Date IN DATE,
45 X_Org_ID IN NUMBER,
46 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
47
48 /* Procedure Payment_Items_to_AP pushes lease payment items in Fixed
49 Assets into Account Payables. For all rows with Export Status
50 'POST', it will create new rows in tables AP_INVOICES_INTERFACE and
51 AP_INVOICE_LINES_INTERFACE. It will be called when a user presses
52 the EXPORT button in the Export Lease Payments to Payables window
53 and run as a concurrent program.*/
54
55 PROCEDURE Payment_Items_to_AP(
56 errbuf OUT NOCOPY VARCHAR2,
57 retcode OUT NOCOPY NUMBER,
58 argument1 IN VARCHAR2 := NULL,
59 argument2 IN VARCHAR2 := NULL,
60 argument3 IN VARCHAR2 := NULL,
61 argument4 IN VARCHAR2 := NULL,
62 argument5 IN VARCHAR2 := NULL,
63 argument6 IN VARCHAR2 := NULL,
64 argument7 IN VARCHAR2 := NULL,
65 argument8 IN VARCHAR2 := NULL,
66 argument9 IN VARCHAR2 := NULL,
67 argument10 IN VARCHAR2 := NULL,
68 argument11 IN VARCHAR2 := NULL,
69 argument12 IN VARCHAR2 := NULL,
70 argument13 IN VARCHAR2 := NULL,
71 argument14 IN VARCHAR2 := NULL,
72 argument15 IN VARCHAR2 := NULL,
73 argument16 IN VARCHAR2 := NULL,
74 argument17 IN VARCHAR2 := NULL,
75 argument18 IN VARCHAR2 := NULL,
76 argument19 IN VARCHAR2 := NULL,
77 argument20 IN VARCHAR2 := NULL,
78 argument21 IN VARCHAR2 := NULL,
79 argument22 IN VARCHAR2 := NULL,
80 argument23 IN VARCHAR2 := NULL,
81 argument24 IN VARCHAR2 := NULL,
82 argument25 IN VARCHAR2 := NULL,
83 argument26 IN VARCHAR2 := NULL,
84 argument27 IN VARCHAR2 := NULL,
85 argument28 IN VARCHAR2 := NULL,
86 argument29 IN VARCHAR2 := NULL,
87 argument30 IN VARCHAR2 := NULL,
88 argument31 IN VARCHAR2 := NULL,
89 argument32 IN VARCHAR2 := NULL,
90 argument33 IN VARCHAR2 := NULL,
91 argument34 IN VARCHAR2 := NULL,
92 argument35 IN VARCHAR2 := NULL,
93 argument36 IN VARCHAR2 := NULL,
94 argument37 IN VARCHAR2 := NULL,
95 argument38 IN VARCHAR2 := NULL,
96 argument39 IN VARCHAR2 := NULL,
97 argument40 IN VARCHAR2 := NULL,
98 argument41 IN VARCHAR2 := NULL,
99 argument42 IN VARCHAR2 := NULL,
100 argument43 IN VARCHAR2 := NULL,
101 argument44 IN VARCHAR2 := NULL,
102 argument45 IN VARCHAR2 := NULL,
103 argument46 IN VARCHAR2 := NULL,
104 argument47 IN VARCHAR2 := NULL,
105 argument48 IN VARCHAR2 := NULL,
106 argument49 IN VARCHAR2 := NULL,
107 argument50 IN VARCHAR2 := NULL,
108 argument51 IN VARCHAR2 := NULL,
109 argument52 IN VARCHAR2 := NULL,
110 argument53 IN VARCHAR2 := NULL,
111 argument54 IN VARCHAR2 := NULL,
112 argument55 IN VARCHAR2 := NULL,
113 argument56 IN VARCHAR2 := NULL,
114 argument57 IN VARCHAR2 := NULL,
115 argument58 IN VARCHAR2 := NULL,
116 argument59 IN VARCHAR2 := NULL,
117 argument60 IN VARCHAR2 := NULL,
118 argument61 IN VARCHAR2 := NULL,
119 argument62 IN VARCHAR2 := NULL,
120 argument63 IN VARCHAR2 := NULL,
121 argument64 IN VARCHAR2 := NULL,
122 argument65 IN VARCHAR2 := NULL,
123 argument66 IN VARCHAR2 := NULL,
124 argument67 IN VARCHAR2 := NULL,
125 argument68 IN VARCHAR2 := NULL,
126 argument69 IN VARCHAR2 := NULL,
127 argument70 IN VARCHAR2 := NULL,
128 argument71 IN VARCHAR2 := NULL,
129 argument72 IN VARCHAR2 := NULL,
130 argument73 IN VARCHAR2 := NULL,
131 argument74 IN VARCHAR2 := NULL,
132 argument75 IN VARCHAR2 := NULL,
133 argument76 IN VARCHAR2 := NULL,
134 argument77 IN VARCHAR2 := NULL,
135 argument78 IN VARCHAR2 := NULL,
136 argument79 IN VARCHAR2 := NULL,
137 argument80 IN VARCHAR2 := NULL,
138 argument81 IN VARCHAR2 := NULL,
139 argument82 IN VARCHAR2 := NULL,
140 argument83 IN VARCHAR2 := NULL,
141 argument84 IN VARCHAR2 := NULL,
142 argument85 IN VARCHAR2 := NULL,
143 argument86 IN VARCHAR2 := NULL,
144 argument87 IN VARCHAR2 := NULL,
145 argument88 IN VARCHAR2 := NULL,
146 argument89 IN VARCHAR2 := NULL,
147 argument90 IN VARCHAR2 := NULL,
148 argument91 IN VARCHAR2 := NULL,
149 argument92 IN VARCHAR2 := NULL,
150 argument93 IN VARCHAR2 := NULL,
151 argument94 IN VARCHAR2 := NULL,
152 argument95 IN VARCHAR2 := NULL,
153 argument96 IN VARCHAR2 := NULL,
154 argument97 IN VARCHAR2 := NULL,
155 argument98 IN VARCHAR2 := NULL,
156 argument99 IN VARCHAR2 := NULL,
157 argument100 IN VARCHAR2 := NULL,
158 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
159
160 END FA_LPITEMS_EXPT_PKG;