APPS.ENG_LAUNCH_ECO_OI_PK dependencies on BOM_SUB_OP_RESOURCES_INTERFACE

Line 1019: UPDATE bom_sub_op_resources_interface

1015: UPDATE bom_op_sequences_interface
1016: SET PROCESS_FLAG = l_process_flag
1017: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1018:
1019: UPDATE bom_sub_op_resources_interface
1020: SET PROCESS_FLAG = l_process_flag
1021: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1022:
1023: --Bug No: 3737881

Line 2430: FROM bom_sub_op_resources_interface

2426: attribute8, attribute9, attribute10, attribute11, attribute12,
2427: attribute13, attribute14, attribute15, original_system_reference,
2428: transaction_type, setup_code
2429: , new_basis_type -- Bug: 5067990
2430: FROM bom_sub_op_resources_interface
2431: WHERE eng_changes_ifce_key = g_ECO_ifce_key;
2432:
2433: i NUMBER;
2434: BEGIN

Line 3126: UPDATE bom_sub_op_resources_interface bsori

3122: FROM mtl_parameters mp2
3123: WHERE mp2.organization_code = bori.organization_code);
3124:
3125: stmt_num := 8.3;
3126: UPDATE bom_sub_op_resources_interface bsori
3127: SET organization_id = (SELECT organization_id
3128: FROM mtl_parameters mp1
3129: WHERE mp1.organization_code = bsori.organization_code)
3130: WHERE process_flag = 1

Line 3236: UPDATE bom_sub_op_resources_interface

3232: OR
3233: (p_all_org = 2 AND organization_id = p_org_id));
3234:
3235: stmt_num := 10.9;
3236: UPDATE bom_sub_op_resources_interface
3237: SET transaction_id = mtl_system_items_interface_s.nextval,
3238: transaction_type = UPPER(transaction_type)
3239: WHERE process_flag = 1
3240: AND (transaction_id is NULL

Line 6230: DELETE from bom_sub_op_resources_interface

6226: COMMIT;
6227: END LOOP;
6228: stmt_num := 522;
6229: LOOP
6230: DELETE from bom_sub_op_resources_interface
6231: WHERE process_flag = 7
6232: AND rownum < G_ROWS_TO_COMMIT;
6233:
6234: EXIT when SQL%NOTFOUND;