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 1015: , standard_rate_flag

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

Line 1051: WHERE standard_operation_id = p_std_operation_id ;

1047: , substitute_group_num
1048: , resource_seq_num -- Bug 7370692 (Schedule_Seq_num=resource_seq_num)
1049: , p_change_notice
1050: FROM BOM_STD_OP_RESOURCES
1051: WHERE standard_operation_id = p_std_operation_id ;
1052:
1053: --
1054: -- Copy alternate resources
1055: --

Line 1064: , standard_rate_flag

1060: , resource_id
1061: , schedule_seq_num
1062: , replacement_group_num
1063: , activity_id
1064: , standard_rate_flag
1065: , assigned_units
1066: , usage_rate_or_amount
1067: , usage_rate_or_amount_inverse
1068: , basis_type

Line 1107: , standard_rate_flag

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

Line 1148: WHERE standard_operation_id = p_std_operation_id ;

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

Line 1154: X_from_entity_name => 'BOM_STANDARD_OPERATIONS',

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

Line 1216: , standard_rate_flag

1212: ( operation_sequence_id
1213: , resource_seq_num
1214: , resource_id
1215: , activity_id
1216: , standard_rate_flag
1217: , assigned_units
1218: , usage_rate_or_amount
1219: , usage_rate_or_amount_inverse
1220: , basis_type

Line 1262: , standard_rate_flag

1258: p_operation_sequence_id
1259: , resource_seq_num
1260: , resource_id
1261: , activity_id
1262: , standard_rate_flag
1263: , assigned_units
1264: , usage_rate_or_amount
1265: , usage_rate_or_amount_inverse
1266: , basis_type

Line 1315: , standard_rate_flag

1311: , substitute_group_num
1312: , resource_id
1313: , replacement_group_num
1314: , activity_id
1315: , standard_rate_flag
1316: , assigned_units
1317: , usage_rate_or_amount
1318: , usage_rate_or_amount_inverse
1319: , basis_type

Line 1361: , standard_rate_flag

1357: , substitute_group_num
1358: , resource_id
1359: , replacement_group_num
1360: , activity_id
1361: , standard_rate_flag
1362: , assigned_units
1363: , usage_rate_or_amount
1364: , usage_rate_or_amount_inverse
1365: , basis_type

Line 1485: standard_operation_id ,

1481: last_updated_by ,
1482: creation_date ,
1483: created_by ,
1484: last_update_login ,
1485: standard_operation_id ,
1486: department_id ,
1487: operation_lead_time_percent ,
1488: minimum_transfer_quantity ,
1489: count_point_type ,

Line 1559: , p_com_op_unexp_rec.standard_operation_id

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

Line 1641: -- Copy Standard Operation Resources

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

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

1640: --
1641: -- Copy Standard Operation Resources
1642: --
1643: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1644: ('Copy Standard Operation Resources. . . ' ) ;
1645: END IF ;
1646:
1647: 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
1648: Copy_Std_Res_and_Docs

Line 1652: p_com_op_unexp_rec.standard_operation_id

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

Line 1750: , standard_operation_id = p_com_op_unexp_rec.standard_operation_id

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

Line 2179: , standard_operation_id

2175: , last_updated_by
2176: , creation_date
2177: , created_by
2178: , last_update_login
2179: , standard_operation_id
2180: , department_id
2181: , operation_lead_time_percent
2182: , minimum_transfer_quantity
2183: , count_point_type

Line 2244: , STANDARD_OPERATION_ID

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