143:
144: t_po_header_id rcvNumberArray;
145: t_line_location_id rcvNumberArray;
146: t_expected_receipt_qty rcvNumberArray;
147: t_ordered_uom rcvVarcharArray;
148: -- bug 4672728 - the non translated UOM values.
149: t_ordered_uom_non_tl rcvVarcharArray;
150: t_item_id rcvNumberArray;
151: t_primary_uom_class rcvVarcharArray;
145: t_line_location_id rcvNumberArray;
146: t_expected_receipt_qty rcvNumberArray;
147: t_ordered_uom rcvVarcharArray;
148: -- bug 4672728 - the non translated UOM values.
149: t_ordered_uom_non_tl rcvVarcharArray;
150: t_item_id rcvNumberArray;
151: t_primary_uom_class rcvVarcharArray;
152: t_org_id rcvNumberArray;
153: t_po_distribution_id rcvNumberArray;
147: t_ordered_uom rcvVarcharArray;
148: -- bug 4672728 - the non translated UOM values.
149: t_ordered_uom_non_tl rcvVarcharArray;
150: t_item_id rcvNumberArray;
151: t_primary_uom_class rcvVarcharArray;
152: t_org_id rcvNumberArray;
153: t_po_distribution_id rcvNumberArray;
154: t_Comments rcvVarcharArray;
155: t_PackingSlip rcvVarcharArray;
150: t_item_id rcvNumberArray;
151: t_primary_uom_class rcvVarcharArray;
152: t_org_id rcvNumberArray;
153: t_po_distribution_id rcvNumberArray;
154: t_Comments rcvVarcharArray;
155: t_PackingSlip rcvVarcharArray;
156: t_WayBillNum rcvVarcharArray;
157:
158: type select_shipments_Cursor is ref cursor ;
151: t_primary_uom_class rcvVarcharArray;
152: t_org_id rcvNumberArray;
153: t_po_distribution_id rcvNumberArray;
154: t_Comments rcvVarcharArray;
155: t_PackingSlip rcvVarcharArray;
156: t_WayBillNum rcvVarcharArray;
157:
158: type select_shipments_Cursor is ref cursor ;
159: Porcpt_Shipment select_shipments_Cursor;
152: t_org_id rcvNumberArray;
153: t_po_distribution_id rcvNumberArray;
154: t_Comments rcvVarcharArray;
155: t_PackingSlip rcvVarcharArray;
156: t_WayBillNum rcvVarcharArray;
157:
158: type select_shipments_Cursor is ref cursor ;
159: Porcpt_Shipment select_shipments_Cursor;
160:
573: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
574:
575: t_req_line_id rcvNumberArray;
576: t_expected_receipt_qty rcvNumberArray;
577: t_ordered_uom rcvVarcharArray;
578: t_item_id rcvNumberArray;
579: t_primary_uom_class rcvVarcharArray;
580: t_org_id rcvNumberArray;
581: t_waybillNum rcvVarcharArray;
575: t_req_line_id rcvNumberArray;
576: t_expected_receipt_qty rcvNumberArray;
577: t_ordered_uom rcvVarcharArray;
578: t_item_id rcvNumberArray;
579: t_primary_uom_class rcvVarcharArray;
580: t_org_id rcvNumberArray;
581: t_waybillNum rcvVarcharArray;
582: t_comments rcvVarcharArray;
583: t_packingSlip rcvVarcharArray;
577: t_ordered_uom rcvVarcharArray;
578: t_item_id rcvNumberArray;
579: t_primary_uom_class rcvVarcharArray;
580: t_org_id rcvNumberArray;
581: t_waybillNum rcvVarcharArray;
582: t_comments rcvVarcharArray;
583: t_packingSlip rcvVarcharArray;
584:
585:
578: t_item_id rcvNumberArray;
579: t_primary_uom_class rcvVarcharArray;
580: t_org_id rcvNumberArray;
581: t_waybillNum rcvVarcharArray;
582: t_comments rcvVarcharArray;
583: t_packingSlip rcvVarcharArray;
584:
585:
586:
579: t_primary_uom_class rcvVarcharArray;
580: t_org_id rcvNumberArray;
581: t_waybillNum rcvVarcharArray;
582: t_comments rcvVarcharArray;
583: t_packingSlip rcvVarcharArray;
584:
585:
586:
587: type select_shipments_Cursor is ref cursor ;
1753:
1754: t_po_header_id rcvNumberArray;
1755: t_line_location_id rcvNumberArray;
1756: t_expected_receipt_qty rcvNumberArray;
1757: t_ordered_uom rcvVarcharArray;
1758: t_item_id rcvNumberArray;
1759: t_primary_uom_class rcvVarcharArray;
1760: t_org_id rcvNumberArray;
1761: t_po_distribution_id rcvNumberArray;
1755: t_line_location_id rcvNumberArray;
1756: t_expected_receipt_qty rcvNumberArray;
1757: t_ordered_uom rcvVarcharArray;
1758: t_item_id rcvNumberArray;
1759: t_primary_uom_class rcvVarcharArray;
1760: t_org_id rcvNumberArray;
1761: t_po_distribution_id rcvNumberArray;
1762: t_Comments rcvVarcharArray;
1763: t_PackingSlip rcvVarcharArray;
1758: t_item_id rcvNumberArray;
1759: t_primary_uom_class rcvVarcharArray;
1760: t_org_id rcvNumberArray;
1761: t_po_distribution_id rcvNumberArray;
1762: t_Comments rcvVarcharArray;
1763: t_PackingSlip rcvVarcharArray;
1764: t_WayBillNum rcvVarcharArray;
1765:
1766: x_progress varchar2(1000):= '001';
1759: t_primary_uom_class rcvVarcharArray;
1760: t_org_id rcvNumberArray;
1761: t_po_distribution_id rcvNumberArray;
1762: t_Comments rcvVarcharArray;
1763: t_PackingSlip rcvVarcharArray;
1764: t_WayBillNum rcvVarcharArray;
1765:
1766: x_progress varchar2(1000):= '001';
1767: x_ntf_trigerred_date varchar2(40);
1760: t_org_id rcvNumberArray;
1761: t_po_distribution_id rcvNumberArray;
1762: t_Comments rcvVarcharArray;
1763: t_PackingSlip rcvVarcharArray;
1764: t_WayBillNum rcvVarcharArray;
1765:
1766: x_progress varchar2(1000):= '001';
1767: x_ntf_trigerred_date varchar2(40);
1768: x_message_token VARCHAR2(2000);
2785: x_org_id NUMBER;
2786:
2787: t_req_line_id rcvNumberArray;
2788: t_expected_receipt_qty rcvNumberArray;
2789: t_ordered_uom rcvVarcharArray;
2790: t_item_id rcvNumberArray;
2791: t_primary_uom_class rcvVarcharArray;
2792: t_org_id rcvNumberArray;
2793: t_waybillNum rcvVarcharArray;
2787: t_req_line_id rcvNumberArray;
2788: t_expected_receipt_qty rcvNumberArray;
2789: t_ordered_uom rcvVarcharArray;
2790: t_item_id rcvNumberArray;
2791: t_primary_uom_class rcvVarcharArray;
2792: t_org_id rcvNumberArray;
2793: t_waybillNum rcvVarcharArray;
2794: t_comments rcvVarcharArray;
2795: t_packingSlip rcvVarcharArray;
2789: t_ordered_uom rcvVarcharArray;
2790: t_item_id rcvNumberArray;
2791: t_primary_uom_class rcvVarcharArray;
2792: t_org_id rcvNumberArray;
2793: t_waybillNum rcvVarcharArray;
2794: t_comments rcvVarcharArray;
2795: t_packingSlip rcvVarcharArray;
2796: x_requestor_id NUMBER;
2797:
2790: t_item_id rcvNumberArray;
2791: t_primary_uom_class rcvVarcharArray;
2792: t_org_id rcvNumberArray;
2793: t_waybillNum rcvVarcharArray;
2794: t_comments rcvVarcharArray;
2795: t_packingSlip rcvVarcharArray;
2796: x_requestor_id NUMBER;
2797:
2798: x_progress varchar2(1000):= '001';
2791: t_primary_uom_class rcvVarcharArray;
2792: t_org_id rcvNumberArray;
2793: t_waybillNum rcvVarcharArray;
2794: t_comments rcvVarcharArray;
2795: t_packingSlip rcvVarcharArray;
2796: x_requestor_id NUMBER;
2797:
2798: x_progress varchar2(1000):= '001';
2799: x_message_token VARCHAR2(2000);
3741:
3742: t_po_header_id rcvNumberArray;
3743: t_line_location_id rcvNumberArray;
3744: t_expected_receipt_qty rcvNumberArray;
3745: t_ordered_uom rcvVarcharArray;
3746: t_item_id rcvNumberArray;
3747: t_primary_uom_class rcvVarcharArray;
3748: t_org_id rcvNumberArray;
3749: t_po_distribution_id rcvNumberArray;
3743: t_line_location_id rcvNumberArray;
3744: t_expected_receipt_qty rcvNumberArray;
3745: t_ordered_uom rcvVarcharArray;
3746: t_item_id rcvNumberArray;
3747: t_primary_uom_class rcvVarcharArray;
3748: t_org_id rcvNumberArray;
3749: t_po_distribution_id rcvNumberArray;
3750: t_Comments rcvVarcharArray;
3751: t_PackingSlip rcvVarcharArray;
3746: t_item_id rcvNumberArray;
3747: t_primary_uom_class rcvVarcharArray;
3748: t_org_id rcvNumberArray;
3749: t_po_distribution_id rcvNumberArray;
3750: t_Comments rcvVarcharArray;
3751: t_PackingSlip rcvVarcharArray;
3752: t_WayBillNum rcvVarcharArray;
3753:
3754: x_message_token VARCHAR2(2000);
3747: t_primary_uom_class rcvVarcharArray;
3748: t_org_id rcvNumberArray;
3749: t_po_distribution_id rcvNumberArray;
3750: t_Comments rcvVarcharArray;
3751: t_PackingSlip rcvVarcharArray;
3752: t_WayBillNum rcvVarcharArray;
3753:
3754: x_message_token VARCHAR2(2000);
3755: x_progress varchar2(1000):= '001';
3748: t_org_id rcvNumberArray;
3749: t_po_distribution_id rcvNumberArray;
3750: t_Comments rcvVarcharArray;
3751: t_PackingSlip rcvVarcharArray;
3752: t_WayBillNum rcvVarcharArray;
3753:
3754: x_message_token VARCHAR2(2000);
3755: x_progress varchar2(1000):= '001';
3756: BEGIN