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);
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
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
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:
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(
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(
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(
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(
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(
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(
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(
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(
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(
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',
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(
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',
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(
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',
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:
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:
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:
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;
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;