APPS.JTF_PREFAB_WSH_POES_PKG dependencies on JTF_PREFAB_WSH_POES_B

Line 21: cursor C is select ROWID from JTF_PREFAB_WSH_POES_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from JTF_PREFAB_WSH_POES_B
22: where WSH_PO_ID = X_WSH_PO_ID
23: ;
24: begin
25: insert into JTF_PREFAB_WSH_POES_B (

Line 25: insert into JTF_PREFAB_WSH_POES_B (

21: cursor C is select ROWID from JTF_PREFAB_WSH_POES_B
22: where WSH_PO_ID = X_WSH_PO_ID
23: ;
24: begin
25: insert into JTF_PREFAB_WSH_POES_B (
26: WSH_PO_ID,
27: OBJECT_VERSION_NUMBER,
28: -- SECURITY_GROUP_ID,
29: HOSTNAME,

Line 120: from JTF_PREFAB_WSH_POES_B

116: LOAD_PICK_UP_FLAG,
117: CACHE_SIZE,
118: WSH_TYPE,
119: PREFAB_ENABLED_FLAG
120: from JTF_PREFAB_WSH_POES_B
121: where WSH_PO_ID = X_WSH_PO_ID
122: for update of WSH_PO_ID nowait;
123: recinfo c%rowtype;
124:

Line 187: update JTF_PREFAB_WSH_POES_B set

183: X_LAST_UPDATED_BY in NUMBER,
184: X_LAST_UPDATE_LOGIN in NUMBER
185: ) is
186: begin
187: update JTF_PREFAB_WSH_POES_B set
188: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
189: -- SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
190: HOSTNAME = X_HOSTNAME,
191: WEIGHT = X_WEIGHT,

Line 230: delete from JTF_PREFAB_WSH_POES_B

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: delete from JTF_PREFAB_WSH_POES_B
231: where WSH_PO_ID = X_WSH_PO_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 244: from JTF_PREFAB_WSH_POES_B B

240: begin
241: delete from JTF_PREFAB_WSH_POES_TL T
242: where not exists
243: (select NULL
244: from JTF_PREFAB_WSH_POES_B B
245: where B.WSH_PO_ID = T.WSH_PO_ID
246: );
247:
248: update JTF_PREFAB_WSH_POES_TL T set (