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_REPORTS_PKG dependencies on AR_GTA_TRX_UTIL

Line 232: IF AR_Gta_Trx_Util.Check_Taxcount_Of_Artrx(P_Org_Id, p_ar_trx_header_id)

228: , G_MODULE_PREFIX||l_procedure_name||'.begin'
229: , 'enter function'
230: );
231: END IF;
232: IF AR_Gta_Trx_Util.Check_Taxcount_Of_Artrx(P_Org_Id, p_ar_trx_header_id)
233: THEN
234:
235: SELECT Xmlforest(
236: ract.Trx_Number AS "ARInvoiceNo"

Line 253: ,ar_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"

249: -----------------------------------------------------------------
250: ,al.meaning AS "ARClass"
251: --,CTT.TYPE AS "ARClass"
252: ------------------------------------------------------------------
253: ,ar_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"
254: ,RAC_BILL_PARTY.PARTY_NAME AS "ARCustomer"
255: ,AR_Gta_Trx_Util.Get_Arinvoice_Amount
256: ( P_Org_Id
257: , ract.Customer_Trx_Id

Line 255: ,AR_Gta_Trx_Util.Get_Arinvoice_Amount

251: --,CTT.TYPE AS "ARClass"
252: ------------------------------------------------------------------
253: ,ar_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"
254: ,RAC_BILL_PARTY.PARTY_NAME AS "ARCustomer"
255: ,AR_Gta_Trx_Util.Get_Arinvoice_Amount
256: ( P_Org_Id
257: , ract.Customer_Trx_Id
258: ) AS "ARAmount"
259: ,AR_Gta_Trx_Util.Get_Arinvoice_Tax_Amount

Line 259: ,AR_Gta_Trx_Util.Get_Arinvoice_Tax_Amount

255: ,AR_Gta_Trx_Util.Get_Arinvoice_Amount
256: ( P_Org_Id
257: , ract.Customer_Trx_Id
258: ) AS "ARAmount"
259: ,AR_Gta_Trx_Util.Get_Arinvoice_Tax_Amount
260: ( P_Org_Id
261: , ract.Customer_Trx_Id
262: ) AS "ARTaxAmount"
263: ,AR_Gta_Trx_Util.Get_Arinvoice_Amount

Line 263: ,AR_Gta_Trx_Util.Get_Arinvoice_Amount

259: ,AR_Gta_Trx_Util.Get_Arinvoice_Tax_Amount
260: ( P_Org_Id
261: , ract.Customer_Trx_Id
262: ) AS "ARTaxAmount"
263: ,AR_Gta_Trx_Util.Get_Arinvoice_Amount
264: ( P_Org_Id
265: , ract.Customer_Trx_Id
266: )
267: +AR_Gta_Trx_Util.Get_Arinvoice_Tax_Amount

Line 267: +AR_Gta_Trx_Util.Get_Arinvoice_Tax_Amount

263: ,AR_Gta_Trx_Util.Get_Arinvoice_Amount
264: ( P_Org_Id
265: , ract.Customer_Trx_Id
266: )
267: +AR_Gta_Trx_Util.Get_Arinvoice_Tax_Amount
268: ( P_Org_Id
269: , ract.Customer_Trx_Id
270: ) AS "ARTotalAmount"
271: )

Line 321: ,ar_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"

317: -----------------------------------------------------------------
318: --,CTT.TYPE AS "ARClass"
319: ,al.meaning AS "ARClass"
320: -----------------------------------------------------------------
321: ,ar_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"
322: ,RAC_BILL_PARTY.PARTY_NAME AS "ARCustomer"
323: ,'' AS "ARAmount"
324: ,'' AS "ARTaxAmount"
325: ,'' AS "ARTotalAmount"

Line 457: , ar_gta_trx_util.To_Xsd_Date_String(Gt_Invoice_Date) AS "Date"

453: SELECT Xmlelement("GTInvoices",
454: Xmlconcat(Xmlelement("Count",l_count)
455: , Xmlagg(Xmlelement("GTInvoice",Xmlforest
456: ( Gt_Invoice_Number AS "InvoiceNo"
457: , ar_gta_trx_util.To_Xsd_Date_String(Gt_Invoice_Date) AS "Date"
458: , Bill_To_Customer_Name AS "Customer"
459: , Gt_Invoice_Net_Amount AS "Amount"
460: , Gt_Invoice_Tax_Amount AS "TaxAmount"
461: , Gt_Invoice_Net_Amount + Gt_Invoice_Tax_Amount AS "TotalAmount"

Line 711: ( ar_gta_trx_util.Get_OperatingUnit(P_Org_Id) AS "OperationUnit"

707:
708: --Generate Parameter Section
709: SELECT
710: Xmlelement("Parameters",Xmlforest
711: ( ar_gta_trx_util.Get_OperatingUnit(P_Org_Id) AS "OperationUnit"
712: , p_fp_tax_reg_num AS "TaxRegistrationNumber"
713: , ar_gta_trx_util.Get_AR_Batch_Source_Name
714: ( P_Org_Id
715: , P_Trx_Source) AS "TransactionSource"

Line 713: , ar_gta_trx_util.Get_AR_Batch_Source_Name

709: SELECT
710: Xmlelement("Parameters",Xmlforest
711: ( ar_gta_trx_util.Get_OperatingUnit(P_Org_Id) AS "OperationUnit"
712: , p_fp_tax_reg_num AS "TaxRegistrationNumber"
713: , ar_gta_trx_util.Get_AR_Batch_Source_Name
714: ( P_Org_Id
715: , P_Trx_Source) AS "TransactionSource"
716: , ar_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"
717: , P_Gt_Inv_Num_From AS "GTInvoiceNumFrom"

Line 716: , ar_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"

712: , p_fp_tax_reg_num AS "TaxRegistrationNumber"
713: , ar_gta_trx_util.Get_AR_Batch_Source_Name
714: ( P_Org_Id
715: , P_Trx_Source) AS "TransactionSource"
716: , ar_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"
717: , P_Gt_Inv_Num_From AS "GTInvoiceNumFrom"
718: , P_Gt_Inv_Num_To AS "GTInvoiceNumTo"
719: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"
720: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"

Line 719: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"

715: , P_Trx_Source) AS "TransactionSource"
716: , ar_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"
717: , P_Gt_Inv_Num_From AS "GTInvoiceNumFrom"
718: , P_Gt_Inv_Num_To AS "GTInvoiceNumTo"
719: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"
720: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"
721: , P_Ar_Inv_Num_From AS "ARTrxNumberFrom"
722: , P_Ar_Inv_Num_To AS "ARTrxNumberTo"
723: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"

Line 720: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"

716: , ar_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"
717: , P_Gt_Inv_Num_From AS "GTInvoiceNumFrom"
718: , P_Gt_Inv_Num_To AS "GTInvoiceNumTo"
719: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"
720: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"
721: , P_Ar_Inv_Num_From AS "ARTrxNumberFrom"
722: , P_Ar_Inv_Num_To AS "ARTrxNumberTo"
723: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"
724: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))

Line 723: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"

719: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"
720: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"
721: , P_Ar_Inv_Num_From AS "ARTrxNumberFrom"
722: , P_Ar_Inv_Num_To AS "ARTrxNumberTo"
723: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"
724: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))
725: INTO
726: l_Parameter
727: FROM DUAL;

Line 724: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))

720: , ar_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"
721: , P_Ar_Inv_Num_From AS "ARTrxNumberFrom"
722: , P_Ar_Inv_Num_To AS "ARTrxNumberTo"
723: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"
724: , ar_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))
725: INTO
726: l_Parameter
727: FROM DUAL;
728:

Line 763: , Xmlelement("RepDate",ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))

759: SELECT Xmlelement( "MappingReport", Xmlconcat
760: ( Xmlelement("ReportFailed",'N')
761: , Xmlelement("FailedWithParameters",'Y')
762: , Xmlelement("FailedMsgWithParameters",l_no_data_message)
763: , Xmlelement("RepDate",ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
764: , L_Parameter
765: ))
766: INTO
767: L_Report

Line 775: , Xmlelement("RepDate",ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))

771:
772: SELECT Xmlelement( "MappingReport", Xmlconcat
773: ( Xmlelement("ReportFailed",'N')
774: , Xmlelement("FailedWithParameters",'N')
775: , Xmlelement("RepDate",ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
776: , L_Parameter
777: , L_Summary
778: , L_gt_currency
779: , xmlelement("Invoices",l_ar_trxs)

Line 787: ar_gta_trx_util.output_conc(L_Report.Getclobval());

783: FROM
784: DUAL;
785: END IF;
786:
787: ar_gta_trx_util.output_conc(L_Report.Getclobval());
788:
789: --logging for debug
790: IF (l_proc_level>=l_dbg_level)
791: THEN

Line 935: /*AR_GTA_TRX_UTIL.Get_Arinvoice_Amount(rct.customer_trx_id

931:
932: CURSOR c_ar_header IS
933: SELECT
934: --commented by Donghai due to ebtax functionality
935: /*AR_GTA_TRX_UTIL.Get_Arinvoice_Amount(rct.customer_trx_id
936: ,rct.invoice_currency_code
937: ,rct.trx_date
938: ,l_org_id) amount
939: , AR_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount(rct.customer_trx_id

Line 939: , AR_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount(rct.customer_trx_id

935: /*AR_GTA_TRX_UTIL.Get_Arinvoice_Amount(rct.customer_trx_id
936: ,rct.invoice_currency_code
937: ,rct.trx_date
938: ,l_org_id) amount
939: , AR_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount(rct.customer_trx_id
940: ,rct.invoice_currency_code
941: ,rct.trx_date
942: ,l_org_id) tax_amount*/
943: rct.bill_to_customer_id

Line 992: /*AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)

988:
989: -- Commented by Allen to fix issue #2 in bug 6147067
990: CURSOR c_gta_headers IS
991: SELECT
992: /*AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
993: amount
994: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
995: taxamount,
996: */

Line 994: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)

990: CURSOR c_gta_headers IS
991: SELECT
992: /*AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
993: amount
994: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
995: taxamount,
996: */
997: gta.bill_to_customer_name
998: customer_name

Line 1021: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gt.gta_trx_header_id)

1017:
1018:
1019: CURSOR c_gt_headers IS
1020: SELECT
1021: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gt.gta_trx_header_id)
1022: amount
1023: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gt.gta_trx_header_id)
1024: taxamount
1025: , gt.bill_to_customer_name

Line 1023: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gt.gta_trx_header_id)

1019: CURSOR c_gt_headers IS
1020: SELECT
1021: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gt.gta_trx_header_id)
1022: amount
1023: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gt.gta_trx_header_id)
1024: taxamount
1025: , gt.bill_to_customer_name
1026: customer_name
1027: , gt.tp_tax_registration_number

Line 1048: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)

1044:
1045: --This cursor is added by Allen to fix issue #2 in bug 6147067.
1046: CURSOR c_gta_amounts IS
1047: SELECT
1048: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
1049: amount
1050: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
1051: taxamount
1052: , gta.gta_trx_number

Line 1050: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)

1046: CURSOR c_gta_amounts IS
1047: SELECT
1048: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
1049: amount
1050: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
1051: taxamount
1052: , gta.gta_trx_number
1053: FROM
1054: ar_gta_trx_headers gta

Line 1221: IF AR_GTA_TRX_UTIL.Check_Taxcount_Of_Artrx

1217: --lines per GT currency code and VAT tax type defined on GTA 'system
1218: --options form.If 'Yes', then will set NULL to the variables, if 'No',
1219: --then return exact taxable amount and tax amount
1220:
1221: IF AR_GTA_TRX_UTIL.Check_Taxcount_Of_Artrx
1222: (p_org_id => l_org_id
1223: ,p_customer_trx_id => l_ar_header_id
1224: )
1225: THEN

