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

Line 425: -- Decscription: This procedure inserts members in the PA_RESOURCE_LIST_MEMBERS

421: -- ================================================================
422: --
423: -- Name: Insert_Members
424: -- Type: PL/SQL Procedure
425: -- Decscription: This procedure inserts members in the PA_RESOURCE_LIST_MEMBERS
426: -- table.
427: --
428: -- Called Subprograms: PA_CREATE_RESOURCE.Create_Resource_list_member
429: --

Line 787: l_enabled_flag pa_resource_list_members.enabled_flag%TYPE;

783: IS
784:
785: l_api_version_number CONSTANT NUMBER := G_API_VERSION_NUMBER;
786: l_api_name CONSTANT VARCHAR2(30) := 'Load_members';
787: l_enabled_flag pa_resource_list_members.enabled_flag%TYPE;
788: l_sort_order pa_resource_list_members.sort_order%TYPE;
789:
790: BEGIN
791: p_return_status := FND_API.g_ret_sts_success;

Line 788: l_sort_order pa_resource_list_members.sort_order%TYPE;

784:
785: l_api_version_number CONSTANT NUMBER := G_API_VERSION_NUMBER;
786: l_api_name CONSTANT VARCHAR2(30) := 'Load_members';
787: l_enabled_flag pa_resource_list_members.enabled_flag%TYPE;
788: l_sort_order pa_resource_list_members.sort_order%TYPE;
789:
790: BEGIN
791: p_return_status := FND_API.g_ret_sts_success;
792:

Line 1203: FROM pa_resource_list_members rlm

