DBA Data[Home] [Help]

APPS.ASO_TAX_INT dependencies on ZX_TRANSACTION_LINES_GT

Line 2750: DELETE FROM Zx_transaction_lines_gt

2746: IF aso_debug_pub.g_debug_flag ='Y' THEN
2747: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE THE QUOTE LINES LOOP ', 1, 'Y');
2748: END IF;
2749:
2750: DELETE FROM Zx_transaction_lines_gt
2751: WHERE APPLICATION_ID= 697
2752: AND ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL'
2753: AND EVENT_CLASS_CODE = 'SALES_TRANSACTION_TAX_QUOTE'
2754: AND TRX_ID = p_qte_header_id

Line 2901: --aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');

2897:
2898: IF aso_debug_pub.g_debug_flag ='Y' THEN
2899: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :AFTER THE CALL TO c_LOCATION_ID ', 1, 'Y');
2900: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_SHIP_FROM_LOCATION_ID : '||l_SHIP_FROM_LOCATION_ID , 1, 'Y');
2901: --aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');
2902: END IF;
2903:
2904:
2905: -- new code added by suyog bug 5061912

Line 2943: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');

2939:
2940: IF aso_debug_pub.g_debug_flag ='Y' THEN
2941: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :Value for poa_party_id: '|| l_qte_header_rec.ORG_ID , 1, 'Y');
2942: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE_LINES_LOOP :Value for poa_location_id: '|| l_int_org_location , 1, 'Y');
2943: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');
2944: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.LINE_QUOTE_PRICE '|| l_qte_line_rec.LINE_QUOTE_PRICE , 1, 'Y');
2945: aso_debug_pub.add('8936101 ASO_TAX_INT :CALCULATE_TAX_WITH_GTT:l_qte_line_rec.QUANTITY '||l_qte_line_rec.QUANTITY, 1, 'Y');
2946: END IF;
2947:

Line 2977: insert into Zx_transaction_lines_gt

2973: -- Code Changes for Default tax classification code Bug 5177854 END
2974:
2975: -- End If;
2976: --Insertion into the Lines Temporary Table
2977: insert into Zx_transaction_lines_gt
2978: (
2979: APPLICATION_ID,
2980: ENTITY_CODE,
2981: EVENT_CLASS_CODE,

Line 3903: Zx_transaction_lines_gt

3899: CTRL_HDR_TX_APPL_FLAG,
3900: TRX_LINE_NUMBER,
3901: BILL_FROM_LOCATION_ID /*** Added for Bug 8474803 and 7408162 ***/
3902: from
3903: Zx_transaction_lines_gt
3904: where
3905: TRX_ID=qte_header_id;
3906:
3907: Cursor c3 is select

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

3961: end loop;
3962: ELSIF (aso_debug_pub.g_debug_flag = 'Y' and rec=2) THEN
3963: for i in c2 loop
3964: aso_debug_pub.add( '******************************************',1, 'Y' );
3965: aso_debug_pub.add( '***** After insertion into Zx_transaction_lines_gt *****',1, 'Y' );
3966: aso_debug_pub.add( '******************************************',1, 'Y' );
3967: aso_debug_pub.add(rpad('APPLICATION_ID',50,'------')||'------>'||i.APPLICATION_ID , 1, 'Y');
3968: aso_debug_pub.add(rpad('ENTITY_CODE',50,'------')||'------>'||i.ENTITY_CODE , 1, 'Y');
3969: aso_debug_pub.add(rpad('EVENT_CLASS_CODE',50,'------')||'------>'||i.EVENT_CLASS_CODE , 1, 'Y');