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

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

105: action_used_by_id,
106: incl_control_group,
107: no_of_rows_targeted
108: ) VALUES (
109: DECODE( px_list_select_action_id, FND_API.g_miss_num, NULL, px_list_select_action_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

106: incl_control_group,
107: no_of_rows_targeted
108: ) VALUES (
109: DECODE( px_list_select_action_id, FND_API.g_miss_num, NULL, px_list_select_action_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

107: no_of_rows_targeted
108: ) VALUES (
109: DECODE( px_list_select_action_id, FND_API.g_miss_num, NULL, px_list_select_action_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

108: ) VALUES (
109: DECODE( px_list_select_action_id, FND_API.g_miss_num, NULL, px_list_select_action_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),

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

109: DECODE( px_list_select_action_id, FND_API.g_miss_num, NULL, px_list_select_action_id),
110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),

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

110: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),

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

111: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),

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

112: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),

Line 117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),

113: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),

Line 118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),

114: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),

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

115: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),

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

116: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),

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

117: DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),

Line 122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),

118: DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),

Line 123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),

119: DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),

Line 124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),

120: DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),

Line 125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),

121: DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),

Line 126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),

122: DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),

Line 127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),

123: DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

Line 128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),

124: DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),

Line 129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),

125: DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),
133: DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),

Line 130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),

126: DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),
133: DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),
134: DECODE( p_incl_control_group, FND_API.g_miss_char, NULL, p_incl_control_group),

Line 131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

127: DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),
133: DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),
134: DECODE( p_incl_control_group, FND_API.g_miss_char, NULL, p_incl_control_group),
135: DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, NULL, p_no_of_rows_targeted));

Line 132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),

128: DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),
133: DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),
134: DECODE( p_incl_control_group, FND_API.g_miss_char, NULL, p_incl_control_group),
135: DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, NULL, p_no_of_rows_targeted));
136: END Insert_Row;

Line 133: DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),

129: DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),
133: DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),
134: DECODE( p_incl_control_group, FND_API.g_miss_char, NULL, p_incl_control_group),
135: DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, NULL, p_no_of_rows_targeted));
136: END Insert_Row;
137:

Line 134: DECODE( p_incl_control_group, FND_API.g_miss_char, NULL, p_incl_control_group),

130: DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),
133: DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),
134: DECODE( p_incl_control_group, FND_API.g_miss_char, NULL, p_incl_control_group),
135: DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, NULL, p_no_of_rows_targeted));
136: END Insert_Row;
137:
138:

Line 135: DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, NULL, p_no_of_rows_targeted));

131: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132: DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),
133: DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),
134: DECODE( p_incl_control_group, FND_API.g_miss_char, NULL, p_incl_control_group),
135: DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, NULL, p_no_of_rows_targeted));
136: END Insert_Row;
137:
138:
139: ----------------------------------------------------------

Line 188: list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),

184: IS
185: BEGIN
186: Update AMS_LIST_SELECT_ACTIONS
187: SET
188: list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

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

185: BEGIN
186: Update AMS_LIST_SELECT_ACTIONS
187: SET
188: list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

186: Update AMS_LIST_SELECT_ACTIONS
187: SET
188: list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

187: SET
188: list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),

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

188: list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),

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

189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),

Line 194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),

Line 195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),

191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),

Line 196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),

192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),

Line 197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),

193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),

Line 198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),

194: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),

Line 199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),

195: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),

Line 200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),

196: order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),

Line 201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),

197: list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),

Line 202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),

198: incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),

Line 203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),

199: arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),

Line 204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),

200: incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),

Line 205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),

201: incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),

Line 206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),

202: incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),

Line 207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),

203: incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),

Line 208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),

204: rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),
212: action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),

Line 209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),

205: no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),
212: action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),
213: incl_control_group = DECODE( p_incl_control_group, FND_API.g_miss_char, incl_control_group, p_incl_control_group),

Line 210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),

206: no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),
212: action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),
213: incl_control_group = DECODE( p_incl_control_group, FND_API.g_miss_char, incl_control_group, p_incl_control_group),
214: no_of_rows_targeted = DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, no_of_rows_targeted, p_no_of_rows_targeted)

Line 211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),

207: no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),
212: action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),
213: incl_control_group = DECODE( p_incl_control_group, FND_API.g_miss_char, incl_control_group, p_incl_control_group),
214: no_of_rows_targeted = DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, no_of_rows_targeted, p_no_of_rows_targeted)
215: WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;

Line 212: action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),

208: distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),
212: action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),
213: incl_control_group = DECODE( p_incl_control_group, FND_API.g_miss_char, incl_control_group, p_incl_control_group),
214: no_of_rows_targeted = DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, no_of_rows_targeted, p_no_of_rows_targeted)
215: WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;
216: -- AND object_version_number = p_object_version_number;

Line 213: incl_control_group = DECODE( p_incl_control_group, FND_API.g_miss_char, incl_control_group, p_incl_control_group),

209: result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),
212: action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),
213: incl_control_group = DECODE( p_incl_control_group, FND_API.g_miss_char, incl_control_group, p_incl_control_group),
214: no_of_rows_targeted = DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, no_of_rows_targeted, p_no_of_rows_targeted)
215: WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;
216: -- AND object_version_number = p_object_version_number;
217:

Line 214: no_of_rows_targeted = DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, no_of_rows_targeted, p_no_of_rows_targeted)

210: description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211: arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),
212: action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),
213: incl_control_group = DECODE( p_incl_control_group, FND_API.g_miss_char, incl_control_group, p_incl_control_group),
214: no_of_rows_targeted = DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, no_of_rows_targeted, p_no_of_rows_targeted)
215: WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;
216: -- AND object_version_number = p_object_version_number;
217:
218: IF (SQL%NOTFOUND) THEN

Line 219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

215: WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;
216: -- AND object_version_number = p_object_version_number;
217:
218: IF (SQL%NOTFOUND) THEN
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;
221: END Update_Row;
222:
223:

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243: BEGIN
244: DELETE FROM AMS_LIST_SELECT_ACTIONS
245: WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;
246: If (SQL%NOTFOUND) then
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: End If;
249: END Delete_Row ;
250:
251:

Line 495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

491: p_arc_action_used_by => p_arc_action_used_by,
492: p_action_used_by_id => p_action_used_by_id,
493: p_incl_control_group => p_incl_control_group,
494: p_no_of_rows_targeted => p_no_of_rows_targeted);
495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: else
499: close c_chk_col_exists;

Line 496: RAISE FND_API.G_EXC_ERROR;

492: p_action_used_by_id => p_action_used_by_id,
493: p_incl_control_group => p_incl_control_group,
494: p_no_of_rows_targeted => p_no_of_rows_targeted);
495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: else
499: close c_chk_col_exists;
500: