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: NO_COST_DATA_FOUND EXCEPTION;
91: --- added following 2 cursors for 3108109
92: --- modified the below 2 cursors for bug 6661707
93:

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

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

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

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

Line 1321: psp_general.get_currency_precision(g_pay_costs_rec.output_currency_code,

1317:
1318: l_total_num_rec:= l_total_num_rec + 1;
1319: l_cur_rec:= l_total_num_rec;
1320:
1321: psp_general.get_currency_precision(g_pay_costs_rec.output_currency_code,
1322: g_precision,
1323: g_ext_precision);
1324:
1325: r_payroll_control_array.r_currency_code(l_cur_rec) := g_pay_costs_rec.output_currency_code;

Line 1390: PSP_GENERAL.GET_GL_CCID(

1386: l_parent_control_id := l_export_id;
1387: end if;
1388:
1389:
1390: PSP_GENERAL.GET_GL_CCID(
1391: P_PAYROLL_ID => l_payroll_id,
1392: P_SET_OF_BOOKS_ID => l_resp_set_of_books_id,
1393: P_COST_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1394: X_GL_CCID => l_gl_ccid);

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

1399: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1400: fnd_msg_pub.add;
1401: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1402: ELSIF l_gl_ccid <> l_clearing_account then
1403: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1404: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1405: l_error_api_name := 'GET_GL_CCID : ';
1406: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1407: fnd_message.set_token('GL_ACCOUNT', l_gl_value);

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

1400: fnd_msg_pub.add;
1401: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1402: ELSIF l_gl_ccid <> l_clearing_account then
1403: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1404: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1405: l_error_api_name := 'GET_GL_CCID : ';
1406: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1407: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1408: fnd_message.set_token('CLEARING', l_clearing_account_value);

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

1424:
1425: l_gms_posting_date := g_pay_costs_rec.date_earned;
1426: hr_utility.trace('l_gms_posting_date = '||l_gms_posting_date);
1427:
1428: psp_general.get_gms_effective_date(l_person_id, l_gms_posting_date);
1429: hr_utility.trace('After proc call - l_gms_posting_date = '||l_gms_posting_date);
1430:
1431: IF l_gms_posting_date is null then
1432:

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

2141: End of comment for work schedules enh. *****/
2142:
2143: PROCEDURE create_working_calendar (p_assignment_id IN NUMBER) IS
2144: CURSOR business_days_cur IS
2145: SELECT DECODE(psp_general.business_days(g_start_date + (ROWNUM-1), g_start_date + (ROWNUM-1), p_assignment_id), 1, 'Y', 'N')
2146: FROM DUAL
2147: CONNECT BY 1=1
2148: AND ROWNUM <= (g_end_date + 1) - g_start_date;
2149: BEGIN

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

2150: OPEN business_days_cur;
2151: FETCH business_days_cur BULK COLLECT INTO work_calendar;
2152: CLOSE business_days_cur;
2153:
2154: g_no_of_work_days := psp_general.business_days(g_start_date, g_end_date, p_assignment_id);
2155: g_no_of_days := work_calendar.COUNT;
2156:
2157: IF ((g_start_date = g_end_date) AND (NVL(g_entry_date_earned,g_start_date) = g_start_date)) THEN
2158: g_no_of_work_days := 1;

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

7547:
7548: begin
7549: hr_utility.trace(' Entering CREATE_SLINE_FTE_CHANGE');
7550: -- l_fte_option_value := FND_PROFILE.VALue('PSP_FTE_OPTIONS');
7551: l_fte_option_value :=psp_general.get_specific_profile('PSP_FTE_OPTIONS');
7552: if NVL(l_fte_option_value,' ') = 'BUDGET_VALUES' or l_fte_option_value IS NULL then
7553: x_return_status := FND_API.G_RET_STS_SUCCESS;
7554: return;
7555: end if;

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

7554: return;
7555: end if;
7556: ----dbms_output.PUT_LINE('Crossed First if of FTE Change... '|| l_fte_option_value );
7557: -- l_fte_value := FND_PROFILE.VALUE('PSP_FTE_ATTRIBUTE');
7558: l_fte_value:=psp_general.get_specific_profile('PSP_FTE_ATTRIBUTE');
7559: if l_fte_value IS NULL then
7560: x_return_status := FND_API.G_RET_STS_SUCCESS;
7561: return;
7562: end if;

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

8238:
8239:
8240: begin
8241: -- l_fte_option_value := FND_PROFILE.value('PSP_FTE_OPTIONS');
8242: -- l_fte_option_value:= psp_general.get_specific_profile('PSP_FTE_OPTIONS'); Commented for bug 4055483
8243: /*
8244: Commented for Bug 4055483
8245: if l_fte_option_value IS NULL or l_fte_option_value <> 'BUDGET_VALUES' then
8246: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

8846:
8847: /*Bug 5557724: to_char(some_date,'D') returns a number indicating the weekday. However, for a given date, this number
8848: returned varies with NLS_TERRITORY. So replaced it with to_char(some_date,'DY') that gives the abbreviated day. */
8849: -- IF to_char(l_effective_start_date,'DY', 'nls_date_language=english') IN ('SUN','SAT') THEN
8850: IF (psp_general.business_days(l_effective_start_date, l_effective_start_date, x_assignment_id) = 0) THEN
8851: hr_utility.trace(' assignment starts in non working day = '||x_assignment_id);
8852: g_hire_zero_work_days := 'Y';
8853: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8854: return;

Line 8859: 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

8855: END IF;
8856: -- End of the changes -lveerubh
8857:
8858: /*Bug 5642002: Added element only on Sat Sun condition*/
8859: 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
8860: g_all_holiday_zero_work_days := 'Y';
8861: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8862: return;
8863: END IF;

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

9047: i := 1;
9048: l_start_date := g_start_date;
9049: END IF;
9050: hr_utility.trace(' l_st_dt, l_end_dt =' ||l_start_date ||','|| l_end_date);
9051: l_business_days := psp_general.business_days(l_start_date, l_end_date);
9052: hr_utility.trace(' l_business_days , g_no_of_days='|| l_business_days||','||g_no_of_days);
9053:
9054: IF (l_business_days = 0) THEN
9055: l_non_working_day_flag := 1;