APPS.PN_NOTE_HEADERS_PKG dependencies on PN_NOTE_HEADERS

Line 1: PACKAGE BODY PN_NOTE_HEADERS_PKG AS

1: PACKAGE BODY PN_NOTE_HEADERS_PKG AS
2: -- $Header: PNTNOTHB.pls 115.10 2004/05/26 07:03:43 abanerje ship $
3:
4: ------------------------------------------------------------------
5: -- PROCEDURE : INSERT_ROW

Line 38: from PN_NOTE_HEADERS

34: X_ATTRIBUTE15 IN VARCHAR2
35: ) is
36: cursor C is
37: select ROWID
38: from PN_NOTE_HEADERS
39: where NOTE_HEADER_ID = X_NOTE_HEADER_ID;
40: BEGIN
41:
42: IF (X_NOTE_HEADER_ID IS NULL) THEN

Line 43: select PN_NOTE_HEADERS_S.nextval

39: where NOTE_HEADER_ID = X_NOTE_HEADER_ID;
40: BEGIN
41:
42: IF (X_NOTE_HEADER_ID IS NULL) THEN
43: select PN_NOTE_HEADERS_S.nextval
44: into X_NOTE_HEADER_ID
45: from dual;
46: END IF;
47:

Line 48: insert into PN_NOTE_HEADERS

44: into X_NOTE_HEADER_ID
45: from dual;
46: END IF;
47:
48: insert into PN_NOTE_HEADERS
49: (
50: NOTE_HEADER_ID,
51: NOTE_DATE,
52: LAST_UPDATED_BY,

Line 145: from PN_NOTE_HEADERS

141: )
142: is
143: cursor c1 is
144: select *
145: from PN_NOTE_HEADERS
146: where NOTE_HEADER_ID = X_NOTE_HEADER_ID
147: for update of NOTE_HEADER_ID nowait;
148:
149: tlinfo c1%rowtype;

Line 297: update PN_NOTE_HEADERS

293: X_ATTRIBUTE15 in VARCHAR2
294: )
295: IS
296: BEGIN
297: update PN_NOTE_HEADERS
298: set LEASE_ID = X_LEASE_ID,
299: NOTE_DATE = X_NOTE_DATE,
300: NOTE_TYPE_LOOKUP_CODE = X_NOTE_TYPE_LOOKUP_CODE,
301: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 347: delete from PN_NOTE_HEADERS where NOTE_HEADER_ID = X_NOTE_HEADER_ID;

343: FOR i IN C LOOP
344: PN_NOTE_DETAILS_PKG.DELETE_ROW (X_NOTE_DETAIL_ID =>i.note_detail_id);
345: END LOOP;
346:
347: delete from PN_NOTE_HEADERS where NOTE_HEADER_ID = X_NOTE_HEADER_ID;
348:
349: if (sql%notfound) then
350: raise no_data_found;
351: end if;

Line 355: END PN_NOTE_HEADERS_PKG;

351: end if;
352:
353: END DELETE_ROW;
354:
355: END PN_NOTE_HEADERS_PKG;