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

Line 185: l_resource_name pa_resource_list_members.alias%TYPE;

181: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
182: -- Added for Bug 3762278
183: l_project_name pa_projects_all.name%TYPE;
184: l_task_name pa_proj_elements.name%TYPE;
185: l_resource_name pa_resource_list_members.alias%TYPE;
186:
187: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
188: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
189: l_rbf_rbs_prm_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 205: ,pa_resource_list_members prl

201: ,pt.name task_name
202: ,prl.alias resource_name
203: FROM pa_projects_all ppa
204: ,pa_proj_elements pt
205: ,pa_resource_list_members prl
206: ,pa_resource_assignments pra
207: WHERE pra.resource_assignment_id = p_resource_assignment_id
208: AND ppa.project_id = pra.project_id
209: AND pt.proj_element_id(+) = pra.task_id

Line 700: ,pa_resource_list_members prl

696: ,l_task_name
697: ,l_resource_name
698: FROM pa_projects_all ppa
699: ,pa_proj_elements pt
700: ,pa_resource_list_members prl
701: ,pa_resource_assignments pra
702: WHERE pra.resource_assignment_id = p_resource_assignment_id_tbl(i)
703: AND ppa.project_id = pra.project_id
704: AND pt.proj_element_id(+) = pra.task_id

Line 1305: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

1301: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1302: l_rlm_id_tbl_count NUMBER := 0;
1303: l_elem_version_id_count NUMBER := 0;
1304: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1305: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1306: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1307: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1308: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1309: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1306: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable

1302: l_rlm_id_tbl_count NUMBER := 0;
1303: l_elem_version_id_count NUMBER := 0;
1304: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1305: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1306: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1307: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1308: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1309: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1310: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1307: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

1303: l_elem_version_id_count NUMBER := 0;
1304: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1305: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1306: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1307: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1308: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1309: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1310: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1311: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;

Line 1308: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

1304: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1305: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1306: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1307: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1308: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1309: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1310: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1311: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1312: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061

Line 7965: FROM pa_resource_list_members rlm,

7961: FOR i IN 1..l_ra_id_tbl.COUNT LOOP
7962: SELECT rlm.resource_class_code, rlm.inventory_item_id,
7963: rlm.expenditure_type
7964: INTO l_resource_class_code, l_inv_item_id, l_exp_type
7965: FROM pa_resource_list_members rlm,
7966: pa_resource_assignments ra
7967: WHERE ra.resource_assignment_id = l_ra_id_tbl(i)
7968: AND ra.resource_list_member_id = rlm.resource_list_member_id;
7969:

Line 10726: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10722: l_msg_index_out NUMBER;
10723: l_debug_mode VARCHAR2(30);
10724: l_error_msg_code VARCHAR2(30);
10725:
10726: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10727: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10728: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10729: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10730:

Line 10727: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10723: l_debug_mode VARCHAR2(30);
10724: l_error_msg_code VARCHAR2(30);
10725:
10726: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10727: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10728: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10729: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10730:
10731: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10728: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10724: l_error_msg_code VARCHAR2(30);
10725:
10726: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10727: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10728: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10729: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10730:
10731: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10732: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10729: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

10725:
10726: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10727: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10728: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10729: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
10730:
10731: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10732: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10733: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 11386: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11382: l_res_list_is_uncategorized VARCHAR2(1);
11383: l_is_resource_list_grouped VARCHAR2(1);
11384: l_group_resource_type_id NUMBER;
11385:
11386: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11387: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11388: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
11389: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11390:

Line 11387: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11383: l_is_resource_list_grouped VARCHAR2(1);
11384: l_group_resource_type_id NUMBER;
11385:
11386: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11387: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11388: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
11389: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11390:
11391: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 11388: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;

11384: l_group_resource_type_id NUMBER;
11385:
11386: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11387: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11388: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
11389: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11390:
11391: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11392:

Line 11389: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11385:
11386: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11387: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11388: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
11389: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11390:
11391: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11392:
11393: BEGIN

Line 11512: FROM pa_resource_list_members prl,

11508: l_resource_list_member_id_tbl(1):= l_fin_res_class_rlm_id;
11509: ELSE
11510: SELECT resource_list_member_id BULK COLLECT
11511: INTO l_resource_list_member_id_tbl
11512: FROM pa_resource_list_members prl,
11513: PA_PLAN_RES_DEFAULTS pr, /*7291493*/
11514: (SELECT control_flag
11515: FROM pa_resource_lists_all_bg
11516: WHERE resource_list_id = version_info_rec.resource_list_id) rl_control_flag

Line 11765: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11761: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
11762: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
11763: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11764:
11765: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11766: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11767: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11768: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11769:

Line 11766: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11762: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
11763: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11764:
11765: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11766: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11767: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11768: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11769:
11770: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 11767: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11763: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
11764:
11765: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11766: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11767: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11768: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11769:
11770: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11771: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 11768: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11764:
11765: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11766: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11767: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11768: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11769:
11770: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11771: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11772: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 12915: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE

12911: --Returns 'Y' if the record is not already there
12912: FUNCTION DUP_EXISTS
12913: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12914: ,p_task_id IN pa_tasks.task_id%TYPE
12915: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
12916: ,p_project_id IN pa_projects_all.project_id%TYPE)
12917: RETURN VARCHAR2
12918: IS
12919: l_dup_exists VARCHAR2(1);