DBA Data[Home] [Help]

APPS.PO_REQS_INQ_SV dependencies on PO_INQ_SV

Line 158: x_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer);

154: x_preparer_name OUT NOCOPY VARCHAR2 ) IS
155: BEGIN
156:
157: IF x_preparer IS NOT NULL THEN
158: x_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer);
159: END IF;
160:
161: IF x_req_num IS NOT NULL THEN
162: x_reserved_flag := PO_REQS_INQ_SV.GET_RESERVED_FLAG (x_req_num);

Line 220: v_requestor := PO_INQ_SV.GET_PERSON_NAME(x_to_person_id);

216: v_bom_department_code := NULL;
217:
218:
219: IF x_to_person_id IS NOT NULL THEN
220: v_requestor := PO_INQ_SV.GET_PERSON_NAME(x_to_person_id);
221: END IF;
222:
223: IF x_suggested_buyer_id IS NOT NULL THEN
224: v_suggested_buyer := PO_INQ_SV.GET_PERSON_NAME(x_suggested_buyer_id);

Line 224: v_suggested_buyer := PO_INQ_SV.GET_PERSON_NAME(x_suggested_buyer_id);

220: v_requestor := PO_INQ_SV.GET_PERSON_NAME(x_to_person_id);
221: END IF;
222:
223: IF x_suggested_buyer_id IS NOT NULL THEN
224: v_suggested_buyer := PO_INQ_SV.GET_PERSON_NAME(x_suggested_buyer_id);
225: END IF;
226:
227: IF x_wip_entity_id IS NOT NULL THEN
228:

Line 229: v_assembly_quantity := NVL(PO_INQ_SV.GET_ASSEMBLY_QUANTITY(x_item_id,

225: END IF;
226:
227: IF x_wip_entity_id IS NOT NULL THEN
228:
229: v_assembly_quantity := NVL(PO_INQ_SV.GET_ASSEMBLY_QUANTITY(x_item_id,
230: x_wip_entity_id,
231: x_wip_operation_seq_num,
232: x_wip_resource_seq_num,
233: x_destination_organization_id,

Line 237: v_resource_quantity := NVL(PO_INQ_SV.GET_RESOURCE_QUANTITY(x_item_id,

233: x_destination_organization_id,
234: x_wip_repetitive_schedule_id,
235: x_quantity),0);
236:
237: v_resource_quantity := NVL(PO_INQ_SV.GET_RESOURCE_QUANTITY(x_item_id,
238: x_wip_entity_id,
239: x_wip_operation_seq_num,
240: x_wip_resource_seq_num,
241: x_destination_organization_id,

Line 245: v_wip_operation_code := PO_INQ_SV.GET_WIP_OPERATION_CODE(x_wip_entity_id,

241: x_destination_organization_id,
242: x_wip_repetitive_schedule_id,
243: x_quantity),0);
244:
245: v_wip_operation_code := PO_INQ_SV.GET_WIP_OPERATION_CODE(x_wip_entity_id,
246: x_wip_operation_seq_num,
247: x_destination_organization_id,
248: x_wip_repetitive_schedule_id);
249:

Line 250: v_bom_department_code := PO_INQ_SV.GET_BOM_DEPARTMENT_CODE(x_wip_entity_id,

246: x_wip_operation_seq_num,
247: x_destination_organization_id,
248: x_wip_repetitive_schedule_id);
249:
250: v_bom_department_code := PO_INQ_SV.GET_BOM_DEPARTMENT_CODE(x_wip_entity_id,
251: x_wip_operation_seq_num,
252: x_destination_organization_id,
253: x_wip_repetitive_schedule_id);
254:

Line 258: v_purchasing_agent_name_dsp := PO_INQ_SV.GET_PERSON_NAME(x_purchasing_agent_id);

254:
255: END IF;
256:
257: IF x_purchasing_agent_id IS NOT NULL THEN
258: v_purchasing_agent_name_dsp := PO_INQ_SV.GET_PERSON_NAME(x_purchasing_agent_id);
259: END IF;
260:
261: IF x_preparer_id IS NOT NULL THEN
262: v_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer_id);

Line 262: v_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer_id);

258: v_purchasing_agent_name_dsp := PO_INQ_SV.GET_PERSON_NAME(x_purchasing_agent_id);
259: END IF;
260:
261: IF x_preparer_id IS NOT NULL THEN
262: v_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer_id);
263: END IF;
264:
265: IF x_blanket_po_header_id IS NOT NULL THEN
266: v_blanket_po_num_dsp := PO_REQS_INQ_SV.GET_PO_NUMBER(x_blanket_po_header_id);

Line 272: v_order_num := PO_INQ_SV.GET_PO_NUMBER(x_line_location_id);

268: END IF;
269:
270:
271: IF (x_source_type_code = 'VENDOR') THEN
272: v_order_num := PO_INQ_SV.GET_PO_NUMBER(x_line_location_id);
273: ELSE
274:
275: --Bug# 1392077
276: --Toju George 08/31/2000

Line 278: /* v_order_num := PO_INQ_SV.GET_SO_NUMBER(x_segment1,x_line_num);*/

274:
275: --Bug# 1392077
276: --Toju George 08/31/2000
277: --Modified the call to procedure to replace req_num and line_num with ids.
278: /* v_order_num := PO_INQ_SV.GET_SO_NUMBER(x_segment1,x_line_num);*/
279:
280: v_order_num := PO_INQ_SV.GET_SO_NUMBER(x_requisition_header_id,x_requsition_line_id);
281: END IF;
282:

Line 280: v_order_num := PO_INQ_SV.GET_SO_NUMBER(x_requisition_header_id,x_requsition_line_id);

276: --Toju George 08/31/2000
277: --Modified the call to procedure to replace req_num and line_num with ids.
278: /* v_order_num := PO_INQ_SV.GET_SO_NUMBER(x_segment1,x_line_num);*/
279:
280: v_order_num := PO_INQ_SV.GET_SO_NUMBER(x_requisition_header_id,x_requsition_line_id);
281: END IF;
282:
283: -- SERVICES FPJ
284: -- Changed to the new function which handles both services and goods lines

Line 308: v_requestor := PO_INQ_SV.GET_PERSON_NAME(x_to_person_id);

304:
305: BEGIN
306:
307: IF x_to_person_id IS NOT NULL THEN
308: v_requestor := PO_INQ_SV.GET_PERSON_NAME(x_to_person_id);
309: END IF;
310:
311:
312: IF x_suggested_buyer_id IS NOT NULL THEN

Line 313: v_suggested_buyer := PO_INQ_SV.GET_PERSON_NAME(x_suggested_buyer_id);

309: END IF;
310:
311:
312: IF x_suggested_buyer_id IS NOT NULL THEN
313: v_suggested_buyer := PO_INQ_SV.GET_PERSON_NAME(x_suggested_buyer_id);
314: END IF;
315:
316:
317: IF x_preparer_id IS NOT NULL THEN

Line 318: v_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer_id);

314: END IF;
315:
316:
317: IF x_preparer_id IS NOT NULL THEN
318: v_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer_id);
319: END IF;
320:
321: -- SERVICES FPJ
322: -- Changed to the new function which handles both services and goods lines