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 511: select po_chg_request_seq.nextval

507: end if;
508:
509: v_request_group_id := getRequestGroupId(p_po_header_id,p_po_release_id,v_document_type);
510: IF(v_request_group_id is null) THEN
511: select po_chg_request_seq.nextval
512: into v_request_group_id
513: from dual;
514: END IF;
515: x_request_group_id := v_request_group_id;

Line 548: values (x_request_group_id,po_chg_request_seq.nextval,

544: SUPPLIER_DOC_REF, SUPPLIER_LINE_REF, SUPPLIER_SHIPMENT_REF, --added in FPJ for splits.
545: NEW_PROGRESS_TYPE,NEW_PAY_DESCRIPTION --<< Complex work changes for R12 >>
546:
547: )
548: values (x_request_group_id,po_chg_request_seq.nextval,
549: p_po_change_requests(i).initiator,
550: p_po_change_requests(i).action_type,
551: p_po_change_requests(i).request_reason,
552: p_po_change_requests(i).request_level,