DBA Data[Home] [Help]

APPS.ZX_TEST_API dependencies on ZX_TRL_ALLOCATIONS_PKG

Line 6111: write_message('Calling zx_trl_allocations_pkg.insert_row');

6107: write_message('x_msg_data : '||l_msg_data );
6108:
6109:
6110: FOR i IN l_start_row..l_end_row LOOP
6111: write_message('Calling zx_trl_allocations_pkg.insert_row');
6112:
6113: zx_trl_allocations_pkg.insert_row(
6114: X_ROWID => l_row_id ,
6115: P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,

Line 6113: zx_trl_allocations_pkg.insert_row(

6109:
6110: FOR i IN l_start_row..l_end_row LOOP
6111: write_message('Calling zx_trl_allocations_pkg.insert_row');
6112:
6113: zx_trl_allocations_pkg.insert_row(
6114: X_ROWID => l_row_id ,
6115: P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
6116: P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),
6117: P_APPLICATION_ID => g_suite_rec_tbl.application_id(i) ,

Line 6168: write_message('Service zx_trl_allocations_pkg.Insert_row has been called!.');

6164: P_LAST_UPDATE_DATE => sysdate , -- Review this later.
6165: P_LAST_UPDATE_LOGIN => 1 ); ---------------------------------
6166:
6167: END LOOP;
6168: write_message('Service zx_trl_allocations_pkg.Insert_row has been called!.');
6169: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
6170: write_message('x_return_status : '||l_return_status);
6171: write_message('x_msg_count : '||l_msg_count );
6172: write_message('x_msg_data : '||l_msg_data );

Line 6175: -- Note: ZX_TRL_ALLOCATIONS_PKG.UPDATE_ROW and

6171: write_message('x_msg_count : '||l_msg_count );
6172: write_message('x_msg_data : '||l_msg_data );
6173:
6174: -----------------------------------------------------------------------
6175: -- Note: ZX_TRL_ALLOCATIONS_PKG.UPDATE_ROW and
6176: -- ZX_TRL_ALLOCATIONS_PKG.LOCK_ROWS and
6177: -- ZX_TRL_ALLOCATIONS_PKG.DELETE_ROW have been removed in TRL pkg
6178: -- 10-DEC-2004
6179: -----------------------------------------------------------------------

Line 6176: -- ZX_TRL_ALLOCATIONS_PKG.LOCK_ROWS and

6172: write_message('x_msg_data : '||l_msg_data );
6173:
6174: -----------------------------------------------------------------------
6175: -- Note: ZX_TRL_ALLOCATIONS_PKG.UPDATE_ROW and
6176: -- ZX_TRL_ALLOCATIONS_PKG.LOCK_ROWS and
6177: -- ZX_TRL_ALLOCATIONS_PKG.DELETE_ROW have been removed in TRL pkg
6178: -- 10-DEC-2004
6179: -----------------------------------------------------------------------
6180:

Line 6177: -- ZX_TRL_ALLOCATIONS_PKG.DELETE_ROW have been removed in TRL pkg

6173:
6174: -----------------------------------------------------------------------
6175: -- Note: ZX_TRL_ALLOCATIONS_PKG.UPDATE_ROW and
6176: -- ZX_TRL_ALLOCATIONS_PKG.LOCK_ROWS and
6177: -- ZX_TRL_ALLOCATIONS_PKG.DELETE_ROW have been removed in TRL pkg
6178: -- 10-DEC-2004
6179: -----------------------------------------------------------------------
6180:
6181: /* FOR i in l_start_row..l_end_row LOOP

Line 6182: zx_trl_allocations_pkg.lock_row

6178: -- 10-DEC-2004
6179: -----------------------------------------------------------------------
6180:
6181: /* FOR i in l_start_row..l_end_row LOOP
6182: zx_trl_allocations_pkg.lock_row
6183: (
6184: X_ROWID => l_row_id,
6185: P_CREATED_BY => 1 , ------------------------------
6186: P_CREATION_DATE => sysdate , -- What are to correct values

Line 6192: write_message('Service zx_trl_allocations_pkg.lock_row has been called!.');

6188: P_LAST_UPDATE_DATE => sysdate , ------------------------------
6189: P_LAST_UPDATE_LOGIN => 1
6190: ); null;
6191: END LOOP;
6192: write_message('Service zx_trl_allocations_pkg.lock_row has been called!.');
6193: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
6194: write_message('x_return_status : '||l_return_status);
6195: write_message('x_msg_count : '||l_msg_count );
6196: write_message('x_msg_data : '||l_msg_data );

Line 6200: zx_trl_allocations_pkg.Update_row

6196: write_message('x_msg_data : '||l_msg_data );
6197:
6198:
6199: FOR i IN l_start_row..l_end_row LOOP
6200: zx_trl_allocations_pkg.Update_row
6201: (
6202: X_ROWID => l_row_id ,
6203: P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
6204: P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i) ,

Line 6227: write_message('Service zx_trl_allocations_pkg.Update_row has been called!.');

6223: ); null;
6224:
6225:
6226: END LOOP;
6227: write_message('Service zx_trl_allocations_pkg.Update_row has been called!.');
6228: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
6229: write_message('x_return_status : '||l_return_status);
6230: write_message('x_msg_count : '||l_msg_count );
6231: write_message('x_msg_data : '||l_msg_data );

Line 6234: zx_trl_allocations_pkg.Delete_row

6230: write_message('x_msg_count : '||l_msg_count );
6231: write_message('x_msg_data : '||l_msg_data );
6232:
6233: FOR i in l_start_row..l_end_row LOOP
6234: zx_trl_allocations_pkg.Delete_row
6235: (
6236: X_ROWID => l_row_id ,
6237: P_SUMMARY_TAX_LINE_ID => g_suite_rec_tbl.summary_tax_line_id(i) ,
6238: P_INTERNAL_ORGANIZATION_ID => g_suite_rec_tbl.internal_organization_id(i),

Line 6247: write_message('Service zx_trl_allocations_pkg.Delete_row has been called!.');

6243: P_TRX_ID => g_suite_rec_tbl.trx_id(i)
6244: );
6245:
6246: END LOOP;
6247: write_message('Service zx_trl_allocations_pkg.Delete_row has been called!.');
6248: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
6249: write_message('x_return_status : '||l_return_status);
6250: write_message('x_msg_count : '||l_msg_count );
6251: write_message('x_msg_data : '||l_msg_data );

Line 6537: write_message('Service zx_trl_allocations_pkg.Delete_row has been called!.');

6533: null;
6534:
6535: END LOOP;
6536:
6537: write_message('Service zx_trl_allocations_pkg.Delete_row has been called!.');
6538: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
6539: write_message('x_return_status : '||l_return_status);
6540: write_message('x_msg_count : '||l_msg_count );
6541: write_message('x_msg_data : '||l_msg_data );