APPS.CS_SR_SAVED_SEARCHES_PKG dependencies on CS_SR_SAVED_SEARCHES_B

Line 15: cursor C is select ROWID from CS_SR_SAVED_SEARCHES_B where SEARCH_ID = X_SEARCH_ID ;

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER) is
14:
15: cursor C is select ROWID from CS_SR_SAVED_SEARCHES_B where SEARCH_ID = X_SEARCH_ID ;
16:
17: begin
18: select CS_SR_SAVED_SEARCHES_S.NEXTVAL into x_Search_id from dual;
19:

Line 20: Insert into CS_SR_SAVED_SEARCHES_B (

16:
17: begin
18: select CS_SR_SAVED_SEARCHES_S.NEXTVAL into x_Search_id from dual;
19:
20: Insert into CS_SR_SAVED_SEARCHES_B (
21: OBJECT_VERSION_NUMBER,
22: SEARCH_ID,
23: USER_ID,
24: CREATION_DATE,

Line 84: delete from CS_SR_SAVED_SEARCHES_B where SEARCH_ID = X_SEARCH_ID;

80: if (sql%notfound) then
81: raise no_data_found;
82: end if;
83:
84: delete from CS_SR_SAVED_SEARCHES_B where SEARCH_ID = X_SEARCH_ID;
85:
86: if (sql%notfound) then
87: raise no_data_found;
88: end if ;

Line 99: (select NULL from CS_SR_SAVED_SEARCHES_B B

95: BEGIN
96:
97: delete from CS_SR_SAVED_SEARCHES_TL T
98: where not exists
99: (select NULL from CS_SR_SAVED_SEARCHES_B B
100: where B.SEARCH_ID = T.SEARCH_ID );
101:
102: update CS_SR_SAVED_SEARCHES_TL T set (
103: NAME ) = ( select B.NAME from CS_SR_SAVED_SEARCHES_TL B