DBA Data[Home] [Help]

APPS.BOM_OP_SEQ_UTIL dependencies on STANDARD

Line 253: l_com_op_unexp_rec.Standard_Operation_Id := op_seq_rec.STANDARD_OPERATION_ID ;

249: l_com_op_unexp_rec.Revised_Item_Sequence_Id := op_seq_rec.REVISED_ITEM_SEQUENCE_ID ;
250: l_com_op_unexp_rec.Operation_Sequence_Id := op_seq_rec.OPERATION_SEQUENCE_ID ;
251: l_com_op_unexp_rec.Old_Operation_Sequence_Id := op_seq_rec.OLD_OPERATION_SEQUENCE_ID ;
252: l_com_op_unexp_rec.Routing_Sequence_Id := op_seq_rec.routing_sequence_id ;
253: l_com_op_unexp_rec.Standard_Operation_Id := op_seq_rec.STANDARD_OPERATION_ID ;
254: l_com_op_unexp_rec.Department_Id := op_seq_rec.DEPARTMENT_ID ;
255: l_com_op_unexp_rec.Process_Op_Seq_Id := op_seq_rec.PROCESS_OP_SEQ_ID ;
256: l_com_op_unexp_rec.Line_Op_Seq_Id := op_seq_rec.LINE_OP_SEQ_ID ;
257: l_com_op_unexp_rec.User_Elapsed_Time := op_seq_rec.TOTAL_TIME_USER ;

Line 945: * Purpose : Copy Standard Operation Resource

