APPS.CSP_BUSINESS_RULES_PKG dependencies on CSP_BUSINESS_RULES_B

Line 63: CURSOR C2 IS SELECT CSP_BUSINESS_RULES_B_S1.nextval FROM sys.dual;

59: p_ATTRIBUTE14 VARCHAR2,
60: p_ATTRIBUTE15 VARCHAR2
61: )
62: IS
63: CURSOR C2 IS SELECT CSP_BUSINESS_RULES_B_S1.nextval FROM sys.dual;
64: BEGIN
65: If (px_BUSINESS_RULE_ID IS NULL) then
66: OPEN C2;
67: FETCH C2 INTO px_BUSINESS_RULE_ID;

Line 70: INSERT INTO CSP_BUSINESS_RULES_B(

66: OPEN C2;
67: FETCH C2 INTO px_BUSINESS_RULE_ID;
68: CLOSE C2;
69: End If;
70: INSERT INTO CSP_BUSINESS_RULES_B(
71: BUSINESS_RULE_ID,
72: CREATED_BY,
73: CREATION_DATE,
74: LAST_UPDATED_BY,

Line 239: Update CSP_BUSINESS_RULES_B

235: p_ATTRIBUTE14 VARCHAR2,
236: p_ATTRIBUTE15 VARCHAR2)
237: IS
238: BEGIN
239: Update CSP_BUSINESS_RULES_B
240: SET
241: CREATED_BY = p_CREATED_BY,
242: CREATION_DATE = p_CREATION_DATE,
243: LAST_UPDATED_BY = p_LAST_UPDATED_BY,

Line 317: DELETE FROM CSP_BUSINESS_RULES_B

313: if (sql%notfound) then
314: raise no_data_found;
315: end if;
316:
317: DELETE FROM CSP_BUSINESS_RULES_B
318: WHERE BUSINESS_RULE_ID = p_BUSINESS_RULE_ID;
319: If (SQL%NOTFOUND) then
320: RAISE NO_DATA_FOUND;
321: End If;

Line 373: FROM CSP_BUSINESS_RULES_B

369: p_ATTRIBUTE15 VARCHAR2)
370: IS
371: CURSOR C IS
372: SELECT *
373: FROM CSP_BUSINESS_RULES_B
374: WHERE BUSINESS_RULE_ID = p_BUSINESS_RULE_ID
375: FOR UPDATE of BUSINESS_RULE_ID NOWAIT;
376:
377: cursor c1 is select

Line 557: from CSP_BUSINESS_RULES_B B

553: begin
554: delete from CSP_BUSINESS_RULES_TL T
555: where not exists
556: (select NULL
557: from CSP_BUSINESS_RULES_B B
558: where B.BUSINESS_RULE_ID = T.BUSINESS_RULE_ID
559: );
560:
561: update CSP_BUSINESS_RULES_TL T set (