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.PSP_LABOR_DIST dependencies on PSP_GENERAL

Line 113: l_org_def_labor_schedule VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');

109: AND ppl.assignment_id between p_start_asg_id and p_end_asg_id
110: ORDER BY ppl.person_id,ppl.assignment_id,ppl.payroll_line_id, ppl.element_type_id;
111:
112:
113: l_org_def_labor_schedule VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');
114: l_org_def_account VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');
115: --
116: l_element_type_id NUMBER(9);
117: l_payroll_sub_line_id NUMBER(10);

Line 114: l_org_def_account VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');

110: ORDER BY ppl.person_id,ppl.assignment_id,ppl.payroll_line_id, ppl.element_type_id;
111:
112:
113: l_org_def_labor_schedule VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');
114: l_org_def_account VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');
115: --
116: l_element_type_id NUMBER(9);
117: l_payroll_sub_line_id NUMBER(10);
118: l_sub_line_start_date DATE;

Line 287: l_action_parameter_group VARCHAR2(30) := psp_general.get_specific_profile('ACTION_PARAMETER_GROUPS'); --6661707

283: l_sum_adj_amount number;
284: l_tot_dist_amount number;
285: l_dist_amount number;
286: l_gl_project_flag varchar2(1);
287: l_action_parameter_group VARCHAR2(30) := psp_general.get_specific_profile('ACTION_PARAMETER_GROUPS'); --6661707
288:
289: cursor get_tgl_revb_acc_date is
290: select nvl(parameter_value, 'P') parameter_value
291: from PAY_ACTION_PARAMETER_VALUES

Line 325: psp_general.get_currency_precision(payroll_control_rec.currency_code, g_precision, g_ext_precision);

321: END IF;
322: BEGIN
323:
324: -- Introduced the following for bug fix 2916848
325: psp_general.get_currency_precision(payroll_control_rec.currency_code, g_precision, g_ext_precision);
326: -- End of bug fix 2916848
327:
328: OPEN payroll_cur(payroll_control_rec.payroll_control_id);
329: LOOP

Line 369: l_last_working_date := psp_general.last_working_date(payroll_rec.sub_line_end_date);

365: g_gl_effective_date := l_effective_date;
366:
367: l_payroll_start_date := payroll_rec.sub_line_start_date;
368: -- FInd out NOCOPY the last working date for a period
369: l_last_working_date := psp_general.last_working_date(payroll_rec.sub_line_end_date);
370:
371:
372: IF payroll_rec.daily_rate = 0 THEN
373: l_no_business_days := psp_general.business_days(payroll_rec.sub_line_start_date,payroll_rec.sub_line_end_date,payroll_rec.assignment_id);

Line 373: l_no_business_days := psp_general.business_days(payroll_rec.sub_line_start_date,payroll_rec.sub_line_end_date,payroll_rec.assignment_id);

369: l_last_working_date := psp_general.last_working_date(payroll_rec.sub_line_end_date);
370:
371:
372: IF payroll_rec.daily_rate = 0 THEN
373: l_no_business_days := psp_general.business_days(payroll_rec.sub_line_start_date,payroll_rec.sub_line_end_date,payroll_rec.assignment_id);
374: IF NVL(l_no_business_days,0)=0 THEN
375: l_no_business_days := 1;
376: END IF;
377: l_daily_rate := round((payroll_rec.pay_amount / l_no_business_days), g_ext_precision); -- Modified to currency extended precision for bug fix 2916848, 3109943

Line 393: IF (psp_general.business_days(l_payroll_start_date, l_payroll_start_date, payroll_rec.assignment_id) > 0)

389: -- Skip the processing if the date encountered is a Saturday or Sunday
390: /*Bug 5557724: to_char(some_date,'D') returns a number indicating the weekday. However, for a given date, this number
391: returned varies with NLS_TERRITORY. So replaced it with to_char(some_date,'DY') that gives the abbreviated day. */
392: -- IF to_char(l_payroll_start_date, 'DY', 'nls_date_language=english') NOT IN ('SUN', 'SAT')
393: IF (psp_general.business_days(l_payroll_start_date, l_payroll_start_date, payroll_rec.assignment_id) > 0)
394: OR payroll_rec.sub_line_start_date = payroll_rec.sub_line_end_date THEN
395: --For Bug 1994421 : Zero work Days build :Introduced the above OR condtion
396:
397: -- changed the if condn for 2663344

