APPS.MTL_TXN_INTERFACE_PKG dependencies on MTL_TRANSACTIONS_INTERFACE

Line 304: cursor C is select ROWID from MTL_TRANSACTIONS_INTERFACE

300: X_LAST_UPDATE_DATE in DATE,
301: X_LAST_UPDATED_BY in NUMBER,
302: X_LAST_UPDATE_LOGIN in NUMBER
303: ) is
304: cursor C is select ROWID from MTL_TRANSACTIONS_INTERFACE
305: where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
306: ;
307: begin
308: insert into MTL_TRANSACTIONS_INTERFACE (

Line 308: insert into MTL_TRANSACTIONS_INTERFACE (

304: cursor C is select ROWID from MTL_TRANSACTIONS_INTERFACE
305: where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
306: ;
307: begin
308: insert into MTL_TRANSACTIONS_INTERFACE (
309: PLANNING_ORGANIZATION_ID,
310: PLANNING_TP_TYPE,
311: XFR_PLANNING_ORGANIZATION_ID,
312: TRANSFER_PLANNING_TP_TYPE,

Line 1503: from MTL_TRANSACTIONS_INTERFACE

1499: LOC_SEGMENT8,
1500: LOC_SEGMENT9,
1501: LOC_SEGMENT10,
1502: LOC_SEGMENT11
1503: from MTL_TRANSACTIONS_INTERFACE
1504: where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
1505: for update of TRANSACTION_INTERFACE_ID nowait;
1506: recinfo c%rowtype;
1507:

Line 2401: update MTL_TRANSACTIONS_INTERFACE set

2397: ) IS
2398: l_item_id NUMBER := NULL;
2399: l_rowid VARCHAR2(100) := NULL;
2400: begin
2401: update MTL_TRANSACTIONS_INTERFACE set
2402: PLANNING_ORGANIZATION_ID = X_PLANNING_ORGANIZATION_ID,
2403: PLANNING_TP_TYPE = X_PLANNING_TP_TYPE,
2404: XFR_PLANNING_ORGANIZATION_ID = X_XFR_PLANNING_ORGANIZATION_ID,
2405: TRANSFER_PLANNING_TP_TYPE = X_TRANSFER_PLANNING_TP_TYPE,

Line 3016: delete from MTL_TRANSACTIONS_INTERFACE

3012: X_TRANSACTION_INTERFACE_ID in NUMBER
3013: ) is
3014: begin
3015:
3016: delete from MTL_TRANSACTIONS_INTERFACE
3017: where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID;
3018:
3019: if (sql%notfound) then
3020: raise no_data_found;