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.

[Home] [Help]

APPS.AR_GTA_REPORTS_PKG dependencies on AR_GTA_DIFFERENCE_TEMP

Line 1568: --Insert this discrepancy record to temp table ar_gta_difference_temp

1564: --Yao Zhang Modified for bug#8765631
1565: ((nvl(l_ar_customer_name,' ')<>nvl(l_gt_customer_name,' '))AND l_gta_status='COMPLETED')
1566: THEN
1567:
1568: --Insert this discrepancy record to temp table ar_gta_difference_temp
1569: INSERT INTO ar_gta_difference_temp(type
1570: ,ar_header_id
1571: ,attribute
1572: ,ar_value

Line 1569: INSERT INTO ar_gta_difference_temp(type

1565: ((nvl(l_ar_customer_name,' ')<>nvl(l_gt_customer_name,' '))AND l_gta_status='COMPLETED')
1566: THEN
1567:
1568: --Insert this discrepancy record to temp table ar_gta_difference_temp
1569: INSERT INTO ar_gta_difference_temp(type
1570: ,ar_header_id
1571: ,attribute
1572: ,ar_value
1573: ,gta_invoice_num

Line 1600: --Insert this discrepancy record to temp table ar_gta_difference_temp

1596: AND l_gta_invoice_type <> l_gt_invoice_type
1597: AND l_gta_status='COMPLETED')--Yao Zhang add for bug#8765631
1598: THEN
1599:
1600: --Insert this discrepancy record to temp table ar_gta_difference_temp
1601:
1602: INSERT INTO ar_gta_difference_temp(type
1603: ,ar_header_id
1604: ,attribute

Line 1602: INSERT INTO ar_gta_difference_temp(type

1598: THEN
1599:
1600: --Insert this discrepancy record to temp table ar_gta_difference_temp
1601:
1602: INSERT INTO ar_gta_difference_temp(type
1603: ,ar_header_id
1604: ,attribute
1605: ,ar_value
1606: ,gta_invoice_num

Line 1735: --Insert this discrepancy record to temp table ar_gta_difference_temp

1731: l_gt_customer_bank_account_m:='';
1732: END IF; --l_gt_customer_bank_account IS NOT NULL
1733:
1734:
1735: --Insert this discrepancy record to temp table ar_gta_difference_temp
1736: INSERT INTO ar_gta_difference_temp(type
1737: ,ar_header_id
1738: ,attribute
1739: ,ar_value

Line 1736: INSERT INTO ar_gta_difference_temp(type

1732: END IF; --l_gt_customer_bank_account IS NOT NULL
1733:
1734:
1735: --Insert this discrepancy record to temp table ar_gta_difference_temp
1736: INSERT INTO ar_gta_difference_temp(type
1737: ,ar_header_id
1738: ,attribute
1739: ,ar_value
1740: ,gta_invoice_num

Line 1792: --Insert this discrepancy record to temp table ar_gta_difference_temp

1788: )*/
1789: THEN
1790:
1791:
1792: --Insert this discrepancy record to temp table ar_gta_difference_temp
1793:
1794: INSERT INTO ar_gta_difference_temp(type
1795: ,ar_header_id
1796: ,attribute

Line 1794: INSERT INTO ar_gta_difference_temp(type

1790:
1791:
1792: --Insert this discrepancy record to temp table ar_gta_difference_temp
1793:
1794: INSERT INTO ar_gta_difference_temp(type
1795: ,ar_header_id
1796: ,attribute
1797: ,ar_value
1798: ,gta_invoice_num

Line 1841: --Insert this discrepancy record to temp table ar_gta_difference_temp

1837: (l_ar_taxpayer_id IS NULL AND
1838: l_gta_taxpayer_id IS NOT NULL
1839: )
1840: THEN
1841: --Insert this discrepancy record to temp table ar_gta_difference_temp
1842: INSERT INTO ar_gta_difference_temp(type
1843: ,ar_header_id
1844: ,attribute
1845: ,ar_value

Line 1842: INSERT INTO ar_gta_difference_temp(type

1838: l_gta_taxpayer_id IS NOT NULL
1839: )
1840: THEN
1841: --Insert this discrepancy record to temp table ar_gta_difference_temp
1842: INSERT INTO ar_gta_difference_temp(type
1843: ,ar_header_id
1844: ,attribute
1845: ,ar_value
1846: ,gta_invoice_num

Line 1958: --Insert this discrepancy record to temp table ar_gta_difference_temp

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
1959: INSERT INTO ar_gta_difference_temp(type
1960: ,ar_header_id
1961: ,attribute
1962: ,ar_value

Line 1959: INSERT INTO ar_gta_difference_temp(type

1955: ,p_amount =>l_gt_amount_sum
1956: );
1957:
1958: --Insert this discrepancy record to temp table ar_gta_difference_temp
1959: INSERT INTO ar_gta_difference_temp(type
1960: ,ar_header_id
1961: ,attribute
1962: ,ar_value
1963: ,gta_invoice_num

Line 2012: --Insert this discrepancy record to temp table ar_gta_difference_temp

2008: ,p_amount => l_gt_taxamount_sum
2009: );
2010:
2011:
2012: --Insert this discrepancy record to temp table ar_gta_difference_temp
2013: INSERT INTO ar_gta_difference_temp(type
2014: ,ar_header_id
2015: ,attribute
2016: ,ar_value

Line 2013: INSERT INTO ar_gta_difference_temp(type

2009: );
2010:
2011:
2012: --Insert this discrepancy record to temp table ar_gta_difference_temp
2013: INSERT INTO ar_gta_difference_temp(type
2014: ,ar_header_id
2015: ,attribute
2016: ,ar_value
2017: ,gta_invoice_num

Line 2894: --insert discrepancy record into temp table ar_gta_difference_temp

2890: l_gt_invoice_number:='-';
2891: -- l_gt_value:=l_unmatched_attr;
2892: END IF; --(l_matched_flag='Y')
2893:
2894: --insert discrepancy record into temp table ar_gta_difference_temp
2895: INSERT INTO ar_gta_difference_temp(TYPE
2896: ,ar_header_id
2897: ,ar_line_id
2898: ,ATTRIBUTE

Line 2895: INSERT INTO ar_gta_difference_temp(TYPE

2891: -- l_gt_value:=l_unmatched_attr;
2892: END IF; --(l_matched_flag='Y')
2893:
2894: --insert discrepancy record into temp table ar_gta_difference_temp
2895: INSERT INTO ar_gta_difference_temp(TYPE
2896: ,ar_header_id
2897: ,ar_line_id
2898: ,ATTRIBUTE
2899: ,ar_line_num

Line 2946: --insert discrepancy record into temp table ar_gta_difference_temp

2942: l_gt_invoice_number:='-';
2943: --l_gt_value:=l_unmatched_attr;
2944: END IF; --(l_matched_flag='Y')
2945:
2946: --insert discrepancy record into temp table ar_gta_difference_temp
2947: INSERT INTO ar_gta_difference_temp(TYPE
2948: ,ar_header_id
2949: ,ar_line_id
2950: ,ATTRIBUTE

Line 2947: INSERT INTO ar_gta_difference_temp(TYPE

2943: --l_gt_value:=l_unmatched_attr;
2944: END IF; --(l_matched_flag='Y')
2945:
2946: --insert discrepancy record into temp table ar_gta_difference_temp
2947: INSERT INTO ar_gta_difference_temp(TYPE
2948: ,ar_header_id
2949: ,ar_line_id
2950: ,ATTRIBUTE
2951: ,ar_line_num

Line 2998: --insert discrepancy record into temp table ar_gta_difference_temp

2994: l_gt_invoice_number:='-';
2995: -- l_gt_value:=l_unmatched_attr;
2996: END IF; --(l_matched_flag='Y')
2997:
2998: --insert discrepancy record into temp table ar_gta_difference_temp
2999: INSERT INTO ar_gta_difference_temp(TYPE
3000: ,ar_header_id
3001: ,ar_line_id
3002: ,ATTRIBUTE

Line 2999: INSERT INTO ar_gta_difference_temp(TYPE

2995: -- l_gt_value:=l_unmatched_attr;
2996: END IF; --(l_matched_flag='Y')
2997:
2998: --insert discrepancy record into temp table ar_gta_difference_temp
2999: INSERT INTO ar_gta_difference_temp(TYPE
3000: ,ar_header_id
3001: ,ar_line_id
3002: ,ATTRIBUTE
3003: ,ar_line_num

Line 3061: --insert discrepancy record into temp table ar_gta_difference_temp

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
3062: INSERT INTO ar_gta_difference_temp(TYPE
3063: ,ar_header_id
3064: ,ar_line_id
3065: ,ATTRIBUTE

Line 3062: INSERT INTO ar_gta_difference_temp(TYPE

3058: ,p_amount => l_gta_unit_price
3059: );
3060:
3061: --insert discrepancy record into temp table ar_gta_difference_temp
3062: INSERT INTO ar_gta_difference_temp(TYPE
3063: ,ar_header_id
3064: ,ar_line_id
3065: ,ATTRIBUTE
3066: ,ar_line_num

Line 3111: --insert discrepancy record into temp table ar_gta_difference_temp

3107: l_gt_invoice_number:='-';
3108: -- l_gt_value:=l_unmatched_attr;
3109: END IF; --(l_matched_flag='Y')
3110:
3111: --insert discrepancy record into temp table ar_gta_difference_temp
3112: INSERT INTO ar_gta_difference_temp(TYPE
3113: ,ar_header_id
3114: ,ar_line_id
3115: ,ATTRIBUTE

Line 3112: INSERT INTO ar_gta_difference_temp(TYPE

3108: -- l_gt_value:=l_unmatched_attr;
3109: END IF; --(l_matched_flag='Y')
3110:
3111: --insert discrepancy record into temp table ar_gta_difference_temp
3112: INSERT INTO ar_gta_difference_temp(TYPE
3113: ,ar_header_id
3114: ,ar_line_id
3115: ,ATTRIBUTE
3116: ,ar_line_num

Line 3171: --insert discrepancy record into temp table ar_gta_difference_temp

3167: -- l_gt_value:=l_unmatched_attr;
3168: END IF; --(l_matched_flag_sum='Y')
3169:
3170:
3171: --insert discrepancy record into temp table ar_gta_difference_temp
3172: INSERT INTO ar_gta_difference_temp(TYPE
3173: ,ar_header_id
3174: ,ar_line_id
3175: ,ATTRIBUTE

Line 3172: INSERT INTO ar_gta_difference_temp(TYPE

3168: END IF; --(l_matched_flag_sum='Y')
3169:
3170:
3171: --insert discrepancy record into temp table ar_gta_difference_temp
3172: INSERT INTO ar_gta_difference_temp(TYPE
3173: ,ar_header_id
3174: ,ar_line_id
3175: ,ATTRIBUTE
3176: ,ar_line_num

Line 3243: --insert discrepancy record into temp table ar_gta_difference_temp

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
3244: INSERT INTO ar_gta_difference_temp(TYPE
3245: ,ar_header_id
3246: ,ar_line_id
3247: ,ATTRIBUTE

Line 3244: INSERT INTO ar_gta_difference_temp(TYPE

3240: ,p_amount => l_gta_line_amount_sum
3241: );
3242:
3243: --insert discrepancy record into temp table ar_gta_difference_temp
3244: INSERT INTO ar_gta_difference_temp(TYPE
3245: ,ar_header_id
3246: ,ar_line_id
3247: ,ATTRIBUTE
3248: ,ar_line_num

Line 3310: --insert discrepancy record into temp table ar_gta_difference_temp

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
3311: INSERT INTO ar_gta_difference_temp(TYPE
3312: ,ar_header_id
3313: ,ar_line_id
3314: ,ATTRIBUTE

Line 3311: INSERT INTO ar_gta_difference_temp(TYPE

3307: ,p_amount => l_gta_line_taxamount_sum
3308: );
3309:
3310: --insert discrepancy record into temp table ar_gta_difference_temp
3311: INSERT INTO ar_gta_difference_temp(TYPE
3312: ,ar_header_id
3313: ,ar_line_id
3314: ,ATTRIBUTE
3315: ,ar_line_num

Line 3393: -- temp table ar_gta_difference_temp

3389: FETCH c_gt_invoice_number INTO l_gt_invoice_number;
3390: CLOSE c_gt_invoice_number;
3391:
3392: --To Insert GTA trx number and GT invoice number that missed ar line to
3393: -- temp table ar_gta_difference_temp
3394: INSERT INTO ar_gta_difference_temp(TYPE
3395: ,ar_header_id
3396: ,ar_line_num
3397: ,gta_invoice_num

Line 3394: INSERT INTO ar_gta_difference_temp(TYPE

3390: CLOSE c_gt_invoice_number;
3391:
3392: --To Insert GTA trx number and GT invoice number that missed ar line to
3393: -- temp table ar_gta_difference_temp
3394: INSERT INTO ar_gta_difference_temp(TYPE
3395: ,ar_header_id
3396: ,ar_line_num
3397: ,gta_invoice_num
3398: ,gta_line_num

Line 3432: INSERT INTO ar_gta_difference_temp(TYPE

3428: ,'c_not_transferred_ar_lines'
3429: );
3430: END IF; --( l_proc_level >= l_dbg_level)
3431:
3432: INSERT INTO ar_gta_difference_temp(TYPE
3433: ,ar_header_id
3434: ,ar_line_id
3435: ,ar_line_num
3436: ,gta_invoice_num

Line 3976: ar_gta_difference_temp

3972: CURSOR c_ar_line_notmatching IS
3973: SELECT
3974: COUNT(DISTINCT ar_line_id)
3975: FROM
3976: ar_gta_difference_temp
3977: WHERE TYPE='LINE';
3978: */
3979:
3980: CURSOR c_gta_header_xml IS

Line 3992: ar_gta_difference_temp

3988: ,discrepancy AS "Discrepancy"
3989: )
3990: )
3991: FROM
3992: ar_gta_difference_temp
3993: WHERE ar_header_id=l_ar_header_id
3994: AND type='HEADER';
3995:
3996:

Line 4013: ar_gta_difference_temp

4009: ,gt_value AS "GT_Value"
4010: )
4011: )
4012: FROM
4013: ar_gta_difference_temp
4014: WHERE ar_header_id=l_ar_header_id
4015: AND type='LINE';
4016:
4017: --Update the cursor for fixing the bug 5381833

Line 4030: ar_gta_difference_temp

4026: ,gt_invoice_num AS "GT_InvoiceNum"
4027: )
4028: )
4029: FROM
4030: ar_gta_difference_temp
4031: WHERE ar_header_id=l_ar_header_id
4032: AND TYPE='MISSING_AR_LINE';
4033:
4034: CURSOR c_unmatched_line_xml IS

Line 5918: INSERT INTO ar_gta_difference_temp(type

5914: CLOSE c_gt_headers;
5915: --compare amount
5916: IF l_gta_amount<>l_gt_amount
5917: THEN
5918: INSERT INTO ar_gta_difference_temp(type
5919: ,ar_header_id
5920: ,attribute
5921: ,ar_value
5922: ,gta_invoice_num

Line 5943: INSERT INTO ar_gta_difference_temp(type

5939: END IF;
5940: --compare tax amount
5941: IF l_gta_taxamount<>l_gt_taxamount
5942: THEN
5943: INSERT INTO ar_gta_difference_temp(type
5944: ,ar_header_id
5945: ,attribute
5946: ,ar_value
5947: ,gta_invoice_num

Line 5968: INSERT INTO ar_gta_difference_temp(type

5964: END IF;
5965: --compare customer name
5966: IF trim(l_gta_customer_name)<>TRIM(l_gt_customer_name)
5967: THEN
5968: INSERT INTO ar_gta_difference_temp(type
5969: ,ar_header_id
5970: ,attribute
5971: ,ar_value
5972: ,gta_invoice_num

Line 5993: INSERT INTO ar_gta_difference_temp(type

5989: END IF;
5990: --compare tax_payer_id
5991: IF trim(l_gta_taxpayer_id)<>TRIM(l_gt_taxpayer_id)
5992: THEN
5993: INSERT INTO ar_gta_difference_temp(type
5994: ,ar_header_id
5995: ,attribute
5996: ,ar_value
5997: ,gta_invoice_num

Line 6019: INSERT INTO ar_gta_difference_temp(type

6015:
6016: --compare customer_bank_account
6017: IF trim(l_gta_customer_bank_account)<>TRIM(l_gt_customer_bank_account)
6018: THEN
6019: INSERT INTO ar_gta_difference_temp(type
6020: ,ar_header_id
6021: ,attribute
6022: ,ar_value
6023: ,gta_invoice_num

Line 6045: INSERT INTO ar_gta_difference_temp(type

6041:
6042: --compare customer address phone
6043: IF trim(l_gta_customer_address_phone)<>TRIM(l_gt_customer_address_phone)
6044: THEN
6045: INSERT INTO ar_gta_difference_temp(type
6046: ,ar_header_id
6047: ,attribute
6048: ,ar_value
6049: ,gta_invoice_num

Line 6071: INSERT INTO ar_gta_difference_temp(type

6067:
6068: --compare invoice type
6069: IF trim(l_gta_invoice_type_name)<>TRIM(l_gt_invoice_type_name)
6070: THEN
6071: INSERT INTO ar_gta_difference_temp(type
6072: ,ar_header_id
6073: ,attribute
6074: ,ar_value
6075: ,gta_invoice_num