DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PAY_GB_P11D_ARCHIVE_SS

Line 388: if ((l_present_val = p_variable_value) and (PAY_GB_P11D_ARCHIVE_SS.g_updated_flag = 'Y'))

384: hr_utility.TRACE('l_new_val '|| l_new_val);
385: else
386: --Added the below logic for the bug fix 8864717.
387: --
388: if ((l_present_val = p_variable_value) and (PAY_GB_P11D_ARCHIVE_SS.g_updated_flag = 'Y'))
389: then
390: l_new_val := l_present_val ;
391: else
392: l_new_val := l_present_val + nvl(to_number(p_variable_value), 0);

Line 734: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,

730: into l_pactid
731: from pay_assignment_actions
732: where assignment_action_id = p_assignment_action_id;
733:
734: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,
735: p_token_name => 'Rep_Run',
736: p_token_value => l_rep_run);
737:
738: if to_number(l_rep_run) < 2005

Line 1268: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,

1264: into l_pactid
1265: from pay_assignment_actions
1266: where assignment_action_id = p_assignment_action_id;
1267:
1268: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,
1269: p_token_name => 'Rep_Run',
1270: p_token_value => l_rep_run);
1271:
1272: if to_number(l_rep_run) < 2005

Line 2090: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2086: fetch get_pactid into l_pactid;
2087: hr_utility.trace('l_pactid: '||l_pactid);
2088: close get_pactid ;
2089:
2090: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2091: p_payroll_action_id => l_pactid,
2092: p_token_name => 'Rep_Run',
2093: p_token_value => l_rep_run);
2094:

Line 2340: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2336: exception
2337: when Others then
2338: l_effective_date := sysdate;
2339: end;
2340: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2341: p_payroll_action_id => p_payroll_action_id,
2342: p_token_name => 'PAYROLL',
2343: p_token_value => l_payroll_id);
2344: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2344: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2340: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2341: p_payroll_action_id => p_payroll_action_id,
2342: p_token_name => 'PAYROLL',
2343: p_token_value => l_payroll_id);
2344: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2345: p_payroll_action_id => p_payroll_action_id,
2346: p_token_name => 'PERSON',
2347: p_token_value => l_person_id);
2348: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2348: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2344: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2345: p_payroll_action_id => p_payroll_action_id,
2346: p_token_name => 'PERSON',
2347: p_token_value => l_person_id);
2348: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2349: p_payroll_action_id => p_payroll_action_id,
2350: p_token_name => 'CONSOLIDATION_SET',
2351: p_token_value => l_consolidation_set_id);
2352: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2352: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2348: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2349: p_payroll_action_id => p_payroll_action_id,
2350: p_token_name => 'CONSOLIDATION_SET',
2351: p_token_value => l_consolidation_set_id);
2352: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2353: p_payroll_action_id => p_payroll_action_id,
2354: p_token_name => 'TAX_REFERENCE',
2355: p_token_value => l_tax_reference);
2356: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2356: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2352: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2353: p_payroll_action_id => p_payroll_action_id,
2354: p_token_name => 'TAX_REFERENCE',
2355: p_token_value => l_tax_reference);
2356: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2357: p_payroll_action_id => p_payroll_action_id,
2358: p_token_name => 'ASSIGNMENT_SET_ID',
2359: p_token_value => l_assignment_set_id);
2360: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2360: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2356: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2357: p_payroll_action_id => p_payroll_action_id,
2358: p_token_name => 'ASSIGNMENT_SET_ID',
2359: p_token_value => l_assignment_set_id);
2360: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2361: p_payroll_action_id => p_payroll_action_id,
2362: p_token_name => 'BENEFIT_START_DATE',
2363: p_token_value => l_benefit_start_date);
2364: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2364: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2360: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2361: p_payroll_action_id => p_payroll_action_id,
2362: p_token_name => 'BENEFIT_START_DATE',
2363: p_token_value => l_benefit_start_date);
2364: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2365: p_payroll_action_id => p_payroll_action_id,
2366: p_token_name => 'BENEFIT_END_DATE',
2367: p_token_value => l_benefit_end_date);
2368: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2368: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2364: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2365: p_payroll_action_id => p_payroll_action_id,
2366: p_token_name => 'BENEFIT_END_DATE',
2367: p_token_value => l_benefit_end_date);
2368: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2369: p_payroll_action_id => p_payroll_action_id,
2370: p_token_name => 'Rep_Run',
2371: p_token_value => l_rep_run);
2372: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2372: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2368: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2369: p_payroll_action_id => p_payroll_action_id,
2370: p_token_name => 'Rep_Run',
2371: p_token_value => l_rep_run);
2372: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2373: p_payroll_action_id => p_payroll_action_id,
2374: p_token_name => 'Status',
2375: p_token_value => l_status_code);
2376: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2376: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2372: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2373: p_payroll_action_id => p_payroll_action_id,
2374: p_token_name => 'Status',
2375: p_token_value => l_status_code);
2376: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2377: p_payroll_action_id => p_payroll_action_id,
2378: p_token_name => 'Run_Type',
2379: p_token_value => l_run_type_code);
2380: l_run_type_meaning := get_lookup_meaning('GB_P11D_RUN_TYPE',

Line 2446: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2442: l_benefit_start_date VARCHAR2(20);
2443: l_status_code varchar2(10);
2444: l_status_meaning varchar2(20);
2445: begin
2446: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2447: p_payroll_action_id => p_payroll_action_id,
2448: p_token_name => 'BENEFIT_END_DATE',
2449: p_token_value => l_benefit_end_date);
2450: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2450: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2446: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2447: p_payroll_action_id => p_payroll_action_id,
2448: p_token_name => 'BENEFIT_END_DATE',
2449: p_token_value => l_benefit_end_date);
2450: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2451: p_payroll_action_id => p_payroll_action_id,
2452: p_token_name => 'Status',
2453: p_token_value => l_status_code);
2454: l_status_meaning := get_lookup_meaning('GB_P11D_LEGISLATIVE_RUN_STATUS',

Line 2466: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2462: l_benefit_end_date VARCHAR2(20);
2463: l_run_type_code varchar2(10);
2464: l_run_type_meaning varchar2(20);
2465: begin
2466: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2467: p_payroll_action_id => p_payroll_action_id,
2468: p_token_name => 'BENEFIT_END_DATE',
2469: p_token_value => l_benefit_end_date);
2470: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

