APPS.FEM_WEBADI_FACT_TAB_UTILS_PVT dependencies on FND_GLOBAL

Line 5: G_LEDGER_ID NUMBER := FND_PROFILE.Value_Specific('FEM_LEDGER',FND_GLOBAL.USER_ID);

1: PACKAGE BODY FEM_WEBADI_FACT_TAB_UTILS_PVT AS
2: /* $Header: FEMVADIFCTRUTILB.pls 120.5 2008/02/20 06:48:27 jcliving noship $ */
3:
4: G_OBJECT_DEFINITION_ID NUMBER := NULL;
5: G_LEDGER_ID NUMBER := FND_PROFILE.Value_Specific('FEM_LEDGER',FND_GLOBAL.USER_ID);
6: G_OBJECT_ID NUMBER := NULL;
7: G_ENTER_IN_DIMS VARCHAR2(1) := NULL;
8:
9: PROCEDURE UPLOAD_FACTOR_TABLE1_INTERFACE(

Line 43: l_user_id number := FND_GLOBAL.USER_ID;

39: P_DISTRIBUTION_DIM_MEM VARCHAR2,
40: P_AMOUNT VARCHAR2)
41: IS
42:
43: l_user_id number := FND_GLOBAL.USER_ID;
44: l_update_login number := FND_GLOBAL.LOGIN_ID;
45: l_row_num number := NULL;
46: l_parent_row_num number := -1;
47: l_level_num number := 0;

Line 44: l_update_login number := FND_GLOBAL.LOGIN_ID;

40: P_AMOUNT VARCHAR2)
41: IS
42:
43: l_user_id number := FND_GLOBAL.USER_ID;
44: l_update_login number := FND_GLOBAL.LOGIN_ID;
45: l_row_num number := NULL;
46: l_parent_row_num number := -1;
47: l_level_num number := 0;
48: l_dimension_member varchar2(30);

Line 203: l_user_id number := FND_GLOBAL.USER_ID;

199: P_MATCHING_DIM3_MEM VARCHAR2,
200: P_AMOUNT VARCHAR2)
201: IS
202:
203: l_user_id number := FND_GLOBAL.USER_ID;
204: l_update_login number := FND_GLOBAL.LOGIN_ID;
205: l_row_num number := NULL;
206: l_parent_row_num number := -1;
207: l_level_num number := 0;

Line 204: l_update_login number := FND_GLOBAL.LOGIN_ID;

200: P_AMOUNT VARCHAR2)
201: IS
202:
203: l_user_id number := FND_GLOBAL.USER_ID;
204: l_update_login number := FND_GLOBAL.LOGIN_ID;
205: l_row_num number := NULL;
206: l_parent_row_num number := -1;
207: l_level_num number := 0;
208: l_dimension_member varchar2(30);

Line 347: l_user_id number := FND_GLOBAL.USER_ID;

343: P_DISTRIBUTION_DIM_MEM VARCHAR2,
344: P_AMOUNT VARCHAR2)
345: IS
346:
347: l_user_id number := FND_GLOBAL.USER_ID;
348: l_update_login number := FND_GLOBAL.LOGIN_ID;
349: l_row_num number := NULL;
350: l_parent_row_num number := -1;
351: l_level_num number := 0;

Line 348: l_update_login number := FND_GLOBAL.LOGIN_ID;

344: P_AMOUNT VARCHAR2)
345: IS
346:
347: l_user_id number := FND_GLOBAL.USER_ID;
348: l_update_login number := FND_GLOBAL.LOGIN_ID;
349: l_row_num number := NULL;
350: l_parent_row_num number := -1;
351: l_level_num number := 0;
352: l_dimension_member varchar2(30);

Line 423: l_user_id number := FND_GLOBAL.USER_ID;

419: l_old_rule varchar2(1) := NULL;
420: l_object_type_code varchar2(30):= 'FACTOR_TABLE';
421: l_folder_id number;
422: l_local_vs_combo_id number := p_vs_combo_id;
423: l_user_id number := FND_GLOBAL.USER_ID;
424: l_object_access_code varchar2(30);
425: l_object_origin_code varchar2(30):= 'USER';
426: l_update_login number := FND_GLOBAL.LOGIN_ID;
427:

Line 426: l_update_login number := FND_GLOBAL.LOGIN_ID;

422: l_local_vs_combo_id number := p_vs_combo_id;
423: l_user_id number := FND_GLOBAL.USER_ID;
424: l_object_access_code varchar2(30);
425: l_object_origin_code varchar2(30):= 'USER';
426: l_update_login number := FND_GLOBAL.LOGIN_ID;
427:
428: BEGIN
429: select folder_id into l_folder_id from fem_folders_vl where folder_name = P_FOLDER_NAME;
430:

Line 493: l_user_id number := FND_GLOBAL.USER_ID;

489: P_DISTRIBUTION_DIM VARCHAR2,
490: P_FORCE_TO_HUNDRED VARCHAR2)
491: IS
492:
493: l_user_id number := FND_GLOBAL.USER_ID;
494: l_update_login number := FND_GLOBAL.LOGIN_ID;
495: l_factor_type_code varchar2(50);
496: l_dim_id number := NULL;
497: l_hier_obj_id number := NULL;

Line 494: l_update_login number := FND_GLOBAL.LOGIN_ID;

490: P_FORCE_TO_HUNDRED VARCHAR2)
491: IS
492:
493: l_user_id number := FND_GLOBAL.USER_ID;
494: l_update_login number := FND_GLOBAL.LOGIN_ID;
495: l_factor_type_code varchar2(50);
496: l_dim_id number := NULL;
497: l_hier_obj_id number := NULL;
498: l_hier_obj_def_id number := NULL;