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_LIST_QUERIES_PKG dependencies on FND_API

Line 69: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

65:
66:
67: BEGIN
68:
69: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
70: SELECT NVL(rtrim(ltrim(SUBSTRB(USERENV('CLIENT_INFO'),1,10))),
71: '')
72: INTO px_org_id
73: FROM DUAL;

Line 103: DECODE( px_list_query_id, FND_API.g_miss_num, NULL, px_list_query_id),

99: query,
100: parent_list_query_id ,
101: sequence_order
102: ) VALUES (
103: DECODE( px_list_query_id, FND_API.g_miss_num, NULL, px_list_query_id),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

100: parent_list_query_id ,
101: sequence_order
102: ) VALUES (
103: DECODE( px_list_query_id, FND_API.g_miss_num, NULL, px_list_query_id),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

101: sequence_order
102: ) VALUES (
103: DECODE( px_list_query_id, FND_API.g_miss_num, NULL, px_list_query_id),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

102: ) VALUES (
103: DECODE( px_list_query_id, FND_API.g_miss_num, NULL, px_list_query_id),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),

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

103: DECODE( px_list_query_id, FND_API.g_miss_num, NULL, px_list_query_id),
104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),

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

104: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),
112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),

Line 109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

105: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),
112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),
113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),

Line 110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),

106: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),
112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),
113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),
114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),

Line 111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),

107: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),
112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),
113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),
114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),

Line 112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),

108: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),
112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),
113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),
114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),
116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),

Line 113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),

109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),
112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),
113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),
114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),
116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),

Line 114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),

110: null,--DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),
112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),
113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),
114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),
116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),

Line 115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),

111: DECODE( p_type, FND_API.g_miss_char, NULL, p_type),
112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),
113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),
114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),
116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),
119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),

Line 116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),

112: DECODE( p_enabled_flag, FND_API.g_miss_char, 'Y', p_enabled_flag),
113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),
114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),
116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),
119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),
120: DECODE( p_sql_string, FND_API.g_miss_char, NULL, p_sql_string),

Line 117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),

113: DECODE( p_primary_key, FND_API.g_miss_char, NULL, p_primary_key),
114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),
116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),
119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),
120: DECODE( p_sql_string, FND_API.g_miss_char, NULL, p_sql_string),
121: DECODE( p_parent_list_query_id, FND_API.g_miss_num, NULL, p_parent_list_query_id),

Line 118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),

114: DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),
116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),
119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),
120: DECODE( p_sql_string, FND_API.g_miss_char, NULL, p_sql_string),
121: DECODE( p_parent_list_query_id, FND_API.g_miss_num, NULL, p_parent_list_query_id),
122: DECODE( p_sequence_order, FND_API.g_miss_num, NULL, p_sequence_order));

Line 119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),

115: DECODE( p_public_flag, FND_API.g_miss_char,'N' , p_public_flag),
116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),
119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),
120: DECODE( p_sql_string, FND_API.g_miss_char, NULL, p_sql_string),
121: DECODE( p_parent_list_query_id, FND_API.g_miss_num, NULL, p_parent_list_query_id),
122: DECODE( p_sequence_order, FND_API.g_miss_num, NULL, p_sequence_order));
123:

Line 120: DECODE( p_sql_string, FND_API.g_miss_char, NULL, p_sql_string),

116: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),
119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),
120: DECODE( p_sql_string, FND_API.g_miss_char, NULL, p_sql_string),
121: DECODE( p_parent_list_query_id, FND_API.g_miss_num, NULL, p_parent_list_query_id),
122: DECODE( p_sequence_order, FND_API.g_miss_num, NULL, p_sequence_order));
123:
124:

Line 121: DECODE( p_parent_list_query_id, FND_API.g_miss_num, NULL, p_parent_list_query_id),

117: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),
119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),
120: DECODE( p_sql_string, FND_API.g_miss_char, NULL, p_sql_string),
121: DECODE( p_parent_list_query_id, FND_API.g_miss_num, NULL, p_parent_list_query_id),
122: DECODE( p_sequence_order, FND_API.g_miss_num, NULL, p_sequence_order));
123:
124:
125: insert into AMS_LIST_QUERIES_TL (

Line 122: DECODE( p_sequence_order, FND_API.g_miss_num, NULL, p_sequence_order));

