DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on PO_CHG_REQUEST_SEQ

Line 165: select po_chg_request_seq.nextval

161: v_req_grp_id := null;
162: end;
163: end if;
164: /* if v_req_grp_id is null then
165: select po_chg_request_seq.nextval
166: into v_req_grp_id
167: from dual;
168: end if; */
169: return v_req_grp_id;

Line 614: select po_chg_request_seq.nextval

610: end if;
611:
612: v_request_group_id := getRequestGroupId(p_po_header_id,p_po_release_id,v_document_type);
613: IF(v_request_group_id is null) THEN
614: select po_chg_request_seq.nextval
615: into v_request_group_id
616: from dual;
617: END IF;
618: x_request_group_id := v_request_group_id;

Line 651: values (x_request_group_id,po_chg_request_seq.nextval,

647: SUPPLIER_DOC_REF, SUPPLIER_LINE_REF, SUPPLIER_SHIPMENT_REF, --added in FPJ for splits.
648: NEW_PROGRESS_TYPE,NEW_PAY_DESCRIPTION --<< Complex work changes for R12 >>
649:
650: )
651: values (x_request_group_id,po_chg_request_seq.nextval,
652: p_po_change_requests(i).initiator,
653: p_po_change_requests(i).action_type,
654: p_po_change_requests(i).request_reason,
655: p_po_change_requests(i).request_level,