APPS.CSC_RELATIONSHIP_PLANS_PVT dependencies on CSC_CUST_PLANS_PVT

Line 192: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

188: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
189: P_OBJECT_VERSION_NUMBER IN NUMBER,
190: P_DESCRIPTION IN VARCHAR2,
191: P_NAME IN VARCHAR2,
192: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
193: X_PLAN_ID OUT NOCOPY NUMBER,
194: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
195: X_Return_Status OUT NOCOPY VARCHAR2,
196: X_Msg_Count OUT NOCOPY NUMBER,

Line 268: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

264: p_validation_level IN NUMBER,
265: P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
266: P_DESCRIPTION IN VARCHAR2,
267: P_NAME IN VARCHAR2,
268: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
269: X_PLAN_ID OUT NOCOPY NUMBER,
270: X_Object_Version_Number OUT NOCOPY NUMBER,
271: X_Return_Status OUT NOCOPY VARCHAR2,
272: X_Msg_Count OUT NOCOPY NUMBER,

Line 292: l_party_id_tbl CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE := P_PARTY_ID_TBL;

288: -- at party level, in which case the cust_account_id and cust_account_org should be
289: -- nullified. 'IN' parameters cannot be assigned a value, so this local table type is
290: -- used.
291: --l_party_id_tbl CSC_PARTY_ID_TBL_TYPE := P_PARTY_ID_TBL;
292: l_party_id_tbl CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE := P_PARTY_ID_TBL;
293:
294: x_cust_object_version_number NUMBER; -- used to get back the OUT NOCOPY value when updating
295: -- CSC_CUST_PLANS table, when customizing plans
296: BEGIN

Line 403: CSC_CUST_PLANS_PVT.Validate_PARTY_ID (

399: x_return_status := FND_API.G_RET_STS_ERROR;
400: RAISE FND_API.G_EXC_ERROR;
401: end if;
402: end if;
403: CSC_CUST_PLANS_PVT.Validate_PARTY_ID (
404: P_Init_Msg_List => FND_API.G_TRUE,
405: P_Validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
406: P_PARTY_ID => l_party_id_tbl(i).party_id,
407: x_Return_Status => x_return_status,

Line 417: CSC_CUST_PLANS_PVT.Validate_CUST_ACC_ORG_ID (

413:
414: /********************** 04-10-2000
415:
416: IF ( P_CSC_PLAN_HEADERS_B_REC.USE_FOR_CUST_ACCOUNT = 'Y' ) then
417: CSC_CUST_PLANS_PVT.Validate_CUST_ACC_ORG_ID (
418: P_Init_Msg_List => FND_API.G_TRUE,
419: P_Validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
420: P_PARTY_ID => l_party_id_tbl(i).party_id,
421: P_CUST_ACCOUNT_ID => l_party_id_tbl(i).cust_account_id,

Line 614: CSC_CUST_PLANS_PVT.Update_for_customized_plans (

610: --p_cust_account_org => l_party_id_tbl(i).cust_account_org );
611:
612: -- Call update_for_customized_plans to do the update of the plan_id for all the parties
613: -- with the new plan_id that was customzied.
614: CSC_CUST_PLANS_PVT.Update_for_customized_plans (
615: P_Api_Version_Number => 1.0,
616: P_Init_Msg_List => FND_API.G_TRUE,
617: P_Commit => p_commit,
618: P_PLAN_ID => x_plan_id,

Line 727: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

723: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
724: P_OBJECT_VERSION_NUMBER IN NUMBER,
725: P_DESCRIPTION IN VARCHAR2,
726: P_NAME IN VARCHAR2,
727: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
728: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
729: X_Return_Status OUT NOCOPY VARCHAR2,
730: X_Msg_Count OUT NOCOPY NUMBER,
731: X_Msg_Data OUT NOCOPY VARCHAR2

Line 801: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

797: p_validation_level IN NUMBER,
798: P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
799: P_DESCRIPTION IN VARCHAR2,
800: P_NAME IN VARCHAR2,
801: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
802: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
803: X_Return_Status OUT NOCOPY VARCHAR2,
804: X_Msg_Count OUT NOCOPY NUMBER,
805: X_Msg_Data OUT NOCOPY VARCHAR2

Line 841: l_ref_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type;

837: Select CUST_PLAN_ID, PARTY_ID, CUST_ACCOUNT_ID, OBJECT_VERSION_NUMBER
838: From CSC_CUST_PLANS
839: WHERE PLAN_ID = nvl(p_csc_plan_headers_b_rec.plan_id, plan_id)
840: AND plan_status_code not in ('MERGED', 'TRANSFERED') ORDER BY OBJECT_VERSION_NUMBER;
841: l_ref_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type;
842:
843: BEGIN
844: -- Standard Start of API savepoint
845: SAVEPOINT UPDATE_PLAN_HEADER_PVT;

Line 1108: CSC_CUST_PLANS_PVT.UPDATE_CUST_PLANS (

1104: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
1105:
1106: Exit when C_Get_cust_plans%NOTFOUND;
1107:
1108: CSC_CUST_PLANS_PVT.UPDATE_CUST_PLANS (
1109: P_Api_Version_Number => p_api_version_number,
1110: P_Init_Msg_List => p_init_msg_list,
1111: P_Commit => p_commit,
1112: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,

Line 1242: CSC_CUST_PLANS_PVT.UPDATE_CUST_PLANS (

1238: loop
1239: fetch c1 into c1rec;
1240: exit when c1%notfound;
1241:
1242: CSC_CUST_PLANS_PVT.UPDATE_CUST_PLANS (
1243: P_Api_Version_Number => p_api_version_number,
1244: P_Init_Msg_List => p_init_msg_list,
1245: P_Commit => p_commit,
1246: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,