APPS.JTF_LOC_POSTAL_CODES_PVT dependencies on JTF_LOC_POSTAL_CODES

Line 1: PACKAGE BODY JTF_Loc_Postal_Codes_PVT AS

1: PACKAGE BODY JTF_Loc_Postal_Codes_PVT AS
2: /* $Header: jtfvlopb.pls 120.2 2005/08/18 22:55:35 stopiwal ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_Loc_Postal_Codes_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_Loc_Postal_Codes_PVT';

1: PACKAGE BODY JTF_Loc_Postal_Codes_PVT AS
2: /* $Header: jtfvlopb.pls 120.2 2005/08/18 22:55:35 stopiwal ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_Loc_Postal_Codes_PVT';
5:
6: /*****************************************************************************/
7: -- Procedure: create_postal_code
8: --

Line 36: SELECT JTF_LOC_POSTAL_CODES_S.NEXTVAL

32: l_postal_code_rec postal_code_rec_type := p_postal_code_rec;
33: l_postal_code_count NUMBER;
34:
35: CURSOR c_postal_code_seq IS
36: SELECT JTF_LOC_POSTAL_CODES_S.NEXTVAL
37: FROM DUAL;
38:
39: CURSOR c_postal_code_count(postal_code_id IN NUMBER) IS
40: SELECT COUNT(*)

Line 41: FROM JTF_LOC_POSTAL_CODES

37: FROM DUAL;
38:
39: CURSOR c_postal_code_count(postal_code_id IN NUMBER) IS
40: SELECT COUNT(*)
41: FROM JTF_LOC_POSTAL_CODES
42: WHERE location_postal_code_id = postal_code_id;
43:
44: BEGIN
45: -- initialize

Line 105: INSERT INTO JTF_LOC_POSTAL_CODES

101:
102: -- insert
103: JTF_Utility_PVT.debug_message(l_full_name || ': insert');
104:
105: INSERT INTO JTF_LOC_POSTAL_CODES
106: (
107: location_postal_code_id,
108: last_update_date,
109: last_updated_by,

Line 294: UPDATE JTF_LOC_POSTAL_CODES SET

290: -- update
291: JTF_Utility_PVT.debug_message(l_full_name||': update');
292:
293: IF p_remove_flag = 'Y' THEN
294: UPDATE JTF_LOC_POSTAL_CODES SET
295: end_date_active = SYSDATE
296: WHERE location_postal_code_id = l_postal_code_rec.location_postal_code_id
297: AND object_version_number = l_postal_code_rec.object_version_number;
298: ELSE

Line 299: UPDATE JTF_LOC_POSTAL_CODES SET

295: end_date_active = SYSDATE
296: WHERE location_postal_code_id = l_postal_code_rec.location_postal_code_id
297: AND object_version_number = l_postal_code_rec.object_version_number;
298: ELSE
299: UPDATE JTF_LOC_POSTAL_CODES SET
300: last_update_date = SYSDATE,
301: last_updated_by = FND_GLOBAL.user_id,
302: object_version_number = l_postal_code_rec.object_version_number + 1,
303: last_update_login = FND_GLOBAL.conc_login_id,

Line 426: DELETE FROM JTF_LOC_POSTAL_CODES

422:
423: -- delete
424: JTF_Utility_PVT.debug_message(l_full_name || ': delete');
425:
426: DELETE FROM JTF_LOC_POSTAL_CODES
427: WHERE location_postal_code_id = p_postal_code_id
428: AND object_version_number = p_object_version;
429:
430: IF (SQL%NOTFOUND) THEN

Line 517: FROM JTF_LOC_POSTAL_CODES

513: l_postal_code_id NUMBER;
514:
515: CURSOR c_postal_code IS
516: SELECT location_postal_code_id
517: FROM JTF_LOC_POSTAL_CODES
518: WHERE location_postal_code_id = p_postal_code_id
519: AND object_version_number = p_object_version
520: FOR UPDATE OF location_postal_code_id NOWAIT;
521:

Line 960: SELECT * FROM JTF_LOC_POSTAL_CODES

956: )
957: IS
958:
959: CURSOR c_postal_code IS
960: SELECT * FROM JTF_LOC_POSTAL_CODES
961: WHERE location_postal_code_id = p_postal_code_rec.location_postal_code_id;
962:
963: l_postal_code_rec c_postal_code%ROWTYPE;
964:

Line 1044: END JTF_Loc_Postal_Codes_PVT;

1040: x_postal_code_rec.postal_code_end := FND_API.g_miss_char;
1041:
1042: END init_rec;
1043:
1044: END JTF_Loc_Postal_Codes_PVT;