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_LISTS

Line 1172: l_start_date_active_old pa_resource_lists.start_date_active%TYPE;

1168: l_resource_type_id NUMBER;
1169: l_resource_list_member_id NUMBER;
1170:
1171: l_rowid_old VARCHAR2(20) := NULL;
1172: l_start_date_active_old pa_resource_lists.start_date_active%TYPE;
1173: l_end_date_active_old pa_resource_lists.end_date_active%TYPE;
1174: l_name_old pa_resource_lists.name%TYPE;
1175: l_group_resource_type_id_old pa_resource_lists.group_resource_type_id%TYPE;
1176: l_description_old pa_resource_lists.description%TYPE;

Line 1173: l_end_date_active_old pa_resource_lists.end_date_active%TYPE;

1169: l_resource_list_member_id NUMBER;
1170:
1171: l_rowid_old VARCHAR2(20) := NULL;
1172: l_start_date_active_old pa_resource_lists.start_date_active%TYPE;
1173: l_end_date_active_old pa_resource_lists.end_date_active%TYPE;
1174: l_name_old pa_resource_lists.name%TYPE;
1175: l_group_resource_type_id_old pa_resource_lists.group_resource_type_id%TYPE;
1176: l_description_old pa_resource_lists.description%TYPE;
1177: l_msg_count NUMBER ;

Line 1174: l_name_old pa_resource_lists.name%TYPE;

1170:
1171: l_rowid_old VARCHAR2(20) := NULL;
1172: l_start_date_active_old pa_resource_lists.start_date_active%TYPE;
1173: l_end_date_active_old pa_resource_lists.end_date_active%TYPE;
1174: l_name_old pa_resource_lists.name%TYPE;
1175: l_group_resource_type_id_old pa_resource_lists.group_resource_type_id%TYPE;
1176: l_description_old pa_resource_lists.description%TYPE;
1177: l_msg_count NUMBER ;
1178: l_msg_data VARCHAR2(2000);

Line 1175: l_group_resource_type_id_old pa_resource_lists.group_resource_type_id%TYPE;

1171: l_rowid_old VARCHAR2(20) := NULL;
1172: l_start_date_active_old pa_resource_lists.start_date_active%TYPE;
1173: l_end_date_active_old pa_resource_lists.end_date_active%TYPE;
1174: l_name_old pa_resource_lists.name%TYPE;
1175: l_group_resource_type_id_old pa_resource_lists.group_resource_type_id%TYPE;
1176: l_description_old pa_resource_lists.description%TYPE;
1177: l_msg_count NUMBER ;
1178: l_msg_data VARCHAR2(2000);
1179: l_function_allowed VARCHAR2(1);

Line 1176: l_description_old pa_resource_lists.description%TYPE;

1172: l_start_date_active_old pa_resource_lists.start_date_active%TYPE;
1173: l_end_date_active_old pa_resource_lists.end_date_active%TYPE;
1174: l_name_old pa_resource_lists.name%TYPE;
1175: l_group_resource_type_id_old pa_resource_lists.group_resource_type_id%TYPE;
1176: l_description_old pa_resource_lists.description%TYPE;
1177: l_msg_count NUMBER ;
1178: l_msg_data VARCHAR2(2000);
1179: l_function_allowed VARCHAR2(1);
1180: l_resp_id NUMBER := 0;

Line 1188: FROM pa_resource_lists rl

1184: -- Check Uniqueness of New Resource List Name
1185: CURSOR l_new_list_name_csr (p_new_list_name VARCHAR2)
1186: IS
1187: SELECT 'x'
1188: FROM pa_resource_lists rl
1189: WHERE rl.name = p_new_list_name;
1190:
1191:
1192: -- FIX, 12-FEB-97, jwhite:

Line 1220: -- Get Original Updatable Columns on PA_RESOURCE_LISTS

1216: SELECT rta.resource_type_id
1217: FROM pa_resource_types_active_v rta
1218: WHERE rta.resource_type_code = p_grouped_by_type;
1219:
1220: -- Get Original Updatable Columns on PA_RESOURCE_LISTS
1221:
1222: CURSOR l_orignal_columns_csr (l_resource_list_id NUMBER)
1223: IS
1224: SELECT rl.name, rl.group_resource_type_id, rl.description, rl.start_date_active, rl.end_date_active, ROWID

Line 1225: FROM pa_resource_lists rl