Line 1226: l_ar_amount:=AR_GTA_TRX_UTIL.Get_Arinvoice_Amount

1222: (p_org_id => l_org_id
1223: ,p_customer_trx_id => l_ar_header_id
1224: )
1225: THEN
1226: l_ar_amount:=AR_GTA_TRX_UTIL.Get_Arinvoice_Amount
1227: (p_org_id => l_org_id
1228: ,p_customer_trx_id => l_ar_header_id
1229: );
1230:

Line 1231: l_ar_taxamount:=AR_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount

1227: (p_org_id => l_org_id
1228: ,p_customer_trx_id => l_ar_header_id
1229: );
1230:
1231: l_ar_taxamount:=AR_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount
1232: (p_org_id => l_org_id
1233: ,p_customer_trx_id => l_ar_header_id
1234: );
1235: ELSE

Line 1238: END IF; --AR_GTA_TRX_UTIL.Check_Taxcount_Of_Artrx.....

1234: );
1235: ELSE
1236: l_ar_amount:='';
1237: l_ar_taxamount:='';
1238: END IF; --AR_GTA_TRX_UTIL.Check_Taxcount_Of_Artrx.....
1239:
1240: --log for debug
1241: IF( l_proc_level >= l_dbg_level)
1242: THEN

Line 1260: AR_GTA_TRX_UTIL.Get_Bank_Info

1256:
1257:
1258:
1259: --Get Bank account name and number of a specific AR transaction
1260: AR_GTA_TRX_UTIL.Get_Bank_Info
1261: (p_customer_trx_id => l_ar_header_id
1262: ,p_org_id => l_org_id
1263: ,x_bank_name => l_ar_bank_name
1264: ,x_bank_branch_name => l_ar_branch_name

Line 1272: l_ar_customer_phone:=AR_GTA_TRX_UTIL.Get_Primary_Phone_Number

1268: l_ar_customer_bank_account:=l_ar_bank_name||' '||
1269: l_ar_branch_name||' '||l_ar_bank_account_num;
1270:
1271:
1272: l_ar_customer_phone:=AR_GTA_TRX_UTIL.Get_Primary_Phone_Number
1273: (p_customer_id => l_ar_customer_id
1274: );
1275:
1276:

Line 1940: l_amount_discrepancy:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1936: THEN
1937: l_amount_discrepancy:='-';
1938: ELSE
1939: --To compute discrepancy of amount (GT-AR)
1940: l_amount_discrepancy:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1941: ,p_amount => l_gt_amount_sum-l_ar_amount
1942: );
1943: END IF; --l_ar_amount IS NULL
1944:

Line 1946: l_ar_amount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1942: );
1943: END IF; --l_ar_amount IS NULL
1944:
1945: --Format Amount
1946: l_ar_amount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1947: ,p_amount => l_ar_amount
1948: );
1949:
1950: l_gta_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

Line 1950: l_gta_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1946: l_ar_amount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1947: ,p_amount => l_ar_amount
1948: );
1949:
1950: l_gta_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1951: ,p_amount => l_gta_amount_sum
1952: );
1953:
1954: l_gt_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

Line 1954: l_gt_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1950: l_gta_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1951: ,p_amount => l_gta_amount_sum
1952: );
1953:
1954: l_gt_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1955: ,p_amount =>l_gt_amount_sum
1956: );
1957:
1958: --Insert this discrepancy record to temp table ar_gta_difference_temp

Line 1993: l_taxamount_discrepancy:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1989: THEN
1990: l_taxamount_discrepancy:='-';
1991: ELSE
1992: --To compute discrepancy of tax amount (GT-AR)
1993: l_taxamount_discrepancy:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1994: ,p_amount => l_gt_taxamount_sum-l_ar_taxamount
1995: );
1996: END IF; -- l_ar_taxamount IS NULL
1997:

Line 1999: l_ar_taxamount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1995: );
1996: END IF; -- l_ar_taxamount IS NULL
1997:
1998: --Format Amount
1999: l_ar_taxamount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2000: ,p_amount => l_ar_taxamount
2001: );
2002:
2003: l_gta_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

Line 2003: l_gta_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1999: l_ar_taxamount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2000: ,p_amount => l_ar_taxamount
2001: );
2002:
2003: l_gta_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2004: ,p_amount => l_gta_taxamount_sum
2005: );
2006:
2007: l_gt_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

Line 2007: l_gt_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

2003: l_gta_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2004: ,p_amount => l_gta_taxamount_sum
2005: );
2006:
2007: l_gt_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2008: ,p_amount => l_gt_taxamount_sum
2009: );
2010:
2011:

Line 2626: IF AR_GTA_TRX_UTIL.Check_Taxcount_Of_Arline

