1004: CURSOR get_application_detais(c_request_id NUMBER) IS
1005: SELECT app.application_short_name, fcp.application_id
1006: FROM fnd_application_vl app,
1007: fnd_concurrent_programs fcp,
1008: fnd_concurrent_requests r
1009: WHERE fcp.concurrent_program_id = r.concurrent_program_id
1010: AND r.request_id = c_request_id
1011: and app.application_id = fcp.application_id;
1012:
1027: -- bug 6799553
1028: -- Get printer details
1029: /*CURSOR get_printer_details(request_id NUMBER) IS
1030: SELECT printer, print_style, number_of_copies, save_output_flag, print_group
1031: FROM fnd_concurrent_requests
1032: WHERE request_id = request_id ;*/
1033: -- bug 7297300
1034: /* Changing the Parameter Name from request_id to c_request_id */
1035: CURSOR get_printer_details(c_request_id NUMBER) IS
1033: -- bug 7297300
1034: /* Changing the Parameter Name from request_id to c_request_id */
1035: CURSOR get_printer_details(c_request_id NUMBER) IS
1036: SELECT printer, print_style, number_of_copies, save_output_flag, print_group
1037: FROM fnd_concurrent_requests
1038: WHERE request_id = c_request_id ;
1039:
1040: printer fnd_concurrent_requests.printer%TYPE;
1041: print_style fnd_concurrent_requests.print_style%TYPE;
1036: SELECT printer, print_style, number_of_copies, save_output_flag, print_group
1037: FROM fnd_concurrent_requests
1038: WHERE request_id = c_request_id ;
1039:
1040: printer fnd_concurrent_requests.printer%TYPE;
1041: print_style fnd_concurrent_requests.print_style%TYPE;
1042: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1043: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1044: save_output BOOLEAN;
1037: FROM fnd_concurrent_requests
1038: WHERE request_id = c_request_id ;
1039:
1040: printer fnd_concurrent_requests.printer%TYPE;
1041: print_style fnd_concurrent_requests.print_style%TYPE;
1042: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1043: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1044: save_output BOOLEAN;
1045: print_group fnd_concurrent_requests.print_group%TYPE;
1038: WHERE request_id = c_request_id ;
1039:
1040: printer fnd_concurrent_requests.printer%TYPE;
1041: print_style fnd_concurrent_requests.print_style%TYPE;
1042: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1043: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1044: save_output BOOLEAN;
1045: print_group fnd_concurrent_requests.print_group%TYPE;
1046: result BOOLEAN;
1039:
1040: printer fnd_concurrent_requests.printer%TYPE;
1041: print_style fnd_concurrent_requests.print_style%TYPE;
1042: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1043: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1044: save_output BOOLEAN;
1045: print_group fnd_concurrent_requests.print_group%TYPE;
1046: result BOOLEAN;
1047: -- bug 6799553
1041: print_style fnd_concurrent_requests.print_style%TYPE;
1042: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1043: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1044: save_output BOOLEAN;
1045: print_group fnd_concurrent_requests.print_group%TYPE;
1046: result BOOLEAN;
1047: -- bug 6799553
1048:
1049: ln_req_id NUMBER;