APPS.PN_NOTE_DETAILS_PKG dependencies on PN_NOTE_DETAILS

Line 1: package body PN_NOTE_DETAILS_PKG As

1: package body PN_NOTE_DETAILS_PKG As
2: /* $Header: PNTNOTDB.pls 120.1 2005/08/05 06:28:07 appldev ship $ */
3: -------------------------------------------------------------------
4: -- PROCEDURE : INSERT_ROW
5: -------------------------------------------------------------------

Line 21: from PN_NOTE_DETAILS

17: )
18: IS
19: cursor C is
20: select ROWID
21: from PN_NOTE_DETAILS
22: where NOTE_DETAIL_ID = X_NOTE_DETAIL_ID
23: and LANGUAGE = userenv('LANG');
24: BEGIN
25: IF (X_NOTE_DETAIL_ID IS NULL) THEN

Line 26: select PN_NOTE_DETAILS_S.nextval

22: where NOTE_DETAIL_ID = X_NOTE_DETAIL_ID
23: and LANGUAGE = userenv('LANG');
24: BEGIN
25: IF (X_NOTE_DETAIL_ID IS NULL) THEN
26: select PN_NOTE_DETAILS_S.nextval
27: into X_NOTE_DETAIL_ID
28: from dual;
29: END IF;
30:

Line 31: insert into PN_NOTE_DETAILS

27: into X_NOTE_DETAIL_ID
28: from dual;
29: END IF;
30:
31: insert into PN_NOTE_DETAILS
32: (
33: LAST_UPDATED_BY,
34: LAST_UPDATE_DATE,
35: LAST_UPDATE_LOGIN,

Line 60: from PN_NOTE_DETAILS T

56: where L.INSTALLED_FLAG in ('I', 'B')
57: and not exists
58: (
59: select NULL
60: from PN_NOTE_DETAILS T
61: where T.NOTE_DETAIL_ID = X_NOTE_DETAIL_ID
62: and T.LANGUAGE = L.LANGUAGE_CODE
63: );
64:

Line 88: from PN_NOTE_DETAILS

84: IS
85:
86: CURSOR C1 IS
87: select *
88: from PN_NOTE_DETAILS
89: where NOTE_DETAIL_ID = X_NOTE_DETAIL_ID
90: and LANGUAGE = userenv('LANG')
91: for update of NOTE_DETAIL_ID nowait;
92:

Line 129: update PN_NOTE_DETAILS

125: ,X_LAST_UPDATE_LOGIN in NUMBER
126: )
127: IS
128: BEGIN
129: update PN_NOTE_DETAILS
130: set TEXT = X_TEXT
131: ,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
132: ,LAST_UPDATED_BY = X_LAST_UPDATED_BY
133: ,LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 152: delete from PN_NOTE_DETAILS

148: X_NOTE_DETAIL_ID in NUMBER
149: )
150: IS
151: BEGIN
152: delete from PN_NOTE_DETAILS
153: where NOTE_DETAIL_ID = X_NOTE_DETAIL_ID;
154:
155: if (sql%notfound) then
156: raise no_data_found;

Line 167: update PN_NOTE_DETAILS T

163: -------------------------------------------------------------------
164: PROCEDURE ADD_LANGUAGE
165: IS
166: BEGIN
167: update PN_NOTE_DETAILS T
168: set ( TEXT) = (
169: select B.TEXT
170: from PN_NOTE_DETAILS B
171: where B.NOTE_DETAIL_ID = T.NOTE_DETAIL_ID

Line 170: from PN_NOTE_DETAILS B

166: BEGIN
167: update PN_NOTE_DETAILS T
168: set ( TEXT) = (
169: select B.TEXT
170: from PN_NOTE_DETAILS B
171: where B.NOTE_DETAIL_ID = T.NOTE_DETAIL_ID
172: and B.LANGUAGE = T.SOURCE_LANG
173: )
174: where ( T.NOTE_DETAIL_ID,

Line 180: from PN_NOTE_DETAILS SUBB,

176: ) IN
177: (
178: select SUBT.NOTE_DETAIL_ID,
179: SUBT.LANGUAGE
180: from PN_NOTE_DETAILS SUBB,
181: PN_NOTE_DETAILS SUBT
182: where SUBB.NOTE_DETAIL_ID = SUBT.NOTE_DETAIL_ID
183: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
184: and (SUBB.TEXT <> SUBT.TEXT)

Line 181: PN_NOTE_DETAILS SUBT

177: (
178: select SUBT.NOTE_DETAIL_ID,
179: SUBT.LANGUAGE
180: from PN_NOTE_DETAILS SUBB,
181: PN_NOTE_DETAILS SUBT
182: where SUBB.NOTE_DETAIL_ID = SUBT.NOTE_DETAIL_ID
183: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
184: and (SUBB.TEXT <> SUBT.TEXT)
185: );

Line 187: insert into PN_NOTE_DETAILS

183: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
184: and (SUBB.TEXT <> SUBT.TEXT)
185: );
186:
187: insert into PN_NOTE_DETAILS
188: (
189: LAST_UPDATED_BY,
190: LAST_UPDATE_DATE,
191: LAST_UPDATE_LOGIN,

Line 210: from PN_NOTE_DETAILS B,

206: B.NOTE_DETAIL_ID,
207: B.NOTE_HEADER_ID,
208: L.LANGUAGE_CODE,
209: B.SOURCE_LANG
210: from PN_NOTE_DETAILS B,
211: FND_LANGUAGES L
212: where L.INSTALLED_FLAG in ('I', 'B')
213: and B.LANGUAGE = userenv('LANG')
214: and not exists

Line 217: from PN_NOTE_DETAILS T

213: and B.LANGUAGE = userenv('LANG')
214: and not exists
215: (
216: select NULL
217: from PN_NOTE_DETAILS T
218: where T.NOTE_DETAIL_ID = B.NOTE_DETAIL_ID
219: and T.LANGUAGE = L.LANGUAGE_CODE
220: );
221: END ADD_LANGUAGE;

Line 223: END PN_NOTE_DETAILS_PKG;

219: and T.LANGUAGE = L.LANGUAGE_CODE
220: );
221: END ADD_LANGUAGE;
222:
223: END PN_NOTE_DETAILS_PKG;