DBA Data[Home] [Help]

APPS.JMF_GTA_CONC_PROG dependencies on JMF_GTA_TRX_UTIL

Line 118: l_parameters jmf_gta_trx_util.transferparas_rec_type;

114: ,p_doc_num_from IN NUMBER
115: ,p_doc_num_to IN NUMBER
116: ) IS
117: l_procedure_name VARCHAR2(50) := 'transfer_AR_to_GTA';
118: l_parameters jmf_gta_trx_util.transferparas_rec_type;
119: l_jmf_gta_gta_not_enabled VARCHAR2(4000);
120: l_conc_succ BOOLEAN;
121: l_errbuf VARCHAR2(4000);
122: l_retcode VARCHAR2(4000);

Line 315: ,xmlforest(jmf_gta_trx_util.get_operatingunit(l_org_id) AS

311: l_gta_line_count := 0;
312: l_gt_line_count := 0;
313:
314: SELECT xmlelement("Parameters"
315: ,xmlforest(jmf_gta_trx_util.get_operatingunit(l_org_id) AS
316: "OperationUnit"
317: ,p_customer_name AS
318: "ARCustomerName"
319: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gl_date_from) AS

Line 319: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gl_date_from) AS

315: ,xmlforest(jmf_gta_trx_util.get_operatingunit(l_org_id) AS
316: "OperationUnit"
317: ,p_customer_name AS
318: "ARCustomerName"
319: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gl_date_from) AS
320: "ARTrxGLDateFrom"
321: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gl_date_to) AS
322: "ARTrxGLDateTo"))
323: INTO l_parameter

Line 321: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gl_date_to) AS

317: ,p_customer_name AS
318: "ARCustomerName"
319: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gl_date_from) AS
320: "ARTrxGLDateFrom"
321: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gl_date_to) AS
322: "ARTrxGLDateTo"))
323: INTO l_parameter
324: FROM dual;
325:

Line 343: ,jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))

339: ,'Y')
340: ,xmlelement("FailedWithParameters"
341: ,'N')
342: ,xmlelement("RepDate"
343: ,jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))
344: ,xmlelement("ReportFailedMsg"
345: ,l_jmf_gta_gta_not_enabled)
346: ,l_parameter))
347: INTO l_report

Line 350: jmf_gta_trx_util.output_conc(l_report.getclobval());

346: ,l_parameter))
347: INTO l_report
348: FROM dual;
349:
350: jmf_gta_trx_util.output_conc(l_report.getclobval());
351: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
352: ,message => l_jmf_gta_gta_not_enabled);
353: RETURN;
354: END IF; /*IF NVL(l_jmf_gta_enabled,'N')<>'Y'*/

Line 377: jmf_gta_trx_util.delete_header_line_cascade(p_gta_trx_header_id => l_gta_trx_header_id);

373: WHERE gta_trx_header_id = l_gta_trx_header_id;
374:
375: -- delete GTA and gt invoices inclunding headers and lines
376: -- according to GTA_TRX_HEADER_ID
377: jmf_gta_trx_util.delete_header_line_cascade(p_gta_trx_header_id => l_gta_trx_header_id);
378:
379: IF l_source = 'AR' --count deleted GTA transaction headers and lines
380: THEN
381: l_gta_header_count := l_gta_header_count + 1;

Line 414: ,jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))

410: ,'N')
411: ,xmlelement("FailedWithParameters"
412: ,'N')
413: ,xmlelement("RepDate"
414: ,jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))
415: ,l_parameter
416: ,l_summary))
417: INTO l_report
418: FROM dual;

Line 420: jmf_gta_trx_util.output_conc(l_report.getclobval());

416: ,l_summary))
417: INTO l_report
418: FROM dual;
419:
420: jmf_gta_trx_util.output_conc(l_report.getclobval());
421:
422: --logging for debug
423: IF (l_proc_level >= l_dbg_level)
424: THEN

Line 529: ,xmlforest(jmf_gta_trx_util.get_operatingunit(l_org_id)

525: IF nvl(l_jmf_gta_enabled
526: ,'N') = 'N'
527: THEN
528: SELECT xmlelement("Parameters"
529: ,xmlforest(jmf_gta_trx_util.get_operatingunit(l_org_id)
530: AS "OperationUnit"
531: ,p_fp_tax_reg_num
532: AS "TaxRegistrationNumber"
533: ,jmf_gta_trx_util.Get_AR_Batch_Source_Name

Line 533: ,jmf_gta_trx_util.Get_AR_Batch_Source_Name

529: ,xmlforest(jmf_gta_trx_util.get_operatingunit(l_org_id)
530: AS "OperationUnit"
531: ,p_fp_tax_reg_num
532: AS "TaxRegistrationNumber"
533: ,jmf_gta_trx_util.Get_AR_Batch_Source_Name
534: ( l_org_id
535: , p_trx_source)
536: AS "TransactionSource"
537: ,jmf_gta_trx_util.get_customer_name(p_customer_id)

Line 537: ,jmf_gta_trx_util.get_customer_name(p_customer_id)

533: ,jmf_gta_trx_util.Get_AR_Batch_Source_Name
534: ( l_org_id
535: , p_trx_source)
536: AS "TransactionSource"
537: ,jmf_gta_trx_util.get_customer_name(p_customer_id)
538: AS "ARCustomerName"
539: ,p_gt_inv_num_from
540: AS "GTInvoiceNumFrom"
541: ,p_gt_inv_num_to

Line 543: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_from)

539: ,p_gt_inv_num_from
540: AS "GTInvoiceNumFrom"
541: ,p_gt_inv_num_to
542: AS "GTInvoiceNumTo"
543: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_from)
544: AS "GTDateFrom"
545: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_to)
546: AS "GTDateTo"
547: ,p_ar_inv_num_from

Line 545: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_to)

541: ,p_gt_inv_num_to
542: AS "GTInvoiceNumTo"
543: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_from)
544: AS "GTDateFrom"
545: ,jmf_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_to)
546: AS "GTDateTo"
547: ,p_ar_inv_num_from
548: AS "ARTrxNumberFrom"
549: ,p_ar_inv_num_to

Line 551: ,jmf_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_from)

547: ,p_ar_inv_num_from
548: AS "ARTrxNumberFrom"
549: ,p_ar_inv_num_to
550: AS "ARTrxNumberTo"
551: ,jmf_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_from)
552: AS "ARTrxDateFrom"
553: ,jmf_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_to)
554: AS "ARTrxDateTo"))
555: INTO l_parameter

Line 553: ,jmf_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_to)

549: ,p_ar_inv_num_to
550: AS "ARTrxNumberTo"
551: ,jmf_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_from)
552: AS "ARTrxDateFrom"
553: ,jmf_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_to)
554: AS "ARTrxDateTo"))
555: INTO l_parameter
556: FROM dual;
557:

Line 569: ,jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))

565: ,'Y')
566: ,xmlelement("FailedWithParameters"
567: ,'N')
568: ,xmlelement("RepDate"
569: ,jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))
570: ,xmlelement("ReportFailedMsg"
571: ,l_jmf_gta_gta_not_enabled)
572: ,l_parameter))
573: INTO l_report

Line 576: jmf_gta_trx_util.output_conc(l_report.getclobval());

572: ,l_parameter))
573: INTO l_report
574: FROM dual;
575:
576: jmf_gta_trx_util.output_conc(l_report.getclobval());
577: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
578: ,message => l_jmf_gta_gta_not_enabled);
579: ELSE
580: NULL;