118: DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, NULL, p_act_list_query_used_by_id),
119: DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_query_used_by),
120: DECODE( p_sql_string, FND_API.g_miss_char, NULL, p_sql_string),
121: DECODE( p_parent_list_query_id, FND_API.g_miss_num, NULL, p_parent_list_query_id),
122: DECODE( p_sequence_order, FND_API.g_miss_num, NULL, p_sequence_order));
123:
124:
125: insert into AMS_LIST_QUERIES_TL (
126: LANGUAGE,

Line 139: decode(p_name ,FND_API.g_miss_char,null,p_name) ,

135: LAST_UPDATE_LOGIN
136: ) select
137: l.language_code,
138: userenv('LANG'),
139: decode(p_name ,FND_API.g_miss_char,null,p_name) ,
140: decode(p_comments ,FND_API.g_miss_char,null,p_comments) ,
141: decode(px_list_query_id ,FND_API.g_miss_num,null,px_list_query_id) ,
142: sysdate,
143: FND_GLOBAL.user_id,

Line 140: decode(p_comments ,FND_API.g_miss_char,null,p_comments) ,

136: ) select
137: l.language_code,
138: userenv('LANG'),
139: decode(p_name ,FND_API.g_miss_char,null,p_name) ,
140: decode(p_comments ,FND_API.g_miss_char,null,p_comments) ,
141: decode(px_list_query_id ,FND_API.g_miss_num,null,px_list_query_id) ,
142: sysdate,
143: FND_GLOBAL.user_id,
144: sysdate,

Line 141: decode(px_list_query_id ,FND_API.g_miss_num,null,px_list_query_id) ,

137: l.language_code,
138: userenv('LANG'),
139: decode(p_name ,FND_API.g_miss_char,null,p_name) ,
140: decode(p_comments ,FND_API.g_miss_char,null,p_comments) ,
141: decode(px_list_query_id ,FND_API.g_miss_num,null,px_list_query_id) ,
142: sysdate,
143: FND_GLOBAL.user_id,
144: sysdate,
145: FND_GLOBAL.user_id,

Line 199: list_query_id = DECODE( p_list_query_id, FND_API.g_miss_num, list_query_id, p_list_query_id),

195: IS
196: BEGIN
197: Update AMS_LIST_QUERIES_ALL
198: SET
199: list_query_id = DECODE( p_list_query_id, FND_API.g_miss_num, list_query_id, p_list_query_id),
200: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

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

196: BEGIN
197: Update AMS_LIST_QUERIES_ALL
198: SET
199: list_query_id = DECODE( p_list_query_id, FND_API.g_miss_num, list_query_id, p_list_query_id),
200: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

197: Update AMS_LIST_QUERIES_ALL
198: SET
199: list_query_id = DECODE( p_list_query_id, FND_API.g_miss_num, list_query_id, p_list_query_id),
200: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),

Line 202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

198: SET
199: list_query_id = DECODE( p_list_query_id, FND_API.g_miss_num, list_query_id, p_list_query_id),
200: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),

Line 203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

199: list_query_id = DECODE( p_list_query_id, FND_API.g_miss_num, list_query_id, p_list_query_id),
200: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),

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

200: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),
208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

Line 205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),

201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),
208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),

Line 206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),

202: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),
208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),
210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),

Line 207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),

203: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),
208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),
210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),

Line 208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),
208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),
210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),
212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),

Line 209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),

205: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),
208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),
210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),
212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),

Line 210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),

206: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),
208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),
210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),
212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),

Line 211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),

207: type = DECODE( p_type, FND_API.g_miss_char, type, p_type),
208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),
210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),
212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),
215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),

Line 212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),

208: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),
210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),
212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),
215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),
216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),

Line 213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),

209: primary_key = DECODE( p_primary_key, FND_API.g_miss_char, primary_key, p_primary_key),
210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),
212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),
215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),
216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
217: query = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),

Line 214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),

210: source_object_name = DECODE( p_source_object_name, FND_API.g_miss_char, NULL, p_source_object_name),
211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),
212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),
215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),
216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
217: query = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
218: parent_list_query_id = decode(p_parent_list_query_id, FND_API.g_miss_num, parent_list_query_id, p_parent_list_query_id),

Line 215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),

211: public_flag = DECODE( p_public_flag, FND_API.g_miss_char, public_flag, p_public_flag),
212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),
215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),
216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
217: query = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
218: parent_list_query_id = decode(p_parent_list_query_id, FND_API.g_miss_num, parent_list_query_id, p_parent_list_query_id),
219: sequence_order = decode(p_sequence_order, FND_API.g_miss_num, sequence_order, p_sequence_order)

Line 216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),

212: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),
215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),
216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
217: query = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
218: parent_list_query_id = decode(p_parent_list_query_id, FND_API.g_miss_num, parent_list_query_id, p_parent_list_query_id),
219: sequence_order = decode(p_sequence_order, FND_API.g_miss_num, sequence_order, p_sequence_order)
220: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID

Line 217: query = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),

213: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),
215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),
216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
217: query = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
218: parent_list_query_id = decode(p_parent_list_query_id, FND_API.g_miss_num, parent_list_query_id, p_parent_list_query_id),
219: sequence_order = decode(p_sequence_order, FND_API.g_miss_num, sequence_order, p_sequence_order)
220: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID
221: AND object_version_number = p_object_version_number;

Line 218: parent_list_query_id = decode(p_parent_list_query_id, FND_API.g_miss_num, parent_list_query_id, p_parent_list_query_id),

214: act_list_query_used_by_id = DECODE( p_act_list_query_used_by_id, FND_API.g_miss_num, act_list_query_used_by_id, p_act_list_query_used_by_id),
215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),
216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
217: query = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
218: parent_list_query_id = decode(p_parent_list_query_id, FND_API.g_miss_num, parent_list_query_id, p_parent_list_query_id),
219: sequence_order = decode(p_sequence_order, FND_API.g_miss_num, sequence_order, p_sequence_order)
220: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID
221: AND object_version_number = p_object_version_number;
222:

Line 219: sequence_order = decode(p_sequence_order, FND_API.g_miss_num, sequence_order, p_sequence_order)

215: arc_act_list_query_used_by = DECODE( p_arc_act_list_query_used_by, FND_API.g_miss_char, arc_act_list_query_used_by, p_arc_act_list_query_used_by),
216: -- sql_string = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
217: query = DECODE( p_sql_string, FND_API.g_miss_char,sql_string, p_sql_string),
218: parent_list_query_id = decode(p_parent_list_query_id, FND_API.g_miss_num, parent_list_query_id, p_parent_list_query_id),
219: sequence_order = decode(p_sequence_order, FND_API.g_miss_num, sequence_order, p_sequence_order)
220: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID
221: AND object_version_number = p_object_version_number;
222:
223: IF (SQL%NOTFOUND) THEN

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID
221: AND object_version_number = p_object_version_number;
222:
223: IF (SQL%NOTFOUND) THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226: END Update_Row;
227:
228:

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

248: BEGIN
249: DELETE FROM AMS_LIST_QUERIES_ALL
250: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID;
251: If (SQL%NOTFOUND) then
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: End If;
254: END Delete_Row ;
255:
256:

Line 393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

389: p_arc_act_list_query_used_by => p_arc_act_list_query_used_by ,
390: p_sql_string => p_sql_string ,
391: p_parent_list_query_id => l_list_query_id,
392: p_sequence_order => 1);
393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396: else
397: close c_chk_col_exists;

Line 394: RAISE FND_API.G_EXC_ERROR;

390: p_sql_string => p_sql_string ,
391: p_parent_list_query_id => l_list_query_id,
392: p_sequence_order => 1);
393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396: else
397: close c_chk_col_exists;
398: