APPS.PQH_PSP_INTEGRATION dependencies on PSP_PQH_INTEGRATION

Line 27: p_assg_ele_tab IN psp_pqh_integration.assignment_enc_ld_col

23: */
24:
25: Procedure get_distinct_assignments
26: (
27: p_assg_ele_tab IN psp_pqh_integration.assignment_enc_ld_col
28: ) IS
29: --
30: Cursor csr_period_date(p_time_period_id in number) is
31: Select start_date,end_date

Line 200: l_versions_tab OUT NOCOPY PSP_PQH_INTEGRATION.t_num_15_type

196: positions may belong to same budget version.
197: */
198: Procedure get_budget_versions
199: (
200: l_versions_tab OUT NOCOPY PSP_PQH_INTEGRATION.t_num_15_type
201: ) IS
202: --
203: -----------------------Cursors----------------------------------------------------
204: Cursor csr_position_budget(p_position_id NUMBER,

Line 461: l_assignment_enc_ld_table psp_pqh_integration.assignment_enc_ld_col;

457:
458: PROCEDURE relieve_budget_commitments( p_calling_process IN VARCHAR2,
459: p_return_status OUT NOCOPY VARCHAR2) IS
460: --
461: l_assignment_enc_ld_table psp_pqh_integration.assignment_enc_ld_col;
462: l_distinct_assignment_table t_assignment_budget_tab;
463: l_encumbered_positions_table PSP_PQH_INTEGRATION.t_num_15_type;
464: l_budget_versions_table PSP_PQH_INTEGRATION.t_num_15_type;
465: l_psp_encumbered BOOLEAN;

Line 463: l_encumbered_positions_table PSP_PQH_INTEGRATION.t_num_15_type;

459: p_return_status OUT NOCOPY VARCHAR2) IS
460: --
461: l_assignment_enc_ld_table psp_pqh_integration.assignment_enc_ld_col;
462: l_distinct_assignment_table t_assignment_budget_tab;
463: l_encumbered_positions_table PSP_PQH_INTEGRATION.t_num_15_type;
464: l_budget_versions_table PSP_PQH_INTEGRATION.t_num_15_type;
465: l_psp_encumbered BOOLEAN;
466: l_return_status varchar2(2);
467: l_proc varchar2(72) := g_package||'relieve_budget_commitments';

Line 464: l_budget_versions_table PSP_PQH_INTEGRATION.t_num_15_type;

460: --
461: l_assignment_enc_ld_table psp_pqh_integration.assignment_enc_ld_col;
462: l_distinct_assignment_table t_assignment_budget_tab;
463: l_encumbered_positions_table PSP_PQH_INTEGRATION.t_num_15_type;
464: l_budget_versions_table PSP_PQH_INTEGRATION.t_num_15_type;
465: l_psp_encumbered BOOLEAN;
466: l_return_status varchar2(2);
467: l_proc varchar2(72) := g_package||'relieve_budget_commitments';
468: l_err varchar2(100);

Line 475: PSP_PQH_INTEGRATION.GET_ENCUMBRANCE_DETAILS(

471: --
472: BEGIN
473:
474: hr_utility.set_location('Entering: '||l_proc, 5);
475: PSP_PQH_INTEGRATION.GET_ENCUMBRANCE_DETAILS(
476: P_CALLING_PROCESS =>p_calling_process,
477: P_ASSIGNMENT_ENC_LD_TABLE =>l_assignment_enc_ld_table,
478: P_PSP_ENCUMBERED =>l_psp_encumbered,
479: P_RETURN_STATUS =>l_return_status);