eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_RELATIONSHIP_PLANS_PVT dependencies on CSC_CUST_PLANS

Line 34: -- 02-11-2002 bhroy Fixed Bug# 2412929,2250056 - CSC_CUST_PLANS table was not

30: -- update_plan_header
31: -- - Added a new procedure VALIDATE_END_USER_TYPE
32: -- Added the dbdrv command.
33: -- 05-23-2002 dejoseph Added checkfile syntax.
34: -- 02-11-2002 bhroy Fixed Bug# 2412929,2250056 - CSC_CUST_PLANS table was not
35: -- getting updated when user changes End_Date_Active
36: --
37: -- 04-Nov-2002 kmotepal Added OSERROR command to fix GSCC warnings for patch 2633080
38: -- 13-Nov-2002 bhroy NOCOPY changes made

Line 60: -- CSC_CUST_PLANS table. This count is used while performing

56: -- not using this global variable coz, when executing the validation procedure stand-alone
57: -- from forms, this errors out.
58: --G_CUST_PLANS_REC_CNT NUMBER := FND_API.G_MISS_NUM;
59: -- Used to keep a count on the number of records in
60: -- CSC_CUST_PLANS table. This count is used while performing
61: -- update on columns which requires that there should be no
62: -- association between plans and customers. ie. if a record
63: -- exist in this table, then do not allow the update on that
64: -- column. eg. use_for_cust_account, profile_check_id etc.

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 295: -- CSC_CUST_PLANS table, when customizing plans

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
297: -- Standard Start of API savepoint
298: SAVEPOINT CREATE_PLAN_HEADER_PVT;
299:

Line 357: -- 4. Insert a record into CSC_CUST_PLANS table.

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
360: -- NOTE : If parent plan which is customized is a PARTY level plan, then allow the
361: -- customization only at PARTY level, else return back and error status. The same

Line 358: -- 5. Update CSC_CUST_PLANS table to show new customized plan_id where ever the customer

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
360: -- NOTE : If parent plan which is customized is a PARTY level plan, then allow the
361: -- customization only at PARTY level, else return back and error status. The same
362: -- applies to ACCOUNT level plans.

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 838: From CSC_CUST_PLANS

834: l_rowid ROWID;
835:
836: Cursor C_Get_cust_plans IS
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:

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 1070: -- Do not delete records from the CSC_CUST_PLANS table, because the only thing

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.
1074:

Line 1082: -- in CSC_CUST_PLANS table for all customers associated to this plan.

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
1082: -- in CSC_CUST_PLANS table for all customers associated to this plan.
1083: -- as per bug# 2250056, first condition is taken out, even the old date not null, user is
1084: -- allowed to change the end date to any future date to extend the plan
1085: -- also party_id, cust_plan_id, cust_account_id and object_version_number, otherwise
1086: -- update fails

Line 1101: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,

1097:
1098: LOOP
1099:
1100: Fetch C_Get_cust_plans into
1101: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1102: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1103: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1104: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
1105:

Line 1102: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,

1098: LOOP
1099:
1100: Fetch C_Get_cust_plans into
1101: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1102: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1103: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1104: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
1105:
1106: Exit when C_Get_cust_plans%NOTFOUND;

Line 1103: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,

1099:
1100: Fetch C_Get_cust_plans into
1101: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1102: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1103: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1104: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;
1105:
1106: Exit when C_Get_cust_plans%NOTFOUND;
1107:

Line 1104: l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER;

