APPS.WSH_CONSOL_BATCHES_PKG dependencies on WSH_CONSOL_BATCHES

Line 1: package body WSH_CONSOL_BATCHES_PKG as

1: package body WSH_CONSOL_BATCHES_PKG as
2: /* $Header: WSHTMCBB.pls 120.1 2005/09/08 14:03:10 wrudge noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_BATCH_ID in out nocopy NUMBER,

Line 47: CURSOR C IS SELECT rowid FROM WSH_CONSOL_BATCHES

43: ) is
44: user_id NUMBER;
45: login_id NUMBER;
46: l_batch_id NUMBER;
47: CURSOR C IS SELECT rowid FROM WSH_CONSOL_BATCHES
48: WHERE batch_id = l_batch_id;
49: --
50: CURSOR NEXTID IS SELECT wsh_consol_batches_s.nextval FROM sys.dual;
51: begin

Line 50: CURSOR NEXTID IS SELECT wsh_consol_batches_s.nextval FROM sys.dual;

46: l_batch_id NUMBER;
47: CURSOR C IS SELECT rowid FROM WSH_CONSOL_BATCHES
48: WHERE batch_id = l_batch_id;
49: --
50: CURSOR NEXTID IS SELECT wsh_consol_batches_s.nextval FROM sys.dual;
51: begin
52: user_id := FND_GLOBAL.USER_ID;
53: login_id := FND_GLOBAL.LOGIN_ID;
54:

Line 60: insert into WSH_CONSOL_BATCHES (

56: OPEN NEXTID;
57: FETCH NEXTID INTO l_batch_id;
58: CLOSE NEXTID;
59: END IF;
60: insert into WSH_CONSOL_BATCHES (
61: FREIGHT_TERMS_CODE,
62: CARRIER_ID,
63: MODE_OF_TRANSPORT,
64: SERVICE_LEVEL,

Line 217: from WSH_CONSOL_BATCHES

213: SHIP_TO_OVERIDE_FLAG,
214: DROPOFF_END_DAYS,
215: PR_BATCH_ID,
216: BATCH_ID
217: from WSH_CONSOL_BATCHES
218: where BATCH_ID = X_BATCH_ID
219: for update of BATCH_ID nowait;
220: begin
221:

Line 310: END WSH_CONSOL_BATCHES_PKG;

306: app_exception.raise_exception;
307: end if;
308: return;
309: end LOCK_ROW;*/
310: END WSH_CONSOL_BATCHES_PKG;