DBA Data[Home] [Help]

APPS.PAY_PAYGTN_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 999: fnd_concurrent_requests r

995: CURSOR get_application_detais(c_request_id NUMBER) IS
996: SELECT app.application_short_name, fcp.application_id
997: FROM fnd_application_vl app,
998: fnd_concurrent_programs fcp,
999: fnd_concurrent_requests r
1000: WHERE fcp.concurrent_program_id = r.concurrent_program_id
1001: AND r.request_id = c_request_id
1002: and app.application_id = fcp.application_id;
1003:

Line 1022: FROM fnd_concurrent_requests

1018: -- bug 6799553
1019: -- Get printer details
1020: /*CURSOR get_printer_details(request_id NUMBER) IS
1021: SELECT printer, print_style, number_of_copies, save_output_flag, print_group
1022: FROM fnd_concurrent_requests
1023: WHERE request_id = request_id ;*/
1024: -- bug 7297300
1025: /* Changing the Parameter Name from request_id to c_request_id */
1026: CURSOR get_printer_details(c_request_id NUMBER) IS

Line 1028: FROM fnd_concurrent_requests

1024: -- bug 7297300
1025: /* Changing the Parameter Name from request_id to c_request_id */
1026: CURSOR get_printer_details(c_request_id NUMBER) IS
1027: SELECT printer, print_style, number_of_copies, save_output_flag, print_group
1028: FROM fnd_concurrent_requests
1029: WHERE request_id = c_request_id ;
1030:
1031: printer fnd_concurrent_requests.printer%TYPE;
1032: print_style fnd_concurrent_requests.print_style%TYPE;

Line 1031: printer fnd_concurrent_requests.printer%TYPE;

1027: SELECT printer, print_style, number_of_copies, save_output_flag, print_group
1028: FROM fnd_concurrent_requests
1029: WHERE request_id = c_request_id ;
1030:
1031: printer fnd_concurrent_requests.printer%TYPE;
1032: print_style fnd_concurrent_requests.print_style%TYPE;
1033: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1034: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1035: save_output BOOLEAN;

Line 1032: print_style fnd_concurrent_requests.print_style%TYPE;

1028: FROM fnd_concurrent_requests
1029: WHERE request_id = c_request_id ;
1030:
1031: printer fnd_concurrent_requests.printer%TYPE;
1032: print_style fnd_concurrent_requests.print_style%TYPE;
1033: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1034: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1035: save_output BOOLEAN;
1036: print_group fnd_concurrent_requests.print_group%TYPE;

Line 1033: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;

1029: WHERE request_id = c_request_id ;
1030:
1031: printer fnd_concurrent_requests.printer%TYPE;
1032: print_style fnd_concurrent_requests.print_style%TYPE;
1033: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1034: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1035: save_output BOOLEAN;
1036: print_group fnd_concurrent_requests.print_group%TYPE;
1037: result BOOLEAN;

Line 1034: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;

1030:
1031: printer fnd_concurrent_requests.printer%TYPE;
1032: print_style fnd_concurrent_requests.print_style%TYPE;
1033: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1034: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1035: save_output BOOLEAN;
1036: print_group fnd_concurrent_requests.print_group%TYPE;
1037: result BOOLEAN;
1038: -- bug 6799553

Line 1036: print_group fnd_concurrent_requests.print_group%TYPE;

1032: print_style fnd_concurrent_requests.print_style%TYPE;
1033: number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
1034: save_output_flag fnd_concurrent_requests.save_output_flag%TYPE;
1035: save_output BOOLEAN;
1036: print_group fnd_concurrent_requests.print_group%TYPE;
1037: result BOOLEAN;
1038: -- bug 6799553
1039:
1040: ln_req_id NUMBER;