APPS.JTF_LOC_POSTAL_CODES_PKG dependencies on JTF_LOC_POSTAL_CODES

Line 1: package body JTF_LOC_POSTAL_CODES_PKG as

1: package body JTF_LOC_POSTAL_CODES_PKG as
2: /* $Header: jtfllopb.pls 120.2 2005/08/18 23:07:51 stopiwal ship $ */
3: procedure INSERT_ROW (
4: X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5: X_LOCATION_POSTAL_CODE_ID in NUMBER,

Line 19: cursor c is select ROWID from JTF_LOC_POSTAL_CODES

15: X_CREATED_BY in NUMBER,
16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER) is
19: cursor c is select ROWID from JTF_LOC_POSTAL_CODES
20: where LOCATION_POSTAL_CODE_ID = X_LOCATION_POSTAL_CODE_ID
21: ;
22: begin
23: insert into JTF_LOC_POSTAL_CODES (

Line 23: insert into JTF_LOC_POSTAL_CODES (

19: cursor c is select ROWID from JTF_LOC_POSTAL_CODES
20: where LOCATION_POSTAL_CODE_ID = X_LOCATION_POSTAL_CODE_ID
21: ;
22: begin
23: insert into JTF_LOC_POSTAL_CODES (
24: LOCATION_POSTAL_CODE_ID,
25: OBJECT_VERSION_NUMBER,
26: ORIG_SYSTEM_REF,
27: ORIG_SYSTEM_ID,

Line 79: update JTF_LOC_POSTAL_CODES set

75: X_LAST_UPDATED_BY in NUMBER,
76: X_LAST_UPDATE_LOGIN in NUMBER
77: ) is
78: begin
79: update JTF_LOC_POSTAL_CODES set
80: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
81: ORIG_SYSTEM_REF = X_ORIG_SYSTEM_REF,
82: ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID,
83: LOCATION_AREA_ID = X_LOCATION_AREA_ID,

Line 102: delete from JTF_LOC_POSTAL_CODES

98: procedure DELETE_ROW (
99: X_LOCATION_POSTAL_CODE_ID in NUMBER
100: ) is
101: begin
102: delete from JTF_LOC_POSTAL_CODES
103: where LOCATION_POSTAL_CODE_ID = X_LOCATION_POSTAL_CODE_ID;
104:
105: if (sql%notfound) then
106: raise no_data_found;

Line 130: from JTF_LOC_POSTAL_CODES

126: l_code_id number;
127:
128: cursor c_obj_verno is
129: select object_version_number
130: from JTF_LOC_POSTAL_CODES
131: where LOCATION_POSTAL_CODE_ID = X_LOCATION_POSTAL_CODE_ID;
132:
133: cursor c_chk_code_exists is
134: select 'x'

Line 135: from JTF_LOC_POSTAL_CODES

131: where LOCATION_POSTAL_CODE_ID = X_LOCATION_POSTAL_CODE_ID;
132:
133: cursor c_chk_code_exists is
134: select 'x'
135: from JTF_LOC_POSTAL_CODES
136: where LOCATION_POSTAL_CODE_ID = X_LOCATION_POSTAL_CODE_ID;
137:
138: cursor c_get_codeid is
139: select JTF_LOC_POSTAL_CODES_S.nextval

Line 139: select JTF_LOC_POSTAL_CODES_S.nextval

135: from JTF_LOC_POSTAL_CODES
136: where LOCATION_POSTAL_CODE_ID = X_LOCATION_POSTAL_CODE_ID;
137:
138: cursor c_get_codeid is
139: select JTF_LOC_POSTAL_CODES_S.nextval
140: from dual;
141:
142: BEGIN
143:

Line 162: JTF_LOC_POSTAL_CODES_PKG.INSERT_ROW(

158: else
159: l_code_id := X_LOCATION_POSTAL_CODE_ID;
160: end if;
161: l_obj_verno := 1;
162: JTF_LOC_POSTAL_CODES_PKG.INSERT_ROW(
163: X_ROWID => l_row_id,
164: X_LOCATION_POSTAL_CODE_ID => l_code_id,
165: X_OBJECT_VERSION_NUMBER => l_obj_verno,
166: X_ORIG_SYSTEM_REF => X_ORIG_SYSTEM_REF,

Line 184: JTF_LOC_POSTAL_CODES_PKG.UPDATE_ROW(

180: close c_chk_code_exists;
181: open c_obj_verno;
182: fetch c_obj_verno into l_obj_verno;
183: close c_obj_verno;
184: JTF_LOC_POSTAL_CODES_PKG.UPDATE_ROW(
185: X_LOCATION_POSTAL_CODE_ID => X_LOCATION_POSTAL_CODE_ID,
186: X_OBJECT_VERSION_NUMBER => l_obj_verno + 1,
187: X_ORIG_SYSTEM_REF => X_ORIG_SYSTEM_REF,
188: X_ORIG_SYSTEM_ID => X_ORIG_SYSTEM_ID,

Line 201: end JTF_LOC_POSTAL_CODES_PKG;

197: );
198: end if;
199: END LOAD_ROW;
200:
201: end JTF_LOC_POSTAL_CODES_PKG;