DBA Data[Home] [Help]

APPS.CTO_WORKFLOW_API_PK dependencies on INV_RESERVATION_GLOBAL

Line 1750: inv_reservation_global.g_source_type_internal_ord,

1746: select count(*)
1747: into v_counter
1748: from mtl_reservations
1749: where demand_source_type_id = decode (l_source_document_type_id, 10,
1750: inv_reservation_global.g_source_type_internal_ord,
1751: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
1752: and demand_source_line_id = p_order_line_id
1753: and primary_reservation_quantity > 0;
1754:

Line 1751: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

1747: into v_counter
1748: from mtl_reservations
1749: where demand_source_type_id = decode (l_source_document_type_id, 10,
1750: inv_reservation_global.g_source_type_internal_ord,
1751: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
1752: and demand_source_line_id = p_order_line_id
1753: and primary_reservation_quantity > 0;
1754:
1755: If PG_DEBUG <> 0 Then

Line 1782: p_demand_source_type => inv_reservation_global.g_source_type_oe,

1778:
1779: if v_counter2 = 0 then
1780: v_counter2 :=
1781: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY( p_demand_source_line => to_char(p_order_line_id),
1782: p_demand_source_type => inv_reservation_global.g_source_type_oe,
1783: p_demand_source_delivery => NULL,
1784: p_use_open_quantity => 'Y');
1785: end if;
1786: -- end bugfix 3174334

Line 3603: l_inv_src_id := inv_reservation_global.g_source_type_inv;

3599: x_token2 := 'ELIGIBLE';
3600: End if;
3601: Else
3602: l_stmt_num := 40;
3603: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3604: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3605: l_po_src_id := inv_reservation_global.g_source_type_po;
3606: l_req_src_id := inv_reservation_global.g_source_type_req;
3607: --cross_dock

Line 3604: l_wip_src_id := inv_reservation_global.g_source_type_wip;

3600: End if;
3601: Else
3602: l_stmt_num := 40;
3603: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3604: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3605: l_po_src_id := inv_reservation_global.g_source_type_po;
3606: l_req_src_id := inv_reservation_global.g_source_type_req;
3607: --cross_dock
3608: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873

Line 3605: l_po_src_id := inv_reservation_global.g_source_type_po;

3601: Else
3602: l_stmt_num := 40;
3603: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3604: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3605: l_po_src_id := inv_reservation_global.g_source_type_po;
3606: l_req_src_id := inv_reservation_global.g_source_type_req;
3607: --cross_dock
3608: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;

Line 3606: l_req_src_id := inv_reservation_global.g_source_type_req;

3602: l_stmt_num := 40;
3603: l_inv_src_id := inv_reservation_global.g_source_type_inv;
3604: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3605: l_po_src_id := inv_reservation_global.g_source_type_po;
3606: l_req_src_id := inv_reservation_global.g_source_type_req;
3607: --cross_dock
3608: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;

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

3604: l_wip_src_id := inv_reservation_global.g_source_type_wip;
3605: l_po_src_id := inv_reservation_global.g_source_type_po;
3606: l_req_src_id := inv_reservation_global.g_source_type_req;
3607: --cross_dock
3608: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3611: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3612: l_flm_src_id := cto_utility_pk.g_source_type_flow;

Line 3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;

3605: l_po_src_id := inv_reservation_global.g_source_type_po;
3606: l_req_src_id := inv_reservation_global.g_source_type_req;
3607: --cross_dock
3608: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3611: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3612: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3613: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;

Line 3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;

3606: l_req_src_id := inv_reservation_global.g_source_type_req;
3607: --cross_dock
3608: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3611: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3612: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3613: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3614: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;

Line 3611: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;

3607: --cross_dock
3608: l_ext_req_src_id := inv_reservation_global.g_source_type_req;--bugfix 4652873
3609: l_int_req_src_id := inv_reservation_global.g_source_type_internal_req;
3610: l_asn_src_id := inv_reservation_global.g_source_type_asn;
3611: l_rcv_src_id := inv_reservation_global.g_source_type_rcv;
3612: l_flm_src_id := cto_utility_pk.g_source_type_flow;
3613: l_ext_req_if_src_id := cto_utility_pk.g_source_type_ext_req_if;
3614: l_int_req_if_src_id := cto_utility_pk.g_source_type_int_req_if;
3615: --end cross_dock