APPS.BOMPCMBM dependencies on BOM_BILL_OF_MATERIALS

Line 155: UPDATE BOM_BILL_OF_MATERIALS bbm

151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));
152: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_commit: ' || p_commit);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
154: IF FND_API.To_Boolean(p_commit) THEN
155: UPDATE BOM_BILL_OF_MATERIALS bbm
156: SET bbm.request_id = p_request_id
157: WHERE bbm.organization_id = p_organization_id
158: AND bbm.assembly_item_id = p_assembly_item_id
159: AND nvl(bbm.alternate_bom_designator,'NONE') = nvl(p_alternate,'NONE')

Line 270: FROM BOM_BILL_OF_MATERIALS bbm1

266: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
267:
268: -- Storing the original request_id column value in a temporary variable
269: SELECT request_id INTO p_orig_request_id
270: FROM BOM_BILL_OF_MATERIALS bbm1
271: WHERE bbm1.organization_id = current_org_id
272: AND bbm1.assembly_item_id = common_item_from
273: AND nvl(bbm1.alternate_bom_designator,'NONE') = nvl(alternate,'NONE');
274:

Line 286: update BOM_BILL_OF_MATERIALS bbm2

282: request will be continued. To make visible the stamped request_id column value to all sessions
283: COMMIT is required. Actual Common BOM process not started yet, so autonomous transaction not
284: required in this case. */
285:
286: update BOM_BILL_OF_MATERIALS bbm2
287: set bbm2.request_id = P_COMMONBOM_IS_RUNNING
288: WHERE nvl(bbm2.request_id, 0) <> P_ECOIMPL_IS_RUNNING
289: AND bbm2.organization_id = current_org_id
290: AND bbm2.assembly_item_id = common_item_from