DBA Data[Home] [Help]

APPS.PAY_CA_RULES dependencies on PAY_CA_RULES

Line 1: package body pay_ca_rules as

1: package body pay_ca_rules as
2: /* $Header: pycarule.pkb 120.18.12020000.8 2013/04/19 13:27:53 sbachu ship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993,1994. All rights reserved
5: --

Line 6: Name : pay_ca_rules

2: /* $Header: pycarule.pkb 120.18.12020000.8 2013/04/19 13:27:53 sbachu ship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993,1994. All rights reserved
5: --
6: Name : pay_ca_rules
7: --
8: Change List
9: -----------
10: Date Name Vers Description

Line 1089: OPEN get_ws_name (l_id_flex_num,--pay_ca_rules.g_id_flex_num,

1085: /* get work schedule_name */
1086: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1087: IF l_id_flex_num IS NOT NULL THEN
1088: hr_utility.trace('getting work schedule name ');
1089: OPEN get_ws_name (l_id_flex_num,--pay_ca_rules.g_id_flex_num,
1090: date_earned,
1091: assignment_id);
1092: FETCH get_ws_name INTO p_ws_name;
1093: CLOSE get_ws_name;

Line 1244: hr_utility.trace('Starting pay_ca_rules.get_file_creation_number !!!!');

1240: l_dd_format VARCHAR2(30);
1241:
1242: BEGIN
1243:
1244: hr_utility.trace('Starting pay_ca_rules.get_file_creation_number !!!!');
1245:
1246: OPEN cur_paid;
1247: FETCH cur_paid
1248: INTO l_legislative_parameter,

Line 1279: hr_utility.trace('Ending pay_ca_rules.get_file_creation_number !!!!');

1275: l_bg_id) ;
1276: END IF;
1277:
1278: hr_utility.trace('file_no = ' || file_no);
1279: hr_utility.trace('Ending pay_ca_rules.get_file_creation_number !!!!');
1280:
1281: END get_file_creation_no;
1282: /* Changes for Deposit Advice (XML) Enhancements starts here*/
1283:

Line 1290: hr_utility.trace('Entering pay_ca_rules.payslip_range_cursor');

1286:
1287: lv_sqlstr VARCHAR2(32000);
1288:
1289: BEGIN
1290: hr_utility.trace('Entering pay_ca_rules.payslip_range_cursor');
1291: lv_sqlstr := NULL;
1292: pycadar_pkg.range_cursor (pactid => p_pactid, sqlstr => lv_sqlstr);
1293: hr_utility.trace('Returning lv_sqlstr := ' || lv_sqlstr);
1294:

Line 1385: end pay_ca_rules;

1381: return lv_sort_order3;
1382: END get_payslip_sort_order3;
1383: /*Bug 16686045 ends here*/
1384:
1385: end pay_ca_rules;