APPS.CSC_CUST_PLANS_AUDIT_PKG dependencies on CSC_CUST_PLANS_AUDIT

Line 1: PACKAGE BODY CSC_CUST_PLANS_AUDIT_PKG as

1: PACKAGE BODY CSC_CUST_PLANS_AUDIT_PKG as
2: /* $Header: csctcpab.pls 120.0 2005/05/30 15:46:47 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUST_PLANS_AUDIT_PKG
5: -- Purpose : Table handler package to perform inserts into

Line 4: -- Package name : CSC_CUST_PLANS_AUDIT_PKG

1: PACKAGE BODY CSC_CUST_PLANS_AUDIT_PKG as
2: /* $Header: csctcpab.pls 120.0 2005/05/30 15:46:47 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUST_PLANS_AUDIT_PKG
5: -- Purpose : Table handler package to perform inserts into
6: -- CSC_CUST_PLANS_AUDIT table. This table maintains an audit
7: -- log of the operations performed on the CSC_CUST_PLANS table.
8: -- History :

Line 6: -- CSC_CUST_PLANS_AUDIT table. This table maintains an audit

2: /* $Header: csctcpab.pls 120.0 2005/05/30 15:46:47 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUST_PLANS_AUDIT_PKG
5: -- Purpose : Table handler package to perform inserts into
6: -- CSC_CUST_PLANS_AUDIT table. This table maintains an audit
7: -- log of the operations performed on the CSC_CUST_PLANS table.
8: -- History :
9: -- MM-DD-YYYY NAME MODIFICATIONS
10: -- 10-29-1999 dejoseph Created.

Line 28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_CUST_PLANS_AUDIT_PKG';

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

Line 66: SELECT CSC_CUST_PLANS_AUDIT_S.nextval

62: p_ATTRIBUTE_CATEGORY IN VARCHAR2,
63: x_plan_audit_id OUT NOCOPY NUMBER)
64: IS
65: CURSOR C2 IS
66: SELECT CSC_CUST_PLANS_AUDIT_S.nextval
67: FROM sys.dual;
68: BEGIN
69: OPEN C2;
70: FETCH C2 INTO x_PLAN_AUDIT_ID;

Line 73: INSERT INTO CSC_CUST_PLANS_AUDIT(

69: OPEN C2;
70: FETCH C2 INTO x_PLAN_AUDIT_ID;
71: CLOSE C2;
72:
73: INSERT INTO CSC_CUST_PLANS_AUDIT(
74: PLAN_AUDIT_ID,
75: PLAN_ID,
76: PARTY_ID,
77: CUST_ACCOUNT_ID,

Line 175: Update CSC_CUST_PLANS_AUDIT

171: p_ATTRIBUTE15 IN VARCHAR2,
172: p_ATTRIBUTE_CATEGORY IN VARCHAR2 )
173: IS
174: BEGIN
175: Update CSC_CUST_PLANS_AUDIT
176: SET
177: PLAN_ID = decode( p_PLAN_ID, FND_API.G_MISS_NUM, PLAN_ID, p_PLAN_ID),
178: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
179: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),

Line 217: DELETE FROM CSC_CUST_PLANS_AUDIT

213: PROCEDURE Delete_Row(
214: p_PLAN_AUDIT_ID IN NUMBER)
215: IS
216: BEGIN
217: DELETE FROM CSC_CUST_PLANS_AUDIT
218: WHERE PLAN_AUDIT_ID = p_PLAN_AUDIT_ID;
219: If (SQL%NOTFOUND) then
220: RAISE NO_DATA_FOUND;
221: End If;

Line 260: FROM CSC_CUST_PLANS_AUDIT

256: p_OBJECT_VERSION_NUMBER IN NUMBER )
257: IS
258: CURSOR C IS
259: SELECT *
260: FROM CSC_CUST_PLANS_AUDIT
261: WHERE PLAN_AUDIT_ID = p_PLAN_AUDIT_ID
262: FOR UPDATE of PLAN_AUDIT_ID NOWAIT;
263: Recinfo C%ROWTYPE;
264: BEGIN

Line 376: End CSC_CUST_PLANS_AUDIT_PKG;

372: --APP_EXCEPTION.RAISE_EXCEPTION;
373: End If;
374: END Lock_Row;
375:
376: End CSC_CUST_PLANS_AUDIT_PKG;