eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PROJECT_OUT_OBJ

Line 26: ,X_PROJECTS_OUT OUT NOCOPY SYSTEM.PROJECT_OUT_OBJ_TBL

22:
23: PROCEDURE SYNC_PROJECTS(
24: -- X_RETURN_STATUS_OBJ_TBL OUT NOCOPY PROJ_RET_STATUS_OBJ_TBL
25: X_CP_REQUEST_OBJ_TBL OUT NOCOPY SYSTEM.PROJ_CP_REQ_OBJ_TBL
26: ,X_PROJECTS_OUT OUT NOCOPY SYSTEM.PROJECT_OUT_OBJ_TBL
27: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
28: ,P_SYNC_MODE IN CHAR := 'S'
29: ,P_PROJECTS_IN IN SYSTEM.PROJECT_IN_OBJ_TBL
30: )

Line 57: L_PROJECT_OUT_OBJ SYSTEM.PROJECT_OUT_OBJ;

53:
54: --Objects
55:
56: L_PROJECT_IN_OBJ SYSTEM.PROJECT_IN_OBJ ;
57: L_PROJECT_OUT_OBJ SYSTEM.PROJECT_OUT_OBJ;
58:
59: L_PROJECT_OUT_TBL SYSTEM.PROJECT_OUT_OBJ_TBL;
60:
61: --L_TASKS_IN_OBJ TASK_IN_OBJ;

Line 59: L_PROJECT_OUT_TBL SYSTEM.PROJECT_OUT_OBJ_TBL;

55:
56: L_PROJECT_IN_OBJ SYSTEM.PROJECT_IN_OBJ ;
57: L_PROJECT_OUT_OBJ SYSTEM.PROJECT_OUT_OBJ;
58:
59: L_PROJECT_OUT_TBL SYSTEM.PROJECT_OUT_OBJ_TBL;
60:
61: --L_TASKS_IN_OBJ TASK_IN_OBJ;
62: --L_TASKS_OUT_OBJ TASK_OUT_OBJ;
63: --L_STRUCTURE_IN_OBJ STRUCTURE_IN_OBJ;

Line 213: L_PROJECT_OUT_TBL := SYSTEM.PROJECT_OUT_OBJ_TBL();

