eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_SETS_PKG dependencies on PA_PROJECT_SETS_TL

Line 6: ( p_project_set_name IN pa_project_sets_tl.name%TYPE

2: /*$Header: PAPPSPKB.pls 120.1 2005/08/19 16:43:34 mwasowic noship $*/
3: --+
4:
5: PROCEDURE insert_row
6: ( p_project_set_name IN pa_project_sets_tl.name%TYPE
7: ,p_party_id IN pa_project_sets_b.party_id%TYPE
8: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
9: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
10: ,p_access_level IN pa_project_sets_b.access_level%TYPE

Line 11: ,p_description IN pa_project_sets_tl.description%TYPE

7: ,p_party_id IN pa_project_sets_b.party_id%TYPE
8: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
9: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
10: ,p_access_level IN pa_project_sets_b.access_level%TYPE
11: ,p_description IN pa_project_sets_tl.description%TYPE
12: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE

Line 104: INSERT INTO pa_project_sets_tl

100: ,fnd_global.login_id
101: )
102: RETURNING project_set_id INTO x_project_set_id;
103:
104: INSERT INTO pa_project_sets_tl
105: ( project_set_id
106: ,language
107: ,source_lang
108: ,name

Line 130: from pa_project_sets_tl T

126: FROM fnd_languages L
127: WHERE l.installed_flag IN ('I', 'B')
128: AND NOT EXISTS
129: (select null
130: from pa_project_sets_tl T
131: where T.project_set_id = x_project_set_id
132: and T.language = L.language_code);
133:
134:

Line 150: ,p_project_set_name IN pa_project_sets_tl.name%TYPE

146:
147:
148: PROCEDURE update_row
149: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
150: ,p_project_set_name IN pa_project_sets_tl.name%TYPE
151: ,p_party_id IN pa_project_sets_b.party_id%TYPE
152: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
154: ,p_access_level IN pa_project_sets_b.access_level%TYPE

Line 155: ,p_description IN pa_project_sets_tl.description%TYPE

151: ,p_party_id IN pa_project_sets_b.party_id%TYPE
152: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
154: ,p_access_level IN pa_project_sets_b.access_level%TYPE
155: ,p_description IN pa_project_sets_tl.description%TYPE
156: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
157: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
158: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
159: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE

Line 223: UPDATE pa_project_sets_tl

219: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: ELSE
222:
223: UPDATE pa_project_sets_tl
224: SET name = decode(p_project_set_name, FND_API.G_MISS_CHAR, name, p_project_set_name)
225: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
226: ,last_update_date = sysdate
227: ,last_updated_by = fnd_global.user_id

Line 273: DELETE FROM pa_project_sets_tl

269: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: ELSE
272:
273: DELETE FROM pa_project_sets_tl
274: WHERE project_set_id = p_project_set_id;
275:
276: IF (SQL%NOTFOUND) THEN
277: x_return_status := FND_API.G_RET_STS_ERROR;

Line 384: delete from PA_PROJECT_SETS_TL T

380: --
381: procedure ADD_LANGUAGE
382: is
383: begin
384: delete from PA_PROJECT_SETS_TL T
385: where not exists
386: (select NULL
387: from PA_PROJECT_SETS_B B
388: where B.PROJECT_SET_ID = T.PROJECT_SET_ID

Line 391: update PA_PROJECT_SETS_TL T set (

387: from PA_PROJECT_SETS_B B
388: where B.PROJECT_SET_ID = T.PROJECT_SET_ID
389: );
390:
391: update PA_PROJECT_SETS_TL T set (
392: NAME,
393: DESCRIPTION
394: ) = (select
395: B.NAME,

Line 397: from PA_PROJECT_SETS_TL B

393: DESCRIPTION
394: ) = (select
395: B.NAME,
396: B.DESCRIPTION
397: from PA_PROJECT_SETS_TL B
398: where B.PROJECT_SET_ID = T.PROJECT_SET_ID
399: and B.LANGUAGE = T.SOURCE_LANG)
400: where (
401: T.PROJECT_SET_ID,

Line 406: from PA_PROJECT_SETS_TL SUBB, PA_PROJECT_SETS_TL SUBT

402: T.LANGUAGE
403: ) in (select
404: SUBT.PROJECT_SET_ID,
405: SUBT.LANGUAGE
406: from PA_PROJECT_SETS_TL SUBB, PA_PROJECT_SETS_TL SUBT
407: where SUBB.PROJECT_SET_ID = SUBT.PROJECT_SET_ID
408: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
409: and (SUBB.NAME <> SUBT.NAME
410: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 415: insert into PA_PROJECT_SETS_TL (

411: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
412: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
413: ));
414:
415: insert into PA_PROJECT_SETS_TL (
416: PROJECT_SET_ID,
417: NAME,
418: DESCRIPTION,
419: CREATED_BY,

Line 437: from PA_PROJECT_SETS_TL B, FND_LANGUAGES L

433: B.LAST_UPDATE_DATE,
434: B.LAST_UPDATE_LOGIN,
435: L.LANGUAGE_CODE,
436: B.SOURCE_LANG
437: from PA_PROJECT_SETS_TL B, FND_LANGUAGES L
438: where L.INSTALLED_FLAG in ('I', 'B')
439: and B.LANGUAGE = userenv('LANG')
440: and not exists
441: (select NULL

Line 442: from PA_PROJECT_SETS_TL T

438: where L.INSTALLED_FLAG in ('I', 'B')
439: and B.LANGUAGE = userenv('LANG')
440: and not exists
441: (select NULL
442: from PA_PROJECT_SETS_TL T
443: where T.PROJECT_SET_ID = B.PROJECT_SET_ID
444: and T.LANGUAGE = L.LANGUAGE_CODE);
445: end ADD_LANGUAGE;
446: