DBA Data[Home] [Help]

APPS.CTO_WORKFLOW_API_PK dependencies on INV_RESERVATION_GLOBAL

Line 1777: inv_reservation_global.g_source_type_internal_ord,

1773: select count(*)
1774: into v_counter
1775: from mtl_reservations
1776: where demand_source_type_id = decode (l_source_document_type_id, 10,
1777: inv_reservation_global.g_source_type_internal_ord,
1778: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
1779: and demand_source_line_id = p_order_line_id
1780: and primary_reservation_quantity > 0;
1781:

Line 1778: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

1774: into v_counter
1775: from mtl_reservations
1776: where demand_source_type_id = decode (l_source_document_type_id, 10,
1777: inv_reservation_global.g_source_type_internal_ord,
1778: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
1779: and demand_source_line_id = p_order_line_id
1780: and primary_reservation_quantity > 0;
1781:
1782: If PG_DEBUG <> 0 Then

Line 1809: p_demand_source_type => inv_reservation_global.g_source_type_oe,

1805:
1806: if v_counter2 = 0 then
1807: v_counter2 :=
1808: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY( p_demand_source_line => to_char(p_order_line_id),
1809: p_demand_source_type => inv_reservation_global.g_source_type_oe,
1810: p_demand_source_delivery => NULL,
1811: p_use_open_quantity => 'Y');
1812: end if;
1813: -- end bugfix 3174334

Line 3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;

3631: x_token2 := 'ELIGIBLE';
3632: End if;
3633: Else
3634: l_stmt_num := 40;
3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock

Line 3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;

3632: End if;
3633: Else
3634: l_stmt_num := 40;
3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873

Line 3637: l_po_src_id := inv_reservation_global.g_source_type_po;

3633: Else
3634: l_stmt_num := 40;
3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;

Line 3638: l_req_src_id := inv_reservation_global.g_source_type_req;

3634: l_stmt_num := 40;
3635: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;

Line 3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873

3636: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;

Line 3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;

3637: l_po_src_id := inv_reservation_global.g_source_type_po;
3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;

Line 3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;

3638: l_req_src_id := inv_reservation_global.g_source_type_req;
3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3646: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;

Line 3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;

3639: --cross_dock
3640: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3641: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3642: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3643: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3644: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3645: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3646: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3647: --end cross_dock