DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on CTO_UTILITY_PK

Line 240: CTO_UTILITY_PK.create_item_attachments(

236: --- Added by Renga Kannan on 01/20/04 . Calling the new procedure to Create item attachments
237:
238: oe_debug_pub.add('Create_all_boms_and_routings: Calling Create_item_attachments API',1);
239:
240: CTO_UTILITY_PK.create_item_attachments(
241: p_ato_line_id => pAtoLineId,
242: x_return_status => xReturnStatus,
243: x_msg_count => xMsgCount,
244: x_msg_data => xMsgData);

Line 771: If ( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

767: to get the lead time of config item */
768: lStmtNum := 113;
769: Begin
770: -- Fixed fp bug 5485452
771: If ( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
772: select (ceil(nvl(msi.fixed_lead_time,0)
773: + nvl(msi.variable_lead_time,0) * bcol.ordered_quantity))
774: into lLeadTime
775: from mtl_system_items msi,

Line 779: and msi.organization_id = CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG;

775: from mtl_system_items msi,
776: bom_cto_order_lines bcol
777: where bcol.line_id = pLineId
778: and msi.inventory_item_id = bcol.inventory_item_id
779: and msi.organization_id = CTO_UTILITY_PK.PC_BOM_VALIDATION_ORG;
780:
781: else
782: select (ceil(nvl(msi.fixed_lead_time,0)
783: + nvl(msi.variable_lead_time,0) * oel.ordered_quantity))

Line 859: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

855: oe_debug_pub.add('Select missed component details.. ' ,1);
856: END IF;
857:
858: -- Bug Fix 5199775
859: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
860: IF PG_DEBUG <> 0 THEN
861: oe_debug_pub.add('Pre configured Item .. ' ,1);
862: END IF;
863: IF PG_DEBUG <> 0 THEN

Line 1057: cto_utility_pk.apply_create_config_hold( l_ato_line_id, l_header_id, xReturnStatus, xMsgCount, xMsgData ) ;

1053: -- rkaza. 08/25/2005. bug 4315973.
1054: -- Applying hold even for dropped item cases when config bom
1055: -- exists and profile set to not create item.
1056:
1057: cto_utility_pk.apply_create_config_hold( l_ato_line_id, l_header_id, xReturnStatus, xMsgCount, xMsgData ) ;
1058:
1059: -- pop up message that model is put on hold.
1060: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');
1061:

Line 1069: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

1065:
1066: end if;
1067: */
1068:
1069: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1070: IF PG_DEBUG <> 0 THEN
1071: oe_debug_pub.add ('Will not go through Hold Logic and Notification as Preconfigured Bom' , 1 );
1072: END IF;
1073: if mismatched_items%ROWCOUNT > 0 then

Line 1181: else /* v_program_id <> CTO_UTILITY_PK.PC_BOM_PROGRAM_ID */

1177: end if; /* lcreate_item = 1 */
1178:
1179: end if; /*mismatched_items%ROWCOUNT > 0 */
1180:
1181: else /* v_program_id <> CTO_UTILITY_PK.PC_BOM_PROGRAM_ID */
1182: if mismatched_items%ROWCOUNT > 0 then
1183: CTO_CONFIG_BOM_PK.gDropItem := 0;
1184:
1185: lStmtNum := 55;

Line 1209: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

1205: into v_error_org
1206: from inv_organization_name_v
1207: where organization_id = lNextRec.organization_id ;
1208:
1209: if( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then
1210: v_problem_model_line_num := ' -1 ' ;
1211: else
1212: select oel.line_number || '.' || oel.shipment_number
1213: into v_problem_model_line_num

Line 1250: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_CREATED

1246: IF PG_DEBUG <> 0 THEN
1247: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1248: END IF;
1249:
1250: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_CREATED
1251: ,p_inventory_item_id => pModelId
1252: ,p_organization_id => lNextRec.organization_id
1253: ,p_line_id => pLineId );
1254:

Line 1362: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_NOT_CREATED

1358: IF PG_DEBUG <> 0 THEN
1359: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1360: END IF;
1361:
1362: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_NOT_CREATED
1363: ,p_inventory_item_id => pModelId
1364: ,p_organization_id => lNextRec.organization_id
1365: ,p_line_id => pLineId );
1366:

Line 1424: cto_utility_pk.apply_create_config_hold( l_ato_line_id, l_header_id, xReturnStatus, xMsgCount, xMsgData ) ;

1420:
1421: oe_debug_pub.add('create_bom_ml: ' || 'fetching information for apply hold on lineid '|| to_char(pLineId) ,2);
1422: oe_debug_pub.add('create_bom_ml: ' || 'going to apply hold on lineid '|| to_char(pLineId) ,2);
1423:
1424: cto_utility_pk.apply_create_config_hold( l_ato_line_id, l_header_id, xReturnStatus, xMsgCount, xMsgData ) ;
1425:
1426:
1427: l_token(1).token_name := 'ORDER_NUM';
1428: l_token(1).token_value := v_order_number;

Line 2612: CTO_UTILITY_PK.copy_cost(v_primary_cost_method

2608:
2609:
2610: /* copy_valuation_cost_to_cto_cost() ; */
2611: lStmtNum := 55;
2612: CTO_UTILITY_PK.copy_cost(v_primary_cost_method
2613: , v_cto_cost_type_id
2614: , pConfigId
2615: , p_cost_organization_id -- 3116778
2616: ) ;

Line 2706: CTO_UTILITY_PK.copy_cost(v_primary_cost_method

2702:
2703:
2704: /* copy_valuation_cost_to_cto_cost() ; */
2705: lStmtNum := 55;
2706: CTO_UTILITY_PK.copy_cost(v_primary_cost_method
2707: , v_cto_cost_type_id
2708: , pConfigId
2709: , p_cost_organization_id -- 3116778
2710: ) ;

Line 2804: CTO_UTILITY_PK.copy_cost( v_primary_cost_method

2800:
2801:
2802: /* copy_valuation_cost_to_cto_cost() ; */
2803: lStmtNum := 65;
2804: CTO_UTILITY_PK.copy_cost( v_primary_cost_method
2805: , v_cto_cost_type_id
2806: , pConfigId
2807: , p_cost_organization_id -- 3116778
2808: ) ;