APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on HZ_CUST_PROFILE_CLASSES

Line 172: FROM hz_cust_profile_classes

168: RETURN VARCHAR2
169: IS
170: CURSOR c1 IS
171: SELECT review_cycle
172: FROM hz_cust_profile_classes
173: WHERE profile_class_id = p_cust_prof_class_id;
174: l_review_cycle VARCHAR2(30);
175: BEGIN
176: OPEN c1;

Line 307: l_status HZ_CUST_PROFILE_CLASSES.status%TYPE;

303: l_msg_count NUMBER;
304: l_msg_data VARCHAR2(2000);
305:
306: l_cust_profile_amt_rec CUST_PROFILE_AMT_REC_TYPE;
307: l_status HZ_CUST_PROFILE_CLASSES.status%TYPE;
308: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
309: l_profile_class_amount_id NUMBER;
310: l_profile_class_id NUMBER;
311:

Line 308: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;

304: l_msg_data VARCHAR2(2000);
305:
306: l_cust_profile_amt_rec CUST_PROFILE_AMT_REC_TYPE;
307: l_status HZ_CUST_PROFILE_CLASSES.status%TYPE;
308: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
309: l_profile_class_amount_id NUMBER;
310: l_profile_class_id NUMBER;
311:
312: -- 2310474 {

Line 338: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

334: l_cons_inv_type varchar2(30);
335: v_action VARCHAR2(10);
336: v_entity_code VARCHAR2(1);
337: v_entity_id NUMBER(15);
338: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
339:
340: BEGIN
341:
342: -- Debug info.

Line 355: FROM HZ_CUST_PROFILE_CLASSES

351: p_customer_profile_rec.profile_class_id = FND_API.G_MISS_NUM
352: THEN
353: BEGIN
354: SELECT STATUS, NAME INTO l_status, l_profile_class_name
355: FROM HZ_CUST_PROFILE_CLASSES
356: WHERE PROFILE_CLASS_ID = l_default_profile_class_id; -- Bug 3767719.
357:
358: IF l_status = 'I' THEN
359: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INACTIVE_PROFILE_CLASS' );

Line 453: FROM HZ_CUST_PROFILE_CLASSES

449: -- Bug 9188425 -Exception block is added to handle invalid Profile Class Id.
450: BEGIN
451: -- to get the default values from profile class
452: SELECT * INTO l_profile_class_rec
453: FROM HZ_CUST_PROFILE_CLASSES
454: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
455:
456: EXCEPTION
457: WHEN NO_DATA_FOUND THEN

Line 1028: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

1024: l_cons_bill_level VARCHAR2(30);
1025: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
1026: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
1027: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
1028: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
1029: l_standard_terms NUMBER;
1030: l_automatch_set_id NUMBER;
1031: l_profile_class_changed VARCHAR2(10);
1032:

Line 1103: FROM HZ_CUST_PROFILE_CLASSES

1099:
1100: l_profile_class_changed := 'Y';
1101:
1102: SELECT * INTO l_profile_class_rec
1103: FROM HZ_CUST_PROFILE_CLASSES
1104: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
1105:
1106: -- While changing the profile class for an existing cusromer profile record
1107: -- it should do the validations based on the new input parameters.