[Home] [Help]
1: PACKAGE BODY CSC_CUST_PLANS_PVT as
2: /* $Header: cscvctpb.pls 115.18 2003/05/01 23:23:57 jamose ship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUST_PLANS_PVT
5: -- Purpose : Private package to perform inserts, updates and deletes operations
1: PACKAGE BODY CSC_CUST_PLANS_PVT as
2: /* $Header: cscvctpb.pls 115.18 2003/05/01 23:23:57 jamose ship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUST_PLANS_PVT
5: -- Purpose : Private package to perform inserts, updates and deletes operations
6: -- on CSC_CUST_PLANS table. It contains procedure to perform item
7: -- level validations if the validation level is set to 100 (FULL).
8: -- History :
2: /* $Header: cscvctpb.pls 115.18 2003/05/01 23:23:57 jamose ship $ */
3: -- Start of Comments
4: -- Package name : CSC_CUST_PLANS_PVT
5: -- Purpose : Private package to perform inserts, updates and deletes operations
6: -- on CSC_CUST_PLANS table. It contains procedure to perform item
7: -- level validations if the validation level is set to 100 (FULL).
8: -- History :
9: -- MM-DD-YYYY NAME MODIFICATIONS
10: -- 10-28-1999 dejoseph Created.
23: -- hz_cust_accounts table. Also removed references to all
24: -- 'HZ_' tables and used 'JTF_'.
25: -- Removed reference to cust_account_org.
26: -- 10-23-2000 dejoseph Removed references to px_plan_audit_id when invoking procedure
27: -- to perform insert into CSC_CUST_PLANS_AUDIT table. Fix to
28: -- Bug # 1467071.
29: -- NOCOPY changes made for OUT parameters
30: --
31: -- 26-11-2002 bhroy G_MISS_XXX defaults of API parameters removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
34: -- reference is 2935833
35: -- NOTE :
36: -- End of Comments
37:
38: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_CUST_PLANS_PVT';
39: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvctpb.pls';
40:
41: PROCEDURE CONVERT_COLUMNS_TO_REC_TYPE(
42: P_PLAN_ID IN NUMBER ,
73: P_ATTRIBUTE14 IN VARCHAR2,
74: P_ATTRIBUTE15 IN VARCHAR2,
75: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
76: P_OBJECT_VERSION_NUMBER IN NUMBER,
77: X_CSC_CUST_PLANS_REC_TYPE OUT NOCOPY CSC_CUST_PLANS_REC_TYPE )
78: IS
79: BEGIN
80: x_csc_cust_plans_rec_type.PLAN_ID := P_PLAN_ID ;
81: x_csc_cust_plans_rec_type.CUST_PLAN_ID := P_CUST_PLAN_ID ;
76: P_OBJECT_VERSION_NUMBER IN NUMBER,
77: X_CSC_CUST_PLANS_REC_TYPE OUT NOCOPY CSC_CUST_PLANS_REC_TYPE )
78: IS
79: BEGIN
80: x_csc_cust_plans_rec_type.PLAN_ID := P_PLAN_ID ;
81: x_csc_cust_plans_rec_type.CUST_PLAN_ID := P_CUST_PLAN_ID ;
82: x_csc_cust_plans_rec_type.PARTY_ID := P_PARTY_ID ;
83: x_csc_cust_plans_rec_type.CUST_ACCOUNT_ID := P_CUST_ACCOUNT_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
77: X_CSC_CUST_PLANS_REC_TYPE OUT NOCOPY CSC_CUST_PLANS_REC_TYPE )
78: IS
79: BEGIN
80: x_csc_cust_plans_rec_type.PLAN_ID := P_PLAN_ID ;
81: x_csc_cust_plans_rec_type.CUST_PLAN_ID := P_CUST_PLAN_ID ;
82: x_csc_cust_plans_rec_type.PARTY_ID := P_PARTY_ID ;
83: x_csc_cust_plans_rec_type.CUST_ACCOUNT_ID := P_CUST_ACCOUNT_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
78: IS
79: BEGIN
80: x_csc_cust_plans_rec_type.PLAN_ID := P_PLAN_ID ;
81: x_csc_cust_plans_rec_type.CUST_PLAN_ID := P_CUST_PLAN_ID ;
82: x_csc_cust_plans_rec_type.PARTY_ID := P_PARTY_ID ;
83: x_csc_cust_plans_rec_type.CUST_ACCOUNT_ID := P_CUST_ACCOUNT_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
79: BEGIN
80: x_csc_cust_plans_rec_type.PLAN_ID := P_PLAN_ID ;
81: x_csc_cust_plans_rec_type.CUST_PLAN_ID := P_CUST_PLAN_ID ;
82: x_csc_cust_plans_rec_type.PARTY_ID := P_PARTY_ID ;
83: x_csc_cust_plans_rec_type.CUST_ACCOUNT_ID := P_CUST_ACCOUNT_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
80: x_csc_cust_plans_rec_type.PLAN_ID := P_PLAN_ID ;
81: x_csc_cust_plans_rec_type.CUST_PLAN_ID := P_CUST_PLAN_ID ;
82: x_csc_cust_plans_rec_type.PARTY_ID := P_PARTY_ID ;
83: x_csc_cust_plans_rec_type.CUST_ACCOUNT_ID := P_CUST_ACCOUNT_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
81: x_csc_cust_plans_rec_type.CUST_PLAN_ID := P_CUST_PLAN_ID ;
82: x_csc_cust_plans_rec_type.PARTY_ID := P_PARTY_ID ;
83: x_csc_cust_plans_rec_type.CUST_ACCOUNT_ID := P_CUST_ACCOUNT_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
82: x_csc_cust_plans_rec_type.PARTY_ID := P_PARTY_ID ;
83: x_csc_cust_plans_rec_type.CUST_ACCOUNT_ID := P_CUST_ACCOUNT_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
83: x_csc_cust_plans_rec_type.CUST_ACCOUNT_ID := P_CUST_ACCOUNT_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
84: -- x_csc_cust_plans_rec_type.CUST_ACCOUNT_ORG := P_CUST_ACCOUNT_ORG ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
85: x_csc_cust_plans_rec_type.START_DATE_ACTIVE := P_START_DATE_ACTIVE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
86: x_csc_cust_plans_rec_type.END_DATE_ACTIVE := P_END_DATE_ACTIVE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
87: x_csc_cust_plans_rec_type.MANUAL_FLAG := P_MANUAL_FLAG ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
88: x_csc_cust_plans_rec_type.PLAN_STATUS_CODE := P_PLAN_STATUS_CODE ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
89: x_csc_cust_plans_rec_type.REQUEST_ID := P_REQUEST_ID ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
90: x_csc_cust_plans_rec_type.PROGRAM_APPLICATION_ID := P_PROGRAM_APPLICATION_ID ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
91: x_csc_cust_plans_rec_type.PROGRAM_ID := P_PROGRAM_ID ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
92: x_csc_cust_plans_rec_type.PROGRAM_UPDATE_DATE := P_PROGRAM_UPDATE_DATE ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
93: x_csc_cust_plans_rec_type.CREATION_DATE := P_CREATION_DATE ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
94: x_csc_cust_plans_rec_type.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
95: x_csc_cust_plans_rec_type.CREATED_BY := P_CREATED_BY ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
96: x_csc_cust_plans_rec_type.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
97: x_csc_cust_plans_rec_type.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
98: x_csc_cust_plans_rec_type.ATTRIBUTE1 := P_ATTRIBUTE1 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
99: x_csc_cust_plans_rec_type.ATTRIBUTE2 := P_ATTRIBUTE2 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
100: x_csc_cust_plans_rec_type.ATTRIBUTE3 := P_ATTRIBUTE3 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
101: x_csc_cust_plans_rec_type.ATTRIBUTE4 := P_ATTRIBUTE4 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
102: x_csc_cust_plans_rec_type.ATTRIBUTE5 := P_ATTRIBUTE5 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
103: x_csc_cust_plans_rec_type.ATTRIBUTE6 := P_ATTRIBUTE6 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
111: x_csc_cust_plans_rec_type.ATTRIBUTE14 := P_ATTRIBUTE14 ;
104: x_csc_cust_plans_rec_type.ATTRIBUTE7 := P_ATTRIBUTE7 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
111: x_csc_cust_plans_rec_type.ATTRIBUTE14 := P_ATTRIBUTE14 ;
112: x_csc_cust_plans_rec_type.ATTRIBUTE15 := P_ATTRIBUTE15 ;
105: x_csc_cust_plans_rec_type.ATTRIBUTE8 := P_ATTRIBUTE8 ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
111: x_csc_cust_plans_rec_type.ATTRIBUTE14 := P_ATTRIBUTE14 ;
112: x_csc_cust_plans_rec_type.ATTRIBUTE15 := P_ATTRIBUTE15 ;
113: x_csc_cust_plans_rec_type.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
106: x_csc_cust_plans_rec_type.ATTRIBUTE9 := P_ATTRIBUTE9 ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
111: x_csc_cust_plans_rec_type.ATTRIBUTE14 := P_ATTRIBUTE14 ;
112: x_csc_cust_plans_rec_type.ATTRIBUTE15 := P_ATTRIBUTE15 ;
113: x_csc_cust_plans_rec_type.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
114: x_csc_cust_plans_rec_type.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
107: x_csc_cust_plans_rec_type.ATTRIBUTE10 := P_ATTRIBUTE10 ;
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
111: x_csc_cust_plans_rec_type.ATTRIBUTE14 := P_ATTRIBUTE14 ;
112: x_csc_cust_plans_rec_type.ATTRIBUTE15 := P_ATTRIBUTE15 ;
113: x_csc_cust_plans_rec_type.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
114: x_csc_cust_plans_rec_type.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
115:
108: x_csc_cust_plans_rec_type.ATTRIBUTE11 := P_ATTRIBUTE11 ;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
111: x_csc_cust_plans_rec_type.ATTRIBUTE14 := P_ATTRIBUTE14 ;
112: x_csc_cust_plans_rec_type.ATTRIBUTE15 := P_ATTRIBUTE15 ;
113: x_csc_cust_plans_rec_type.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
114: x_csc_cust_plans_rec_type.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
115:
116: END CONVERT_COLUMNS_TO_REC_TYPE;
109: x_csc_cust_plans_rec_type.ATTRIBUTE12 := P_ATTRIBUTE12 ;
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
111: x_csc_cust_plans_rec_type.ATTRIBUTE14 := P_ATTRIBUTE14 ;
112: x_csc_cust_plans_rec_type.ATTRIBUTE15 := P_ATTRIBUTE15 ;
113: x_csc_cust_plans_rec_type.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
114: x_csc_cust_plans_rec_type.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
115:
116: END CONVERT_COLUMNS_TO_REC_TYPE;
117:
110: x_csc_cust_plans_rec_type.ATTRIBUTE13 := P_ATTRIBUTE13 ;
111: x_csc_cust_plans_rec_type.ATTRIBUTE14 := P_ATTRIBUTE14 ;
112: x_csc_cust_plans_rec_type.ATTRIBUTE15 := P_ATTRIBUTE15 ;
113: x_csc_cust_plans_rec_type.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
114: x_csc_cust_plans_rec_type.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
115:
116: END CONVERT_COLUMNS_TO_REC_TYPE;
117:
118: /*** Overloaded proc. that accepts a detailed parameter list, converts the list
165: X_Msg_Count OUT NOCOPY NUMBER,
166: X_Msg_Data OUT NOCOPY VARCHAR2
167: )
168: IS
169: l_csc_cust_plans_rec CSC_CUST_PLANS_REC_TYPE;
170: BEGIN
171:
172: CONVERT_COLUMNS_TO_REC_TYPE(
173: P_PLAN_ID => P_PLAN_ID ,
204: P_ATTRIBUTE14 => P_ATTRIBUTE14 ,
205: P_ATTRIBUTE15 => P_ATTRIBUTE15 ,
206: P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY ,
207: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER ,
208: X_CSC_CUST_PLANS_REC_TYPE => l_csc_cust_plans_rec );
209:
210: -- issue a call to the create_cust_plans proc. with the record type parameter
211: Create_cust_plans(
212: P_Api_Version_Number => p_api_version_number,
212: P_Api_Version_Number => p_api_version_number,
213: P_Init_Msg_List => p_init_msg_list,
214: P_Commit => p_commit,
215: P_Validation_level => p_validation_level,
216: P_CSC_CUST_PLANS_Rec => l_csc_cust_plans_rec,
217: X_CUST_PLAN_ID => x_cust_plan_id,
218: X_OBJECT_VERSION_NUMBER => x_object_version_number,
219: X_Return_Status => x_return_status,
220: X_Msg_Count => x_msg_count,
227: P_Api_Version_Number IN NUMBER,
228: P_Init_Msg_List IN VARCHAR2,
229: P_Commit IN VARCHAR2,
230: p_validation_level IN NUMBER ,
231: P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type ,
232: X_CUST_PLAN_ID OUT NOCOPY NUMBER,
233: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
234: X_Return_Status OUT NOCOPY VARCHAR2,
235: X_Msg_Count OUT NOCOPY NUMBER,
247: l_api_name CONSTANT VARCHAR2(30) := 'Create_cust_plans';
248: l_api_version_number CONSTANT NUMBER := 1.0;
249: l_return_status_full VARCHAR2(1);
250:
251: l_start_date_active DATE := p_csc_cust_plans_rec.start_date_active;
252: l_end_date_active DATE := p_csc_cust_plans_rec.end_date_active;
253: BEGIN
254: -- Standard Start of API savepoint
255: SAVEPOINT CREATE_CUST_PLANS_PVT;
248: l_api_version_number CONSTANT NUMBER := 1.0;
249: l_return_status_full VARCHAR2(1);
250:
251: l_start_date_active DATE := p_csc_cust_plans_rec.start_date_active;
252: l_end_date_active DATE := p_csc_cust_plans_rec.end_date_active;
253: BEGIN
254: -- Standard Start of API savepoint
255: SAVEPOINT CREATE_CUST_PLANS_PVT;
256:
288:
289: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
290: THEN
291: -- Invoke validation procedures
292: Validate_csc_cust_plans(
293: p_init_msg_list => FND_API.G_FALSE,
294: p_validation_level => p_validation_level,
295: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
296: P_CSC_CUST_PLANS_Rec => P_CSC_CUST_PLANS_Rec,
292: Validate_csc_cust_plans(
293: p_init_msg_list => FND_API.G_FALSE,
294: p_validation_level => p_validation_level,
295: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
296: P_CSC_CUST_PLANS_Rec => P_CSC_CUST_PLANS_Rec,
297: x_return_status => x_return_status,
298: x_msg_count => x_msg_count,
299: x_msg_data => x_msg_data);
300: END IF;
305:
306: -- if either start_date_active or end_date_active is passed in as null, then
307: -- retreive these value from the csc_plan_headers_b table for the given plan_id;
308:
309: if (( p_csc_cust_plans_rec.START_DATE_ACTIVE is NULL OR
310: p_csc_cust_plans_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) OR
311: ( p_csc_cust_plans_rec.END_DATE_ACTIVE is NULL OR
312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
306: -- if either start_date_active or end_date_active is passed in as null, then
307: -- retreive these value from the csc_plan_headers_b table for the given plan_id;
308:
309: if (( p_csc_cust_plans_rec.START_DATE_ACTIVE is NULL OR
310: p_csc_cust_plans_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) OR
311: ( p_csc_cust_plans_rec.END_DATE_ACTIVE is NULL OR
312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
314: FETCH c1 INTO l_start_date_active, l_end_date_active;
307: -- retreive these value from the csc_plan_headers_b table for the given plan_id;
308:
309: if (( p_csc_cust_plans_rec.START_DATE_ACTIVE is NULL OR
310: p_csc_cust_plans_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) OR
311: ( p_csc_cust_plans_rec.END_DATE_ACTIVE is NULL OR
312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
314: FETCH c1 INTO l_start_date_active, l_end_date_active;
315: IF C1%NOTFOUND THEN
308:
309: if (( p_csc_cust_plans_rec.START_DATE_ACTIVE is NULL OR
310: p_csc_cust_plans_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) OR
311: ( p_csc_cust_plans_rec.END_DATE_ACTIVE is NULL OR
312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
314: FETCH c1 INTO l_start_date_active, l_end_date_active;
315: IF C1%NOTFOUND THEN
316: --FND_MESSAGE.SET_NAME(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, '
309: if (( p_csc_cust_plans_rec.START_DATE_ACTIVE is NULL OR
310: p_csc_cust_plans_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) OR
311: ( p_csc_cust_plans_rec.END_DATE_ACTIVE is NULL OR
312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
314: FETCH c1 INTO l_start_date_active, l_end_date_active;
315: IF C1%NOTFOUND THEN
316: --FND_MESSAGE.SET_NAME(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, '
317: CLOSE c1;
319: END IF;
320: CLOSE c1;
321: end if;
322:
323: x_cust_plan_id := p_csc_cust_plans_rec.cust_plan_id;
324:
325: -- Invoke table handler(CSC_CUST_PLANS_PKG.Insert_Row)
326: CSC_CUST_PLANS_PKG.Insert_Row(
327: px_CUST_PLAN_ID => x_CUST_PLAN_ID,
321: end if;
322:
323: x_cust_plan_id := p_csc_cust_plans_rec.cust_plan_id;
324:
325: -- Invoke table handler(CSC_CUST_PLANS_PKG.Insert_Row)
326: CSC_CUST_PLANS_PKG.Insert_Row(
327: px_CUST_PLAN_ID => x_CUST_PLAN_ID,
328: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID,
329: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID,
322:
323: x_cust_plan_id := p_csc_cust_plans_rec.cust_plan_id;
324:
325: -- Invoke table handler(CSC_CUST_PLANS_PKG.Insert_Row)
326: CSC_CUST_PLANS_PKG.Insert_Row(
327: px_CUST_PLAN_ID => x_CUST_PLAN_ID,
328: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID,
329: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID,
330: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
324:
325: -- Invoke table handler(CSC_CUST_PLANS_PKG.Insert_Row)
326: CSC_CUST_PLANS_PKG.Insert_Row(
327: px_CUST_PLAN_ID => x_CUST_PLAN_ID,
328: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID,
329: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID,
330: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
331: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
332: p_START_DATE_ACTIVE => l_start_date_active,
325: -- Invoke table handler(CSC_CUST_PLANS_PKG.Insert_Row)
326: CSC_CUST_PLANS_PKG.Insert_Row(
327: px_CUST_PLAN_ID => x_CUST_PLAN_ID,
328: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID,
329: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID,
330: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
331: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
332: p_START_DATE_ACTIVE => l_start_date_active,
333: p_END_DATE_ACTIVE => l_end_date_active,
326: CSC_CUST_PLANS_PKG.Insert_Row(
327: px_CUST_PLAN_ID => x_CUST_PLAN_ID,
328: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID,
329: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID,
330: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
331: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
332: p_START_DATE_ACTIVE => l_start_date_active,
333: p_END_DATE_ACTIVE => l_end_date_active,
334: p_MANUAL_FLAG => p_CSC_CUST_PLANS_rec.MANUAL_FLAG,
327: px_CUST_PLAN_ID => x_CUST_PLAN_ID,
328: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID,
329: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID,
330: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
331: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
332: p_START_DATE_ACTIVE => l_start_date_active,
333: p_END_DATE_ACTIVE => l_end_date_active,
334: p_MANUAL_FLAG => p_CSC_CUST_PLANS_rec.MANUAL_FLAG,
335: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
330: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
331: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
332: p_START_DATE_ACTIVE => l_start_date_active,
333: p_END_DATE_ACTIVE => l_end_date_active,
334: p_MANUAL_FLAG => p_CSC_CUST_PLANS_rec.MANUAL_FLAG,
335: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
336: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID,
337: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
338: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID,
332: p_START_DATE_ACTIVE => l_start_date_active,
333: p_END_DATE_ACTIVE => l_end_date_active,
334: p_MANUAL_FLAG => p_CSC_CUST_PLANS_rec.MANUAL_FLAG,
335: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
336: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID,
337: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
338: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID,
339: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
340: p_CREATION_DATE => SYSDATE,
333: p_END_DATE_ACTIVE => l_end_date_active,
334: p_MANUAL_FLAG => p_CSC_CUST_PLANS_rec.MANUAL_FLAG,
335: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
336: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID,
337: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
338: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID,
339: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
340: p_CREATION_DATE => SYSDATE,
341: p_LAST_UPDATE_DATE => SYSDATE,
334: p_MANUAL_FLAG => p_CSC_CUST_PLANS_rec.MANUAL_FLAG,
335: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
336: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID,
337: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
338: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID,
339: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
340: p_CREATION_DATE => SYSDATE,
341: p_LAST_UPDATE_DATE => SYSDATE,
342: p_CREATED_BY => FND_GLOBAL.USER_ID,
335: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
336: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID,
337: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
338: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID,
339: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
340: p_CREATION_DATE => SYSDATE,
341: p_LAST_UPDATE_DATE => SYSDATE,
342: p_CREATED_BY => FND_GLOBAL.USER_ID,
343: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
341: p_LAST_UPDATE_DATE => SYSDATE,
342: p_CREATED_BY => FND_GLOBAL.USER_ID,
343: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
344: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
345: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
342: p_CREATED_BY => FND_GLOBAL.USER_ID,
343: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
344: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
345: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
343: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
344: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
345: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
344: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
345: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
345: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
349: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
357: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13,
350: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
357: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13,
358: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14,
351: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
357: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13,
358: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14,
359: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15,
352: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
357: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13,
358: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14,
359: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15,
360: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
353: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9,
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
357: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13,
358: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14,
359: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15,
360: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
361: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
354: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10,
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
357: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13,
358: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14,
359: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15,
360: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
361: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
362:
355: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11,
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
357: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13,
358: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14,
359: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15,
360: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
361: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
362:
363: -- For every operation on the CSC_CUST_PLANS table insert a record in the
356: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12,
357: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13,
358: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14,
359: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15,
360: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
361: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
362:
363: -- For every operation on the CSC_CUST_PLANS table insert a record in the
364: -- CSC_CUST_PLANS_AUDIT table.
359: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15,
360: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
361: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
362:
363: -- For every operation on the CSC_CUST_PLANS table insert a record in the
364: -- CSC_CUST_PLANS_AUDIT table.
365:
366: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
367: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
360: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
361: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
362:
363: -- For every operation on the CSC_CUST_PLANS table insert a record in the
364: -- CSC_CUST_PLANS_AUDIT table.
365:
366: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
367: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
368: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID ,
362:
363: -- For every operation on the CSC_CUST_PLANS table insert a record in the
364: -- CSC_CUST_PLANS_AUDIT table.
365:
366: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
367: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
368: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID ,
369: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID ,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,
364: -- CSC_CUST_PLANS_AUDIT table.
365:
366: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
367: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
368: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID ,
369: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID ,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,
371: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG ,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
365:
366: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
367: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
368: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID ,
369: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID ,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,
371: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG ,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
373: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID ,
366: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
367: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
368: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID ,
369: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID ,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,
371: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG ,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
373: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID ,
374: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID ,
367: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
368: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID ,
369: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID ,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,
371: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG ,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
373: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID ,
374: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID ,
375: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID ,
369: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID ,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,
371: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG ,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
373: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID ,
374: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID ,
375: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID ,
376: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE ,
377: p_CREATION_DATE => SYSDATE,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,
371: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG ,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
373: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID ,
374: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID ,
375: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID ,
376: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE ,
377: p_CREATION_DATE => SYSDATE,
378: p_LAST_UPDATE_DATE => SYSDATE,
371: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG ,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
373: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID ,
374: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID ,
375: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID ,
376: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE ,
377: p_CREATION_DATE => SYSDATE,
378: p_LAST_UPDATE_DATE => SYSDATE,
379: p_CREATED_BY => FND_GLOBAL.USER_ID,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
373: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID ,
374: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID ,
375: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID ,
376: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE ,
377: p_CREATION_DATE => SYSDATE,
378: p_LAST_UPDATE_DATE => SYSDATE,
379: p_CREATED_BY => FND_GLOBAL.USER_ID,
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
378: p_LAST_UPDATE_DATE => SYSDATE,
379: p_CREATED_BY => FND_GLOBAL.USER_ID,
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
382: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
379: p_CREATED_BY => FND_GLOBAL.USER_ID,
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
382: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
382: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
381: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
382: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
382: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
386: p_ATTRIBUTE5 => p_CSC_CUST_PLANS_rec.ATTRIBUTE5 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
394: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13 ,
387: p_ATTRIBUTE6 => p_CSC_CUST_PLANS_rec.ATTRIBUTE6 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
394: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13 ,
395: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14 ,
388: p_ATTRIBUTE7 => p_CSC_CUST_PLANS_rec.ATTRIBUTE7 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
394: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13 ,
395: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14 ,
396: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15 ,
389: p_ATTRIBUTE8 => p_CSC_CUST_PLANS_rec.ATTRIBUTE8 ,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
394: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13 ,
395: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14 ,
396: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15 ,
397: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
390: p_ATTRIBUTE9 => p_CSC_CUST_PLANS_rec.ATTRIBUTE9 ,
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
394: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13 ,
395: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14 ,
396: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15 ,
397: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
398: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
391: p_ATTRIBUTE10 => p_CSC_CUST_PLANS_rec.ATTRIBUTE10 ,
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
394: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13 ,
395: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14 ,
396: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15 ,
397: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
398: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
399:
392: p_ATTRIBUTE11 => p_CSC_CUST_PLANS_rec.ATTRIBUTE11 ,
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
394: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13 ,
395: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14 ,
396: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15 ,
397: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
398: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
399:
400: -- Standard check for p_commit
393: p_ATTRIBUTE12 => p_CSC_CUST_PLANS_rec.ATTRIBUTE12 ,
394: p_ATTRIBUTE13 => p_CSC_CUST_PLANS_rec.ATTRIBUTE13 ,
395: p_ATTRIBUTE14 => p_CSC_CUST_PLANS_rec.ATTRIBUTE14 ,
396: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15 ,
397: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
398: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
399:
400: -- Standard check for p_commit
401: IF FND_API.to_Boolean( p_commit )
494: X_Msg_Count OUT NOCOPY NUMBER,
495: X_Msg_Data OUT NOCOPY VARCHAR2
496: )
497: IS
498: l_csc_cust_plans_rec CSC_CUST_PLANS_REC_TYPE;
499: BEGIN
500:
501: CONVERT_COLUMNS_TO_REC_TYPE(
502: P_PLAN_ID => P_PLAN_ID ,
533: P_ATTRIBUTE14 => P_ATTRIBUTE14 ,
534: P_ATTRIBUTE15 => P_ATTRIBUTE15 ,
535: P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY ,
536: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER ,
537: X_CSC_CUST_PLANS_REC_TYPE => l_csc_cust_plans_rec );
538:
539: -- issue a call to the create_cust_plans proc. with the record type parameter
540: Update_cust_plans(
541: P_Api_Version_Number => p_api_version_number,
541: P_Api_Version_Number => p_api_version_number,
542: P_Init_Msg_List => p_init_msg_list,
543: P_Commit => p_commit,
544: p_validation_level => p_validation_level,
545: P_CSC_CUST_PLANS_Rec => l_csc_cust_plans_rec,
546: X_OBJECT_VERSION_NUMBER => x_object_version_number,
547: X_Return_Status => x_return_status,
548: X_Msg_Count => x_msg_count,
549: X_Msg_Data => x_msg_data);
555: P_Api_Version_Number IN NUMBER,
556: P_Init_Msg_List IN VARCHAR2,
557: P_Commit IN VARCHAR2,
558: p_validation_level IN NUMBER ,
559: P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type,
560: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
561: X_Return_Status OUT NOCOPY VARCHAR2,
562: X_Msg_Count OUT NOCOPY NUMBER,
563: X_Msg_Data OUT NOCOPY VARCHAR2
575: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
576: ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,
577: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,
578: ATTRIBUTE15, ATTRIBUTE_CATEGORY, OBJECT_VERSION_NUMBER
579: From CSC_CUST_PLANS
580: WHERE CUST_PLAN_ID = nvl(p_csc_cust_plans_rec.cust_plan_id, cust_plan_id)
581: AND PLAN_ID = nvl(p_csc_cust_plans_rec.plan_id, plan_id)
582: AND PARTY_ID = nvl(p_csc_cust_plans_rec.party_id, party_id)
583: AND nvl(CUST_ACCOUNT_ID,0) = nvl(p_csc_cust_plans_rec.cust_account_id,
576: ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,
577: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,
578: ATTRIBUTE15, ATTRIBUTE_CATEGORY, OBJECT_VERSION_NUMBER
579: From CSC_CUST_PLANS
580: WHERE CUST_PLAN_ID = nvl(p_csc_cust_plans_rec.cust_plan_id, cust_plan_id)
581: AND PLAN_ID = nvl(p_csc_cust_plans_rec.plan_id, plan_id)
582: AND PARTY_ID = nvl(p_csc_cust_plans_rec.party_id, party_id)
583: AND nvl(CUST_ACCOUNT_ID,0) = nvl(p_csc_cust_plans_rec.cust_account_id,
584: nvl(cust_account_id,0) );
577: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,
578: ATTRIBUTE15, ATTRIBUTE_CATEGORY, OBJECT_VERSION_NUMBER
579: From CSC_CUST_PLANS
580: WHERE CUST_PLAN_ID = nvl(p_csc_cust_plans_rec.cust_plan_id, cust_plan_id)
581: AND PLAN_ID = nvl(p_csc_cust_plans_rec.plan_id, plan_id)
582: AND PARTY_ID = nvl(p_csc_cust_plans_rec.party_id, party_id)
583: AND nvl(CUST_ACCOUNT_ID,0) = nvl(p_csc_cust_plans_rec.cust_account_id,
584: nvl(cust_account_id,0) );
585:
578: ATTRIBUTE15, ATTRIBUTE_CATEGORY, OBJECT_VERSION_NUMBER
579: From CSC_CUST_PLANS
580: WHERE CUST_PLAN_ID = nvl(p_csc_cust_plans_rec.cust_plan_id, cust_plan_id)
581: AND PLAN_ID = nvl(p_csc_cust_plans_rec.plan_id, plan_id)
582: AND PARTY_ID = nvl(p_csc_cust_plans_rec.party_id, party_id)
583: AND nvl(CUST_ACCOUNT_ID,0) = nvl(p_csc_cust_plans_rec.cust_account_id,
584: nvl(cust_account_id,0) );
585:
586: l_api_name CONSTANT VARCHAR2(30) := 'Update_cust_plans';
579: From CSC_CUST_PLANS
580: WHERE CUST_PLAN_ID = nvl(p_csc_cust_plans_rec.cust_plan_id, cust_plan_id)
581: AND PLAN_ID = nvl(p_csc_cust_plans_rec.plan_id, plan_id)
582: AND PARTY_ID = nvl(p_csc_cust_plans_rec.party_id, party_id)
583: AND nvl(CUST_ACCOUNT_ID,0) = nvl(p_csc_cust_plans_rec.cust_account_id,
584: nvl(cust_account_id,0) );
585:
586: l_api_name CONSTANT VARCHAR2(30) := 'Update_cust_plans';
587: l_api_version_number CONSTANT NUMBER := 1.0;
585:
586: l_api_name CONSTANT VARCHAR2(30) := 'Update_cust_plans';
587: l_api_version_number CONSTANT NUMBER := 1.0;
588:
589: l_ref_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type;
590: --l_tar_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_Rec;
591: l_upd_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_REC;
592: l_rowid ROWID;
593: BEGIN
586: l_api_name CONSTANT VARCHAR2(30) := 'Update_cust_plans';
587: l_api_version_number CONSTANT NUMBER := 1.0;
588:
589: l_ref_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type;
590: --l_tar_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_Rec;
591: l_upd_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_REC;
592: l_rowid ROWID;
593: BEGIN
594: -- Standard Start of API savepoint
587: l_api_version_number CONSTANT NUMBER := 1.0;
588:
589: l_ref_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type;
590: --l_tar_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_Rec;
591: l_upd_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_REC;
592: l_rowid ROWID;
593: BEGIN
594: -- Standard Start of API savepoint
595: SAVEPOINT UPDATE_CUST_PLANS_PVT;
611:
612: -- Initialize API return status to SUCCESS
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: CSC_CUST_PLANS_PKG.Lock_Row(
616: p_CUST_PLAN_ID => p_csc_cust_plans_rec.cust_plan_id,
617: p_PLAN_ID => p_csc_cust_plans_rec.plan_id,
618: p_PARTY_ID => p_csc_cust_plans_rec.party_id,
619: P_CUST_ACCOUNT_ID => p_csc_cust_plans_rec.cust_account_id,
612: -- Initialize API return status to SUCCESS
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: CSC_CUST_PLANS_PKG.Lock_Row(
616: p_CUST_PLAN_ID => p_csc_cust_plans_rec.cust_plan_id,
617: p_PLAN_ID => p_csc_cust_plans_rec.plan_id,
618: p_PARTY_ID => p_csc_cust_plans_rec.party_id,
619: P_CUST_ACCOUNT_ID => p_csc_cust_plans_rec.cust_account_id,
620: -- P_CUST_ACCOUNT_ORG => p_csc_cust_plans_rec.cust_account_org,
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: CSC_CUST_PLANS_PKG.Lock_Row(
616: p_CUST_PLAN_ID => p_csc_cust_plans_rec.cust_plan_id,
617: p_PLAN_ID => p_csc_cust_plans_rec.plan_id,
618: p_PARTY_ID => p_csc_cust_plans_rec.party_id,
619: P_CUST_ACCOUNT_ID => p_csc_cust_plans_rec.cust_account_id,
620: -- P_CUST_ACCOUNT_ORG => p_csc_cust_plans_rec.cust_account_org,
621: p_OBJECT_VERSION_NUMBER => p_csc_cust_plans_rec.object_version_number);
614:
615: CSC_CUST_PLANS_PKG.Lock_Row(
616: p_CUST_PLAN_ID => p_csc_cust_plans_rec.cust_plan_id,
617: p_PLAN_ID => p_csc_cust_plans_rec.plan_id,
618: p_PARTY_ID => p_csc_cust_plans_rec.party_id,
619: P_CUST_ACCOUNT_ID => p_csc_cust_plans_rec.cust_account_id,
620: -- P_CUST_ACCOUNT_ORG => p_csc_cust_plans_rec.cust_account_org,
621: p_OBJECT_VERSION_NUMBER => p_csc_cust_plans_rec.object_version_number);
622:
615: CSC_CUST_PLANS_PKG.Lock_Row(
616: p_CUST_PLAN_ID => p_csc_cust_plans_rec.cust_plan_id,
617: p_PLAN_ID => p_csc_cust_plans_rec.plan_id,
618: p_PARTY_ID => p_csc_cust_plans_rec.party_id,
619: P_CUST_ACCOUNT_ID => p_csc_cust_plans_rec.cust_account_id,
620: -- P_CUST_ACCOUNT_ORG => p_csc_cust_plans_rec.cust_account_org,
621: p_OBJECT_VERSION_NUMBER => p_csc_cust_plans_rec.object_version_number);
622:
623: Open C_Get_cust_plans;
616: p_CUST_PLAN_ID => p_csc_cust_plans_rec.cust_plan_id,
617: p_PLAN_ID => p_csc_cust_plans_rec.plan_id,
618: p_PARTY_ID => p_csc_cust_plans_rec.party_id,
619: P_CUST_ACCOUNT_ID => p_csc_cust_plans_rec.cust_account_id,
620: -- P_CUST_ACCOUNT_ORG => p_csc_cust_plans_rec.cust_account_org,
621: p_OBJECT_VERSION_NUMBER => p_csc_cust_plans_rec.object_version_number);
622:
623: Open C_Get_cust_plans;
624:
617: p_PLAN_ID => p_csc_cust_plans_rec.plan_id,
618: p_PARTY_ID => p_csc_cust_plans_rec.party_id,
619: P_CUST_ACCOUNT_ID => p_csc_cust_plans_rec.cust_account_id,
620: -- P_CUST_ACCOUNT_ORG => p_csc_cust_plans_rec.cust_account_org,
621: p_OBJECT_VERSION_NUMBER => p_csc_cust_plans_rec.object_version_number);
622:
623: Open C_Get_cust_plans;
624:
625: Fetch C_Get_cust_plans into
623: Open C_Get_cust_plans;
624:
625: Fetch C_Get_cust_plans into
626: l_rowid,
627: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
628: l_ref_CSC_CUST_PLANS_rec.PLAN_ID,
629: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
630: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
624:
625: Fetch C_Get_cust_plans into
626: l_rowid,
627: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
628: l_ref_CSC_CUST_PLANS_rec.PLAN_ID,
629: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
630: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
625: Fetch C_Get_cust_plans into
626: l_rowid,
627: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
628: l_ref_CSC_CUST_PLANS_rec.PLAN_ID,
629: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
630: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
626: l_rowid,
627: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
628: l_ref_CSC_CUST_PLANS_rec.PLAN_ID,
629: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
630: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
627: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
628: l_ref_CSC_CUST_PLANS_rec.PLAN_ID,
629: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
630: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
628: l_ref_CSC_CUST_PLANS_rec.PLAN_ID,
629: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
630: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
629: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
630: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
630: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
631: -- l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
632: l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
633: l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
634: l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
635: l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
636: l_ref_CSC_CUST_PLANS_rec.REQUEST_ID,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
637: l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
638: l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
639: l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
640: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
641: l_ref_CSC_CUST_PLANS_rec.CREATION_DATE,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
642: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATED_BY,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
643: l_ref_CSC_CUST_PLANS_rec.CREATED_BY,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
644: l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_LOGIN,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
645: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
646: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
647: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
648: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
649: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
650: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
658: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14,
651: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
658: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14,
659: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15,
652: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
658: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14,
659: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15,
660: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
653: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9,
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
658: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14,
659: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15,
660: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
661: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
654: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10,
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
658: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14,
659: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15,
660: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
661: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
662:
655: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11,
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
658: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14,
659: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15,
660: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
661: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
662:
663: If ( C_Get_cust_plans%NOTFOUND) Then
656: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12,
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
658: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14,
659: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15,
660: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
661: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
662:
663: If ( C_Get_cust_plans%NOTFOUND) Then
664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
657: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13,
658: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14,
659: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15,
660: l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
661: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
662:
663: If ( C_Get_cust_plans%NOTFOUND) Then
664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
665: THEN
671: raise FND_API.G_EXC_ERROR;
672: END IF;
673: Close C_Get_cust_plans;
674:
675: l_upd_csc_cust_plans_rec.cust_account_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.cust_account_id, l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID);
676:
677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);
678:
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
673: Close C_Get_cust_plans;
674:
675: l_upd_csc_cust_plans_rec.cust_account_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.cust_account_id, l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID);
676:
677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);
678:
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
680:
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
675: l_upd_csc_cust_plans_rec.cust_account_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.cust_account_id, l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID);
676:
677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);
678:
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
680:
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
682:
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);
678:
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
680:
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
682:
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
684:
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
680:
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
682:
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
684:
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
686:
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
682:
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
684:
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
686:
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
688:
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
684:
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
686:
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
688:
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
690:
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
686:
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
688:
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
690:
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
692:
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
688:
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
690:
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
692:
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
694:
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
690:
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
692:
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
694:
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
696:
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
692:
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
694:
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
696:
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
698:
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
694:
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
696:
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
698:
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
700:
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
696:
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
698:
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
700:
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
702:
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
698:
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
700:
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
702:
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
704:
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
700:
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
702:
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
704:
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
706:
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
702:
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
704:
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
706:
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
708:
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
704:
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
706:
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
708:
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
710:
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
706:
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
708:
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
710:
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
712:
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
708:
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
710:
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
712:
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
714:
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
710:
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
712:
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
714:
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
716:
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
712:
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
714:
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
716:
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
718:
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
714:
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
716:
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
718:
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
720:
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
716:
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
718:
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
720:
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
722:
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
718:
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
720:
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
722:
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);
724:
725: l_upd_csc_cust_plans_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute_category, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY);
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
720:
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
722:
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);
724:
725: l_upd_csc_cust_plans_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute_category, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY);
726:
727: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
722:
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);
724:
725: l_upd_csc_cust_plans_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute_category, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY);
726:
727: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
728: THEN
729: -- Invoke validation procedures
726:
727: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
728: THEN
729: -- Invoke validation procedures
730: Validate_csc_cust_plans(
731: p_init_msg_list => FND_API.G_FALSE,
732: p_validation_level => p_validation_level,
733: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
734: P_CSC_CUST_PLANS_Rec => L_UPD_CSC_CUST_PLANS_REC,
730: Validate_csc_cust_plans(
731: p_init_msg_list => FND_API.G_FALSE,
732: p_validation_level => p_validation_level,
733: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
734: P_CSC_CUST_PLANS_Rec => L_UPD_CSC_CUST_PLANS_REC,
735: x_return_status => x_return_status,
736: x_msg_count => x_msg_count,
737: x_msg_data => x_msg_data);
738:
740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742: END IF;
743:
744: -- Invoke table handler(CSC_CUST_PLANS_PKG.Update_Row)
745: CSC_CUST_PLANS_PKG.Update_Row(
746: p_CUST_PLAN_ID => l_upd_csc_cust_plans_rec.CUST_PLAN_ID,
747: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
741: END IF;
742: END IF;
743:
744: -- Invoke table handler(CSC_CUST_PLANS_PKG.Update_Row)
745: CSC_CUST_PLANS_PKG.Update_Row(
746: p_CUST_PLAN_ID => l_upd_csc_cust_plans_rec.CUST_PLAN_ID,
747: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
742: END IF;
743:
744: -- Invoke table handler(CSC_CUST_PLANS_PKG.Update_Row)
745: CSC_CUST_PLANS_PKG.Update_Row(
746: p_CUST_PLAN_ID => l_upd_csc_cust_plans_rec.CUST_PLAN_ID,
747: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
743:
744: -- Invoke table handler(CSC_CUST_PLANS_PKG.Update_Row)
745: CSC_CUST_PLANS_PKG.Update_Row(
746: p_CUST_PLAN_ID => l_upd_csc_cust_plans_rec.CUST_PLAN_ID,
747: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
744: -- Invoke table handler(CSC_CUST_PLANS_PKG.Update_Row)
745: CSC_CUST_PLANS_PKG.Update_Row(
746: p_CUST_PLAN_ID => l_upd_csc_cust_plans_rec.CUST_PLAN_ID,
747: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
745: CSC_CUST_PLANS_PKG.Update_Row(
746: p_CUST_PLAN_ID => l_upd_csc_cust_plans_rec.CUST_PLAN_ID,
747: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
746: p_CUST_PLAN_ID => l_upd_csc_cust_plans_rec.CUST_PLAN_ID,
747: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
747: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
755: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID,
748: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
755: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID,
756: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID,
749: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
755: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID,
756: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID,
757: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID,
750: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
755: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID,
756: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID,
757: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID,
758: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE,
751: p_START_DATE_ACTIVE => l_upd_csc_cust_plans_rec.START_DATE_ACTIVE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
755: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID,
756: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID,
757: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID,
758: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE,
759: p_LAST_UPDATE_DATE => SYSDATE,
752: p_END_DATE_ACTIVE => l_upd_csc_cust_plans_rec.END_DATE_ACTIVE,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
755: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID,
756: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID,
757: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID,
758: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE,
759: p_LAST_UPDATE_DATE => SYSDATE,
760: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
753: p_MANUAL_FLAG => l_upd_csc_cust_plans_rec.MANUAL_FLAG,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
755: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID,
756: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID,
757: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID,
758: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE,
759: p_LAST_UPDATE_DATE => SYSDATE,
760: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
761: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
754: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE,
755: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID,
756: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID,
757: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID,
758: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE,
759: p_LAST_UPDATE_DATE => SYSDATE,
760: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
761: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
762: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1,
758: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE,
759: p_LAST_UPDATE_DATE => SYSDATE,
760: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
761: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
762: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1,
763: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
759: p_LAST_UPDATE_DATE => SYSDATE,
760: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
761: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
762: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1,
763: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
760: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
761: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
762: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1,
763: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
761: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
762: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1,
763: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
762: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1,
763: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
763: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
766: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
774: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13,
767: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
774: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13,
775: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14,
768: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
774: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13,
775: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14,
776: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15,
769: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
774: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13,
775: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14,
776: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15,
777: p_ATTRIBUTE_CATEGORY => l_upd_csc_cust_plans_rec.ATTRIBUTE_CATEGORY,
770: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9,
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
774: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13,
775: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14,
776: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15,
777: p_ATTRIBUTE_CATEGORY => l_upd_csc_cust_plans_rec.ATTRIBUTE_CATEGORY,
778: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
771: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10,
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
774: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13,
775: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14,
776: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15,
777: p_ATTRIBUTE_CATEGORY => l_upd_csc_cust_plans_rec.ATTRIBUTE_CATEGORY,
778: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
779:
772: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11,
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
774: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13,
775: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14,
776: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15,
777: p_ATTRIBUTE_CATEGORY => l_upd_csc_cust_plans_rec.ATTRIBUTE_CATEGORY,
778: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
779:
780: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
773: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12,
774: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13,
775: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14,
776: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15,
777: p_ATTRIBUTE_CATEGORY => l_upd_csc_cust_plans_rec.ATTRIBUTE_CATEGORY,
778: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
779:
780: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
781: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
776: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15,
777: p_ATTRIBUTE_CATEGORY => l_upd_csc_cust_plans_rec.ATTRIBUTE_CATEGORY,
778: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
779:
780: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
781: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
782: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID ,
783: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID ,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,
778: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
779:
780: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
781: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
782: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID ,
783: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID ,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,
785: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG ,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
779:
780: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
781: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
782: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID ,
783: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID ,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,
785: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG ,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
787: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID ,
780: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
781: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
782: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID ,
783: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID ,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,
785: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG ,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
787: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID ,
788: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID ,
781: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
782: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID ,
783: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID ,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,
785: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG ,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
787: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID ,
788: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID ,
789: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID ,
782: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID ,
783: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID ,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,
785: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG ,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
787: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID ,
788: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID ,
789: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID ,
790: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE ,
783: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID ,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,
785: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG ,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
787: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID ,
788: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID ,
789: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID ,
790: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE ,
791: p_CREATION_DATE => SYSDATE,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,
785: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG ,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
787: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID ,
788: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID ,
789: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID ,
790: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE ,
791: p_CREATION_DATE => SYSDATE,
792: p_LAST_UPDATE_DATE => SYSDATE,
785: -- p_CUST_ACCOUNT_ORG => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ORG ,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
787: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID ,
788: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID ,
789: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID ,
790: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE ,
791: p_CREATION_DATE => SYSDATE,
792: p_LAST_UPDATE_DATE => SYSDATE,
793: p_CREATED_BY => FND_GLOBAL.USER_ID,
786: p_PLAN_STATUS_CODE => l_upd_csc_cust_plans_rec.PLAN_STATUS_CODE ,
787: p_REQUEST_ID => l_upd_csc_cust_plans_rec.REQUEST_ID ,
788: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID ,
789: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID ,
790: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE ,
791: p_CREATION_DATE => SYSDATE,
792: p_LAST_UPDATE_DATE => SYSDATE,
793: p_CREATED_BY => FND_GLOBAL.USER_ID,
794: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
792: p_LAST_UPDATE_DATE => SYSDATE,
793: p_CREATED_BY => FND_GLOBAL.USER_ID,
794: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
795: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
796: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
793: p_CREATED_BY => FND_GLOBAL.USER_ID,
794: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
795: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
796: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
794: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
795: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
796: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
795: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
796: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
796: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
800: p_ATTRIBUTE5 => l_upd_csc_cust_plans_rec.ATTRIBUTE5 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
808: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13 ,
801: p_ATTRIBUTE6 => l_upd_csc_cust_plans_rec.ATTRIBUTE6 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
808: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13 ,
809: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14 ,
802: p_ATTRIBUTE7 => l_upd_csc_cust_plans_rec.ATTRIBUTE7 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
808: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13 ,
809: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14 ,
810: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15 ,
803: p_ATTRIBUTE8 => l_upd_csc_cust_plans_rec.ATTRIBUTE8 ,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
808: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13 ,
809: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14 ,
810: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15 ,
811: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
804: p_ATTRIBUTE9 => l_upd_csc_cust_plans_rec.ATTRIBUTE9 ,
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
808: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13 ,
809: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14 ,
810: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15 ,
811: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
812: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
805: p_ATTRIBUTE10 => l_upd_csc_cust_plans_rec.ATTRIBUTE10 ,
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
808: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13 ,
809: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14 ,
810: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15 ,
811: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
812: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
813:
806: p_ATTRIBUTE11 => l_upd_csc_cust_plans_rec.ATTRIBUTE11 ,
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
808: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13 ,
809: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14 ,
810: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15 ,
811: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
812: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
813:
814: --denzb***************************************************/
807: p_ATTRIBUTE12 => l_upd_csc_cust_plans_rec.ATTRIBUTE12 ,
808: p_ATTRIBUTE13 => l_upd_csc_cust_plans_rec.ATTRIBUTE13 ,
809: p_ATTRIBUTE14 => l_upd_csc_cust_plans_rec.ATTRIBUTE14 ,
810: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15 ,
811: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
812: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
813:
814: --denzb***************************************************/
815: -- Standard check for p_commit
871: X_Msg_Count OUT NOCOPY NUMBER,
872: X_Msg_Data OUT NOCOPY VARCHAR2
873: )
874: IS
875: l_csc_cust_plans_rec CSC_CUST_PLANS_REC_TYPE;
876: l_api_name CONSTANT VARCHAR2(30) := 'Enable_Plan';
877: l_api_version_number CONSTANT NUMBER := 1.0;
878: BEGIN
879: -- Standard Start of API savepoint
924:
925:
926: /******************* using regular update procedure
927:
928: CSC_CUST_PLANS_PKG.LOCK_ROW (
929: p_plan_id => p_plan_id,
930: p_party_id => p_party_id_tbl(i).party_id,
931: p_cust_account_id => p_party_id_tbl(i).cust_account_id,
932: -- p_cust_account_org => p_party_id_tbl(i).cust_account_org,
931: p_cust_account_id => p_party_id_tbl(i).cust_account_id,
932: -- p_cust_account_org => p_party_id_tbl(i).cust_account_org,
933: p_object_version_number => p_party_id_tbl(i).object_version_number );
934:
935: update csc_cust_plans
936: set plan_status_code = p_plan_status_code,
937: object_version_number = object_version_number + 1
938: where plan_id = p_plan_id
939: and party_id = p_party_id_tbl(i).party_id
969: X_Msg_Count OUT NOCOPY NUMBER,
970: X_Msg_Data OUT NOCOPY VARCHAR2
971: )
972: IS
973: l_csc_cust_plans_rec CSC_CUST_PLANS_REC_TYPE;
974: l_api_name CONSTANT VARCHAR2(30) := 'Disable_Plan';
975: l_api_version_number CONSTANT NUMBER := 1.0;
976: BEGIN
977: -- Standard Start of API savepoint
1020: end loop;
1021:
1022: /******* using regular update procedure to take of audit insert
1023:
1024: CSC_CUST_PLANS_PKG.LOCK_ROW (
1025: p_plan_id => p_plan_id,
1026: p_party_id => p_party_id_tbl(i).party_id,
1027: p_cust_account_id => p_party_id_tbl(i).cust_account_id,
1028: -- p_cust_account_org => p_party_id_tbl(i).cust_account_org,
1027: p_cust_account_id => p_party_id_tbl(i).cust_account_id,
1028: -- p_cust_account_org => p_party_id_tbl(i).cust_account_org,
1029: p_object_version_number => p_party_id_tbl(i).object_version_number );
1030:
1031: update csc_cust_plans
1032: set plan_status_code = p_plan_status_code,
1033: object_version_number = object_version_number + 1
1034: where plan_id = p_plan_id
1035: and party_id = p_party_id_tbl(i).party_id
1071: )
1072: IS
1073: cursor c1 is
1074: select *
1075: from csc_cust_plans
1076: where plan_id = p_original_plan_id
1077: and party_id = p_party_id
1078: and nvl(cust_account_id,0) = nvl(p_cust_account_id, nvl(cust_account_id,0))
1079: and object_version_number = p_object_version_number;
1113:
1114: if ( c1%NOTFOUND ) then
1115: close c1;
1116: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
1117: FND_MESSAGE.Set_Token ('INFO', 'CSC_CUST_PLANS', FALSE);
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: raise FND_API.G_EXC_ERROR;
1120: END IF;
1121: close c1;
1119: raise FND_API.G_EXC_ERROR;
1120: END IF;
1121: close c1;
1122:
1123: CSC_CUST_PLANS_PKG.LOCK_ROW(
1124: p_plan_id => p_original_plan_id,
1125: p_party_id => p_party_id,
1126: p_cust_account_id => p_cust_account_id,
1127: -- p_cust_account_org => p_cust_account_org,
1127: -- p_cust_account_org => p_cust_account_org,
1128: p_object_version_number => p_object_version_number );
1129:
1130:
1131: update csc_cust_plans
1132: SET PLAN_ID = P_PLAN_ID,
1133: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
1134: where plan_id = p_original_plan_id
1135: and party_id = nvl(p_party_id, party_id)
1135: and party_id = nvl(p_party_id, party_id)
1136: and nvl(cust_account_id, 0) = nvl(p_cust_account_id, nvl(cust_account_id,0) )
1137: and object_version_number = p_object_version_number;
1138:
1139: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
1140: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
1141: p_PLAN_ID => P_PLAN_ID ,
1142: p_PARTY_ID => P_PARTY_ID ,
1143: p_CUST_ACCOUNT_ID => P_CUST_ACCOUNT_ID ,
1193: X_Msg_Count OUT NOCOPY NUMBER,
1194: X_Msg_Data OUT NOCOPY VARCHAR2
1195: )
1196: IS
1197: -- cursor to select the values of CSC_CUST_PLANS table which will be used as
1198: -- input values to do insert into CSC_CUST_PLANS_AUDIT table.
1199: cursor C1 ( C_CUST_PLAN_ID NUMBER ) is
1200: SELECT CUST_PLAN_ID , PLAN_ID , PARTY_ID ,
1201: CUST_ACCOUNT_ID , -- CUST_ACCOUNT_ORG , START_DATE_ACTIVE ,
1194: X_Msg_Data OUT NOCOPY VARCHAR2
1195: )
1196: IS
1197: -- cursor to select the values of CSC_CUST_PLANS table which will be used as
1198: -- input values to do insert into CSC_CUST_PLANS_AUDIT table.
1199: cursor C1 ( C_CUST_PLAN_ID NUMBER ) is
1200: SELECT CUST_PLAN_ID , PLAN_ID , PARTY_ID ,
1201: CUST_ACCOUNT_ID , -- CUST_ACCOUNT_ORG , START_DATE_ACTIVE ,
1202: END_DATE_ACTIVE , MANUAL_FLAG , PLAN_STATUS_CODE ,
1208: ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 ,
1209: ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 ,
1210: ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 ,
1211: ATTRIBUTE_CATEGORY , OBJECT_VERSION_NUMBER
1212: FROM csc_cust_plans
1213: WHERE cust_plan_id = c_cust_plan_id;
1214:
1215: C1REC C1%ROWTYPE;
1216:
1246: raise no_data_found;
1247: end if;
1248: close c1;
1249:
1250: -- Invoke table handler(CSC_CUST_PLANS_PKG.Delete_Row)
1251: CSC_CUST_PLANS_PKG.Delete_Row(
1252: p_CUST_PLAN_ID => p_CUST_PLAN_ID);
1253:
1254: -- Insert row into CSC_CUST_PLANS_AUDIT table with the selected cursor values
1247: end if;
1248: close c1;
1249:
1250: -- Invoke table handler(CSC_CUST_PLANS_PKG.Delete_Row)
1251: CSC_CUST_PLANS_PKG.Delete_Row(
1252: p_CUST_PLAN_ID => p_CUST_PLAN_ID);
1253:
1254: -- Insert row into CSC_CUST_PLANS_AUDIT table with the selected cursor values
1255: -- and with PLAN_STATUS_CODE = 'DELETED';
1250: -- Invoke table handler(CSC_CUST_PLANS_PKG.Delete_Row)
1251: CSC_CUST_PLANS_PKG.Delete_Row(
1252: p_CUST_PLAN_ID => p_CUST_PLAN_ID);
1253:
1254: -- Insert row into CSC_CUST_PLANS_AUDIT table with the selected cursor values
1255: -- and with PLAN_STATUS_CODE = 'DELETED';
1256: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
1257: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
1258: p_PLAN_ID => c1rec.PLAN_ID ,
1252: p_CUST_PLAN_ID => p_CUST_PLAN_ID);
1253:
1254: -- Insert row into CSC_CUST_PLANS_AUDIT table with the selected cursor values
1255: -- and with PLAN_STATUS_CODE = 'DELETED';
1256: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
1257: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
1258: p_PLAN_ID => c1rec.PLAN_ID ,
1259: p_PARTY_ID => c1rec.PARTY_ID ,
1260: p_CUST_ACCOUNT_ID => c1rec.CUST_ACCOUNT_ID ,
1365:
1366: -- Initialize API return status to SUCCESS
1367: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
1368:
1369: -- sql_stmt := 'select cust_plan_id from csc_cust_plans where ' || p_where_clause;
1370: -- execute immediate sql_stmt into x_cust_plan_id;
1371:
1372: /* The code has been modfied to have dynamic sql bind variable complaince
1373: The existing dynamic where clause has two parts, the second part of the where cluase
1384: v_position2 := instr(v_where , 'AND' ,1,2);
1385: v_plan_id := substr(v_where,v_position1+1,(v_position2-v_position1-1));
1386:
1387: if (instr(v_where,'IS',1,1)>0) then
1388: sql_stmt := 'select cust_plan_id from csc_cust_plans where ' ||
1389: ' party_id = :1 and plan_id = :2 and cust_account_id is null ';
1390: execute immediate sql_stmt into x_cust_plan_id using v_party_id,v_plan_id;
1391: else
1392: sql_stmt := 'select cust_plan_id from csc_cust_plans where ' ||
1388: sql_stmt := 'select cust_plan_id from csc_cust_plans where ' ||
1389: ' party_id = :1 and plan_id = :2 and cust_account_id is null ';
1390: execute immediate sql_stmt into x_cust_plan_id using v_party_id,v_plan_id;
1391: else
1392: sql_stmt := 'select cust_plan_id from csc_cust_plans where ' ||
1393: ' party_id = :1 and plan_id = :2 and cust_account_id = :3 ';
1394: v_position1 := instr(v_where,'=',1,3);
1395: v_position2 := length(v_where);
1396: v_c_acct_id := substr(v_where,v_position1+1,(v_position2-v_position1));
1412: )
1413: IS
1414: cursor check_dup_id is
1415: select cust_plan_id
1416: from CSC_CUST_PLANS
1417: where cust_plan_id = p_cust_plan_id;
1418:
1419: l_cust_plan_id number;
1420: l_api_name varchar2(30) := 'Validate_Cust_Plan_Id';
1755:
1756: END Validate_PLAN_STATUS_CODE;
1757:
1758:
1759: PROCEDURE Validate_csc_cust_plans(
1760: P_Init_Msg_List IN VARCHAR2,
1761: P_Validation_level IN NUMBER ,
1762: P_Validation_mode IN VARCHAR2,
1763: P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type,
1759: PROCEDURE Validate_csc_cust_plans(
1760: P_Init_Msg_List IN VARCHAR2,
1761: P_Validation_level IN NUMBER ,
1762: P_Validation_mode IN VARCHAR2,
1763: P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type,
1764: X_Return_Status OUT NOCOPY VARCHAR2,
1765: X_Msg_Count OUT NOCOPY NUMBER,
1766: X_Msg_Data OUT NOCOPY VARCHAR2
1767: )
1765: X_Msg_Count OUT NOCOPY NUMBER,
1766: X_Msg_Data OUT NOCOPY VARCHAR2
1767: )
1768: IS
1769: l_api_name CONSTANT VARCHAR2(30) := 'Validate_csc_cust_plans';
1770: BEGIN
1771: -- Initialize API return status to SUCCESS
1772: x_return_status := FND_API.G_RET_STS_SUCCESS;
1773:
1775:
1776: Validate_CUST_PLAN_ID(
1777: p_init_msg_list => FND_API.G_TRUE,
1778: p_validation_mode => p_validation_mode,
1779: p_CUST_PLAN_ID => P_CSC_CUST_PLANS_Rec.CUST_PLAN_ID,
1780: x_return_status => x_return_status,
1781: x_msg_count => x_msg_count,
1782: x_msg_data => x_msg_data);
1783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1786:
1787: Validate_PLAN_ID(
1788: p_init_msg_list => FND_API.G_TRUE,
1789: p_validation_mode => p_validation_mode,
1790: p_PLAN_ID => P_CSC_CUST_PLANS_Rec.PLAN_ID,
1791: x_return_status => x_return_status,
1792: x_msg_count => x_msg_count,
1793: x_msg_data => x_msg_data);
1794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1797:
1798: Validate_PARTY_ID(
1799: p_init_msg_list => FND_API.G_TRUE,
1800: p_validation_mode => p_validation_mode,
1801: p_PARTY_ID => P_CSC_CUST_PLANS_Rec.PARTY_ID,
1802: x_return_status => x_return_status,
1803: x_msg_count => x_msg_count,
1804: x_msg_data => x_msg_data);
1805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1811:
1812: Validate_CUST_ACC_ORG_ID (
1813: p_init_msg_list => FND_API.G_TRUE,
1814: p_validation_mode => p_validation_mode,
1815: p_PARTY_ID => P_CSC_CUST_PLANS_Rec.PARTY_ID,
1816: p_CUST_ACCOUNT_ID => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ID,
1817: p_CUST_ACCOUNT_ORG => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ORG,
1818: x_return_status => x_return_status,
1819: x_msg_count => x_msg_count,
1812: Validate_CUST_ACC_ORG_ID (
1813: p_init_msg_list => FND_API.G_TRUE,
1814: p_validation_mode => p_validation_mode,
1815: p_PARTY_ID => P_CSC_CUST_PLANS_Rec.PARTY_ID,
1816: p_CUST_ACCOUNT_ID => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ID,
1817: p_CUST_ACCOUNT_ORG => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ORG,
1818: x_return_status => x_return_status,
1819: x_msg_count => x_msg_count,
1820: x_msg_data => x_msg_data);
1813: p_init_msg_list => FND_API.G_TRUE,
1814: p_validation_mode => p_validation_mode,
1815: p_PARTY_ID => P_CSC_CUST_PLANS_Rec.PARTY_ID,
1816: p_CUST_ACCOUNT_ID => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ID,
1817: p_CUST_ACCOUNT_ORG => P_CSC_CUST_PLANS_Rec.CUST_ACCOUNT_ORG,
1818: x_return_status => x_return_status,
1819: x_msg_count => x_msg_count,
1820: x_msg_data => x_msg_data);
1821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1825:
1826: Validate_MANUAL_FLAG(
1827: p_init_msg_list => FND_API.G_TRUE,
1828: p_validation_mode => p_validation_mode,
1829: p_MANUAL_FLAG => P_CSC_CUST_PLANS_Rec.MANUAL_FLAG,
1830: x_return_status => x_return_status,
1831: x_msg_count => x_msg_count,
1832: x_msg_data => x_msg_data);
1833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1836:
1837: Validate_PLAN_STATUS_CODE(
1838: p_init_msg_list => FND_API.G_TRUE,
1839: p_validation_mode => p_validation_mode,
1840: p_PLAN_STATUS_CODE => P_CSC_CUST_PLANS_Rec.PLAN_STATUS_CODE,
1841: x_return_status => x_return_status,
1842: x_msg_count => x_msg_count,
1843: x_msg_data => x_msg_data);
1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1849: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1850: p_init_msg_list => FND_API.G_TRUE,
1851: p_validation_mode => p_validation_mode,
1852: P_COLUMN_NAME => 'CREATION_DATE',
1853: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.CREATION_DATE,
1854: x_return_status => x_return_status,
1855: x_msg_count => x_msg_count,
1856: x_msg_data => x_msg_data);
1857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1861: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1862: p_init_msg_list => FND_API.G_TRUE,
1863: p_validation_mode => p_validation_mode,
1864: P_COLUMN_NAME => 'LAST_UPDATE_DATE',
1865: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.LAST_UPDATE_DATE,
1866: x_return_status => x_return_status,
1867: x_msg_count => x_msg_count,
1868: x_msg_data => x_msg_data);
1869: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1873: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1874: p_init_msg_list => FND_API.G_TRUE,
1875: p_validation_mode => p_validation_mode,
1876: P_COLUMN_NAME => 'CREATED_BY',
1877: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.CREATED_BY,
1878: x_return_status => x_return_status,
1879: x_msg_count => x_msg_count,
1880: x_msg_data => x_msg_data);
1881: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1885: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1886: p_init_msg_list => FND_API.G_TRUE,
1887: p_validation_mode => p_validation_mode,
1888: P_COLUMN_NAME => 'LAST_UPDATED_BY',
1889: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.LAST_UPDATED_BY,
1890: x_return_status => x_return_status,
1891: x_msg_count => x_msg_count,
1892: x_msg_data => x_msg_data);
1893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1897: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1898: p_init_msg_list => FND_API.G_TRUE,
1899: p_validation_mode => p_validation_mode,
1900: P_COLUMN_NAME => 'OBJECT_VERSION_NUMBER',
1901: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.OBJECT_VERSION_NUMBER,
1902: x_return_status => x_return_status,
1903: x_msg_count => x_msg_count,
1904: x_msg_data => x_msg_data);
1905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1907: END IF;
1908: */
1909: END IF;
1910:
1911: END Validate_csc_cust_plans;
1912:
1913: End CSC_CUST_PLANS_PVT;
1909: END IF;
1910:
1911: END Validate_csc_cust_plans;
1912:
1913: End CSC_CUST_PLANS_PVT;