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_ENC_CREATE_LINES dependencies on PSP_GENERAL

Line 189: g_Org_def_labor_schedule VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');

185: PROCEDURE clear_sch_hierarchy;
186:
187: -- Define Global Variables
188: g_Eff_Date_Value NUMBER;
189: g_Org_def_labor_schedule VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');
190: g_Org_def_account VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');
191: g_dr_cr_flag VARCHAR2(1); /* DEFAULT 'D'; commented for 2530853 */
192: g_enc_line_type VARCHAR2(1);
193: g_business_group_id NUMBER;

Line 190: g_Org_def_account VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');

186:
187: -- Define Global Variables
188: g_Eff_Date_Value NUMBER;
189: g_Org_def_labor_schedule VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');
190: g_Org_def_account VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');
191: g_dr_cr_flag VARCHAR2(1); /* DEFAULT 'D'; commented for 2530853 */
192: g_enc_line_type VARCHAR2(1);
193: g_business_group_id NUMBER;
194: g_set_of_books_id NUMBER;

Line 841: SUM(psp_general.business_days( GREATEST(ptp.start_date, paf.effective_start_date, peev.effective_start_date),

837: CURSOR element_period_amount_cur IS
838: SELECT time_period_id,
839: SUM(period_amount)
840: FROM (SELECT ((MAX(fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0))) *
841: SUM(psp_general.business_days( GREATEST(ptp.start_date, paf.effective_start_date, peev.effective_start_date),
842: LEAST(ptp.end_date, paf.effective_end_date, peev.effective_end_date),p_assignment_id)) ) /
843: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
844: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,
845: ptp.time_period_id

Line 843: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,

839: SUM(period_amount)
840: FROM (SELECT ((MAX(fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0))) *
841: SUM(psp_general.business_days( GREATEST(ptp.start_date, paf.effective_start_date, peev.effective_start_date),
842: LEAST(ptp.end_date, paf.effective_end_date, peev.effective_end_date),p_assignment_id)) ) /
843: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
844: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,
845: ptp.time_period_id
846: FROM pay_element_entry_values_f peev,
847: pay_input_values_f piv,

Line 844: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,

840: FROM (SELECT ((MAX(fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0))) *
841: SUM(psp_general.business_days( GREATEST(ptp.start_date, paf.effective_start_date, peev.effective_start_date),
842: LEAST(ptp.end_date, paf.effective_end_date, peev.effective_end_date),p_assignment_id)) ) /
843: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
844: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,
845: ptp.time_period_id
846: FROM pay_element_entry_values_f peev,
847: pay_input_values_f piv,
848: pay_element_entries_f pee,

Line 1140: /* l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date) -- Bug 9683158

1136: l_period_end_date := r_enc_period.r_period_end_date(I);
1137: l_asg_start_date := r_enc_period.r_asg_start_date(I);
1138: l_asg_end_date := r_enc_period.r_asg_end_date(I);
1139: l_end_date := l_asg_end_date;
1140: /* l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date) -- Bug 9683158
1141: ,l_period_end_date
1142: ,p_assignment_id); */ -- Bug 11930831
1143:
1144: /* l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date), LEAST(l_period_end_date,l_asg_end_date), p_assignment_id); -- Bug 11930831

Line 1144: /* l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date), LEAST(l_period_end_date,l_asg_end_date), p_assignment_id); -- Bug 11930831

1140: /* l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date) -- Bug 9683158
1141: ,l_period_end_date
1142: ,p_assignment_id); */ -- Bug 11930831
1143:
1144: /* l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date), LEAST(l_period_end_date,l_asg_end_date), p_assignment_id); -- Bug 11930831
1145: */ -- Commented for the Bug 12647364
1146: l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id); -- Reverting the change done by 9683158 for the Bug 12647364
1147: l_enc_amount := 0;
1148: l_proc_step:= 60 + (I / 100000);

Line 1146: l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id); -- Reverting the change done by 9683158 for the Bug 12647364

