APPS.CS_SR_SAVED_BSC_CRITERIA_PKG dependencies on CS_SR_SAVED_BSC_CRITERIA

Line 1: package body CS_SR_SAVED_BSC_CRITERIA_PKG as

1: package body CS_SR_SAVED_BSC_CRITERIA_PKG as
2: /* $Header: csxtssbb.pls 115.1 2003/09/18 04:46:12 aktripat noship $*/
3:
4: procedure INSERT_ROW ( X_ROWID in out nocopy VARCHAR2,
5: X_SEARCH_ID in NUMBER,

Line 17: cursor C is select ROWID from CS_SR_SAVED_BSC_CRITERIA

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER,
15: X_COMMIT_FLAG in VARCHAR2) is
16:
17: cursor C is select ROWID from CS_SR_SAVED_BSC_CRITERIA
18: where SEARCH_ID = X_SEARCH_ID and FIELD_NAME = X_FIELD_NAME ;
19:
20: begin
21:

Line 22: insert into CS_SR_SAVED_BSC_CRITERIA (

18: where SEARCH_ID = X_SEARCH_ID and FIELD_NAME = X_FIELD_NAME ;
19:
20: begin
21:
22: insert into CS_SR_SAVED_BSC_CRITERIA (
23: SEARCH_ID,
24: LAST_UPDATE_DATE,
25: LAST_UPDATED_BY,
26: CREATION_DATE,

Line 69: from CS_SR_SAVED_BSC_CRITERIA

65: X_FIELD_VALUE in VARCHAR2) is
66:
67: cursor c1 is select FIELD_TYPE, OBJECT_VERSION_NUMBER,
68: SECURITY_GROUP_ID, FIELD_VALUE, FIELD_NAME
69: from CS_SR_SAVED_BSC_CRITERIA
70: where SEARCH_ID = X_SEARCH_ID
71: and FIELD_NAME = X_FIELD_NAME for update of SEARCH_ID nowait;
72:
73: begin

Line 98: delete from CS_SR_SAVED_BSC_CRITERIA where SEARCH_ID = X_SEARCH_ID;

94: procedure DELETE_ROW ( X_SEARCH_ID in NUMBER) is
95:
96: begin
97:
98: delete from CS_SR_SAVED_BSC_CRITERIA where SEARCH_ID = X_SEARCH_ID;
99: if (sql%notfound) then
100: raise no_data_found;
101: end if;
102: end DELETE_ROW;

Line 103: end CS_SR_SAVED_BSC_CRITERIA_PKG;

99: if (sql%notfound) then
100: raise no_data_found;
101: end if;
102: end DELETE_ROW;
103: end CS_SR_SAVED_BSC_CRITERIA_PKG;