DBA Data[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on PSP_GENERAL

Line 46: psp_general.TRANSACTION_CHANGE_PURGEBLE;

42: BEGIN
43: ---hr_utility.trace_on('Y','SandT');
44: g_error_api_path := '';
45: fnd_msg_pub.initialize;
46: psp_general.TRANSACTION_CHANGE_PURGEBLE;
47:
48: /* Following three variables initialized to faciliate calling mark_batch_end procedure
49: from GL_TIE_BACK procedure: Bug 1929317 */
50:

Line 55: -- g_currency_code := psp_general.get_currency_code(p_business_group_id); -- Commented the following code for Bug 2916848

51: g_source_code := p_source_code;
52: g_batch_name := p_batch_name;
53: g_time_period_id := p_time_period_id;
54: g_payroll_id := p_payroll_id;
55: -- g_currency_code := psp_general.get_currency_code(p_business_group_id); -- Commented the following code for Bug 2916848
56:
57: open autopop_config_cur; -- 5080403
58: fetch autopop_config_cur into g_suspense_autopop;
59: close autopop_config_cur;

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

58: fetch autopop_config_cur into g_suspense_autopop;
59: close autopop_config_cur;
60:
61:
62: g_dff_grouping_option := psp_general.get_act_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
63:
64: mark_batch_begin(p_source_type,
65: p_source_code,
66: p_payroll_id,

Line 436: l_migration_status BOOLEAN:= psp_general.is_effort_report_migrated;

432: retcode varchar2(1000);
433:
434: /* Start of Changes to check for migration before Supercedence */
435:
436: l_migration_status BOOLEAN:= psp_general.is_effort_report_migrated;
437:
438:
439: /* End of Changes to check for migration before Supercedence */
440:

Line 807: psp_general.get_currency_precision(payroll_control_rec.currency_code,l_precision,l_ext_precision);

803: END;
804:
805:
806: -- Made the following call for Bug 2916848 to populate l_precision , l_ext_precision
807: psp_general.get_currency_precision(payroll_control_rec.currency_code,l_precision,l_ext_precision);
808:
809: -- create balancing transactions for GL
810: gl_balance_transaction(payroll_control_rec.source_type,
811: payroll_control_rec.payroll_control_id,

Line 1093: psp_general.get_gms_effective_date(p_person_id,l_gms_posting_effective_date);

1089:
1090: -- Code added for Enhancement Employee Assignment with Zero Work Days
1091: IF P_PROJECT_ID IS NOT NULL THEN
1092: l_gms_posting_effective_date:= p_effective_date;
1093: psp_general.get_gms_effective_date(p_person_id,l_gms_posting_effective_date);
1094: END IF;
1095: -- Code ended for Enhancement Employee Assignment with Zero Work Days
1096:
1097: SELECT PSP_SUMMARY_LINES_S.NEXTVAL

Line 2071: l_return_value := psp_general.find_global_suspense(l_distribution_date,

2067: FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id,l_award_id,l_task_id,
2068: l_exp_org_id, l_expenditure_type;
2069: IF org_susp_ac_cur%NOTFOUND THEN
2070: /* Following code is added for bug 2056877 ,Added validation for generic suspense account */
2071: l_return_value := psp_general.find_global_suspense(l_distribution_date,
2072: p_business_group_id,
2073: p_set_of_books_id,
2074: l_organization_account_id );
2075: /* --------------------------------------------------------------------

Line 2199: /* Bug 1874696: deleted the procedure call for psp_general.poeta_effective_date

2195:
2196: ELSE
2197: l_gl_project_flag := 'P';
2198:
2199: /* Bug 1874696: deleted the procedure call for psp_general.poeta_effective_date
2200: */
2201: l_effective_date := l_distribution_date; --- added for Bug 2663344
2202:
2203: END IF;

Line 3282: l_org_id := psp_general.Get_transaction_org_id (l_project_id,l_expenditure_organization_id);

3278: l_summary_amount := 0 - l_summary_amount;
3279: END IF;
3280:
3281: -- R12 MOAC Uptake
3282: l_org_id := psp_general.Get_transaction_org_id (l_project_id,l_expenditure_organization_id);
3283:
3284: -- insert into summary lines
3285: insert_into_summary_lines(
3286: l_summary_line_id,

Line 3384: l_org_id := psp_general.Get_transaction_org_id (l_project_id,l_expenditure_organization_id);

3380: IF l_rec_count > 1 THEN
3381: -- insert into summary lines
3382:
3383: -- R12 MOAC Uptake
3384: l_org_id := psp_general.Get_transaction_org_id (l_project_id,l_expenditure_organization_id);
3385:
3386: insert_into_summary_lines(
3387: l_summary_line_id,
3388: l_person_id,

Line 4594: l_return_value := psp_general.find_global_suspense(l_distribution_date,

4590: l_exp_org_id, l_expenditure_type;
4591:
4592: IF org_susp_ac_cur%NOTFOUND THEN
4593: /* Following code is added for bug 2056877 ,Added validation for generic suspense account */
4594: l_return_value := psp_general.find_global_suspense(l_distribution_date,
4595: p_business_group_id,
4596: p_set_of_books_id,
4597: l_organization_account_id);
4598: /* --------------------------------------------------------------------

Line 6262: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN

6258: end;';
6259:
6260: --Bug 4319874 START
6261: -- Replacing the Dynamic Sql based on Configuration value
6262: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
6263: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
6264: p_proj_segment => l_proj_segment,
6265: p_tsk_segment => l_tsk_segment,
6266: p_awd_sgement => l_awd_sgement,

Line 6263: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,

6259:
6260: --Bug 4319874 START
6261: -- Replacing the Dynamic Sql based on Configuration value
6262: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
6263: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
6264: p_proj_segment => l_proj_segment,
6265: p_tsk_segment => l_tsk_segment,
6266: p_awd_sgement => l_awd_sgement,
6267: p_exp_org_segment=> l_exp_org_segment,

Line 6315: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN

6311: erd.payroll_percent))) > :l_tolerance_percent;
6312: end;';
6313: --Bug 4319874 START
6314: -- Replacing the Dynamic Sql based on Configuration value
6315: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
6316: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
6317: p_proj_segment => l_proj_segment,
6318: p_tsk_segment => l_tsk_segment,
6319: p_awd_sgement => l_awd_sgement,

Line 6316: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,

6312: end;';
6313: --Bug 4319874 START
6314: -- Replacing the Dynamic Sql based on Configuration value
6315: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
6316: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
6317: p_proj_segment => l_proj_segment,
6318: p_tsk_segment => l_tsk_segment,
6319: p_awd_sgement => l_awd_sgement,
6320: p_exp_org_segment=> l_exp_org_segment,