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 2407: ,p_standard_link_flag => l_standard_link

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

Line 2467: ,p_standard_link_flag => l_standard_link

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

Line 2601: ,p_standard_link_flag => l_standard_link

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

Line 3349: ,p_standard_link IN VARCHAR2

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

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

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

Line 3545: ,p_standard_link => p_standard_link

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

Line 3602: ,p_standard_link => p_standard_link

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

Line 3641: ,p_standard_link => p_standard_link

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

Line 3694: ,p_standard_link IN VARCHAR2

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

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

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

Line 3809: ,p_standard_link => p_standard_link

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