[Home] [Help]
1130: print_warning := 'Y';
1131: end if;
1132:
1133: -- if number of copies is zero, no need to perform print action so don't insert
1134: -- into fnd_conc_pp_actions
1135:
1136: if curr_copies > 0 then
1137: insert into fnd_conc_pp_actions
1138: (concurrent_request_id, action_type, status_s_flag,
1133: -- if number of copies is zero, no need to perform print action so don't insert
1134: -- into fnd_conc_pp_actions
1135:
1136: if curr_copies > 0 then
1137: insert into fnd_conc_pp_actions
1138: (concurrent_request_id, action_type, status_s_flag,
1139: status_w_flag, status_f_flag, last_update_date,
1140: last_updated_by, creation_date, last_update_login,
1141: created_by, arguments, completed, number_of_copies,
1197:
1198: -- Insert Notifications
1199:
1200: for i in 1..P_NOTIFICATION_COUNT loop
1201: insert into fnd_conc_pp_actions
1202: (concurrent_request_id, action_type, status_s_flag,
1203: status_w_flag, status_f_flag, last_update_date,
1204: last_updated_by, creation_date, last_update_login,
1205: created_by, arguments, completed, number_of_copies,
1218:
1219: -- Insert layout options
1220: if (P_LAYOUT_COUNT > 0) then
1221:
1222: insert into fnd_conc_pp_actions
1223: (concurrent_request_id, action_type, status_s_flag,
1224: status_w_flag, status_f_flag, last_update_date,
1225: last_updated_by, creation_date, last_update_login,
1226: created_by, completed, sequence, argument1, argument2,
1237: -- Insert delivery options
1238: if (P_DELIV_OPTS_COUNT > 0) then
1239:
1240: for i in 1..P_DELIV_OPTS_COUNT loop
1241: insert into fnd_conc_pp_actions
1242: (concurrent_request_id, action_type,
1243: status_s_flag, status_w_flag, status_f_flag,
1244: last_update_date, last_updated_by, creation_date,
1245: last_update_login, created_by,
3231: empty_notify_array notification_tab_type;
3232:
3233: cursor c_users is
3234: select arguments
3235: from fnd_conc_pp_actions
3236: where concurrent_request_id = reqid
3237: and action_type = 2
3238: order by sequence;
3239: begin