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.JMF_GTA_REPORTS_PKG dependencies on JMF_GTA_DIFFERENCE_TEMP

Line 1477: --Insert this discrepancy record to temp table jmf_gta_difference_temp

1473: IF (l_ar_customer_name<>l_gta_customer_name) OR
1474: (l_ar_customer_name<>l_gt_customer_name)
1475: THEN
1476:
1477: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1478: INSERT INTO jmf_gta_difference_temp(type
1479: ,ar_header_id
1480: ,attribute
1481: ,ar_value

Line 1478: INSERT INTO jmf_gta_difference_temp(type

1474: (l_ar_customer_name<>l_gt_customer_name)
1475: THEN
1476:
1477: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1478: INSERT INTO jmf_gta_difference_temp(type
1479: ,ar_header_id
1480: ,attribute
1481: ,ar_value
1482: ,gta_invoice_num

Line 1508: --Insert this discrepancy record to temp table jmf_gta_difference_temp

1504: AND l_gt_invoice_type IS NOT NULL
1505: AND l_gta_invoice_type <> l_gt_invoice_type )
1506: THEN
1507:
1508: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1509:
1510: INSERT INTO jmf_gta_difference_temp(type
1511: ,ar_header_id
1512: ,attribute

Line 1510: INSERT INTO jmf_gta_difference_temp(type

1506: THEN
1507:
1508: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1509:
1510: INSERT INTO jmf_gta_difference_temp(type
1511: ,ar_header_id
1512: ,attribute
1513: ,ar_value
1514: ,gta_invoice_num

Line 1642: --Insert this discrepancy record to temp table jmf_gta_difference_temp

1638: l_gt_customer_bank_account_m:='';
1639: END IF; --l_gt_customer_bank_account IS NOT NULL
1640:
1641:
1642: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1643: INSERT INTO jmf_gta_difference_temp(type
1644: ,ar_header_id
1645: ,attribute
1646: ,ar_value

Line 1643: INSERT INTO jmf_gta_difference_temp(type

1639: END IF; --l_gt_customer_bank_account IS NOT NULL
1640:
1641:
1642: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1643: INSERT INTO jmf_gta_difference_temp(type
1644: ,ar_header_id
1645: ,attribute
1646: ,ar_value
1647: ,gta_invoice_num

Line 1698: --Insert this discrepancy record to temp table jmf_gta_difference_temp

1694: )
1695: THEN
1696:
1697:
1698: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1699:
1700: INSERT INTO jmf_gta_difference_temp(type
1701: ,ar_header_id
1702: ,attribute

Line 1700: INSERT INTO jmf_gta_difference_temp(type

1696:
1697:
1698: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1699:
1700: INSERT INTO jmf_gta_difference_temp(type
1701: ,ar_header_id
1702: ,attribute
1703: ,ar_value
1704: ,gta_invoice_num

Line 1747: --Insert this discrepancy record to temp table jmf_gta_difference_temp

1743: (l_ar_taxpayer_id IS NULL AND
1744: l_gta_taxpayer_id IS NOT NULL
1745: )
1746: THEN
1747: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1748: INSERT INTO jmf_gta_difference_temp(type
1749: ,ar_header_id
1750: ,attribute
1751: ,ar_value

Line 1748: INSERT INTO jmf_gta_difference_temp(type

1744: l_gta_taxpayer_id IS NOT NULL
1745: )
1746: THEN
1747: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1748: INSERT INTO jmf_gta_difference_temp(type
1749: ,ar_header_id
1750: ,attribute
1751: ,ar_value
1752: ,gta_invoice_num

Line 1861: --Insert this discrepancy record to temp table jmf_gta_difference_temp

1857: l_gt_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1858: ,p_amount =>l_gt_amount_sum
1859: );
1860:
1861: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1862: INSERT INTO jmf_gta_difference_temp(type
1863: ,ar_header_id
1864: ,attribute
1865: ,ar_value

Line 1862: INSERT INTO jmf_gta_difference_temp(type

1858: ,p_amount =>l_gt_amount_sum
1859: );
1860:
1861: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1862: INSERT INTO jmf_gta_difference_temp(type
1863: ,ar_header_id
1864: ,attribute
1865: ,ar_value
1866: ,gta_invoice_num

Line 1913: --Insert this discrepancy record to temp table jmf_gta_difference_temp

1909: ,p_amount => l_gt_taxamount_sum
1910: );
1911:
1912:
1913: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1914: INSERT INTO jmf_gta_difference_temp(type
1915: ,ar_header_id
1916: ,attribute
1917: ,ar_value

Line 1914: INSERT INTO jmf_gta_difference_temp(type

1910: );
1911:
1912:
1913: --Insert this discrepancy record to temp table jmf_gta_difference_temp
1914: INSERT INTO jmf_gta_difference_temp(type
1915: ,ar_header_id
1916: ,attribute
1917: ,ar_value
1918: ,gta_invoice_num

Line 2692: --insert discrepancy record into temp table jmf_gta_difference_temp

2688: l_gt_invoice_number:='-';
2689: l_gt_value:=l_unmatched_attr;
2690: END IF; --(l_matched_flag='Y')
2691:
2692: --insert discrepancy record into temp table jmf_gta_difference_temp
2693: INSERT INTO jmf_gta_difference_temp(TYPE
2694: ,ar_header_id
2695: ,ar_line_id
2696: ,ATTRIBUTE

Line 2693: INSERT INTO jmf_gta_difference_temp(TYPE

2689: l_gt_value:=l_unmatched_attr;
2690: END IF; --(l_matched_flag='Y')
2691:
2692: --insert discrepancy record into temp table jmf_gta_difference_temp
2693: INSERT INTO jmf_gta_difference_temp(TYPE
2694: ,ar_header_id
2695: ,ar_line_id
2696: ,ATTRIBUTE
2697: ,ar_line_num

Line 2744: --insert discrepancy record into temp table jmf_gta_difference_temp

2740: l_gt_invoice_number:='-';
2741: l_gt_value:=l_unmatched_attr;
2742: END IF; --(l_matched_flag='Y')
2743:
2744: --insert discrepancy record into temp table jmf_gta_difference_temp
2745: INSERT INTO jmf_gta_difference_temp(TYPE
2746: ,ar_header_id
2747: ,ar_line_id
2748: ,ATTRIBUTE

Line 2745: INSERT INTO jmf_gta_difference_temp(TYPE

2741: l_gt_value:=l_unmatched_attr;
2742: END IF; --(l_matched_flag='Y')
2743:
2744: --insert discrepancy record into temp table jmf_gta_difference_temp
2745: INSERT INTO jmf_gta_difference_temp(TYPE
2746: ,ar_header_id
2747: ,ar_line_id
2748: ,ATTRIBUTE
2749: ,ar_line_num

Line 2796: --insert discrepancy record into temp table jmf_gta_difference_temp

2792: l_gt_invoice_number:='-';
2793: l_gt_value:=l_unmatched_attr;
2794: END IF; --(l_matched_flag='Y')
2795:
2796: --insert discrepancy record into temp table jmf_gta_difference_temp
2797: INSERT INTO jmf_gta_difference_temp(TYPE
2798: ,ar_header_id
2799: ,ar_line_id
2800: ,ATTRIBUTE

Line 2797: INSERT INTO jmf_gta_difference_temp(TYPE

2793: l_gt_value:=l_unmatched_attr;
2794: END IF; --(l_matched_flag='Y')
2795:
2796: --insert discrepancy record into temp table jmf_gta_difference_temp
2797: INSERT INTO jmf_gta_difference_temp(TYPE
2798: ,ar_header_id
2799: ,ar_line_id
2800: ,ATTRIBUTE
2801: ,ar_line_num

Line 2859: --insert discrepancy record into temp table jmf_gta_difference_temp

2855: l_gta_unit_price_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2856: ,p_amount => l_gta_unit_price
2857: );
2858:
2859: --insert discrepancy record into temp table jmf_gta_difference_temp
2860: INSERT INTO jmf_gta_difference_temp(TYPE
2861: ,ar_header_id
2862: ,ar_line_id
2863: ,ATTRIBUTE

Line 2860: INSERT INTO jmf_gta_difference_temp(TYPE

2856: ,p_amount => l_gta_unit_price
2857: );
2858:
2859: --insert discrepancy record into temp table jmf_gta_difference_temp
2860: INSERT INTO jmf_gta_difference_temp(TYPE
2861: ,ar_header_id
2862: ,ar_line_id
2863: ,ATTRIBUTE
2864: ,ar_line_num

Line 2909: --insert discrepancy record into temp table jmf_gta_difference_temp

2905: l_gt_invoice_number:='-';
2906: l_gt_value:=l_unmatched_attr;
2907: END IF; --(l_matched_flag='Y')
2908:
2909: --insert discrepancy record into temp table jmf_gta_difference_temp
2910: INSERT INTO jmf_gta_difference_temp(TYPE
2911: ,ar_header_id
2912: ,ar_line_id
2913: ,ATTRIBUTE

Line 2910: INSERT INTO jmf_gta_difference_temp(TYPE

2906: l_gt_value:=l_unmatched_attr;
2907: END IF; --(l_matched_flag='Y')
2908:
2909: --insert discrepancy record into temp table jmf_gta_difference_temp
2910: INSERT INTO jmf_gta_difference_temp(TYPE
2911: ,ar_header_id
2912: ,ar_line_id
2913: ,ATTRIBUTE
2914: ,ar_line_num

Line 2986: --insert discrepancy record into temp table jmf_gta_difference_temp

2982: l_gt_value:=l_unmatched_attr;
2983: END IF; --(l_matched_flag_sum='Y')
2984:
2985:
2986: --insert discrepancy record into temp table jmf_gta_difference_temp
2987: INSERT INTO jmf_gta_difference_temp(TYPE
2988: ,ar_header_id
2989: ,ar_line_id
2990: ,ATTRIBUTE

Line 2987: INSERT INTO jmf_gta_difference_temp(TYPE

2983: END IF; --(l_matched_flag_sum='Y')
2984:
2985:
2986: --insert discrepancy record into temp table jmf_gta_difference_temp
2987: INSERT INTO jmf_gta_difference_temp(TYPE
2988: ,ar_header_id
2989: ,ar_line_id
2990: ,ATTRIBUTE
2991: ,ar_line_num

Line 3053: --insert discrepancy record into temp table jmf_gta_difference_temp

3049: l_gta_line_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3050: ,p_amount => l_gta_line_amount_sum
3051: );
3052:
3053: --insert discrepancy record into temp table jmf_gta_difference_temp
3054: INSERT INTO jmf_gta_difference_temp(TYPE
3055: ,ar_header_id
3056: ,ar_line_id
3057: ,ATTRIBUTE

Line 3054: INSERT INTO jmf_gta_difference_temp(TYPE

3050: ,p_amount => l_gta_line_amount_sum
3051: );
3052:
3053: --insert discrepancy record into temp table jmf_gta_difference_temp
3054: INSERT INTO jmf_gta_difference_temp(TYPE
3055: ,ar_header_id
3056: ,ar_line_id
3057: ,ATTRIBUTE
3058: ,ar_line_num

Line 3119: --insert discrepancy record into temp table jmf_gta_difference_temp

3115: l_gta_line_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3116: ,p_amount => l_gta_line_taxamount_sum
3117: );
3118:
3119: --insert discrepancy record into temp table jmf_gta_difference_temp
3120: INSERT INTO jmf_gta_difference_temp(TYPE
3121: ,ar_header_id
3122: ,ar_line_id
3123: ,ATTRIBUTE

Line 3120: INSERT INTO jmf_gta_difference_temp(TYPE

3116: ,p_amount => l_gta_line_taxamount_sum
3117: );
3118:
3119: --insert discrepancy record into temp table jmf_gta_difference_temp
3120: INSERT INTO jmf_gta_difference_temp(TYPE
3121: ,ar_header_id
3122: ,ar_line_id
3123: ,ATTRIBUTE
3124: ,ar_line_num

Line 3217: -- temp table jmf_gta_difference_temp

3213: FETCH c_gt_invoice_number INTO l_gt_invoice_number;
3214: CLOSE c_gt_invoice_number;
3215:
3216: --To Insert GTA trx number and GT invoice number that missed ar line to
3217: -- temp table jmf_gta_difference_temp
3218: INSERT INTO jmf_gta_difference_temp(TYPE
3219: ,ar_header_id
3220: ,ar_line_num
3221: ,gta_invoice_num

Line 3218: INSERT INTO jmf_gta_difference_temp(TYPE

3214: CLOSE c_gt_invoice_number;
3215:
3216: --To Insert GTA trx number and GT invoice number that missed ar line to
3217: -- temp table jmf_gta_difference_temp
3218: INSERT INTO jmf_gta_difference_temp(TYPE
3219: ,ar_header_id
3220: ,ar_line_num
3221: ,gta_invoice_num
3222: ,gta_line_num

Line 3256: INSERT INTO jmf_gta_difference_temp(TYPE

3252: ,'c_not_transferred_ar_lines'
3253: );
3254: END IF; --( l_proc_level >= l_dbg_level)
3255:
3256: INSERT INTO jmf_gta_difference_temp(TYPE
3257: ,ar_header_id
3258: ,ar_line_id
3259: ,ar_line_num
3260: ,gta_invoice_num

Line 3793: jmf_gta_difference_temp

3789: CURSOR c_ar_line_notmatching IS
3790: SELECT
3791: COUNT(DISTINCT ar_line_id)
3792: FROM
3793: jmf_gta_difference_temp
3794: WHERE TYPE='LINE';
3795: */
3796:
3797: CURSOR c_gta_header_xml IS

Line 3809: jmf_gta_difference_temp

3805: ,discrepancy AS "Discrepancy"
3806: )
3807: )
3808: FROM
3809: jmf_gta_difference_temp
3810: WHERE ar_header_id=l_ar_header_id
3811: AND type='HEADER';
3812:
3813:

Line 3830: jmf_gta_difference_temp

3826: ,gt_value AS "GT_Value"
3827: )
3828: )
3829: FROM
3830: jmf_gta_difference_temp
3831: WHERE ar_header_id=l_ar_header_id
3832: AND type='LINE';
3833:
3834: --Update the cursor for fixing the bug 5381833

Line 3847: jmf_gta_difference_temp

3843: ,gt_invoice_num AS "GT_InvoiceNum"
3844: )
3845: )
3846: FROM
3847: jmf_gta_difference_temp
3848: WHERE ar_header_id=l_ar_header_id
3849: AND TYPE='MISSING_AR_LINE';
3850:
3851: CURSOR c_unmatched_line_xml IS