DBA Data[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on PSP_GENERAL

Line 73: psp_general.TRANSACTION_CHANGE_PURGEBLE;

69:
70: ---hr_utility.trace_on('Y','SandT');
71: g_error_api_path := '';
72: fnd_msg_pub.initialize;
73: psp_general.TRANSACTION_CHANGE_PURGEBLE;
74:
75: /* Following three variables initialized to faciliate calling mark_batch_end procedure
76: from GL_TIE_BACK procedure: Bug 1929317 */
77:

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

78: g_source_code := p_source_code;
79: g_batch_name := p_batch_name;
80: g_time_period_id := p_time_period_id;
81: g_payroll_id := p_payroll_id;
82: -- g_currency_code := psp_general.get_currency_code(p_business_group_id); -- Commented the following code for Bug 2916848
83:
84: open autopop_config_cur; -- 5080403
85: fetch autopop_config_cur into g_suspense_autopop;
86: close autopop_config_cur;

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

90: fetch create_stat_batch_in_gms_cur into g_create_stat_batch_in_gms;
91: close create_stat_batch_in_gms_cur; -- change
92:
93:
94: g_dff_grouping_option := psp_general.get_act_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
95:
96: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' calling mark_batch_begin');
97:
98: mark_batch_begin(p_source_type,

Line 491: l_migration_status BOOLEAN:= psp_general.is_effort_report_migrated;

487: retcode varchar2(1000);
488:
489: /* Start of Changes to check for migration before Supercedence */
490:
491: l_migration_status BOOLEAN:= psp_general.is_effort_report_migrated;
492:
493:
494: /* End of Changes to check for migration before Supercedence */
495:

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

862: END;
863:
864:
865: -- Made the following call for Bug 2916848 to populate l_precision , l_ext_precision
866: psp_general.get_currency_precision(payroll_control_rec.currency_code,l_precision,l_ext_precision);
867:
868: -- create balancing transactions for GL
869: gl_balance_transaction(payroll_control_rec.source_type,
870: payroll_control_rec.payroll_control_id,

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

1172:
1173: -- Code added for Enhancement Employee Assignment with Zero Work Days
1174: IF P_PROJECT_ID IS NOT NULL THEN
1175: l_gms_posting_effective_date:= p_effective_date;
1176: psp_general.get_gms_effective_date(p_person_id,l_gms_posting_effective_date);
1177: END IF;
1178: -- Code ended for Enhancement Employee Assignment with Zero Work Days
1179:
1180: SELECT PSP_SUMMARY_LINES_S.NEXTVAL

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

2194: FETCH org_susp_ac_cur INTO l_organization_account_id,l_susp_glccid,l_project_id,l_award_id,l_task_id,
2195: l_exp_org_id, l_expenditure_type;
2196: IF org_susp_ac_cur%NOTFOUND THEN
2197: /* Following code is added for bug 2056877 ,Added validation for generic suspense account */
2198: l_return_value := psp_general.find_global_suspense(l_distribution_date,
2199: p_business_group_id,
2200: p_set_of_books_id,
2201: l_organization_account_id );
2202: /* --------------------------------------------------------------------

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

2322:
2323: ELSE
2324: l_gl_project_flag := 'P';
2325:
2326: /* Bug 1874696: deleted the procedure call for psp_general.poeta_effective_date
2327: */
2328: l_effective_date := l_distribution_date; --- added for Bug 2663344
2329:
2330: END IF;

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

3465: l_summary_amount := 0 - l_summary_amount;
3466: END IF;
3467:
3468: -- R12 MOAC Uptake
3469: l_org_id := psp_general.Get_transaction_org_id (l_project_id,l_expenditure_organization_id);
3470:
3471: -- insert into summary lines
3472: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling insert_into_summary_lines');
3473:

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

3569: IF l_rec_count > 1 THEN
3570: -- insert into summary lines
3571:
3572: -- R12 MOAC Uptake
3573: l_org_id := psp_general.Get_transaction_org_id (l_project_id,l_expenditure_organization_id);
3574:
3575: insert_into_summary_lines(
3576: l_summary_line_id,
3577: l_person_id,

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

4921: IF org_susp_ac_cur%NOTFOUND THEN
4922: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' org_susp_ac_cur not found for l_orig_org_id1, l_distribution_date'||l_orig_org_id1||','|| l_distribution_date);
4923:
4924: /* Following code is added for bug 2056877 ,Added validation for generic suspense account */
4925: l_return_value := psp_general.find_global_suspense(l_distribution_date,
4926: p_business_group_id,
4927: p_set_of_books_id,
4928: l_organization_account_id);
4929: /* --------------------------------------------------------------------

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

6685: end;';
6686:
6687: --Bug 4319874 START
6688: -- Replacing the Dynamic Sql based on Configuration value
6689: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
6690: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
6691: p_proj_segment => l_proj_segment,
6692: p_tsk_segment => l_tsk_segment,
6693: p_awd_sgement => l_awd_sgement,

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

6686:
6687: --Bug 4319874 START
6688: -- Replacing the Dynamic Sql based on Configuration value
6689: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
6690: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
6691: p_proj_segment => l_proj_segment,
6692: p_tsk_segment => l_tsk_segment,
6693: p_awd_sgement => l_awd_sgement,
6694: p_exp_org_segment=> l_exp_org_segment,

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

6738: erd.payroll_percent))) > :l_tolerance_percent;
6739: end;';
6740: --Bug 4319874 START
6741: -- Replacing the Dynamic Sql based on Configuration value
6742: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
6743: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
6744: p_proj_segment => l_proj_segment,
6745: p_tsk_segment => l_tsk_segment,
6746: p_awd_sgement => l_awd_sgement,

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

6739: end;';
6740: --Bug 4319874 START
6741: -- Replacing the Dynamic Sql based on Configuration value
6742: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
6743: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
6744: p_proj_segment => l_proj_segment,
6745: p_tsk_segment => l_tsk_segment,
6746: p_awd_sgement => l_awd_sgement,
6747: p_exp_org_segment=> l_exp_org_segment,