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 768: If ( v_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID ) then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2552: CTO_UTILITY_PK.copy_cost(v_primary_cost_method

2548:
2549:
2550: /* copy_valuation_cost_to_cto_cost() ; */
2551: lStmtNum := 55;
2552: CTO_UTILITY_PK.copy_cost(v_primary_cost_method
2553: , v_cto_cost_type_id
2554: , pConfigId
2555: , p_cost_organization_id -- 3116778
2556: ) ;

Line 2646: CTO_UTILITY_PK.copy_cost(v_primary_cost_method

2642:
2643:
2644: /* copy_valuation_cost_to_cto_cost() ; */
2645: lStmtNum := 55;
2646: CTO_UTILITY_PK.copy_cost(v_primary_cost_method
2647: , v_cto_cost_type_id
2648: , pConfigId
2649: , p_cost_organization_id -- 3116778
2650: ) ;

Line 2744: CTO_UTILITY_PK.copy_cost( v_primary_cost_method

2740:
2741:
2742: /* copy_valuation_cost_to_cto_cost() ; */
2743: lStmtNum := 65;
2744: CTO_UTILITY_PK.copy_cost( v_primary_cost_method
2745: , v_cto_cost_type_id
2746: , pConfigId
2747: , p_cost_organization_id -- 3116778
2748: ) ;