APPS.PAY_ZA_UPDATE_PKG dependencies on PAY_ZA_TYS_PROCESSES

Line 21: pay_za_tys_processes

17:
18: SELECT
19: COUNT(tysp_id) INTO l_result
20: FROM
21: pay_za_tys_processes
22: WHERE
23: payroll_id = p_payroll
24: AND tax_year = p_tax_year;
25:

Line 270: /* This procedure updates the PAY_ZA_TYS_PROCESSES table to ensure that

266: );
267:
268: END update_this_record;
269:
270: /* This procedure updates the PAY_ZA_TYS_PROCESSES table to ensure that
271: the process will not be run for the same payroll and the same tax year.*/
272:
273: PROCEDURE update_tysp_table
274: (

Line 280: INSERT INTO pay_za_tys_processes (

276: p_tax_year NUMBER
277: )
278: AS
279: BEGIN
280: INSERT INTO pay_za_tys_processes (
281: TYSP_ID
282: , PAYROLL_ID
283: , CONSOLIDATION_SET_ID
284: , TAX_YEAR

Line 288: pay_za_tys_processes_s.NEXTVAL,

284: , TAX_YEAR
285: )
286: VALUES
287: (
288: pay_za_tys_processes_s.NEXTVAL,
289: p_payroll,
290: 0,
291: p_tax_year
292: );

Line 296: /* This procedure deletes the PAY_ZA_TYS_PROCESSES table to indicate that the

292: );
293:
294: END update_tysp_table;
295:
296: /* This procedure deletes the PAY_ZA_TYS_PROCESSES table to indicate that the
297: TYSP process was rolled back for this specific payroll. In other words if
298: the user wants to run the process for this payroll, he will be allowed to. */
299:
300: PROCEDURE delete_tysp_table

Line 308: DELETE FROM pay_za_tys_processes

304: )
305: AS
306: BEGIN
307:
308: DELETE FROM pay_za_tys_processes
309: WHERE payroll_id = p_payroll
310: AND tax_year = p_tax_year;
311:
312: END delete_tysp_table;

Line 329: pay_za_tys_processes

325: BEGIN
326: SELECT
327: COUNT(tysp_id) INTO l_result
328: FROM
329: pay_za_tys_processes
330: WHERE
331: payroll_id = p_payroll
332: AND tax_year = p_tax_year;
333: