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.ZX_TEST_API dependencies on ZX_LINES

Line 4934: from zx_lines

4930:
4931: FOR i in l_start_row..l_end_row LOOP
4932: select object_version_number
4933: into l_object_version_number
4934: from zx_lines
4935: where application_id =g_suite_rec_tbl.application_id(i)
4936: and entity_code = g_suite_rec_tbl.entity_code(i)
4937: and event_class_code = g_suite_rec_tbl.event_class_code(i)
4938: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 5264: from zx_lines

5260:
5261: FOR i in l_start_row..l_end_row LOOP
5262: select object_version_number
5263: into l_object_version_number
5264: from zx_lines
5265: where application_id =g_suite_rec_tbl.application_id(i)
5266: and entity_code = g_suite_rec_tbl.entity_code(i)
5267: and event_class_code = g_suite_rec_tbl.event_class_code(i)
5268: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 5620: from zx_lines

5616:
5617: FOR i in l_start_row..l_end_row LOOP
5618: select object_version_number
5619: into l_object_version_number
5620: from zx_lines
5621: where application_id =g_suite_rec_tbl.application_id(i)
5622: and entity_code = g_suite_rec_tbl.entity_code(i)
5623: and event_class_code = g_suite_rec_tbl.event_class_code(i)
5624: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 6260: from zx_lines_summary

6256: FOR i in g_suite_rec_tbl.application_id.FIRST..g_suite_rec_tbl.application_id.LAST LOOP
6257:
6258: select object_version_number
6259: into l_object_version_number
6260: from zx_lines_summary
6261: where application_id =g_suite_rec_tbl.application_id(i)
6262: and entity_code = g_suite_rec_tbl.entity_code(i)
6263: and event_class_code = g_suite_rec_tbl.event_class_code(i)
6264: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 6399: from zx_lines_summary

6395: FOR i in g_suite_rec_tbl.application_id.FIRST..g_suite_rec_tbl.application_id.LAST LOOP
6396:
6397: select object_version_number
6398: into l_object_version_number
6399: from zx_lines_summary
6400: where application_id =g_suite_rec_tbl.application_id(i)
6401: and entity_code = g_suite_rec_tbl.entity_code(i)
6402: and event_class_code = g_suite_rec_tbl.event_class_code(i)
6403: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 6565: from zx_lines_summary

6561: FOR i in l_start_row..l_end_row LOOP
6562:
6563: select object_version_number
6564: into l_object_version_number
6565: from zx_lines_summary
6566: where application_id =g_suite_rec_tbl.application_id(i)
6567: and entity_code = g_suite_rec_tbl.entity_code(i)
6568: and event_class_code = g_suite_rec_tbl.event_class_code(i)
6569: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 7464: FROM zx_lines

7460: TRX_DATE,
7461: TRX_CURRENCY_CODE,
7462: PRECISION,
7463: LEGAL_ENTITY_ID
7464: FROM zx_lines
7465: WHERE trx_id = p_transaction_id
7466: AND tax_only_line_flag= 'N';
7467:
7468: --- Inserting into zx_transaction_lines_gt has changed. Correct it later.

Line 7494: FROM zx_lines

7490: UNIT_PRICE,
7491: --UOM_CODE, -- Commented for V6 Changes.
7492: sysdate, --TRX_LINE_GL_DATE, -- Commented for V6 changes.
7493: 'A' --LINE_AMT_INCLUDES_TAX_FLAG -- Commented for V6 Changes.
7494: FROM zx_lines
7495: WHERE trx_id = p_transaction_id
7496: AND tax_only_line_flag= 'N'; */
7497:
7498: -----------------------------------------------------------

Line 7523: FROM zx_lines

7519:
7520: Begin
7521:
7522: SELECT 'X' into l_flag
7523: FROM zx_lines
7524: WHERE trx_id = p_transaction_id
7525: AND tax_only_line_flag= 'Y';
7526:
7527: EXCEPTION

Line 8214: | from ZX_LINES,ZX_LINES_SUMMARY and |

