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.JTF_CTM_UTILITY_PVT dependencies on JTF_CTM_UTILITY_PVT

Line 1: PACKAGE BODY JTF_CTM_UTILITY_PVT as

1: PACKAGE BODY JTF_CTM_UTILITY_PVT as
2: /* $Header: jtfvutlb.pls 120.0 2005/06/02 18:23:13 appldev ship $ */
3: --
4: -- NAME
5: -- JTF_CTM_UTILITY_PVT

Line 5: -- JTF_CTM_UTILITY_PVT

1: PACKAGE BODY JTF_CTM_UTILITY_PVT as
2: /* $Header: jtfvutlb.pls 120.0 2005/06/02 18:23:13 appldev ship $ */
3: --
4: -- NAME
5: -- JTF_CTM_UTILITY_PVT
6: --
7: -- HISTORY
8: -- 8/16/99 JDOCHERT CREATED
9: -- 04/19/00 VNEDUNGA Adding get_message procedure

Line 14: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_CTM_UTILITY_PVT';

10: -- 07/05/00 JDOCHERT Removed hard-coded reference to APPS
11: -- 03/17/04 ACHANDA Fix bug# 3511203
12:
13:
14: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_CTM_UTILITY_PVT';
15: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvutlb.pls';
16:
17: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

Line 376: l_Column_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;

372: l_Select number;
373: l_from number;
374: l_where number;
375: l_return_status VARCHAR2(01);
376: l_Column_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
377: l_String_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
378: l_TblName_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
379: i NUMBER;
380: j NUMBER;

Line 377: l_String_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;

373: l_from number;
374: l_where number;
375: l_return_status VARCHAR2(01);
376: l_Column_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
377: l_String_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
378: l_TblName_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
379: i NUMBER;
380: j NUMBER;
381: l_apps_schema_name VARCHAR2(30);

Line 378: l_TblName_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;

374: l_where number;
375: l_return_status VARCHAR2(01);
376: l_Column_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
377: l_String_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
378: l_TblName_Tbl JTF_CTM_UTILITY_PVt.util_string_tbl_type;
379: i NUMBER;
380: j NUMBER;
381: l_apps_schema_name VARCHAR2(30);
382: BEGIN

Line 413: JTF_CTM_UTILITY_PVT.Split(c_select, ',', l_return_status, l_Column_Tbl);

409: X_Where_Clause := substr(l_view_Text, l_where + 5);
410: --dbms_output.put_line(X_Where_Clause);
411:
412: -- Seperate the SELECT columns
413: JTF_CTM_UTILITY_PVT.Split(c_select, ',', l_return_status, l_Column_Tbl);
414: --
415: X_No_Of_Columns := l_Column_Tbl.Count;
416: --
417: --dbms_output.put_line('l_Column_Tbl.Count - ' || to_char(l_Column_Tbl.Count));

Line 422: --dbms_output.put_line('Before COLUMN JTF_CTM_UTILITY_PVT.Split - ' || l_Column_Tbl(i) );

418: --
419: -- Split the column into table alias and column name
420: FOR i in l_Column_Tbl.first .. l_Column_Tbl.Count LOOP
421: --
422: --dbms_output.put_line('Before COLUMN JTF_CTM_UTILITY_PVT.Split - ' || l_Column_Tbl(i) );
423: JTF_CTM_UTILITY_PVT.Split(l_Column_Tbl(i), '.', l_return_status, l_String_Tbl);
424: --dbms_output.put_line('After COLUMN JTF_CTM_UTILITY_PVT.Split - ' || l_String_Tbl(1));
425: --
426: -- If the use hasn't specified an alias

Line 423: JTF_CTM_UTILITY_PVT.Split(l_Column_Tbl(i), '.', l_return_status, l_String_Tbl);

419: -- Split the column into table alias and column name
420: FOR i in l_Column_Tbl.first .. l_Column_Tbl.Count LOOP
421: --
422: --dbms_output.put_line('Before COLUMN JTF_CTM_UTILITY_PVT.Split - ' || l_Column_Tbl(i) );
423: JTF_CTM_UTILITY_PVT.Split(l_Column_Tbl(i), '.', l_return_status, l_String_Tbl);
424: --dbms_output.put_line('After COLUMN JTF_CTM_UTILITY_PVT.Split - ' || l_String_Tbl(1));
425: --
426: -- If the use hasn't specified an alias
427: If l_String_Tbl.Count = 2 Then

