APPS.CS_EST_TXNS_PKG dependencies on CS_EST_DETAILS_MTL_TXNS

Line 33: cursor C is select ROWID from CS_EST_DETAILS_MTL_TXNS

29: X_CONTEXT in VARCHAR2,
30: X_ORGANIZATION_ID in NUMBER,
31: X_MODE in VARCHAR2 default 'R'
32: ) is
33: cursor C is select ROWID from CS_EST_DETAILS_MTL_TXNS
34: where DETAIL_TRANSACTION_ID = X_DETAIL_TRANSACTION_ID;
35: X_LAST_UPDATE_DATE DATE;
36: X_LAST_UPDATED_BY NUMBER;
37: X_LAST_UPDATE_LOGIN NUMBER;

Line 56: insert into CS_EST_DETAILS_MTL_TXNS (

52: else
53: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
54: app_exception.raise_exception;
55: end if;
56: insert into CS_EST_DETAILS_MTL_TXNS (
57: DETAIL_TRANSACTION_ID,
58: ESTIMATE_DETAIL_ID,
59: SERIAL_NUMBER,
60: LOT_NUMBER,

Line 184: from CS_EST_DETAILS_MTL_TXNS

180: ATTRIBUTE13,
181: ATTRIBUTE14,
182: ATTRIBUTE15,
183: CONTEXT
184: from CS_EST_DETAILS_MTL_TXNS
185: where DETAIL_TRANSACTION_ID = X_DETAIL_TRANSACTION_ID
186: for update of DETAIL_TRANSACTION_ID nowait;
187: tlinfo c1%rowtype;
188:

Line 329: update CS_EST_DETAILS_MTL_TXNS set

325: else
326: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
327: app_exception.raise_exception;
328: end if;
329: update CS_EST_DETAILS_MTL_TXNS set
330: ESTIMATE_DETAIL_ID = X_ESTIMATE_DETAIL_ID,
331: SERIAL_NUMBER = X_SERIAL_NUMBER,
332: LOT_NUMBER = X_LOT_NUMBER,
333: LOCATOR_ID = X_LOCATOR_ID,

Line 394: cursor c1 is select rowid from CS_EST_DETAILS_MTL_TXNS

390: X_ATTRIBUTE15 in VARCHAR2,
391: X_CONTEXT in VARCHAR2,
392: X_MODE in VARCHAR2 default 'R'
393: ) is
394: cursor c1 is select rowid from CS_EST_DETAILS_MTL_TXNS
395: where DETAIL_TRANSACTION_ID = X_DETAIL_TRANSACTION_ID
396: ;
397: dummy c1%rowtype;
398: begin

Line 467: delete from CS_EST_DETAILS_MTL_TXNS

463: procedure DELETE_ROW (
464: X_ROWID in VARCHAR2
465: ) is
466: begin
467: delete from CS_EST_DETAILS_MTL_TXNS
468: WHERE rowid = X_Rowid;
469: if (sql%notfound) then
470: raise no_data_found;
471: end if;