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_ALLOC_RUN dependencies on PA_PLSQL_DATATYPES

Line 4527: v_child_resource_excl_id pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */

4523: v_incld_exists VARCHAR2(1) := 'N' ; /*2564418 Flagged if an include
4524: is specified*/
4525: v_excld_exists VARCHAR2(1) := 'N' ; /*2564418 Flagged if an exclude
4526: is specified*/
4527: v_child_resource_excl_id pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */
4528: v_child_resource_excl_id_temp pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */
4529: v_cnt Number := 0;
4530: -- Cursor to get all the Resource list members of a rule
4531: Cursor C_RLM is

Line 4528: v_child_resource_excl_id_temp pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */

4524: is specified*/
4525: v_excld_exists VARCHAR2(1) := 'N' ; /*2564418 Flagged if an exclude
4526: is specified*/
4527: v_child_resource_excl_id pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */
4528: v_child_resource_excl_id_temp pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */
4529: v_cnt Number := 0;
4530: -- Cursor to get all the Resource list members of a rule
4531: Cursor C_RLM is
4532: Select * From

Line 4666: resource_list_member_tab pa_plsql_datatypes.IdTabTyp;

4662: AND par.rule_id = p_rule_id
4663: AND prbs.rbs_element_id = par.resource_list_member_id
4664: )
4665: and p_resource_struct_type = 'RBS';
4666: resource_list_member_tab pa_plsql_datatypes.IdTabTyp;
4667: /****************** Bug 3149853 Ends ***************************/
4668: -- Cursor to all defined resource list members of a resource group
4669: Cursor C_RG_RLM is
4670: Select resource_list_member_id

Line 4841: p_res_list_member_id_tab IN pa_plsql_datatypes.IdTabTyp,

4837: -- Created procedure to perform BULK INSERT into pa_alloc_run_resource_det.
4838: Procedure bulk_ins_alloc_run_res(p_run_id IN NUMBER,
4839: p_rule_id IN NUMBER,
4840: p_member_type IN VARCHAR2,
4841: p_res_list_member_id_tab IN pa_plsql_datatypes.IdTabTyp,
4842: p_resource_percent IN NUMBER)
4843: IS
4844: BEGIN
4845: FORALL i IN p_res_list_member_id_tab.first..p_res_list_member_id_tab.last