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_TBL_PKG dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 10: p_name PA_RESOURCE_LISTS_ALL_BG.name%TYPE,

6: --
7: -- 16-MAR-2004 smullapp created
8: -------------------------------------------------------------------
9: PROCEDURE Insert_Row(
10: p_name PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
11: p_description PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
12: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
13: p_group_resource_type_id NUMBER,
14: p_start_date_active DATE,

Line 11: p_description PA_RESOURCE_LISTS_ALL_BG.description%TYPE,

7: -- 16-MAR-2004 smullapp created
8: -------------------------------------------------------------------
9: PROCEDURE Insert_Row(
10: p_name PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
11: p_description PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
12: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
13: p_group_resource_type_id NUMBER,
14: p_start_date_active DATE,
15: p_end_date_active DATE,

Line 12: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,

8: -------------------------------------------------------------------
9: PROCEDURE Insert_Row(
10: p_name PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
11: p_description PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
12: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
13: p_group_resource_type_id NUMBER,
14: p_start_date_active DATE,
15: p_end_date_active DATE,
16: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,

Line 16: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,

12: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
13: p_group_resource_type_id NUMBER,
14: p_start_date_active DATE,
15: p_end_date_active DATE,
16: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,
17: p_business_group_id NUMBER,
18: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
19: p_job_group_id NUMBER,
20: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,

Line 18: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,

14: p_start_date_active DATE,
15: p_end_date_active DATE,
16: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,
17: p_business_group_id NUMBER,
18: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
19: p_job_group_id NUMBER,
20: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
21: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
22: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,

Line 20: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,

16: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,
17: p_business_group_id NUMBER,
18: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
19: p_job_group_id NUMBER,
20: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
21: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
22: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
23: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
24: x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 21: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,

17: p_business_group_id NUMBER,
18: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
19: p_job_group_id NUMBER,
20: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
21: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
22: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
23: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
24: x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 22: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,

18: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
19: p_job_group_id NUMBER,
20: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
21: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
22: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
23: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
24: x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
26: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 23: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,

19: p_job_group_id NUMBER,
20: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
21: p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
22: p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
23: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
24: x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
26: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
27: )

Line 32: --This cursor selects rowid from pa_resource_lists_all_bg

28: IS
29:
30: l_row_id VARCHAR2(100);
31:
32: --This cursor selects rowid from pa_resource_lists_all_bg
33: CURSOR c_res_cur IS
34: SELECT
35: Rowid
36: FROM

Line 37: pa_resource_lists_all_bg

33: CURSOR c_res_cur IS
34: SELECT
35: Rowid
36: FROM
37: pa_resource_lists_all_bg
38: WHERE resource_list_id = x_resource_list_id;
39:
40: --This sets the value for resource_list_id of pa_resource_lists_all_bg fro pa_resource_lists_s sequence
41: CURSOR c_res_list_seq_csr IS

Line 40: --This sets the value for resource_list_id of pa_resource_lists_all_bg fro pa_resource_lists_s sequence

36: FROM
37: pa_resource_lists_all_bg
38: WHERE resource_list_id = x_resource_list_id;
39:
40: --This sets the value for resource_list_id of pa_resource_lists_all_bg fro pa_resource_lists_s sequence
41: CURSOR c_res_list_seq_csr IS
42: SELECT pa_resource_lists_s.NEXTVAL
43: FROM
44: SYS.DUAL;

Line 55: --Inserts a record into pa_resource_lists_all_bg

51: FETCH c_res_list_seq_csr INTO X_RESOURCE_LIST_ID;
52: CLOSE c_res_list_seq_csr;
53:
54:
55: --Inserts a record into pa_resource_lists_all_bg
56: Insert Into PA_RESOURCE_LISTS_ALL_BG
57: (
58: RESOURCE_LIST_ID,
59: NAME,

Line 56: Insert Into PA_RESOURCE_LISTS_ALL_BG

52: CLOSE c_res_list_seq_csr;
53:
54:
55: --Inserts a record into pa_resource_lists_all_bg
56: Insert Into PA_RESOURCE_LISTS_ALL_BG
57: (
58: RESOURCE_LIST_ID,
59: NAME,
60: DESCRIPTION,

Line 144: PA_RESOURCE_LISTS_ALL_BG

140: CURSOR RES_CUR IS
141: Select
142: Rowid
143: from
144: PA_RESOURCE_LISTS_ALL_BG
145: Where Resource_List_Id = X_Resource_List_Id;
146: BEGIN
147: Insert Into PA_RESOURCE_LISTS_ALL_BG
148: (

Line 147: Insert Into PA_RESOURCE_LISTS_ALL_BG

143: from
144: PA_RESOURCE_LISTS_ALL_BG
145: Where Resource_List_Id = X_Resource_List_Id;
146: BEGIN
147: Insert Into PA_RESOURCE_LISTS_ALL_BG
148: (
149: RESOURCE_LIST_ID,
150: NAME ,
151: DESCRIPTION ,

Line 261: Update PA_RESOURCE_LISTS_ALL_BG

257: X_LAST_UPDATE_DATE DATE,
258: X_LAST_UPDATE_LOGIN NUMBER ) IS
259: BEGIN
260:
261: Update PA_RESOURCE_LISTS_ALL_BG
262: SET
263: -- For bug 4202015
264: -- RESOURCE_LIST_ID = X_RESOURCE_LIST_ID ,
265: NAME = X_NAME ,

Line 316: Select * From PA_RESOURCE_LISTS_ALL_BG WHERE ROWID = X_ROW_ID

312: -- X_ADW_NOTIFY_FLAG VARCHAR2,
313: X_LAST_UPDATED_BY NUMBER) IS
314:
315: CURSOR C Is
316: Select * From PA_RESOURCE_LISTS_ALL_BG WHERE ROWID = X_ROW_ID
317: For Update of RESOURCE_LIST_ID NOWAIT;
318: Recinfo C%ROWTYPE;
319: Begin
320: --hr_utility.trace_on(NULL, 'RMUPG');

Line 376: from PA_RESOURCE_LISTS_ALL_BG

372: Begin
373:
374: delete from pa_resource_lists_tl
375: where resource_list_id in (select resource_list_id
376: from PA_RESOURCE_LISTS_ALL_BG
377: Where RowId = X_Row_Id);
378:
379: Delete from PA_RESOURCE_LISTS_ALL_BG Where RowId = X_Row_Id;
380: If SQL%NOTFOUND Then

Line 379: Delete from PA_RESOURCE_LISTS_ALL_BG Where RowId = X_Row_Id;

375: where resource_list_id in (select resource_list_id
376: from PA_RESOURCE_LISTS_ALL_BG
377: Where RowId = X_Row_Id);
378:
379: Delete from PA_RESOURCE_LISTS_ALL_BG Where RowId = X_Row_Id;
380: If SQL%NOTFOUND Then
381: Raise NO_DATA_FOUND;
382: End If;
383: