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) ,
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) ,
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 );
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: -----------------------------------------------------------------------
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:
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
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
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 );
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) ,
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 );
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),
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 );
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 );