209: log_pvt('MAIN', ' PA_DEBUG_MODE '||NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N'));
210:
211: x_return_status := 'S';
212:
213: L_PROJECT_OUT_TBL := SYSTEM.PROJECT_OUT_OBJ_TBL();
214:
215: L_PROJECT_OUT_TBL.extend(p_projects_in.count);
216:
217: L_PROJECT_OUT_OBJ := SYSTEM.project_out_obj(null,null,null,null,null,null,null,null,null,null,null,null,null,null);

Line 217: L_PROJECT_OUT_OBJ := SYSTEM.project_out_obj(null,null,null,null,null,null,null,null,null,null,null,null,null,null);

213: L_PROJECT_OUT_TBL := SYSTEM.PROJECT_OUT_OBJ_TBL();
214:
215: L_PROJECT_OUT_TBL.extend(p_projects_in.count);
216:
217: L_PROJECT_OUT_OBJ := SYSTEM.project_out_obj(null,null,null,null,null,null,null,null,null,null,null,null,null,null);
218:
219: i_task_out_tbl := SYSTEM.task_out_obj_tbl();
220:
221: i_task_out_obj := SYSTEM.task_out_obj(null,null,null,null,null);

Line 245: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := null;

241:
242: l_tasks_in_rec_tbl.delete;
243: L_TASKS_OUT_REC_TBL.delete;
244:
245: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := null;
246: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := null;
247: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'S';
248:
249: L_PROJECT_OUT_REC.pa_project_id := null;

Line 246: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := null;

242: l_tasks_in_rec_tbl.delete;
243: L_TASKS_OUT_REC_TBL.delete;
244:
245: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := null;
246: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := null;
247: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'S';
248:
249: L_PROJECT_OUT_REC.pa_project_id := null;
250: L_PROJECT_OUT_REC.pa_project_number := null;

Line 247: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'S';

243: L_TASKS_OUT_REC_TBL.delete;
244:
245: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := null;
246: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := null;
247: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'S';
248:
249: L_PROJECT_OUT_REC.pa_project_id := null;
250: L_PROJECT_OUT_REC.pa_project_number := null;
251: L_PROJECT_OUT_REC.return_status := null;

Line 306: L_PROJECT_OUT_OBJ.AIA_COMMON_ID := L_PROJECT_IN_OBJ.AIA_COMMON_ID;

302: --end;
303: log_pvt('MAIN','After load_project_in_reec ');
304:
305:
306: L_PROJECT_OUT_OBJ.AIA_COMMON_ID := L_PROJECT_IN_OBJ.AIA_COMMON_ID;
307: L_PROJECT_OUT_OBJ.msg_data := li_return_message;
308: L_PROJECT_OUT_OBJ.RETURN_STATUS := li_return_status ;
309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;

Line 307: L_PROJECT_OUT_OBJ.msg_data := li_return_message;

303: log_pvt('MAIN','After load_project_in_reec ');
304:
305:
306: L_PROJECT_OUT_OBJ.AIA_COMMON_ID := L_PROJECT_IN_OBJ.AIA_COMMON_ID;
307: L_PROJECT_OUT_OBJ.msg_data := li_return_message;
308: L_PROJECT_OUT_OBJ.RETURN_STATUS := li_return_status ;
309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;
311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;

Line 308: L_PROJECT_OUT_OBJ.RETURN_STATUS := li_return_status ;

304:
305:
306: L_PROJECT_OUT_OBJ.AIA_COMMON_ID := L_PROJECT_IN_OBJ.AIA_COMMON_ID;
307: L_PROJECT_OUT_OBJ.msg_data := li_return_message;
308: L_PROJECT_OUT_OBJ.RETURN_STATUS := li_return_status ;
309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;
311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
312:

Line 309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;

305:
306: L_PROJECT_OUT_OBJ.AIA_COMMON_ID := L_PROJECT_IN_OBJ.AIA_COMMON_ID;
307: L_PROJECT_OUT_OBJ.msg_data := li_return_message;
308: L_PROJECT_OUT_OBJ.RETURN_STATUS := li_return_status ;
309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;
311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
312:
313: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;

Line 310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;

306: L_PROJECT_OUT_OBJ.AIA_COMMON_ID := L_PROJECT_IN_OBJ.AIA_COMMON_ID;
307: L_PROJECT_OUT_OBJ.msg_data := li_return_message;
308: L_PROJECT_OUT_OBJ.RETURN_STATUS := li_return_status ;
309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;
311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
312:
313: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;
314: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;

Line 311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;

307: L_PROJECT_OUT_OBJ.msg_data := li_return_message;
308: L_PROJECT_OUT_OBJ.RETURN_STATUS := li_return_status ;
309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;
311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
312:
313: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;
314: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;
315:

Line 313: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;

309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;
311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
312:
313: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;
314: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;
315:
316: L_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
317:

Line 314: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;

310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;
311: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
312:
313: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;
314: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;
315:
316: L_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
317:
318: L_PROJECT_OUT_TBL(i) := L_PROJECT_OUT_OBJ;

Line 318: L_PROJECT_OUT_TBL(i) := L_PROJECT_OUT_OBJ;

314: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;
315:
316: L_PROJECT_ID := L_PROJECT_IN_REC.PA_PROJECT_ID;
317:
318: L_PROJECT_OUT_TBL(i) := L_PROJECT_OUT_OBJ;
319:
320: ------- Project Creation / Update Start -------------------------------
321:
322: IF ( li_return_status = 'S' ) THEN

Line 367: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_OUT_REC.pa_project_id;

363: P_TASKS_OUT => L_TASKS_OUT_REC_TBL,
364: P_STRUCTURE_IN => L_STRUCTURE_IN_REC
365: );
366:
367: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_OUT_REC.pa_project_id;
368: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_OUT_REC.pa_project_number;
369:
370: L_PROJECT_OUT_REC.return_status := l_return_status;
371: log_pvt('MAIN','after create_project '||l_RETURN_STATUS);

Line 368: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_OUT_REC.pa_project_number;

364: P_STRUCTURE_IN => L_STRUCTURE_IN_REC
365: );
366:
367: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_OUT_REC.pa_project_id;
368: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_OUT_REC.pa_project_number;
369:
370: L_PROJECT_OUT_REC.return_status := l_return_status;
371: log_pvt('MAIN','after create_project '||l_RETURN_STATUS);
372: log_pvt('MAIN','after create_project L_PROJECT_OUT_REC.return_status '||L_PROJECT_OUT_REC.return_status);

Line 375: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := NULL;

371: log_pvt('MAIN','after create_project '||l_RETURN_STATUS);
372: log_pvt('MAIN','after create_project L_PROJECT_OUT_REC.return_status '||L_PROJECT_OUT_REC.return_status);
373: /* COMMIT_ISSUE Start Change */
374: else
375: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := NULL;
376: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := NULL;
377: L_PROJECT_OUT_REC.return_status := 'S';
378:
379: end if;

