APPS.CS_SR_SAVED_ADV_CRITERIA_PKG dependencies on CS_SR_SAVED_ADV_CRITERIA

Line 1: package body CS_SR_SAVED_ADV_CRITERIA_PKG as

1: package body CS_SR_SAVED_ADV_CRITERIA_PKG as
2: /* $Header: csxtssab.pls 115.2 2003/12/16 08:31:50 aktripat noship $*/
3:
4: procedure INSERT_ROW ( X_ROWID in out nocopy VARCHAR2,
5: X_SEARCH_ID in NUMBER,

Line 20: cursor C is select ROWID from CS_SR_SAVED_ADV_CRITERIA

16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER,
18: X_COMMIT_FLAG in VARCHAR2) is
19:
20: cursor C is select ROWID from CS_SR_SAVED_ADV_CRITERIA
21: where SEARCH_ID = X_SEARCH_ID
22: and FIELD_NAME = X_FIELD_NAME ;
23:
24: begin

Line 26: insert into CS_SR_SAVED_ADV_CRITERIA (

22: and FIELD_NAME = X_FIELD_NAME ;
23:
24: begin
25:
26: insert into CS_SR_SAVED_ADV_CRITERIA (
27: ROWNUM_IN_LAYOUT,
28: FIELD_NAME,
29: FIELD_NAME_ID,
30: CONDITION,

Line 105: delete from CS_SR_SAVED_ADV_CRITERIA

101: procedure DELETE_ROW ( X_SEARCH_ID in NUMBER) is
102:
103: begin
104:
105: delete from CS_SR_SAVED_ADV_CRITERIA
106: where SEARCH_ID = X_SEARCH_ID;
107:
108: if (sql%notfound) then
109: raise no_data_found;

Line 114: end CS_SR_SAVED_ADV_CRITERIA_PKG;

110: end if;
111:
112: end DELETE_ROW;
113:
114: end CS_SR_SAVED_ADV_CRITERIA_PKG;