DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on DUAL

Line 167: from dual;

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;
170: END;
171:

Line 513: from dual;

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;
516: END IF;
517:

Line 2317: from dual;

2313: else
2314: -- This means a split shipment pass back PENDING
2315: select FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE')
2316: into x_msg_display
2317: from dual;
2318:
2319: x_msg_code :='PENDING_CHANGE';
2320: end if;
2321: