APPS.CS_SR_LOAD_BALANCE_WT_PKG dependencies on CS_SR_LOAD_BALANCE_WT

Line 1: package body CS_SR_LOAD_BALANCE_WT_PKG as

1: package body CS_SR_LOAD_BALANCE_WT_PKG as
2: /* $Header: csviwetb.pls 115.6 2002/12/11 02:01:37 dejoseph noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_WEIGHT_ID in NUMBER,

Line 43: cursor C is select ROWID from CS_SR_LOAD_BALANCE_WT

39: X_LAST_UPDATE_DATE in DATE,
40: X_LAST_UPDATED_BY in NUMBER,
41: X_LAST_UPDATE_LOGIN in NUMBER)
42: is
43: cursor C is select ROWID from CS_SR_LOAD_BALANCE_WT
44: where WEIGHT_ID = X_WEIGHT_ID
45: ;
46: begin
47: insert into CS_SR_LOAD_BALANCE_WT (

Line 47: insert into CS_SR_LOAD_BALANCE_WT (

43: cursor C is select ROWID from CS_SR_LOAD_BALANCE_WT
44: where WEIGHT_ID = X_WEIGHT_ID
45: ;
46: begin
47: insert into CS_SR_LOAD_BALANCE_WT (
48: WEIGHT_ID ,
49: INCIDENT_TYPE_ID ,
50: INCIDENT_SEVERITY_ID ,
51: START_DATE_ACTIVE ,

Line 200: from CS_SR_LOAD_BALANCE_WT

196: ATTRIBUTE14 ,
197: ATTRIBUTE15 ,
198: CONTEXT,
199: OBJECT_VERSION_NUMBER
200: from CS_SR_LOAD_BALANCE_WT
201: where WEIGHT_ID = X_WEIGHT_ID
202: for update of WEIGHT_ID nowait;
203: recinfo c%rowtype;
204:

Line 323: update CS_SR_LOAD_BALANCE_WT set

319: X_LAST_UPDATED_BY in NUMBER,
320: X_LAST_UPDATE_LOGIN in NUMBER
321: ) is
322: begin
323: update CS_SR_LOAD_BALANCE_WT set
324: INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID,
325: INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID,
326: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
327: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 369: delete from CS_SR_LOAD_BALANCE_WT

365: procedure DELETE_ROW(
366: X_WEIGHT_ID in NUMBER)
367: is
368: begin
369: delete from CS_SR_LOAD_BALANCE_WT
370: where WEIGHT_ID = X_WEIGHT_ID;
371:
372: if(sql%notfound) then
373: raise no_data_found;

Line 378: end CS_SR_LOAD_BALANCE_WT_PKG;

374: end if;
375:
376: end DELETE_ROW;
377:
378: end CS_SR_LOAD_BALANCE_WT_PKG;