APPS.ASO_TAX_INT dependencies on ZX_TRX_HEADERS_GT

Line 2587: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table ', 1, 'Y');

2583:
2584: --Insertion into the Header Temporary Table.
2585:
2586: IF aso_debug_pub.g_debug_flag ='Y' THEN
2587: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table ', 1, 'Y');
2588: END IF;
2589:
2590: DELETE FROM ZX_TRX_HEADERS_GT where
2591: APPLICATION_ID=697 and

Line 2590: DELETE FROM ZX_TRX_HEADERS_GT where

2586: IF aso_debug_pub.g_debug_flag ='Y' THEN
2587: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table ', 1, 'Y');
2588: END IF;
2589:
2590: DELETE FROM ZX_TRX_HEADERS_GT where
2591: APPLICATION_ID=697 and
2592: ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL' and
2593: EVENT_CLASS_CODE= 'SALES_TRANSACTION_TAX_QUOTE' and
2594: TRX_ID= p_qte_header_id;

Line 2596: insert into ZX_TRX_HEADERS_GT

2592: ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL' and
2593: EVENT_CLASS_CODE= 'SALES_TRANSACTION_TAX_QUOTE' and
2594: TRX_ID= p_qte_header_id;
2595:
2596: insert into ZX_TRX_HEADERS_GT
2597: (
2598: INTERNAL_ORGANIZATION_ID,
2599: INTERNAL_ORG_LOCATION_ID,
2600: APPLICATION_ID,

Line 3750: ZX_TRX_HEADERS_GT

3746: SHIP_THIRD_PTY_ACCT_ID,
3747: BILL_THIRD_PTY_ACCT_ID,
3748: ROUNDING_BILL_TO_PARTY_ID
3749: from
3750: ZX_TRX_HEADERS_GT
3751: where
3752: TRX_ID=qte_header_id;
3753:
3754: Cursor c2 is select

Line 3825: aso_debug_pub.add( '***** After insertion into ZX_TRX_HEADERS_GTT *****',1, 'Y' );

3821: BEGIN
3822: IF (aso_debug_pub.g_debug_flag = 'Y' and rec=1) THEN
3823: for i in c1 LOOP
3824: aso_debug_pub.add( '******************************************',1, 'Y' );
3825: aso_debug_pub.add( '***** After insertion into ZX_TRX_HEADERS_GTT *****',1, 'Y' );
3826: aso_debug_pub.add( '******************************************',1, 'Y' );
3827: aso_debug_pub.add(rpad('INTERNAL_ORGANIZATION_ID',50,'------')||'------>'||i.INTERNAL_ORGANIZATION_ID , 1, 'Y');
3828: aso_debug_pub.add(rpad('INTERNAL_ORG_LOCATION_ID',50,'------')||'------>'||i.INTERNAL_ORG_LOCATION_ID , 1, 'Y');
3829: aso_debug_pub.add(rpad('APPLICATION_ID',50,'------')||'------>'||i.APPLICATION_ID , 1, 'Y');

Line 3856: --aso_debug_pub.add('*****INSERTED INTO ZX_TRX_HEADERS_GTT*****',1, 'Y' );

3852: aso_debug_pub.add(rpad('SHIP_THIRD_PTY_ACCT_ID',50,'------')||'------>'||i.SHIP_THIRD_PTY_ACCT_ID , 1, 'Y');
3853: aso_debug_pub.add(rpad('BILL_THIRD_PTY_ACCT_ID',50,'------')||'------>'||i.BILL_THIRD_PTY_ACCT_ID , 1, 'Y');
3854: aso_debug_pub.add(rpad('ROUNDING_BILL_TO_PARTY_ID',50,'------')||'------>'||i.ROUNDING_BILL_TO_PARTY_ID , 1, 'Y');
3855: aso_debug_pub.add(rpad('*',100,'*'),1, 'Y' );
3856: --aso_debug_pub.add('*****INSERTED INTO ZX_TRX_HEADERS_GTT*****',1, 'Y' );
3857: --aso_debug_pub.add('******************************************',1, 'Y' );
3858: end loop;
3859: ELSIF (aso_debug_pub.g_debug_flag = 'Y' and rec=2) THEN
3860: for i in c2 loop