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_RESOURCE_LIST_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 27: PA_RESOURCE_LIST_MEMBERS

23: CURSOR PARENT_RES_CUR IS
24: Select
25: Rowid
26: from
27: PA_RESOURCE_LIST_MEMBERS
28: Where Resource_List_Member_Id = X_Resource_List_Member_Id;
29:
30: -- Added for bug 1889671
31:

Line 96: Insert Into PA_RESOURCE_LIST_MEMBERS

92:
93: /* As this select will not be used to insert unclassified resource, so no outer join is kept for
94: prta table */
95:
96: Insert Into PA_RESOURCE_LIST_MEMBERS
97: (RESOURCE_LIST_MEMBER_ID,
98: RESOURCE_LIST_ID,
99: RESOURCE_ID ,
100: ALIAS ,

Line 198: Update PA_RESOURCE_LIST_MEMBERS

194: p_migration_code VARCHAR2
195: ) IS
196: BEGIN
197:
198: Update PA_RESOURCE_LIST_MEMBERS
199: SET
200: ALIAS = X_ALIAS,
201: SORT_ORDER = X_SORT_ORDER,
202: DISPLAY_FLAG = X_DISPLAY_FLAG,

Line 226: Select * From PA_RESOURCE_LIST_MEMBERS WHERE ROWID = X_ROW_ID

222: X_ENABLED_FLAG VARCHAR2,
223: X_Funds_Control_Level_Code VARCHAR2,
224: p_migration_code VARCHAR2) IS
225: CURSOR C Is
226: Select * From PA_RESOURCE_LIST_MEMBERS WHERE ROWID = X_ROW_ID
227: For Update of RESOURCE_LIST_MEMBER_ID NOWAIT;
228: Recinfo C%ROWTYPE;
229: Begin
230: OPEN C;

Line 263: Delete from PA_RESOURCE_LIST_MEMBERS Where RowId = X_Row_Id;

259: End Lock_Parent_Row;
260:
261: Procedure Delete_Parent_Row (X_ROW_ID IN VARCHAR2) Is
262: Begin
263: Delete from PA_RESOURCE_LIST_MEMBERS Where RowId = X_Row_Id;
264: If SQL%NOTFOUND Then
265: Raise NO_DATA_FOUND;
266: End If;
267:

Line 289: CURSOR CHILD_RES_CUR IS Select Rowid from PA_RESOURCE_LIST_MEMBERS

285: X_LAST_UPDATE_LOGIN NUMBER,
286: X_Funds_Control_Level_Code VARCHAR2
287: ) IS
288:
289: CURSOR CHILD_RES_CUR IS Select Rowid from PA_RESOURCE_LIST_MEMBERS
290: Where Resource_List_Member_Id = X_Resource_List_Member_Id;
291:
292: -- Added for bug 1889671
293:

Line 360: Insert Into PA_RESOURCE_LIST_MEMBERS

356:
357: /* As this select will not be used to insert unclassified resource, so no outer join is kept for
358: prta table */
359:
360: Insert Into PA_RESOURCE_LIST_MEMBERS
361: (RESOURCE_LIST_MEMBER_ID,
362: RESOURCE_LIST_ID,
363: RESOURCE_ID ,
364: ALIAS ,

Line 459: Update PA_RESOURCE_LIST_MEMBERS

455: X_Funds_Control_Level_Code VARCHAR2
456: ) IS
457: BEGIN
458:
459: Update PA_RESOURCE_LIST_MEMBERS
460: SET
461: ALIAS = X_ALIAS,
462: SORT_ORDER = X_SORT_ORDER,
463: DISPLAY_FLAG = X_DISPLAY_FLAG,

Line 486: Select * From PA_RESOURCE_LIST_MEMBERS WHERE ROWID = X_ROW_ID

482: X_ENABLED_FLAG VARCHAR2,
483: X_Funds_Control_Level_Code VARCHAR2
484: ) IS
485: CURSOR C Is
486: Select * From PA_RESOURCE_LIST_MEMBERS WHERE ROWID = X_ROW_ID
487: For Update of RESOURCE_LIST_MEMBER_ID NOWAIT;
488: Recinfo C%ROWTYPE;
489: Begin
490: OPEN C;

Line 522: Delete from PA_RESOURCE_LIST_MEMBERS Where RowId = X_Row_Id;

518: End Lock_CHILD_Row;
519:
520: Procedure Delete_CHILD_Row (X_ROW_ID IN VARCHAR2) Is
521: Begin
522: Delete from PA_RESOURCE_LIST_MEMBERS Where RowId = X_Row_Id;
523: If SQL%NOTFOUND Then
524: Raise NO_DATA_FOUND;
525: End If;
526: End Delete_Child_Row;

Line 533: PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE,

529: This procedure will delete the unclassified resource list member if all the children for
530: parent is deleted */
531:
532: Procedure Delete_Unclassified_Child (x_resource_list_id IN
533: PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE,
534: x_parent_member_id IN
535: PA_RESOURCE_LIST_MEMBERS.Parent_Member_ID%TYPE,
536: X_msg_Count OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
537: X_msg_Data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 535: PA_RESOURCE_LIST_MEMBERS.Parent_Member_ID%TYPE,

531:
532: Procedure Delete_Unclassified_Child (x_resource_list_id IN
533: PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE,
534: x_parent_member_id IN
535: PA_RESOURCE_LIST_MEMBERS.Parent_Member_ID%TYPE,
536: X_msg_Count OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
537: X_msg_Data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
538: X_return_Status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
539: ) IS

Line 544: FROM pa_resource_list_members PRLM

540:
541:
542: CURSOR Cur_Child_Count IS
543: SELECT count(*)
544: FROM pa_resource_list_members PRLM
545: WHERE prlm.Parent_member_id=x_parent_member_id
546: AND NVL(prlm.resource_type_code,'xyz') <> 'UNCLASSIFIED';
547:
548:

Line 552: l_resource_id pa_resource_list_members.resource_id%TYPE;

548:
549: l_count NUMBER;
550: x_err_code NUMBER;
551: x_err_stage VARCHAR2(100);
552: l_resource_id pa_resource_list_members.resource_id%TYPE;
553: l_group_resource_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
554: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE;
555:
556: Begin

Line 554: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE;

550: x_err_code NUMBER;
551: x_err_stage VARCHAR2(100);
552: l_resource_id pa_resource_list_members.resource_id%TYPE;
553: l_group_resource_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
554: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE;
555:
556: Begin
557:
558: /* In case when resource list is not grouped then this procedure will not get called.To check this

Line 580: Delete pa_resource_list_members prlm

576:
577: /*IF the number of children for resource parent is zero, delete the unclassified list member also.*/
578: If L_count = 0 THEN
579:
580: Delete pa_resource_list_members prlm
581: WHere prlm.parent_member_id=x_parent_member_id
582: AND resource_type_code = 'UNCLASSIFIED';
583:
584: END IF;