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.IGC_ETAX_UTIL_PKG dependencies on ZX_REC_NREC_DIST_GT

Line 663: --l_tax_amount ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt%type;

659: l_debug_info VARCHAR2(240);
660: l_calling_sequence VARCHAR2(240);
661: l_msg_count NUMBER;
662: l_msg_data VARCHAR2(10);
663: --l_tax_amount ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt%type;
664: l_tax_amount ZX_DETAIL_TAX_LINES_GT.tax_amt%type;
665: l_taxable_amount ZX_DETAIL_TAX_LINES_GT.taxable_amt%type;
666: l_amount_includes_tax_flag ZX_DETAIL_TAX_LINES_GT.tax_amt_included_flag%type;
667: l_tax_value NUMBER := 0;

Line 822: FOR l_zx_rec_nrec_dist_gt in C_ZX_REC_NREC_DIST_GT(P_CC_Header_Rec.cc_header_id, P_Line_Id)

818:
819: l_tax_amount := 0;
820:
821: /*
822: FOR l_zx_rec_nrec_dist_gt in C_ZX_REC_NREC_DIST_GT(P_CC_Header_Rec.cc_header_id, P_Line_Id)
823: LOOP
824: IF (g_debug_mode = 'Y') THEN
825: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.recoverable_flag : '||l_zx_rec_nrec_dist_gt.recoverable_flag);
826: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt : '||l_zx_rec_nrec_dist_gt.rec_nrec_tax_amt);

Line 825: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.recoverable_flag : '||l_zx_rec_nrec_dist_gt.recoverable_flag);

821: /*
822: FOR l_zx_rec_nrec_dist_gt in C_ZX_REC_NREC_DIST_GT(P_CC_Header_Rec.cc_header_id, P_Line_Id)
823: LOOP
824: IF (g_debug_mode = 'Y') THEN
825: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.recoverable_flag : '||l_zx_rec_nrec_dist_gt.recoverable_flag);
826: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt : '||l_zx_rec_nrec_dist_gt.rec_nrec_tax_amt);
827: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.REC_NREC_RATE : '||l_zx_rec_nrec_dist_gt.REC_NREC_RATE);
828: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_ID :'||l_zx_rec_nrec_dist_gt.TAX_ID);
829: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TRX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TRX_CURRENCY_CODE);

Line 826: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt : '||l_zx_rec_nrec_dist_gt.rec_nrec_tax_amt);

822: FOR l_zx_rec_nrec_dist_gt in C_ZX_REC_NREC_DIST_GT(P_CC_Header_Rec.cc_header_id, P_Line_Id)
823: LOOP
824: IF (g_debug_mode = 'Y') THEN
825: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.recoverable_flag : '||l_zx_rec_nrec_dist_gt.recoverable_flag);
826: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt : '||l_zx_rec_nrec_dist_gt.rec_nrec_tax_amt);
827: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.REC_NREC_RATE : '||l_zx_rec_nrec_dist_gt.REC_NREC_RATE);
828: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_ID :'||l_zx_rec_nrec_dist_gt.TAX_ID);
829: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TRX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TRX_CURRENCY_CODE);
830: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CODE);

Line 827: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.REC_NREC_RATE : '||l_zx_rec_nrec_dist_gt.REC_NREC_RATE);

823: LOOP
824: IF (g_debug_mode = 'Y') THEN
825: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.recoverable_flag : '||l_zx_rec_nrec_dist_gt.recoverable_flag);
826: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt : '||l_zx_rec_nrec_dist_gt.rec_nrec_tax_amt);
827: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.REC_NREC_RATE : '||l_zx_rec_nrec_dist_gt.REC_NREC_RATE);
828: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_ID :'||l_zx_rec_nrec_dist_gt.TAX_ID);
829: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TRX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TRX_CURRENCY_CODE);
830: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CODE);
831: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CONVERSION_RATE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CONVERSION_RATE );

Line 828: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_ID :'||l_zx_rec_nrec_dist_gt.TAX_ID);

824: IF (g_debug_mode = 'Y') THEN
825: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.recoverable_flag : '||l_zx_rec_nrec_dist_gt.recoverable_flag);
826: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt : '||l_zx_rec_nrec_dist_gt.rec_nrec_tax_amt);
827: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.REC_NREC_RATE : '||l_zx_rec_nrec_dist_gt.REC_NREC_RATE);
828: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_ID :'||l_zx_rec_nrec_dist_gt.TAX_ID);
829: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TRX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TRX_CURRENCY_CODE);
830: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CODE);
831: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CONVERSION_RATE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CONVERSION_RATE );
832: END IF;

Line 829: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TRX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TRX_CURRENCY_CODE);

825: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.recoverable_flag : '||l_zx_rec_nrec_dist_gt.recoverable_flag);
826: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt : '||l_zx_rec_nrec_dist_gt.rec_nrec_tax_amt);
827: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.REC_NREC_RATE : '||l_zx_rec_nrec_dist_gt.REC_NREC_RATE);
828: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_ID :'||l_zx_rec_nrec_dist_gt.TAX_ID);
829: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TRX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TRX_CURRENCY_CODE);
830: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CODE);
831: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CONVERSION_RATE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CONVERSION_RATE );
832: END IF;
833: END LOOP;

Line 830: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CODE);

826: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.rec_nrec_tax_amt : '||l_zx_rec_nrec_dist_gt.rec_nrec_tax_amt);
827: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.REC_NREC_RATE : '||l_zx_rec_nrec_dist_gt.REC_NREC_RATE);
828: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_ID :'||l_zx_rec_nrec_dist_gt.TAX_ID);
829: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TRX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TRX_CURRENCY_CODE);
830: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CODE);
831: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CONVERSION_RATE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CONVERSION_RATE );
832: END IF;
833: END LOOP;
834: */

Line 831: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CONVERSION_RATE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CONVERSION_RATE );

827: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.REC_NREC_RATE : '||l_zx_rec_nrec_dist_gt.REC_NREC_RATE);
828: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_ID :'||l_zx_rec_nrec_dist_gt.TAX_ID);
829: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TRX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TRX_CURRENCY_CODE);
830: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CODE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CODE);
831: Put_Debug_Msg (l_full_path,p_debug_msg => 'Value of C_ZX_REC_NREC_DIST_GT.TAX_CURRENCY_CONVERSION_RATE : '||l_zx_rec_nrec_dist_gt.TAX_CURRENCY_CONVERSION_RATE );
832: END IF;
833: END LOOP;
834: */
835: SELECT nvl(SUM(rec_nrec_tax_amt),0)

Line 837: FROM ZX_REC_NREC_DIST_GT

833: END LOOP;
834: */
835: SELECT nvl(SUM(rec_nrec_tax_amt),0)
836: INTO l_tax_amount
837: FROM ZX_REC_NREC_DIST_GT
838: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --'8407'
839: AND entity_code =IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --'IGC_CC_HEADERS'
840: AND event_class_code =IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --'PURCHASE_TRANSACTION_TAX_QUOTE'
841: AND trx_id = P_CC_Header_Rec.cc_header_id