1100: Fetch C_Get_cust_plans into
1101: l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1102: l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1103: l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
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 (

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 1114: P_CUST_PLAN_ID => l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,

1110: P_Init_Msg_List => p_init_msg_list,
1111: P_Commit => p_commit,
1112: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
1113: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
1114: P_CUST_PLAN_ID => l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1115: P_PARTY_ID => l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1116: P_CUST_ACCOUNT_ID => l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1117: p_start_date_active => p_csc_plan_headers_b_rec.start_date_active,
1118: p_end_date_active => p_csc_plan_headers_b_rec.end_date_active,

Line 1115: P_PARTY_ID => l_ref_CSC_CUST_PLANS_rec.PARTY_ID,

1111: P_Commit => p_commit,
1112: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
1113: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
1114: P_CUST_PLAN_ID => l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1115: P_PARTY_ID => l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1116: P_CUST_ACCOUNT_ID => l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1117: p_start_date_active => p_csc_plan_headers_b_rec.start_date_active,
1118: p_end_date_active => p_csc_plan_headers_b_rec.end_date_active,
1119: P_OBJECT_VERSION_NUMBER => l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER,

Line 1116: P_CUST_ACCOUNT_ID => l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,

1112: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
1113: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
1114: P_CUST_PLAN_ID => l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1115: P_PARTY_ID => l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1116: P_CUST_ACCOUNT_ID => l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1117: p_start_date_active => p_csc_plan_headers_b_rec.start_date_active,
1118: p_end_date_active => p_csc_plan_headers_b_rec.end_date_active,
1119: P_OBJECT_VERSION_NUMBER => l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER,
1120: X_Object_Version_number => x_object_version_number,

Line 1119: P_OBJECT_VERSION_NUMBER => l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER,

1115: P_PARTY_ID => l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1116: P_CUST_ACCOUNT_ID => l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1117: p_start_date_active => p_csc_plan_headers_b_rec.start_date_active,
1118: p_end_date_active => p_csc_plan_headers_b_rec.end_date_active,
1119: P_OBJECT_VERSION_NUMBER => l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER,
1120: X_Object_Version_number => x_object_version_number,
1121: X_Return_Status => x_return_status,
1122: X_Msg_Count => x_msg_count,
1123: X_Msg_Data => x_msg_data );

Line 1199: from csc_cust_plans

1195: IS
1196: cursor c1 is
1197: select cust_plan_id, party_id, cust_account_id, -- cust_account_org,
1198: object_version_number
1199: from csc_cust_plans
1200: where plan_id = p_plan_id;
1201:
1202: c1rec c1%rowtype;
1203:

Line 1233: -- Change the end_date_active of the CSC_CUST_PLANS table to sysdate+1 for all records

1229: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Disable_Row)
1230: CSC_PLAN_HEADERS_B_PKG.Disable_Row(
1231: p_PLAN_ID => p_PLAN_ID);
1232:
1233: -- Change the end_date_active of the CSC_CUST_PLANS table to sysdate+1 for all records
1234: -- with this plan_id. The plan assignment engine will then check all records with
1235: -- end_date not valid and delete the records.
1236:
1237: open c1;

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,

Line 1595: from csc_cust_plans

1591: )
1592: IS
1593: cursor c1 is
1594: select count(*)
1595: from csc_cust_plans
1596: where plan_id = p_plan_id;
1597:
1598: l_rec_count number := 0;
1599: l_api_name varchar2(30) := 'Validate_Use_For_Cust_Account';

Line 1770: from csc_cust_plans

1766: and nvl(end_date_active, sysdate);
1767:
1768: cursor c1 is
1769: select count(*)
1770: from csc_cust_plans
1771: where plan_id = p_plan_id;
1772:
1773: l_rec_count number := 0;
1774: l_api_name varchar2(30) := 'Validate_Profile_Check_Id';

Line 1853: from csc_cust_plans

1849: )
1850: IS
1851: cursor c1 is
1852: select count(*)
1853: from csc_cust_plans
1854: where plan_id = p_plan_id;
1855:
1856: l_rec_count number := 0;
1857: l_api_name varchar2(30) := 'Validate_Criteria_Value_Low';

Line 1913: from csc_cust_plans

1909: )
1910: IS
1911: cursor c1 is
1912: select count(*)
1913: from csc_cust_plans
1914: where plan_id = p_plan_id;
1915:
1916: l_rec_count number := 0;
1917: l_api_name varchar2(30) := 'Validate_Criteria_Value_High';

Line 1966: from csc_cust_plans

1962: )
1963: IS
1964: cursor c1 is
1965: select count(*)
1966: from csc_cust_plans
1967: where plan_id = p_plan_id;
1968:
1969: l_rec_count number := 0;
1970: l_api_name varchar2(30) := 'Validate_Relational_Operator';

Line 2122: from csc_cust_plans

2118: )
2119: IS
2120: cursor c1 is
2121: select min(start_date_active)
2122: from csc_cust_plans
2123: where plan_id = p_plan_id;
2124:
2125: l_min_date DATE;
2126: l_api_name VARCHAR2(30) := 'Validate_Start_Date_Active';

Line 2176: from csc_cust_plans

2172: )
2173: IS
2174: cursor c1 is
2175: select max(end_date_active)
2176: from csc_cust_plans
2177: where plan_id = p_plan_id;
2178:
2179: l_max_date DATE;
2180: l_api_name VARCHAR2(30) := 'Validate_End_Date_Active';