[Home] [Help]
49:
50: G_CUSTOMIZED_ID NUMBER;
51: -- G_CUSTOMIZED_ID NUMBER := FND_API.G_MISS_NUM;
52: -- used to get back the id of the record
53: -- created in CSC_CUSTOMIZED_PLANS table
54: -- when a customzied plan is created.
55:
56: -- not using this global variable coz, when executing the validation procedure stand-alone
57: -- from forms, this errors out.
351: -- if a customized plan is being created,ie. CUST0MIZED_PLAN = 'Y' then
352: -- 1. Validate party_id.
353: -- 2. If plan is being customized for account level, ie.USE_FOR_CUST_ACCOUNTS = 'Y' then
354: -- 2a. Validate CUST_ACCOUNT_ID and CUST_ACCOUNT_ORG
355: -- 3. Insert a record into CSC_CUSTOMIZED_PLANS table to save the
356: -- customer-plan relationship.
357: -- 4. Insert a record into CSC_CUST_PLANS table.
358: -- 5. Update CSC_CUST_PLANS table to show new customized plan_id where ever the customer
359: -- plan association exists
601:
602: IF ( p_csc_plan_headers_b_rec.customized_plan = 'Y' ) then
603: for i in 1..l_party_id_tbl.count
604: LOOP
605: CSC_CUSTOMIZED_PLANS_PKG.INSERT_ROW(
606: px_id => g_customized_id,
607: p_plan_id => x_plan_id,
608: p_party_id => l_party_id_tbl(i).party_id,
609: p_cust_account_id => l_party_id_tbl(i).cust_account_id );
1065: P_NAME => l_name,
1066: X_OBJECT_VERSION_NUMBER => x_object_version_number );
1067:
1068: -- if customized_plans is updated from 'Y' to 'N' then delete the customer-plan
1069: -- relationship in CSC_CUSTOMIZED_PLANS table.
1070: -- Do not delete records from the CSC_CUST_PLANS table, because the only thing
1071: -- happening here is removing the customization part of the plan to the customer
1072: -- and making the plan available to all other eligible customers. The customer
1073: -- may still be assigned to the plan.
1073: -- may still be assigned to the plan.
1074:
1075: if ( l_ref_plan_header_rec.customized_plan = 'Y'
1076: and p_csc_plan_headers_b_rec.customized_plan = 'N' ) then
1077: delete from csc_customized_plans
1078: where plan_id = p_csc_plan_headers_b_rec.plan_id;
1079: end if;
1080:
1081: -- if plan header end_date_active was null and is updated, update the end_date_active