2622: --type and GT currency code defined on GTA 'system options' form,
2623: --if 'YES', then set NULL to tax registration number,taxable amount,
2624: --tax amount and tax rate, if 'No', then give exact values to tax
2625: --registration number, taxable amount,tax amount and tax rate.
2626: IF AR_GTA_TRX_UTIL.Check_Taxcount_Of_Arline
2627: (p_org_id => l_org_id
2628: ,p_customer_trx_line_id => l_ar_line_id
2629: )
2630: THEN

Line 2632: l_ar_tax_reg_number:=AR_GTA_TRX_UTIL.Get_Arline_Tp_Taxreg_Number

2628: ,p_customer_trx_line_id => l_ar_line_id
2629: )
2630: THEN
2631: --Third party tax registration number
2632: l_ar_tax_reg_number:=AR_GTA_TRX_UTIL.Get_Arline_Tp_Taxreg_Number
2633: (p_org_id => l_org_id
2634: ,p_customer_trx_id => l_ar_header_id
2635: ,p_customer_trx_line_id => l_ar_line_id
2636: );

Line 2638: l_ar_line_amount:=AR_GTA_TRX_UTIL.Get_Arline_Amount

2634: ,p_customer_trx_id => l_ar_header_id
2635: ,p_customer_trx_line_id => l_ar_line_id
2636: );
2637: --taxable amount of AR line
2638: l_ar_line_amount:=AR_GTA_TRX_UTIL.Get_Arline_Amount
2639: (p_org_id => l_org_id
2640: ,p_customer_trx_line_id => l_ar_line_id
2641: )+ nvl(l_discount_amount,0);
2642: --tax amount of AR line

Line 2643: l_ar_vat_line_tax:=AR_GTA_TRX_UTIL.Get_Arline_Vattax_Amount

2639: (p_org_id => l_org_id
2640: ,p_customer_trx_line_id => l_ar_line_id
2641: )+ nvl(l_discount_amount,0);
2642: --tax amount of AR line
2643: l_ar_vat_line_tax:=AR_GTA_TRX_UTIL.Get_Arline_Vattax_Amount
2644: (p_org_id => l_org_id
2645: ,p_customer_trx_line_id => l_ar_line_id
2646: )+nvl(l_discount_tax_amount,0);
2647: --tax rate of AR line

Line 2648: l_ar_vat_tax_rate:=AR_GTA_TRX_UTIL.Get_Arline_Vattax_Rate

2644: (p_org_id => l_org_id
2645: ,p_customer_trx_line_id => l_ar_line_id
2646: )+nvl(l_discount_tax_amount,0);
2647: --tax rate of AR line
2648: l_ar_vat_tax_rate:=AR_GTA_TRX_UTIL.Get_Arline_Vattax_Rate
2649: (p_org_id => l_org_id
2650: ,p_customer_trx_line_id => l_ar_line_id
2651: );
2652:

Line 2658: END IF; --AR_GTA_TRX_UTIL.Check_Taxcount_Of_Arline

2654: l_ar_tax_reg_number:='';
2655: l_ar_line_amount:='';
2656: l_ar_vat_line_tax:='';
2657: l_ar_vat_tax_rate:='';
2658: END IF; --AR_GTA_TRX_UTIL.Check_Taxcount_Of_Arline
2659:
2660: --log for debug
2661: IF( l_proc_level >= l_dbg_level)
2662: THEN

Line 3045: l_gt_value:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3041: IF (l_ar_unit_price<>l_gta_unit_price)
3042: THEN
3043: IF (l_matched_flag='Y')
3044: THEN
3045: l_gt_value:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3046: ,p_amount => l_gta_unit_price
3047: );
3048: ELSE
3049: l_gt_invoice_number:='-';

Line 3054: l_ar_unit_price_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3050: --l_gt_value:=l_unmatched_attr;
3051: END IF; --(l_matched_flag='Y')
3052:
3053: --Fomrat Amount
3054: l_ar_unit_price_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3055: ,p_amount => l_ar_unit_price
3056: );
3057: l_gta_unit_price_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3058: ,p_amount => l_gta_unit_price

Line 3057: l_gta_unit_price_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3053: --Fomrat Amount
3054: l_ar_unit_price_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3055: ,p_amount => l_ar_unit_price
3056: );
3057: l_gta_unit_price_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3058: ,p_amount => l_gta_unit_price
3059: );
3060:
3061: --insert discrepancy record into temp table ar_gta_difference_temp

Line 3226: l_gt_value:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3222: THEN
3223: IF (l_matched_flag_total='Y')
3224: THEN
3225: l_gt_invoice_number:=l_gt_invoice_number_con;
3226: l_gt_value:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3227: ,p_amount => l_gta_line_amount_sum
3228: );
3229:
3230: ELSE

Line 3236: l_ar_line_amount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3232: -- l_gt_value:=l_unmatched_attr;
3233: END IF; --(l_matched_flag_sum='Y')
3234:
3235: --Format Amount
3236: l_ar_line_amount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3237: ,p_amount => l_ar_line_amount
3238: );
3239: l_gta_line_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3240: ,p_amount => l_gta_line_amount_sum

Line 3239: l_gta_line_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3235: --Format Amount
3236: l_ar_line_amount_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3237: ,p_amount => l_ar_line_amount
3238: );
3239: l_gta_line_amount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3240: ,p_amount => l_gta_line_amount_sum
3241: );
3242:
3243: --insert discrepancy record into temp table ar_gta_difference_temp

Line 3293: l_gt_value:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3289: THEN
3290: IF (l_matched_flag_total='Y')
3291: THEN
3292: l_gt_invoice_number:=l_gt_invoice_number_con;
3293: l_gt_value:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3294: ,p_amount => l_gta_line_taxamount_sum
3295: );
3296:
3297: ELSE

Line 3303: l_ar_vat_line_tax_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3299: --l_gt_value:=l_unmatched_attr;
3300: END IF; --(l_matched_flag_sum='Y')
3301:
3302: --Format Amount
3303: l_ar_vat_line_tax_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3304: ,p_amount => l_ar_vat_line_tax
3305: );
3306: l_gta_line_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3307: ,p_amount => l_gta_line_taxamount_sum

Line 3306: l_gta_line_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3302: --Format Amount
3303: l_ar_vat_line_tax_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3304: ,p_amount => l_ar_vat_line_tax
3305: );
3306: l_gta_line_taxamount_sum_disp:=AR_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3307: ,p_amount => l_gta_line_taxamount_sum
3308: );
3309:
3310: --insert discrepancy record into temp table ar_gta_difference_temp

Line 4219: l_gl_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);

4215: CLOSE c_primary_salesrep_name;
4216:
4217: --Bug 5521629
4218: --Format date to XSD Date format
4219: l_gl_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4220: l_gl_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4221: l_ar_trx_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4222: l_ar_trx_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4223: l_report_date:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);

Line 4220: l_gl_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);

4216:
4217: --Bug 5521629
4218: --Format date to XSD Date format
4219: l_gl_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4220: l_gl_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4221: l_ar_trx_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4222: l_ar_trx_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4223: l_report_date:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);
4224:

Line 4221: l_ar_trx_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);

4217: --Bug 5521629
4218: --Format date to XSD Date format
4219: l_gl_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4220: l_gl_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4221: l_ar_trx_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4222: l_ar_trx_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4223: l_report_date:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);
4224:
4225: --generate xml elements for Parameters

Line 4222: l_ar_trx_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);

4218: --Format date to XSD Date format
4219: l_gl_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4220: l_gl_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4221: l_ar_trx_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4222: l_ar_trx_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4223: l_report_date:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);
4224:
4225: --generate xml elements for Parameters
4226: SELECT

Line 4223: l_report_date:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);

