APPS.CSD_SC_RECOMMENDATIONS_PKG dependencies on CSD_SC_RECOMMENDATIONS_B

Line 22: cursor C is select ROWID from CSD_SC_RECOMMENDATIONS_B

18: ) is
19:
20: P_ROWID ROWID;
21:
22: cursor C is select ROWID from CSD_SC_RECOMMENDATIONS_B
23: where SC_RECOMMENDATION_ID = PX_SC_RECOMMENDATION_ID
24: ;
25:
26: begin

Line 32: insert into CSD_SC_RECOMMENDATIONS_B (

28: select CSD_SC_RECOMMENDATIONS_S1.nextval
29: into PX_SC_RECOMMENDATION_ID
30: from dual;
31:
32: insert into CSD_SC_RECOMMENDATIONS_B (
33: SC_DOMAIN_ID,
34: RECOMMENDATION_TYPE_CODE,
35: ACTIVE_FROM,
36: ACTIVE_TO,

Line 102: from CSD_SC_RECOMMENDATIONS_B

98: P_OBJECT_VERSION_NUMBER in NUMBER
99: ) is
100: cursor c is select
101: OBJECT_VERSION_NUMBER
102: from CSD_SC_RECOMMENDATIONS_B
103: where SC_RECOMMENDATION_ID = P_SC_RECOMMENDATION_ID
104: for update of SC_RECOMMENDATION_ID nowait;
105: recinfo c%rowtype;
106:

Line 156: update CSD_SC_RECOMMENDATIONS_B set

152: P_LAST_UPDATED_BY in NUMBER,
153: P_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: begin
156: update CSD_SC_RECOMMENDATIONS_B set
157: SC_DOMAIN_ID = P_SC_DOMAIN_ID,
158: RECOMMENDATION_TYPE_CODE = P_RECOMMENDATION_TYPE_CODE,
159: ACTIVE_FROM = P_ACTIVE_FROM,
160: ACTIVE_TO = P_ACTIVE_TO,

Line 197: delete from CSD_SC_RECOMMENDATIONS_B

193: if (sql%notfound) then
194: raise no_data_found;
195: end if;
196:
197: delete from CSD_SC_RECOMMENDATIONS_B
198: where SC_RECOMMENDATION_ID = P_SC_RECOMMENDATION_ID;
199:
200: if (sql%notfound) then
201: raise no_data_found;

Line 211: from CSD_SC_RECOMMENDATIONS_B B

207: begin
208: delete from CSD_SC_RECOMMENDATIONS_TL T
209: where not exists
210: (select NULL
211: from CSD_SC_RECOMMENDATIONS_B B
212: where B.SC_RECOMMENDATION_ID = T.SC_RECOMMENDATION_ID
213: );
214:
215: update CSD_SC_RECOMMENDATIONS_TL T set (