[Home] [Help]
498: -- Submit_Program
499: -- Purpose
500: -- It inserts rows into FND_RUN_REQUESTS table for program specified.
501: -- The program should exists in Request Set. It also inserts rows into
502: -- FND_RUN_REQ_PP_ACTIONS table based on the options set before calling
503: -- this function.
504: -- Call set_request_set function before calling this function to set the
505: -- context for the report set submission. Call this function for each
506: -- program in the report set.
948:
949: -- insert the action
950: -- (don't print on warning or failure)
951:
952: insert into fnd_run_req_pp_actions
953: (parent_request_id, request_set_program_id,
954: set_application_id, request_set_id,
955: action_type, status_s_flag,
956: status_w_flag, status_f_flag,
1005:
1006: -- Insert Notifications
1007: -- 12.1 Project Changes: Added orig_system and orig_system_id
1008: for i in 1..P_NOTIFICATION_COUNT loop
1009: insert into fnd_run_req_pp_actions
1010: (parent_request_id, request_set_program_id,
1011: set_application_id, request_set_id,
1012: action_type, status_s_flag,
1013: status_w_flag, status_f_flag,
1025:
1026:
1027: -- Insert layout options
1028: if P_TEMPLATE_CODE is not null then
1029: insert into fnd_run_req_pp_actions
1030: (parent_request_id, request_set_program_id,
1031: set_application_id, request_set_id,
1032: action_type, status_s_flag,
1033: status_w_flag, status_f_flag,
1045:
1046: -- Insert delivery options
1047: if (P_DELIV_OPTS_COUNT > 0) then
1048: for i in 1..P_DELIV_OPTS_COUNT loop
1049: insert into fnd_run_req_pp_actions
1050: (parent_request_id,
1051: request_set_id,set_application_id,request_set_program_id,
1052: action_type,status_s_flag,status_w_flag,status_f_flag,
1053: program_application_id,program_id,sequence,