DBA Data[Home] [Help]

APPS.PSP_VALID_NON_ORCL_PKG dependencies on PSP_GENERAL

Line 286: If PSP_General.Business_Days(Import_Cursor_Agg.Sub_Line_Start_Date, Import_Cursor_Agg.Sub_Line_End_Date) = 0

282:
283: If retVal = 0 Then
284: -- Need to check if there is atleast one business day in selected sub_line date range
285: Begin
286: If PSP_General.Business_Days(Import_Cursor_Agg.Sub_Line_Start_Date, Import_Cursor_Agg.Sub_Line_End_Date) = 0
287: AND g_hire_zero_work_days='N' Then --Modified for zero work days build.Bug 1994421.
288: retVal := 24;
289: End If;
290:

Line 408: PSP_General.get_GL_CCID(P_Payroll_ID => v_Payroll_ID, P_Set_Of_Books_ID => n_Set_Of_Books_ID,

404:
405: -- Obtain Cost Allocation Key Flex ID, GL_Code_Combination_ID, and Balance_Amount using
406: -- Venkat's procedure
407:
408: PSP_General.get_GL_CCID(P_Payroll_ID => v_Payroll_ID, P_Set_Of_Books_ID => n_Set_Of_Books_ID,
409: P_Cost_KeyFlex_ID => n_Cost_Allocation_KeyFlex_ID, x_GL_CCID => n_GL_Code_Combination_ID);
410: If n_GL_Code_Combination_ID IS NULL or n_GL_Code_Combination_ID = 0 Then
411: -- fnd_message.debug('GL Code Combination ID is invalid. Cannot proceed');
412: return 21;

Line 535: PSP_General.get_GL_CCID(P_Payroll_ID => v_Payroll_ID, P_Set_Of_Books_ID => v_Set_Of_Books_ID,

531: and v_Effective_Date between Effective_Start_Date and Effective_End_Date
532: and business_group_id = v_business_group_id
533: and gl_set_of_books_id = v_set_of_books_id;
534:
535: PSP_General.get_GL_CCID(P_Payroll_ID => v_Payroll_ID, P_Set_Of_Books_ID => v_Set_Of_Books_ID,
536: P_Cost_KeyFlex_ID => v_Cost_Allocation_KeyFlex_ID, x_GL_CCID => v_GL_CCID);
537:
538: If v_GL_CCID = 0 Then
539: return 21;

Line 838: n_Business_Days := PSP_General.Business_Days(v_Sub_Line_Start_Date, v_Sub_Line_End_Date, v_assignment_id);

834:
835: n_Business_Days Number;
836: Begin
837: /* The following code is added for bug 1994421 ."Zero work days build"*/
838: n_Business_Days := PSP_General.Business_Days(v_Sub_Line_Start_Date, v_Sub_Line_End_Date, v_assignment_id);
839:
840: IF n_Business_Days=0 and v_sub_line_start_date=v_effective_date THEN
841: g_hire_zero_work_days:='Y';
842: IF v_sub_line_start_date<>v_sub_line_end_date THEN