1142: ,p_assignment_id); */ -- Bug 11930831
1143:
1144: /* l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date), LEAST(l_period_end_date,l_asg_end_date), p_assignment_id); -- Bug 11930831
1145: */ -- Commented for the Bug 12647364
1146: l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id); -- Reverting the change done by 9683158 for the Bug 12647364
1147: l_enc_amount := 0;
1148: l_proc_step:= 60 + (I / 100000);
1149:
1150: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

Line 1217: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id));

1213: ELSIF l_inputs(recno).name='ASG_END_DATE' THEN
1214: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_end_date);
1215: hr_utility.trace('Assigned asg_end_date');
1216: ELSIF l_inputs(recno).name='BUS_DAYS_IN_CHUNK' THEN
1217: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id));
1218: hr_utility.trace('Assigned business days in chunk');
1219: ELSIF l_inputs(recno).name='PERIOD_START_DATE' THEN
1220: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_start_date);
1221: hr_utility.trace('Assigned period_start_date');

Line 1226: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id));

1222: ELSIF l_inputs(recno).name='PERIOD_END_DATE' THEN
1223: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_end_date);
1224: hr_utility.trace('Assigned period_end_date');
1225: ELSIF l_inputs(recno).name='BUS_DAYS_IN_PERIOD' THEN
1226: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id));
1227: hr_utility.trace('Assigned business days in period');
1228: ELSIF l_inputs(recno).name='UOM' THEN
1229: l_inputs(recno).value := g_uom;
1230: hr_utility.trace('Assigned UOM');

Line 1245: IF (psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id) > 0) THEN

1241: END IF;
1242: l_calculate_period_amt := FALSE;
1243: l_proc_step:= 90;
1244: ELSE
1245: IF (psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id) > 0) THEN
1246: FOR J IN 1..r_salary_proposal.r_change_date.COUNT
1247: LOOP
1248: IF (l_asg_start_date <= r_salary_proposal.r_effective_end_date(J) AND
1249: l_asg_end_date >= r_salary_proposal.r_effective_start_date(J)) THEN

Line 1269: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);

1265: l_temp_salary := round((l_temp_salary * l_annualization_factor / l_num_per_fiscal_year), g_ext_precision);
1266: END IF;
1267:
1268: l_start_date := GREATEST(l_change_date, l_asg_start_date);
1269: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
1270: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched) / ( l_bus_working_days )), g_ext_precision);
1271:
1272: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1273: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||

Line 1297: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);

1293:
1294: IF (l_element_end_date >= l_asg_start_date) AND (l_element_start_date <= l_asg_end_date) THEN
1295: l_start_date := GREATEST(l_asg_start_date, l_element_start_date);
1296: l_end_date := LEAST(l_asg_end_date, l_element_end_date);
1297: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
1298: l_enc_amount := l_enc_amount + ROUND(((l_pay_amount * l_bus_days_in_sched)/( l_bus_working_days )),g_ext_precision);
1299: END IF;
1300:
1301: hr_utility.trace('l_element_start_date: ' || fnd_date.date_to_canonical(l_element_start_date) ||

Line 1352: /* l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date, p_assignment_id);

1348: l_period_start_date := r_enc_period.r_period_start_date(I);
1349: l_period_end_date := r_enc_period.r_period_end_date(I);
1350: l_change_end_date := l_period_end_date;
1351: l_enc_amount := 0;
1352: /* l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date, p_assignment_id);
1353: --Bug 11930831
1354: */
1355: l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date), LEAST(l_period_end_date,l_asg_end_date), p_assignment_id); -- Bug 11930831
1356: l_end_date := l_period_end_date;

Line 1355: l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date), LEAST(l_period_end_date,l_asg_end_date), p_assignment_id); -- Bug 11930831

1351: l_enc_amount := 0;
1352: /* l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date, p_assignment_id);
1353: --Bug 11930831
1354: */
1355: l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date), LEAST(l_period_end_date,l_asg_end_date), p_assignment_id); -- Bug 11930831
1356: l_end_date := l_period_end_date;
1357: l_period_counter := 0;
1358:
1359: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

Line 1400: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date), 0);

1396: END IF;
1397:
1398: /***** Commented for bug fix 3551561
1399: l_start_date := GREATEST(l_change_date, r_salary_proposal.r_effective_start_date(J), l_period_start_date);
1400: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date), 0);
1401: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched) / ( l_bus_working_days )), g_ext_precision);
1402: End of comment for bug fix 3551561 *****/
1403: -- Introduced for bug fix 3551561
1404:

