APPS.MTL_SERIAL_NUMBERS_INTERF_PKG dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 120: insert into MTL_SERIAL_NUMBERS_INTERFACE (

116: --SELECT mtl_material_transactions_s.NEXTVAL
117: --INTO l_transaction_interface_id FROM dual;
118: l_transaction_quantity := 10;
119:
120: insert into MTL_SERIAL_NUMBERS_INTERFACE (
121: PRODUCT_TRANSACTION_ID,
122: TRANSACTION_INTERFACE_ID,
123: SOURCE_CODE,
124: SOURCE_LINE_ID,

Line 548: from MTL_SERIAL_NUMBERS_INTERFACE

544: PARENT_OBJECT_TYPE2,
545: PARENT_OBJECT_ID2,
546: PARENT_OBJECT_NUMBER2,
547: PARENT_ITEM_ID
548: from MTL_SERIAL_NUMBERS_INTERFACE
549: where ROWID=X_ROWID
550: for update of TRANSACTION_INTERFACE_ID nowait;
551: recinfo c%rowtype;
552:

Line 886: update MTL_SERIAL_NUMBERS_INTERFACE SET

882: X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
883: X_PARENT_ITEM_ID IN NUMBER
884: ) is
885: begin
886: update MTL_SERIAL_NUMBERS_INTERFACE SET
887: transaction_interface_id = x_transaction_interface_id,
888: PRODUCT_TRANSACTION_ID = X_PRODUCT_TRANSACTION_ID,
889: SOURCE_CODE = X_SOURCE_CODE,
890: SOURCE_LINE_ID = X_SOURCE_LINE_ID,

Line 995: insert into MTL_SERIAL_NUMBERS_INTERFACE

991: PARENT_ITEM_ID = X_PARENT_ITEM_ID
992: where ROWID=X_ROWID;
993:
994: if (sql%notfound) then
995: insert into MTL_SERIAL_NUMBERS_INTERFACE
996: (
997: PRODUCT_TRANSACTION_ID,
998: TRANSACTION_INTERFACE_ID,
999: SOURCE_CODE,

Line 1221: delete from MTL_SERIAL_NUMBERS_INTERFACE

1217: procedure DELETE_ROW (
1218: X_ROWID IN ROWID
1219: ) is
1220: begin
1221: delete from MTL_SERIAL_NUMBERS_INTERFACE
1222: where ROWID=X_ROWID;
1223:
1224: if (sql%notfound) then
1225: raise no_data_found;