[Home] [Help]
1068: print_warning := 'Y';
1069: end if;
1070:
1071:
1072: insert into fnd_conc_pp_actions
1073: (concurrent_request_id, action_type, status_s_flag,
1074: status_w_flag, status_f_flag, last_update_date,
1075: last_updated_by, creation_date, last_update_login,
1076: created_by, arguments, completed, number_of_copies,
1131:
1132: -- Insert Notifications
1133:
1134: for i in 1..P_NOTIFICATION_COUNT loop
1135: insert into fnd_conc_pp_actions
1136: (concurrent_request_id, action_type, status_s_flag,
1137: status_w_flag, status_f_flag, last_update_date,
1138: last_updated_by, creation_date, last_update_login,
1139: created_by, arguments, completed, number_of_copies,
1152:
1153: -- Insert layout options
1154: if (P_TEMPLATE_CODE is not null) then
1155:
1156: insert into fnd_conc_pp_actions
1157: (concurrent_request_id, action_type, status_s_flag,
1158: status_w_flag, status_f_flag, last_update_date,
1159: last_updated_by, creation_date, last_update_login,
1160: created_by, completed, sequence, argument1, argument2,
1806: p_on_error := 'Y';
1807: end if;
1808:
1809: if ( portlet_ref <> 'N' ) then
1810: pp_plsql_step := FND_CONC_PP.Assign('FND',
1811: 'FNDPRUPD',
1812: cur_request_id,
1813: p_on_success, p_on_warning, p_on_error,
1814: null, null, null, null, null,
1817: raise pp_plsql_exception;
1818: end if;
1819: end if;
1820:
1821: -- as safe side catching this exception for any fnd_conc_pp.assign
1822: -- call exception
1823: exception when others then
1824: raise pp_plsql_exception;
1825: end;
2672: empty_notify_array notification_tab_type;
2673:
2674: cursor c_users is
2675: select arguments
2676: from fnd_conc_pp_actions
2677: where concurrent_request_id = reqid
2678: and action_type = 2
2679: order by sequence;
2680: begin