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 4504: v_child_resource_excl_id pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */

4500: v_incld_exists VARCHAR2(1) := 'N' ; /*2564418 Flagged if an include
4501: is specified*/
4502: v_excld_exists VARCHAR2(1) := 'N' ; /*2564418 Flagged if an exclude
4503: is specified*/
4504: v_child_resource_excl_id pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */
4505: v_child_resource_excl_id_temp pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */
4506: v_cnt Number := 0;
4507: -- Cursor to get all the Resource list members of a rule
4508: Cursor C_RLM is

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

4501: is specified*/
4502: v_excld_exists VARCHAR2(1) := 'N' ; /*2564418 Flagged if an exclude
4503: is specified*/
4504: v_child_resource_excl_id pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */
4505: v_child_resource_excl_id_temp pa_plsql_datatypes.IdTabTyp; /* 3567201 : Exclusion Of Childs when Parent Resource Is Excluded. */
4506: v_cnt Number := 0;
4507: -- Cursor to get all the Resource list members of a rule
4508: Cursor C_RLM is
4509: Select * From

Line 4643: resource_list_member_tab pa_plsql_datatypes.IdTabTyp;

4639: AND par.rule_id = p_rule_id
4640: AND prbs.rbs_element_id = par.resource_list_member_id
4641: )
4642: and p_resource_struct_type = 'RBS';
4643: resource_list_member_tab pa_plsql_datatypes.IdTabTyp;
4644: /****************** Bug 3149853 Ends ***************************/
4645: -- Cursor to all defined resource list members of a resource group
4646: Cursor C_RG_RLM is
4647: Select resource_list_member_id

Line 4818: p_res_list_member_id_tab IN pa_plsql_datatypes.IdTabTyp,

4814: -- Created procedure to perform BULK INSERT into pa_alloc_run_resource_det.
4815: Procedure bulk_ins_alloc_run_res(p_run_id IN NUMBER,
4816: p_rule_id IN NUMBER,
4817: p_member_type IN VARCHAR2,
4818: p_res_list_member_id_tab IN pa_plsql_datatypes.IdTabTyp,
4819: p_resource_percent IN NUMBER)
4820: IS
4821: BEGIN
4822: FORALL i IN p_res_list_member_id_tab.first..p_res_list_member_id_tab.last