APPS.CSC_CUST_PLANS_PVT dependencies on CSC_CUST_PLANS_PVT

Line 1: PACKAGE BODY CSC_CUST_PLANS_PVT as

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

Line 4: -- Package name : CSC_CUST_PLANS_PVT

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 :

Line 38: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_CUST_PLANS_PVT';

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 ,

Line 589: l_ref_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type;

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

Line 590: --l_tar_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_Rec;

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

Line 591: l_upd_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_REC;

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;

Line 1913: End CSC_CUST_PLANS_PVT;

1909: END IF;
1910:
1911: END Validate_csc_cust_plans;
1912:
1913: End CSC_CUST_PLANS_PVT;