APPS.PJM_TASK_AUTOASSIGN_COPY dependencies on PJM_PROJECT

Line 83: , pjm_project.all_task_idtonum( task_id ) task_number

79: CURSOR DSrc IS
80: SELECT assignment_type
81: , project_id
82: , task_id
83: , pjm_project.all_task_idtonum( task_id ) task_number
84: , organization_id
85: , creation_date
86: , created_by
87: , last_update_date

Line 126: FROM pjm_project_parameters

122: --
123: -- Make sure the to project is specified in the organization
124: --
125: SELECT null
126: FROM pjm_project_parameters
127: WHERE organization_id = dt.organization_id
128: AND project_id = P_To_Project_ID
129: UNION ALL
130: SELECT null

Line 153: , pjm_project.all_task_idtonum( task_id ) task_number

149: CURSOR Src IS
150: SELECT assignment_type
151: , project_id
152: , task_id
153: , pjm_project.all_task_idtonum( task_id ) task_number
154: , organization_id
155: , creation_date
156: , created_by
157: , last_update_date

Line 196: FROM pjm_project_parameters

192: --
193: -- Make sure the to project is specified in the organization
194: --
195: SELECT null
196: FROM pjm_project_parameters
197: WHERE organization_id = dt.organization_id
198: AND project_id = P_To_Project_ID
199: UNION ALL
200: SELECT null

Line 237: ProjNum := PJM_PROJECT.All_Proj_IDToNum( P_To_Project_ID );

233: X_Count1 := 0;
234: X_Count2 := 0;
235: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
236:
237: ProjNum := PJM_PROJECT.All_Proj_IDToNum( P_To_Project_ID );
238:
239: --
240: -- First copy the default assignment rules
241: --

Line 246: TaskID := PJM_PROJECT.Val_Task_NumToID( ProjNum , DSrcRec.Task_Number );

242: FOR DSrcRec IN DSrc LOOP
243: --
244: -- Try to find a match in the To Project based on Task Number
245: --
246: TaskID := PJM_PROJECT.Val_Task_NumToID( ProjNum , DSrcRec.Task_Number );
247:
248: IF ( TaskID IS NOT NULL ) THEN
249: --
250: -- If copy option of "REPLACE" is specified, then update

Line 393: TaskID := PJM_PROJECT.Val_Task_NumToID( ProjNum , SrcRec.Task_Number );

389: FOR SrcRec IN Src LOOP
390: --
391: -- Try to find a match in the To Project based on Task Number
392: --
393: TaskID := PJM_PROJECT.Val_Task_NumToID( ProjNum , SrcRec.Task_Number );
394:
395: --
396: -- If no match found, and user elects to use the default task,
397: -- then get the default task using the private function.