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 241: l_resource_name pa_resource_list_members.alias%TYPE;

237: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
238: -- Added for Bug 3762278
239: l_project_name pa_projects_all.name%TYPE;
240: l_task_name pa_proj_elements.name%TYPE;
241: l_resource_name pa_resource_list_members.alias%TYPE;
242:
243: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
244: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
245: l_rbf_rbs_prm_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 261: ,pa_resource_list_members prl

257: ,pt.name task_name
258: ,prl.alias resource_name
259: FROM pa_projects_all ppa
260: ,pa_proj_elements pt
261: ,pa_resource_list_members prl
262: ,pa_resource_assignments pra
263: WHERE pra.resource_assignment_id = p_resource_assignment_id
264: AND ppa.project_id = pra.project_id
265: AND pt.proj_element_id(+) = pra.task_id

Line 756: ,pa_resource_list_members prl

752: ,l_task_name
753: ,l_resource_name
754: FROM pa_projects_all ppa
755: ,pa_proj_elements pt
756: ,pa_resource_list_members prl
757: ,pa_resource_assignments pra
758: WHERE pra.resource_assignment_id = p_resource_assignment_id_tbl(i)
759: AND ppa.project_id = pra.project_id
760: AND pt.proj_element_id(+) = pra.task_id

Line 1365: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

1361: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1362: l_rlm_id_tbl_count NUMBER := 0;
1363: l_elem_version_id_count NUMBER := 0;
1364: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1365: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1366: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1367: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1369: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1362: l_rlm_id_tbl_count NUMBER := 0;
1363: l_elem_version_id_count NUMBER := 0;
1364: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1365: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1366: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1367: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1369: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1367: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

1363: l_elem_version_id_count NUMBER := 0;
1364: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1365: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1366: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1367: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1369: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1371: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;

Line 1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

1364: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1365: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1366: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1367: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1369: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1371: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1372: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061

Line 8791: FROM pa_resource_list_members rlm,

8787: FOR i IN 1..l_ra_id_tbl.COUNT LOOP
8788: SELECT rlm.resource_class_code, rlm.inventory_item_id,
8789: rlm.expenditure_type
8790: INTO l_resource_class_code, l_inv_item_id, l_exp_type
8791: FROM pa_resource_list_members rlm,
8792: pa_resource_assignments ra
8793: WHERE ra.resource_assignment_id = l_ra_id_tbl(i)
8794: AND ra.resource_list_member_id = rlm.resource_list_member_id;
8795:

Line 11592: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11588: l_msg_index_out NUMBER;
11589: l_debug_mode VARCHAR2(30);
11590: l_error_msg_code VARCHAR2(30);
11591:
11592: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11593: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11594: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11595: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11596:

Line 11593: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11589: l_debug_mode VARCHAR2(30);
11590: l_error_msg_code VARCHAR2(30);
11591:
11592: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11593: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11594: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11595: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11596:
11597: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 11594: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11590: l_error_msg_code VARCHAR2(30);
11591:
11592: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11593: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11594: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11595: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11596:
11597: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11598: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 11595: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

11591:
11592: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11593: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11594: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11595: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11596:
11597: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11598: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11599: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 12260: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

12256: l_res_list_is_uncategorized VARCHAR2(1);
12257: l_is_resource_list_grouped VARCHAR2(1);
12258: l_group_resource_type_id NUMBER;
12259:
12260: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12261: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12262: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
12263: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12264:

Line 12261: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

12257: l_is_resource_list_grouped VARCHAR2(1);
12258: l_group_resource_type_id NUMBER;
12259:
12260: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12261: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12262: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
12263: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12264:
12265: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

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

12258: l_group_resource_type_id NUMBER;
12259:
12260: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12261: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12262: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
12263: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12264:
12265: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12266:

Line 12263: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

12259:
12260: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12261: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12262: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
12263: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12264:
12265: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12266:
12267: BEGIN

Line 12386: FROM pa_resource_list_members prl,

12382: l_resource_list_member_id_tbl(1):= l_fin_res_class_rlm_id;
12383: ELSE
12384: SELECT resource_list_member_id BULK COLLECT
12385: INTO l_resource_list_member_id_tbl
12386: FROM pa_resource_list_members prl,
12387: PA_PLAN_RES_DEFAULTS pr, /*7291493*/
12388: (SELECT control_flag
12389: FROM pa_resource_lists_all_bg
12390: WHERE resource_list_id = version_info_rec.resource_list_id) rl_control_flag

Line 12639: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

12635: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12636: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12637: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12638:
12639: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12640: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12641: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12642: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12643:

Line 12640: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

12636: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12637: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12638:
12639: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12640: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12641: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12642: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12643:
12644: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 12641: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

12637: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12638:
12639: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12640: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12641: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12642: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12643:
12644: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12645: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 12642: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

12638:
12639: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12640: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12641: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12642: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12643:
12644: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12645: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12646: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 13816: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE

13812: --Returns 'Y' if the record is not already there
13813: FUNCTION DUP_EXISTS
13814: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
13815: ,p_task_id IN pa_tasks.task_id%TYPE
13816: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
13817: ,p_project_id IN pa_projects_all.project_id%TYPE)
13818: RETURN VARCHAR2
13819: IS
13820: l_dup_exists VARCHAR2(1);