APPS.ENG_LAUNCH_ECO_OI_PK dependencies on BOM_SUB_OP_RESOURCES_INTERFACE

Line 1015: UPDATE bom_sub_op_resources_interface

1011: UPDATE bom_op_sequences_interface
1012: SET PROCESS_FLAG = l_process_flag
1013: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1014:
1015: UPDATE bom_sub_op_resources_interface
1016: SET PROCESS_FLAG = l_process_flag
1017: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1018:
1019: --Bug No: 3737881

Line 2425: FROM bom_sub_op_resources_interface

2421: attribute8, attribute9, attribute10, attribute11, attribute12,
2422: attribute13, attribute14, attribute15, original_system_reference,
2423: transaction_type, setup_code
2424: , new_basis_type -- Bug: 5067990
2425: FROM bom_sub_op_resources_interface
2426: WHERE eng_changes_ifce_key = g_ECO_ifce_key;
2427:
2428: i NUMBER;
2429: BEGIN

Line 3120: UPDATE bom_sub_op_resources_interface bsori

3116: FROM mtl_parameters mp2
3117: WHERE mp2.organization_code = bori.organization_code);
3118:
3119: stmt_num := 8.3;
3120: UPDATE bom_sub_op_resources_interface bsori
3121: SET organization_id = (SELECT organization_id
3122: FROM mtl_parameters mp1
3123: WHERE mp1.organization_code = bsori.organization_code)
3124: WHERE process_flag = 1

Line 3230: UPDATE bom_sub_op_resources_interface

3226: OR
3227: (p_all_org = 2 AND organization_id = p_org_id));
3228:
3229: stmt_num := 10.9;
3230: UPDATE bom_sub_op_resources_interface
3231: SET transaction_id = mtl_system_items_interface_s.nextval,
3232: transaction_type = UPPER(transaction_type)
3233: WHERE process_flag = 1
3234: AND (transaction_id is NULL

Line 6200: DELETE from bom_sub_op_resources_interface

6196: COMMIT;
6197: END LOOP;
6198: stmt_num := 522;
6199: LOOP
6200: DELETE from bom_sub_op_resources_interface
6201: WHERE process_flag = 7
6202: AND rownum < G_ROWS_TO_COMMIT;
6203:
6204: EXIT when SQL%NOTFOUND;