[Home] [Help]
418: p_context_value2 IN VARCHAR2 DEFAULT NULL,
419: p_context_value3 IN VARCHAR2 DEFAULT NULL)
420: RETURN VARCHAR2
421: -- Pure Public Function which returns a value from the archive, given
422: -- the action id (ff_archive_items.context1), user entity id and up to
423: -- three additional contexts. No validation is performed on the input
424: -- parameters. If a matching item does not exist, null is returned.
425: -- The additional context parameters must be populated in order.
426: IS
423: -- three additional contexts. No validation is performed on the input
424: -- parameters. If a matching item does not exist, null is returned.
425: -- The additional context parameters must be populated in order.
426: IS
427: l_arch_value ff_archive_items.value%type;
428: BEGIN
429: -- use implicit cursors so that too_many_rows can easily be detected
430: IF p_context_value3 IS NOT NULL THEN
431: SELECT fai.VALUE
432: INTO l_arch_value
433: FROM ff_archive_item_contexts aic1,
434: ff_archive_item_contexts aic2,
435: ff_archive_item_contexts aic3,
436: ff_archive_items fai
437: WHERE fai.context1 = p_action_id
438: AND fai.user_entity_id = p_user_entity_id
439: AND aic1.archive_item_id = fai.archive_item_id
440: AND aic1.sequence_no = 1
447: AND aic3.context = p_context_value3;
448: ELSIF p_context_value2 IS NOT NULL THEN
449: SELECT fai.VALUE
450: INTO l_arch_value
451: FROM ff_archive_items fai,
452: ff_archive_item_contexts aic1,
453: ff_archive_item_contexts aic2
454: WHERE fai.context1 = p_action_id
455: AND fai.user_entity_id = p_user_entity_id
462: ELSIF p_context_value1 IS NOT NULL THEN
463: SELECT fai.VALUE
464: INTO l_arch_value
465: FROM ff_archive_item_contexts aic1,
466: ff_archive_items fai
467: WHERE fai.context1 = p_action_id
468: AND fai.user_entity_id = p_user_entity_id
469: AND aic1.archive_item_id = fai.archive_item_id
470: AND aic1.sequence_no = 1
471: AND aic1.context = p_context_value1;
472: ELSE
473: SELECT fai.VALUE
474: INTO l_arch_value
475: FROM ff_archive_items fai
476: WHERE fai.context1 = p_action_id
477: AND fai.user_entity_id = p_user_entity_id;
478: END IF;
479: RETURN l_arch_value;
488: p_context_value2 IN VARCHAR2 DEFAULT NULL,
489: p_context_value3 IN VARCHAR2 DEFAULT NULL)
490: RETURN VARCHAR2
491: -- Overloaded Pure Public Function which returns a value from the archive,
492: -- given the action id (ff_archive_items.context1), user entity name and up to
493: -- two additional contexts. No validation is performed on the input
494: -- parameters. If a matching item does not exist, null is returned.
495: -- The additional context parameters must be populated in order.
496: IS
494: -- parameters. If a matching item does not exist, null is returned.
495: -- The additional context parameters must be populated in order.
496: IS
497: l_user_entity_id ff_user_entities.user_entity_id%type;
498: l_arch_value ff_archive_items.value%type;
499: BEGIN
500: SELECT fue.user_entity_id
501: INTO l_user_entity_id
502: FROM ff_user_entities fue
611: l_archive_value VARCHAR2(30);
612: cursor get_payroll_id(c_payroll_action_id number,
613: c_user_entity_id number) is
614: select to_number(faic.context) payroll_id
615: from ff_archive_items fai,
616: ff_archive_item_contexts faic
617: where fai.context1 = c_payroll_action_id
618: and fai.user_entity_id = c_user_entity_id
619: and fai.archive_item_id = faic.archive_item_id
1223: l_tax_reference_number VARCHAR2(10); -- 4011263: length 10 chars
1224: l_test_indicator varchar2(1); -- 5909829 EOY to store test indicator value
1225: l_unique_test_id varchar2(50); -- 5909829 EOY to store unique test id value
1226: -- vars for returns from the API:
1227: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1228: l_ovn NUMBER;
1229: l_some_warning BOOLEAN;
1230: -- vars for holding payroll data:
1231: l_payroll_start_year DATE;
1700: l_proc CONSTANT VARCHAR2(35):= g_package||'action_creation';
1701: --
1702: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1703: -- vars for returns from the API:
1704: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1705: l_ovn NUMBER;
1706: l_some_warning BOOLEAN;
1707: --
1708: l_start_year_date DATE;
2266: aic.context) tax_ref,
2267: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2268: aic.context) tax_dist
2269: FROM ff_archive_item_contexts aic, /* payrolls */
2270: ff_archive_items fai, /* X_START_YEAR */
2271: ff_user_entities fue,
2272: pay_payroll_actions pact
2273: WHERE pact.report_type = 'EOY'
2274: AND pact.report_qualifier = 'GB'
3001: PROCEDURE archive_code(p_assactid IN NUMBER, p_effective_date IN DATE) IS
3002: --
3003: l_proc CONSTANT VARCHAR2(35):= g_package||'archive_code';
3004: -- vars for returns from the API:
3005: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
3006: l_ovn NUMBER;
3007: l_some_warning BOOLEAN;
3008: --
3009: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3752: --
3753: CURSOR csr_get_final_payment_date(c_asg_action_id NUMBER) IS
3754: SELECT ppa.effective_date
3755: FROM ff_user_entities fue,
3756: ff_archive_items fai,
3757: pay_assignment_actions paa,
3758: pay_payroll_actions ppa
3759: WHERE fue.user_entity_name = 'X_P45_FINAL_PAYMENT_ACTION'
3760: AND fue.user_entity_id = fai.user_entity_id