APPS.JTF_LOC_TYPES_PKG dependencies on JTF_LOC_TYPES_B

Line 15: cursor C is select ROWID from JTF_LOC_TYPES_B

11: X_CREATED_BY in NUMBER,
12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER) is
15: cursor C is select ROWID from JTF_LOC_TYPES_B
16: where LOCATION_TYPE_ID = X_LOCATION_TYPE_ID
17: ;
18: begin
19: insert into JTF_LOC_TYPES_B (

Line 19: insert into JTF_LOC_TYPES_B (

15: cursor C is select ROWID from JTF_LOC_TYPES_B
16: where LOCATION_TYPE_ID = X_LOCATION_TYPE_ID
17: ;
18: begin
19: insert into JTF_LOC_TYPES_B (
20: LOCATION_TYPE_ID,
21: OBJECT_VERSION_NUMBER,
22: LOCATION_TYPE_CODE,
23: CREATION_DATE,

Line 90: update JTF_LOC_TYPES_B set

86: X_LAST_UPDATED_BY in NUMBER,
87: X_LAST_UPDATE_LOGIN in NUMBER
88: ) is
89: begin
90: update JTF_LOC_TYPES_B set
91: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
92: LOCATION_TYPE_CODE = X_LOCATION_TYPE_CODE,
93: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
94: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 124: from JTF_LOC_TYPES_B B

120: begin
121: delete from JTF_LOC_TYPES_TL T
122: where not exists
123: (select NULL
124: from JTF_LOC_TYPES_B B
125: where B.LOCATION_TYPE_ID = T.LOCATION_TYPE_ID
126: );
127:
128: update JTF_LOC_TYPES_TL T set (

Line 218: from JTF_LOC_TYPES_B

214: l_type_id number;
215:
216: cursor c_obj_verno is
217: select object_version_number
218: from JTF_LOC_TYPES_B
219: where LOCATION_TYPE_ID = X_LOCATION_TYPE_ID;
220:
221: cursor c_chk_type_exists is
222: select 'x'

Line 223: from JTF_LOC_TYPES_B

219: where LOCATION_TYPE_ID = X_LOCATION_TYPE_ID;
220:
221: cursor c_chk_type_exists is
222: select 'x'
223: from JTF_LOC_TYPES_B
224: where LOCATION_TYPE_ID = X_LOCATION_TYPE_ID;
225:
226: cursor c_get_typeid is
227: select JTF_LOC_TYPES_B_S.nextval

Line 227: select JTF_LOC_TYPES_B_S.nextval

223: from JTF_LOC_TYPES_B
224: where LOCATION_TYPE_ID = X_LOCATION_TYPE_ID;
225:
226: cursor c_get_typeid is
227: select JTF_LOC_TYPES_B_S.nextval
228: from dual;
229:
230: BEGIN
231: