APPS.MTL_TRANSACTION_LOTS_INTF_PKG dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 131: insert into MTL_TRANSACTION_LOTS_INTERFACE (

127: --SELECT mtl_material_transactions_s.NEXTVAL
128: --INTO l_transaction_interface_id FROM dual;
129: --l_transaction_quantity := 10;
130:
131: insert into MTL_TRANSACTION_LOTS_INTERFACE (
132: EXPIRATION_ACTION_CODE,
133: EXPIRATION_ACTION_DATE,
134: HOLD_DATE,
135: ORIGINATION_TYPE,

Line 603: from MTL_TRANSACTION_LOTS_INTERFACE

599: PARENT_OBJECT_TYPE2,
600: PARENT_OBJECT_ID2,
601: PARENT_OBJECT_NUMBER2,
602: PARENT_ITEM_ID
603: from MTL_TRANSACTION_LOTS_INTERFACE
604: where ROWID = X_ROWID
605: for update of TRANSACTION_INTERFACE_ID nowait;
606: recinfo c%rowtype;
607:

Line 974: update MTL_TRANSACTION_LOTS_INTERFACE SET

970: X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
971: X_PARENT_ITEM_ID IN NUMBER
972: ) is
973: begin
974: update MTL_TRANSACTION_LOTS_INTERFACE SET
975: TRANSACTION_INTERFACE_ID=X_TRANSACTION_INTERFACE_ID,
976: EXPIRATION_ACTION_CODE = X_EXPIRATION_ACTION_CODE,
977: EXPIRATION_ACTION_DATE = X_EXPIRATION_ACTION_DATE,
978: HOLD_DATE = X_HOLD_DATE,

Line 1094: insert into MTL_TRANSACTION_LOTS_INTERFACE (

1090: PARENT_ITEM_ID = X_PARENT_ITEM_ID
1091: where ROWID = X_ROWID;
1092:
1093: if (sql%notfound) then
1094: insert into MTL_TRANSACTION_LOTS_INTERFACE (
1095: EXPIRATION_ACTION_CODE,
1096: EXPIRATION_ACTION_DATE,
1097: HOLD_DATE,
1098: ORIGINATION_TYPE,

Line 1342: delete from MTL_TRANSACTION_LOTS_INTERFACE

1338: X_ROWID IN ROWID
1339: ) is
1340: begin
1341:
1342: delete from MTL_TRANSACTION_LOTS_INTERFACE
1343: where ROWID = X_ROWID;
1344:
1345: if (sql%notfound) then
1346: raise no_data_found;