APPS.CN_SYIN_RULESETS_PKG dependencies on CN_RULESETS_ALL_B

Line 55: insert into CN_RULESETS_ALL_B

51:
52: BEGIN
53:
54:
55: insert into CN_RULESETS_ALL_B
56: (
57: RULESET_STATUS,
58: RULESET_ID,
59: DESTINATION_COLUMN_ID,

Line 158: update CN_RULESETS_ALL_B set

154: X_ORG_ID in NUMBER
155: ) is
156: BEGIN
157:
158: update CN_RULESETS_ALL_B set
159: RULESET_STATUS = X_RULESET_STATUS,
160: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
161: DESTINATION_COLUMN_ID = X_DESTINATION_COLUMN_ID,
162: REPOSITORY_ID = X_REPOSITORY_ID,

Line 204: delete from CN_RULESETS_ALL_B

200: if (sql%notfound) then
201: raise no_data_found;
202: end if;
203:
204: delete from CN_RULESETS_ALL_B
205: where RULESET_ID = x_ruleset_id AND
206: ORG_ID=X_ORG_ID;
207:
208: if (sql%notfound) then

Line 219: from CN_RULESETS_ALL_B B

215: begin
216: delete from CN_RULESETS_ALL_TL T
217: where not exists
218: (select NULL
219: from CN_RULESETS_ALL_B B
220: where B.RULESET_ID = T.ruleset_id
221: and B.ORG_ID = T.ORG_ID
222: );
223:

Line 313: UPDATE cn_rulesets_all_b SET

309: ELSE
310: user_id := 0;
311: END IF;
312: -- Load The record to _B table
313: UPDATE cn_rulesets_all_b SET
314: destination_column_id = x_destination_column_id,
315: repository_id = x_repository_id,
316: ruleset_status = x_ruleset_status,
317: last_update_date = sysdate,

Line 324: INSERT INTO cn_rulesets_all_b

320: WHERE ruleset_id = x_ruleset_id and org_id=x_org_id ;
321:
322: IF (SQL%NOTFOUND) THEN
323: -- Insert new record to _B table
324: INSERT INTO cn_rulesets_all_b
325: (RULESET_ID,
326: DESTINATION_COLUMN_ID,
327: REPOSITORY_ID,
328: RULESET_STATUS,