APPS.HZ_CUSTOMER_PROFILES_PKG dependencies on HZ_CUST_PROFILE_CLASSES

Line 117: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

113: ) IS
114:
115: l_success VARCHAR2(1) := 'N';
116:
117: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
118:
119: BEGIN
120:
121: -- x_profile_class_id is defaulted to default profile class id

Line 125: FROM HZ_CUST_PROFILE_CLASSES

121: -- x_profile_class_id is defaulted to default profile class id
122: -- before calling table handler.
123:
124: SELECT * INTO l_profile_class_rec
125: FROM HZ_CUST_PROFILE_CLASSES
126: WHERE PROFILE_CLASS_ID = X_PROFILE_CLASS_ID;
127:
128: WHILE l_success = 'N' LOOP
129: BEGIN

Line 523: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

519: ) IS
520:
521: l_profile_class_updated VARCHAR2(1) := 'N';
522:
523: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
524:
525: BEGIN
526:
527: -- profile_class_id cannot be updated to null.

Line 532: FROM HZ_CUST_PROFILE_CLASSES

528: IF X_PROFILE_CLASS_ID IS NOT NULL THEN
529: l_profile_class_updated := 'Y';
530:
531: SELECT * INTO l_profile_class_rec
532: FROM HZ_CUST_PROFILE_CLASSES
533: WHERE PROFILE_CLASS_ID = X_PROFILE_CLASS_ID;
534: END IF;
535:
536: UPDATE HZ_CUSTOMER_PROFILES SET