Line 1412: l_bus_days_in_sched := l_bus_days_in_sched + NVL(psp_general.business_days(l_start_date, l_end_date,p_assignment_id), 0);

1408: l_start_date := GREATEST(l_period_start_date,
1409: r_salary_proposal.r_effective_start_date(l_period_counter), l_change_date);
1410: l_end_date := LEAST(l_period_end_date,
1411: r_salary_proposal.r_effective_end_date(l_period_counter), l_change_end_date);
1412: l_bus_days_in_sched := l_bus_days_in_sched + NVL(psp_general.business_days(l_start_date, l_end_date,p_assignment_id), 0);
1413: EXIT WHEN l_period_counter = r_salary_proposal.r_change_date.COUNT;
1414: EXIT WHEN l_change_date <> r_salary_proposal.r_change_date(l_period_counter + 1);
1415: l_period_counter := l_period_counter + 1;
1416: END LOOP; -- Introduced for bug fix 3673723

Line 1885: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,

1881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: END IF;
1884: ELSE
1885: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,
1886: l_project_id,
1887: l_award_id,
1888: l_task_id,
1889: l_effective_date,

Line 1898: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);

1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895: END IF;
1896:
1897: -- R12 moac uptake. Set the MOAC Context to Single
1898: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);
1899: mo_global.set_policy_context('S', l_org_id);
1900:
1901: pa_transactions_pub.validate_transaction
1902: (x_project_id => l_project_id,

Line 1993: (psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date,

1989: RAISE SUSPENSE_AC_INVALID;
1990: END IF;
1991:
1992: IF ((t_poeta_gl_hier_array(I).r_enc_start_date <= g_enc_org_end_date) AND
1993: (psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date,
1994: t_poeta_gl_hier_array(I).r_enc_end_date) > 0)) THEN
1995: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;
1996: orig_ci.project_id(g_orig_pointer) := l_project_id;
1997: orig_ci.task_id(g_orig_pointer) := l_task_id;

Line 2013: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /

2009: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(p_chunk_pointer);
2010: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2011: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2012: r_enc_period.r_encumbrance_amount(l_enc_period_count) :=
2013: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /
2014: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);
2015: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(p_chunk_pointer);
2016: r_enc_period.r_reason_code(l_enc_period_count) := l_patc_status;
2017: END IF;

Line 2014: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);

2010: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2011: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2012: r_enc_period.r_encumbrance_amount(l_enc_period_count) :=
2013: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /
2014: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);
2015: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(p_chunk_pointer);
2016: r_enc_period.r_reason_code(l_enc_period_count) := l_patc_status;
2017: END IF;
2018: add_cel_warnings(p_start_date => t_poeta_gl_hier_array(I).r_enc_start_date,

Line 2087: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,

2083: END IF;
2084: ELSE
2085: l_dist_amount := t_poeta_gl_hier_array(i).r_amount;
2086:
2087: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,
2088: l_project_id,
2089: l_award_id,
2090: l_task_id,
2091: l_effective_date,

Line 2100: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);

2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: END IF;
2098:
2099: -- R12 moac uptake. Set the MOAC Context to Single
2100: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);
2101: mo_global.set_policy_context('S', l_org_id);
2102:
2103: pa_transactions_pub.validate_transaction
2104: (x_project_id => l_project_id,

Line 2189: (psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date,

2185: RAISE SUSPENSE_AC_INVALID;
2186: END IF;
2187:
2188: IF ((t_poeta_gl_hier_array(I).r_enc_start_date <= g_enc_org_end_date) AND
2189: (psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date,
2190: t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id) > 0)) THEN
2191: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;
2192: orig_ci.project_id(g_orig_pointer) := l_project_id;
2193: orig_ci.task_id(g_orig_pointer) := l_task_id;

Line 2209: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /

2205: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(p_chunk_pointer);
2206: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2207: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2208: r_enc_period.r_encumbrance_amount(l_enc_period_count) :=
2209: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /
2210: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);
2211: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(p_chunk_pointer);
2212: r_enc_period.r_reason_code(l_enc_period_count) := l_patc_status;
2213: END IF;

Line 2210: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);

2206: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2207: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2208: r_enc_period.r_encumbrance_amount(l_enc_period_count) :=
2209: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /
2210: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);
2211: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(p_chunk_pointer);
2212: r_enc_period.r_reason_code(l_enc_period_count) := l_patc_status;
2213: END IF;
2214:

Line 2338: (psp_general.business_days(r_enc_period.r_period_start_date(1),

2334: l_max_end_date := LEAST(r_enc_period.r_asg_end_date(r_enc_period.r_asg_end_date.COUNT),
2335: l_max_end_date);
2336:
2337: IF ( (l_min_start_date > r_enc_period.r_period_start_date(1)) AND
2338: (psp_general.business_days(r_enc_period.r_period_start_date(1),
2339: r_enc_period.r_period_end_date(1),p_assignment_id) <>
2340: psp_general.business_days(l_min_start_date,
2341: r_enc_period.r_period_end_date(1),p_assignment_id))) THEN
2342: l_ignore_start := r_enc_period.r_time_period_id(1);

Line 2340: psp_general.business_days(l_min_start_date,

2336:
2337: IF ( (l_min_start_date > r_enc_period.r_period_start_date(1)) AND
2338: (psp_general.business_days(r_enc_period.r_period_start_date(1),
2339: r_enc_period.r_period_end_date(1),p_assignment_id) <>
2340: psp_general.business_days(l_min_start_date,
2341: r_enc_period.r_period_end_date(1),p_assignment_id))) THEN
2342: l_ignore_start := r_enc_period.r_time_period_id(1);
2343: END IF;
2344:

Line 2346: (psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT),

2342: l_ignore_start := r_enc_period.r_time_period_id(1);
2343: END IF;
2344:
2345: IF ( (l_max_end_date < r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) AND
2346: (psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT),
2347: r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) <>
2348: psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT), l_max_end_date))) THEN
2349: l_ignore_end := r_enc_period.r_time_period_id(r_enc_period.r_asg_end_date.COUNT);
2350: END IF;

Line 2348: psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT), l_max_end_date))) THEN

2344:
2345: IF ( (l_max_end_date < r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) AND
2346: (psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT),
2347: r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) <>
2348: psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT), l_max_end_date))) THEN
2349: l_ignore_end := r_enc_period.r_time_period_id(r_enc_period.r_asg_end_date.COUNT);
2350: END IF;
2351: hr_utility.trace('l_ignore_start: ' || l_ignore_start);
2352: hr_utility.trace('l_ignore_end: ' || l_ignore_end);

Line 2368: l_bus_days_in_chunk := psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id);

2364: l_period_ind := r_enc_period.r_period_ind(l_chunk_pointer);
2365: l_effective_date := r_enc_period.r_effective_date(l_chunk_pointer);
2366: l_reason_code := r_enc_period.r_reason_code(l_chunk_pointer);
2367:
2368: l_bus_days_in_chunk := psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id);
2369: l_dist_amount := 0;
2370: l_schedule_line_id := NULL;
2371: l_org_schedule_id := NULL;
2372: l_element_account_id := NULL;

Line 2477: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2473: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2474: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2475: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2476: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2477: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2478: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2479: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2480: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2481: END IF;

Line 2598: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2594: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2595: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2596: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2597: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2598: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2599: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2600: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2601: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2602: END IF;

Line 2719: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2715: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2716: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2717: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2718: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2719: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2720: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2721: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2722: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2723: END IF;

Line 2848: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2844: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2845: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2846: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2847: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2848: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2849: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2850: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2851: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2852: END IF;

Line 2975: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2971: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2972: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2973: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2974: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2975: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2976: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2977: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2978: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2979: END IF;

Line 3104: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

3100: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
3101: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
3102: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
3103: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
3104: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
3105: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
3106: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
3107: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
3108: END IF;

Line 3264: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);

