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_RBS_ASGMT_PVT dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 35: FROM pa_rbs_prj_assignments

31: INTO l_primary_rep_exists
32: FROM dual
33: WHERE EXISTS
34: (SELECT rbs_prj_assignment_id
35: FROM pa_rbs_prj_assignments
36: WHERE project_id = p_project_id
37: AND assignment_status = 'ACTIVE'
38: AND primary_reporting_rbs_flag = 'Y'
39: AND rbs_header_id <> p_rbs_header_id);

Line 213: UPDATE pa_rbs_prj_assignments

209: -- association exists with WP usage as Y. If it does, then make it N.
210:
211: IF l_wp_flag = 'Y' THEN
212:
213: UPDATE pa_rbs_prj_assignments
214: SET wp_usage_flag = 'N'
215: WHERE rbs_header_id <> p_rbs_header_id
216: AND rbs_version_id <> l_rbs_version_id
217: AND project_id = p_project_id

Line 236: FROM pa_rbs_prj_assignments rpa

232:
233: BEGIN
234: SELECT rpa.rbs_prj_assignment_id
235: INTO l_fp_assoc_id
236: FROM pa_rbs_prj_assignments rpa
237: WHERE rpa.project_id = p_project_id
238: AND rpa.fp_usage_flag = 'Y'
239: AND rpa.assignment_status = 'ACTIVE'
240: -- AND rpa.rbs_version_id <> l_rbs_version_id

Line 253: UPDATE pa_rbs_prj_assignments

249: OR
250: (pfo.fin_plan_type_id IS NULL)));
251:
252: -- hr_utility.trace('l_fp_assoc_id IS : ' || l_fp_assoc_id);
253: UPDATE pa_rbs_prj_assignments
254: SET fp_usage_flag = 'N'
255: WHERE rbs_prj_assignment_id = l_fp_assoc_id;
256:
257: -- hr_utility.trace('done upd');

Line 277: FROM pa_rbs_prj_assignments

273: INTO l_exists_association
274: FROM dual
275: WHERE EXISTS
276: (SELECT rbs_prj_assignment_id
277: FROM pa_rbs_prj_assignments
278: WHERE rbs_header_id = p_rbs_header_id
279: AND rbs_version_id = l_rbs_version_id
280: AND project_id = p_project_id
281: AND assignment_status = 'ACTIVE');

Line 303: FROM pa_rbs_prj_assignments

299: nvl(p_fp_usage_flag, fp_usage_flag),
300: nvl(p_prog_rep_usage_flag, prog_rep_usage_flag)
301: INTO l_rbs_prj_assignment_id, l_record_version_number,
302: l_wp_flag, l_fp_flag, l_prog_flag
303: FROM pa_rbs_prj_assignments
304: WHERE project_id = p_project_id
305: AND rbs_header_id = p_rbs_header_id
306: AND rbs_version_id = l_rbs_version_id; -- changed 7376494 to pass on value of max frozen RBS version id
307: EXCEPTION

Line 316: * take care of Updation of the pa_rbs_prj_assignments

