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

Line 89: l_action_parameter_group VARCHAR2(30) := psp_general.get_specific_profile('ACTION_PARAMETER_GROUPS'); -- added for bug 6661707

85: l_subline_message varchar2(200);
86: l_TGL_REVB_ACC_DATE varchar2(80); -- added for 3108109
87: l_TGL_DATE_USED varchar2(80); -- added for 3108109
88: l_prev_accounting_date date := to_date('01/01/1900','dd/mm/yyyy'); -- added for 3108109
89: l_action_parameter_group VARCHAR2(30) := psp_general.get_specific_profile('ACTION_PARAMETER_GROUPS'); -- added for bug 6661707
90:
91: --- added following 2 cursors for 3108109
92: --- modified the below 2 cursors for bug 6661707
93:

Line 692: g_bg_currency_code := psp_general.get_currency_code(l_resp_business_group_id);

688: close get_set_of_books_csr;
689: End of comment for bug fix 3098050 *****/
690:
691: -- Introduced the following for bug fix 3107800
692: g_bg_currency_code := psp_general.get_currency_code(l_resp_business_group_id);
693:
694: OPEN sob_currency_code_cur;
695: FETCH sob_currency_code_cur INTO g_sob_currency_code;
696: CLOSE sob_currency_code_cur;

Line 777: l_return_value := psp_general.find_global_suspense(l_end_date,

773:
774: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_clearing_account ='||l_clearing_account );
775:
776: /* Following code is added for bug 2056877 ,Added validation for generic suspense account */
777: l_return_value := psp_general.find_global_suspense(l_end_date,
778: l_resp_business_group_id,
779: l_resp_set_of_books_id,
780: l_organization_account_id );
781: /* --------------------------------------------------------------------

Line 1282: psp_general.get_currency_precision(g_pay_costs_rec.output_currency_code,

1278:
1279: l_total_num_rec:= l_total_num_rec + 1;
1280: l_cur_rec:= l_total_num_rec;
1281:
1282: psp_general.get_currency_precision(g_pay_costs_rec.output_currency_code,
1283: g_precision,
1284: g_ext_precision);
1285:
1286: r_payroll_control_array.r_currency_code(l_cur_rec) := g_pay_costs_rec.output_currency_code;

Line 1351: PSP_GENERAL.GET_GL_CCID(

1347: l_parent_control_id := l_export_id;
1348: end if;
1349:
1350:
1351: PSP_GENERAL.GET_GL_CCID(
1352: P_PAYROLL_ID => l_payroll_id,
1353: P_SET_OF_BOOKS_ID => l_resp_set_of_books_id,
1354: P_COST_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1355: X_GL_CCID => l_gl_ccid);

Line 1364: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);

1360: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1361: fnd_msg_pub.add;
1362: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_gl_ccid <> l_clearing_account then
1364: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1365: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1366: l_error_api_name := 'GET_GL_CCID : ';
1367: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1368: fnd_message.set_token('GL_ACCOUNT', l_gl_value);

Line 1365: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);

1361: fnd_msg_pub.add;
1362: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_gl_ccid <> l_clearing_account then
1364: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1365: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1366: l_error_api_name := 'GET_GL_CCID : ';
1367: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1368: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1369: fnd_message.set_token('CLEARING', l_clearing_account_value);

Line 1384: psp_general.get_gms_effective_date(l_person_id, l_gms_posting_date);

1380: -- intro this IF-ENDIF and changed the next IF stmt to check gms_posting_date for 2426343
1381: If g_non_active_flag = 'Y' then
1382: -- date earned will be the max date any child sub line can take as effective date.
1383: l_gms_posting_date := g_pay_costs_rec.date_earned;
1384: psp_general.get_gms_effective_date(l_person_id, l_gms_posting_date);
1385:
1386: IF l_gms_posting_date is null then
1387: select distinct substr(full_name,1,50)
1388: into l_employee_name

Line 2071: SELECT DECODE(psp_general.business_days(g_start_date + (ROWNUM-1), g_start_date + (ROWNUM-1), p_assignment_id), 1, 'Y', 'N')

2067: End of comment for work schedules enh. *****/
2068:
2069: PROCEDURE create_working_calendar (p_assignment_id IN NUMBER) IS
2070: CURSOR business_days_cur IS
2071: SELECT DECODE(psp_general.business_days(g_start_date + (ROWNUM-1), g_start_date + (ROWNUM-1), p_assignment_id), 1, 'Y', 'N')
2072: FROM DUAL
2073: CONNECT BY 1=1
2074: AND ROWNUM <= (g_end_date + 1) - g_start_date;
2075: BEGIN

Line 2080: g_no_of_work_days := psp_general.business_days(g_start_date, g_end_date, p_assignment_id);

2076: OPEN business_days_cur;
2077: FETCH business_days_cur BULK COLLECT INTO work_calendar;
2078: CLOSE business_days_cur;
2079:
2080: g_no_of_work_days := psp_general.business_days(g_start_date, g_end_date, p_assignment_id);
2081: g_no_of_days := work_calendar.COUNT;
2082:
2083: IF ((g_start_date = g_end_date) AND (NVL(g_entry_date_earned,g_start_date) = g_start_date)) THEN
2084: g_no_of_work_days := 1;

Line 7477: l_fte_option_value :=psp_general.get_specific_profile('PSP_FTE_OPTIONS');

7473:
7474: begin
7475: hr_utility.trace(' Entering CREATE_SLINE_FTE_CHANGE');
7476: -- l_fte_option_value := FND_PROFILE.VALue('PSP_FTE_OPTIONS');
7477: l_fte_option_value :=psp_general.get_specific_profile('PSP_FTE_OPTIONS');
7478: if NVL(l_fte_option_value,' ') = 'BUDGET_VALUES' or l_fte_option_value IS NULL then
7479: x_return_status := FND_API.G_RET_STS_SUCCESS;
7480: return;
7481: end if;

Line 7484: l_fte_value:=psp_general.get_specific_profile('PSP_FTE_ATTRIBUTE');

7480: return;
7481: end if;
7482: ----dbms_output.PUT_LINE('Crossed First if of FTE Change... '|| l_fte_option_value );
7483: -- l_fte_value := FND_PROFILE.VALUE('PSP_FTE_ATTRIBUTE');
7484: l_fte_value:=psp_general.get_specific_profile('PSP_FTE_ATTRIBUTE');
7485: if l_fte_value IS NULL then
7486: x_return_status := FND_API.G_RET_STS_SUCCESS;
7487: return;
7488: end if;

Line 8168: -- l_fte_option_value:= psp_general.get_specific_profile('PSP_FTE_OPTIONS'); Commented for bug 4055483

8164:
8165:
8166: begin
8167: -- l_fte_option_value := FND_PROFILE.value('PSP_FTE_OPTIONS');
8168: -- l_fte_option_value:= psp_general.get_specific_profile('PSP_FTE_OPTIONS'); Commented for bug 4055483
8169: /*
8170: Commented for Bug 4055483
8171: if l_fte_option_value IS NULL or l_fte_option_value <> 'BUDGET_VALUES' then
8172: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8776: IF (psp_general.business_days(l_effective_start_date, l_effective_start_date, x_assignment_id) = 0) THEN

8772:
8773: /*Bug 5557724: to_char(some_date,'D') returns a number indicating the weekday. However, for a given date, this number
8774: returned varies with NLS_TERRITORY. So replaced it with to_char(some_date,'DY') that gives the abbreviated day. */
8775: -- IF to_char(l_effective_start_date,'DY', 'nls_date_language=english') IN ('SUN','SAT') THEN
8776: IF (psp_general.business_days(l_effective_start_date, l_effective_start_date, x_assignment_id) = 0) THEN
8777: hr_utility.trace(' assignment starts in non working day = '||x_assignment_id);
8778: g_hire_zero_work_days := 'Y';
8779: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8780: return;

Line 8785: IF trunc(x_end_date) - trunc(x_start_date) <= 1 AND psp_general.business_days(trunc(x_start_date), trunc(x_end_date)) <= 0 THEN

8781: END IF;
8782: -- End of the changes -lveerubh
8783:
8784: /*Bug 5642002: Added element only on Sat Sun condition*/
8785: IF trunc(x_end_date) - trunc(x_start_date) <= 1 AND psp_general.business_days(trunc(x_start_date), trunc(x_end_date)) <= 0 THEN
8786: g_all_holiday_zero_work_days := 'Y';
8787: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8788: return;
8789: END IF;

Line 8977: l_business_days := psp_general.business_days(l_start_date, l_end_date);

8973: i := 1;
8974: l_start_date := g_start_date;
8975: END IF;
8976: hr_utility.trace(' l_st_dt, l_end_dt =' ||l_start_date ||','|| l_end_date);
8977: l_business_days := psp_general.business_days(l_start_date, l_end_date);
8978: hr_utility.trace(' l_business_days , g_no_of_days='|| l_business_days||','||g_no_of_days);
8979:
8980: IF (l_business_days = 0) THEN
8981: l_non_working_day_flag := 1;