1199: SELECT 'x'
1200: FROM sys.dual
1201: WHERE EXISTS
1202: (SELECT 'x'
1203: FROM pa_resource_list_members rlm
1204: , pa_resources r
1205: , pa_resource_types rt
1206: WHERE
1207: rlm.resource_list_id = l_resource_list_id

Line 2005: pa_resource_list_members

2001:
2002: BEGIN
2003:
2004: DELETE
2005: pa_resource_list_members
2006: WHERE
2007: resource_list_id = l_resource_list_id;
2008:
2009: EXCEPTION

Line 2130: -- Decscription: This procedure inserts a new member in the PA_RESOURCE_LIST_MEMBERS

2126:
2127: --
2128: -- Name: Add_Resource_List_Member
2129: -- Type: PL/SQL Procedure
2130: -- Decscription: This procedure inserts a new member in the PA_RESOURCE_LIST_MEMBERS
2131: -- table.
2132: --
2133: -- Called Subprograms: Convert_List_name_to_id
2134: -- , Insert_Members

Line 2187: l_enabled_flag pa_resource_list_members.enabled_flag%TYPE;

2183: l_resource_group_name VARCHAR2(80);
2184: l_resource_group_alias VARCHAR2(30);
2185: l_group_resource_type_id NUMBER;
2186: l_sort_order NUMBER;
2187: l_enabled_flag pa_resource_list_members.enabled_flag%TYPE;
2188: l_msg_count NUMBER ;
2189: l_msg_data VARCHAR2(2000);
2190: l_function_allowed VARCHAR2(1);
2191: l_resp_id NUMBER := 0;

Line 2478: -- Decscription: This procedure updates an existing member on the PA_RESOURCE_LIST_MEMBERS

2474:
2475: --
2476: -- Name: Update_Resource_List_Member
2477: -- Type: PL/SQL Procedure
2478: -- Decscription: This procedure updates an existing member on the PA_RESOURCE_LIST_MEMBERS
2479: -- table.
2480: --
2481: -- Called Subprograms: Convert_List_name_to_id
2482: -- , Convert_alias_to_id

Line 2522: l_alias_old pa_resource_list_members.alias%TYPE;

2518: l_group_resource_type_id NUMBER := -1;
2519: l_parent_member_id NUMBER := 0;
2520:
2521: l_rowid_old VARCHAR2(20) := NULL;
2522: l_alias_old pa_resource_list_members.alias%TYPE;
2523: l_sort_order_old NUMBER := 0;
2524: l_enabled_flag_new pa_resource_list_members.enabled_flag%TYPE;
2525: l_enabled_flag_old pa_resource_list_members.enabled_flag%TYPE;
2526: l_msg_count NUMBER ;

Line 2524: l_enabled_flag_new pa_resource_list_members.enabled_flag%TYPE;

2520:
2521: l_rowid_old VARCHAR2(20) := NULL;
2522: l_alias_old pa_resource_list_members.alias%TYPE;
2523: l_sort_order_old NUMBER := 0;
2524: l_enabled_flag_new pa_resource_list_members.enabled_flag%TYPE;
2525: l_enabled_flag_old pa_resource_list_members.enabled_flag%TYPE;
2526: l_msg_count NUMBER ;
2527: l_msg_data VARCHAR2(2000);
2528: l_function_allowed VARCHAR2(1);

Line 2525: l_enabled_flag_old pa_resource_list_members.enabled_flag%TYPE;

2521: l_rowid_old VARCHAR2(20) := NULL;
2522: l_alias_old pa_resource_list_members.alias%TYPE;
2523: l_sort_order_old NUMBER := 0;
2524: l_enabled_flag_new pa_resource_list_members.enabled_flag%TYPE;
2525: l_enabled_flag_old pa_resource_list_members.enabled_flag%TYPE;
2526: l_msg_count NUMBER ;
2527: l_msg_data VARCHAR2(2000);
2528: l_function_allowed VARCHAR2(1);
2529: l_resp_id NUMBER := 0;

Line 2546: FROM pa_resource_list_members rlm

2542: CURSOR l_new_alias_none_csr (p_new_alias VARCHAR2
2543: , l_resource_list_id NUMBER)
2544: IS
2545: SELECT 'x'
2546: FROM pa_resource_list_members rlm
2547: WHERE rlm.resource_list_id = l_resource_list_id
2548: AND rlm.alias = p_new_alias;
2549:
2550: -- Find Parent Member Id of Resource List Member Id

Line 2555: FROM pa_resource_list_members rlm

2551:
2552: CURSOR l_parent_member_csr (l_resource_list_member_id NUMBER)
2553: IS
2554: SELECT rlm.parent_member_id
2555: FROM pa_resource_list_members rlm
2556: WHERE rlm.resource_list_member_id = l_resource_list_member_id;
2557:
2558: -- Find New Alias within the Group of the Resource List Member Id
2559:

Line 2564: FROM pa_resource_list_members rlm

2560: CURSOR l_new_alias_grouped_csr (p_new_alias VARCHAR2
2561: , l_parent_member_id NUMBER)
2562: IS
2563: SELECT 'x'
2564: FROM pa_resource_list_members rlm
2565: WHERE rlm.parent_member_id = l_parent_member_id
2566: AND rlm.alias = p_new_alias;
2567:
2568: -- Find Original Updatable Columns on PA_RESOURCE_LIST_MEMBERS

Line 2568: -- Find Original Updatable Columns on PA_RESOURCE_LIST_MEMBERS

2564: FROM pa_resource_list_members rlm
2565: WHERE rlm.parent_member_id = l_parent_member_id
2566: AND rlm.alias = p_new_alias;
2567:
2568: -- Find Original Updatable Columns on PA_RESOURCE_LIST_MEMBERS
2569:
2570: CURSOR l_orignal_columns_csr (l_resource_list_member_id NUMBER)
2571: IS
2572: SELECT rlm.alias, rlm.sort_order, rlm.enabled_flag, ROWID

Line 2573: FROM pa_resource_list_members rlm

2569:
2570: CURSOR l_orignal_columns_csr (l_resource_list_member_id NUMBER)
2571: IS
2572: SELECT rlm.alias, rlm.sort_order, rlm.enabled_flag, ROWID
2573: FROM pa_resource_list_members rlm
2574: WHERE rlm.resource_list_member_id = l_resource_list_member_id;
2575:
2576: -- Lock Row of Existing Resource List Member Before Update
2577:

Line 2581: FROM pa_resource_list_members

2577:
2578: CURSOR l_lock_row_member_csr (l_rowid_old VARCHAR2)
2579: IS
2580: SELECT 'x'
2581: FROM pa_resource_list_members
2582: WHERE ROWID = l_rowid_old
2583: FOR UPDATE NOWAIT;
2584:
2585:

Line 2784: l_statement := 'UPDATE PA_RESOURCE_LIST_MEMBERS SET ';

2780: CLOSE l_orignal_columns_csr;
2781:
2782:
2783: l_update_member_flag := 'N';
2784: l_statement := 'UPDATE PA_RESOURCE_LIST_MEMBERS SET ';
2785:
2786: IF (p_new_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2787: AND (NVL(p_new_alias, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> NVL(l_alias_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
2788: THEN

Line 2942: FROM pa_resource_list_members rlm

2938:
2939: CURSOR l_lock_row_member_csr (l_resource_list_member_id NUMBER)
2940: IS
2941: SELECT 'x'
2942: FROM pa_resource_list_members rlm
2943: WHERE rlm.resource_list_member_id = l_resource_list_member_id
2944: FOR UPDATE NOWAIT;
2945:
2946: /* Changes done for bug 1889671 Resource Mapping Enhancements */

Line 2948: CURSOR Cur_Unclassified_Parent_ID(X_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE) IS

2944: FOR UPDATE NOWAIT;
2945:
2946: /* Changes done for bug 1889671 Resource Mapping Enhancements */
2947:
2948: CURSOR Cur_Unclassified_Parent_ID(X_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE) IS
2949: SELECT parent_member_id
2950: FROM pa_resource_list_members
2951: WHERE resource_list_member_id = x_resource_list_member_id;
2952:

Line 2950: FROM pa_resource_list_members

2946: /* Changes done for bug 1889671 Resource Mapping Enhancements */
2947:
2948: CURSOR Cur_Unclassified_Parent_ID(X_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE) IS
2949: SELECT parent_member_id
2950: FROM pa_resource_list_members
2951: WHERE resource_list_member_id = x_resource_list_member_id;
2952:
2953: CURSOR Cur_Unclassified_member(x_parent_member_id pa_resource_list_members.parent_member_id%TYPE) IS
2954: SELECT resource_list_member_id

Line 2953: CURSOR Cur_Unclassified_member(x_parent_member_id pa_resource_list_members.parent_member_id%TYPE) IS

2949: SELECT parent_member_id
2950: FROM pa_resource_list_members
2951: WHERE resource_list_member_id = x_resource_list_member_id;
2952:
2953: CURSOR Cur_Unclassified_member(x_parent_member_id pa_resource_list_members.parent_member_id%TYPE) IS
2954: SELECT resource_list_member_id
2955: FROM pa_resource_list_members
2956: WHERE parent_member_id =x_parent_member_id
2957: AND resource_type_code ='UNCLASSIFIED';

Line 2955: FROM pa_resource_list_members

2951: WHERE resource_list_member_id = x_resource_list_member_id;
2952:
2953: CURSOR Cur_Unclassified_member(x_parent_member_id pa_resource_list_members.parent_member_id%TYPE) IS
2954: SELECT resource_list_member_id
2955: FROM pa_resource_list_members
2956: WHERE parent_member_id =x_parent_member_id
2957: AND resource_type_code ='UNCLASSIFIED';
2958:
2959: BEGIN

Line 3070: pa_resource_list_members

3066: OPEN l_lock_row_member_csr (l_resource_list_member_id);
3067: CLOSE l_lock_row_member_csr;
3068:
3069: DELETE
3070: pa_resource_list_members
3071: WHERE
3072: resource_list_member_id = l_resource_list_member_id;
3073:
3074: /* Chnages added for Resource Mapping Enhancement -- Bug 1889671 */

Line 3216: l_resource_group_alias pa_resource_list_members.alias%TYPE;

3212:
3213: l_resource_list_id NUMBER := 0;
3214: l_return_status VARCHAR2(1);
3215: l_dummy VARCHAR2(1);
3216: l_resource_group_alias pa_resource_list_members.alias%TYPE;
3217:
3218: l_rg_rowid VARCHAR2(20) ;
3219: l_rg_rlm_id NUMBER := 0;
3220: l_rg_sort_order NUMBER := 0;

Line 3223: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE;

3219: l_rg_rlm_id NUMBER := 0;
3220: l_rg_sort_order NUMBER := 0;
3221: l_mbr_rowid VARCHAR2(20) ;
3222: l_mbr_sort_order NUMBER := 0;
3223: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE;
3224: l_msg_count NUMBER ;
3225: l_msg_data VARCHAR2(2000);
3226: l_function_allowed VARCHAR2(1);
3227: l_resp_id NUMBER := 0;

Line 3234: FROM pa_resource_list_members rlm

3230:
3231: CURSOR l_rsrc_grp_csr (l_resource_list_id NUMBER, l_resource_group_alias VARCHAR2)
3232: IS
3233: SELECT rlm.resource_list_member_id
3234: FROM pa_resource_list_members rlm
3235: WHERE rlm.resource_list_id = l_resource_list_id
3236: AND rlm.parent_member_id IS NULL
3237: AND rlm.alias = l_resource_group_alias;
3238:

Line 3246: FROM pa_resource_list_members rlm,

3242: , l_resource_group_alias VARCHAR2
3243: , p_sort_by VARCHAR2)
3244: IS
3245: SELECT rlm.ROWID, rlm.resource_list_member_id
3246: FROM pa_resource_list_members rlm,
3247: pa_resources r,
3248: pa_resource_types rt
3249: WHERE rlm.resource_id = r.resource_id
3250: AND r.resource_type_id = rt.resource_type_id

Line 3262: FROM pa_resource_list_members rlm,

3258:
3259: CURSOR l_rsrc_list_mbr_csr (l_rg_rlm_id NUMBER, p_sort_by VARCHAR2)
3260: IS
3261: SELECT rlm.ROWID
3262: FROM pa_resource_list_members rlm,
3263: pa_resources r,
3264: pa_resource_types rt
3265: WHERE rlm.resource_id = r.resource_id
3266: AND rlm.parent_member_id = l_rg_rlm_id

Line 3276: FROM pa_resource_list_members rlm

3272:
3273: CURSOR l_lock_row_all_csr (l_resource_list_id NUMBER)
3274: IS
3275: SELECT 'x'
3276: FROM pa_resource_list_members rlm
3277: WHERE rlm.resource_list_id = l_resource_list_id
3278: FOR UPDATE NOWAIT;
3279:
3280: -- ROW LOCKING: A single group and its members

Line 3285: FROM pa_resource_list_members rlm

3281:
3282: CURSOR l_lock_row_group_csr (l_resource_list_member_id NUMBER)
3283: IS
3284: SELECT 'x'
3285: FROM pa_resource_list_members rlm
3286: WHERE (rlm.resource_list_member_id = l_resource_list_member_id
3287: OR rlm.parent_member_id = l_resource_list_member_id)
3288: FOR UPDATE NOWAIT;
3289:

Line 3445: UPDATE pa_resource_list_members

3441:
3442: -- Inner Loop Update
3443: l_mbr_sort_order := l_mbr_sort_order + 10;
3444:
3445: UPDATE pa_resource_list_members
3446: SET sort_order = l_mbr_sort_order
3447: WHERE ROWID = l_mbr_rowid;
3448:
3449: END LOOP;

Line 3454: UPDATE pa_resource_list_members

3450: CLOSE l_rsrc_list_mbr_csr;
3451:
3452: l_rg_sort_order := l_rg_sort_order + 10;
3453:
3454: UPDATE pa_resource_list_members
3455: SET sort_order = l_rg_sort_order
3456: WHERE ROWID = l_rg_rowid;
3457:
3458: END LOOP;

Line 3709: pa_resource_list_members

3705:
3706: CURSOR l_resource_list_members_csr IS
3707: SELECT resource_list_member_id
3708: FROM
3709: pa_resource_list_members
3710: WHERE resource_list_id = p_resource_list_id
3711: AND alias = p_alias;
3712:
3713: l_resource_list_member_rec l_resource_list_members_csr%ROWTYPE;

Line 3784: FROM pa_resource_list_members

3780: p_object_id NUMBER,
3781: p_object_type VARCHAR2)
3782: IS
3783: SELECT 'x'
3784: FROM pa_resource_list_members
3785: WHERE resource_list_member_id = p_resource_list_member_id
3786: AND resource_list_id = p_resource_list_id
3787: AND nvl(object_id, -99) = nvl(p_object_id, -99)
3788: AND nvl(object_type, 'D') = nvl(p_object_type, 'D');

Line 3846: FROM pa_resource_list_members

3842: p_alias => p_alias );
3843: ELSE
3844: SELECT resource_list_member_id
3845: INTO l_resource_list_member_id
3846: FROM pa_resource_list_members
3847: WHERE resource_list_id = p_resource_list_id
3848: AND object_type = l_object_type
3849: AND object_id = l_object_id
3850: AND alias = p_alias;

Line 4139: FROM pa_resource_list_members

4135: IF p_resource_list_member_id IS NOT NULL THEN
4136: BEGIN
4137: SELECT migration_code
4138: INTO l_migration_code
4139: FROM pa_resource_list_members
4140: WHERE resource_list_member_id = p_resource_list_member_id;
4141:
4142: IF l_migration_code is NULL THEN
4143: l_return := 'N';