APPS.WIP_OSP dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 468: INSERT INTO PO_REQUISITIONS_INTERFACE_ALL

464: /* Create the requisition */
465: IF Additional_Quantity > 0 THEN
466: /* This additional_quantity is set to the increased quantity
467: of the job that is modified by the user. */
468: INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
469: ( last_update_date, last_updated_by, creation_date,
470: created_by, last_update_login, request_id,
471: program_application_id, program_id, program_update_date,
472: org_id, /* Operating unit org */ preparer_id,

Line 654: INSERT INTO PO_REQUISITIONS_INTERFACE_ALL

650: AND bcd3.seq_num = (bcd4.next_seq_num -
651: CEIL(NVL(msi.postprocessing_lead_time,0)));
652:
653: ELSE
654: INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
655: ( last_update_date, last_updated_by, creation_date,
656: created_by, last_update_login, request_id,
657: program_application_id, program_id, program_update_date,
658: org_id, /* Operating unit org */ preparer_id,

Line 940: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

936: AND nvl(PRL.cancel_flag, 'N') = 'N'
937: AND PRL.LINE_LOCATION_ID is NULL /* added as part of 2740352 */
938: UNION ALL
939: SELECT 'PO/REQ Linked'
940: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
941: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
942: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
943: AND (p_op_seq_num is NULL OR PRI.WIP_OPERATION_SEQ_NUM = p_op_seq_num);
944:

Line 983: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

979: PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num)
980: AND nvl(PRL.cancel_flag, 'N') = 'N'
981: UNION ALL
982: SELECT 'PO/REQ Linked'
983: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
984: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
985: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
986: AND PRI.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id
987: AND (p_op_seq_num is NULL OR PRI.WIP_OPERATION_SEQ_NUM = p_op_seq_num);

Line 2086: FROM po_requisitions_interface_all

2082: p_is_scrap_txn IS NULL OR p_is_scrap_txn = WIP_CONSTANTS.NO) THEN
2083:
2084: SELECT count(*)
2085: INTO l_pending_recs
2086: FROM po_requisitions_interface_all
2087: WHERE wip_entity_id = p_job_id
2088: AND (p_repetitive_id IS NULL OR
2089: wip_repetitive_schedule_id = p_repetitive_id);
2090:

Line 2095: 'PO_REQUISITIONS_INTERFACE_ALL';

2091: IF(l_pending_recs <> 0) THEN
2092: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');
2093: fnd_msg_pub.add;
2094: l_errMsg := 'There are some pending records in ' ||
2095: 'PO_REQUISITIONS_INTERFACE_ALL';
2096: raise fnd_api.g_exc_unexpected_error;
2097: END IF;
2098: end if; /* if((p_is_scrap_txn = WIP_CONSTANTS.YES AND */
2099:

Line 2475: FROM po_requisitions_interface_all

2471: fnd_msg_pub.add;
2472: ELSE
2473: SELECT count(*)
2474: INTO l_pending_recs
2475: FROM po_requisitions_interface_all
2476: WHERE wip_entity_id = p_job_id;
2477: IF(l_pending_recs <> 0) THEN
2478: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');
2479: fnd_msg_pub.add;

Line 2546: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

2542: AND (p_op_seq_num is NULL
2543: OR PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num))
2544: AND NOT EXISTS
2545: (SELECT '1'
2546: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
2547: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
2548: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
2549: AND (p_op_seq_num is NULL
2550: OR PRI.WIP_OPERATION_SEQ_NUM = p_op_seq_num));

Line 2577: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

2573: AND (p_op_seq_num is NULL
2574: OR PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num))
2575: AND NOT EXISTS
2576: (SELECT '1'
2577: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
2578: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
2579: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
2580: AND PRI.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id
2581: AND (p_op_seq_num is NULL