Line 2470: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

2466: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2467: p_payroll_action_id => p_payroll_action_id,
2468: p_token_name => 'BENEFIT_END_DATE',
2469: p_token_value => l_benefit_end_date);
2470: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2471: p_payroll_action_id => p_payroll_action_id,
2472: p_token_name => 'Run_Type',
2473: p_token_value => l_run_type_code);
2474: l_run_type_meaning := get_lookup_meaning('GB_P11D_RUN_TYPE',

Line 3274: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

3270: l_fore_name);
3271: -- P11D 08/09
3272: l_pactid := get_pactid(p_assignment_action_id);
3273: l_person_id := get_person_id (p_assignment_action_id );
3274: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
3275: p_payroll_action_id => l_pactid,
3276: p_token_name => 'Rep_Run',
3277: p_token_value => l_rep_run);
3278:

Line 4336: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

4332: l_pactid := get_pactid(p_assignment_action_id);
4333: l_person_id := get_person_id (p_assignment_action_id );
4334: l_loop_count := 0;
4335:
4336: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
4337: p_payroll_action_id => l_pactid,
4338: p_token_name => 'Rep_Run',
4339: p_token_value => l_rep_run);
4340:

Line 4779: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

4775: l_fore_name);
4776: -- P11D 08/09
4777: l_pactid := get_pactid(p_assignment_action_id);
4778: l_person_id := get_person_id (p_assignment_action_id );
4779: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
4780: p_payroll_action_id => l_pactid,
4781: p_token_name => 'Rep_Run',
4782: p_token_value => l_rep_run);
4783:

Line 5937: PAY_GB_P11D_ARCHIVE_SS.get_parameters(

5933: dbms_lob.createtemporary(l_xfdf_str,false,DBMS_LOB.CALL);
5934: dbms_lob.open(l_xfdf_str,dbms_lob.lob_readwrite);
5935:
5936:
5937: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
5938: p_payroll_action_id => l_pactid,
5939: p_token_name => 'Rep_Run',
5940: p_token_value => l_rep_run);
5941: l_loop_count := 0;

Line 6578: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => p_arch_payroll_action_id,

6574: l_rep_run varchar2(10);
6575:
6576: BEGIN
6577:
6578: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => p_arch_payroll_action_id,
6579: p_token_name => 'Rep_Run',
6580: p_token_value => l_rep_run);
6581:
6582: OPEN get_assignment_action_id;