APPS.HZP_CPROF_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 90: from hz_customer_profiles cp

86: IF ( p_site_use_id is null ) THEN
87: --
88: select count(1)
89: into l_profile_count
90: from hz_customer_profiles cp
91: where cp.cust_account_id = p_customer_id
92: and cp.site_use_id is null;
93: --
94: ELSE

Line 99: from hz_customer_profiles cp,

95: /* bug3578108 : Added condition to pickup only bill to,
96: statement and dunning profile */
97: select count(1)
98: into l_profile_count
99: from hz_customer_profiles cp,
100: hz_cust_site_uses su
101: where cp.cust_account_id = p_customer_id
102: and cp.site_use_id = p_site_use_id
103: and su.site_use_id = cp.site_use_id

Line 127: from hz_customer_profiles

123: l_standard_terms number := null ;
124:
125: CURSOR c1 is
126: select standard_terms
127: from hz_customer_profiles
128: where rowid = p_rowid;
129: BEGIN
130: --
131: --

Line 294: SELECT hz_customer_profiles_s.nextval

290: -- in order bt create profile ammounts from a prfile class
291: --
292: IF ( x_customer_profile_id is null ) THEN
293: --
294: SELECT hz_customer_profiles_s.nextval
295: INTO x_customer_profile_id
296: FROM dual;
297: --
298: END IF;

Line 476: SELECT hz_customer_profiles_s.NEXTVAL

472: OPEN cu_class;
473: FETCH cu_class INTO lrec;
474: CLOSE cu_class;
475: --
476: SELECT hz_customer_profiles_s.NEXTVAL
477: INTO l_customer_profile_id
478: FROM DUAL;
479: --
480: x_cust_prof_rec.cust_account_profile_id := l_customer_profile_id;

Line 695: FROM HZ_CUSTOMER_PROFILES

691: IF l_object_version = -1 THEN
692:
693: SELECT OBJECT_VERSION_NUMBER
694: INTO l_object_version
695: FROM HZ_CUSTOMER_PROFILES
696: WHERE ROWID = X_rowid;
697:
698: IF (SQL%NOTFOUND) THEN
699: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');

Line 700: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUSTOMER_PROFILES');

696: WHERE ROWID = X_rowid;
697:
698: IF (SQL%NOTFOUND) THEN
699: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
700: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUSTOMER_PROFILES');
701: FND_MESSAGE.SET_TOKEN('ID',X_Customer_Profile_Id);
702: FND_MSG_PUB.ADD;
703:
704: FND_MSG_PUB.Count_And_Get(

Line 1122: FROM hz_customer_profiles

1118: --{bug#4084126
1119: CURSOR c_prof_class_id(p_customer_profile_id IN NUMBER)
1120: IS
1121: SELECT profile_class_id
1122: FROM hz_customer_profiles
1123: WHERE cust_account_profile_id = p_customer_profile_id;
1124:
1125: l_curr_profile_class_id NUMBER;
1126: --}

Line 1221: SELECT hz_customer_profiles_s.NEXTVAL INTO x_customer_profile_id FROM DUAL;

1217: END IF;
1218: --
1219: --
1220: IF (x_customer_profile_id is null ) THEN
1221: SELECT hz_customer_profiles_s.NEXTVAL INTO x_customer_profile_id FROM DUAL;
1222: END IF;
1223: --
1224: --
1225: --

Line 1277: UPDATE hz_customer_profiles

1273: OPEN c_prof_class_id(x_customer_profile_id);
1274: FETCH c_prof_class_id INTO l_curr_profile_class_id;
1275: IF c_prof_class_id%FOUND THEN
1276: IF l_curr_profile_class_id <> x_customer_profile_class_id THEN
1277: UPDATE hz_customer_profiles
1278: SET profile_class_id = x_customer_profile_class_id
1279: WHERE cust_account_profile_id = x_customer_profile_id;
1280: END IF;
1281: END IF;

Line 1642: FROM hz_customer_profiles

1638: --{bug#4084126
1639: CURSOR c_prof_class_id(p_customer_profile_id IN NUMBER)
1640: IS
1641: SELECT profile_class_id
1642: FROM hz_customer_profiles
1643: WHERE cust_account_profile_id = p_customer_profile_id;
1644:
1645: l_curr_profile_class_id NUMBER;
1646: --}

Line 1748: SELECT hz_customer_profiles_s.NEXTVAL INTO x_customer_profile_id FROM DUAL;

1744: END IF;
1745: --
1746: --
1747: IF (x_customer_profile_id is null ) THEN
1748: SELECT hz_customer_profiles_s.NEXTVAL INTO x_customer_profile_id FROM DUAL;
1749: END IF;
1750: --
1751: --
1752: --

Line 1804: UPDATE hz_customer_profiles

1800: OPEN c_prof_class_id(x_customer_profile_id);
1801: FETCH c_prof_class_id INTO l_curr_profile_class_id;
1802: IF c_prof_class_id%FOUND THEN
1803: IF l_curr_profile_class_id <> x_customer_profile_class_id THEN
1804: UPDATE hz_customer_profiles
1805: SET profile_class_id = x_customer_profile_class_id
1806: WHERE cust_account_profile_id = x_customer_profile_id;
1807: END IF;
1808: END IF;