DBA Data[Home] [Help]

APPS.PAY_PAYROLLS_F_PKG dependencies on PAY_PAYROLLS_F_PKG

Line 1: PACKAGE BODY PAY_PAYROLLS_F_PKG as

1: PACKAGE BODY PAY_PAYROLLS_F_PKG as
2: /* $Header: pyprl01t.pkb 120.2 2006/11/10 16:49:25 ajeyam noship $ */
3: --
4: c_end_of_time constant date := to_date('31/12/4712','DD/MM/YYYY');
5: --

Line 206: 'pay_payrolls_f_pkg.maintain_soft_coding_keyflex');

202: exception
203: when NO_DATA_FOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE',
206: 'pay_payrolls_f_pkg.maintain_soft_coding_keyflex');
207: hr_utility.set_message_token('STEP','1');
208: hr_utility.raise_error;
209: end;
210: --

Line 342: 'pay_payrolls_f_pkg.current_values');

338: if csr_current_values%notfound then
339: close csr_current_values;
340: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
341: hr_utility.set_message_token('PROCEDURE',
342: 'pay_payrolls_f_pkg.current_values');
343: hr_utility.set_message_token('STEP', 1);
344: hr_utility.raise_error;
345: else
346: close csr_current_values;

Line 1563: pay_payrolls_f_pkg.validate_insert_payroll

1559: l_midpoint_offset number := 0 ;
1560: --
1561: BEGIN
1562: --
1563: pay_payrolls_f_pkg.validate_insert_payroll
1564: (x_business_group_id,
1565: x_payroll_name,
1566: x_default_payment_method_id,
1567: x_validation_start_date,

Line 1749: 'pay_payrolls_f_pkg.insert_row');

1745: if (C%NOTFOUND) then
1746: CLOSE C;
1747: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1748: hr_utility.set_message_token('PROCEDURE',
1749: 'pay_payrolls_f_pkg.insert_row');
1750: hr_utility.set_message_token('STEP','1');
1751: hr_utility.raise_error;
1752: end if;
1753: CLOSE C;

Line 1770: pay_payrolls_f_pkg.insert_payroll

1766: -- for the rest of session
1767: --
1768: hr_security.add_payroll(x_payroll_id);
1769: --
1770: pay_payrolls_f_pkg.insert_payroll
1771: (x_payroll_id,
1772: x_default_payment_method_id,
1773: x_validation_start_date,
1774: x_validation_end_date);

Line 1906: pay_payrolls_f_pkg.validate_insert_payroll

1902: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
1903: --
1904: BEGIN
1905: --
1906: pay_payrolls_f_pkg.validate_insert_payroll
1907: (x_business_group_id,
1908: x_payroll_name,
1909: x_default_payment_method_id,
1910: x_validation_start_date,

Line 2030: 'pay_payrolls_f_pkg.insert_row');

2026: if (C%NOTFOUND) then
2027: CLOSE C;
2028: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2029: hr_utility.set_message_token('PROCEDURE',
2030: 'pay_payrolls_f_pkg.insert_row');
2031: hr_utility.set_message_token('STEP','1');
2032: hr_utility.raise_error;
2033: end if;
2034: CLOSE C;

Line 2051: pay_payrolls_f_pkg.insert_payroll

2047: -- for the rest of session
2048: --
2049: hr_security.add_payroll(x_payroll_id);
2050: --
2051: pay_payrolls_f_pkg.insert_payroll
2052: (x_payroll_id,
2053: x_default_payment_method_id,
2054: x_validation_start_date,
2055: x_validation_end_date);

Line 2171: 'pay_payrolls_f_pkg.lock_row');

2167: if (C%NOTFOUND) then
2168: CLOSE C;
2169: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2170: hr_utility.set_message_token('PROCEDURE',
2171: 'pay_payrolls_f_pkg.lock_row');
2172: hr_utility.set_message_token('STEP','1');
2173: hr_utility.raise_error;
2174: end if;
2175: CLOSE C;

Line 2600: pay_payrolls_F_pkg.validate_update_payroll

