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 886: cto_utility_pk.split_line( psplitdtls(v_splits_index).line_id,

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

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

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

Line 971: CTO_UTILITY_PK.check_cto_can_create_supply(

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

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

2451: END IF;
2452:
2453: l_stmt_no := 10;
2454:
2455: -- The following get_model_souring_org call is moved from CTO_ATP_INTERFACE_PK to CTO_UTILITY_PK
2456: -- To avoid dependency with Multi level functionality
2457: -- This is modified by Renga on 06/18/01.
2458:
2459:

Line 2484: CTO_UTILITY_PK.get_model_sourcing_org(

2480:
2481:
2482:
2483:
2484: CTO_UTILITY_PK.get_model_sourcing_org(
2485: p_inventory_item_id => pInventory_item_id,
2486: p_organization_id => pOrg_id,
2487: p_sourcing_rule_exists => x_result,
2488: p_sourcing_org => x_src_org_id,

Line 2896: l_rsv_rec_tbl CTO_UTILITY_PK.resv_tbl_rec_type;

2892: x_return_status OUT NOCOPY varchar2) is
2893:
2894: lStmtNumber number := 10;
2895: l_source_doc_type_id number;
2896: l_rsv_rec_tbl CTO_UTILITY_PK.resv_tbl_rec_type;
2897: l_resv_code varchar2(10);
2898: l_sum_rsv_qty number;
2899: l_msg_count number;
2900: l_msg_data varchar2(2000);

Line 2925: l_source_doc_type_id := CTO_UTILITY_PK.get_source_document_id (

2921:
2922:
2923:
2924: lStmtNumber := 20;
2925: l_source_doc_type_id := CTO_UTILITY_PK.get_source_document_id (
2926: pLineId => p_line_id );
2927:
2928:
2929:

Line 2933: CTO_UTILITY_PK.Get_Resv_Qty

2929:
2930: lStmtNumber := 30;
2931: -- This procedure returns the supply qty available for the line for each supply
2932: -- type.
2933: CTO_UTILITY_PK.Get_Resv_Qty
2934: (
2935: p_order_line_id => p_line_id,
2936: x_rsv_rec => l_rsv_rec_tbl,
2937: x_primary_uom_code => l_prim_uom_code,

Line 2965: (CTO_UTILITY_PK.g_source_type_ext_req_if,

2961:
2962: i := l_rsv_rec_tbl.first;
2963: LOOP
2964: if i not in
2965: (CTO_UTILITY_PK.g_source_type_ext_req_if,
2966: CTO_UTILITY_PK.g_source_type_int_req_if) then
2967:
2968: l_supply_qty := l_supply_qty +
2969: l_rsv_rec_tbl(i).primary_reservation_quantity;

Line 2966: CTO_UTILITY_PK.g_source_type_int_req_if) then

2962: i := l_rsv_rec_tbl.first;
2963: LOOP
2964: if i not in
2965: (CTO_UTILITY_PK.g_source_type_ext_req_if,
2966: CTO_UTILITY_PK.g_source_type_int_req_if) then
2967:
2968: l_supply_qty := l_supply_qty +
2969: l_rsv_rec_tbl(i).primary_reservation_quantity;
2970:

Line 3003: (CTO_UTILITY_PK.g_source_type_ext_req_if,

2999:
3000: k := l_rsv_rec_tbl.first;
3001: LOOP
3002: if k not in
3003: (CTO_UTILITY_PK.g_source_type_ext_req_if,
3004: CTO_UTILITY_PK.g_source_type_int_req_if) then
3005:
3006: l_supply_qty2 := l_supply_qty2 +
3007: l_rsv_rec_tbl(k).secondary_reservation_quantity;

Line 3004: CTO_UTILITY_PK.g_source_type_int_req_if) then

3000: k := l_rsv_rec_tbl.first;
3001: LOOP
3002: if k not in
3003: (CTO_UTILITY_PK.g_source_type_ext_req_if,
3004: CTO_UTILITY_PK.g_source_type_int_req_if) then
3005:
3006: l_supply_qty2 := l_supply_qty2 +
3007: l_rsv_rec_tbl(k).secondary_reservation_quantity;
3008: