APPS.CSC_CUST_PLANS_PUB dependencies on CSC_CUST_PLANS_PVT

Line 52: x_pvt_CSC_CUST_PLANS_rec OUT NOCOPY CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type

48: -- End of Comments
49:
50: PROCEDURE CONVERT_CSC_CUST_PLANS(
51: P_CSC_CUST_PLANS_Rec IN CSC_cust_plans_PUB.CSC_CUST_PLANS_Rec_Type,
52: x_pvt_CSC_CUST_PLANS_rec OUT NOCOPY CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type
53: )
54: IS
55: -- Hint: Declare cursor and local variables
56: -- Example: CURSOR C_Get_Lookup_Code(X_Lookup_Type VARCHAR2, X_Meaning VARCHAR2) IS

Line 353: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;

349: )
350: IS
351: l_api_name CONSTANT VARCHAR2(30) := 'Create_cust_plans';
352: l_api_version_number CONSTANT NUMBER := 1.0;
353: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;
354: BEGIN
355: -- Standard Start of API savepoint
356: SAVEPOINT CREATE_CUST_PLANS_PUB;
357:

Line 385: CSC_cust_plans_PVT.Create_cust_plans(

381:
382: -- Calling Private package: Create_CUST_PLANS
383: -- Hint: Primary key needs to be returned
384:
385: CSC_cust_plans_PVT.Create_cust_plans(
386: P_Api_Version_Number => 1.0,
387: P_Init_Msg_List => FND_API.G_FALSE,
388: P_Commit => FND_API.G_FALSE,
389: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 593: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;

589: )
590: IS
591: l_api_name CONSTANT VARCHAR2(30) := 'Update_cust_plans';
592: l_api_version_number CONSTANT NUMBER := 1.0;
593: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;
594: BEGIN
595: -- Standard Start of API savepoint
596: SAVEPOINT UPDATE_CUST_PLANS_PUB;
597:

Line 622: CSC_cust_plans_PVT.Update_cust_plans(

618: CONVERT_CSC_CUST_PLANS (
619: p_CSC_CUST_PLANS_rec => p_CSC_CUST_PLANS_rec,
620: x_pvt_CSC_CUST_PLANS_rec => l_pvt_CSC_CUST_PLANS_rec );
621:
622: CSC_cust_plans_PVT.Update_cust_plans(
623: P_Api_Version_Number => 1.0,
624: P_Init_Msg_List => FND_API.G_FALSE,
625: P_Commit => p_commit,
626: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 700: l_csc_cust_plans_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_REC_TYPE;

696: X_Msg_Count OUT NOCOPY NUMBER,
697: X_Msg_Data OUT NOCOPY VARCHAR2
698: )
699: IS
700: l_csc_cust_plans_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_REC_TYPE;
701: l_api_name CONSTANT VARCHAR2(30) := 'Enable_Plan';
702: l_api_version_number CONSTANT NUMBER := 1.0;
703: BEGIN
704: -- Standard Start of API savepoint

Line 733: csc_cust_plans_pvt.update_cust_plans(

729: l_csc_cust_plans_rec.party_id := NULL;
730: l_csc_cust_plans_rec.cust_account_id := NULL;
731: --l_csc_cust_plans_rec.cust_account_org := NULL;
732:
733: csc_cust_plans_pvt.update_cust_plans(
734: P_Api_Version_Number => p_api_version_number,
735: P_Init_Msg_List => p_init_msg_list,
736: P_Commit => p_commit,
737: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 774: l_csc_cust_plans_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_REC_TYPE;

770: X_Msg_Count OUT NOCOPY NUMBER,
771: X_Msg_Data OUT NOCOPY VARCHAR2
772: )
773: IS
774: l_csc_cust_plans_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_REC_TYPE;
775: l_api_name CONSTANT VARCHAR2(30) := 'Disable_Plan';
776: l_api_version_number CONSTANT NUMBER := 1.0;
777: BEGIN
778: -- Standard Start of API savepoint

Line 803: csc_cust_plans_pvt.update_cust_plans(

799: l_csc_cust_plans_rec.plan_status_code := p_plan_status_code;
800: l_csc_cust_plans_rec.plan_id := p_plan_id;
801: l_csc_cust_plans_rec.object_version_number := 1;
802:
803: csc_cust_plans_pvt.update_cust_plans(
804: P_Api_Version_Number => p_api_version_number,
805: P_Init_Msg_List => p_init_msg_list,
806: P_Commit => p_commit,
807: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 843: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;

839: )
840: IS
841: l_api_name CONSTANT VARCHAR2(30) := 'Delete_cust_plans';
842: l_api_version_number CONSTANT NUMBER := 1.0;
843: l_pvt_CSC_CUST_PLANS_rec CSC_CUST_PLANS_PVT.CSC_CUST_PLANS_Rec_Type;
844: BEGIN
845: -- Standard Start of API savepoint
846: SAVEPOINT DELETE_CUST_PLANS_PUB;
847: