DBA Data[Home] [Help]

APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_NUM_TBL_TYPE

Line 2254: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=

2250: l_msg_data Varchar2(100);
2251: l_check_exists Varchar2(1);
2252: l_exist_res_list Varchar2(1);
2253: l_err_code Number;
2254: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2255: SYSTEM.PA_NUM_TBL_TYPE();
2256: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2257: SYSTEM.PA_NUM_TBL_TYPE();
2258: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=

Line 2255: SYSTEM.PA_NUM_TBL_TYPE();

2251: l_check_exists Varchar2(1);
2252: l_exist_res_list Varchar2(1);
2253: l_err_code Number;
2254: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2255: SYSTEM.PA_NUM_TBL_TYPE();
2256: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2257: SYSTEM.PA_NUM_TBL_TYPE();
2258: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2259: SYSTEM.PA_NUM_TBL_TYPE();

Line 2256: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=

2252: l_exist_res_list Varchar2(1);
2253: l_err_code Number;
2254: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2255: SYSTEM.PA_NUM_TBL_TYPE();
2256: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2257: SYSTEM.PA_NUM_TBL_TYPE();
2258: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2259: SYSTEM.PA_NUM_TBL_TYPE();
2260: API_ERROR Exception;

Line 2257: SYSTEM.PA_NUM_TBL_TYPE();

2253: l_err_code Number;
2254: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2255: SYSTEM.PA_NUM_TBL_TYPE();
2256: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2257: SYSTEM.PA_NUM_TBL_TYPE();
2258: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2259: SYSTEM.PA_NUM_TBL_TYPE();
2260: API_ERROR Exception;
2261: BEGIN

Line 2258: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=

2254: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2255: SYSTEM.PA_NUM_TBL_TYPE();
2256: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2257: SYSTEM.PA_NUM_TBL_TYPE();
2258: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2259: SYSTEM.PA_NUM_TBL_TYPE();
2260: API_ERROR Exception;
2261: BEGIN
2262: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';

Line 2259: SYSTEM.PA_NUM_TBL_TYPE();

2255: SYSTEM.PA_NUM_TBL_TYPE();
2256: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2257: SYSTEM.PA_NUM_TBL_TYPE();
2258: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2259: SYSTEM.PA_NUM_TBL_TYPE();
2260: API_ERROR Exception;
2261: BEGIN
2262: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';
2263: --Initialize the message stack before starting any further processing.

Line 3671: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,

3667: * Further details in the Body.
3668: * The detailed information is in the spec.
3669: ***************************************************/
3670: PROCEDURE Delete_Planning_Resource(
3671: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,
3672: p_commit IN VARCHAR2,
3673: p_init_msg_list IN VARCHAR2,
3674: x_return_status OUT NOCOPY VARCHAR2,
3675: x_msg_count OUT NOCOPY NUMBER,