Line 376: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := NULL;

372: log_pvt('MAIN','after create_project L_PROJECT_OUT_REC.return_status '||L_PROJECT_OUT_REC.return_status);
373: /* COMMIT_ISSUE Start Change */
374: else
375: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := NULL;
376: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := NULL;
377: L_PROJECT_OUT_REC.return_status := 'S';
378:
379: end if;
380: /* COMMIT_ISSUE End Change */

Line 406: L_PROJECT_OUT_OBJ.p_delete_RES_ASGMT_OUT_OBJ_TBL := l_del_res_asgmt_tbl;

402: if ( l_del_res_asgmt_tbl is not null ) then
403:
404: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);
405:
406: L_PROJECT_OUT_OBJ.p_delete_RES_ASGMT_OUT_OBJ_TBL := l_del_res_asgmt_tbl;
407: L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status := l_del_res_asgm_status;
408: L_PROJECT_OUT_OBJ.del_res_msg_data := l_del_res_msg_data;
409:
410: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);

Line 407: L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status := l_del_res_asgm_status;

403:
404: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);
405:
406: L_PROJECT_OUT_OBJ.p_delete_RES_ASGMT_OUT_OBJ_TBL := l_del_res_asgmt_tbl;
407: L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status := l_del_res_asgm_status;
408: L_PROJECT_OUT_OBJ.del_res_msg_data := l_del_res_msg_data;
409:
410: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);
411: log_pvt('MAIN_DEL',' p_delete_res_asgmt_status '||l_del_res_asgm_status);

Line 408: L_PROJECT_OUT_OBJ.del_res_msg_data := l_del_res_msg_data;

404: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);
405:
406: L_PROJECT_OUT_OBJ.p_delete_RES_ASGMT_OUT_OBJ_TBL := l_del_res_asgmt_tbl;
407: L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status := l_del_res_asgm_status;
408: L_PROJECT_OUT_OBJ.del_res_msg_data := l_del_res_msg_data;
409:
410: log_pvt('MAIN_DEL',' p_delete_RES_ASGMT_OUT_OBJ_TBL.count '||l_del_res_asgmt_tbl.count);
411: log_pvt('MAIN_DEL',' p_delete_res_asgmt_status '||l_del_res_asgm_status);
412: log_pvt('MAIN_DEL',' l_del_res_msg_data '||l_del_res_msg_data);

Line 428: L_PROJECT_OUT_OBJ.P_DELETE_TASK_OUT_OBJ_TBL := i_del_task_out_obj_tbl;

424: x_del_task_out_obj_tbl => i_del_task_out_obj_tbl ,
425: x_del_task_status => i_del_task_status,
426: x_del_task_msg_data => i_del_task_msg_data );
427:
428: L_PROJECT_OUT_OBJ.P_DELETE_TASK_OUT_OBJ_TBL := i_del_task_out_obj_tbl;
429: L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS := i_del_task_status;
430: L_PROJECT_OUT_OBJ.del_task_msg_data := i_del_task_msg_data;
431:
432: commit;

Line 429: L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS := i_del_task_status;

425: x_del_task_status => i_del_task_status,
426: x_del_task_msg_data => i_del_task_msg_data );
427:
428: L_PROJECT_OUT_OBJ.P_DELETE_TASK_OUT_OBJ_TBL := i_del_task_out_obj_tbl;
429: L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS := i_del_task_status;
430: L_PROJECT_OUT_OBJ.del_task_msg_data := i_del_task_msg_data;
431:
432: commit;
433:

Line 430: L_PROJECT_OUT_OBJ.del_task_msg_data := i_del_task_msg_data;

426: x_del_task_msg_data => i_del_task_msg_data );
427:
428: L_PROJECT_OUT_OBJ.P_DELETE_TASK_OUT_OBJ_TBL := i_del_task_out_obj_tbl;
429: L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS := i_del_task_status;
430: L_PROJECT_OUT_OBJ.del_task_msg_data := i_del_task_msg_data;
431:
432: commit;
433:
434: /* SRIDHAR_COMMIT_ISSUE Start Change */

Line 479: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.pa_project_id;