312: END;
313:
314: /************************************************
315: * Call to PA_RBS_ASGMT_PKG.Update_Row procedure, which would
316: * take care of Updation of the pa_rbs_prj_assignments
317: * table.
318: *****************************************************/
319: PA_RBS_ASGMT_PKG.Update_Row(
320: p_rbs_prj_assignment_id => l_rbs_prj_assignment_id ,

Line 336: * PA_RBS_PRJ_ASSIGNMENTS_S

332: END IF;
333: ELSE
334: /**************************************
335: * Get the rbs Assignment ID from the sequence
336: * PA_RBS_PRJ_ASSIGNMENTS_S
337: ******************************************/
338: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
339: INTO l_rbs_prj_assignment_id
340: FROM DUAL;

Line 338: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL

334: /**************************************
335: * Get the rbs Assignment ID from the sequence
336: * PA_RBS_PRJ_ASSIGNMENTS_S
337: ******************************************/
338: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
339: INTO l_rbs_prj_assignment_id
340: FROM DUAL;
341: /************************************************
342: * Call to PA_RBS_ASGMT_PKG.Insert_Row procedure, which would

Line 343: * take care of Insertion into the pa_rbs_prj_assignments

339: INTO l_rbs_prj_assignment_id
340: FROM DUAL;
341: /************************************************
342: * Call to PA_RBS_ASGMT_PKG.Insert_Row procedure, which would
343: * take care of Insertion into the pa_rbs_prj_assignments
344: * table.
345: *****************************************************/
346: BEGIN
347: SELECT count(*)

Line 349: FROM pa_rbs_prj_assignments

345: *****************************************************/
346: BEGIN
347: SELECT count(*)
348: INTO l_count
349: FROM pa_rbs_prj_assignments
350: WHERE project_id = p_project_id
351: AND assignment_status = 'ACTIVE' ;
352: END;
353: IF l_count = 0 THEN

Line 403: FROM pa_rbs_prj_assignments

399: * the primary reporting flag is set to 'Y' */
400: BEGIN
401: SELECT count(*)
402: INTO l_count
403: FROM pa_rbs_prj_assignments
404: WHERE project_id = p_project_id
405: AND assignment_status = 'ACTIVE'
406: AND primary_reporting_rbs_flag = 'Y';
407: END;

Line 410: UPDATE pa_rbs_prj_assignments

406: AND primary_reporting_rbs_flag = 'Y';
407: END;
408:
409: IF l_count = 0 THEN
410: UPDATE pa_rbs_prj_assignments
411: SET primary_reporting_rbs_flag = 'Y'
412: WHERE project_id = p_project_id
413: AND assignment_status = 'ACTIVE'
414: AND rownum = 1;

Line 455: * pa_rbs_prj_assignments table. These values will then

451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452: /*************************************************
453: * Derive the Project_id and RBS_header_id based on
454: * the rbs_prj_assignment_id from the
455: * pa_rbs_prj_assignments table. These values will then
456: * be passed to the Check_Primary_rep_flag function
457: **************************************************/
458: BEGIN
459: SELECT project_id,rbs_header_id,rbs_version_id

Line 461: FROM pa_rbs_prj_assignments

457: **************************************************/
458: BEGIN
459: SELECT project_id,rbs_header_id,rbs_version_id
460: INTO l_project_id,l_rbs_header_id,l_rbs_version_id
461: FROM pa_rbs_prj_assignments
462: WHERE rbs_prj_assignment_id = p_rbs_prj_assignment_id;
463: EXCEPTION
464: WHEN OTHERS THEN
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 471: UPDATE pa_rbs_prj_assignments

467: RETURN;
468: END;
469: IF p_set_as_primary = 'Y' THEN
470: BEGIN
471: UPDATE pa_rbs_prj_assignments
472: SET primary_reporting_rbs_flag = 'N'
473: WHERE project_id = l_project_id
474: AND primary_reporting_rbs_flag = 'Y'
475: AND assignment_status = 'ACTIVE';

Line 552: * pa_rbs_prj_assignments table.

548: /********************************************
549: * This select is used to retrieve the wp_usage_flag,
550: * fp_usage_flag and prog_rep_usage_flag
551: * for the rbs_rpj_assignment_id passed, from the
552: * pa_rbs_prj_assignments table.
553: * We will then use these values to determine if Removal
554: * of record is possible or not.
555: * **********************************************/
556: BEGIN

Line 561: FROM pa_rbs_prj_assignments

557: SELECT WP_USAGE_FLAG, FP_USAGE_FLAG,
558: PROG_REP_USAGE_FLAG,project_id,rbs_version_id
559: INTO l_wp_usage_flag, l_fp_usage_flag,
560: l_prog_rep_usage_flag,l_project_id,l_rbs_version_id
561: FROM pa_rbs_prj_assignments
562: WHERE RBS_PRJ_ASSIGNMENT_ID = p_rbs_prj_assignment_id;
563: EXCEPTION
564: WHEN OTHERS THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 682: * Delete all the associations in the pa_rbs_prj_assignments

678: RETURN;
679: END;
680: END IF;
681: /******************************************************
682: * Delete all the associations in the pa_rbs_prj_assignments
683: * table which corr to the rbs_header, version and project ID
684: * passed in, Which are Obsolete.
685: ******************************************************/
686: /*FORALL i IN p_project_id_tbl.first .. p_project_id_tbl.last

Line 687: DELETE FROM pa_rbs_prj_assignments

683: * table which corr to the rbs_header, version and project ID
684: * passed in, Which are Obsolete.
685: ******************************************************/
686: /*FORALL i IN p_project_id_tbl.first .. p_project_id_tbl.last
687: DELETE FROM pa_rbs_prj_assignments
688: WHERE rbs_header_id = p_rbs_header_id
689: AND rbs_version_id = l_rbs_version_id
690: AND project_id = p_project_id_tbl(i)
691: AND assignment_status = 'OBSOLETE';

Line 709: FROM pa_rbs_prj_assignments

705: INTO l_exists_association
706: FROM dual
707: WHERE EXISTS
708: (SELECT rbs_prj_assignment_id
709: FROM pa_rbs_prj_assignments
710: WHERE rbs_header_id = p_rbs_header_id
711: AND rbs_version_id = l_rbs_version_id
712: AND project_id = p_project_id_tbl(i)
713: AND assignment_status = 'ACTIVE');

Line 731: FROM pa_rbs_prj_assignments

727: ********************************************/
728: BEGIN
729: SELECT rbs_prj_assignment_id, record_version_number
730: INTO l_rbs_prj_assignment_id, l_record_version_number
731: FROM pa_rbs_prj_assignments
732: WHERE project_id = p_project_id_tbl(i)
733: AND rbs_header_id = p_rbs_header_id
734: AND rbs_version_id = l_rbs_version_id;
735: EXCEPTION

Line 743: * take care of Updation of the pa_rbs_prj_assignments

739: END;
740:
741: /************************************************
742: * Call to PA_RBS_ASGMT_PKG.Update_Row procedure, which would
743: * take care of Updation of the pa_rbs_prj_assignments
744: * table.
745: * We only need to set the value for the
746: * reporting_usage flag = 'Y' and the prog_rep_usage_flag
747: * = 'Y'

Line 750: UPDATE pa_rbs_prj_assignments

746: * reporting_usage flag = 'Y' and the prog_rep_usage_flag
747: * = 'Y'
748: *****************************************************/
749: BEGIN
750: UPDATE pa_rbs_prj_assignments
751: SET reporting_usage_flag = 'Y',
752: prog_rep_usage_flag = 'Y',
753: last_update_date = sysdate,
754: record_version_number = record_version_number + 1

Line 768: * PA_RBS_PRJ_ASSIGNMENTS_S

764: END;
765: ELSE
766: /**************************************
767: * Get the rbs Assignment ID from the sequence
768: * PA_RBS_PRJ_ASSIGNMENTS_S
769: ******************************************/
770: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
771: INTO l_rbs_prj_assignment_id
772: FROM DUAL;

Line 770: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL

766: /**************************************
767: * Get the rbs Assignment ID from the sequence
768: * PA_RBS_PRJ_ASSIGNMENTS_S
769: ******************************************/
770: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
771: INTO l_rbs_prj_assignment_id
772: FROM DUAL;
773:
774: PA_RBS_ASGMT_PKG.Insert_Row(

Line 800: * Update the pa_rbs_prj_assignments

796: * Procedure : Assign_New_Version
797: * Description : This API is used to assign the
798: * new version number passed to all
799: * the Projects passed in as a table.
800: * Update the pa_rbs_prj_assignments
801: * table.
802: ****************************************************/
803: PROCEDURE Assign_New_Version(
804: p_rbs_new_version_id IN Number,

Line 823: UPDATE pa_rbs_prj_assignments

819: Return;
820: END;
821:
822: FORALL i IN p_project_id_tbl.FIRST.. p_project_id_tbl.LAST
823: UPDATE pa_rbs_prj_assignments
824: SET rbs_version_id = p_rbs_new_version_id
825: WHERE project_id = p_project_id_tbl(i)
826: AND rbs_header_id = l_rbs_header_id
827: AND assignment_status = 'ACTIVE' ;

Line 854: INSERT INTO pa_rbs_prj_assignments

850: Return;
851: END IF;
852:
853: BEGIN
854: INSERT INTO pa_rbs_prj_assignments
855: (RBS_PRJ_ASSIGNMENT_ID,
856: PROJECT_ID,
857: RBS_VERSION_ID,
858: RBS_HEADER_ID,

Line 872: PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL,

868: CREATED_BY,
869: LAST_UPDATE_LOGIN,
870: RECORD_VERSION_NUMBER)
871: SELECT
872: PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL,
873: p_rbs_dest_project_id,
874: a.RBS_VERSION_ID,
875: a.RBS_HEADER_ID,
876: a.REPORTING_USAGE_FLAG,

Line 888: FROM pa_rbs_prj_assignments a

884: SYSDATE,
885: FND_GLOBAL.USER_ID,
886: FND_GLOBAL.LOGIN_ID,
887: 1
888: FROM pa_rbs_prj_assignments a
889: WHERE a.project_id = p_rbs_src_project_id
890: and (a.RBS_VERSION_ID,a.RBS_HEADER_ID)
891: NOT IN (select rbs_version_id,rbs_header_id
892: from pa_rbs_prj_assignments

Line 892: from pa_rbs_prj_assignments

888: FROM pa_rbs_prj_assignments a
889: WHERE a.project_id = p_rbs_src_project_id
890: and (a.RBS_VERSION_ID,a.RBS_HEADER_ID)
891: NOT IN (select rbs_version_id,rbs_header_id
892: from pa_rbs_prj_assignments
893: where project_id = p_rbs_dest_project_id);
894: EXCEPTION
895: WHEN OTHERS THEN
896: X_Return_Status := Fnd_Api.G_Ret_Sts_UNEXP_ERROR;