2596: v_payroll_name,
2597: v_number_of_years,
2598: v_default_payment_method_id);
2599: --
2600: pay_payrolls_F_pkg.validate_update_payroll
2601: (X_Business_Group_id,
2602: X_Payroll_Id,
2603: X_Payroll_Name,
2604: v_payroll_name, -- Current payroll name

Line 2694: 'pay_payrolls_f_pkg.update_row');

2690: --
2691: if (SQL%NOTFOUND) then
2692: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2693: hr_utility.set_message_token('PROCEDURE',
2694: 'pay_payrolls_f_pkg.update_row');
2695: hr_utility.set_message_token('STEP','1');
2696: hr_utility.raise_error;
2697: --
2698: end if;

Line 2700: pay_payrolls_f_pkg.update_payroll

2696: hr_utility.raise_error;
2697: --
2698: end if;
2699: --
2700: pay_payrolls_f_pkg.update_payroll
2701: (x_business_group_id,
2702: x_payroll_id,
2703: x_payroll_name,
2704: v_payroll_name, -- Current payroll name

Line 2857: pay_payrolls_F_pkg.validate_update_payroll

2853: v_payroll_name,
2854: v_number_of_years,
2855: v_default_payment_method_id);
2856: --
2857: pay_payrolls_F_pkg.validate_update_payroll
2858: (X_Business_Group_id,
2859: X_Payroll_Id,
2860: X_Payroll_Name,
2861: v_payroll_name, -- Current payroll name

Line 2965: pay_payrolls_f_pkg.update_payroll

2961: X_Payroll_Id := l_payroll_id;
2962: X_rowid := l_rowid;
2963:
2964: --
2965: pay_payrolls_f_pkg.update_payroll
2966: (x_business_group_id,
2967: x_payroll_id,
2968: x_payroll_name,
2969: v_payroll_name, -- Current payroll name

Line 3000: pay_payrolls_f_pkg.validate_delete_payroll

2996: X_Validation_Start_date DATE,
2997: X_Validation_End_date DATE) IS
2998: BEGIN
2999: --
3000: pay_payrolls_f_pkg.validate_delete_payroll
3001: (x_payroll_id,
3002: x_default_payment_method_id,
3003: x_dt_delete_mode,
3004: x_validation_start_date,

Line 3013: 'pay_payrolls_f_pkg.delete_row');

3009: --
3010: if (SQL%NOTFOUND) then
3011: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3012: hr_utility.set_message_token('PROCEDURE',
3013: 'pay_payrolls_f_pkg.delete_row');
3014: hr_utility.set_message_token('STEP','1');
3015: hr_utility.raise_error;
3016: end if;
3017: --

Line 3018: pay_payrolls_F_pkg.delete_payroll

3014: hr_utility.set_message_token('STEP','1');
3015: hr_utility.raise_error;
3016: end if;
3017: --
3018: pay_payrolls_F_pkg.delete_payroll
3019: (x_payroll_id,
3020: x_default_payment_method_id,
3021: x_dt_delete_mode,
3022: x_validation_start_date,

Line 3063: pay_payrolls_f_pkg.validate_delete_payroll

3059: where rowid = X_Rowid;
3060: --
3061: BEGIN
3062: --
3063: pay_payrolls_f_pkg.validate_delete_payroll
3064: (x_payroll_id,
3065: x_default_payment_method_id,
3066: x_dt_delete_mode,
3067: x_validation_start_date,

Line 3084: pay_payrolls_F_pkg.delete_payroll

3080: p_effective_start_date => l_effective_start_date,
3081: p_effective_end_date => l_effective_end_date
3082: );
3083: --
3084: pay_payrolls_F_pkg.delete_payroll
3085: (x_payroll_id,
3086: x_default_payment_method_id,
3087: x_dt_delete_mode,
3088: x_validation_start_date,

Line 3190: END pay_payrolls_f_pkg;

3186: hr_utility.set_location('pyprl01t.show_ddf_canvas_yesno',200);
3187:
3188: END show_ddf_canvas_yesno;
3189: --
3190: END pay_payrolls_f_pkg;