eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYROLLS_F_PKG dependencies on PAY_PAYROLLS_F

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 329: from pay_payrolls_f prl

325: cursor csr_current_values is
326: select prl.payroll_name,
327: prl.number_of_years,
328: prl.default_payment_method_id
329: from pay_payrolls_f prl
330: where prl.rowid = p_rowid;
331: --
332: v_values_rec csr_current_values%rowtype;
333: --

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 374: from pay_payrolls_f prl

370: ) is
371: --
372: cursor csr_lock_payroll is
373: select prl.payroll_id
374: from pay_payrolls_f prl
375: where prl.payroll_id = p_payroll_id
376: for update;
377: --
378: begin

Line 453: from pay_payrolls_f prl

449: --
450: cursor csr_payroll_rows is
451: select prl.payroll_name,
452: prl.number_of_years
453: from pay_payrolls_f prl
454: where prl.payroll_id = p_payroll_id
455: for update;
456: --
457: begin

Line 461: update pay_payrolls_f prl

457: begin
458: --
459: for v_prl_rec in csr_payroll_rows loop
460: --
461: update pay_payrolls_f prl
462: set prl.payroll_name = nvl(p_payroll_name,
463: v_prl_rec.payroll_name),
464: prl.number_of_years = nvl(p_number_of_years,
465: v_prl_rec.number_of_years)

Line 1325: from pay_payrolls_f prl,

1321: ) is
1322: --
1323: cursor csr_comment_rows_zap is
1324: select com.comment_id
1325: from pay_payrolls_f prl,
1326: hr_comments com
1327: where prl.payroll_id = p_payroll_id
1328: and com.comment_id = prl.comment_id
1329: for update of com.comment_id;

Line 1333: from pay_payrolls_f prl,

1329: for update of com.comment_id;
1330: --
1331: cursor csr_comment_rows_delete is
1332: select com.comment_id
1333: from pay_payrolls_f prl,
1334: hr_comments com
1335: where prl.payroll_id = p_payroll_id
1336: and prl.effective_start_date >= p_validation_start_date
1337: and com.comment_id = prl.comment_id

Line 1340: from pay_payrolls_f prl2

1336: and prl.effective_start_date >= p_validation_start_date
1337: and com.comment_id = prl.comment_id
1338: and not exists
1339: (select null
1340: from pay_payrolls_f prl2
1341: where prl2.payroll_id = prl.payroll_id
1342: and prl2.effective_start_date < p_validation_start_date
1343: and prl2.comment_id = prl.comment_id)
1344: for update of com.comment_id;

Line 1438: update pay_payrolls_f

1434: --
1435: if l_last_period_end_date is not null and
1436: l_first_period_start_date is not null
1437: then
1438: update pay_payrolls_f
1439: set number_of_years =
1440: round(months_between(l_last_period_end_date,l_first_period_start_date))/12
1441: where payroll_id = p_payroll_id;
1442: end if;

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 1582: INSERT INTO PAY_PAYROLLS_F

1578: else
1579: l_midpoint_offset := 0 ;
1580: end if ;
1581: --
1582: INSERT INTO PAY_PAYROLLS_F
1583: (payroll_id,
1584: effective_start_date,
1585: effective_end_date,
1586: default_payment_method_id,

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 2158: CURSOR C IS SELECT * FROM PAY_PAYROLLS_F

2154: X_payslip_view_date_offset NUMBER DEFAULT NULL
2155: ) IS
2156:
2157: --
2158: CURSOR C IS SELECT * FROM PAY_PAYROLLS_F
2159: WHERE rowid = X_Rowid FOR UPDATE of Payroll_Id NOWAIT;
2160: --
2161: Recinfo C%ROWTYPE;
2162: --

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 2610: UPDATE PAY_PAYROLLS_F

2606: v_default_payment_method_id, -- Current default payment method
2607: X_Validation_Start_Date,
2608: X_Validation_End_Date);
2609:
2610: UPDATE PAY_PAYROLLS_F
2611: SET payroll_id = X_Payroll_Id,
2612: effective_start_date = X_Effective_Start_Date,
2613: effective_end_date = X_Effective_End_Date,
2614: default_payment_method_id = X_Default_Payment_Method_Id,

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 3007: DELETE FROM PAY_PAYROLLS_F

3003: x_dt_delete_mode,
3004: x_validation_start_date,
3005: x_validation_end_date);
3006: --
3007: DELETE FROM PAY_PAYROLLS_F
3008: WHERE rowid = X_Rowid;
3009: --
3010: if (SQL%NOTFOUND) then
3011: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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;