DBA Data[Home] [Help]

APPS.ASO_TAX_INT dependencies on ZX_TRANSACTION_LINES_GT

Line 2668: DELETE FROM Zx_transaction_lines_gt

2664: IF aso_debug_pub.g_debug_flag ='Y' THEN
2665: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: BEFORE THE QUOTE LINES LOOP ', 1, 'Y');
2666: END IF;
2667:
2668: DELETE FROM Zx_transaction_lines_gt
2669: WHERE APPLICATION_ID= 697
2670: AND ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL'
2671: AND EVENT_CLASS_CODE = 'SALES_TRANSACTION_TAX_QUOTE'
2672: AND TRX_ID = p_qte_header_id

Line 2812: --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');

2808:
2809: IF aso_debug_pub.g_debug_flag ='Y' THEN
2810: 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');
2811: 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');
2812: --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');
2813: END IF;
2814:
2815:
2816: -- new code added by suyog bug 5061912

Line 2854: 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');

2850:
2851: IF aso_debug_pub.g_debug_flag ='Y' THEN
2852: 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');
2853: 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');
2854: 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');
2855: END IF;
2856:
2857: -- end of new code added by suyog
2858:

Line 2885: insert into Zx_transaction_lines_gt

2881: -- Code Changes for Default tax classification code Bug 5177854 END
2882:
2883:
2884: --Insertion into the Lines Temporary Table
2885: insert into Zx_transaction_lines_gt
2886: (
2887: APPLICATION_ID,
2888: ENTITY_CODE,
2889: EVENT_CLASS_CODE,

Line 3800: Zx_transaction_lines_gt

3796: CTRL_HDR_TX_APPL_FLAG,
3797: TRX_LINE_NUMBER,
3798: BILL_FROM_LOCATION_ID --bug7408162
3799: from
3800: Zx_transaction_lines_gt
3801: where
3802: TRX_ID=qte_header_id;
3803:
3804: Cursor c3 is select

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

3858: end loop;
3859: ELSIF (aso_debug_pub.g_debug_flag = 'Y' and rec=2) THEN
3860: for i in c2 loop
3861: aso_debug_pub.add( '******************************************',1, 'Y' );
3862: aso_debug_pub.add( '***** After insertion into Zx_transaction_lines_gt *****',1, 'Y' );
3863: aso_debug_pub.add( '******************************************',1, 'Y' );
3864: aso_debug_pub.add(rpad('APPLICATION_ID',50,'------')||'------>'||i.APPLICATION_ID , 1, 'Y');
3865: aso_debug_pub.add(rpad('ENTITY_CODE',50,'------')||'------>'||i.ENTITY_CODE , 1, 'Y');
3866: aso_debug_pub.add(rpad('EVENT_CLASS_CODE',50,'------')||'------>'||i.EVENT_CLASS_CODE , 1, 'Y');