475: log_pvt('MAIN','after L_PROJECT_OUT_REC.pa_project_id;'||L_PROJECT_OUT_REC.pa_project_id);
476: log_pvt('MAIN','after L_PROJECT_OUT_REC.pa_project_number '||L_PROJECT_OUT_REC.pa_project_number);
477: log_pvt('MAIN','L_PROJECT_OUT_REC.return_status '||L_PROJECT_OUT_REC.return_status);
478:
479: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.pa_project_id;
480: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.pa_project_number;
481:
482: /* COMMIT_ISSUE Start Change */
483: else

Line 480: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.pa_project_number;

476: log_pvt('MAIN','after L_PROJECT_OUT_REC.pa_project_number '||L_PROJECT_OUT_REC.pa_project_number);
477: log_pvt('MAIN','L_PROJECT_OUT_REC.return_status '||L_PROJECT_OUT_REC.return_status);
478:
479: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.pa_project_id;
480: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.pa_project_number;
481:
482: /* COMMIT_ISSUE Start Change */
483: else
484: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.pa_project_id;

Line 484: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.pa_project_id;

480: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.pa_project_number;
481:
482: /* COMMIT_ISSUE Start Change */
483: else
484: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.pa_project_id;
485: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.pa_project_number;
486: l_return_status := 'S';
487: end if;
488: /* COMMIT_ISSUE End Change */

Line 485: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.pa_project_number;

481:
482: /* COMMIT_ISSUE Start Change */
483: else
484: L_PROJECT_OUT_OBJ.PA_PROJECT_ID := L_PROJECT_IN_REC.pa_project_id;
485: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.pa_project_number;
486: l_return_status := 'S';
487: end if;
488: /* COMMIT_ISSUE End Change */
489: END IF;

Line 505: l_project_out_obj.msg_data := l_data;

501: );
502:
503: -- dbms_output.put_line ('Error Message: ' ||l_data);
504: log_pvt('MAIN','ERORRS : '||l_data);
505: l_project_out_obj.msg_data := l_data;
506:
507: end loop;
508:
509: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_return_status;

Line 509: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_return_status;

505: l_project_out_obj.msg_data := l_data;
506:
507: end loop;
508:
509: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_return_status;
510:
511: i_task_out_tbl.delete;
512: i_task_out_tbl.extend(L_TASKS_OUT_REC_TBL.count);
513:

Line 515: log_pvt('MAIN','before task_table '||L_PROJECT_OUT_OBJ.RETURN_STATUS);

511: i_task_out_tbl.delete;
512: i_task_out_tbl.extend(L_TASKS_OUT_REC_TBL.count);
513:
514:
515: log_pvt('MAIN','before task_table '||L_PROJECT_OUT_OBJ.RETURN_STATUS);
516:
517: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
518: if (L_TASKS_OUT_REC_TBL is not null) then
519: if (L_TASKS_OUT_REC_TBL.count > 0) then

Line 517: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then

513:
514:
515: log_pvt('MAIN','before task_table '||L_PROJECT_OUT_OBJ.RETURN_STATUS);
516:
517: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
518: if (L_TASKS_OUT_REC_TBL is not null) then
519: if (L_TASKS_OUT_REC_TBL.count > 0) then
520:
521: for l1 in L_TASKS_OUT_REC_TBL.first .. L_TASKS_OUT_REC_TBL.last loop

Line 552: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;

548: end if;
549: end if;
550:
551: log_pvt('MAIN','after task_table ');
552: L_PROJECT_OUT_OBJ.P_TASK_OUT_OBJ_TBL := i_task_out_tbl;
553:
554: EXCEPTION
555:
556: WHEN OTHERS THEN

Line 559: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';

555:
556: WHEN OTHERS THEN
557: log_pvt('MAIN','raise 1000');
558: raise;
559: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
560:
561: END ;
562:
563: END IF;

Line 574: if ( ( l_project_out_obj.return_status = 'S' and g_res_pm_project_reference.count > 0 )

570:
571: ------- Project Resource Assignment Creation / Update Start -------------------------------
572:
573: /* COMMIT_ISSUE Start Change */
574: if ( ( l_project_out_obj.return_status = 'S' and g_res_pm_project_reference.count > 0 )
575: AND
576: ( p_sync_mode <> 'D'))
577: /* COMMIT_ISSUE End Change */
578: then

Line 644: where s.project_id = L_PROJECT_OUT_OBJ.pa_project_id

640: into L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
641: from pa_proj_elem_ver_structure s,
642: pa_proj_structure_types ppst,
643: pa_structure_types pst
644: where s.project_id = L_PROJECT_OUT_OBJ.pa_project_id
645: and ( ( s.status_code = 'STRUCTURE_WORKING' AND
646: exists ( select 'x' from pa_proj_workplan_attr w1
647: where w1.project_id = s.project_id
648: and w1.wp_enable_version_flag = 'Y' ) )

Line 667: where s.project_id = L_PROJECT_OUT_OBJ.pa_project_id

663: pa_proj_structure_types ppst,
664: pa_structure_types pst,
665: pa_budget_versions bud,
666: pa_proj_fp_options opt
667: where s.project_id = L_PROJECT_OUT_OBJ.pa_project_id
668: and ( ( s.status_code = 'STRUCTURE_WORKING' AND
669: exists ( select 'x' from pa_proj_workplan_attr w1
670: where w1.project_id = s.project_id
671: and w1.wp_enable_version_flag = 'Y' ) )

Line 695: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';

691: write_log ('MAIN', 'query condition unsatisfied');
692: when others then
693: log_pvt('MAIN','raise 2000');
694: raise;
695: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
696: end ;
697:
698: begin
699:

Line 715: where s.project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID

711: select a.element_version_id , a.proj_element_id , c.element_number bulk collect
712: into l_elem_ver_id_tbl,l_task_id_tbl , l_task_num_tbl
713: from pa_proj_element_versions a , pa_proj_elem_ver_structure s, pa_proj_elements c, pa_proj_element_versions d,
714: pa_proj_structure_types PPST, pa_integration_settings pis
715: where s.project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID
716: and s.project_id = a.project_id
717: and a.parent_structure_version_id = s.element_version_id
718: and a.object_type = 'PA_TASKS'
719: and ( ( s.status_code = 'STRUCTURE_WORKING' AND

Line 758: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';

754: exception
755: when others then
756: log_pvt('MAIN','raise 3000');
757: raise;
758: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
759: end ;
760:
761: begin
762: Select plan_in_multi_curr_flag into l_plan_in_multi_curr_flag from pa_proj_fp_options WHERE project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID

Line 762: Select plan_in_multi_curr_flag into l_plan_in_multi_curr_flag from pa_proj_fp_options WHERE project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID

758: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
759: end ;
760:
761: begin
762: Select plan_in_multi_curr_flag into l_plan_in_multi_curr_flag from pa_proj_fp_options WHERE project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID
763: AND FIN_PLAN_TYPE_ID = 10 AND FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
764:
765: log_pvt('MAIN','plan_in_multi_curr_flag = '||l_plan_in_multi_curr_flag);
766: log_pvt('MAIN','gl_currency_code = '||gl_currency_code);

Line 771: Select 'x' INTO l_plan_in_multi_curr_flag from pa_projects_all where project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID

767:
768: if (l_plan_in_multi_curr_flag = 'N') then
769: begin
770:
771: Select 'x' INTO l_plan_in_multi_curr_flag from pa_projects_all where project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID
772: and PROJECT_CURRENCY_CODE = gl_currency_code ;
773: log_pvt('MAIN','plan_in_multi_curr_flag 2nd = '||l_plan_in_multi_curr_flag);
774:
775: exception

Line 778: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';

774:
775: exception
776: when NO_DATA_FOUND then
777: log_pvt('MAIN','Exception : Plan in Multiple Currencies not enabled');
778: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
779: pa_utils.add_message
780: ( p_app_short_name => 'PA'
781: ,p_msg_name => 'PA_PLAN_MC_NOT_ENABLED'
782: );

Line 784: --L_PROJECT_OUT_OBJ.msg_data := 'PA_PLAN_MC_NOT_ENABLED';

780: ( p_app_short_name => 'PA'
781: ,p_msg_name => 'PA_PLAN_MC_NOT_ENABLED'
782: );
783: X_MSG_COUNT := FND_MSG_PUB.count_msg ; -- amehrotr
784: --L_PROJECT_OUT_OBJ.msg_data := 'PA_PLAN_MC_NOT_ENABLED';
785: --RAISE;
786: for i in 1..x_msg_count loop
787:
788: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

Line 796: l_project_out_obj.msg_data := l_data;

792: );
793:
794: -- dbms_output.put_line ('Error Message: ' ||l_data);
795: log_pvt('MAIN','ERORRS : '||l_data);
796: l_project_out_obj.msg_data := l_data;
797: end loop;
798: END;
799:
800: END IF;

Line 804: log_pvt('MAIN','before resource assignments '||L_PROJECT_OUT_OBJ.RETURN_STATUS);

800: END IF;
801: end;
802:
803:
804: log_pvt('MAIN','before resource assignments '||L_PROJECT_OUT_OBJ.RETURN_STATUS);
805:
806:
807: log_pvt('MAIN','before for loop resource assignments count : '||g_res_pm_project_reference.count);
808:

Line 861: log_pvt('MAIN',' PROJ ID '||L_PROJECT_OUT_OBJ.PA_PROJECT_ID||' struct '||L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID);

857: c_res_planned_total_bur_cost.extend(1);
858:
859: o_task_asgmt_index.extend(1);
860:
861: log_pvt('MAIN',' PROJ ID '||L_PROJECT_OUT_OBJ.PA_PROJECT_ID||' struct '||L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID);
862:
863: g_res_pa_project_id(i) := L_PROJECT_OUT_OBJ.PA_PROJECT_ID;
864: g_res_pa_task_id(i) := l_task_num_id_tbl(g_res_pa_task_number(i));
865: g_res_pa_struct_version_id(i) := L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID;

Line 863: g_res_pa_project_id(i) := L_PROJECT_OUT_OBJ.PA_PROJECT_ID;

859: o_task_asgmt_index.extend(1);
860:
861: log_pvt('MAIN',' PROJ ID '||L_PROJECT_OUT_OBJ.PA_PROJECT_ID||' struct '||L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID);
862:
863: g_res_pa_project_id(i) := L_PROJECT_OUT_OBJ.PA_PROJECT_ID;
864: g_res_pa_task_id(i) := l_task_num_id_tbl(g_res_pa_task_number(i));
865: g_res_pa_struct_version_id(i) := L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID;
866:
867: c_res_currency_code(c_res_counter) := gl_currency_code;

Line 965: if ( l_project_out_obj.return_status = 'S' and ( ( c_res_counter = 1000 ) or ( i = g_res_pm_project_reference.last and c_res_counter > 0 ) ) ) then

961:
962: BEGIN
963:
964:
965: if ( l_project_out_obj.return_status = 'S' and ( ( c_res_counter = 1000 ) or ( i = g_res_pm_project_reference.last and c_res_counter > 0 ) ) ) then
966:
967: ------ create resource assignments start --------------------
968:
969: for k1 in c_res_pm_project_reference.first .. c_res_pm_project_reference.last loop

Line 1019: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then

1015: ,x_msg_data => X_MSG_DATA
1016: ,x_return_status => l_RETURN_STATUS
1017: ) ;
1018:
1019: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1020: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1021: end if;
1022:
1023: log_pvt('MAIN','creating resource assignments: after load '||l_RETURN_STATUS);

Line 1020: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;

1016: ,x_return_status => l_RETURN_STATUS
1017: ) ;
1018:
1019: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1020: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1021: end if;
1022:
1023: log_pvt('MAIN','creating resource assignments: after load '||l_RETURN_STATUS);
1024:

Line 1033: ,p_pa_project_id => L_PROJECT_OUT_OBJ.PA_PROJECT_ID

1029: ,p_commit => fnd_api.g_false
1030: ,p_init_msg_list => FND_API.G_TRUE
1031: ,p_pm_product_code => 'P6PROJECT'
1032: ,p_pm_project_reference => L_PROJECT_IN_REC.PM_PROJECT_REFERENCE
1033: ,p_pa_project_id => L_PROJECT_OUT_OBJ.PA_PROJECT_ID
1034: ,p_pa_structure_version_id => L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
1035: ,x_msg_count => X_MSG_COUNT
1036: ,x_msg_data => X_MSG_DATA
1037: ,x_return_status => l_RETURN_STATUS

Line 1040: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then

1036: ,x_msg_data => X_MSG_DATA
1037: ,x_return_status => l_RETURN_STATUS
1038: ) ;
1039:
1040: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1041: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1042: end if;
1043:
1044: l_project_out_obj.msg_data := x_msg_data;

Line 1041: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;

1037: ,x_return_status => l_RETURN_STATUS
1038: ) ;
1039:
1040: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1041: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1042: end if;
1043:
1044: l_project_out_obj.msg_data := x_msg_data;
1045:

