DBA Data[Home] [Help]

APPS.JTF_LOC_POSTAL_CODES_PKG dependencies on JTF_LOC_POSTAL_CODES_S

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