DBA Data[Home] [Help]

APPS.PA_FP_PJI_INTG_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 52: * NOTE: BEFORE CALLING THIS API, a record must exists in pa_resource_assignments for the p_resource_assignment_id

48: * p_start_date BudgetLine StartDate
49: * p_end_date BudgetLine Enddate
50: * If activity = 'UPDATE' then all the amounts and currency columns must be passed
51: * if activity = 'DELETE' then -ve budgetLine amounts will be selected from DB and passed in params will be ignored
52: * NOTE: BEFORE CALLING THIS API, a record must exists in pa_resource_assignments for the p_resource_assignment_id
53: * AND CALL THIS API ONLY IF THERE ARE NO REJECTION CODES STAMPED ON THE BUDGET LINES
54: * NOTE: As of IPM, we ignore rejection codes stamped on budget lines for the purpose of updating PJI data.
55: */
56: PROCEDURE update_reporting_lines

Line 116: ,pa_resource_assignments ra

112: ,ra.rate_based_flag
113: FROM pa_projects_all ppa
114: ,pa_budget_versions pbv
115: ,pa_proj_fp_options ppfo
116: ,pa_resource_assignments ra
117: WHERE ppa.project_id = pbv.project_id
118: AND pbv.budget_version_id = ppfo.fin_plan_version_id
119: AND pbv.budget_version_id = p_budget_version_id
120: AND ra.resource_assignment_id = p_resource_assignment_id

Line 434: * NOTE: BEFORE CALLING THIS API, a record must exists in pa_resource_assignments for the p_resource_assignment_id

430: * p_activity_code 'UPDATE',/'DELETE'
431: * p_calling_module name of API, for ex: 'CALCULATE_API'
432: * If activity = 'UPDATE' then +ve budgetLine amounts will be selected from DB
433: * if activity = 'DELETE' then -ve budgetLine amounts will be selected from DB
434: * NOTE: BEFORE CALLING THIS API, a record must exists in pa_resource_assignments for the p_resource_assignment_id
435: * AND a budget line must exists for the given p_budget_line_id
436: */
437: PROCEDURE update_reporting_lines_frombl
438: (p_calling_module IN Varchar2 Default 'CALCULATE_API'

Line 546: * NOTE: BEFORE CALLING THIS API, a record must exists in pa_resource_assignments for the p_resource_assignment_id

542: * p_start_date BudgetLine StartDate
543: * p_end_date BudgetLine Enddate
544: * If activity = 'UPDATE' then all the amounts and currency columns must be passed
545: * if activity = 'DELETE' then -ve budgetLine amounts will be selected from DB and passed in params will be ignored
546: * NOTE: BEFORE CALLING THIS API, a record must exists in pa_resource_assignments for the p_resource_assignment_id
547: * AND CALL THIS API ONLY IF THERE ARE NO REJECTION CODES STAMPED ON THE BUDGET LINES
548: * NOTE: As of IPM, we ignore rejection codes stamped on budget lines for the purpose of updating PJI data.
549: * THIS API IS CREATED FOR BULK PROCESS OF DATA.
550: * NOTE: ALL PARAMS MUST BE PASSED , passing Null or incomplete params will error out

Line 989: ,pa_resource_assignments ra

985: ,l_time_phase_code
986: FROM pa_projects_all ppa
987: ,pa_budget_versions pbv
988: ,pa_proj_fp_options ppfo
989: ,pa_resource_assignments ra
990: WHERE ppa.project_id = pbv.project_id
991: AND pbv.budget_version_id = ppfo.fin_plan_version_id
992: AND pbv.budget_version_id = p_budget_version_id
993: AND ra.resource_assignment_id = l_rep_res_assignment_id_tab(i)