4219: l_gl_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4220: l_gl_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4221: l_ar_trx_date_from_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4222: l_ar_trx_date_to_f:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4223: l_report_date:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);
4224:
4225: --generate xml elements for Parameters
4226: SELECT
4227: xmlforest( l_operating_unit AS "OperationUnit"

Line 4460: l_ar_trx_date:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(l_ar_difference.trx_date);

4456:
4457:
4458: --Bug 5521629
4459: --Format date to XSD Date formate
4460: l_ar_trx_date:=AR_GTA_TRX_UTIL.To_Xsd_Date_String(l_ar_difference.trx_date);
4461: SELECT
4462: XMLELEMENT("Invoice"
4463: ,XMLFOREST
4464: (l_ar_difference.trx_number AS "ARInvoiceNo"

Line 5045: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount

5041: END IF; -- l_gt_invoice_number_missing IS NULL
5042:
5043:
5044: l_gt_invoice_amount_missing :=l_gt_invoice_amount_missing +
5045: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount
5046: (l_missing_artrx_rec.gta_trx_header_id
5047: );
5048:
5049: FETCH c_missing_artrx INTO l_missing_artrx_rec;

Line 5201: AR_GTA_TRX_UTIL.Output_Conc(l_xml_output.Getclobval);

5197:
5198: --Output xml script
5199:
5200: FND_FILE.Put_Line(FND_FILE.Output,'');
5201: AR_GTA_TRX_UTIL.Output_Conc(l_xml_output.Getclobval);
5202:
5203: --Logging for debug
5204:
5205: IF (l_proc_level>=l_dbg_level)

Line 5433: , Xmlforest( ar_gta_trx_util.Get_OperatingUnit(p_org_id)

5429:
5430: --Generate Parameter Section
5431: SELECT
5432: Xmlelement("Parameters"
5433: , Xmlforest( ar_gta_trx_util.Get_OperatingUnit(p_org_id)
5434: AS "OperationUnit"
5435: , p_gl_period AS "GLPeriod"
5436: , p_customer_num_from AS "CustNumFrom"
5437: , p_customer_num_to AS "CustNumTo"

Line 5462: , ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))

5458: , Xmlelement("FailedWithParameters",'Y')
5459: , Xmlelement("FailedMsgWithParameters"
5460: , l_no_data_message)
5461: , Xmlelement("RepDate"
5462: , ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
5463: , l_parameter))
5464: INTO
5465: l_report
5466: FROM DUAL;

Line 5472: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))

5468: SELECT Xmlelement("ConsolidationMappingReport"
5469: , Xmlconcat(Xmlelement("ReportFailed",'N')
5470: , Xmlelement("FailedWithParameters",'N')
5471: , Xmlelement("RepDate"
5472: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
5473: , l_parameter
5474: , xmlelement("Invoices", l_consolidation_trxs)))
5475: INTO
5476: l_report

Line 5480: ar_gta_trx_util.output_conc(l_report.getclobval());

5476: l_report
5477: FROM DUAL;
5478: END IF; --l_no_data_flag='Y'
5479:
5480: ar_gta_trx_util.output_conc(l_report.getclobval());
5481:
5482: --logging for debug
5483: IF (l_proc_level>=l_dbg_level)
5484: THEN

Line 5561: --, ar_gta_trx_util.Get_Gtainvoice_Amount(p_header_id =>

5557: , INVOICE_TYPE AS "InvoiceType"
5558: , BANK_ACCOUNT_NAME AS "BankName"
5559: , BANK_ACCOUNT_NUMBER AS "BankAccountNum"
5560: -- modified by Allen Yang 25-Aug-2009 for bug 8809860
5561: --, ar_gta_trx_util.Get_Gtainvoice_Amount(p_header_id =>
5562: -- p_trx_header_id) AS "Amount")
5563: , ar_gta_trx_util.Get_Gtainvoice_Amount(p_trx_header_id) AS "Amount")
5564: -- end modified by Allen
5565: INTO

Line 5563: , ar_gta_trx_util.Get_Gtainvoice_Amount(p_trx_header_id) AS "Amount")

5559: , BANK_ACCOUNT_NUMBER AS "BankAccountNum"
5560: -- modified by Allen Yang 25-Aug-2009 for bug 8809860
5561: --, ar_gta_trx_util.Get_Gtainvoice_Amount(p_header_id =>
5562: -- p_trx_header_id) AS "Amount")
5563: , ar_gta_trx_util.Get_Gtainvoice_Amount(p_trx_header_id) AS "Amount")
5564: -- end modified by Allen
5565: INTO
5566: l_ret_xmlelement
5567: FROM AR_GTA_TRX_HEADERS_ALL

