APPS.PO_HAZARD_CLASSES_PKG dependencies on PO_HAZARD_CLASSES_B

Line 32: cursor C is select ROWID from PO_HAZARD_CLASSES_B

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from PO_HAZARD_CLASSES_B
33: where HAZARD_CLASS_ID = X_HAZARD_CLASS_ID
34: ;
35: begin
36: insert into PO_HAZARD_CLASSES_B (

Line 36: insert into PO_HAZARD_CLASSES_B (

32: cursor C is select ROWID from PO_HAZARD_CLASSES_B
33: where HAZARD_CLASS_ID = X_HAZARD_CLASS_ID
34: ;
35: begin
36: insert into PO_HAZARD_CLASSES_B (
37: HAZARD_CLASS_ID,
38: INACTIVE_DATE,
39: ATTRIBUTE_CATEGORY,
40: ATTRIBUTE1,

Line 170: from PO_HAZARD_CLASSES_B

166: ATTRIBUTE13,
167: ATTRIBUTE14,
168: ATTRIBUTE15,
169: REQUEST_ID
170: from PO_HAZARD_CLASSES_B
171: where HAZARD_CLASS_ID = X_HAZARD_CLASS_ID
172: for update of HAZARD_CLASS_ID nowait;
173: recinfo c%rowtype;
174:

Line 278: update PO_HAZARD_CLASSES_B set

274: X_LAST_UPDATED_BY in NUMBER,
275: X_LAST_UPDATE_LOGIN in NUMBER
276: ) is
277: begin
278: update PO_HAZARD_CLASSES_B set
279: INACTIVE_DATE = X_INACTIVE_DATE,
280: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
281: ATTRIBUTE1 = X_ATTRIBUTE1,
282: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 332: delete from PO_HAZARD_CLASSES_B

328: if (sql%notfound) then
329: raise no_data_found;
330: end if;
331:
332: delete from PO_HAZARD_CLASSES_B
333: where HAZARD_CLASS_ID = X_HAZARD_CLASS_ID;
334:
335: if (sql%notfound) then
336: raise no_data_found;

Line 346: from PO_HAZARD_CLASSES_B B

342: begin
343: delete from PO_HAZARD_CLASSES_TL T
344: where not exists
345: (select NULL
346: from PO_HAZARD_CLASSES_B B
347: where B.HAZARD_CLASS_ID = T.HAZARD_CLASS_ID
348: );
349:
350: update PO_HAZARD_CLASSES_TL T set (