APPS.CSC_CUSTOMIZED_PLANS_PKG dependencies on CSC_CUSTOMIZED_PLANS

Line 1: PACKAGE BODY CSC_CUSTOMIZED_PLANS_PKG as

1: PACKAGE BODY CSC_CUSTOMIZED_PLANS_PKG as
2: /* $Header: csctcupb.pls 115.15 2002/11/25 06:12:33 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUSTOMIZED_PLANS_PKG
5: -- Purpose : Table handler package to insert and delete rows in

Line 4: -- Package name : CSC_CUSTOMIZED_PLANS_PKG

1: PACKAGE BODY CSC_CUSTOMIZED_PLANS_PKG as
2: /* $Header: csctcupb.pls 115.15 2002/11/25 06:12:33 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUSTOMIZED_PLANS_PKG
5: -- Purpose : Table handler package to insert and delete rows in
6: -- CSC_CUSTOMIZED_PLANS table.
7: -- History :
8: -- DD-MM-YYYY NAME MODIFICATIONS

Line 6: -- CSC_CUSTOMIZED_PLANS table.

2: /* $Header: csctcupb.pls 115.15 2002/11/25 06:12:33 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUSTOMIZED_PLANS_PKG
5: -- Purpose : Table handler package to insert and delete rows in
6: -- CSC_CUSTOMIZED_PLANS table.
7: -- History :
8: -- DD-MM-YYYY NAME MODIFICATIONS
9: -- 11-04-1999 dejoseph Created.
10: -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.

Line 29: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_CUSTOMIZED_PLANS_PKG';

25: -- NOTE :
26: -- End of Comments
27:
28:
29: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_CUSTOMIZED_PLANS_PKG';
30: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctcupb.pls';
31:
32: PROCEDURE Insert_Row(
33: px_ID IN OUT NOCOPY NUMBER,

Line 44: SELECT CSC_CUSTOMIZED_PLANS_S.nextval

40: p_program_update_date IN DATE,
41: p_plan_status_code IN VARCHAR2)
42: IS
43: CURSOR C2 IS
44: SELECT CSC_CUSTOMIZED_PLANS_S.nextval
45: FROM sys.dual;
46: BEGIN
47: OPEN C2;
48: FETCH C2 INTO px_ID;

Line 51: INSERT INTO CSC_CUSTOMIZED_PLANS(

47: OPEN C2;
48: FETCH C2 INTO px_ID;
49: CLOSE C2;
50:
51: INSERT INTO CSC_CUSTOMIZED_PLANS(
52: ID,
53: PLAN_ID,
54: PARTY_ID ,
55: CUST_ACCOUNT_ID ,

Line 82: DELETE FROM CSC_CUSTOMIZED_PLANS

78: P_PARTY_ID IN NUMBER)
79: IS
80: BEGIN
81: if ( P_ID IS NOT NULL OR P_ID <> FND_API.G_MISS_NUM ) THEN
82: DELETE FROM CSC_CUSTOMIZED_PLANS
83: WHERE ID = p_ID;
84: elsif ( P_PLAN_ID IS NOT NULL OR P_PLAN_ID <> FND_API.G_MISS_NUM ) THEN
85: IF ( P_PARTY_ID IS NOT NULL OR P_PARTY_ID <> FND_API.G_MISS_NUM ) THEN
86: DELETE FROM CSC_CUSTOMIZED_PLANS

Line 86: DELETE FROM CSC_CUSTOMIZED_PLANS

82: DELETE FROM CSC_CUSTOMIZED_PLANS
83: WHERE ID = p_ID;
84: elsif ( P_PLAN_ID IS NOT NULL OR P_PLAN_ID <> FND_API.G_MISS_NUM ) THEN
85: IF ( P_PARTY_ID IS NOT NULL OR P_PARTY_ID <> FND_API.G_MISS_NUM ) THEN
86: DELETE FROM CSC_CUSTOMIZED_PLANS
87: WHERE PLAN_ID = P_PLAN_ID
88: AND PARTY_ID = P_PARTY_ID;
89: ELSE
90: DELETE FROM CSC_CUSTOMIZED_PLANS

Line 90: DELETE FROM CSC_CUSTOMIZED_PLANS

86: DELETE FROM CSC_CUSTOMIZED_PLANS
87: WHERE PLAN_ID = P_PLAN_ID
88: AND PARTY_ID = P_PARTY_ID;
89: ELSE
90: DELETE FROM CSC_CUSTOMIZED_PLANS
91: WHERE PLAN_ID = P_PLAN_ID;
92: END IF;
93: else
94: DELETE FROM CSC_CUSTOMIZED_PLANS

Line 94: DELETE FROM CSC_CUSTOMIZED_PLANS

90: DELETE FROM CSC_CUSTOMIZED_PLANS
91: WHERE PLAN_ID = P_PLAN_ID;
92: END IF;
93: else
94: DELETE FROM CSC_CUSTOMIZED_PLANS
95: WHERE PARTY_ID = P_PARTY_ID;
96: end if;
97:
98: If (SQL%NOTFOUND) then

Line 104: End CSC_CUSTOMIZED_PLANS_PKG;

100: End If;
101:
102: END Delete_Row;
103:
104: End CSC_CUSTOMIZED_PLANS_PKG;