APPS.PA_FIN_PLAN_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 46: API Description : Return 'Y' if at least one record exists in Resource Assignments (pa_resource_assignments)

42: --PRAGMA RESTRICT_REFERENCES ( Plan_Amount_Exists, WNDS, WNPS);
43:
44: /*
45: API Name : Plan_Amount_Exists_Task_Res
46: API Description : Return 'Y' if at least one record exists in Resource Assignments (pa_resource_assignments)
47: for the given Budget Version Id, Task Id, Resource List Member Id
48: API Created By : Vthakkar
49: API Creation Date : 15-MAR-2004
50: */

Line 714: pa_fp_elements to pa_resource_assignments */

710: This function is being called by PA_FP_ELEMENTS_PUB currently to verify,
711: if PA_FP_ELEMENTS contains a entry for this task. This procedure is now
712: obsoleted.However noticing that this procedure is re-usable, we change
713: all references to pa_tasks to pa_struct_task_wbs_v and all references of
714: pa_fp_elements to pa_resource_assignments */
715: /* FUNCTION check_task_in_fp_option
716: (p_task_id IN pa_tasks.task_id%TYPE)
717: RETURN VARCHAR2; Re-writing function declaration below*/
718: FUNCTION check_task_in_fp_option

Line 823: ,p_task_id IN pa_resource_assignments.task_id%TYPE)

819:
820: /* To determine if a task has resources attached to it as planning element */
821: FUNCTION IS_RESOURCE_ATTACHED_TO_TASK(
822: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
823: ,p_task_id IN pa_resource_assignments.task_id%TYPE)
824: --,p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE)
825: RETURN VARCHAR2;
826:
827: /*=============================================================================

Line 824: --,p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE)

820: /* To determine if a task has resources attached to it as planning element */
821: FUNCTION IS_RESOURCE_ATTACHED_TO_TASK(
822: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
823: ,p_task_id IN pa_resource_assignments.task_id%TYPE)
824: --,p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE)
825: RETURN VARCHAR2;
826:
827: /*=============================================================================
828: This api would be called to check if workplan res list can be updated.

Line 1205: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,

1201: API Creation Date : 07-MAY-2007
1202: */
1203:
1204: FUNCTION Get_NP_RA_Description
1205: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
1206: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null
1207: ) RETURN VARCHAR2;
1208:
1209: /*

Line 1217: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,

1213: API Creation Date : 07-MAY-2007
1214: */
1215:
1216: FUNCTION Get_Change_Reason
1217: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
1218: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null,
1219: p_time_phased_code IN varchar2
1220: ) RETURN VARCHAR2;
1221: