APPS.JTF_LOC_POSTAL_CODES_PKG dependencies on JTF_LOC_POSTAL_CODES_PKG

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 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;