Line 1192: psp_general.poeta_effective_date(p_payroll_start_date,

1188: (l_award_status is null) THEN
1189: /* Commented for Bug 1874696
1190: if l_award_id is not null
1191: then
1192: psp_general.poeta_effective_date(p_payroll_start_date,
1193: l_project_id,
1194: l_award_id,
1195: l_task_id,
1196: l_effective_date,

Line 1199: psp_general.poeta_effective_date(p_payroll_start_date,

1195: l_task_id,
1196: l_effective_date,
1197: l_return_status);
1198: elsif l_award_id is null then
1199: psp_general.poeta_effective_date(p_payroll_start_date,
1200: l_project_id,
1201: l_task_id,
1202: l_effective_date,
1203: l_return_status);

Line 1727: psp_general.poeta_effective_date(p_payroll_start_date,

1723: (l_award_status is null) THEN
1724: /* Bug 1874696
1725: if l_award_id is not null
1726: then
1727: psp_general.poeta_effective_date(p_payroll_start_date,
1728: l_project_id,
1729: l_award_id,
1730: l_task_id,
1731: l_effective_date,

Line 1735: psp_general.poeta_effective_date(p_payroll_start_date,

1731: l_effective_date,
1732: l_return_status);
1733: elsif l_award_id is null
1734: then
1735: psp_general.poeta_effective_date(p_payroll_start_date,
1736: l_project_id,
1737: l_task_id,
1738: l_effective_date,
1739: l_return_status);

Line 2313: psp_general.poeta_effective_date(p_payroll_start_date,

2309: (l_award_status is null) THEN
2310: /* Bug 1874696
2311: if l_award_id is not null
2312: then
2313: psp_general.poeta_effective_date(p_payroll_start_date,
2314: l_project_id,
2315: l_award_id,
2316: l_task_id,
2317: l_effective_date,

Line 2321: psp_general.poeta_effective_date(p_payroll_start_date,

2317: l_effective_date,
2318: l_return_status);
2319: elsif l_award_id is null
2320: then
2321: psp_general.poeta_effective_date(p_payroll_start_date,
2322: l_project_id,
2323: l_task_id,
2324: l_effective_date,
2325: l_return_status);

Line 2860: psp_general.poeta_effective_date(p_payroll_start_date,

2856: (l_award_status is null) THEN
2857: /* Bug 1874696
2858: if l_award_id is not null
2859: then
2860: psp_general.poeta_effective_date(p_payroll_start_date,
2861: l_project_id,
2862: l_award_id,
2863: l_task_id,
2864: l_effective_date,

Line 2868: psp_general.poeta_effective_date(p_payroll_start_date,

2864: l_effective_date,
2865: l_return_status);
2866: elsif l_award_id is null
2867: then
2868: psp_general.poeta_effective_date(p_payroll_start_date,
2869: l_project_id,
2870: l_task_id,
2871: l_effective_date,
2872: l_return_status);

Line 3409: psp_general.poeta_effective_date(p_payroll_start_date,

3405: (l_award_status IS NULL) THEN
3406: /* Bug 1874696
3407: if l_award_id is not null
3408: then
3409: psp_general.poeta_effective_date(p_payroll_start_date,
3410: l_project_id,
3411: l_award_id,
3412: l_task_id,
3413: l_effective_date,

Line 3417: psp_general.poeta_effective_date(p_payroll_start_date,

3413: l_effective_date,
3414: l_return_status);
3415: elsif l_award_id is null
3416: then
3417: psp_general.poeta_effective_date(p_payroll_start_date,
3418: l_project_id,
3419: l_task_id,
3420: l_effective_date,
3421: l_return_status);

Line 3889: psp_general.poeta_effective_date(p_payroll_start_date,

3885: (l_award_status is null) THEN
3886: /* Bug 1874696
3887: if l_award_id is not null
3888: then
3889: psp_general.poeta_effective_date(p_payroll_start_date,
3890: l_project_id,
3891: l_award_id,
3892: l_task_id,
3893: l_effective_date,

Line 3897: psp_general.poeta_effective_date(p_payroll_start_date,

3893: l_effective_date,
3894: l_return_status);
3895: elsif l_award_id is null
3896: then
3897: psp_general.poeta_effective_date(p_payroll_start_date,
3898: l_project_id,
3899: l_task_id,
3900: l_effective_date,
3901: l_return_status);

Line 4147: l_return_value := psp_general.find_global_suspense(p_payroll_start_date,

4143:
4144: IF suspense_account_cur%NOTFOUND THEN
4145: CLOSE suspense_account_cur;
4146: ---
4147: l_return_value := psp_general.find_global_suspense(p_payroll_start_date,
4148: p_business_group_id,
4149: p_set_of_books_id,
4150: l_organization_account_id );
4151: /* --------------------------------------------------------------------

Line 4451: psp_general.poeta_effective_date(p_payroll_start_date,

4447: (l_award_status IS NULL) THEN
4448: /* Bug 1874696
4449: if l_award_id is not null
4450: then
4451: psp_general.poeta_effective_date(p_payroll_start_date,
4452: l_project_id,
4453: l_award_id,
4454: l_task_id,
4455: l_effective_date,

Line 4459: psp_general.poeta_effective_date(p_payroll_start_date,

4455: l_effective_date,
4456: l_return_status);
4457: elsif l_award_id is null
4458: then
4459: psp_general.poeta_effective_date(p_payroll_start_date,
4460: l_project_id,
4461: l_task_id,
4462: l_effective_date,
4463: l_return_status);

Line 4906: -- psp_general.poeta_effective_date(p_payroll_start_date,

4902: OR l_award_status is null THEN
4903: -- Bug 1874696
4904: -- if p_award_id is not null
4905: -- then
4906: -- psp_general.poeta_effective_date(p_payroll_start_date,
4907: -- p_project_id,
4908: -- p_award_id,
4909: -- P_task_id,
4910: -- l_effective_date,

Line 4914: -- psp_general.poeta_effective_date(p_payroll_start_date,

4910: -- l_effective_date,
4911: l_return_status);
4912: -- elsif p_award_id is null
4913: -- then
4914: -- psp_general.poeta_effective_date(p_payroll_start_date,
4915: -- p_project_id,
4916: -- P_task_id,
4917: l_effective_date,
4918: -- l_return_status);

Line 5213: l_org_def_labor_schedule VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');

5209: where ppl.payroll_line_id = ppsl.payroll_line_id
5210: and ppsl.payroll_sub_line_id = g_sub_line_id;
5211:
5212: l_proc_executed varchar2(10);
5213: l_org_def_labor_schedule VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');
5214: l_org_def_account VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');
5215: l_return_status VARCHAR2(1);
5216:
5217:

Line 5214: l_org_def_account VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');

5210: and ppsl.payroll_sub_line_id = g_sub_line_id;
5211:
5212: l_proc_executed varchar2(10);
5213: l_org_def_labor_schedule VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');
5214: l_org_def_account VARCHAR2(3) := psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');
5215: l_return_status VARCHAR2(1);
5216:
5217:
5218: x_proc_executed VARCHAR2(10) := 'TRUE';

Line 5472: ----g_auto_population := psp_general.get_specific_profile('PSP_USE_AUTO_POPULATION'); commented for 5080403

5468: end if;
5469:
5470: -- dbms_output.put_line('Inside hierarchy Check');
5471: g_num_dist := 0;
5472: ----g_auto_population := psp_general.get_specific_profile('PSP_USE_AUTO_POPULATION'); commented for 5080403
5473:
5474: if g_charging_instructions.count > 0 then
5475: g_charging_instructions.delete;
5476: end if;

Line 7042: l_tp_no_of_work_days := psp_general.business_days(l_tp_start_date, l_tp_end_date);

7038: open get_units_per_year(control_details_rec.payroll_id);
7039: fetch get_units_per_year into l_no_units_per_year;
7040: close get_units_per_year;
7041:
7042: l_tp_no_of_work_days := psp_general.business_days(l_tp_start_date, l_tp_end_date);
7043: l_sponsor_str := null;
7044:
7045: open get_funding_source_codes(l_tp_start_date);
7046: loop

Line 7054: psp_general.get_configuration_option_value(p_business_group_id,

7050: close get_funding_source_codes;
7051: exit;
7052: end if;
7053: l_sponsor_id :=
7054: psp_general.get_configuration_option_value(p_business_group_id,
7055: 'PSP_SET_SPONSORS_FOR_CAPPING',
7056: l_sponsor_code);
7057: l_sponsor_str := l_sponsor_str ||'@@@'|| l_sponsor_code||rpad(to_char(l_sponsor_id),15);
7058: hr_utility.trace('CDL program --> apply_salary_cap WITHIN LOOP l_sponsor_str= '||l_sponsor_str );

Line 8436: g_dff_grouping_option := psp_general.get_act_dff_grouping_option(g_business_group_id); -- Introduced for bug fix 2908859

8432: --dbms_output.put_line('value of profile is '||g_auto_population);
8433:
8434: g_use_eff_date := FND_PROFILE.VALUE('PSP_USE_NON_ORACLE_EFFECTIVE_DATE'); /* bug 1874696 */
8435:
8436: g_dff_grouping_option := psp_general.get_act_dff_grouping_option(g_business_group_id); -- Introduced for bug fix 2908859
8437:
8438: g_salary_cap_option := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP');
8439: hr_utility.trace('CDL procedure: setting g_cap_element_set_id');
8440: if g_salary_cap_option = 'Y' then

Line 8438: g_salary_cap_option := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP');

8434: g_use_eff_date := FND_PROFILE.VALUE('PSP_USE_NON_ORACLE_EFFECTIVE_DATE'); /* bug 1874696 */
8435:
8436: g_dff_grouping_option := psp_general.get_act_dff_grouping_option(g_business_group_id); -- Introduced for bug fix 2908859
8437:
8438: g_salary_cap_option := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP');
8439: hr_utility.trace('CDL procedure: setting g_cap_element_set_id');
8440: if g_salary_cap_option = 'Y' then
8441: g_cap_element_set_id := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_CAP_ELEMENT_SET_ID');
8442: g_gen_excess_org_id := -- 4744285

Line 8441: g_cap_element_set_id := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_CAP_ELEMENT_SET_ID');

8437:
8438: g_salary_cap_option := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP');
8439: hr_utility.trace('CDL procedure: setting g_cap_element_set_id');
8440: if g_salary_cap_option = 'Y' then
8441: g_cap_element_set_id := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_CAP_ELEMENT_SET_ID');
8442: g_gen_excess_org_id := -- 4744285
8443: psp_general.get_configuration_option_value(g_business_group_id, 'PSP_GENERIC_EXCESS_ACCT_ORG');
8444: end if;
8445: END;

Line 8443: psp_general.get_configuration_option_value(g_business_group_id, 'PSP_GENERIC_EXCESS_ACCT_ORG');

8439: hr_utility.trace('CDL procedure: setting g_cap_element_set_id');
8440: if g_salary_cap_option = 'Y' then
8441: g_cap_element_set_id := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_CAP_ELEMENT_SET_ID');
8442: g_gen_excess_org_id := -- 4744285
8443: psp_general.get_configuration_option_value(g_business_group_id, 'PSP_GENERIC_EXCESS_ACCT_ORG');
8444: end if;
8445: END;
8446:
8447: procedure range_code (pactid IN NUMBER, sqlstr out nocopy varchar2) is

Line 8556: if psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP') = 'Y' then

8552: end loop;
8553:
8554: if sql%rowcount > 0 then
8555:
8556: if psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP') = 'Y' then
8557: l_error_flag := 'N';
8558:
8559: hr_utility.trace('CDL process --> range_code --> source_type, source_code, time_period_id, batch_name = '||
8560: g_source_code||','||g_source_type||','||g_time_period_id||','||g_batch_name);

Line 8570: psp_general.get_configuration_option_value(g_business_group_id,

8566: --fnd_file.put_line(fnd_file.log,' l_begin_dist_date = '||l_begin_dist_date||' , l_end_dist_date='||l_end_dist_date);
8567: hr_utility.trace('CDL process --> range_code --> l_begin_dist_date = '||l_begin_dist_date);
8568:
8569: l_gen_excess_org_id := -- 4744285
8570: psp_general.get_configuration_option_value(g_business_group_id,
8571: 'PSP_GENERIC_EXCESS_ACCT_ORG');
8572: if l_gen_excess_org_id is null then
8573: fnd_message.set_name('PSP','PSP_SET_GEN_EXCESS_ORG');
8574: fnd_msg_pub.add;

Line 8613: l_sponsor_id := psp_general.get_configuration_option_value(g_business_group_id,

8609: end if;
8610:
8611: -- replaced the cursor get_map_sponsor, with following function call
8612: l_sponsor_id := null;
8613: l_sponsor_id := psp_general.get_configuration_option_value(g_business_group_id,
8614: 'PSP_SET_SPONSORS_FOR_CAPPING', l_sponsor_code);
8615: if l_sponsor_id is null then
8616: l_error_flag := 'Y';
8617: fnd_message.set_name('PSP', 'PSP_MAP_SAL_CAP_SPONSOR');