3260: fnd_message.set_token('AW', l_award_number);
3261: fnd_message.set_token('EO', l_exp_org_name);
3262: fnd_message.set_token('ET', l_expenditure_type);
3263: ELSE
3264: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3265: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3266: fnd_message.set_token('GL', l_gl_description);
3267: END IF;
3268: fnd_message.set_token('START_DATE', l_asg_start_date);

Line 3843: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);

3839: END IF;
3840: END IF;
3841: END IF; --Main IF :2317856
3842:
3843: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);
3844: IF l_bus_days_in_period = 0 THEN
3845: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3846: fnd_message.set_token('START_DATE', p_asg_start_date);
3847: fnd_message.set_token('END_DATE', p_asg_end_date);

Line 3854: l_bus_days_in_schedules := PSP_GENERAL.BUSINESS_DAYS(p_poeta_gl_hier_array(j).r_enc_start_date, p_poeta_gl_hier_array(j).r_enc_end_date,p_assignment_id);

3850: END IF;
3851:
3852: For j in 1 .. p_poeta_gl_hier_array.COUNT
3853: LOOP
3854: l_bus_days_in_schedules := PSP_GENERAL.BUSINESS_DAYS(p_poeta_gl_hier_array(j).r_enc_start_date, p_poeta_gl_hier_array(j).r_enc_end_date,p_assignment_id);
3855: p_poeta_gl_hier_array(j).r_amount :=
3856: round(((p_asg_amount * l_bus_days_in_schedules) / l_bus_days_in_period),g_ext_precision);
3857: -- Introduced rounding for Bug 2916848 Ilo Mrc Ehnc.
3858: END LOOP;

Line 6722: psp_general.add_report_error

6718: IF (SQL%ROWCOUNT = 0) THEN
6719: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');
6720: g_warning_message := fnd_message.get;
6721: fnd_file.put_line(fnd_file.log, g_warning_message);
6722: psp_general.add_report_error
6723: (p_request_id => l_request_id,
6724: p_message_level => 'N',
6725: p_source_id => NULL,
6726: p_source_name => NULL,

Line 7127: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));

7123: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
7124: g_warning_message := fnd_message.get;
7125: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
7126: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
7127: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
7128: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
7129: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
7130: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
7131: fnd_message.set_token('GL', l_gl_description);

Line 7207: psp_general.add_report_error

