DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 4054: l_number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;

4050: l_dummy NUMBER;
4051: l_print_style VARCHAR2(2);
4052: l_report_short_name VARCHAR2(20);
4053: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
4054: l_number_of_copies fnd_concurrent_requests.number_of_copies%TYPE;
4055: l_request_id NUMBER:=-1;
4056: l_formula_id ff_formulas_f.formula_id%TYPE;
4057: --
4058: l_print_together VARCHAR2(80);

Line 4063: l_printer_style fnd_concurrent_requests.print_style%TYPE; --Bug 9170440

4059: l_print_return BOOLEAN;
4060: l_stationary VARCHAR2(2); /*P45 A4 2008-09 changes */
4061: l_defer_print VARCHAR2(1);
4062: xml_layout BOOLEAN ; /*P45 A4 2008-09 changes */
4063: l_printer_style fnd_concurrent_requests.print_style%TYPE; --Bug 9170440
4064:
4065: --
4066: cursor csr_get_formula_id(p_formula_name VARCHAR2) IS
4067: SELECT a.formula_id

Line 4081: fnd_concurrent_requests fcr

4077: SELECT printer,
4078: print_style,
4079: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
4080: FROM pay_payroll_actions pact,
4081: fnd_concurrent_requests fcr
4082: WHERE fcr.request_id = pact.request_id
4083: AND pact.payroll_action_id = p_payroll_action_id;
4084: --
4085: cursor get_errored_actions(c_payroll_action_id number) is