DBA Data[Home] [Help]

APPS.PAY_PAYGTN_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 1008: fnd_concurrent_requests r

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:

Line 1031: FROM fnd_concurrent_requests

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

Line 1037: FROM fnd_concurrent_requests

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;

Line 1040: printer fnd_concurrent_requests.printer%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;

Line 1041: print_style fnd_concurrent_requests.print_style%TYPE;

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;

Line 1042: number_of_copies fnd_concurrent_requests.number_of_copies%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;

Line 1043: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;

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

Line 1045: print_group fnd_concurrent_requests.print_group%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
1048:
1049: ln_req_id NUMBER;