APPS.ASO_TAX_INT dependencies on ZX_TRX_HEADERS_GT

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

2665:
2666: --Insertion into the Header Temporary Table.
2667:
2668: IF aso_debug_pub.g_debug_flag ='Y' THEN
2669: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table ', 1, 'Y');
2670: END IF;
2671:
2672: DELETE FROM ZX_TRX_HEADERS_GT where
2673: APPLICATION_ID=697 and

Line 2672: DELETE FROM ZX_TRX_HEADERS_GT where

2668: IF aso_debug_pub.g_debug_flag ='Y' THEN
2669: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table ', 1, 'Y');
2670: END IF;
2671:
2672: DELETE FROM ZX_TRX_HEADERS_GT where
2673: APPLICATION_ID=697 and
2674: ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL' and
2675: EVENT_CLASS_CODE= 'SALES_TRANSACTION_TAX_QUOTE' and
2676: TRX_ID= p_qte_header_id;

Line 2678: insert into ZX_TRX_HEADERS_GT

2674: ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL' and
2675: EVENT_CLASS_CODE= 'SALES_TRANSACTION_TAX_QUOTE' and
2676: TRX_ID= p_qte_header_id;
2677:
2678: insert into ZX_TRX_HEADERS_GT
2679: (
2680: INTERNAL_ORGANIZATION_ID,
2681: INTERNAL_ORG_LOCATION_ID,
2682: APPLICATION_ID,

Line 3853: ZX_TRX_HEADERS_GT

3849: SHIP_THIRD_PTY_ACCT_ID,
3850: BILL_THIRD_PTY_ACCT_ID,
3851: ROUNDING_BILL_TO_PARTY_ID
3852: from
3853: ZX_TRX_HEADERS_GT
3854: where
3855: TRX_ID=qte_header_id;
3856:
3857: Cursor c2 is select

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

3924: BEGIN
3925: IF (aso_debug_pub.g_debug_flag = 'Y' and rec=1) THEN
3926: for i in c1 LOOP
3927: aso_debug_pub.add( '******************************************',1, 'Y' );
3928: aso_debug_pub.add( '***** After insertion into ZX_TRX_HEADERS_GTT *****',1, 'Y' );
3929: aso_debug_pub.add( '******************************************',1, 'Y' );
3930: aso_debug_pub.add(rpad('INTERNAL_ORGANIZATION_ID',50,'------')||'------>'||i.INTERNAL_ORGANIZATION_ID , 1, 'Y');
3931: aso_debug_pub.add(rpad('INTERNAL_ORG_LOCATION_ID',50,'------')||'------>'||i.INTERNAL_ORG_LOCATION_ID , 1, 'Y');
3932: aso_debug_pub.add(rpad('APPLICATION_ID',50,'------')||'------>'||i.APPLICATION_ID , 1, 'Y');

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

3955: aso_debug_pub.add(rpad('SHIP_THIRD_PTY_ACCT_ID',50,'------')||'------>'||i.SHIP_THIRD_PTY_ACCT_ID , 1, 'Y');
3956: aso_debug_pub.add(rpad('BILL_THIRD_PTY_ACCT_ID',50,'------')||'------>'||i.BILL_THIRD_PTY_ACCT_ID , 1, 'Y');
3957: aso_debug_pub.add(rpad('ROUNDING_BILL_TO_PARTY_ID',50,'------')||'------>'||i.ROUNDING_BILL_TO_PARTY_ID , 1, 'Y');
3958: aso_debug_pub.add(rpad('*',100,'*'),1, 'Y' );
3959: --aso_debug_pub.add('*****INSERTED INTO ZX_TRX_HEADERS_GTT*****',1, 'Y' );
3960: --aso_debug_pub.add('******************************************',1, 'Y' );
3961: end loop;
3962: ELSIF (aso_debug_pub.g_debug_flag = 'Y' and rec=2) THEN
3963: for i in c2 loop