DBA Data[Home] [Help]

APPS.PO_MODIFY_REQUISITION_PVT dependencies on PON_CLO_RENUMBER_PKG

Line 591: l_next_clin_number := PON_CLO_RENUMBER_PKG.NEXT_CLIN_NUM_WRAPPER(l_temp_req_header_id, 'ICX');

587: IF l_line_num_index = 1
588: THEN
589: -- copy L_REQUISITION_LINE_ID into l_req_line_id_temp and compute the l_next_clin_number
590: l_req_line_id_temp:=l_requisition_line_id;
591: l_next_clin_number := PON_CLO_RENUMBER_PKG.NEXT_CLIN_NUM_WRAPPER(l_temp_req_header_id, 'ICX');
592: l_next_slin_number:=NULL;
593: -- copy the quantity of the new line into l_quantity
594: l_quantity:=p_quantity_tbl(1);
595: ELSE

Line 604: l_next_clin_number := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_clin_number);

600: --in the parent line and if Create new Line was considered then
601: --for l_new_clin_number=1 line_num_index=2 and
602: --for l_new_clin_number=2 line_num_index=3.
603: l_req_line_id_temp:=l_requisition_line_id;
604: l_next_clin_number := PON_CLO_RENUMBER_PKG.INCREMENT_CLIN_NUMBER(l_next_clin_number);
605: l_next_slin_number:=NULL;
606: l_quantity:=p_quantity_tbl(l_new_clin_number+1);
607: END IF;
608: -- copy the l_group_id_temp to l_grp_id and l_next_clin_number to l_display_number.

Line 619: l_next_slin_number := PON_CLO_RENUMBER_PKG.GETNEXTSLINNUMBER('ICX',l_temp_req_header_id,l_parent_clin_number,l_clm_info_flag );

615: THEN
616: IF l_line_num_index = 1
617: THEN
618: l_req_line_id_temp:=l_requisition_line_id;
619: l_next_slin_number := PON_CLO_RENUMBER_PKG.GETNEXTSLINNUMBER('ICX',l_temp_req_header_id,l_parent_clin_number,l_clm_info_flag );
620: l_quantity:=P_QUANTITY_TBL(1);
621: l_slin_number_temp:=l_next_slin_number;
622: ELSE
623: l_req_line_id_temp:=l_requisition_line_id;

Line 624: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_PRICED_SLIN_NUMBER(l_slin_number_temp);

620: l_quantity:=P_QUANTITY_TBL(1);
621: l_slin_number_temp:=l_next_slin_number;
622: ELSE
623: l_req_line_id_temp:=l_requisition_line_id;
624: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_PRICED_SLIN_NUMBER(l_slin_number_temp);
625: l_slin_number_temp:=l_next_slin_number;
626: l_quantity:=P_QUANTITY_TBL(l_new_clin_number+1);
627: END IF;
628: l_display_number:=l_next_slin_number;

Line 644: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);

640: l_req_line_id_temp:=l_slin_array(l_line_num_index-1);
641: IF l_line_num_index=2
642: THEN
643:
644: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);
645: -- copy the req_line_id of the clin to the l_grp_id of the Info SLins
646: l_grp_id:=l_new_requisition_line_Id;
647: ELSE
648: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);

Line 648: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);

644: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);
645: -- copy the req_line_id of the clin to the l_grp_id of the Info SLins
646: l_grp_id:=l_new_requisition_line_Id;
647: ELSE
648: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);
649: END IF;
650: -- for the 2nd new Clin's associated SLins
651: ELSif l_line_num_index >(l_number_of_slins+1)+1 and l_line_num_index<2*(l_number_of_slins+1)+1 then
652:

Line 657: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);

653: l_req_line_id_temp:=l_slin_array(l_line_num_index-(l_number_of_slins+1)-1);
654: IF l_line_num_index=(l_number_of_slins+1)+2
655: THEN
656:
657: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);
658: l_grp_id:=l_new_requisition_line_Id;
659: ELSE
660: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);
661: END IF;

Line 660: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);

656:
657: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);
658: l_grp_id:=l_new_requisition_line_Id;
659: ELSE
660: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);
661: END IF;
662: -- when create new line is selected
663: ELSif l_line_num_index >2*(l_number_of_slins+1)+1 and l_line_num_index<3*(l_number_of_slins+1)+1 then
664: l_req_line_id_temp:=l_slin_array(l_line_num_index-2*(l_number_of_slins+1)-1);

Line 668: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);

664: l_req_line_id_temp:=l_slin_array(l_line_num_index-2*(l_number_of_slins+1)-1);
665: IF l_line_num_index=2*(l_number_of_slins+1)+2
666: THEN
667:
668: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);
669: l_grp_id:=l_new_requisition_line_Id;
670: ELSE
671: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);
672: END IF;

Line 671: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);

667:
668: l_next_slin_number :=PON_CLO_RENUMBER_PKG.FIRST_INFO_SLIN_NUMBER(l_next_clin_number);
669: l_grp_id:=l_new_requisition_line_Id;
670: ELSE
671: l_next_slin_number := PON_CLO_RENUMBER_PKG.INCREMENT_INFO_SLIN_NUMBER(l_next_slin_number);
672: END IF;
673:
674: END IF;
675: -- quantity of the info slins is null.