8210: /*==========================================================================*
8211: | PROCEDURE Populate_Report_Table : Populates the Report Table to display |
8212: | the results of the Suite. |
8213: | First, it has to fetch the information |
8214: | from ZX_LINES,ZX_LINES_SUMMARY and |
8215: | ZX_REC_NREC_DIST tables, then Bulk |
8216: | Collect into memory structures and then|
8217: | Bulk insert into the temporary table. |
8218: *==========================================================================*/

Line 8266: -- Proceed to Insert ZX_LINES data

8262:
8263: IF p_error_flag <> 'Y' THEN
8264:
8265: --------------------------------------------------
8266: -- Proceed to Insert ZX_LINES data
8267: --------------------------------------------------
8268: select count(*)
8269: into l_dummy
8270: from zx_lines l

Line 8270: from zx_lines l

8266: -- Proceed to Insert ZX_LINES data
8267: --------------------------------------------------
8268: select count(*)
8269: into l_dummy
8270: from zx_lines l
8271: where l.trx_id = p_transaction_id
8272: and l.application_id = l_application_id
8273: and l.entity_code = l_entity_code
8274: and l.event_class_code = l_event_class_code;

Line 8277: write_message('The number of rows in ZX_LINES for transaction id '||to_char(p_transaction_id)||' are '||to_char(l_dummy));

