36: --
37: -- PARAMETERS:
38: -- In: P_ORG_ID NUMBER
39: -- P_transfer_rule NUMBER
40: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
41: -- p_DEBUG VARCHAR2
42: -- OUT: errbuf varchar2
43: -- retcode VARCHAR2
44:
52: ( errbuf OUT NOCOPY VARCHAR2
53: , retcode OUT NOCOPY VARCHAR2
54: , P_ORG_ID IN NUMBER
55: , P_TRANSFER_id IN NUMBER
56: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
57: );
58:
59: --==========================================================================
60: -- PROCEDURE NAME:
65: --
66: -- PARAMETERS:
67: -- In: P_ORG_ID NUMBER
68: -- p_transfer_id NUMBER
69: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
70: --
71: -- DESIGN REFERENCES:
72: -- GTA-TRANSFER-PROGRAM-TD.doc
73: --
76: --===========================================================================
77: PROCEDURE Generate_XML_output
78: (p_org_id IN NUMBER
79: , p_transfer_id IN NUMBER
80: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
81: );
82:
83:
84: --==========================================================================
90: --
91: -- PARAMETERS:
92: -- In: P_ORG_ID NUMBER
93: -- p_transfer_id VARCHAR2
94: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
95: -- OUT: x_GTA_TRX_Tbl AR_GTA_TRX_UTIL.TRX_TBL_TYPE
96:
97: -- DESIGN REFERENCES:
98: -- GTA-TRANSFER-PROGRAM-TD.doc
91: -- PARAMETERS:
92: -- In: P_ORG_ID NUMBER
93: -- p_transfer_id VARCHAR2
94: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
95: -- OUT: x_GTA_TRX_Tbl AR_GTA_TRX_UTIL.TRX_TBL_TYPE
96:
97: -- DESIGN REFERENCES:
98: -- GTA-TRANSFER-PROGRAM-TD.doc
99: --
103: --===========================================================================
104: PROCEDURE retrive_valid_AR_TRXs
105: ( P_ORG_ID IN NUMBER
106: , p_transfer_id IN NUMBER
107: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
108: , x_GTA_TRX_Tbl OUT NOCOPY AR_GTA_TRX_UTIL.TRX_TBL_TYPE
109: );
110:
111: --==========================================================================
104: PROCEDURE retrive_valid_AR_TRXs
105: ( P_ORG_ID IN NUMBER
106: , p_transfer_id IN NUMBER
107: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
108: , x_GTA_TRX_Tbl OUT NOCOPY AR_GTA_TRX_UTIL.TRX_TBL_TYPE
109: );
110:
111: --==========================================================================
112: -- PROCEDURE NAME:
117: --
118: -- PARAMETERS:
119: -- In: P_ORG_ID NUMBER
120: -- p_transfer_id VARCHAR2
121: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
122: -- OUT: x_query_sql VARCHAR2
123: -- x_trxtype_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
124: -- x_flex_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
125: -- x_other_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
119: -- In: P_ORG_ID NUMBER
120: -- p_transfer_id VARCHAR2
121: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
122: -- OUT: x_query_sql VARCHAR2
123: -- x_trxtype_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
124: -- x_flex_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
125: -- x_other_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
126: -- x_currency_code VARCHAR2
127:
120: -- p_transfer_id VARCHAR2
121: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
122: -- OUT: x_query_sql VARCHAR2
123: -- x_trxtype_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
124: -- x_flex_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
125: -- x_other_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
126: -- x_currency_code VARCHAR2
127:
128:
121: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
122: -- OUT: x_query_sql VARCHAR2
123: -- x_trxtype_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
124: -- x_flex_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
125: -- x_other_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
126: -- x_currency_code VARCHAR2
127:
128:
129: -- DESIGN REFERENCES:
135: --===========================================================================
136: PROCEDURE Get_AR_SQL
137: ( P_ORG_ID IN NUMBER
138: , p_transfer_id IN NUMBER
139: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
140: , x_query_sql OUT NOCOPY VARCHAR2
141: , x_trxtype_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
142: , x_flex_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
143: , x_other_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
137: ( P_ORG_ID IN NUMBER
138: , p_transfer_id IN NUMBER
139: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
140: , x_query_sql OUT NOCOPY VARCHAR2
141: , x_trxtype_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
142: , x_flex_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
143: , x_other_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
144: , x_currency_code OUT NOCOPY VARCHAR2
145: );
138: , p_transfer_id IN NUMBER
139: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
140: , x_query_sql OUT NOCOPY VARCHAR2
141: , x_trxtype_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
142: , x_flex_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
143: , x_other_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
144: , x_currency_code OUT NOCOPY VARCHAR2
145: );
146:
139: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
140: , x_query_sql OUT NOCOPY VARCHAR2
141: , x_trxtype_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
142: , x_flex_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
143: , x_other_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
144: , x_currency_code OUT NOCOPY VARCHAR2
145: );
146:
147: --==========================================================================
155: -- In: P_ORG_ID NUMBER
156: -- p_transfer_id VARCHAR2
157:
158: -- OUT: x_condition_sql Varchar2
159: -- x_query_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
160:
161:
162: -- DESIGN REFERENCES:
163: -- GTA-TRANSFER-PROGRAM-TD.doc
168: PROCEDURE Get_AR_TrxType_Cond
169: ( p_ORG_ID IN NUMBER
170: , p_transfer_id IN NUMBER
171: , x_condition_sql OUT NOCOPY VARCHAR2
172: , x_query_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
173: );
174:
175:
176:
185: -- In: P_ORG_ID NUMBER
186: -- p_transfer_id VARCHAR2
187:
188: -- OUT: x_condition_sql Varchar2
189: -- x_query_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
190:
191:
192: -- DESIGN REFERENCES:
193: -- GTA-TRANSFER-PROGRAM-TD.doc
198: PROCEDURE Get_AR_FLEX_COND
199: ( P_ORG_ID IN NUMBER
200: , p_transfer_id IN NUMBER
201: , x_condition_sql OUT NOCOPY VARCHAR2
202: , x_query_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
203: );
204:
205:
206: --==========================================================================
212: --
213: -- PARAMETERS:
214: -- In: P_ORG_ID NUMBER
215: -- p_transfer_id VARCHAR2
216: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
217:
218: -- OUT: x_condition_sql Varchar2
219: -- x_query_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
220:
215: -- p_transfer_id VARCHAR2
216: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type
217:
218: -- OUT: x_condition_sql Varchar2
219: -- x_query_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type
220:
221:
222: -- DESIGN REFERENCES:
223: -- GTA-TRANSFER-PROGRAM-TD.doc
228: --===========================================================================
229: PROCEDURE Get_Param_Cond
230: ( P_ORG_ID IN NUMBER
231: , p_transfer_id IN NUMBER
232: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
233: , x_condition_sql OUT NOCOPY VARCHAR2
234: , x_query_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
235: );
236:
230: ( P_ORG_ID IN NUMBER
231: , p_transfer_id IN NUMBER
232: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type
233: , x_condition_sql OUT NOCOPY VARCHAR2
234: , x_query_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type
235: );
236:
237: --==========================================================================
238: -- PROCEDURE NAME:
271: --
272: -- PARAMETERS:
273: -- In: P_ORG_ID NUMBER
274: -- p_transfer_id VARCHAR2
275: -- P_trxtype_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
276: -- p_flex_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
277: -- p_other_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
278: -- p_currency_code IN VARCHAR2
279: -- OUT: x_GTA_Trx_Tbl AR_GTA_TRX_UTIL.TRX_TBL_TYPE
272: -- PARAMETERS:
273: -- In: P_ORG_ID NUMBER
274: -- p_transfer_id VARCHAR2
275: -- P_trxtype_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
276: -- p_flex_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
277: -- p_other_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
278: -- p_currency_code IN VARCHAR2
279: -- OUT: x_GTA_Trx_Tbl AR_GTA_TRX_UTIL.TRX_TBL_TYPE
280:
273: -- In: P_ORG_ID NUMBER
274: -- p_transfer_id VARCHAR2
275: -- P_trxtype_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
276: -- p_flex_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
277: -- p_other_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
278: -- p_currency_code IN VARCHAR2
279: -- OUT: x_GTA_Trx_Tbl AR_GTA_TRX_UTIL.TRX_TBL_TYPE
280:
281:
275: -- P_trxtype_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
276: -- p_flex_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
277: -- p_other_para AR_GTA_TRX_UTIL.Condition_para_tbl_type
278: -- p_currency_code IN VARCHAR2
279: -- OUT: x_GTA_Trx_Tbl AR_GTA_TRX_UTIL.TRX_TBL_TYPE
280:
281:
282: -- DESIGN REFERENCES:
283: -- GTA-TRANSFER-PROGRAM-TD.doc
288: PROCEDURE Retrieve_AR_TRXs
289: ( p_org_id IN NUMBER
290: , p_transfer_id IN NUMBER
291: , P_query_SQL IN VARCHAR2
292: , P_trxtype_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
293: , p_flex_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
294: , p_other_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
295: , p_currency_code IN VARCHAR2
296: , x_GTA_TRX_TBL OUT NOCOPY AR_GTA_TRX_UTIL.TRX_TBL_TYPE
289: ( p_org_id IN NUMBER
290: , p_transfer_id IN NUMBER
291: , P_query_SQL IN VARCHAR2
292: , P_trxtype_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
293: , p_flex_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
294: , p_other_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
295: , p_currency_code IN VARCHAR2
296: , x_GTA_TRX_TBL OUT NOCOPY AR_GTA_TRX_UTIL.TRX_TBL_TYPE
297: );
290: , p_transfer_id IN NUMBER
291: , P_query_SQL IN VARCHAR2
292: , P_trxtype_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
293: , p_flex_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
294: , p_other_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
295: , p_currency_code IN VARCHAR2
296: , x_GTA_TRX_TBL OUT NOCOPY AR_GTA_TRX_UTIL.TRX_TBL_TYPE
297: );
298:
292: , P_trxtype_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
293: , p_flex_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
294: , p_other_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type
295: , p_currency_code IN VARCHAR2
296: , x_GTA_TRX_TBL OUT NOCOPY AR_GTA_TRX_UTIL.TRX_TBL_TYPE
297: );
298:
299: --==========================================================================
300: -- PROCEDURE NAME: