APPS.CSP_LOOP_CALC_RULES_B_PKG dependencies on CSP_LOOP_CALC_RULES_B

Line 1: PACKAGE BODY CSP_LOOP_CALC_RULES_B_PKG as

1: PACKAGE BODY CSP_LOOP_CALC_RULES_B_PKG as
2: /* $Header: csptpcrb.pls 115.9 2002/11/26 07:13:40 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_LOOP_CALC_RULES_B_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_LOOP_CALC_RULES_B_PKG

1: PACKAGE BODY CSP_LOOP_CALC_RULES_B_PKG as
2: /* $Header: csptpcrb.pls 115.9 2002/11/26 07:13:40 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_LOOP_CALC_RULES_B_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_LOOP_CALC_RULES_B_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_LOOP_CALC_RULES_B_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptpcrb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_CALCULATION_RULE_ID IN OUT NOCOPY NUMBER,

Line 56: CURSOR C2 IS SELECT CSP_LOOP_CALC_RULES_B_S1.nextval FROM sys.dual;

52: p_ATTRIBUTE15 VARCHAR2,
53: p_DESCRIPTION VARCHAR2 )
54:
55: IS
56: CURSOR C2 IS SELECT CSP_LOOP_CALC_RULES_B_S1.nextval FROM sys.dual;
57:
58: CURSOR C3 is select ROWID from CSP_LOOP_CALC_RULES_B
59: where CALCULATION_RULE_ID = px_CALCULATION_RULE_ID;
60:

Line 58: CURSOR C3 is select ROWID from CSP_LOOP_CALC_RULES_B

54:
55: IS
56: CURSOR C2 IS SELECT CSP_LOOP_CALC_RULES_B_S1.nextval FROM sys.dual;
57:
58: CURSOR C3 is select ROWID from CSP_LOOP_CALC_RULES_B
59: where CALCULATION_RULE_ID = px_CALCULATION_RULE_ID;
60:
61: p_ROWID VARCHAR2(30);
62:

Line 69: INSERT INTO CSP_LOOP_CALC_RULES_B(

65: OPEN C2;
66: FETCH C2 INTO px_CALCULATION_RULE_ID;
67: CLOSE C2;
68: End If;
69: INSERT INTO CSP_LOOP_CALC_RULES_B(
70: CALCULATION_RULE_ID,
71: CREATED_BY,
72: CREATION_DATE,
73: LAST_UPDATED_BY,

Line 230: Update CSP_LOOP_CALC_RULES_B

226: p_DESCRIPTION VARCHAR2 )
227:
228: IS
229: BEGIN
230: Update CSP_LOOP_CALC_RULES_B
231: SET
232: CALCULATION_RULE_ID = decode( p_CALCULATION_RULE_ID, FND_API.G_MISS_NUM, CALCULATION_RULE_ID, p_CALCULATION_RULE_ID),
233: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 303: DELETE FROM CSP_LOOP_CALC_RULES_B

299: if (sql%notfound) then
300: raise no_data_found;
301: end if;
302:
303: DELETE FROM CSP_LOOP_CALC_RULES_B
304: WHERE CALCULATION_RULE_ID = p_CALCULATION_RULE_ID;
305: If (SQL%NOTFOUND) then
306: RAISE NO_DATA_FOUND;
307: End If;

Line 354: FROM CSP_LOOP_CALC_RULES_B

350:
351: IS
352: CURSOR C IS
353: SELECT *
354: FROM CSP_LOOP_CALC_RULES_B
355: WHERE CALCULATION_RULE_ID = p_CALCULATION_RULE_ID
356: FOR UPDATE of CALCULATION_RULE_ID NOWAIT;
357: Recinfo C%ROWTYPE;
358:

Line 521: from CSP_LOOP_CALC_RULES_B B

517: begin
518: delete from CSP_LOOP_CALC_RULES_TL T
519: where not exists
520: (select NULL
521: from CSP_LOOP_CALC_RULES_B B
522: where B.CALCULATION_RULE_ID = T.CALCULATION_RULE_ID
523: );
524:
525: update CSP_LOOP_CALC_RULES_TL T set (

Line 722: End CSP_LOOP_CALC_RULES_B_PKG;

718: RAISE;
719:
720: END Load_Row;
721:
722: End CSP_LOOP_CALC_RULES_B_PKG;