APPS.PO_UN_NUMBERS_PKG dependencies on PO_UN_NUMBERS_B

Line 33: cursor C is select ROWID from PO_UN_NUMBERS_B

29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from PO_UN_NUMBERS_B
34: where UN_NUMBER_ID = X_UN_NUMBER_ID
35: ;
36: CURSOR C2 IS SELECT po_un_numbers_s.nextval FROM sys.dual;
37:

Line 45: insert into PO_UN_NUMBERS_B (

41: FETCH C2 INTO X_UN_Number_ID;
42: CLOSE C2;
43: end if;
44:
45: insert into PO_UN_NUMBERS_B (
46: UN_NUMBER_ID,
47: HAZARD_CLASS_ID,
48: INACTIVE_DATE,
49: ATTRIBUTE_CATEGORY,

Line 183: from PO_UN_NUMBERS_B

179: ATTRIBUTE13,
180: ATTRIBUTE14,
181: ATTRIBUTE15,
182: REQUEST_ID
183: from PO_UN_NUMBERS_B
184: where UN_NUMBER_ID = X_UN_NUMBER_ID
185: for update of UN_NUMBER_ID nowait;
186: recinfo c%rowtype;
187:

Line 293: update PO_UN_NUMBERS_B set

289: X_LAST_UPDATED_BY in NUMBER,
290: X_LAST_UPDATE_LOGIN in NUMBER
291: ) is
292: begin
293: update PO_UN_NUMBERS_B set
294: HAZARD_CLASS_ID = X_HAZARD_CLASS_ID,
295: INACTIVE_DATE = X_INACTIVE_DATE,
296: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
297: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 348: delete from PO_UN_NUMBERS_B

344: if (sql%notfound) then
345: raise no_data_found;
346: end if;
347:
348: delete from PO_UN_NUMBERS_B
349: where UN_NUMBER_ID = X_UN_NUMBER_ID;
350:
351: if (sql%notfound) then
352: raise no_data_found;

Line 362: from PO_UN_NUMBERS_B B

358: begin
359: delete from PO_UN_NUMBERS_TL T
360: where not exists
361: (select NULL
362: from PO_UN_NUMBERS_B B
363: where B.UN_NUMBER_ID = T.UN_NUMBER_ID
364: );
365:
366: update PO_UN_NUMBERS_TL T set (