7203: END IF;
7204: g_warning_message := fnd_message.get;
7205: END IF;
7206:
7207: psp_general.add_report_error
7208: (p_request_id => g_request_id,
7209: p_message_level => 'W',
7210: p_source_id => l_assignment_id,
7211: p_source_name => l_assignment_number,

Line 7251: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(l_business_group_id);

7247: g_business_group_id := l_business_group_id;
7248: g_enc_line_type := 'U';
7249: g_package_name := 'PSP_ENC_CREATE_LINES.';
7250: g_payroll_action_id := p_payroll_action_id;
7251: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(l_business_group_id);
7252:
7253: OPEN cel_request_id_cur;
7254: FETCH cel_request_id_cur INTO g_request_id;
7255: CLOSE cel_request_id_cur;

Line 7292: g_currency_code := psp_general.get_currency_code(l_business_group_id);

7288: l_enc_create_lines := 1;
7289: l_enclines_index := 1;
7290: l_enc_create := 1;
7291: l_pre_process_mode:= 'R';
7292: g_currency_code := psp_general.get_currency_code(l_business_group_id);
7293: psp_general.get_currency_precision(g_currency_code,g_precision,g_ext_precision);
7294: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_line_type: U
7295: g_request_id: ' || g_request_id || '
7296: g_payroll_action_id: ' || g_payroll_action_id || '

Line 7293: psp_general.get_currency_precision(g_currency_code,g_precision,g_ext_precision);

7289: l_enclines_index := 1;
7290: l_enc_create := 1;
7291: l_pre_process_mode:= 'R';
7292: g_currency_code := psp_general.get_currency_code(l_business_group_id);
7293: psp_general.get_currency_precision(g_currency_code,g_precision,g_ext_precision);
7294: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_line_type: U
7295: g_request_id: ' || g_request_id || '
7296: g_payroll_action_id: ' || g_payroll_action_id || '
7297: g_currency_code: ' || g_currency_code || '

Line 7473: psp_general.get_currency_precision('STAT',g_precision,g_ext_precision);

7469: CLOSE hours_value_cur;
7470:
7471: IF (l_hours_value > 0) THEN
7472: g_uom := 'H';
7473: psp_general.get_currency_precision('STAT',g_precision,g_ext_precision);
7474: OPEN c_max_enc_date(l_assignment_id, l_element_type_id, l_enc_begin_date);
7475: FETCH c_max_enc_date INTO l_enc_create, l_max_enc_hist_date;
7476: CLOSE c_max_enc_date;
7477:

Line 7692: psp_general.add_report_error

7688: OPEN element_name_cur;
7689: FETCH element_name_cur INTO l_element_name;
7690: CLOSE element_name_cur;
7691:
7692: psp_general.add_report_error
7693: (p_request_id => g_request_id,
7694: p_message_level => 'E',
7695: p_source_id => l_assignment_id,
7696: p_source_name => l_assignment_number,

Line 7709: psp_general.add_report_error

7705: p_value3 => l_element_type_id,
7706: p_information3 => l_element_name,
7707: p_return_status => l_return_status);
7708: ELSE
7709: psp_general.add_report_error
7710: (p_request_id => g_request_id,
7711: p_message_level => 'E',
7712: p_source_id => NULL,
7713: p_source_name => NULL,

Line 9014: IF (l_new_cust = 0 AND psp_general.start_capturing_updates(l_business_group_id) = 'N') THEN

9010: END IF;
9011: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_enc_begin_date: ' || fnd_date.date_to_canonical(l_enc_begin_date));
9012:
9013: l_pre_process_mode := 'R';
9014: IF (l_new_cust = 0 AND psp_general.start_capturing_updates(l_business_group_id) = 'N') THEN
9015: l_pre_process_mode := 'F';
9016: END IF;
9017:
9018: psp_enc_pre_process.poeta_pre_process

Line 9676: psp_general.add_report_error

9672: CLOSE org_name_cur;
9673: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_organization_name: '||l_organization_name);
9674:
9675:
9676: psp_general.add_report_error
9677: (p_request_id => l_request_id,
9678: p_message_level => 'N',
9679: p_source_id => l_assignment_id,
9680: p_source_name => l_assignment_number,

Line 9755: psp_general.add_report_error

9751: OPEN org_name_cur;
9752: FETCH org_name_cur INTO l_organization_name;
9753: CLOSE org_name_cur;
9754:
9755: psp_general.add_report_error
9756: (p_request_id => l_request_id,
9757: p_message_level => 'N',
9758: p_source_id => l_assignment_id,
9759: p_source_name => l_assignment_number,

Line 9823: psp_general.add_report_error

9819: OPEN org_name_cur;
9820: FETCH org_name_cur INTO l_organization_name;
9821: CLOSE org_name_cur;
9822:
9823: psp_general.add_report_error
9824: (p_request_id => l_request_id,
9825: p_message_level => 'N',
9826: p_source_id => l_assignment_id,
9827: p_source_name => l_assignment_number,

Line 9892: psp_general.add_report_error

9888: OPEN org_name_cur;
9889: FETCH org_name_cur INTO l_organization_name;
9890: CLOSE org_name_cur;
9891:
9892: psp_general.add_report_error
9893: (p_request_id => l_request_id,
9894: p_message_level => 'N',
9895: p_source_id => l_assignment_id,
9896: p_source_name => l_assignment_number,

Line 9961: psp_general.add_report_error

9957: OPEN org_name_cur;
9958: FETCH org_name_cur INTO l_organization_name;
9959: CLOSE org_name_cur;
9960:
9961: psp_general.add_report_error
9962: (p_request_id => l_request_id,
9963: p_message_level => 'N',
9964: p_source_id => l_assignment_id,
9965: p_source_name => l_assignment_number,

Line 10030: psp_general.add_report_error

10026: OPEN org_name_cur;
10027: FETCH org_name_cur INTO l_organization_name;
10028: CLOSE org_name_cur;
10029:
10030: psp_general.add_report_error
10031: (p_request_id => l_request_id,
10032: p_message_level => 'N',
10033: p_source_id => l_assignment_id,
10034: p_source_name => l_assignment_number,