Line 1044: l_project_out_obj.msg_data := x_msg_data;

1040: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1041: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1042: end if;
1043:
1044: l_project_out_obj.msg_data := x_msg_data;
1045:
1046: log_pvt('MAIN','creating resource assignments: after execute '||l_RETURN_STATUS||' x_msg_count '||x_msg_count);
1047:
1048: if ( l_return_status <> 'S') then

Line 1052: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;

1048: if ( l_return_status <> 'S') then
1049: l_return_status := 'E';
1050: end if;
1051:
1052: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1053:
1054: x_msg_count := nvl(x_msg_count,1);
1055:
1056: if ( x_msg_count > 10 ) then

Line 1069: l_project_out_obj.msg_data := l_data;

1065: );
1066:
1067: -- dbms_output.put_line ('Error Message: ' ||l_data);
1068: log_pvt('MAIN','ERORRS : '||l_data);
1069: l_project_out_obj.msg_data := l_data;
1070:
1071: end loop;
1072:
1073:

Line 1109: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then

1105: ,x_return_status => l_RETURN_STATUS );
1106:
1107: log_pvt('MAIN','creating resource assignments: after fetch '||l_RETURN_STATUS);
1108:
1109: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1110: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1111: end if;
1112:
1113: l_res_asgmt_obj_tbl.extend(o_task_asgmt_index.COUNT);

