APPS.HZ_CUSTOMER_PROFILES_PKG dependencies on HZ_CUST_PROFILE_CLASSES

Line 118: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

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

Line 126: FROM HZ_CUST_PROFILE_CLASSES

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

Line 534: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;

530: ) IS
531:
532: l_profile_class_updated VARCHAR2(1) := 'N';
533:
534: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
535:
536: BEGIN
537:
538: -- profile_class_id cannot be updated to null.

Line 543: FROM HZ_CUST_PROFILE_CLASSES

539: IF X_PROFILE_CLASS_ID IS NOT NULL THEN
540: l_profile_class_updated := 'Y';
541:
542: SELECT * INTO l_profile_class_rec
543: FROM HZ_CUST_PROFILE_CLASSES
544: WHERE PROFILE_CLASS_ID = X_PROFILE_CLASS_ID;
545: END IF;
546:
547: UPDATE HZ_CUSTOMER_PROFILES SET