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_RES_LIST_UPGRADE_PKG dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 117: P_Resource_List_Id IN pa_resource_lists_all_bg.resource_list_id%type,

113:
114: END RES_LIST_PLAN_LIST_WHEN_NULL;
115:
116: Procedure Res_List_To_Plan_Res_List(
117: P_Resource_List_Id IN pa_resource_lists_all_bg.resource_list_id%type,
118: p_commit IN VARCHAR2,
119: p_init_msg_list IN VARCHAR2,
120: X_Return_Status OUT NOCOPY Varchar2,
121: X_Msg_Count OUT NOCOPY Number,

Line 147: cursor get_res_list_id_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is

143: AND fmt.res_type_id = b.res_type_id
144: AND fmt.res_type_enabled_flag = 'Y'
145: AND def.object_type = 'CLASS';
146:
147: cursor get_res_list_id_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is
148: SELECT b.resource_list_id,b.group_resource_type_id,b.uncategorized_flag,
149: b.last_update_login, b.creation_date, b.created_by, b.last_update_date,
150: b.last_updated_by, b.name,t.resource_type_code,
151: decode(nvl(t.resource_type_code,'None'),'None',0, 'REVENUE_CATEGORY',300,

Line 153: FROM pa_resource_lists_all_bg b, pa_resource_types t

149: b.last_update_login, b.creation_date, b.created_by, b.last_update_date,
150: b.last_updated_by, b.name,t.resource_type_code,
151: decode(nvl(t.resource_type_code,'None'),'None',0, 'REVENUE_CATEGORY',300,
152: 'EXPENDITURE_CATEGORY',100, 'ORGANIZATION',200, 0 ) grp_seq
153: FROM pa_resource_lists_all_bg b, pa_resource_types t
154: WHERE t.resource_type_id(+) = b.group_resource_type_id and
155: b.resource_list_id = c_res_list_id and
156: EXISTS ( select 'X' from pa_resource_list_members m
157: WHERE m.res_format_id is null and m.resource_list_id = b.resource_list_id

Line 160: cursor get_res_list_mem_id_csr(l_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is

156: EXISTS ( select 'X' from pa_resource_list_members m
157: WHERE m.res_format_id is null and m.resource_list_id = b.resource_list_id
158: OR b.uncategorized_flag = 'Y');
159:
160: cursor get_res_list_mem_id_csr(l_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is
161: SELECT m.resource_list_member_id,m.resource_type_id,m.parent_member_id,
162: m.organization_id,m.revenue_category, m.expenditure_category,m.expenditure_type,
163: decode(rl.uncategorized_flag,'Y',9,decode(nvl(t.resource_type_code,'None'),'None',0 , 'EMPLOYEE',1, 'EXPENDITURE_CATEGORY',
164: 2, 'EXPENDITURE_TYPE', 3, 'JOB',4,'ORGANIZATION',5, 'REVENUE_CATEGORY',6,'EVENT_TYPE',

Line 167: pa_resource_lists_all_bg rl

163: decode(rl.uncategorized_flag,'Y',9,decode(nvl(t.resource_type_code,'None'),'None',0 , 'EMPLOYEE',1, 'EXPENDITURE_CATEGORY',
164: 2, 'EXPENDITURE_TYPE', 3, 'JOB',4,'ORGANIZATION',5, 'REVENUE_CATEGORY',6,'EVENT_TYPE',
165: 7,'VENDOR', 8, 'UNCATEGORIZED',9,-1 )) + decode(nvl(track_as_labor_flag,'N'),'Y',0,15) res_seq,t.resource_type_code
166: FROM pa_resource_list_members m,pa_resource_types t,
167: pa_resource_lists_all_bg rl
168: WHERE m.resource_list_id = l_res_list_id
169: AND m.resource_type_id = t.resource_type_id(+)
170: AND m.res_format_id is null
171: AND NVL(t.resource_type_code,-99) not in ('UNCLASSIFIED', 'PROJECT_ROLE', 'HZ_PARTY')

Line 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

177: FROM pa_resource_classes_tl t,pa_resource_classes_b c
178: WHERE t.resource_class_id = c.resource_class_id
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;

Line 187: cursor res_list_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is

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
188: SELECT 'Y'
189: FROM pa_resource_lists_all_bg
190: WHERE resource_list_id = c_res_list_id
191: AND migration_code = 'M';

Line 189: FROM pa_resource_lists_all_bg

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
188: SELECT 'Y'
189: FROM pa_resource_lists_all_bg
190: WHERE resource_list_id = c_res_list_id
191: AND migration_code = 'M';
192:
193: cursor chk_res_for_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is

Line 193: cursor chk_res_for_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is

189: FROM pa_resource_lists_all_bg
190: WHERE resource_list_id = c_res_list_id
191: AND migration_code = 'M';
192:
193: cursor chk_res_for_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is
194: SELECT 'Y'
195: FROM pa_resource_lists_all_bg b
196: WHERE resource_list_id = c_res_list_id
197: AND exists ( select 'Y' from pa_resource_list_members m

Line 195: FROM pa_resource_lists_all_bg b

191: AND migration_code = 'M';
192:
193: cursor chk_res_for_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type) is
194: SELECT 'Y'
195: FROM pa_resource_lists_all_bg b
196: WHERE resource_list_id = c_res_list_id
197: AND exists ( select 'Y' from pa_resource_list_members m
198: WHERE m.resource_list_id = b.resource_list_id and
199: m.res_format_id is not null);

Line 949: pa_debug.g_err_stage := 'Updating pa_resource_lists_all_bg table';

945: end if;
946: --ITEM NO 9
947:
948: IF l_debug_mode = 'Y' THEN
949: pa_debug.g_err_stage := 'Updating pa_resource_lists_all_bg table';
950: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
951: end if;
952: -- Update migration code for each resource list header
953: update pa_resource_lists_all_bg

Line 953: update pa_resource_lists_all_bg

949: pa_debug.g_err_stage := 'Updating pa_resource_lists_all_bg table';
950: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
951: end if;
952: -- Update migration code for each resource list header
953: update pa_resource_lists_all_bg
954: set control_flag = 'Y',
955: use_for_wp_flag = 'Y',
956: migration_code = 'M',
957: record_version_number = 1