DBA Data[Home] [Help]

APPS.ZX_TEST_API dependencies on ZX_TRL_DETAIL_OVERRIDE_PKG

Line 4592: zx_trl_detail_override_pkg.Insert_row (

4588: x_end_row => l_end_row
4589: );
4590:
4591: FOR i IN l_start_row..l_end_row LOOP
4592: zx_trl_detail_override_pkg.Insert_row (
4593: X_ROWID => l_row_id ,
4594: P_TAX_LINE_ID => null ,
4595: P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
4596: P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,

Line 4925: /* For Lock Row V7 changes I didn't find following columns zx_trl_detail_override_pkg.Lock_row

4921: x_start_row => l_start_row,
4922: x_end_row => l_end_row
4923: );
4924:
4925: /* For Lock Row V7 changes I didn't find following columns zx_trl_detail_override_pkg.Lock_row
4926: P_EXEMPTION_RATE => g_suite_rec_tbl.exemption_rate(i) ,
4927: P_EXEMPT_CERTIFICATE_NUMBER => g_suite_rec_tbl.exempt_certificate_number(i),
4928: P_EXEMPT_REASON_CODE => g_suite_rec_tbl.exempt_reason_code(i) , */
4929:

Line 4943: zx_trl_detail_override_pkg.Lock_row (

4939: and trx_line_id = g_suite_rec_tbl.trx_line_id(i)
4940: and trx_level_type = g_suite_rec_tbl.trx_level_type(i)
4941: and tax_line_id = g_suite_rec_tbl.tax_line_id(i) ;
4942:
4943: zx_trl_detail_override_pkg.Lock_row (
4944: X_ROWID => l_row_id ,
4945: P_TAX_LINE_ID => g_suite_rec_tbl.tax_line_id(i) ,
4946: P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
4947: P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,

Line 5273: zx_trl_detail_override_pkg.Update_row(

5269: and trx_line_id = g_suite_rec_tbl.trx_line_id(i)
5270: and trx_level_type = g_suite_rec_tbl.trx_level_type(i)
5271: and tax_line_id = g_suite_rec_tbl.tax_line_id(i) ;
5272:
5273: zx_trl_detail_override_pkg.Update_row(
5274: --X_ROWID => l_row_id ,
5275: P_TAX_LINE_ID => g_suite_rec_tbl.tax_line_id(i) ,
5276: P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
5277: P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,

Line 5592: write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_row/Update_row have been called!.');

5588: P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
5589:
5590: END LOOP;
5591:
5592: write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Lock_row/Update_row have been called!.');
5593: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
5594: write_message('x_return_status : '||l_return_status);
5595: write_message('x_msg_count : '||l_msg_count );
5596: write_message('x_msg_data : '||l_msg_data );

Line 5613: /* In V7 Changes for ZX_TRL_DETAIL_OVERRIDE_PKG.delete_row

5609: x_end_row => l_end_row
5610: );
5611:
5612:
5613: /* In V7 Changes for ZX_TRL_DETAIL_OVERRIDE_PKG.delete_row
5614: P_EXEMPTION_RATE => g_suite_rec_tbl.exemption_rate(i)
5615: is no longer there*/
5616:
5617: FOR i in l_start_row..l_end_row LOOP

Line 5629: ZX_TRL_DETAIL_OVERRIDE_PKG.delete_row(

5625: and trx_line_id = g_suite_rec_tbl.trx_line_id(i)
5626: and trx_level_type = g_suite_rec_tbl.trx_level_type(i)
5627: and tax_line_id = g_suite_rec_tbl.tax_line_id(i) ;
5628:
5629: ZX_TRL_DETAIL_OVERRIDE_PKG.delete_row(
5630: X_ROWID => l_row_id ,
5631: P_TAX_LINE_ID => g_suite_rec_tbl.tax_line_id(i) ,
5632: P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
5633: P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,

Line 5946: write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row has been called!.');

5942: P_LAST_UPDATE_DATE => sysdate, -- Review this later.
5943: P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
5944:
5945: END LOOP;
5946: write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row has been called!.');
5947: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
5948: write_message('x_return_status : '||l_return_status);
5949: write_message('x_msg_count : '||l_msg_count );
5950: write_message('x_msg_data : '||l_msg_data );

Line 6103: write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row has been called!.');

6099: P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
6100:
6101:
6102: END LOOP;
6103: write_message('Service ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row has been called!.');
6104: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
6105: write_message('x_return_status : '||l_return_status);
6106: write_message('x_msg_count : '||l_msg_count );
6107: write_message('x_msg_data : '||l_msg_data );