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.AMS_ADV_FILTER_PKG dependencies on FND_API

Line 70: DECODE( px_query_param_id, FND_API.g_miss_num, NULL, px_query_param_id),

66: last_update_login,
67: security_group_id
68: ) VALUES
69: (
70: DECODE( px_query_param_id, FND_API.g_miss_num, NULL, px_query_param_id),
71: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
72: DECODE( p_parameter_name, FND_API.g_miss_char, NULL, p_parameter_name),
73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),
74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),

Line 71: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),

67: security_group_id
68: ) VALUES
69: (
70: DECODE( px_query_param_id, FND_API.g_miss_num, NULL, px_query_param_id),
71: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
72: DECODE( p_parameter_name, FND_API.g_miss_char, NULL, p_parameter_name),
73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),
74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),
75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),

Line 72: DECODE( p_parameter_name, FND_API.g_miss_char, NULL, p_parameter_name),

68: ) VALUES
69: (
70: DECODE( px_query_param_id, FND_API.g_miss_num, NULL, px_query_param_id),
71: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
72: DECODE( p_parameter_name, FND_API.g_miss_char, NULL, p_parameter_name),
73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),
74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),
75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),
76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),

Line 73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),

69: (
70: DECODE( px_query_param_id, FND_API.g_miss_num, NULL, px_query_param_id),
71: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
72: DECODE( p_parameter_name, FND_API.g_miss_char, NULL, p_parameter_name),
73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),
74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),
75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),
76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),

70: DECODE( px_query_param_id, FND_API.g_miss_num, NULL, px_query_param_id),
71: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
72: DECODE( p_parameter_name, FND_API.g_miss_char, NULL, p_parameter_name),
73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),
74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),
75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),
76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),

71: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
72: DECODE( p_parameter_name, FND_API.g_miss_char, NULL, p_parameter_name),
73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),
74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),
75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),
76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),

72: DECODE( p_parameter_name, FND_API.g_miss_char, NULL, p_parameter_name),
73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),
74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),
75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),
76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

73: DECODE( p_parameter_type, FND_API.g_miss_char, NULL, p_parameter_type),
74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),
75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),
76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)

Line 78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

74: DECODE( p_parameter_value, FND_API.g_miss_char, NULL, p_parameter_value),
75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),
76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
82: );

Line 79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

75: DECODE( p_parameter_condition, FND_API.g_miss_char, NULL, p_parameter_condition),
76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
82: );
83: END Insert_Row;

Line 80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

76: DECODE( p_parameter_sequence, FND_API.g_miss_num, NULL, p_parameter_sequence),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
82: );
83: END Insert_Row;
84:

Line 81: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)

77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
82: );
83: END Insert_Row;
84:
85:

Line 119: parameter_name = DECODE( p_parameter_name, FND_API.g_miss_char, parameter_name, p_parameter_name),

115: AMS_UTILITY_PVT.debug_message('Table Handler API: Update_row');
116:
117: Update JTF_PERZ_QUERY_PARAM
118: SET
119: parameter_name = DECODE( p_parameter_name, FND_API.g_miss_char, parameter_name, p_parameter_name),
120: parameter_value = DECODE( p_parameter_value, FND_API.g_miss_char, parameter_value, p_parameter_value),
121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),
122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 120: parameter_value = DECODE( p_parameter_value, FND_API.g_miss_char, parameter_value, p_parameter_value),

116:
117: Update JTF_PERZ_QUERY_PARAM
118: SET
119: parameter_name = DECODE( p_parameter_name, FND_API.g_miss_char, parameter_name, p_parameter_name),
120: parameter_value = DECODE( p_parameter_value, FND_API.g_miss_char, parameter_value, p_parameter_value),
121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),
122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),

117: Update JTF_PERZ_QUERY_PARAM
118: SET
119: parameter_name = DECODE( p_parameter_name, FND_API.g_miss_char, parameter_name, p_parameter_name),
120: parameter_value = DECODE( p_parameter_value, FND_API.g_miss_char, parameter_value, p_parameter_value),
121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),
122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),

118: SET
119: parameter_name = DECODE( p_parameter_name, FND_API.g_miss_char, parameter_name, p_parameter_name),
120: parameter_value = DECODE( p_parameter_value, FND_API.g_miss_char, parameter_value, p_parameter_value),
121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),
122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
126: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

Line 123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

119: parameter_name = DECODE( p_parameter_name, FND_API.g_miss_char, parameter_name, p_parameter_name),
120: parameter_value = DECODE( p_parameter_value, FND_API.g_miss_char, parameter_value, p_parameter_value),
121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),
122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
126: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
127: WHERE query_param_id = px_query_param_id

Line 124: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

120: parameter_value = DECODE( p_parameter_value, FND_API.g_miss_char, parameter_value, p_parameter_value),
121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),
122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
126: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
127: WHERE query_param_id = px_query_param_id
128: AND query_id = p_query_id

Line 125: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),
122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
126: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
127: WHERE query_param_id = px_query_param_id
128: AND query_id = p_query_id
129: AND parameter_type = p_parameter_type ;

Line 126: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

122: parameter_sequence = DECODE( p_parameter_sequence, FND_API.g_miss_num, parameter_sequence, p_parameter_sequence),
123: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
126: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
127: WHERE query_param_id = px_query_param_id
128: AND query_id = p_query_id
129: AND parameter_type = p_parameter_type ;
130:

Line 134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

130:
131: IF (SQL%NOTFOUND) THEN
132: l_flag := 'true';
133: AMS_UTILITY_PVT.debug_message('Table Handler API: Update_row Flag '|| l_flag);
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: ELSE
136: commit;
137: END IF;
138:

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: BEGIN
158: DELETE FROM JTF_PERZ_QUERY_PARAM
159: WHERE query_param_id = p_query_param_id;
160: If (SQL%NOTFOUND) then
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: End If;
163: END Delete_Row ;
164:
165: