APPS.PA_RES_LIST_UPGRADE_PKG dependencies on PA_PLAN_RL_FORMATS

Line 183: FROM pa_plan_rl_formats

179: AND language = userenv('LANG');
180:
181: cursor res_list_form_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type,c_res_for_id pa_res_formats_b.res_format_id%type) is
182: SELECT 'Y'
183: FROM pa_plan_rl_formats
184: WHERE resource_list_id = c_res_list_id
185: AND res_format_id = c_res_for_id;
186:
187: cursor res_list_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is

Line 901: pa_debug.g_err_stage := 'Inserting into pa_plan_rl_formats table';

897: end if;
898: --ITEM NO 7
899: -- Insert into this table with distinct resource_list_id and resource_format_id's
900: IF l_debug_mode = 'Y' THEN
901: pa_debug.g_err_stage := 'Inserting into pa_plan_rl_formats table';
902: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
903: end if;
904: if (l_res_format_tbl.count > 0) then
905: for i in l_res_format_tbl.first..l_res_format_tbl.last

Line 913: insert into pa_plan_rl_formats (

909: open res_list_form_exists_csr(l_get_res_list_id_csr.resource_list_id,l_res_format_tbl(i));
910: fetch res_list_form_exists_csr into l_res_list_form_exists;
911: close res_list_form_exists_csr;
912: if (l_res_list_form_exists = 'N' ) then
913: insert into pa_plan_rl_formats (
914: PLAN_RL_FORMAT_ID,
915: RESOURCE_LIST_ID,
916: RES_FORMAT_ID ,
917: LAST_UPDATE_DATE,

Line 925: pa_plan_rl_formats_s.nextval,

921: LAST_UPDATE_LOGIN,
922: RECORD_VERSION_NUMBER
923: )
924: select
925: pa_plan_rl_formats_s.nextval,
926: l_get_res_list_id_csr.resource_list_id,
927: l_res_format_tbl(i) ,
928: g_last_update_date,
929: g_last_updated_by ,