DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on STANDARD

Line 64: ,p_standard_link IN VARCHAR2

60: ,p_iterative_processing IN VARCHAR2
61: ,p_arrearage_allowed IN VARCHAR2
62: ,p_partial_deduction IN VARCHAR2
63: ,p_termination_rule IN VARCHAR2
64: ,p_standard_link IN VARCHAR2
65: ,p_validate IN BOOLEAN
66: )
67: RETURN NUMBER
68: IS

Line 106: p_standard_link (V) - Check box based i/p (Y/N) Default N

102: p_iterative_processing (V) - Check box based i/p (Y/N) Default N
103: p_arrearage_allowed (V) - Check box based i/p (Y/N) Default N
104: p_partial_deduction (V) - Check box based i/p (Y/N) Default N
105: p_termination_rule (V) - Radio button based i/p (A/F/L) Default L
106: p_standard_link (V) - Check box based i/p (Y/N) Default N
107: p_validate (B) - TRUE or FALSE
108:
109: -----------------------------------------------------------------------------*/
110: --

Line 187: l_standard_link VARCHAR2 (1) := NVL (

183: l_arrearage_allowed VARCHAR2 (1)
184: := NVL (p_arrearage_allowed, 'N');
185: l_partial_deduction VARCHAR2 (1)
186: := NVL (p_partial_deduction, 'N');
187: l_standard_link VARCHAR2 (1) := NVL (
188: p_standard_link
189: ,'N'
190: );
191: l_format_base_name pay_element_templates.base_name%TYPE

Line 188: p_standard_link

184: := NVL (p_arrearage_allowed, 'N');
185: l_partial_deduction VARCHAR2 (1)
186: := NVL (p_partial_deduction, 'N');
187: l_standard_link VARCHAR2 (1) := NVL (
188: p_standard_link
189: ,'N'
190: );
191: l_format_base_name pay_element_templates.base_name%TYPE
192: := UPPER (TRANSLATE (TRIM (p_ele_base_name), ' ', '_'));

Line 509: -- element's Standard status proc rule.

505:
506:
507: -- ------------------------------------------------------------
508: -- Query formula info (ie. the formula attached to this
509: -- element's Standard status proc rule.
510: -- ------------------------------------------------------------
511: FOR fra_rec IN csr_get_ff_id (
512: c_element_type_id => p_element_type_id
513: )

Line 2405: ,p_standard_link_flag => l_standard_link

2401: ,p_third_party_pay_only_flag => p_third_party_only_flag
2402: ,p_iterative_flag => l_iterative_flag
2403: ,p_iterative_priority => l_iterative_priority
2404: ,p_iterative_formula_name => l_iterative_formula
2405: ,p_standard_link_flag => l_standard_link
2406: ,p_post_termination_rule => p_termination_rule
2407: ,p_object_version_number => l_ele_obj_ver_number
2408: );
2409: --

Line 2465: ,p_standard_link_flag => l_standard_link

2461: ,p_effective_date => p_effective_start_date
2462: ,p_element_type_id => l_element_type_id
2463: ,p_element_name => l_ele_new_name (i)
2464: ,p_third_party_pay_only_flag => p_third_party_only_flag
2465: ,p_standard_link_flag => l_standard_link
2466: ,p_post_termination_rule => p_termination_rule
2467: ,p_object_version_number => l_ele_obj_ver_number
2468: );
2469: -- Move the ele new name to the ele name

Line 2599: ,p_standard_link_flag => l_standard_link

2595: ,p_third_party_pay_only_flag => p_third_party_only_flag
2596: ,p_iterative_flag => l_iterative_flag
2597: ,p_iterative_priority => l_iterative_priority
2598: ,p_iterative_formula_name => l_iterative_formula
2599: ,p_standard_link_flag => l_standard_link
2600: ,p_post_termination_rule => p_termination_rule
2601: ,p_object_version_number => l_ele_obj_ver_number
2602: );
2603: END LOOP;

Line 3347: ,p_standard_link IN VARCHAR2

3343: ,p_iterative_processing IN VARCHAR2
3344: ,p_arrearage_allowed IN VARCHAR2
3345: ,p_partial_deduction IN VARCHAR2
3346: ,p_termination_rule IN VARCHAR2
3347: ,p_standard_link IN VARCHAR2
3348: )
3349: RETURN NUMBER
3350: IS
3351: --

Line 3387: p_standard_link (V) - Check box based i/p (Y/N) Default N

3383: p_iterative_processing (V) - Check box based i/p (Y/N) Default N
3384: p_arrearage_allowed (V) - Check box based i/p (Y/N) Default N
3385: p_partial_deduction (V) - Check box based i/p (Y/N) Default N
3386: p_termination_rule (V) - Radio button based i/p (A/F/L) Default L
3387: p_standard_link (V) - Check box based i/p (Y/N) Default N
3388:
3389: -----------------------------------------------------------------------------*/
3390: --
3391: l_element_type_id NUMBER;

Line 3543: ,p_standard_link => p_standard_link

3539: ,p_iterative_processing => p_iterative_processing
3540: ,p_arrearage_allowed => p_arrearage_allowed
3541: ,p_partial_deduction => p_partial_deduction
3542: ,p_termination_rule => p_termination_rule
3543: ,p_standard_link => p_standard_link
3544: ,p_validate => TRUE
3545: );
3546: -- Get the pensionable salary balance if a new one is created above
3547: -- so that the same information is used for the fixed rate element

Line 3600: ,p_standard_link => p_standard_link

3596: ,p_iterative_processing => p_iterative_processing
3597: ,p_arrearage_allowed => p_arrearage_allowed
3598: ,p_partial_deduction => p_partial_deduction
3599: ,p_termination_rule => p_termination_rule
3600: ,p_standard_link => p_standard_link
3601: ,p_validate => FALSE
3602: );
3603: ELSE -- not PEFR
3604: -- Call the low level function with the same parameters

Line 3639: ,p_standard_link => p_standard_link

3635: ,p_iterative_processing => p_iterative_processing
3636: ,p_arrearage_allowed => p_arrearage_allowed
3637: ,p_partial_deduction => p_partial_deduction
3638: ,p_termination_rule => p_termination_rule
3639: ,p_standard_link => p_standard_link
3640: ,p_validate => TRUE
3641: );
3642: END IF; -- End if of emp deduction method = PEFR check ...
3643: ELSE

Line 3692: ,p_standard_link IN VARCHAR2

3688: ,p_iterative_processing IN VARCHAR2
3689: ,p_arrearage_allowed IN VARCHAR2
3690: ,p_partial_deduction IN VARCHAR2
3691: ,p_termination_rule IN VARCHAR2
3692: ,p_standard_link IN VARCHAR2
3693: )
3694: RETURN NUMBER
3695: IS
3696: --

Line 3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);

3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);
3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);
3742: hr_utility.set_location(' p_termination_rule :' ||p_termination_rule ,5);
3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);
3744:
3745: --**********************************
3746:
3747: hr_utility.set_location ( ' Entering:'

Line 3806: ,p_standard_link => p_standard_link

3802: ,p_iterative_processing => p_iterative_processing
3803: ,p_arrearage_allowed => p_arrearage_allowed
3804: ,p_partial_deduction => p_partial_deduction
3805: ,p_termination_rule => p_termination_rule
3806: ,p_standard_link => p_standard_link
3807: );
3808:
3809: hr_utility.set_location ( 'l_element_type_id: ' || l_element_type_id, 25);
3810: --