Line 5580: --, ar_gta_trx_util.Get_Gtainvoice_Amount(p_header_id =>

5576: , FLTV.MEANING AS "InvoiceType"
5577: , JGTHA.BANK_ACCOUNT_NAME AS "BankName"
5578: , JGTHA.BANK_ACCOUNT_NUMBER AS "BankAccountNum"
5579: -- modified by Allen Yang 25-Aug-2009 for bug 8809860
5580: --, ar_gta_trx_util.Get_Gtainvoice_Amount(p_header_id =>
5581: -- p_trx_header_id) AS "Amount")
5582: , ar_gta_trx_util.Get_Gtainvoice_Amount(p_trx_header_id) AS "Amount")
5583: -- end modified by Allen
5584: INTO

Line 5582: , ar_gta_trx_util.Get_Gtainvoice_Amount(p_trx_header_id) AS "Amount")

5578: , JGTHA.BANK_ACCOUNT_NUMBER AS "BankAccountNum"
5579: -- modified by Allen Yang 25-Aug-2009 for bug 8809860
5580: --, ar_gta_trx_util.Get_Gtainvoice_Amount(p_header_id =>
5581: -- p_trx_header_id) AS "Amount")
5582: , ar_gta_trx_util.Get_Gtainvoice_Amount(p_trx_header_id) AS "Amount")
5583: -- end modified by Allen
5584: INTO
5585: l_ret_xmlelement
5586: FROM AR_GTA_TRX_HEADERS_ALL JGTHA

Line 5666: ,ar_gta_trx_util.Get_Gtainvoice_Amount

5662: ,Xmlforest(jgtha.RA_GL_PERIOD AS "ConsolidatedGLPeriod"
5663: ,jgtha.GTA_TRX_NUMBER AS "ConsolidatedTrxNum"
5664: ,jgtha.RA_TRX_NUMBER AS "ARTrxNum"
5665: ,rctt.NAME AS "ARTrxType"
5666: ,ar_gta_trx_util.Get_Gtainvoice_Amount
5667: -- modified by Allen Yang 25-Aug-2009 for bug 8809860
5668: --(p_header_id =>p_trx_header_id)
5669: (jgtha.GTA_TRX_HEADER_ID)
5670: -- end modified by Allen

Line 5773: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)

5769:
5770:
5771: CURSOR c_gta_headers IS
5772: SELECT
5773: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
5774: amount
5775: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
5776: taxamount
5777: , gta.bill_to_customer_name

Line 5775: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)

5771: CURSOR c_gta_headers IS
5772: SELECT
5773: AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
5774: amount
5775: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
5776: taxamount
5777: , gta.bill_to_customer_name
5778: customer_name
5779: , gta.tp_tax_registration_number

Line 5795: SELECT ar_gta_trx_util.get_gtainvoice_amount(gt.gta_trx_header_id) amount,

5791: AND gta.invoice_type = lk.lookup_code
5792: AND lk.lookup_type='AR_GTA_INVOICE_TYPE';
5793:
5794: CURSOR c_gt_headers IS
5795: SELECT ar_gta_trx_util.get_gtainvoice_amount(gt.gta_trx_header_id) amount,
5796: ar_gta_trx_util.get_gtainvoice_tax_amount(gt.gta_trx_header_id) taxamount,
5797: gt.bill_to_customer_name customer_name,
5798: gt.tp_tax_registration_number tax_registration_number,
5799: gt.bank_account_name_number customer_bank_account,

Line 5796: ar_gta_trx_util.get_gtainvoice_tax_amount(gt.gta_trx_header_id) taxamount,

5792: AND lk.lookup_type='AR_GTA_INVOICE_TYPE';
5793:
5794: CURSOR c_gt_headers IS
5795: SELECT ar_gta_trx_util.get_gtainvoice_amount(gt.gta_trx_header_id) amount,
5796: ar_gta_trx_util.get_gtainvoice_tax_amount(gt.gta_trx_header_id) taxamount,
5797: gt.bill_to_customer_name customer_name,
5798: gt.tp_tax_registration_number tax_registration_number,
5799: gt.bank_account_name_number customer_bank_account,
5800: gt.customer_address_phone customer_address_phone,