941: /******************************************************************
942: * Procedure : Copy_Std_Res_and_Docs
943: * internally called by RTG BO and by ECO BO
944: * Parameters IN : p_std_operation_id
945: * Purpose : Copy Standard Operation Resource
946: * to Operation Resources
947: **********************************************************************/
948: /*
949: Bug : 3728894

Line 972: , standard_rate_flag

968: , resource_seq_num
969: , resource_id
970: , acd_type
971: , activity_id
972: , standard_rate_flag
973: , assigned_units
974: , usage_rate_or_amount
975: , usage_rate_or_amount_inverse
976: , basis_type

Line 1016: , standard_rate_flag

1012: , BOM_Rtg_Globals.G_ECO_BO
1013: , 1 -- Acd Type : ADD
1014: , NULL )
1015: , activity_id
1016: , standard_rate_flag
1017: , assigned_units
1018: , usage_rate_or_amount
1019: , usage_rate_or_amount_inverse
1020: , basis_type

Line 1054: WHERE standard_operation_id = p_std_operation_id ;

1050: , schedule_seq_num --Bug#14550670
1051: , principle_flag --Bug#14550670
1052: , p_change_notice
1053: FROM BOM_STD_OP_RESOURCES
1054: WHERE standard_operation_id = p_std_operation_id ;
1055:
1056: --
1057: -- Copy alternate resources
1058: --

Line 1067: , standard_rate_flag

1063: , resource_id
1064: , schedule_seq_num
1065: , replacement_group_num
1066: , activity_id
1067: , standard_rate_flag
1068: , assigned_units
1069: , usage_rate_or_amount
1070: , usage_rate_or_amount_inverse
1071: , basis_type

Line 1110: , standard_rate_flag

1106: , resource_id
1107: , schedule_seq_num -- Bug 7370692 0 -- defaulting SSN to zero and the user has to change this value.
1108: , replacement_group_num
1109: , activity_id
1110: , standard_rate_flag
1111: , assigned_units
1112: , usage_rate_or_amount
1113: , usage_rate_or_amount_inverse
1114: , basis_type

Line 1151: WHERE standard_operation_id = p_std_operation_id ;

1147: , 1 -- Acd Type : ADD
1148: , NULL )
1149: , NULL -- original_system_reference
1150: FROM BOM_STD_SUB_OP_RESOURCES
1151: WHERE standard_operation_id = p_std_operation_id ;
1152:
1153: --
1154: -- Copy Attachment
1155: --

Line 1157: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',

1153: --
1154: -- Copy Attachment
1155: --
1156: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1157: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',
1158: X_from_pk1_value => to_char(p_std_operation_id),
1159: X_from_pk2_value => null,
1160: X_from_pk3_value => null,
1161: X_from_pk4_value => null,

Line 1219: , standard_rate_flag

1215: ( operation_sequence_id
1216: , resource_seq_num
1217: , resource_id
1218: , activity_id
1219: , standard_rate_flag
1220: , assigned_units
1221: , usage_rate_or_amount
1222: , usage_rate_or_amount_inverse
1223: , basis_type

Line 1265: , standard_rate_flag

1261: p_operation_sequence_id
1262: , resource_seq_num
1263: , resource_id
1264: , activity_id
1265: , standard_rate_flag
1266: , assigned_units
1267: , usage_rate_or_amount
1268: , usage_rate_or_amount_inverse
1269: , basis_type

Line 1318: , standard_rate_flag

1314: , substitute_group_num
1315: , resource_id
1316: , replacement_group_num
1317: , activity_id
1318: , standard_rate_flag
1319: , assigned_units
1320: , usage_rate_or_amount
1321: , usage_rate_or_amount_inverse
1322: , basis_type

Line 1364: , standard_rate_flag

1360: , substitute_group_num
1361: , resource_id
1362: , replacement_group_num
1363: , activity_id
1364: , standard_rate_flag
1365: , assigned_units
1366: , usage_rate_or_amount
1367: , usage_rate_or_amount_inverse
1368: , basis_type

Line 1488: standard_operation_id ,

1484: last_updated_by ,
1485: creation_date ,
1486: created_by ,
1487: last_update_login ,
1488: standard_operation_id ,
1489: department_id ,
1490: operation_lead_time_percent ,
1491: minimum_transfer_quantity ,
1492: count_point_type ,

Line 1562: , p_com_op_unexp_rec.standard_operation_id

1558: , BOM_Rtg_Globals.Get_User_Id -- Last Updated By
1559: , SYSDATE -- Creation Date
1560: , BOM_Rtg_Globals.Get_User_Id -- Created By
1561: , BOM_Rtg_Globals.Get_Login_Id -- Last Update Login
1562: , p_com_op_unexp_rec.standard_operation_id
1563: , p_com_op_unexp_rec.department_id
1564: , p_com_operation_rec.op_lead_time_percent
1565: , p_com_operation_rec.minimum_transfer_quantity
1566: , p_com_operation_rec.count_point_type

Line 1644: -- Copy Standard Operation Resources

1640: IF p_com_op_unexp_rec.operation_sequence_id IS NOT NULL
1641: AND NVL(p_com_operation_rec.acd_type , 1 ) = 1 -- Acd Type : ADD
1642: THEN
1643: --
1644: -- Copy Standard Operation Resources
1645: --
1646: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1647: ('Copy Standard Operation Resources. . . ' ) ;
1648: END IF ;

Line 1647: ('Copy Standard Operation Resources. . . ' ) ;

1643: --
1644: -- Copy Standard Operation Resources
1645: --
1646: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1647: ('Copy Standard Operation Resources. . . ' ) ;
1648: END IF ;
1649:
1650: IF p_com_operation_rec.reference_flag = 1 OR (p_com_operation_rec.reference_flag = 2 AND nvl(BOM_Globals.Get_Caller_Type, '') <> 'MIGRATION') THEN
1651: Copy_Std_Res_and_Docs

Line 1655: p_com_op_unexp_rec.standard_operation_id

1651: Copy_Std_Res_and_Docs
1652: ( p_operation_sequence_id =>
1653: p_com_op_unexp_rec.operation_sequence_id
1654: , p_std_operation_id =>
1655: p_com_op_unexp_rec.standard_operation_id
1656: , p_change_notice =>
1657: p_com_operation_rec.Eco_Name
1658: ) ;
1659: END IF;

Line 1753: , standard_operation_id = p_com_op_unexp_rec.standard_operation_id

1749: )
1750: , last_update_date = SYSDATE /* Last Update Date */
1751: , last_updated_by = BOM_Rtg_Globals.Get_User_Id /* Last Updated By */
1752: , last_update_login = BOM_Rtg_Globals.Get_Login_Id /* Last Update Login */
1753: , standard_operation_id = p_com_op_unexp_rec.standard_operation_id
1754: , department_id = p_com_op_unexp_rec.department_id
1755: , operation_lead_time_percent = p_com_operation_rec.op_lead_time_percent
1756: , minimum_transfer_quantity = p_com_operation_rec.minimum_transfer_quantity
1757: , count_point_type = p_com_operation_rec.count_point_type

Line 2182: , standard_operation_id

2178: , last_updated_by
2179: , creation_date
2180: , created_by
2181: , last_update_login
2182: , standard_operation_id
2183: , department_id
2184: , operation_lead_time_percent
2185: , minimum_transfer_quantity
2186: , count_point_type

Line 2247: , STANDARD_OPERATION_ID

2243: , p_user_id -- Last Updated By
2244: , SYSDATE -- Creation Date
2245: , p_user_id -- Created By
2246: , p_login_id -- Last Update Login
2247: , STANDARD_OPERATION_ID
2248: , DEPARTMENT_ID
2249: , OPERATION_LEAD_TIME_PERCENT
2250: , MINIMUM_TRANSFER_QUANTITY
2251: , COUNT_POINT_TYPE