DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PON_CLO_RENUMBER_PKG

Line 3789: -- Make a call to PON_CLO_RENUMBER_PKG to get the next CLIN number

3785:
3786: -- Loop through and assign line numbers sequentially to each
3787: -- req line starting from the max line number derived above.
3788:
3789: -- Make a call to PON_CLO_RENUMBER_PKG to get the next CLIN number
3790: l_next_line_num := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_max_line_num);
3791:
3792: -- First initialize the CLIN numbers
3793: FOR i IN p_start_index..p_end_index

Line 3790: l_next_line_num := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_max_line_num);

3786: -- Loop through and assign line numbers sequentially to each
3787: -- req line starting from the max line number derived above.
3788:
3789: -- Make a call to PON_CLO_RENUMBER_PKG to get the next CLIN number
3790: l_next_line_num := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_max_line_num);
3791:
3792: -- First initialize the CLIN numbers
3793: FOR i IN p_start_index..p_end_index
3794: LOOP

Line 3802: -- Make a call to PON_CLO_RENUMBER_PKG to get the next CLIN number

3798:
3799: l_next_info_slin_num := l_next_line_num ||'01';
3800: l_next_priced_slin_num := l_next_line_num ||'AA';
3801:
3802: -- Make a call to PON_CLO_RENUMBER_PKG to get the next CLIN number
3803:
3804: l_next_line_num := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_line_num);
3805:
3806: For j IN p_start_index..p_end_index

Line 3804: l_next_line_num := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_line_num);

3800: l_next_priced_slin_num := l_next_line_num ||'AA';
3801:
3802: -- Make a call to PON_CLO_RENUMBER_PKG to get the next CLIN number
3803:
3804: l_next_line_num := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_line_num);
3805:
3806: For j IN p_start_index..p_end_index
3807: Loop
3808:

Line 3814: l_next_info_slin_num := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_info_slin_num);

3810: IF p_req_clm_info_flag_tbl(j)='Y' then
3811:
3812: x_po_line_num_tbl(j) := l_next_info_slin_num;
3813: -- Make a call to package to get next info slin number
3814: l_next_info_slin_num := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_info_slin_num);
3815:
3816: ELSE
3817: x_po_line_num_tbl(j) := l_next_priced_slin_num;
3818: -- Make a call to package to get next priced slin number

Line 3819: l_next_priced_slin_num := PON_CLO_RENUMBER_PKG.INCREMENT_PRICED_SLIN_NUMBER(l_next_priced_slin_num);

3815:
3816: ELSE
3817: x_po_line_num_tbl(j) := l_next_priced_slin_num;
3818: -- Make a call to package to get next priced slin number
3819: l_next_priced_slin_num := PON_CLO_RENUMBER_PKG.INCREMENT_PRICED_SLIN_NUMBER(l_next_priced_slin_num);
3820: END IF;
3821:
3822: end if;
3823: end loop;

Line 5074: l_current_slin := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_current_slin);

5070: l_current_slin := l_max_slin_num;
5071:
5072: FOR i IN 1..p_req_group_line_id_tbl.Count LOOP
5073: IF (p_req_group_line_id_tbl(i) IS NOT NULL AND p_req_group_line_id_tbl(i) = p_req_line_id) THEN
5074: l_current_slin := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_current_slin);
5075: l_po_line_num_tbl(i) := l_current_slin;
5076: END IF;
5077: END LOOP;
5078: END IF;

Line 5241: l_next_clin_num_disp := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_max_line_num_disp);

5237:
5238: END IF;
5239:
5240: -- Get the next line num display for a CLIN
5241: l_next_clin_num_disp := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_max_line_num_disp);
5242:
5243: l_action_tbl := PO_AUTOCREATE_GROUPING_PVT.get_line_action_tbl(p_po_line_num_tbl,
5244: p_add_to_po_header_id,
5245: p_draft_id);

Line 5290: l_next_clin_num_disp := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_clin_num_disp);

5286: END IF;
5287:
5288: END LOOP;
5289:
5290: l_next_clin_num_disp := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_clin_num_disp);
5291:
5292: END IF;
5293: END IF;
5294: END LOOP;

Line 5343: l_next_clin_num_disp := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_max_line_num_disp);

5339:
5340: END IF;
5341:
5342: -- Get the next line num display for a CLIN
5343: l_next_clin_num_disp := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_max_line_num_disp);
5344:
5345: l_action_tbl := PO_AUTOCREATE_GROUPING_PVT.get_line_action_tbl(p_neg_line_num_tbl,
5346: p_add_to_neg_header_id,
5347: p_draft_id);

Line 5392: l_next_clin_num_disp := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_clin_num_disp);

5388: END IF;
5389:
5390: END LOOP;
5391:
5392: l_next_clin_num_disp := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_clin_num_disp);
5393:
5394: END IF;
5395: END IF;
5396: END LOOP;

Line 5605: l_next_info_slin_num := pon_clo_renumber_pkg.INCREMENT_INFO_SLIN_NUMBER(l_next_info_slin_num);

5601: )
5602: LOOP
5603: IF rec.char5 = 'Y' THEN -- info slin
5604: l_next_slin_num := l_next_info_slin_num;
5605: l_next_info_slin_num := pon_clo_renumber_pkg.INCREMENT_INFO_SLIN_NUMBER(l_next_info_slin_num);
5606:
5607: ELSE --priced slin
5608: l_next_slin_num := l_next_priced_slin_num;
5609: l_next_priced_slin_num := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(l_next_priced_slin_num);

Line 5609: l_next_priced_slin_num := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(l_next_priced_slin_num);

5605: l_next_info_slin_num := pon_clo_renumber_pkg.INCREMENT_INFO_SLIN_NUMBER(l_next_info_slin_num);
5606:
5607: ELSE --priced slin
5608: l_next_slin_num := l_next_priced_slin_num;
5609: l_next_priced_slin_num := pon_clo_renumber_pkg.INCREMENT_PRICED_SLIN_NUMBER(l_next_priced_slin_num);
5610: END IF;
5611:
5612: update po_session_gt
5613: set char1 = l_next_slin_num