Line 1110: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;

1106:
1107: log_pvt('MAIN','creating resource assignments: after fetch '||l_RETURN_STATUS);
1108:
1109: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1110: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1111: end if;
1112:
1113: l_res_asgmt_obj_tbl.extend(o_task_asgmt_index.COUNT);
1114:

Line 1180: if ( l_project_out_obj.return_status = 'S' and ( ( u_res_counter = 1000 ) or ( i = g_res_pm_project_reference.last and u_res_counter > 0 ) ) ) then

1176: end if; /* create assignments */
1177:
1178: ------ create resource assignments end --------------------
1179:
1180: if ( l_project_out_obj.return_status = 'S' and ( ( u_res_counter = 1000 ) or ( i = g_res_pm_project_reference.last and u_res_counter > 0 ) ) ) then
1181:
1182: ------ update resource assignments start --------------------
1183:
1184: log_pvt('MAIN','updating resource assignments: start '||u_res_counter);

Line 1235: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then

1231: ,x_msg_data => X_MSG_DATA
1232: ,x_return_status => l_RETURN_STATUS
1233: ) ;
1234:
1235: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1236: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1237: end if;
1238:
1239: log_pvt('MAIN','updating resource assignments: after load ');

Line 1236: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;

1232: ,x_return_status => l_RETURN_STATUS
1233: ) ;
1234:
1235: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1236: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1237: end if;
1238:
1239: log_pvt('MAIN','updating resource assignments: after load ');
1240: log_pvt('MAIN','updating resource assignments: after load, return status : '||l_RETURN_STATUS);

Line 1273: l_project_out_obj.msg_data := l_data;

1269: );
1270:
1271: -- dbms_output.put_line ('Error Message: ' ||l_data);
1272: log_pvt('MAIN','ERORRS : '||l_data);
1273: l_project_out_obj.msg_data := l_data;
1274:
1275:
1276: end loop;
1277:

Line 1282: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;

1278: if ( l_return_status <> 'S') then
1279: l_return_status := 'E';
1280: end if;
1281:
1282: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1283:
1284:
1285: PA_TASK_ASSIGNMENTS_PUB.Fetch_Task_Assignments
1286: ( p_api_version_number => 1.0

Line 1298: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then

1294: ,p_resource_list_member_id => ou_resource_list_member_id
1295: ,p_cbs_element_id => o_cbs_element_id -- CBS is not supported for primavera, this is just a place holder
1296: ,x_return_status => l_RETURN_STATUS );
1297:
1298: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1299: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1300: end if;
1301:
1302: log_pvt('MAIN','updating resource assignments: after fetch '||ou_task_asgmt_index.COUNT);

Line 1299: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;

1295: ,p_cbs_element_id => o_cbs_element_id -- CBS is not supported for primavera, this is just a place holder
1296: ,x_return_status => l_RETURN_STATUS );
1297:
1298: if ( L_PROJECT_OUT_OBJ.RETURN_STATUS = 'S' ) then
1299: L_PROJECT_OUT_OBJ.RETURN_STATUS := l_RETURN_STATUS;
1300: end if;
1301:
1302: log_pvt('MAIN','updating resource assignments: after fetch '||ou_task_asgmt_index.COUNT);
1303:

Line 1383: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';

1379:
1380: WHEN OTHERS THEN
1381: log_pvt('MAIN','raise 4000');
1382: raise;
1383: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
1384:
1385: END ;
1386:
1387:

Line 1399: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;

1395: ------- Project Resource Assignment Creation / Update End -------------------------------
1396:
1397: log_pvt('MAIN','BEFORE END ');
1398:
1399: L_PROJECT_OUT_OBJ.P_RES_ASGMT_OUT_OBJ_TBL := l_res_asgmt_obj_tbl;
1400:
1401: /* Commit issue changes Start */
1402:
1403: if ( p_sync_mode = 'D' ) then

