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.AMV_SEARCH_PVT dependencies on AMV_UTILITY_PVT

Line 61: G_PUBLIC CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PUBLIC;

57: G_WORD_CONS CONSTANT VARCHAR2(30) := 'WORD_CONS';
58:
59:
60:
61: G_PUBLIC CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PUBLIC;
62:
63: G_PRIVATE CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PRIVATE;
64:
65: G_GROUP CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_GROUP;

Line 63: G_PRIVATE CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PRIVATE;

59:
60:
61: G_PUBLIC CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PUBLIC;
62:
63: G_PRIVATE CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PRIVATE;
64:
65: G_GROUP CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_GROUP;
66:
67: G_CONTENT CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CONTENT;

Line 65: G_GROUP CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_GROUP;

61: G_PUBLIC CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PUBLIC;
62:
63: G_PRIVATE CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PRIVATE;
64:
65: G_GROUP CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_GROUP;
66:
67: G_CONTENT CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CONTENT;
68:
69:

Line 67: G_CONTENT CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CONTENT;

63: G_PRIVATE CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_PRIVATE;
64:
65: G_GROUP CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_GROUP;
66:
67: G_CONTENT CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CONTENT;
68:
69:
70:
71: G_APPROVED CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_APPROVED;

Line 71: G_APPROVED CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_APPROVED;

67: G_CONTENT CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CONTENT;
68:
69:
70:
71: G_APPROVED CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_APPROVED;
72:
73: G_CHANNEL CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CHANNEL;
74:
75: G_CATEGORY CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CATEGORY;

Line 73: G_CHANNEL CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CHANNEL;

69:
70:
71: G_APPROVED CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_APPROVED;
72:
73: G_CHANNEL CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CHANNEL;
74:
75: G_CATEGORY CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CATEGORY;
76:
77: G_ITEM CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_ITEM;

Line 75: G_CATEGORY CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CATEGORY;

71: G_APPROVED CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_APPROVED;
72:
73: G_CHANNEL CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CHANNEL;
74:
75: G_CATEGORY CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CATEGORY;
76:
77: G_ITEM CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_ITEM;
78:
79: G_AUTHOR CONSTANT VARCHAR2(30) := 'AUTHOR';

Line 77: G_ITEM CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_ITEM;

73: G_CHANNEL CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CHANNEL;
74:
75: G_CATEGORY CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_CATEGORY;
76:
77: G_ITEM CONSTANT VARCHAR2(30) := AMV_UTILITY_PVT.G_ITEM;
78:
79: G_AUTHOR CONSTANT VARCHAR2(30) := 'AUTHOR';
80:
81: G_KEYWORD CONSTANT VARCHAR2(30) := 'KEYWORD';

Line 1497: --AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''' ||

1493: --l_where1 := l_where1 || ' AND cim.approval_status_type = '''||
1494:
1495: --G_APPROVED ||'''' || ' AND cim.table_name_code = '''||
1496:
1497: --AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''' ||
1498:
1499: --' AND cim.available_for_channel_date <= sysdate ';
1500:
1501:

Line 1508: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''' ||

1504: l_mainWhere := l_mainWhere || ' AND cim.approval_status_type = '''||
1505:
1506: G_APPROVED ||'''' || ' AND cim.table_name_code = '''||
1507:
1508: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''' ||
1509:
1510: ' AND cim.available_for_channel_date <= sysdate ';
1511:
1512: --ss

Line 2568: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''';

2564: x_sql_statement(p_index) :=
2565:
2566: ' AND cim.table_name_code = '''||
2567:
2568: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''';
2569:
2570: p_index := p_index + 1;
2571:
2572: x_sql_statement(p_index) :=

Line 2954: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''';

2950: x_sql_statement(p_index) :=
2951:
2952: ' AND cim.table_name_code = '''||
2953:
2954: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''';
2955:
2956: p_index := p_index + 1;
2957:
2958: x_sql_statement(p_index) :=

Line 3316: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''';

3312: x_sql_statement(p_index) :=
3313:
3314: ' AND cim.table_name_code = '''||
3315:
3316: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''';
3317:
3318: p_index := p_index + 1;
3319:
3320: x_sql_statement(p_index) :=

Line 3678: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''';

3674: x_sql_statement(p_index) :=
3675:
3676: ' AND cim.table_name_code = '''||
3677:
3678: AMV_UTILITY_PVT.G_TABLE_NAME_CODE ||'''';
3679:
3680: p_index := p_index + 1;
3681:
3682: x_sql_statement(p_index) :=

Line 3966: IF AMV_UTILITY_PVT.Is_CategoryIdValid(l_category_id(i)) THEN

3962:
3963:
3964: FOR i in 1..l_category_id.count LOOP
3965:
3966: IF AMV_UTILITY_PVT.Is_CategoryIdValid(l_category_id(i)) THEN
3967:
3968: IF p_include_subcats = FND_API.G_FALSE THEN
3969:
3970: l_cat_count := l_cat_count + 1;

Line 6370: AMV_UTILITY_PVT.Get_UserInfo(

6366: END IF;
6367:
6368: -- Get the current (login) user id.
6369:
6370: AMV_UTILITY_PVT.Get_UserInfo(
6371:
6372: x_resource_id => l_resource_id,
6373:
6374: x_user_id => l_user_id,

Line 6980: AMV_UTILITY_PVT.Get_UserInfo(

6976: END IF;
6977:
6978: -- Get the current (login) user id.
6979:
6980: AMV_UTILITY_PVT.Get_UserInfo(
6981:
6982: x_resource_id => l_resource_id,
6983:
6984: x_user_id => l_user_id,

Line 7886: AMV_UTILITY_PVT.Get_UserInfo(

7882: END IF;
7883:
7884: -- Get the current (login) user id.
7885:
7886: AMV_UTILITY_PVT.Get_UserInfo(
7887:
7888: x_resource_id => l_resource_id,
7889:
7890: x_user_id => l_user_id,