eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_FOREIGN_WORKERS dependencies on PAY_AU_FOREIGN_WORKERS

Line 1: PACKAGE BODY pay_au_foreign_workers AS

1: PACKAGE BODY pay_au_foreign_workers AS
2: /* $Header: pyaufwrp.pkb 120.5 2010/12/06 14:08:01 avenkatk noship $*/
3:
4: /*
5: ******************************************************************

Line 25: *** Program: pay_au_foreign_workers (Package Body)

21: * *
22: ******************************************************************
23:
24: ------------------------------------------------------------------------+
25: *** Program: pay_au_foreign_workers (Package Body)
26: ***
27: ***
28: *** Change History
29: ***

Line 143: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F

139: Access : Private
140: Description : This private procedure is called to get the Assignment Status ID
141: for the given Foreign Worker Type
142: Inputs : p_fw_type - Foreign Worker Type, Valid Values are,
143: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
144: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
145:
146: Outputs : None
147: */

Line 144: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J

140: Description : This private procedure is called to get the Assignment Status ID
141: for the given Foreign Worker Type
142: Inputs : p_fw_type - Foreign Worker Type, Valid Values are,
143: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
144: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
145:
146: Outputs : None
147: */
148:

Line 173: IF (p_fw_type = pay_au_foreign_workers.g_fw_f_type)

169: END IF;
170:
171: l_status_id := -1;
172:
173: IF (p_fw_type = pay_au_foreign_workers.g_fw_f_type)
174: THEN
175: l_status_id := g_fw_asg_f_status_id;
176: ELSIF (p_fw_type = pay_au_foreign_workers.g_fw_j_type)
177: THEN

Line 176: ELSIF (p_fw_type = pay_au_foreign_workers.g_fw_j_type)

172:
173: IF (p_fw_type = pay_au_foreign_workers.g_fw_f_type)
174: THEN
175: l_status_id := g_fw_asg_f_status_id;
176: ELSIF (p_fw_type = pay_au_foreign_workers.g_fw_j_type)
177: THEN
178: l_status_id := g_fw_asg_j_status_id;
179: END IF;
180:

Line 203: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F

199: p_tax_unit_id - Legal Employer
200: p_start_date - Start Date
201: p_end_date - End Date
202: p_fw_type - Foreign Worker Type, Valid Values are,
203: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
204: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
205: */
206:
207:

Line 204: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J

200: p_start_date - Start Date
201: p_end_date - End Date
202: p_fw_type - Foreign Worker Type, Valid Values are,
203: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
204: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
205: */
206:
207:
208:

Line 338: ,pay_au_foreign_workers.g_fw_f_type);

334: (p_assignment_id
335: ,p_tax_unit_id
336: ,p_start_date
337: ,p_end_date
338: ,pay_au_foreign_workers.g_fw_f_type);
339:
340: IF NVL(l_return_value,'N') = 'N'
341: THEN
342: l_return_value := check_foreign_worker

Line 347: ,pay_au_foreign_workers.g_fw_j_type);

343: (p_assignment_id
344: ,p_tax_unit_id
345: ,p_start_date
346: ,p_end_date
347: ,pay_au_foreign_workers.g_fw_j_type);
348: END IF;
349:
350: IF g_debug
351: THEN

Line 374: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F

370: p_tax_unit_id - Legal Employer
371: p_start_date - Start Date
372: p_end_date - End Date
373: p_fw_type - Foreign Worker Type, Valid Values are,
374: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
375: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
376: Outputs : p_act_term_date - Actual Termination Date
377:
378: */

Line 375: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J

371: p_start_date - Start Date
372: p_end_date - End Date
373: p_fw_type - Foreign Worker Type, Valid Values are,
374: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
375: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
376: Outputs : p_act_term_date - Actual Termination Date
377:
378: */
379:

Line 474: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F

470: p_tax_unit_id - Legal Employer
471: p_start_date - Start Date
472: p_end_date - End Date
473: p_fw_type - Foreign Worker Type, Valid Values are,
474: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
475: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
476: Outputs : Complex Data Type - pay_au_foreign_workers.tab_fw_dates
477: contains Assignment Details
478:

Line 475: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J

471: p_start_date - Start Date
472: p_end_date - End Date
473: p_fw_type - Foreign Worker Type, Valid Values are,
474: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
475: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
476: Outputs : Complex Data Type - pay_au_foreign_workers.tab_fw_dates
477: contains Assignment Details
478:
479: */

Line 476: Outputs : Complex Data Type - pay_au_foreign_workers.tab_fw_dates

472: p_end_date - End Date
473: p_fw_type - Foreign Worker Type, Valid Values are,
474: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
475: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
476: Outputs : Complex Data Type - pay_au_foreign_workers.tab_fw_dates
477: contains Assignment Details
478:
479: */
480:

Line 486: ,p_tab_fw_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates)

482: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
483: ,p_start_date IN DATE
484: ,p_end_date IN DATE
485: ,p_fw_type IN VARCHAR2
486: ,p_tab_fw_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates)
487: AS
488:
489: CURSOR get_fw_asg_dates
490: (c_assignment_id per_assignments_f.assignment_id%TYPE

Line 673: PROCEDURE get_defined_balances(p_balances_tab IN pay_au_foreign_workers.tab_bal_type

669:
670: */
671:
672:
673: PROCEDURE get_defined_balances(p_balances_tab IN pay_au_foreign_workers.tab_bal_type
674: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
675: ,p_def_bal_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab
676: )
677: IS

Line 978: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F

974: p_tab_fw_dates - FW Assignment Details Complex Data Type
975: p_start_date - Start Date
976: p_end_date - End Date
977: p_fw_type - Foreign Worker Type, Valid Values are,
978: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
979: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
980: p_balances_tab - PL/SQL table of Balances for which prorated values should be fetched
981: Outputs : Complex Data Type - pay_balance_pkg.t_detailed_bal_out_tab
982: contains Balance Values

Line 979: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J

975: p_start_date - Start Date
976: p_end_date - End Date
977: p_fw_type - Foreign Worker Type, Valid Values are,
978: pay_au_foreign_workers.g_fw_f_type - Foreign Worker F
979: pay_au_foreign_workers.g_fw_j_type - Foreign Worker J
980: p_balances_tab - PL/SQL table of Balances for which prorated values should be fetched
981: Outputs : Complex Data Type - pay_balance_pkg.t_detailed_bal_out_tab
982: contains Balance Values
983:

Line 988: ,p_tab_fw_dates IN pay_au_foreign_workers.tab_fw_dates

984: */
985:
986: PROCEDURE get_foreign_payment_amounts(p_assignment_id IN per_assignments_f.assignment_id%TYPE
987: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
988: ,p_tab_fw_dates IN pay_au_foreign_workers.tab_fw_dates
989: ,p_start_date IN DATE
990: ,p_end_date IN DATE
991: ,p_fw_type IN VARCHAR2
992: ,p_balances_tab IN pay_au_foreign_workers.tab_bal_type

Line 992: ,p_balances_tab IN pay_au_foreign_workers.tab_bal_type

988: ,p_tab_fw_dates IN pay_au_foreign_workers.tab_fw_dates
989: ,p_start_date IN DATE
990: ,p_end_date IN DATE
991: ,p_fw_type IN VARCHAR2
992: ,p_balances_tab IN pay_au_foreign_workers.tab_bal_type
993: ,p_output_table OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab)
994: IS
995:
996: TYPE prorate_dat IS RECORD

Line 1022: ,pay_au_foreign_workers.is_le_changed(c_assignment_id,p_tax_unit_id,ptp.payroll_id,ptp.time_period_id) le_change_flag

1018: ,((ptp.end_date - ptp.start_date) + 1) denom_factor
1019: ,ptp.start_date
1020: ,ptp.end_date
1021: ,ptp.payroll_id
1022: ,pay_au_foreign_workers.is_le_changed(c_assignment_id,p_tax_unit_id,ptp.payroll_id,ptp.time_period_id) le_change_flag
1023: FROM per_assignments_f paf
1024: ,per_time_periods ptp
1025: WHERE paf.assignment_id = c_assignment_id
1026: AND c_fw_end_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 1366: (p_fw_tab_dates IN pay_au_foreign_workers.tab_fw_dates

1362:
1363: */
1364:
1365: PROCEDURE get_fw_between_dates
1366: (p_fw_tab_dates IN pay_au_foreign_workers.tab_fw_dates
1367: ,p_start_date IN DATE
1368: ,p_end_date IN DATE
1369: ,p_result_tab_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates)
1370: IS

Line 1369: ,p_result_tab_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates)

1365: PROCEDURE get_fw_between_dates
1366: (p_fw_tab_dates IN pay_au_foreign_workers.tab_fw_dates
1367: ,p_start_date IN DATE
1368: ,p_end_date IN DATE
1369: ,p_result_tab_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates)
1370: IS
1371:
1372: l_procedure VARCHAR2(100);
1373:

Line 1374: l_result_tab_dates pay_au_foreign_workers.tab_fw_dates;

1370: IS
1371:
1372: l_procedure VARCHAR2(100);
1373:
1374: l_result_tab_dates pay_au_foreign_workers.tab_fw_dates;
1375: i_index NUMBER;
1376:
1377: BEGIN
1378:

Line 1428: END pay_au_foreign_workers;

1424: p_result_tab_dates := l_result_tab_dates;
1425:
1426: END get_fw_between_dates;
1427:
1428: END pay_au_foreign_workers;