Line 1405: if ( ( nvl(L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS,'S') <> 'S' ) or ( nvl(L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status,'S') <> 'S' ) ) then

1401: /* Commit issue changes Start */
1402:
1403: if ( p_sync_mode = 'D' ) then
1404:
1405: if ( ( nvl(L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS,'S') <> 'S' ) or ( nvl(L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status,'S') <> 'S' ) ) then
1406:
1407: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
1408: else
1409: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'S';

Line 1407: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';

1403: if ( p_sync_mode = 'D' ) then
1404:
1405: if ( ( nvl(L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS,'S') <> 'S' ) or ( nvl(L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status,'S') <> 'S' ) ) then
1406:
1407: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
1408: else
1409: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'S';
1410: x_return_status := 'S';
1411: end if;

Line 1409: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'S';

1405: if ( ( nvl(L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS,'S') <> 'S' ) or ( nvl(L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status,'S') <> 'S' ) ) then
1406:
1407: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'E';
1408: else
1409: L_PROJECT_OUT_OBJ.RETURN_STATUS := 'S';
1410: x_return_status := 'S';
1411: end if;
1412: end if;
1413:

Line 1414: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.RETURN_STATUS '||L_PROJECT_OUT_OBJ.RETURN_STATUS);

1410: x_return_status := 'S';
1411: end if;
1412: end if;
1413:
1414: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.RETURN_STATUS '||L_PROJECT_OUT_OBJ.RETURN_STATUS);
1415: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS '||L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS);
1416: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status'||L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status);
1417:
1418: /* Commit issue changes End */

Line 1415: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS '||L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS);

1411: end if;
1412: end if;
1413:
1414: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.RETURN_STATUS '||L_PROJECT_OUT_OBJ.RETURN_STATUS);
1415: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS '||L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS);
1416: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status'||L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status);
1417:
1418: /* Commit issue changes End */
1419:

Line 1416: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status'||L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status);

1412: end if;
1413:
1414: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.RETURN_STATUS '||L_PROJECT_OUT_OBJ.RETURN_STATUS);
1415: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS '||L_PROJECT_OUT_OBJ.P_DELETE_TASK_STATUS);
1416: log_pvt('MAIN',' L_PROJECT_OUT_OBJ.L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status'||L_PROJECT_OUT_OBJ.p_delete_res_asgmt_status);
1417:
1418: /* Commit issue changes End */
1419:
1420: if ( x_return_status = 'S' ) then

Line 1421: x_return_status := L_PROJECT_OUT_OBJ.RETURN_STATUS;

1417:
1418: /* Commit issue changes End */
1419:
1420: if ( x_return_status = 'S' ) then
1421: x_return_status := L_PROJECT_OUT_OBJ.RETURN_STATUS;
1422: end if;
1423:
1424: L_PROJECT_OUT_TBL(i) := L_PROJECT_OUT_OBJ;
1425:

Line 1424: L_PROJECT_OUT_TBL(i) := L_PROJECT_OUT_OBJ;

1420: if ( x_return_status = 'S' ) then
1421: x_return_status := L_PROJECT_OUT_OBJ.RETURN_STATUS;
1422: end if;
1423:
1424: L_PROJECT_OUT_TBL(i) := L_PROJECT_OUT_OBJ;
1425:
1426: --L_ROJECT_OUT_REC := LOAD_PROJECT_OUT ( L_PROJECT_OUT_REC,L_TASKS_OUT_REC);
1427: --X_RETURN_STATUS_OBJ_TBL := LOAD_RETURN_STATUS_OUT ( L_PROJECT_OUT_REC, L_TASKS_OUT_REC,P_MSG_COUNT,P_MSG_DATA,P_RETURN_STATUS);
1428: --X_CP_REQUEST_OBJ_TBL := LOAD_CP_REQUEST_OUT( L_PROJECT_OUT_REC, L_TASKS_OUT_REC,P_MSG_COUNT,P_MSG_DATA,P_RETURN_STATUS);

Line 2762: -- l_project_out_obj.msg_data := l_data;

2758: );
2759:
2760: -- dbms_output.put_line ('Error Message: ' ||l_data);
2761: log_pvt('DELETE','ERORRS : '||l_data);
2762: -- l_project_out_obj.msg_data := l_data;
2763: l_del_task_out_obj.error_message := l_data;
2764: x_del_task_msg_data := l_data;
2765: end loop;
2766: