DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on AR_GTA_TRX_UTIL

Line 40: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type

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:

Line 56: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type

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:

Line 69: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type

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: --

Line 80: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type

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: --==========================================================================

Line 94: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type

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

Line 95: -- OUT: x_GTA_TRX_Tbl AR_GTA_TRX_UTIL.TRX_TBL_TYPE

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: --

Line 107: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type

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: --==========================================================================

Line 108: , x_GTA_TRX_Tbl OUT NOCOPY AR_GTA_TRX_UTIL.TRX_TBL_TYPE

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:

Line 121: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type

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

Line 123: -- x_trxtype_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:

Line 124: -- x_flex_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type

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:

Line 125: -- x_other_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type

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:

Line 139: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type

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

Line 141: , x_trxtype_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: );

Line 142: , x_flex_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type

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:

Line 143: , x_other_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type

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: --==========================================================================

Line 159: -- x_query_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type

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

Line 172: , x_query_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type

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:

Line 189: -- x_query_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type

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

Line 202: , x_query_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type

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: --==========================================================================

Line 216: -- p_conc_parameters AR_GTA_TRX_UTIL.transferParas_rec_type

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:

Line 219: -- x_query_parameter AR_GTA_TRX_UTIL.Condition_para_tbl_type

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

Line 232: , p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type

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:

Line 234: , x_query_parameter OUT NOCOPY AR_GTA_TRX_UTIL.Condition_para_tbl_type

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:

Line 275: -- P_trxtype_para AR_GTA_TRX_UTIL.Condition_para_tbl_type

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

Line 276: -- p_flex_para AR_GTA_TRX_UTIL.Condition_para_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:

Line 277: -- p_other_para AR_GTA_TRX_UTIL.Condition_para_tbl_type

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:

Line 279: -- OUT: x_GTA_Trx_Tbl AR_GTA_TRX_UTIL.TRX_TBL_TYPE

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

Line 292: , P_trxtype_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type

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

Line 293: , p_flex_query_para IN AR_GTA_TRX_UTIL.Condition_para_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: );

Line 294: , p_other_query_para IN AR_GTA_TRX_UTIL.Condition_para_tbl_type

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:

Line 296: , x_GTA_TRX_TBL OUT NOCOPY AR_GTA_TRX_UTIL.TRX_TBL_TYPE

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: