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 HR_UTILITY

Line 204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

200: into v_soft_coding_keyflex_id
201: from sys.dual;
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;

Line 205: hr_utility.set_message_token('PROCEDURE',

201: from sys.dual;
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;

Line 207: hr_utility.set_message_token('STEP','1');

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: --
211: -- Insert the new row.

Line 208: hr_utility.raise_error;

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: --
211: -- Insert the new row.
212: begin

Line 340: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');

336: open csr_current_values;
337: fetch csr_current_values into v_values_rec;
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;

Line 341: hr_utility.set_message_token('PROCEDURE',

337: fetch csr_current_values into v_values_rec;
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

Line 343: hr_utility.set_message_token('STEP', 1);

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;
347: end if;

Line 344: hr_utility.raise_error;

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;
347: end if;
348: --

Line 421: hr_utility.set_message(801, 'HR_6667_PAY_PAYROLL_EXISTS');

417: open csr_payroll_exists;
418: fetch csr_payroll_exists into v_payroll_id;
419: if csr_payroll_exists%found then
420: close csr_payroll_exists;
421: hr_utility.set_message(801, 'HR_6667_PAY_PAYROLL_EXISTS');
422: hr_utility.raise_error;
423: else
424: close csr_payroll_exists;
425: end if;

Line 422: hr_utility.raise_error;

418: fetch csr_payroll_exists into v_payroll_id;
419: if csr_payroll_exists%found then
420: close csr_payroll_exists;
421: hr_utility.set_message(801, 'HR_6667_PAY_PAYROLL_EXISTS');
422: hr_utility.raise_error;
423: else
424: close csr_payroll_exists;
425: end if;
426: --

Line 643: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');

639: open csr_opm_dates;
640: fetch csr_opm_dates into v_opm_rec;
641: if csr_opm_dates%notfound then
642: close csr_opm_dates;
643: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
644: hr_utility.set_message_token('PROCEDURE',
645: 'validate_dflt_payment_method');
646: hr_utility.set_message_token('STEP', 1);
647: hr_utility.raise_error;

Line 644: hr_utility.set_message_token('PROCEDURE',

640: fetch csr_opm_dates into v_opm_rec;
641: if csr_opm_dates%notfound then
642: close csr_opm_dates;
643: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
644: hr_utility.set_message_token('PROCEDURE',
645: 'validate_dflt_payment_method');
646: hr_utility.set_message_token('STEP', 1);
647: hr_utility.raise_error;
648: else

Line 646: hr_utility.set_message_token('STEP', 1);

642: close csr_opm_dates;
643: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
644: hr_utility.set_message_token('PROCEDURE',
645: 'validate_dflt_payment_method');
646: hr_utility.set_message_token('STEP', 1);
647: hr_utility.raise_error;
648: else
649: v_start_date := v_opm_rec.effective_start_date;
650: v_end_date := v_opm_rec.effective_end_date;

Line 647: hr_utility.raise_error;

643: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
644: hr_utility.set_message_token('PROCEDURE',
645: 'validate_dflt_payment_method');
646: hr_utility.set_message_token('STEP', 1);
647: hr_utility.raise_error;
648: else
649: v_start_date := v_opm_rec.effective_start_date;
650: v_end_date := v_opm_rec.effective_end_date;
651: end if;

Line 662: hr_utility.set_message(801, 'HR_7096_PAYM_PYRLL_DFLT_INVID');

658: close csr_opm_dates;
659: --
660: if v_start_date > p_validation_start_date or
661: v_end_date < p_validation_end_date then
662: hr_utility.set_message(801, 'HR_7096_PAYM_PYRLL_DFLT_INVID');
663: hr_utility.raise_error;
664: end if;
665: --
666: end validate_dflt_payment_method;

Line 663: hr_utility.raise_error;

659: --
660: if v_start_date > p_validation_start_date or
661: v_end_date < p_validation_end_date then
662: hr_utility.set_message(801, 'HR_7096_PAYM_PYRLL_DFLT_INVID');
663: hr_utility.raise_error;
664: end if;
665: --
666: end validate_dflt_payment_method;
667: --

Line 1211: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');

1207: open csr_chk_assignment;
1208: fetch csr_chk_assignment into v_result;
1209: if csr_chk_assignment%found then
1210: close csr_chk_assignment;
1211: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');
1212: hr_utility.raise_error;
1213: else
1214: close csr_chk_assignment;
1215: end if;

Line 1212: hr_utility.raise_error;

1208: fetch csr_chk_assignment into v_result;
1209: if csr_chk_assignment%found then
1210: close csr_chk_assignment;
1211: hr_utility.set_message(801, 'HR_6674_PAY_ASSIGN');
1212: hr_utility.raise_error;
1213: else
1214: close csr_chk_assignment;
1215: end if;
1216: --

Line 1221: hr_utility.set_message(801, 'HR_6675_PAY_ELE');

1217: open csr_chk_element_link;
1218: fetch csr_chk_element_link into v_result;
1219: if csr_chk_element_link%found then
1220: close csr_chk_element_link;
1221: hr_utility.set_message(801, 'HR_6675_PAY_ELE');
1222: hr_utility.raise_error;
1223: else
1224: close csr_chk_element_link;
1225: end if;

Line 1222: hr_utility.raise_error;

1218: fetch csr_chk_element_link into v_result;
1219: if csr_chk_element_link%found then
1220: close csr_chk_element_link;
1221: hr_utility.set_message(801, 'HR_6675_PAY_ELE');
1222: hr_utility.raise_error;
1223: else
1224: close csr_chk_element_link;
1225: end if;
1226:

Line 1231: hr_utility.set_message(800, 'HR_DEL_PAYROLL_POSITION_EXISTS');

1227: open csr_chk_position;
1228: fetch csr_chk_position into v_result;
1229: if csr_chk_position%found then
1230: close csr_chk_position;
1231: hr_utility.set_message(800, 'HR_DEL_PAYROLL_POSITION_EXISTS');
1232: hr_utility.raise_error;
1233: else
1234: close csr_chk_position;
1235: end if;

Line 1232: hr_utility.raise_error;

1228: fetch csr_chk_position into v_result;
1229: if csr_chk_position%found then
1230: close csr_chk_position;
1231: hr_utility.set_message(800, 'HR_DEL_PAYROLL_POSITION_EXISTS');
1232: hr_utility.raise_error;
1233: else
1234: close csr_chk_position;
1235: end if;
1236:

Line 1246: hr_utility.set_message(801, 'HR_6488_PAY_DEL_ACTIONS');

1242: open csr_chk_payroll_action;
1243: fetch csr_chk_payroll_action into v_result;
1244: if csr_chk_payroll_action%found then
1245: close csr_chk_payroll_action;
1246: hr_utility.set_message(801, 'HR_6488_PAY_DEL_ACTIONS');
1247: hr_utility.raise_error;
1248: else
1249: close csr_chk_payroll_action;
1250: end if;

Line 1247: hr_utility.raise_error;

1243: fetch csr_chk_payroll_action into v_result;
1244: if csr_chk_payroll_action%found then
1245: close csr_chk_payroll_action;
1246: hr_utility.set_message(801, 'HR_6488_PAY_DEL_ACTIONS');
1247: hr_utility.raise_error;
1248: else
1249: close csr_chk_payroll_action;
1250: end if;
1251: --

Line 1256: hr_utility.set_message(801, 'HR_6489_PAY_DEL_ASS');

1252: open csr_chk_assignment_set;
1253: fetch csr_chk_assignment_set into v_result;
1254: if csr_chk_assignment_set%found then
1255: close csr_chk_assignment_set;
1256: hr_utility.set_message(801, 'HR_6489_PAY_DEL_ASS');
1257: hr_utility.raise_error;
1258: else
1259: close csr_chk_assignment_set;
1260: end if;

Line 1257: hr_utility.raise_error;

1253: fetch csr_chk_assignment_set into v_result;
1254: if csr_chk_assignment_set%found then
1255: close csr_chk_assignment_set;
1256: hr_utility.set_message(801, 'HR_6489_PAY_DEL_ASS');
1257: hr_utility.raise_error;
1258: else
1259: close csr_chk_assignment_set;
1260: end if;
1261: --

Line 1266: hr_utility.set_message(801, 'HR_6491_PAY_DEL_SEC_PAY');

1262: open csr_chk_security_payroll;
1263: fetch csr_chk_security_payroll into v_result;
1264: if csr_chk_security_payroll%found then
1265: close csr_chk_security_payroll;
1266: hr_utility.set_message(801, 'HR_6491_PAY_DEL_SEC_PAY');
1267: hr_utility.raise_error;
1268: else
1269: close csr_chk_security_payroll;
1270: end if;

Line 1267: hr_utility.raise_error;

1263: fetch csr_chk_security_payroll into v_result;
1264: if csr_chk_security_payroll%found then
1265: close csr_chk_security_payroll;
1266: hr_utility.set_message(801, 'HR_6491_PAY_DEL_SEC_PAY');
1267: hr_utility.raise_error;
1268: else
1269: close csr_chk_security_payroll;
1270: end if;
1271: --

Line 1276: hr_utility.set_message(801, 'HR_6731_PAY_DEL_MESS');

1272: open csr_chk_message_line;
1273: fetch csr_chk_message_line into v_result;
1274: if csr_chk_message_line%found then
1275: close csr_chk_message_line;
1276: hr_utility.set_message(801, 'HR_6731_PAY_DEL_MESS');
1277: hr_utility.raise_error;
1278: else
1279: close csr_chk_message_line;
1280: end if;

Line 1277: hr_utility.raise_error;

1273: fetch csr_chk_message_line into v_result;
1274: if csr_chk_message_line%found then
1275: close csr_chk_message_line;
1276: hr_utility.set_message(801, 'HR_6731_PAY_DEL_MESS');
1277: hr_utility.raise_error;
1278: else
1279: close csr_chk_message_line;
1280: end if;
1281: --

Line 1288: hr_utility.set_message(801, ''PAY_33198_PAYROLL_USED_IN_OTL'');

1284: begin
1285: l_payroll_used := hxc_resource_rules_utils.chk_criteria_exists
1286: (''PAYROLL'',:p_eligibility_criteria_id);
1287: if l_payroll_used then
1288: hr_utility.set_message(801, ''PAY_33198_PAYROLL_USED_IN_OTL'');
1289: hr_utility.raise_error;
1290: end if;
1291: end;' ;
1292:

Line 1289: hr_utility.raise_error;

1285: l_payroll_used := hxc_resource_rules_utils.chk_criteria_exists
1286: (''PAYROLL'',:p_eligibility_criteria_id);
1287: if l_payroll_used then
1288: hr_utility.set_message(801, ''PAY_33198_PAYROLL_USED_IN_OTL'');
1289: hr_utility.raise_error;
1290: end if;
1291: end;' ;
1292:
1293: execute immediate v_text using p_payroll_id ;

Line 1747: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1743: OPEN C;
1744: FETCH C INTO X_Rowid;
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;

Line 1748: hr_utility.set_message_token('PROCEDURE',

1744: FETCH C INTO X_Rowid;
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;

Line 1750: hr_utility.set_message_token('STEP','1');

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;
1754: --

Line 1751: hr_utility.raise_error;

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;
1754: --
1755: -- Code added as part of bug fix 2593982

Line 2028: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2024: OPEN C;
2025: FETCH C INTO X_Rowid, X_comment_id;
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;

Line 2029: hr_utility.set_message_token('PROCEDURE',

2025: FETCH C INTO X_Rowid, X_comment_id;
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;

Line 2031: hr_utility.set_message_token('STEP','1');

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;
2035: --

Line 2032: hr_utility.raise_error;

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;
2035: --
2036: -- Code added as part of bug fix 2593982

Line 2169: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2165: OPEN C;
2166: FETCH C INTO Recinfo;
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;

Line 2170: hr_utility.set_message_token('PROCEDURE',

2166: FETCH C INTO Recinfo;
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;

Line 2172: hr_utility.set_message_token('STEP','1');

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;
2176: --

Line 2173: hr_utility.raise_error;

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;
2176: --
2177: -- Remove trailing spaces.

Line 2692: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2688: payslip_view_date_offset = X_payslip_view_date_offset
2689: WHERE rowid = X_rowid;
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;

Line 2693: hr_utility.set_message_token('PROCEDURE',

2689: WHERE rowid = X_rowid;
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: --

Line 2695: hr_utility.set_message_token('STEP','1');

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;
2699: --

Line 2696: hr_utility.raise_error;

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;
2699: --
2700: pay_payrolls_f_pkg.update_payroll

Line 3011: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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');
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;

Line 3012: hr_utility.set_message_token('PROCEDURE',

3008: WHERE rowid = X_Rowid;
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;

Line 3014: hr_utility.set_message_token('STEP','1');

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: --
3018: pay_payrolls_F_pkg.delete_payroll

Line 3015: hr_utility.raise_error;

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: --
3018: pay_payrolls_F_pkg.delete_payroll
3019: (x_payroll_id,

Line 3173: hr_utility.set_location('pyprl01t.show_ddf_canvas_yesno',100);

3169: v_show_ddf_canvas boolean := false;
3170: --
3171: BEGIN
3172: --
3173: hr_utility.set_location('pyprl01t.show_ddf_canvas_yesno',100);
3174:
3175: -- the flexfield canvas will be shown only if there are segments defined
3176: -- for the Payroll DDF
3177:

Line 3186: hr_utility.set_location('pyprl01t.show_ddf_canvas_yesno',200);

3182: end if;
3183: CLOSE c_show_ddf_canvas;
3184:
3185: p_show_ddf_canvas := v_show_ddf_canvas;
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;