Line 424: --dbms_output.put_line('After COLUMN JTF_CTM_UTILITY_PVT.Split - ' || l_String_Tbl(1));

420: FOR i in l_Column_Tbl.first .. l_Column_Tbl.Count LOOP
421: --
422: --dbms_output.put_line('Before COLUMN JTF_CTM_UTILITY_PVT.Split - ' || l_Column_Tbl(i) );
423: JTF_CTM_UTILITY_PVT.Split(l_Column_Tbl(i), '.', l_return_status, l_String_Tbl);
424: --dbms_output.put_line('After COLUMN JTF_CTM_UTILITY_PVT.Split - ' || l_String_Tbl(1));
425: --
426: -- If the use hasn't specified an alias
427: If l_String_Tbl.Count = 2 Then
428: x_view_Columns_Tbl(i).Table_Alias := l_String_Tbl(1);

Line 438: JTF_CTM_UTILITY_PVT.Split(X_From_Clause, ',', l_return_status, l_TblName_Tbl);

434: --
435: End LOOP;
436:
437: -- Seperate the FROM columns
438: JTF_CTM_UTILITY_PVT.Split(X_From_Clause, ',', l_return_status, l_TblName_Tbl);
439: -- Split the column into table alias and column name
440: FOR i in l_TblName_Tbl.first .. l_TblName_Tbl.Count LOOP
441: --
442: --dbms_output.put_line('Before FROM JTF_CTM_UTILITY_PVT.Split - ' || l_TblName_Tbl(i));

Line 442: --dbms_output.put_line('Before FROM JTF_CTM_UTILITY_PVT.Split - ' || l_TblName_Tbl(i));

438: JTF_CTM_UTILITY_PVT.Split(X_From_Clause, ',', l_return_status, l_TblName_Tbl);
439: -- Split the column into table alias and column name
440: FOR i in l_TblName_Tbl.first .. l_TblName_Tbl.Count LOOP
441: --
442: --dbms_output.put_line('Before FROM JTF_CTM_UTILITY_PVT.Split - ' || l_TblName_Tbl(i));
443: JTF_CTM_UTILITY_PVT.Split(l_TblName_Tbl(i), ' ', l_return_status, l_String_Tbl);
444: --dbms_output.put_line('After FROM JTF_CTM_UTILITY_PVT.Split - ' || l_String_Tbl(1));
445: --
446: -- If the use hasn't specified an alias

Line 443: JTF_CTM_UTILITY_PVT.Split(l_TblName_Tbl(i), ' ', l_return_status, l_String_Tbl);

439: -- Split the column into table alias and column name
440: FOR i in l_TblName_Tbl.first .. l_TblName_Tbl.Count LOOP
441: --
442: --dbms_output.put_line('Before FROM JTF_CTM_UTILITY_PVT.Split - ' || l_TblName_Tbl(i));
443: JTF_CTM_UTILITY_PVT.Split(l_TblName_Tbl(i), ' ', l_return_status, l_String_Tbl);
444: --dbms_output.put_line('After FROM JTF_CTM_UTILITY_PVT.Split - ' || l_String_Tbl(1));
445: --
446: -- If the use hasn't specified an alias
447: If l_String_Tbl.Count = 2 Then

Line 444: --dbms_output.put_line('After FROM JTF_CTM_UTILITY_PVT.Split - ' || l_String_Tbl(1));

440: FOR i in l_TblName_Tbl.first .. l_TblName_Tbl.Count LOOP
441: --
442: --dbms_output.put_line('Before FROM JTF_CTM_UTILITY_PVT.Split - ' || l_TblName_Tbl(i));
443: JTF_CTM_UTILITY_PVT.Split(l_TblName_Tbl(i), ' ', l_return_status, l_String_Tbl);
444: --dbms_output.put_line('After FROM JTF_CTM_UTILITY_PVT.Split - ' || l_String_Tbl(1));
445: --
446: -- If the use hasn't specified an alias
447: If l_String_Tbl.Count = 2 Then
448: x_view_From_Tbl(i).Table_Alias := l_String_Tbl(2);

Line 554: END JTF_CTM_UTILITY_PVT;

550:
551: END Get_Messages;
552:
553:
554: END JTF_CTM_UTILITY_PVT;