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 117: ,pa_resource_assignments ra

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

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

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

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

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

Line 997: ,pa_resource_assignments ra

993: ,l_time_phase_code
994: FROM pa_projects_all ppa
995: ,pa_budget_versions pbv
996: ,pa_proj_fp_options ppfo
997: ,pa_resource_assignments ra
998: WHERE ppa.project_id = pbv.project_id
999: AND pbv.budget_version_id = ppfo.fin_plan_version_id
1000: AND pbv.budget_version_id = p_budget_version_id
1001: AND ra.resource_assignment_id = l_rep_res_assignment_id_tab(i)