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_LIST_MEMBERS

Line 156: EXISTS ( select 'X' from pa_resource_list_members m

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
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

Line 166: FROM pa_resource_list_members m,pa_resource_types t,

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',
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

Line 197: AND exists ( select 'Y' from pa_resource_list_members m

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);
200:
201: TYPE res_class_csr_tbl is table of res_class_csr%ROWTYPE

Line 221: TYPE rev_cat_tbl is table of pa_resource_list_members.revenue_category%type

217: TYPE res_for_id_tbl is TABLE of pa_res_formats_b.res_format_id%type
218: index by binary_integer;
219: l_res_for_id_tbl res_for_id_tbl;
220:
221: TYPE rev_cat_tbl is table of pa_resource_list_members.revenue_category%type
222: index by binary_integer;
223: l_rev_cat_tbl rev_cat_tbl;
224:
225: TYPE exp_cat_tbl is table of pa_resource_list_members.expenditure_category%type

Line 225: TYPE exp_cat_tbl is table of pa_resource_list_members.expenditure_category%type

221: TYPE rev_cat_tbl is table of pa_resource_list_members.revenue_category%type
222: index by binary_integer;
223: l_rev_cat_tbl rev_cat_tbl;
224:
225: TYPE exp_cat_tbl is table of pa_resource_list_members.expenditure_category%type
226: index by binary_integer;
227: l_exp_cat_tbl exp_cat_tbl;
228:
229: TYPE org_id_tbl is table of pa_resource_list_members.organization_id%type

Line 229: TYPE org_id_tbl is table of pa_resource_list_members.organization_id%type

225: TYPE exp_cat_tbl is table of pa_resource_list_members.expenditure_category%type
226: index by binary_integer;
227: l_exp_cat_tbl exp_cat_tbl;
228:
229: TYPE org_id_tbl is table of pa_resource_list_members.organization_id%type
230: index by binary_integer;
231: l_org_id_tbl org_id_tbl;
232:
233: TYPE res_format_tbl is table of pa_resource_list_members.res_format_id%type

Line 233: TYPE res_format_tbl is table of pa_resource_list_members.res_format_id%type

229: TYPE org_id_tbl is table of pa_resource_list_members.organization_id%type
230: index by binary_integer;
231: l_org_id_tbl org_id_tbl;
232:
233: TYPE res_format_tbl is table of pa_resource_list_members.res_format_id%type
234: index by binary_integer;
235: l_res_format_tbl res_format_tbl;
236:
237: l_res_format_id_exists varchar2(1) := 'N';

Line 240: l_org_id pa_resource_list_members.organization_id%type;

236:
237: l_res_format_id_exists varchar2(1) := 'N';
238: l_stage VARCHAR2(240) :='';
239: l_res_format_id pa_res_formats_b.res_format_id%type;
240: l_org_id pa_resource_list_members.organization_id%type;
241: l_rev_cat pa_resource_list_members.revenue_category%type;
242: l_exp_cat pa_resource_list_members.expenditure_category%type;
243: l_res_class_id pa_resource_list_members.resource_class_id%type;
244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;

Line 241: l_rev_cat pa_resource_list_members.revenue_category%type;

237: l_res_format_id_exists varchar2(1) := 'N';
238: l_stage VARCHAR2(240) :='';
239: l_res_format_id pa_res_formats_b.res_format_id%type;
240: l_org_id pa_resource_list_members.organization_id%type;
241: l_rev_cat pa_resource_list_members.revenue_category%type;
242: l_exp_cat pa_resource_list_members.expenditure_category%type;
243: l_res_class_id pa_resource_list_members.resource_class_id%type;
244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;
245: l_res_class_code pa_resource_list_members.resource_class_code%type;

Line 242: l_exp_cat pa_resource_list_members.expenditure_category%type;

238: l_stage VARCHAR2(240) :='';
239: l_res_format_id pa_res_formats_b.res_format_id%type;
240: l_org_id pa_resource_list_members.organization_id%type;
241: l_rev_cat pa_resource_list_members.revenue_category%type;
242: l_exp_cat pa_resource_list_members.expenditure_category%type;
243: l_res_class_id pa_resource_list_members.resource_class_id%type;
244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;
245: l_res_class_code pa_resource_list_members.resource_class_code%type;
246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;

Line 243: l_res_class_id pa_resource_list_members.resource_class_id%type;

239: l_res_format_id pa_res_formats_b.res_format_id%type;
240: l_org_id pa_resource_list_members.organization_id%type;
241: l_rev_cat pa_resource_list_members.revenue_category%type;
242: l_exp_cat pa_resource_list_members.expenditure_category%type;
243: l_res_class_id pa_resource_list_members.resource_class_id%type;
244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;
245: l_res_class_code pa_resource_list_members.resource_class_code%type;
246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;
247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;

Line 244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;

240: l_org_id pa_resource_list_members.organization_id%type;
241: l_rev_cat pa_resource_list_members.revenue_category%type;
242: l_exp_cat pa_resource_list_members.expenditure_category%type;
243: l_res_class_id pa_resource_list_members.resource_class_id%type;
244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;
245: l_res_class_code pa_resource_list_members.resource_class_code%type;
246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;
247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;
248: l_object_id pa_resource_list_members.object_id%TYPE;

Line 245: l_res_class_code pa_resource_list_members.resource_class_code%type;

241: l_rev_cat pa_resource_list_members.revenue_category%type;
242: l_exp_cat pa_resource_list_members.expenditure_category%type;
243: l_res_class_id pa_resource_list_members.resource_class_id%type;
244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;
245: l_res_class_code pa_resource_list_members.resource_class_code%type;
246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;
247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;
248: l_object_id pa_resource_list_members.object_id%TYPE;
249: l_object_type pa_resource_list_members.object_type%TYPE;

Line 246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;

242: l_exp_cat pa_resource_list_members.expenditure_category%type;
243: l_res_class_id pa_resource_list_members.resource_class_id%type;
244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;
245: l_res_class_code pa_resource_list_members.resource_class_code%type;
246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;
247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;
248: l_object_id pa_resource_list_members.object_id%TYPE;
249: l_object_type pa_resource_list_members.object_type%TYPE;
250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;

Line 247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;

243: l_res_class_id pa_resource_list_members.resource_class_id%type;
244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;
245: l_res_class_code pa_resource_list_members.resource_class_code%type;
246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;
247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;
248: l_object_id pa_resource_list_members.object_id%TYPE;
249: l_object_type pa_resource_list_members.object_type%TYPE;
250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;
251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;

Line 248: l_object_id pa_resource_list_members.object_id%TYPE;

244: l_res_class_flag pa_resource_list_members.resource_class_flag%type;
245: l_res_class_code pa_resource_list_members.resource_class_code%type;
246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;
247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;
248: l_object_id pa_resource_list_members.object_id%TYPE;
249: l_object_type pa_resource_list_members.object_type%TYPE;
250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;
251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;
252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;

Line 249: l_object_type pa_resource_list_members.object_type%TYPE;

245: l_res_class_code pa_resource_list_members.resource_class_code%type;
246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;
247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;
248: l_object_id pa_resource_list_members.object_id%TYPE;
249: l_object_type pa_resource_list_members.object_type%TYPE;
250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;
251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;
252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;
253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;

Line 250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;

246: l_etc_method_code pa_resource_list_members.etc_method_code%TYPE;
247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;
248: l_object_id pa_resource_list_members.object_id%TYPE;
249: l_object_type pa_resource_list_members.object_type%TYPE;
250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;
251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;
252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;
253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;
254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;

Line 251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;

247: l_spread_curve_id pa_resource_list_members.spread_curve_id%TYPE;
248: l_object_id pa_resource_list_members.object_id%TYPE;
249: l_object_type pa_resource_list_members.object_type%TYPE;
250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;
251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;
252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;
253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;
254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;
255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;

Line 252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;

248: l_object_id pa_resource_list_members.object_id%TYPE;
249: l_object_type pa_resource_list_members.object_type%TYPE;
250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;
251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;
252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;
253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;
254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;
255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;
256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;

Line 253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;

249: l_object_type pa_resource_list_members.object_type%TYPE;
250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;
251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;
252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;
253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;
254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;
255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;
256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;
257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;

Line 254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;

250: --l_mfc_cost_type_id pa_resource_list_members.mfc_cost_type_id%TYPE;
251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;
252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;
253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;
254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;
255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;
256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;
257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;
258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;

Line 255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;

251: l_fc_res_type_code pa_resource_list_members.fc_res_type_code%type;
252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;
253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;
254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;
255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;
256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;
257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;
258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;

Line 256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;

252: l_inventory_item_id pa_resource_list_members.inventory_item_id%TYPE := NULL;
253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;
254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;
255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;
256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;
257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;
258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;

Line 257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;

253: l_item_category_id pa_resource_list_members.item_category_id%TYPE := NULL;
254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;
255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;
256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;
257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;
258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;
261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';

Line 258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;

254: l_migration_code pa_resource_list_members.migration_code%TYPE := NULL;
255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;
256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;
257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;
258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;
261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';
262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;

Line 259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;

255: g_last_updated_by pa_resource_list_members.last_updated_by%TYPE:= FND_GLOBAL.USER_ID;
256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;
257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;
258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;
261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';
262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;
263: l_incur_by_role_id pa_resource_list_members.incur_by_role_id%TYPE := NULL;

Line 260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;

256: g_last_update_date pa_resource_list_members.last_update_date%TYPE := SYSDATE;
257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;
258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;
261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';
262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;
263: l_incur_by_role_id pa_resource_list_members.incur_by_role_id%TYPE := NULL;
264: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE := NULL;

Line 261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';

257: g_creation_date pa_resource_list_members.creation_date%TYPE := SYSDATE;
258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;
261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';
262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;
263: l_incur_by_role_id pa_resource_list_members.incur_by_role_id%TYPE := NULL;
264: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE := NULL;
265: l_alias pa_resource_list_members.alias%TYPE := NULL;

Line 262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;

258: g_created_by pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;
261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';
262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;
263: l_incur_by_role_id pa_resource_list_members.incur_by_role_id%TYPE := NULL;
264: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE := NULL;
265: l_alias pa_resource_list_members.alias%TYPE := NULL;
266: l_indx NUMBER;

Line 263: l_incur_by_role_id pa_resource_list_members.incur_by_role_id%TYPE := NULL;

259: g_last_update_login pa_resource_list_members.last_update_login%TYPE := FND_GLOBAL.USER_ID;
260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;
261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';
262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;
263: l_incur_by_role_id pa_resource_list_members.incur_by_role_id%TYPE := NULL;
264: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE := NULL;
265: l_alias pa_resource_list_members.alias%TYPE := NULL;
266: l_indx NUMBER;
267: l_indx_count NUMBER;

Line 264: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE := NULL;

260: l_resource_id pa_resource_list_members.resource_id%TYPE :=-99;
261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';
262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;
263: l_incur_by_role_id pa_resource_list_members.incur_by_role_id%TYPE := NULL;
264: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE := NULL;
265: l_alias pa_resource_list_members.alias%TYPE := NULL;
266: l_indx NUMBER;
267: l_indx_count NUMBER;
268: l_res_list_exists_flag varchar2(1) :='N';

Line 265: l_alias pa_resource_list_members.alias%TYPE := NULL;

261: l_incur_by_res_flag pa_resource_list_members.incurred_by_res_flag%TYPE := 'N';
262: l_incur_by_res_code pa_resource_list_members.incur_by_res_class_code%TYPE := NULL;
263: l_incur_by_role_id pa_resource_list_members.incur_by_role_id%TYPE := NULL;
264: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE := NULL;
265: l_alias pa_resource_list_members.alias%TYPE := NULL;
266: l_indx NUMBER;
267: l_indx_count NUMBER;
268: l_res_list_exists_flag varchar2(1) :='N';
269: l_res_list_form_exists varchar2(1) :='N';

Line 298: l_updated_alias pa_resource_list_members.alias%TYPE := NULL;

294: l_exists_alias_id number := Null;
295: l_first_alias_id number := Null;
296: l_concat_no number := 0;
297: l_alias_concat varchar2(30):= Null;
298: l_updated_alias pa_resource_list_members.alias%TYPE := NULL;
299: l_res_parent_alias varchar2(80);
300: l_parent_member_id number := Null;
301:
302: l_enabled_flag varchar2(1); -- bug 3682103

Line 595: pa_debug.g_err_stage := 'Updating pa_resource_list_members table';

591: FROM pa_res_formats_b
592: WHERE res_format_id = l_res_format_id;
593:
594: IF l_debug_mode = 'Y' THEN
595: pa_debug.g_err_stage := 'Updating pa_resource_list_members table';
596: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
597: end if;
598: -- Update each resource list member with the info obtained above
599: update pa_resource_list_members

Line 599: update pa_resource_list_members

595: pa_debug.g_err_stage := 'Updating pa_resource_list_members table';
596: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
597: end if;
598: -- Update each resource list member with the info obtained above
599: update pa_resource_list_members
600: set res_format_id = l_res_format_id,
601: revenue_category = nvl(l_rev_cat,l_get_res_list_mem_id_csr.revenue_category),
602: expenditure_category = nvl(l_exp_cat,l_get_res_list_mem_id_csr.expenditure_category),
603: organization_id = nvl(l_org_id,l_get_res_list_mem_id_csr.organization_id),

Line 624: pa_debug.g_err_stage := 'Get alias and parent_member_id from pa_resource_list_members';

620: enabled_flag = nvl(l_enabled_flag, enabled_flag)
621: where resource_list_member_id = l_get_res_list_mem_id_csr.resource_list_member_id;
622:
623: IF l_debug_mode = 'Y' THEN
624: pa_debug.g_err_stage := 'Get alias and parent_member_id from pa_resource_list_members';
625: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
626: end if;
627:
628: Select

Line 635: pa_resource_list_members

631: Into
632: l_res_alias,
633: l_parent_member_id
634: from
635: pa_resource_list_members
636: where
637: resource_list_member_id = l_get_res_list_mem_id_csr.resource_list_member_id;
638:
639: IF l_debug_mode = 'Y' THEN

Line 665: pa_resource_list_members

661: alias
662: Into
663: l_res_parent_alias
664: from
665: pa_resource_list_members
666: where
667: resource_list_member_id = l_parent_member_id;
668:
669: IF l_debug_mode = 'Y' THEN

Line 676: pa_debug.g_err_stage := 'Update the pa_resource_list_members record with the combined alias';

672: end if;
673: l_res_alias := substr(l_res_parent_alias || ' - ' || l_res_alias,1,80);
674:
675: IF l_debug_mode = 'Y' THEN
676: pa_debug.g_err_stage := 'Update the pa_resource_list_members record with the combined alias';
677: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
678: end if;
679: update pa_resource_list_members
680: set alias = l_res_alias

Line 679: update pa_resource_list_members

675: IF l_debug_mode = 'Y' THEN
676: pa_debug.g_err_stage := 'Update the pa_resource_list_members record with the combined alias';
677: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
678: end if;
679: update pa_resource_list_members
680: set alias = l_res_alias
681: where resource_list_member_id = l_get_res_list_mem_id_csr.resource_list_member_id;
682:
683: End If;

Line 726: pa_debug.g_err_stage := 'Inserting into pa_resource_list_members table';

722: l_stage := 'ALIAS IS NULL';
723: RAISE null_alias;
724: end if;
725: IF l_debug_mode = 'Y' THEN
726: pa_debug.g_err_stage := 'Inserting into pa_resource_list_members table';
727: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
728: end if;
729:
730:

Line 746: FROM pa_resource_list_members

742:
743: BEGIN
744: SELECT resource_list_member_id
745: INTO l_exists_alias_id
746: FROM pa_resource_list_members
747: WHERE alias = l_updated_alias||l_alias_concat
748: AND resource_list_id =
749: l_get_res_list_id_csr.resource_list_id
750: AND object_type = 'RESOURCE_LIST'

Line 772: UPDATE pa_resource_list_members

768: END LOOP;
769:
770:
771: IF l_exists_alias_id IS NOT NULL THEN
772: UPDATE pa_resource_list_members
773: SET alias = l_updated_alias
774: WHERE resource_list_member_id =
775: l_first_alias_id;
776: END IF;

Line 780: insert into pa_resource_list_members(

776: END IF;
777: /* End of fix for bug 4766426 */
778: --dbms_output.put_line('R10.5');
779:
780: insert into pa_resource_list_members(
781: RESOURCE_LIST_MEMBER_ID,
782: RESOURCE_LIST_ID,
783: RESOURCE_ID,
784: ALIAS,

Line 828: (select pa_resource_list_members_s.NEXTVAL,

824: WP_ELIGIBLE_FLAG,
825: UNIT_OF_MEASURE,
826: PROJECT_ROLE_ID,
827: RECORD_VERSION_NUMBER)
828: (select pa_resource_list_members_s.NEXTVAL,
829: l_get_res_list_id_csr.resource_list_id,
830: l_resource_id,
831: l_alias,
832: null,