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.PJI_MT_ROWSET_PKG dependencies on PJI_MT_ROWSET_TL

Line 50: DELETE FROM pji_mt_rowset_TL

46: PROCEDURE DELETE_ROW (
47: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE
48: ) IS
49: BEGIN
50: DELETE FROM pji_mt_rowset_TL
51: WHERE rowset_code = p_rowset_code;
52:
53: IF (SQL%NOTFOUND) THEN
54: RAISE NO_DATA_FOUND;

Line 70: X_Name IN pji_mt_rowset_Tl.Name%TYPE,

66: PROCEDURE Insert_Row (
67: X_Rowid IN OUT NOCOPY ROWID,
68: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
69: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
70: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,

Line 71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,

67: X_Rowid IN OUT NOCOPY ROWID,
68: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
69: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
70: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,

Line 129: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_tl '||X_Rowset_Code;

125: , X_Last_Update_Login
126: );
127:
128: IF g_debug_mode = 'Y' THEN
129: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_tl '||X_Rowset_Code;
130: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
131: END IF;
132:
133: INSERT INTO pji_mt_rowset_tl

Line 133: INSERT INTO pji_mt_rowset_tl

129: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_tl '||X_Rowset_Code;
130: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
131: END IF;
132:
133: INSERT INTO pji_mt_rowset_tl
134: (
135: Rowset_Code,
136: Name,
137: Description,

Line 160: (SELECT NULL FROM pji_mt_rowset_tl T

156: USERENV('Lang')
157: FROM Fnd_Languages L
158: WHERE L.Installed_Flag IN ('I', 'B')
159: AND NOT EXISTS
160: (SELECT NULL FROM pji_mt_rowset_tl T
161: WHERE T.rowset_code = X_Rowset_Code
162: AND T.LANGUAGE = L.Language_Code);
163:
164: OPEN C;

Line 230: X_Name IN pji_mt_rowset_Tl.Name%TYPE,

226:
227: PROCEDURE Update_Row (
228: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
229: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
230: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
231: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
232: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
233: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
234: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,

Line 231: X_Description IN pji_mt_rowset_Tl.Description%TYPE,

227: PROCEDURE Update_Row (
228: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
229: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
230: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
231: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
232: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
233: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
234: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
235: X_Lock_Flag IN VARCHAR2 DEFAULT 'true',

Line 293: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_tl for '||X_Rowset_Code;

289: RAISE NO_DATA_FOUND;
290: END IF;
291:
292: IF g_debug_mode = 'Y' THEN
293: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_tl for '||X_Rowset_Code;
294: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
295: END IF;
296:
297: UPDATE pji_mt_rowset_tl

Line 297: UPDATE pji_mt_rowset_tl

293: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_tl for '||X_Rowset_Code;
294: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
295: END IF;
296:
297: UPDATE pji_mt_rowset_tl
298: SET Name = X_Name,
299: Description = X_Description,
300: Last_Update_Date = X_Last_Update_Date,
301: Last_Updated_By = X_Last_Updated_By,

Line 369: X_Name IN pji_mt_rowset_Tl.Name%TYPE,

365:
366: PROCEDURE Load_Row (
367: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
368: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
369: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
370: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
371: X_Owner IN VARCHAR2
372: )
373: IS

Line 370: X_Description IN pji_mt_rowset_Tl.Description%TYPE,

366: PROCEDURE Load_Row (
367: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
368: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
369: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
370: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
371: X_Owner IN VARCHAR2
372: )
373: IS
374: User_Id NUMBER := NULL;

Line 449: DELETE FROM pji_mt_rowset_tl T

445: PROCEDURE Add_Language
446: IS
447: BEGIN
448:
449: DELETE FROM pji_mt_rowset_tl T
450: WHERE NOT EXISTS
451: (SELECT NULL
452: FROM pji_mt_rowset_B B
453: WHERE B.rowset_code = T.rowset_code

Line 456: UPDATE pji_mt_rowset_tl T SET (

452: FROM pji_mt_rowset_B B
453: WHERE B.rowset_code = T.rowset_code
454: );
455:
456: UPDATE pji_mt_rowset_tl T SET (
457: NAME,
458: DESCRIPTION
459: ) = (SELECT
460: B.NAME,

Line 462: FROM pji_mt_rowset_tl B

458: DESCRIPTION
459: ) = (SELECT
460: B.NAME,
461: B.DESCRIPTION
462: FROM pji_mt_rowset_tl B
463: WHERE B.rowset_code = T.rowset_code
464: AND B.LANGUAGE = T.SOURCE_LANG)
465: WHERE (
466: T.rowset_code,

Line 471: FROM pji_mt_rowset_tl SUBB, pji_mt_rowset_tl SUBT

467: T.LANGUAGE
468: ) IN (SELECT
469: SUBT.rowset_code,
470: SUBT.LANGUAGE
471: FROM pji_mt_rowset_tl SUBB, pji_mt_rowset_tl SUBT
472: WHERE SUBB.rowset_code = SUBT.rowset_code
473: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
474: AND (SUBB.NAME <> SUBT.NAME
475: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 480: INSERT INTO pji_mt_rowset_tl(

476: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
477: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
478: ));
479:
480: INSERT INTO pji_mt_rowset_tl(
481: LAST_UPDATE_LOGIN,
482: CREATION_DATE,
483: CREATED_BY,
484: LAST_UPDATE_DATE,

Line 502: FROM pji_mt_rowset_tl B, FND_LANGUAGES L

498: B.NAME,
499: B.DESCRIPTION,
500: L.LANGUAGE_CODE,
501: B.SOURCE_LANG
502: FROM pji_mt_rowset_tl B, FND_LANGUAGES L
503: WHERE L.INSTALLED_FLAG IN ('I', 'B')
504: AND B.LANGUAGE = USERENV('LANG')
505: AND NOT EXISTS
506: (SELECT NULL

Line 507: FROM pji_mt_rowset_tl T

503: WHERE L.INSTALLED_FLAG IN ('I', 'B')
504: AND B.LANGUAGE = USERENV('LANG')
505: AND NOT EXISTS
506: (SELECT NULL
507: FROM pji_mt_rowset_tl T
508: WHERE T.rowset_code = B.rowset_code
509: AND T.LANGUAGE = L.LANGUAGE_CODE);
510: END ADD_LANGUAGE;
511:

Line 516: X_NAME IN pji_mt_rowset_TL.NAME%TYPE,

512:
513: PROCEDURE TRANSLATE_ROW (
514: X_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,
515: X_OWNER IN VARCHAR2 ,
516: X_NAME IN pji_mt_rowset_TL.NAME%TYPE,
517: X_DESCRIPTION IN pji_mt_rowset_TL.DESCRIPTION%TYPE
518: )IS
519: BEGIN
520:

Line 517: X_DESCRIPTION IN pji_mt_rowset_TL.DESCRIPTION%TYPE

513: PROCEDURE TRANSLATE_ROW (
514: X_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,
515: X_OWNER IN VARCHAR2 ,
516: X_NAME IN pji_mt_rowset_TL.NAME%TYPE,
517: X_DESCRIPTION IN pji_mt_rowset_TL.DESCRIPTION%TYPE
518: )IS
519: BEGIN
520:
521: UPDATE pji_mt_rowset_tl SET

Line 521: UPDATE pji_mt_rowset_tl SET

517: X_DESCRIPTION IN pji_mt_rowset_TL.DESCRIPTION%TYPE
518: )IS
519: BEGIN
520:
521: UPDATE pji_mt_rowset_tl SET
522: NAME = X_NAME,
523: DESCRIPTION = X_DESCRIPTION,
524: LAST_UPDATE_DATE = SYSDATE,
525: LAST_UPDATED_BY = DECODE(X_OWNER, 'SEED', 1, 0),