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 451: FROM HZ_CUST_PROFILE_CLASSES

447: -- }
448: --------------
449: -- to get the default values from profile class
450: SELECT * INTO l_profile_class_rec
451: FROM HZ_CUST_PROFILE_CLASSES
452: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
453:
454: -- if cons_inv_flag is NULL, get it defaulted from profile class
455: -- if it is still NULL, assign it as 'N'

Line 997: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

993: l_cons_bill_level VARCHAR2(30);
994: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
995: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
996: l_message_text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
997: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
998: l_standard_terms NUMBER;
999: l_profile_class_changed VARCHAR2(10);
1000:
1001: cursor c_acct_use_profile_dtls IS

Line 1068: FROM HZ_CUST_PROFILE_CLASSES

1064:
1065: l_profile_class_changed := 'Y';
1066:
1067: SELECT * INTO l_profile_class_rec
1068: FROM HZ_CUST_PROFILE_CLASSES
1069: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
1070:
1071: -- While changing the profile class for an existing cusromer profile record
1072: -- it should do the validations based on the new input parameters.