APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_CLO_RENUMBER_PKG

Line 1292: * the same value is passed to pon_clo_renumber_pkg.next_clin_num only one line

1288:
1289: /* Bug 9378884 - Start
1290: * When the last batch runs i.e., from 7501-9999 the below query will retrun
1291: * 9999 as the table pon_auction_item_prices_all will have 9999 records. When
1292: * the same value is passed to pon_clo_renumber_pkg.next_clin_num only one line
1293: * will be processed as per the algorithm written in that procedure. Hence added
1294: * line_num_display is not null condition to the query so that processing of the
1295: * next batch will start from the last row.
1296: * Eg: 0 for first batch

Line 1319: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);

1315:
1316:
1317: BEGIN
1318: FOR upd_row IN update_clin_num_cursor LOOP
1319: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);
1320:
1321: UPDATE pon_auction_item_prices_all
1322: SET line_num_display = next_clin_num
1323: WHERE auction_header_id = upd_row.auction_header_id

Line 1330: pon_clo_renumber_pkg.RenumberSlinStructure('PON',g_auction_header_id,next_clin_num,x_result);

1326: clin_num_tbl.extend();
1327: len := clin_num_tbl.Count ;
1328: clin_num_tbl(len) := next_clin_num;
1329:
1330: pon_clo_renumber_pkg.RenumberSlinStructure('PON',g_auction_header_id,next_clin_num,x_result);
1331:
1332: END LOOP;
1333: EXCEPTION
1334: WHEN OTHERS THEN