APPS.CTO_CHANGE_ORDER_PK dependencies on CTO_UTILITY_PK

Line 63: | CTO_UTILITY_PK to avoid having |

59: | 06/18/01 Modified by Renga Kannan |
60: | The get_model_sourcing_org API |
61: | call is moved from |
62: | CTO_ATP_INTERFACE_PK to |
63: | CTO_UTILITY_PK to avoid having |
64: | dependency with CTOATPIB.pls |
65: | |
66: | 08/17/01 Replicated Branch fix by Sushant |
67: | Sawant |

Line 884: cto_utility_pk.split_line( psplitdtls(v_splits_index).line_id,

880:
881:
882: oe_debug_pub.add('Change_Notify: ' || 'calling split line ' , 1 );
883:
884: cto_utility_pk.split_line( psplitdtls(v_splits_index).line_id,
885: x_return_status => x_return_status,
886: X_Msg_Count => x_Msg_Count,
887: x_Msg_data => x_Msg_data);
888:

Line 906: cto_utility_pk.adjust_bcol_for_split( p_ato_line_id => pLineId,

902:
903:
904: oe_debug_pub.add('Change_Notify: ' || 'calling adjust_bcol..' || pLineId , 1 );
905:
906: cto_utility_pk.adjust_bcol_for_split( p_ato_line_id => pLineId,
907: x_return_status => x_return_status,
908: X_Msg_Count => x_Msg_Count,
909: x_Msg_data => x_Msg_data);
910:

Line 969: CTO_UTILITY_PK.check_cto_can_create_supply(

965: -- Call check_cto_can_create_supply. We process interface
966: -- records only for IR or buy cases. Also source type will be used to
967: -- determine whether to send the notification to buyer or planner.
968:
969: CTO_UTILITY_PK.check_cto_can_create_supply(
970: p_config_item_id => LConfig_id,
971: p_org_id => lorg_id,
972: x_can_create_supply => l_can_create_supply,
973: p_source_type => x_source_type,

Line 2218: -- The following get_model_souring_org call is moved from CTO_ATP_INTERFACE_PK to CTO_UTILITY_PK

2214: END IF;
2215:
2216: l_stmt_no := 10;
2217:
2218: -- The following get_model_souring_org call is moved from CTO_ATP_INTERFACE_PK to CTO_UTILITY_PK
2219: -- To avoid dependency with Multi level functionality
2220: -- This is modified by Renga on 06/18/01.
2221:
2222:

Line 2247: CTO_UTILITY_PK.get_model_sourcing_org(

2243:
2244:
2245:
2246:
2247: CTO_UTILITY_PK.get_model_sourcing_org(
2248: p_inventory_item_id => pInventory_item_id,
2249: p_organization_id => pOrg_id,
2250: p_sourcing_rule_exists => x_result,
2251: p_sourcing_org => x_src_org_id,

Line 2656: l_rsv_rec_tbl CTO_UTILITY_PK.resv_tbl_rec_type;

2652: x_return_status OUT NOCOPY varchar2) is
2653:
2654: lStmtNumber number := 10;
2655: l_source_doc_type_id number;
2656: l_rsv_rec_tbl CTO_UTILITY_PK.resv_tbl_rec_type;
2657: l_resv_code varchar2(10);
2658: l_sum_rsv_qty number;
2659: l_msg_count number;
2660: l_msg_data varchar2(2000);

Line 2685: l_source_doc_type_id := CTO_UTILITY_PK.get_source_document_id (

2681:
2682:
2683:
2684: lStmtNumber := 20;
2685: l_source_doc_type_id := CTO_UTILITY_PK.get_source_document_id (
2686: pLineId => p_line_id );
2687:
2688:
2689:

Line 2693: CTO_UTILITY_PK.Get_Resv_Qty

2689:
2690: lStmtNumber := 30;
2691: -- This procedure returns the supply qty available for the line for each supply
2692: -- type.
2693: CTO_UTILITY_PK.Get_Resv_Qty
2694: (
2695: p_order_line_id => p_line_id,
2696: x_rsv_rec => l_rsv_rec_tbl,
2697: x_primary_uom_code => l_prim_uom_code,

Line 2725: (CTO_UTILITY_PK.g_source_type_ext_req_if,

2721:
2722: i := l_rsv_rec_tbl.first;
2723: LOOP
2724: if i not in
2725: (CTO_UTILITY_PK.g_source_type_ext_req_if,
2726: CTO_UTILITY_PK.g_source_type_int_req_if) then
2727:
2728: l_supply_qty := l_supply_qty +
2729: l_rsv_rec_tbl(i).primary_reservation_quantity;

Line 2726: CTO_UTILITY_PK.g_source_type_int_req_if) then

2722: i := l_rsv_rec_tbl.first;
2723: LOOP
2724: if i not in
2725: (CTO_UTILITY_PK.g_source_type_ext_req_if,
2726: CTO_UTILITY_PK.g_source_type_int_req_if) then
2727:
2728: l_supply_qty := l_supply_qty +
2729: l_rsv_rec_tbl(i).primary_reservation_quantity;
2730:

Line 2763: (CTO_UTILITY_PK.g_source_type_ext_req_if,

2759:
2760: k := l_rsv_rec_tbl.first;
2761: LOOP
2762: if k not in
2763: (CTO_UTILITY_PK.g_source_type_ext_req_if,
2764: CTO_UTILITY_PK.g_source_type_int_req_if) then
2765:
2766: l_supply_qty2 := l_supply_qty2 +
2767: l_rsv_rec_tbl(k).secondary_reservation_quantity;

Line 2764: CTO_UTILITY_PK.g_source_type_int_req_if) then

2760: k := l_rsv_rec_tbl.first;
2761: LOOP
2762: if k not in
2763: (CTO_UTILITY_PK.g_source_type_ext_req_if,
2764: CTO_UTILITY_PK.g_source_type_int_req_if) then
2765:
2766: l_supply_qty2 := l_supply_qty2 +
2767: l_rsv_rec_tbl(k).secondary_reservation_quantity;
2768: