APPS.HZ_LOCATION_PROFILES_PKG dependencies on HZ_LOCATION_PROFILES

Line 1: PACKAGE BODY hz_location_profiles_pkg AS

1: PACKAGE BODY hz_location_profiles_pkg AS
2: /*$Header: ARHLOCPB.pls 115.1 2003/08/14 00:22:41 acng noship $ */
3:
4: PROCEDURE insert_row (
5: x_location_profile_id IN OUT NOCOPY NUMBER,

Line 45: INSERT INTO hz_location_profiles (

41: END IF;
42:
43: WHILE l_success = 'N' LOOP
44: BEGIN
45: INSERT INTO hz_location_profiles (
46: location_profile_id,
47: location_id,
48: actual_content_source,
49: effective_start_date,

Line 72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,

68: object_version_number
69: )
70: VALUES (
71: DECODE(x_location_profile_id,
72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,
73: NULL, hz_location_profiles_s.NEXTVAL,
74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),

Line 73: NULL, hz_location_profiles_s.NEXTVAL,

69: )
70: VALUES (
71: DECODE(x_location_profile_id,
72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,
73: NULL, hz_location_profiles_s.NEXTVAL,
74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),
77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),

Line 106: IF INSTRB(SQLERRM, 'HZ_LOCATION_PROFILES_U1') <> 0 OR

102: l_success := 'Y';
103:
104: EXCEPTION
105: WHEN DUP_VAL_ON_INDEX THEN
106: IF INSTRB(SQLERRM, 'HZ_LOCATION_PROFILES_U1') <> 0 OR
107: INSTRB(SQLERRM, 'HZ_LOCATION_PROFILES_PK') <> 0
108: THEN
109: IF l_primary_key_passed THEN
110: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 107: INSTRB(SQLERRM, 'HZ_LOCATION_PROFILES_PK') <> 0

103:
104: EXCEPTION
105: WHEN DUP_VAL_ON_INDEX THEN
106: IF INSTRB(SQLERRM, 'HZ_LOCATION_PROFILES_U1') <> 0 OR
107: INSTRB(SQLERRM, 'HZ_LOCATION_PROFILES_PK') <> 0
108: THEN
109: IF l_primary_key_passed THEN
110: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
111: fnd_message.set_token('COLUMN', 'location_profile_id');

Line 122: FROM HZ_LOCATION_PROFILES;

118: l_max_profile_id NUMBER;
119: BEGIN
120: l_temp_profile_id := 0;
121: SELECT max(LOCATION_PROFILE_ID) INTO l_max_profile_id
122: FROM HZ_LOCATION_PROFILES;
123: WHILE l_temp_profile_id <= l_max_profile_id LOOP
124: SELECT HZ_LOCATION_PROFILES_S.NEXTVAL
125: INTO l_temp_profile_id FROM dual;
126: END LOOP;

Line 124: SELECT HZ_LOCATION_PROFILES_S.NEXTVAL

120: l_temp_profile_id := 0;
121: SELECT max(LOCATION_PROFILE_ID) INTO l_max_profile_id
122: FROM HZ_LOCATION_PROFILES;
123: WHILE l_temp_profile_id <= l_max_profile_id LOOP
124: SELECT HZ_LOCATION_PROFILES_S.NEXTVAL
125: INTO l_temp_profile_id FROM dual;
126: END LOOP;
127: END;
128:

Line 158: UPDATE hz_location_profiles

154: x_country IN VARCHAR2,
155: x_object_version_number IN NUMBER
156: ) IS
157: BEGIN
158: UPDATE hz_location_profiles
159: SET location_profile_id = DECODE(x_location_profile_id,
160: NULL, location_profile_id,
161: fnd_api.g_miss_num, NULL,
162: x_location_profile_id),

Line 273: FROM hz_location_profiles

269: ) IS
270:
271: CURSOR c IS
272: SELECT *
273: FROM hz_location_profiles
274: WHERE ROWID = x_rowid
275: FOR UPDATE NOWAIT;
276:
277: recinfo c%ROWTYPE;

Line 369: DELETE FROM hz_location_profiles

365:
366:
367: PROCEDURE delete_row (x_location_profile_id IN NUMBER) IS
368: BEGIN
369: DELETE FROM hz_location_profiles
370: WHERE location_profile_id = x_location_profile_id;
371:
372: IF (SQL%NOTFOUND) THEN
373: RAISE NO_DATA_FOUND;

Line 377: END hz_location_profiles_pkg;

373: RAISE NO_DATA_FOUND;
374: END IF;
375: END delete_row;
376:
377: END hz_location_profiles_pkg;