DBA Data[Home] [Help]

APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_NUM_TBL_TYPE

Line 2239: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=

2235: l_msg_data Varchar2(100);
2236: l_check_exists Varchar2(1);
2237: l_exist_res_list Varchar2(1);
2238: l_err_code Number;
2239: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2240: SYSTEM.PA_NUM_TBL_TYPE();
2241: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2242: SYSTEM.PA_NUM_TBL_TYPE();
2243: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=

Line 2240: SYSTEM.PA_NUM_TBL_TYPE();

2236: l_check_exists Varchar2(1);
2237: l_exist_res_list Varchar2(1);
2238: l_err_code Number;
2239: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2240: SYSTEM.PA_NUM_TBL_TYPE();
2241: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2242: SYSTEM.PA_NUM_TBL_TYPE();
2243: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2244: SYSTEM.PA_NUM_TBL_TYPE();

Line 2241: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=

2237: l_exist_res_list Varchar2(1);
2238: l_err_code Number;
2239: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2240: SYSTEM.PA_NUM_TBL_TYPE();
2241: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2242: SYSTEM.PA_NUM_TBL_TYPE();
2243: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2244: SYSTEM.PA_NUM_TBL_TYPE();
2245: API_ERROR Exception;

Line 2242: SYSTEM.PA_NUM_TBL_TYPE();

2238: l_err_code Number;
2239: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2240: SYSTEM.PA_NUM_TBL_TYPE();
2241: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2242: SYSTEM.PA_NUM_TBL_TYPE();
2243: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2244: SYSTEM.PA_NUM_TBL_TYPE();
2245: API_ERROR Exception;
2246: BEGIN

Line 2243: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=

2239: l_res_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2240: SYSTEM.PA_NUM_TBL_TYPE();
2241: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2242: SYSTEM.PA_NUM_TBL_TYPE();
2243: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2244: SYSTEM.PA_NUM_TBL_TYPE();
2245: API_ERROR Exception;
2246: BEGIN
2247: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';

Line 2244: SYSTEM.PA_NUM_TBL_TYPE();

2240: SYSTEM.PA_NUM_TBL_TYPE();
2241: l_res_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2242: SYSTEM.PA_NUM_TBL_TYPE();
2243: l_Plan_rl_format_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=
2244: SYSTEM.PA_NUM_TBL_TYPE();
2245: API_ERROR Exception;
2246: BEGIN
2247: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';
2248: --Initialize the message stack before starting any further processing.

Line 3624: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,

3620: * Further details in the Body.
3621: * The detailed information is in the spec.
3622: ***************************************************/
3623: PROCEDURE Delete_Planning_Resource(
3624: p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,
3625: p_commit IN VARCHAR2,
3626: p_init_msg_list IN VARCHAR2,
3627: x_return_status OUT NOCOPY VARCHAR2,
3628: x_msg_count OUT NOCOPY NUMBER,