APPS.INV_CONSUMPTION_PKG dependencies on MTL_CONSUMPTION_DEFINITION

Line 40: CURSOR C IS SELECT rowid FROM MTL_CONSUMPTION_DEFINITION

36: X_LAST_UPDATE_LOGIN in NUMBER,
37: x_weight IN number
38: ) is
39:
40: CURSOR C IS SELECT rowid FROM MTL_CONSUMPTION_DEFINITION
41: WHERE transaction_type_id = x_transaction_type_id
42: and nvl(ORGANIZATION_ID, nvl(X_ORGANIZATION_ID,-999))= nvl(X_ORGANIZATION_ID,-999)
43: and nvl(SUBINVENTORY_CODE, nvl(X_SUBINVENTORY_CODE,-999)) = nvl(X_SUBINVENTORY_CODE,-999)
44: and nvl(XFER_SUBINVENTORY_CODE, nvl(X_XFER_SUBINVENTORY_CODE, -999) )

Line 56: insert into MTL_CONSUMPTION_DEFINITION (

52: and nvl(PLANNING_ORGANIZATION_ID,nvl(X_PLANNING_ORGANIZATION_ID,-999))=nvl(X_PLANNING_ORGANIZATION_ID,-999);
53:
54:
55: begin
56: insert into MTL_CONSUMPTION_DEFINITION (
57: TRANSACTION_TYPE_ID,
58: ORGANIZATION_ID,
59: SUBINVENTORY_CODE,
60: XFER_SUBINVENTORY_CODE,

Line 195: from MTL_CONSUMPTION_DEFINITION

191: attribute12,
192: attribute13,
193: attribute14,
194: attribute15
195: from MTL_CONSUMPTION_DEFINITION
196: where ROWID = X_ROWID
197: for update OF TRANSACTION_TYPE_ID nowait;
198: recinfo c%rowtype;
199:

Line 309: update MTL_CONSUMPTION_DEFINITION mcd set

305: x_weight IN number
306: ) is
307:
308: begin
309: update MTL_CONSUMPTION_DEFINITION mcd set
310: transaction_type_id = X_transaction_type_id,
311: organization_id = x_organization_id,
312: subinventory_code = x_subinventory_code,
313: xfer_subinventory_code = x_XFER_SUBINVENTORY_CODE,

Line 353: delete from mtl_consumption_definition MCD

349: procedure DELETE_ROW (
350: X_ROWID in varchar2
351: ) is
352: begin
353: delete from mtl_consumption_definition MCD
354: where mcd.ROWID = X_ROWID;
355:
356: if (sql%notfound) then
357: raise no_data_found;