eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_GTA_CONSOLIDATE_PROC dependencies on AR_GTA_TRX_UTIL

Line 59: -- In: p_conc_parameters AR_GTA_TRX_UTIL.consolparas_rec_type

55: -- This procedure generate XML string as concurrent output
56: -- from temporary table
57: --
58: -- PARAMETERS:
59: -- In: p_conc_parameters AR_GTA_TRX_UTIL.consolparas_rec_type
60: --
61: -- DESIGN REFERENCES:
62: --
63: --

Line 72: (p_consolidation_paras IN AR_GTA_TRX_UTIL.consolparas_rec_type

68: -- 26-Apr-2013: Jixun Huang modified for Bug#16274922
69: --===========================================================================
70:
71: PROCEDURE Generate_XML_Output
72: (p_consolidation_paras IN AR_GTA_TRX_UTIL.consolparas_rec_type
73: )
74: IS
75: l_procedure_name VARCHAR2(30):='Generate_XML_output';
76: l_report_XML XMLType;

Line 195: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"

191: jgcit.ra_trx_num AS "RATrxNum",
192: jgcit.ra_trx_type AS "RATrxType",
193: --modified by Jixun for bug#16274922 begin
194: --jgcit.amount AS "Amount"
195: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"
196: --modified by Jixun for bug#16274922 end
197: )))
198: INTO l_success_invs
199: FROM AR_gta_consol_invs_temp jgcit

Line 215: ar_gta_trx_util.format_monetary_amount(l_org_id, jgct.amount) AS "Amount",

211: "BankAccountNumber",
212: lk.meaning AS "InvoiceType",
213: --modified by Jixun for bug#16274922 begin
214: --jgct.amount AS "Amount",
215: ar_gta_trx_util.format_monetary_amount(l_org_id, jgct.amount) AS "Amount",
216: --modified by Jixun for bug#16274922 end
217: jgct.failed_reason AS "FailedReason",
218: l_success_invs AS "ConsolidatedInvs"))
219: INTO l_success

Line 245: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"

241: jgcit.ra_trx_num AS "RATrxNum",
242: jgcit.ra_trx_type AS "RATrxType",
243: --modified by Jixun for bug#16274922 begin
244: --jgcit.amount AS "Amount"
245: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"
246: --modified by Jixun for bug#16274922 end
247: )))
248: INTO l_warning_invs
249: FROM AR_gta_consol_invs_temp jgcit

Line 265: ar_gta_trx_util.format_monetary_amount(l_org_id, jgct.amount) AS "Amount",

261: "BankAccountNumber",
262: lk.meaning AS "InvoiceType",
263: --modified by Jixun for bug#16274922 begin
264: --jgct.amount AS "Amount",
265: ar_gta_trx_util.format_monetary_amount(l_org_id, jgct.amount) AS "Amount",
266: --modified by Jixun for bug#16274922 end
267: jgct.failed_reason AS "FailedReason",
268: l_warning_invs AS "ConsolidatedInvs")))
269:

Line 296: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"

292: jgcit.ra_trx_num AS "RATrxNum",
293: jgcit.ra_trx_type AS "RATrxType",
294: --modified by Jixun for bug#16274922 begin
295: --jgcit.amount AS "Amount"
296: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"
297: --modified by Jixun for bug#16274922 end
298: )))
299: INTO l_failed_invs
300: FROM AR_gta_consol_invs_temp jgcit

Line 319: ar_gta_trx_util.format_monetary_amount(l_org_id, jgct.amount) AS "Amount",

315: "BankAccountNumber",
316: lk.meaning AS "InvoiceType",
317: --modified by Jixun for bug#16274922 begin
318: --jgct.amount AS "Amount",
319: ar_gta_trx_util.format_monetary_amount(l_org_id, jgct.amount) AS "Amount",
320: --modified by Jixun for bug#16274922 end
321: jgct.failed_reason AS
322: "FailedReason",
323: l_failed_invs AS

Line 341: ar_gta_trx_util.to_xsd_date_string(SYSDATE) AS

337: SELECT xmlelement("ConsolidationReport",
338: xmlforest(l_reportfailed AS "ReportFailed",
339: l_failedwithparameters AS
340: "FailedWithParameters",
341: ar_gta_trx_util.to_xsd_date_string(SYSDATE) AS
342: "ReqDate",
343: l_parameter AS "Parameters",
344: l_summary AS "Summary",
345: l_success_all AS "SuccessInvs",

Line 352: AR_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);

348: INTO l_report_xml
349: FROM dual;
350:
351: -- concurrent output
352: AR_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
353:
354: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355: AR_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);
356: END IF;