1221:
1222: CURSOR l_orignal_columns_csr (l_resource_list_id NUMBER)
1223: IS
1224: SELECT rl.name, rl.group_resource_type_id, rl.description, rl.start_date_active, rl.end_date_active, ROWID
1225: FROM pa_resource_lists rl
1226: WHERE rl.resource_list_id = l_resource_list_id;
1227:
1228: -- Lock Row of Existing Resource List Before Update
1229:

Line 1233: FROM pa_resource_lists

1229:
1230: CURSOR l_lock_row_list_csr (l_rowid_old VARCHAR2)
1231: IS
1232: SELECT 'x'
1233: FROM pa_resource_lists
1234: WHERE ROWID = l_rowid_old
1235: FOR UPDATE NOWAIT;
1236:
1237:

Line 1462: l_statement := 'UPDATE PA_RESOURCE_LISTS SET ';

1458:
1459: -- BUILD UPDATE SQL Statement for Resourec List Header ---------------------------------------------
1460:
1461: l_update_header_flag := 'N';
1462: l_statement := 'UPDATE PA_RESOURCE_LISTS SET ';
1463:
1464: --Changes done for SQL BIND VARIABLE by xin liu. 13-May-2003
1465:
1466: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 1907: FROM pa_resource_lists rl

1903:
1904: CURSOR l_lock_row_list_csr (l_resource_list_id NUMBER)
1905: IS
1906: SELECT 'x'
1907: FROM pa_resource_lists rl
1908: WHERE rl.resource_list_id = l_resource_list_id
1909: FOR UPDATE NOWAIT;
1910:
1911: BEGIN

Line 2037: pa_resource_lists

2033: OPEN l_lock_row_list_csr (l_resource_list_id);
2034: CLOSE l_lock_row_list_csr;
2035:
2036: DELETE
2037: pa_resource_lists
2038: WHERE
2039: resource_list_id = l_resource_list_id;
2040:
2041: EXCEPTION

Line 2201: pa_resource_lists rl,pa_resource_groups_valid_v rg

2197: SELECT rl.group_resource_type_id,
2198: rg.resource_group,
2199: rl.job_group_id -- Added for the bug 2486405.
2200: FROM
2201: pa_resource_lists rl,pa_resource_groups_valid_v rg
2202: WHERE rl.resource_list_id = l_resource_list_id
2203: AND rl.group_resource_type_id = rg.group_resource_type_id;
2204:
2205: BEGIN

Line 2537: FROM pa_resource_lists rl

2533:
2534: CURSOR l_group_resource_type_csr (l_resource_list_id NUMBER)
2535: IS
2536: SELECT rl.group_resource_type_id
2537: FROM pa_resource_lists rl
2538: WHERE rl.resource_list_id = l_resource_list_id;
2539:
2540: -- Find New Alias for a Non-Grouped Resource List
2541:

Line 3545: pa_resource_lists

3541:
3542: CURSOR l_resource_list_csr IS
3543: SELECT resource_list_id
3544: FROM
3545: pa_resource_lists
3546: WHERE
3547: name = p_resource_list_name;
3548:
3549: l_resource_list_rec l_resource_list_csr%ROWTYPE;

Line 3612: FROM pa_resource_lists

3608:
3609: CURSOR l_resource_list_csr (p_resource_list_id NUMBER)
3610: IS
3611: SELECT 'x'
3612: FROM pa_resource_lists
3613: WHERE resource_list_id = p_resource_list_id;
3614:
3615:
3616: BEGIN

Line 3795: FROM pa_resource_lists_all_bg

3791: p_return_status := FND_API.G_RET_STS_SUCCESS;
3792:
3793: SELECT migration_code, control_flag
3794: INTO l_migration_code, l_control_flag
3795: FROM pa_resource_lists_all_bg
3796: WHERE resource_list_id = p_resource_list_id;
3797:
3798: IF l_migration_code is not null THEN
3799: IF l_control_flag = 'Y' THEN

Line 4170: FROM pa_resource_lists_all_bg

4166: IF p_resource_list_id IS NOT NULL THEN
4167: BEGIN
4168: SELECT migration_code
4169: INTO l_migration_code
4170: FROM pa_resource_lists_all_bg
4171: WHERE resource_list_id = p_resource_list_id;
4172:
4173: IF l_migration_code is NULL THEN
4174: l_return := 'N';