8273: and l.entity_code = l_entity_code
8274: and l.event_class_code = l_event_class_code;
8275:
8276:
8277: write_message('The number of rows in ZX_LINES for transaction id '||to_char(p_transaction_id)||' are '||to_char(l_dummy));
8278:
8279: INSERT INTO ZX_TEST_API_GT(
8280: SUITE_NUMBER ,
8281: CASE_NUMBER ,

Line 8334: zx_lines.TRX_NUMBER ,

8330: select
8331: p_suite ,
8332: p_case ,
8333: p_transaction_id ,
8334: zx_lines.TRX_NUMBER ,
8335: zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,
8336: zx_lines.TRX_DATE ,
8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,

Line 8335: zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,

8331: p_suite ,
8332: p_case ,
8333: p_transaction_id ,
8334: zx_lines.TRX_NUMBER ,
8335: zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,
8336: zx_lines.TRX_DATE ,
8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,

Line 8336: zx_lines.TRX_DATE ,

8332: p_case ,
8333: p_transaction_id ,
8334: zx_lines.TRX_NUMBER ,
8335: zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,
8336: zx_lines.TRX_DATE ,
8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,

Line 8337: zx_lines.TRX_CURRENCY_CODE ,

8333: p_transaction_id ,
8334: zx_lines.TRX_NUMBER ,
8335: zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,
8336: zx_lines.TRX_DATE ,
8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,

Line 8338: zx_lines.SUMMARY_TAX_LINE_ID ,

8334: zx_lines.TRX_NUMBER ,
8335: zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,
8336: zx_lines.TRX_DATE ,
8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,

Line 8339: zx_lines.TAX_LINE_ID ,

8335: zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,
8336: zx_lines.TRX_DATE ,
8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,
8343: zx_lines.TAX_STATUS_CODE ,

Line 8340: zx_lines.TAX_REGIME_CODE ,

8336: zx_lines.TRX_DATE ,
8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,
8343: zx_lines.TAX_STATUS_CODE ,
8344: zx_lines.TAX_RATE_ID ,

Line 8341: zx_lines.TAX_JURISDICTION_ID ,

8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,
8343: zx_lines.TAX_STATUS_CODE ,
8344: zx_lines.TAX_RATE_ID ,
8345: zx_lines.TAX_RATE_CODE ,

Line 8342: zx_lines.TAX ,

8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,
8343: zx_lines.TAX_STATUS_CODE ,
8344: zx_lines.TAX_RATE_ID ,
8345: zx_lines.TAX_RATE_CODE ,
8346: zx_lines.TAX_RATE ,

Line 8343: zx_lines.TAX_STATUS_CODE ,

8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,
8343: zx_lines.TAX_STATUS_CODE ,
8344: zx_lines.TAX_RATE_ID ,
8345: zx_lines.TAX_RATE_CODE ,
8346: zx_lines.TAX_RATE ,
8347: zx_lines.TAX_AMT ,

Line 8344: zx_lines.TAX_RATE_ID ,

8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,
8343: zx_lines.TAX_STATUS_CODE ,
8344: zx_lines.TAX_RATE_ID ,
8345: zx_lines.TAX_RATE_CODE ,
8346: zx_lines.TAX_RATE ,
8347: zx_lines.TAX_AMT ,
8348: zx_lines.TAXABLE_AMT ,

Line 8345: zx_lines.TAX_RATE_CODE ,

8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,
8343: zx_lines.TAX_STATUS_CODE ,
8344: zx_lines.TAX_RATE_ID ,
8345: zx_lines.TAX_RATE_CODE ,
8346: zx_lines.TAX_RATE ,
8347: zx_lines.TAX_AMT ,
8348: zx_lines.TAXABLE_AMT ,
8349: zx_lines.REC_TAX_AMT ,

Line 8346: zx_lines.TAX_RATE ,

8342: zx_lines.TAX ,
8343: zx_lines.TAX_STATUS_CODE ,
8344: zx_lines.TAX_RATE_ID ,
8345: zx_lines.TAX_RATE_CODE ,
8346: zx_lines.TAX_RATE ,
8347: zx_lines.TAX_AMT ,
8348: zx_lines.TAXABLE_AMT ,
8349: zx_lines.REC_TAX_AMT ,
8350: zx_lines.NREC_TAX_AMT ,

Line 8347: zx_lines.TAX_AMT ,

8343: zx_lines.TAX_STATUS_CODE ,
8344: zx_lines.TAX_RATE_ID ,
8345: zx_lines.TAX_RATE_CODE ,
8346: zx_lines.TAX_RATE ,
8347: zx_lines.TAX_AMT ,
8348: zx_lines.TAXABLE_AMT ,
8349: zx_lines.REC_TAX_AMT ,
8350: zx_lines.NREC_TAX_AMT ,
8351: zx_lines.TAX_AMT_FUNCL_CURR ,

Line 8348: zx_lines.TAXABLE_AMT ,

8344: zx_lines.TAX_RATE_ID ,
8345: zx_lines.TAX_RATE_CODE ,
8346: zx_lines.TAX_RATE ,
8347: zx_lines.TAX_AMT ,
8348: zx_lines.TAXABLE_AMT ,
8349: zx_lines.REC_TAX_AMT ,
8350: zx_lines.NREC_TAX_AMT ,
8351: zx_lines.TAX_AMT_FUNCL_CURR ,
8352: NULL ,

Line 8349: zx_lines.REC_TAX_AMT ,

8345: zx_lines.TAX_RATE_CODE ,
8346: zx_lines.TAX_RATE ,
8347: zx_lines.TAX_AMT ,
8348: zx_lines.TAXABLE_AMT ,
8349: zx_lines.REC_TAX_AMT ,
8350: zx_lines.NREC_TAX_AMT ,
8351: zx_lines.TAX_AMT_FUNCL_CURR ,
8352: NULL ,
8353: NULL ,

Line 8350: zx_lines.NREC_TAX_AMT ,

8346: zx_lines.TAX_RATE ,
8347: zx_lines.TAX_AMT ,
8348: zx_lines.TAXABLE_AMT ,
8349: zx_lines.REC_TAX_AMT ,
8350: zx_lines.NREC_TAX_AMT ,
8351: zx_lines.TAX_AMT_FUNCL_CURR ,
8352: NULL ,
8353: NULL ,
8354: NULL ,

Line 8351: zx_lines.TAX_AMT_FUNCL_CURR ,

8347: zx_lines.TAX_AMT ,
8348: zx_lines.TAXABLE_AMT ,
8349: zx_lines.REC_TAX_AMT ,
8350: zx_lines.NREC_TAX_AMT ,
8351: zx_lines.TAX_AMT_FUNCL_CURR ,
8352: NULL ,
8353: NULL ,
8354: NULL ,
8355: NULL ,

Line 8356: zx_lines.SELF_ASSESSED_FLAG ,

8352: NULL ,
8353: NULL ,
8354: NULL ,
8355: NULL ,
8356: zx_lines.SELF_ASSESSED_FLAG ,
8357: zx_lines.MANUALLY_ENTERED_FLAG ,
8358: 'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.
8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,
8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,

Line 8357: zx_lines.MANUALLY_ENTERED_FLAG ,

8353: NULL ,
8354: NULL ,
8355: NULL ,
8356: zx_lines.SELF_ASSESSED_FLAG ,
8357: zx_lines.MANUALLY_ENTERED_FLAG ,
8358: 'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.
8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,
8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,
8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,

Line 8358: 'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.

8354: NULL ,
8355: NULL ,
8356: zx_lines.SELF_ASSESSED_FLAG ,
8357: zx_lines.MANUALLY_ENTERED_FLAG ,
8358: 'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.
8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,
8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,
8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,

Line 8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,

8355: NULL ,
8356: zx_lines.SELF_ASSESSED_FLAG ,
8357: zx_lines.MANUALLY_ENTERED_FLAG ,
8358: 'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.
8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,
8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,
8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,
8363: zx_lines.TAX_EXEMPTION_ID ,

Line 8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,

8356: zx_lines.SELF_ASSESSED_FLAG ,
8357: zx_lines.MANUALLY_ENTERED_FLAG ,
8358: 'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.
8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,
8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,
8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,
8363: zx_lines.TAX_EXEMPTION_ID ,
8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes

Line 8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,

8357: zx_lines.MANUALLY_ENTERED_FLAG ,
8358: 'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.
8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,
8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,
8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,
8363: zx_lines.TAX_EXEMPTION_ID ,
8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
8365: zx_lines.EXEMPT_REASON_CODE ,

Line 8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,

8358: 'A', --substr(zx_lines.LINE_AMT_INCLUDES_TAX_FLAG,1,1) , --Commented V6 Changes.
8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,
8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,
8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,
8363: zx_lines.TAX_EXEMPTION_ID ,
8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
8365: zx_lines.EXEMPT_REASON_CODE ,
8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,

Line 8363: zx_lines.TAX_EXEMPTION_ID ,

8359: zx_lines.TAXABLE_AMT_FUNCL_CURR ,
8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,
8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,
8363: zx_lines.TAX_EXEMPTION_ID ,
8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
8365: zx_lines.EXEMPT_REASON_CODE ,
8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
8367: zx_lines.TAX_REGISTRATION_NUMBER ,

Line 8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes

8360: zx_lines.REC_TAX_AMT_FUNCL_CURR ,
8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,
8363: zx_lines.TAX_EXEMPTION_ID ,
8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
8365: zx_lines.EXEMPT_REASON_CODE ,
8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
8367: zx_lines.TAX_REGISTRATION_NUMBER ,
8368: zx_lines.TAX_HOLD_CODE ,

Line 8365: zx_lines.EXEMPT_REASON_CODE ,

8361: zx_lines.NREC_TAX_AMT_FUNCL_CURR ,
8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,
8363: zx_lines.TAX_EXEMPTION_ID ,
8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
8365: zx_lines.EXEMPT_REASON_CODE ,
8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
8367: zx_lines.TAX_REGISTRATION_NUMBER ,
8368: zx_lines.TAX_HOLD_CODE ,
8369: zx_lines.TAX_HOLD_RELEASED_CODE ,

Line 8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,

8362: zx_lines.TAX_AMT_INCLUDED_FLAG ,
8363: zx_lines.TAX_EXEMPTION_ID ,
8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
8365: zx_lines.EXEMPT_REASON_CODE ,
8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
8367: zx_lines.TAX_REGISTRATION_NUMBER ,
8368: zx_lines.TAX_HOLD_CODE ,
8369: zx_lines.TAX_HOLD_RELEASED_CODE ,
8370: zx_lines.LINE_AMT ,

Line 8367: zx_lines.TAX_REGISTRATION_NUMBER ,

8363: zx_lines.TAX_EXEMPTION_ID ,
8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
8365: zx_lines.EXEMPT_REASON_CODE ,
8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
8367: zx_lines.TAX_REGISTRATION_NUMBER ,
8368: zx_lines.TAX_HOLD_CODE ,
8369: zx_lines.TAX_HOLD_RELEASED_CODE ,
8370: zx_lines.LINE_AMT ,
8371: zx_lines.TAX_JURISDICTION_CODE ,

Line 8368: zx_lines.TAX_HOLD_CODE ,

8364: NULL, -- zx_lines.EXEMPTION_RATE, --Commented for V6 changes
8365: zx_lines.EXEMPT_REASON_CODE ,
8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
8367: zx_lines.TAX_REGISTRATION_NUMBER ,
8368: zx_lines.TAX_HOLD_CODE ,
8369: zx_lines.TAX_HOLD_RELEASED_CODE ,
8370: zx_lines.LINE_AMT ,
8371: zx_lines.TAX_JURISDICTION_CODE ,
8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated

Line 8369: zx_lines.TAX_HOLD_RELEASED_CODE ,

8365: zx_lines.EXEMPT_REASON_CODE ,
8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
8367: zx_lines.TAX_REGISTRATION_NUMBER ,
8368: zx_lines.TAX_HOLD_CODE ,
8369: zx_lines.TAX_HOLD_RELEASED_CODE ,
8370: zx_lines.LINE_AMT ,
8371: zx_lines.TAX_JURISDICTION_CODE ,
8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated

Line 8370: zx_lines.LINE_AMT ,

8366: zx_lines.TAX_APPORTIONMENT_LINE_NUMBER ,
8367: zx_lines.TAX_REGISTRATION_NUMBER ,
8368: zx_lines.TAX_HOLD_CODE ,
8369: zx_lines.TAX_HOLD_RELEASED_CODE ,
8370: zx_lines.LINE_AMT ,
8371: zx_lines.TAX_JURISDICTION_CODE ,
8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
8374: zx_lines.TAX_DETERMINE_DATE ,

Line 8371: zx_lines.TAX_JURISDICTION_CODE ,

8367: zx_lines.TAX_REGISTRATION_NUMBER ,
8368: zx_lines.TAX_HOLD_CODE ,
8369: zx_lines.TAX_HOLD_RELEASED_CODE ,
8370: zx_lines.LINE_AMT ,
8371: zx_lines.TAX_JURISDICTION_CODE ,
8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
8374: zx_lines.TAX_DETERMINE_DATE ,
8375: zx_lines.CANCEL_FLAG ,

Line 8374: zx_lines.TAX_DETERMINE_DATE ,

8370: zx_lines.LINE_AMT ,
8371: zx_lines.TAX_JURISDICTION_CODE ,
8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
8374: zx_lines.TAX_DETERMINE_DATE ,
8375: zx_lines.CANCEL_FLAG ,
8376: zx_lines.EVENT_CLASS_CODE ,
8377: zx_lines.EVENT_TYPE_CODE ,
8378: p_service ,

Line 8375: zx_lines.CANCEL_FLAG ,

8371: zx_lines.TAX_JURISDICTION_CODE ,
8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
8374: zx_lines.TAX_DETERMINE_DATE ,
8375: zx_lines.CANCEL_FLAG ,
8376: zx_lines.EVENT_CLASS_CODE ,
8377: zx_lines.EVENT_TYPE_CODE ,
8378: p_service ,
8379: 'N', --ERROR_FLAG ,

Line 8376: zx_lines.EVENT_CLASS_CODE ,

8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
8374: zx_lines.TAX_DETERMINE_DATE ,
8375: zx_lines.CANCEL_FLAG ,
8376: zx_lines.EVENT_CLASS_CODE ,
8377: zx_lines.EVENT_TYPE_CODE ,
8378: p_service ,
8379: 'N', --ERROR_FLAG ,
8380: g_party_rec.prod_family_grp_code||' LINE' --ERROR_MESSAGE

Line 8377: zx_lines.EVENT_TYPE_CODE ,

8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
8374: zx_lines.TAX_DETERMINE_DATE ,
8375: zx_lines.CANCEL_FLAG ,
8376: zx_lines.EVENT_CLASS_CODE ,
8377: zx_lines.EVENT_TYPE_CODE ,
8378: p_service ,
8379: 'N', --ERROR_FLAG ,
8380: g_party_rec.prod_family_grp_code||' LINE' --ERROR_MESSAGE
8381: FROM ZX_LINES,

Line 8381: FROM ZX_LINES,

8377: zx_lines.EVENT_TYPE_CODE ,
8378: p_service ,
8379: 'N', --ERROR_FLAG ,
8380: g_party_rec.prod_family_grp_code||' LINE' --ERROR_MESSAGE
8381: FROM ZX_LINES,
8382: ZX_RATES_B
8383: WHERE trx_id = p_transaction_id
8384: AND application_id = l_application_id
8385: AND entity_code = l_entity_code

Line 8387: AND zx_lines.tax_rate_id(+) = zx_rates_b.tax_rate_id

8383: WHERE trx_id = p_transaction_id
8384: AND application_id = l_application_id
8385: AND entity_code = l_entity_code
8386: AND event_class_code = l_event_class_code
8387: AND zx_lines.tax_rate_id(+) = zx_rates_b.tax_rate_id
8388: ORDER BY trx_id,
8389: trx_line_id;
8390:
8391:

Line 8393: -- Insert ZX_LINES_SUMMARY data

8389: trx_line_id;
8390:
8391:
8392: --------------------------------------------------
8393: -- Insert ZX_LINES_SUMMARY data
8394: --------------------------------------------------
8395: select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;
8396: write_message('The number of rows in ZX_LINES_SUMMARY for transaction id '
8397: ||to_char(p_transaction_id)||' are '||to_char(l_dummy));

Line 8395: select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;

8391:
8392: --------------------------------------------------
8393: -- Insert ZX_LINES_SUMMARY data
8394: --------------------------------------------------
8395: select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;
8396: write_message('The number of rows in ZX_LINES_SUMMARY for transaction id '
8397: ||to_char(p_transaction_id)||' are '||to_char(l_dummy));
8398:
8399: INSERT INTO ZX_TEST_API_GT(

Line 8396: write_message('The number of rows in ZX_LINES_SUMMARY for transaction id '

8392: --------------------------------------------------
8393: -- Insert ZX_LINES_SUMMARY data
8394: --------------------------------------------------
8395: select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;
8396: write_message('The number of rows in ZX_LINES_SUMMARY for transaction id '
8397: ||to_char(p_transaction_id)||' are '||to_char(l_dummy));
8398:
8399: INSERT INTO ZX_TEST_API_GT(
8400: SUITE_NUMBER ,

Line 8453: zx_lines_summary.TRX_NUMBER ,

8449: ERROR_MESSAGE )
8450: select p_suite ,
8451: p_case ,
8452: p_transaction_id ,
8453: zx_lines_summary.TRX_NUMBER ,
8454: null, --TRX_LINE_NUMBER ,
8455: null, --TRX_DATE ,
8456: null, --TRX_CURRENCY_CODE ,
8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,

Line 8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,

8453: zx_lines_summary.TRX_NUMBER ,
8454: null, --TRX_LINE_NUMBER ,
8455: null, --TRX_DATE ,
8456: null, --TRX_CURRENCY_CODE ,
8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,
8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,

Line 8459: zx_lines_summary.TAX_REGIME_CODE ,

8455: null, --TRX_DATE ,
8456: null, --TRX_CURRENCY_CODE ,
8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,
8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,

Line 8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.

8456: null, --TRX_CURRENCY_CODE ,
8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,
8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,

Line 8461: zx_lines_summary.TAX ,

8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,
8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,

Line 8462: zx_lines_summary.TAX_STATUS_CODE ,

8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,

Line 8463: zx_lines_summary.TAX_RATE_ID ,

8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,

Line 8464: zx_lines_summary.TAX_RATE_CODE ,

8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,

Line 8465: zx_lines_summary.TAX_RATE ,

8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,

Line 8466: zx_lines_summary.TAX_AMT ,

8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,

Line 8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,

8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,

Line 8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,

8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,

Line 8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,

8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,

Line 8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,

8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,
8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,

Line 8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,

8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,
8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,
8478: null, --TAXABLE_AMT_FUNCL_CURR ,

Line 8475: zx_lines_summary.SELF_ASSESSED_FLAG ,

8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,
8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,
8478: null, --TAXABLE_AMT_FUNCL_CURR ,
8479: null, --REC_TAX_AMT_FUNCL_CURR ,

Line 8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,

8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,
8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,
8478: null, --TAXABLE_AMT_FUNCL_CURR ,
8479: null, --REC_TAX_AMT_FUNCL_CURR ,
8480: null, --NREC_TAX_AMT_FUNCL_CURR ,

Line 8481: zx_lines_summary.TAX_AMT_INCLUDED_FLAG ,

8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,
8478: null, --TAXABLE_AMT_FUNCL_CURR ,
8479: null, --REC_TAX_AMT_FUNCL_CURR ,
8480: null, --NREC_TAX_AMT_FUNCL_CURR ,
8481: zx_lines_summary.TAX_AMT_INCLUDED_FLAG ,
8482: null, --TAX_EXEMPTION_ID ,
8483: null, --EXEMPTION_RATE ,
8484: null, --EXEMPT_REASON_CODE ,
8485: null, --TAX_APPORTIONMENT_LINE_NUMBER ,

Line 8490: zx_lines_summary.TAX_JURISDICTION_CODE ,

8486: null, --TAX_REGISTRATION_NUMBER ,
8487: null, --TAX_HOLD_CODE ,
8488: null, --TAX_HOLD_RELEASED_CODE ,
8489: null, --LINE_AMT ,
8490: zx_lines_summary.TAX_JURISDICTION_CODE ,
8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
8493: null, --TAX_DETERMINE_DATE ,
8494: zx_lines_summary.CANCEL_FLAG ,

Line 8494: zx_lines_summary.CANCEL_FLAG ,

8490: zx_lines_summary.TAX_JURISDICTION_CODE ,
8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
8493: null, --TAX_DETERMINE_DATE ,
8494: zx_lines_summary.CANCEL_FLAG ,
8495: zx_lines_summary.EVENT_CLASS_CODE ,
8496: null, --EVENT_TYPE_CODE ,
8497: p_service ,
8498: 'N', --ERROR_FLAG ,

Line 8495: zx_lines_summary.EVENT_CLASS_CODE ,

8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
8493: null, --TAX_DETERMINE_DATE ,
8494: zx_lines_summary.CANCEL_FLAG ,
8495: zx_lines_summary.EVENT_CLASS_CODE ,
8496: null, --EVENT_TYPE_CODE ,
8497: p_service ,
8498: 'N', --ERROR_FLAG ,
8499: g_party_rec.prod_family_grp_code||' SUMMARY' --ERROR_MESSAGE

Line 8500: FROM ZX_LINES_SUMMARY,

8496: null, --EVENT_TYPE_CODE ,
8497: p_service ,
8498: 'N', --ERROR_FLAG ,
8499: g_party_rec.prod_family_grp_code||' SUMMARY' --ERROR_MESSAGE
8500: FROM ZX_LINES_SUMMARY,
8501: ZX_RATES_B
8502: WHERE trx_id = p_transaction_id
8503: AND application_id = l_application_id
8504: AND entity_code = l_entity_code

Line 8506: AND zx_lines_summary.tax_rate_id(+) = zx_rates_b.tax_rate_id;

8502: WHERE trx_id = p_transaction_id
8503: AND application_id = l_application_id
8504: AND entity_code = l_entity_code
8505: AND event_class_code = l_event_class_code
8506: AND zx_lines_summary.tax_rate_id(+) = zx_rates_b.tax_rate_id;
8507:
8508:
8509: --------------------------------------------------
8510: -- Insert ZX_REC_NREC_DIST data

Line 9351: FROM zx_lines l

9347: (SELECT
9348: REC_NREC_TAX_DIST_ID
9349: FROM zx_rec_nrec_dist
9350: WHERE tax_id in (SELECT tax_id
9351: FROM zx_lines l
9352: WHERE l.application_id = g_suite_rec_tbl.APPLICATION_ID(i)
9353: AND l.entity_code = g_suite_rec_tbl.ENTITY_CODE(i)
9354: AND l.event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(i)
9355: AND l.trx_id = g_suite_rec_tbl.TRX_ID(i)

Line 9429: FROM zx_lines l

9425: (SELECT
9426: REC_NREC_TAX_DIST_ID
9427: FROM zx_rec_nrec_dist
9428: WHERE tax_id in (SELECT tax_id
9429: FROM zx_lines l
9430: WHERE l.application_id = g_suite_rec_tbl.APPLICATION_ID(i)
9431: AND l.entity_code = g_suite_rec_tbl.ENTITY_CODE(i)
9432: AND l.event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(i)
9433: AND l.trx_id = g_suite_rec_tbl.TRX_ID(i)