Line 355: AR_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);

351: -- concurrent output
352: AR_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
353:
354: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355: AR_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);
356: END IF;
357:
358:
359: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 387: -- IN p_consolidation_paras AR_GTA_TRX_UTIL.consolparas_rec_type

383: -- DESCRIPTION: This procedure is used to Consolidate GTA invoices
384: --
385: --
386: -- PARAMETERS:
387: -- IN p_consolidation_paras AR_GTA_TRX_UTIL.consolparas_rec_type
388: --
389: --
390: -- HISTORY:
391: -- 30-Jun-2009 : Yao Zhang Create

Line 409: (p_consolidation_paras IN AR_GTA_TRX_UTIL.consolparas_rec_type

405: -- 11-Jan-2011: Qiong Liu fix bug#10638369
406: -- 26-Apr-2013: Jixun Huang modified for ER#16613351
407: --=============================================================================
408: PROCEDURE Create_Consol_Inv
409: (p_consolidation_paras IN AR_GTA_TRX_UTIL.consolparas_rec_type
410: )
411: IS
412: l_procedure_name VARCHAR2(30):='Create_Consol_Inv';
413: l_consolidation_id NUMBER;

Line 420: l_csldted_invs ar_gta_trx_util.trx_tbl_type;

416: l_diff_pri VARCHAR2(1);
417: l_sales_list_flag VARCHAR2(1);
418: l_org_id NUMBER(15); --Yao Zhang add for bug#8770356
419:
420: l_csldted_invs ar_gta_trx_util.trx_tbl_type;
421: l_csldted_inv ar_gta_trx_util.trx_rec_type;
422: l_csldted_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();
423: l_csldted_inv_line ar_gta_trx_util.trx_line_rec_type;
424: l_csldted_invs_index NUMBER;

Line 421: l_csldted_inv ar_gta_trx_util.trx_rec_type;

417: l_sales_list_flag VARCHAR2(1);
418: l_org_id NUMBER(15); --Yao Zhang add for bug#8770356
419:
420: l_csldted_invs ar_gta_trx_util.trx_tbl_type;
421: l_csldted_inv ar_gta_trx_util.trx_rec_type;
422: l_csldted_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();
423: l_csldted_inv_line ar_gta_trx_util.trx_line_rec_type;
424: l_csldted_invs_index NUMBER;
425: l_csldted_inv_lines_index NUMBER;

Line 422: l_csldted_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();

418: l_org_id NUMBER(15); --Yao Zhang add for bug#8770356
419:
420: l_csldted_invs ar_gta_trx_util.trx_tbl_type;
421: l_csldted_inv ar_gta_trx_util.trx_rec_type;
422: l_csldted_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();
423: l_csldted_inv_line ar_gta_trx_util.trx_line_rec_type;
424: l_csldted_invs_index NUMBER;
425: l_csldted_inv_lines_index NUMBER;
426:

Line 423: l_csldted_inv_line ar_gta_trx_util.trx_line_rec_type;

419:
420: l_csldted_invs ar_gta_trx_util.trx_tbl_type;
421: l_csldted_inv ar_gta_trx_util.trx_rec_type;
422: l_csldted_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();
423: l_csldted_inv_line ar_gta_trx_util.trx_line_rec_type;
424: l_csldted_invs_index NUMBER;
425: l_csldted_inv_lines_index NUMBER;
426:
427:

Line 428: l_csldtion_inv ar_gta_trx_util.trx_rec_type;

424: l_csldted_invs_index NUMBER;
425: l_csldted_inv_lines_index NUMBER;
426:
427:
428: l_csldtion_inv ar_gta_trx_util.trx_rec_type;
429: l_csldtion_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();
430: l_csldtion_inv_line ar_gta_trx_util.trx_line_rec_type;
431: l_csldtion_inv_lines_index NUMBER;
432: l_csldtion_line_count NUMBER;

Line 429: l_csldtion_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();

425: l_csldted_inv_lines_index NUMBER;
426:
427:
428: l_csldtion_inv ar_gta_trx_util.trx_rec_type;
429: l_csldtion_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();
430: l_csldtion_inv_line ar_gta_trx_util.trx_line_rec_type;
431: l_csldtion_inv_lines_index NUMBER;
432: l_csldtion_line_count NUMBER;
433: l_csldtion_discount_line_num NUMBER;

Line 430: l_csldtion_inv_line ar_gta_trx_util.trx_line_rec_type;

426:
427:
428: l_csldtion_inv ar_gta_trx_util.trx_rec_type;
429: l_csldtion_inv_lines ar_gta_trx_util.trx_line_tbl_type:=ar_gta_trx_util.trx_line_tbl_type();
430: l_csldtion_inv_line ar_gta_trx_util.trx_line_rec_type;
431: l_csldtion_inv_lines_index NUMBER;
432: l_csldtion_line_count NUMBER;
433: l_csldtion_discount_line_num NUMBER;
434: l_csldtion_line_num NUMBER;--Yao add for bug#8830170

Line 437: l_csldtion_inv_line1 ar_gta_trx_util.trx_line_rec_type;

433: l_csldtion_discount_line_num NUMBER;
434: l_csldtion_line_num NUMBER;--Yao add for bug#8830170
435:
436: --added by jixun for ER#16613351 begin
437: l_csldtion_inv_line1 ar_gta_trx_util.trx_line_rec_type;
438: l_csldtion_inv_lines_index1 NUMBER;
439: --added by jixun for ER#16613351 end
440:
441: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;

Line 612: l_csldted_invs:= ar_gta_trx_util.trx_tbl_type();

608: RETURN;
609: END;
610: --init
611: l_sum_amount:=0;
612: l_csldted_invs:= ar_gta_trx_util.trx_tbl_type();
613: l_csldted_inv:=NULL;
614: l_result_flag:=NULL;
615: l_error_string:=NULL;
616: l_csldted_inv_status_flag:=NULL;--yao add for bug#8882568

Line 624: l_csldtion_inv.trx_lines:=ar_gta_trx_util.trx_line_tbl_type();

620: l_consolidation_gl_date:=NULL;
621: l_csldtion_inv:=NULL;
622: l_csldtion_inv_line:=NULL;
623: -- l_csldtion_line_count:=0;
624: l_csldtion_inv.trx_lines:=ar_gta_trx_util.trx_line_tbl_type();
625: --Yao add end for bug#8919922
626: l_csldtion_inv_line1 := NULL; --added by jixun for ER#16613351
627:
628: OPEN c_consolidated_invs(l_consolidation_id

Line 641: AR_GTA_TRX_UTIL.get_trx(p_trx_header_id => l_gta_trx_header_id

637: LOOP
638: FETCH c_consolidated_invs
639: INTO l_gta_trx_header_id;
640: EXIT WHEN c_consolidated_invs%NOTFOUND;
641: AR_GTA_TRX_UTIL.get_trx(p_trx_header_id => l_gta_trx_header_id
642: ,x_trx_rec => l_csldted_inv
643: );
644: l_csldted_invs.EXTEND;
645: l_csldted_invs(l_csldted_invs.COUNT):=l_csldted_inv;

Line 646: l_amount:=ar_gta_trx_util.get_gtainvoice_amount(l_gta_trx_header_id);

642: ,x_trx_rec => l_csldted_inv
643: );
644: l_csldted_invs.EXTEND;
645: l_csldted_invs(l_csldted_invs.COUNT):=l_csldted_inv;
646: l_amount:=ar_gta_trx_util.get_gtainvoice_amount(l_gta_trx_header_id);
647: l_sum_amount:=l_sum_amount+l_amount;
648: --yao add for bug#8882568 check invoice status
649: IF l_csldted_inv.trx_header.status<>'DRAFT'
650: THEN

Line 738: l_amount := ar_gta_trx_util.get_gtainvoice_amount(l_csldted_inv.trx_header.gta_trx_header_id);

734: --added by jixun for ER#16613351 begin
735: /*-------------------------------------------------------------------------------------
736: Get amount of each GTA Invoice to judge whether it is a Credit Memo or Positive Invoice
737: --------------------------------------------------------------------------------------*/
738: l_amount := ar_gta_trx_util.get_gtainvoice_amount(l_csldted_inv.trx_header.gta_trx_header_id);
739: --added by jixun for ER#16613351 end
740:
741: l_csldted_inv_lines:=l_csldted_inv.trx_lines;
742: l_csldted_inv_lines_index:=l_csldted_inv_lines.FIRST;

Line 1375: AR_GTA_TRX_UTIL.create_trx(l_csldtion_inv);

1371: :=l_csldtion_inv.trx_header.gta_trx_header_id;
1372: l_csldtion_inv_lines_index:= l_csldtion_inv.trx_lines.NEXT(l_csldtion_inv_lines_index);
1373: END LOOP;
1374: --create consolidation inv
1375: AR_GTA_TRX_UTIL.create_trx(l_csldtion_inv);
1376:
1377: l_csldted_invs_index:=l_csldted_invs.FIRST;
1378: WHILE l_csldted_invs_index IS NOT NULL
1379: LOOP