APPS.JMF_GTA_REPORTS_PKG dependencies on DUAL

Line 628: dual;

624: , Xmlconcat(L_Ar_Trx,L_Gt_Invoices)))
625: INTO
626: l_ar_trxs
627: FROM
628: dual;
629:
630: FETCH C_Trx_Ids INTO L_Ar_Trx_Id;
631: END LOOP;
632:

Line 663: FROM DUAL;

659: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"
660: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))
661: INTO
662: l_Parameter
663: FROM DUAL;
664:
665: --Generate Summary Section
666: SELECT
667: Xmlelement("Summary", Xmlforest

Line 675: DUAL;

671: )
672: INTO
673: L_Summary
674: FROM
675: DUAL;
676:
677: --Generate Golden Tax Currency Section
678: OPEN C_cur;
679: FETCH C_cur INTO l_gt_cur;

Line 687: DUAL;

683: Xmlelement("RepCurr", l_gt_cur)
684: INTO
685: L_gt_currency
686: FROM
687: DUAL;
688:
689: --Generate Reports Xml Data
690: IF l_no_data_flag='Y'
691: THEN

Line 705: DUAL;

701: ))
702: INTO
703: L_Report
704: FROM
705: DUAL;
706: ELSE
707:
708: SELECT Xmlelement( "MappingReport", Xmlconcat
709: ( Xmlelement("ReportFailed",'N')

Line 720: DUAL;

716: ))
717: INTO
718: L_Report
719: FROM
720: DUAL;
721: END IF;
722:
723: jmf_gta_trx_util.output_conc(L_Report.Getclobval());
724:

Line 1587: dual;

1583: )
1584: INTO
1585: l_ar_customer_bank_account_m
1586: FROM
1587: dual;
1588: ELSE
1589: l_ar_customer_bank_account_m:='';
1590: END IF; --l_ar_customer_bank_account IS NOT NULL
1591:

Line 1612: dual;

1608: )
1609: INTO
1610: l_gta_customer_bank_account_m
1611: FROM
1612: dual;
1613: ELSE
1614: l_gta_customer_bank_account_m:='';
1615: END IF; --l_gta_customer_bank_account IS NOT NULL
1616:

Line 1636: dual;

1632: )
1633: INTO
1634: l_gt_customer_bank_account_m
1635: FROM
1636: dual;
1637: ELSE
1638: l_gt_customer_bank_account_m:='';
1639: END IF; --l_gt_customer_bank_account IS NOT NULL
1640:

Line 4067: FROM dual;

4063: ,l_primary_sales_name AS "PrimarySalesPerson"
4064: )
4065: INTO
4066: l_parameter_xml
4067: FROM dual;
4068:
4069: --To calculate total number of AR transactions that have discrepancy
4070: OPEN c_ar_diff_count;
4071: FETCH c_ar_diff_count INTO l_ar_diff_count;

Line 4099: dual;

4095: )
4096: INTO
4097: l_report_xml
4098: FROM
4099: dual;
4100:
4101: ELSE
4102: --
4103: --Generate xml for summary section

Line 4134: dual;

4130: )
4131: INTO
4132: l_summary_xml
4133: FROM
4134: dual;
4135:
4136: --To get base currency
4137: OPEN c_base_currency;
4138: FETCH c_base_currency INTO l_base_currency;

Line 4167: dual;

4163: )
4164: INTO
4165: l_gta_header_xml
4166: FROM
4167: dual;
4168: END IF; --l_gta_header_xml IS NULL
4169: FETCH c_gta_header_xml INTO l_gta_header_xml_tmp;
4170: END LOOP; --c_gta_header_xml%FOUND
4171: CLOSE c_gta_header_xml;

Line 4194: dual;

4190: )
4191: INTO
4192: l_gta_line_xml
4193: FROM
4194: dual;
4195: END IF; --l_gta_line_xml IS NULL
4196: FETCH c_gta_line_xml INTO l_gta_line_xml_tmp;
4197: END LOOP; --c_gta_line_xml%FOUND
4198: CLOSE c_gta_line_xml;

Line 4220: dual;

4216: )
4217: INTO
4218: l_missing_line_xml
4219: FROM
4220: dual;
4221: END IF; --l_missing_line_xml IS NULL
4222: FETCH c_missing_line_xml INTO l_missing_line_xml_tmp;
4223: END LOOP; --c_missing_line_xml%FOUND
4224: CLOSE c_missing_line_xml;

Line 4246: dual;

4242: )
4243: INTO
4244: l_unmatched_line_xml
4245: FROM
4246: dual;
4247: END IF; --l_unmatched_line_xml IS NULL
4248: FETCH c_unmatched_line_xml INTO l_unmatched_line_xml_tmp;
4249: END LOOP; --c_unmatched_line_xml%FOUND
4250: CLOSE c_unmatched_line_xml;

Line 4273: dual;

4269: )
4270: )
4271: INTO l_ar_invoice_xml_tmp
4272: FROM
4273: dual;
4274:
4275: IF l_ar_invoice_xml IS NULL
4276: THEN
4277: l_ar_invoice_xml:=l_ar_invoice_xml_tmp;

Line 4285: FROM dual;

4281: ,l_ar_invoice_xml_tmp
4282: )
4283: INTO
4284: l_ar_invoice_xml
4285: FROM dual;
4286: END IF; --l_ar_invoice_xml IS NULL
4287: FETCH c_ar_difference INTO l_ar_difference;
4288: END LOOP; --c_ar_difference%found
4289: CLOSE c_ar_difference;

Line 4308: dual;

4304: )
4305: INTO
4306: l_missing_artrx_xml
4307: FROM
4308: dual;
4309: END IF;--l_missing_artrx_xml IS NULL
4310:
4311: FETCH c_missing_artrx_xml INTO l_missing_artrx_xml_tmp;
4312: END LOOP;--c_missing_artrx_xml%FOUND

Line 4331: dual;

4327: )
4328: INTO
4329: l_report_xml
4330: FROM
4331: dual;
4332: END IF; -- (l_ar_diff_count=0) AND (l_missing_artrx_count=0)
4333:
4334:
4335: