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.FEM_HIER_UTILS_PVT dependencies on FND_GLOBAL

Line 13: g_current_user_id NUMBER := NVL(Fnd_Global.User_Id , 0) ;

9: --
10: -- WHO columns variables
11: --
12: g_current_date DATE := sysdate ;
13: g_current_user_id NUMBER := NVL(Fnd_Global.User_Id , 0) ;
14: g_current_login_id NUMBER := NVL(Fnd_Global.Login_Id, 0) ;
15:
16: -- Type definition for cursor
17: TYPE dhm_cur_type is REF CURSOR;

Line 14: g_current_login_id NUMBER := NVL(Fnd_Global.Login_Id, 0) ;

10: -- WHO columns variables
11: --
12: g_current_date DATE := sysdate ;
13: g_current_user_id NUMBER := NVL(Fnd_Global.User_Id , 0) ;
14: g_current_login_id NUMBER := NVL(Fnd_Global.Login_Id, 0) ;
15:
16: -- Type definition for cursor
17: TYPE dhm_cur_type is REF CURSOR;
18:

Line 2041: l_last_Updated_by := FND_GLOBAL.User_Id;

2037:
2038: p_return_status := FND_API.G_RET_STS_SUCCESS ;
2039: l_creation_date := SYSDATE ;
2040: l_last_update_date := SYSDATE;
2041: l_last_Updated_by := FND_GLOBAL.User_Id;
2042: l_created_by := FND_GLOBAL.User_Id;
2043: l_last_update_login := FND_GLOBAL.Login_Id ;
2044:
2045: IF p_vs_required_flag = 'Y' THEN

Line 2042: l_created_by := FND_GLOBAL.User_Id;

2038: p_return_status := FND_API.G_RET_STS_SUCCESS ;
2039: l_creation_date := SYSDATE ;
2040: l_last_update_date := SYSDATE;
2041: l_last_Updated_by := FND_GLOBAL.User_Id;
2042: l_created_by := FND_GLOBAL.User_Id;
2043: l_last_update_login := FND_GLOBAL.Login_Id ;
2044:
2045: IF p_vs_required_flag = 'Y' THEN
2046: l_sql_stmt := 'INSERT INTO '||p_hier_table_name||

Line 2043: l_last_update_login := FND_GLOBAL.Login_Id ;

2039: l_creation_date := SYSDATE ;
2040: l_last_update_date := SYSDATE;
2041: l_last_Updated_by := FND_GLOBAL.User_Id;
2042: l_created_by := FND_GLOBAL.User_Id;
2043: l_last_update_login := FND_GLOBAL.Login_Id ;
2044:
2045: IF p_vs_required_flag = 'Y' THEN
2046: l_sql_stmt := 'INSERT INTO '||p_hier_table_name||
2047: ' ( '||

Line 2297: l_last_Updated_by := FND_GLOBAL.User_Id;

2293: p_return_status := FND_API.G_RET_STS_SUCCESS ;
2294:
2295: l_creation_date := SYSDATE ;
2296: l_last_update_date := SYSDATE;
2297: l_last_Updated_by := FND_GLOBAL.User_Id;
2298: l_created_by := FND_GLOBAL.User_Id;
2299: l_last_update_login := FND_GLOBAL.Login_Id ;
2300:
2301: open l_object_catalog_details_csr (p_object_id => p_src_hier_obj_id);

Line 2298: l_created_by := FND_GLOBAL.User_Id;

2294:
2295: l_creation_date := SYSDATE ;
2296: l_last_update_date := SYSDATE;
2297: l_last_Updated_by := FND_GLOBAL.User_Id;
2298: l_created_by := FND_GLOBAL.User_Id;
2299: l_last_update_login := FND_GLOBAL.Login_Id ;
2300:
2301: open l_object_catalog_details_csr (p_object_id => p_src_hier_obj_id);
2302: fetch l_object_catalog_details_csr into l_object_catalog_details_rec;

Line 2299: l_last_update_login := FND_GLOBAL.Login_Id ;

2295: l_creation_date := SYSDATE ;
2296: l_last_update_date := SYSDATE;
2297: l_last_Updated_by := FND_GLOBAL.User_Id;
2298: l_created_by := FND_GLOBAL.User_Id;
2299: l_last_update_login := FND_GLOBAL.Login_Id ;
2300:
2301: open l_object_catalog_details_csr (p_object_id => p_src_hier_obj_id);
2302: fetch l_object_catalog_details_csr into l_object_catalog_details_rec;
2303: close l_object_catalog_details_csr;

Line 2738: l_created_by NUMBER := fnd_global.user_id;

2734:
2735: l_version_start_date DATE;
2736:
2737: l_creation_date DATE := sysdate;
2738: l_created_by NUMBER := fnd_global.user_id;
2739: l_last_update_date DATE := sysdate;
2740: l_last_Updated_by NUMBER := fnd_global.user_id;
2741: l_last_update_login NUMBER := fnd_global.login_id;
2742:

Line 2740: l_last_Updated_by NUMBER := fnd_global.user_id;

2736:
2737: l_creation_date DATE := sysdate;
2738: l_created_by NUMBER := fnd_global.user_id;
2739: l_last_update_date DATE := sysdate;
2740: l_last_Updated_by NUMBER := fnd_global.user_id;
2741: l_last_update_login NUMBER := fnd_global.login_id;
2742:
2743: BEGIN
2744:

Line 2741: l_last_update_login NUMBER := fnd_global.login_id;

2737: l_creation_date DATE := sysdate;
2738: l_created_by NUMBER := fnd_global.user_id;
2739: l_last_update_date DATE := sysdate;
2740: l_last_Updated_by NUMBER := fnd_global.user_id;
2741: l_last_update_login NUMBER := fnd_global.login_id;
2742:
2743: BEGIN
2744:
2745: -- dbms_output.put_line('copy_hier_data: start ...');

Line 4368: l_created_by NUMBER := fnd_global.user_id;

4364: p_dest_start_date IN DATE,
4365: p_dest_end_date IN DATE) IS
4366:
4367: l_creation_date DATE := sysdate;
4368: l_created_by NUMBER := fnd_global.user_id;
4369: l_last_update_date DATE := sysdate;
4370: l_last_Updated_by NUMBER := fnd_global.user_id;
4371: l_last_update_login NUMBER := fnd_global.login_id;
4372:

Line 4370: l_last_Updated_by NUMBER := fnd_global.user_id;

4366:
4367: l_creation_date DATE := sysdate;
4368: l_created_by NUMBER := fnd_global.user_id;
4369: l_last_update_date DATE := sysdate;
4370: l_last_Updated_by NUMBER := fnd_global.user_id;
4371: l_last_update_login NUMBER := fnd_global.login_id;
4372:
4373: l_new_version_id NUMBER;
4374:

Line 4371: l_last_update_login NUMBER := fnd_global.login_id;

4367: l_creation_date DATE := sysdate;
4368: l_created_by NUMBER := fnd_global.user_id;
4369: l_last_update_date DATE := sysdate;
4370: l_last_Updated_by NUMBER := fnd_global.user_id;
4371: l_last_update_login NUMBER := fnd_global.login_id;
4372:
4373: l_new_version_id NUMBER;
4374:
4375: l_object_definition_rec FEM_OBJECT_DEFINITION_VL%rowtype;

Line 4571: AND USER_ID = FND_GLOBAL.USER_ID ;

4567: SELECT WRITE_FLAG
4568: INTO l_write_status
4569: FROM FEM_USER_FOLDERS
4570: WHERE FOLDER_ID = p_folder_id
4571: AND USER_ID = FND_GLOBAL.USER_ID ;
4572:
4573: if l_hier_version_status = 'PENDING_DELETION' then
4574: l_delete_status := 'N';
4575: end if;

Line 4785: AND USER_ID = FND_GLOBAL.USER_ID ;

4781: SELECT WRITE_FLAG
4782: INTO l_write_status
4783: FROM FEM_USER_FOLDERS
4784: WHERE FOLDER_ID = p_folder_id
4785: AND USER_ID = FND_GLOBAL.USER_ID ;
4786:
4787: if l_hier_status = 'PENDING_DELETION' then
4788: l_delete_status := 'N';
4789: end if;

Line 5977: l_last_update_login NUMBER:= FND_GLOBAL.Login_Id ;

5973: l_display_order_num NUMBER;
5974: l_depth_gap NUMBER;
5975: l_old_child_depth_num NUMBER;
5976: l_weighting_pct NUMBER(3,2);
5977: l_last_update_login NUMBER:= FND_GLOBAL.Login_Id ;
5978: l_detailed_row_count NUMBER := 0;
5979: l_leaf_row_count NUMBER := 0;
5980: l_req_id NUMBER;
5981: l_rowid VARCHAR2(20);

Line 7179: l_user_id NUMBER := FND_GLOBAL.User_Id;

7175: l_hierarchy_table_name VARCHAR2(30) ;
7176: l_per_hierarchy_table_name VARCHAR2(30) ;
7177: l_value_set_required_flag VARCHAR2(1) ;
7178: l_is_reorder_allowed VARCHAR2(1) := 'N' ;
7179: l_user_id NUMBER := FND_GLOBAL.User_Id;
7180:
7181: BEGIN
7182:
7183: -- Find out the metadata information.

Line 7594: l_cal_period_id NUMBER := FND_PROFILE.Value_Specific('FEM_PERIOD',FND_GLOBAL.USER_ID);

7590: l_is_prior_version VARCHAR2(1) := 'N';
7591:
7592: l_child_sequence_num NUMBER;
7593:
7594: l_cal_period_id NUMBER := FND_PROFILE.Value_Specific('FEM_PERIOD',FND_GLOBAL.USER_ID);
7595: --l_dataset_code NUMBER := -999;
7596:
7597: --Bug#4252397: Fetch dataset code from profile.
7598: l_dataset_code NUMBER := FND_PROFILE.Value_Specific('FEM_DATASET',FND_GLOBAL.USER_ID);

Line 7598: l_dataset_code NUMBER := FND_PROFILE.Value_Specific('FEM_DATASET',FND_GLOBAL.USER_ID);

7594: l_cal_period_id NUMBER := FND_PROFILE.Value_Specific('FEM_PERIOD',FND_GLOBAL.USER_ID);
7595: --l_dataset_code NUMBER := -999;
7596:
7597: --Bug#4252397: Fetch dataset code from profile.
7598: l_dataset_code NUMBER := FND_PROFILE.Value_Specific('FEM_DATASET',FND_GLOBAL.USER_ID);
7599:
7600: CURSOR l_hier_ver_details_csr (c_version_id IN NUMBER)
7601: IS
7602: SELECT effective_start_date,

Line 8426: l_dataset_code NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_DATASET',FND_GLOBAL.USER_ID);

8422: l_relationship_id NUMBER;
8423: l_version_start_date DATE;
8424:
8425: -- Bug#5723800 : Begin
8426: l_dataset_code NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_DATASET',FND_GLOBAL.USER_ID);
8427: l_cal_period_id NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_PERIOD',FND_GLOBAL.USER_ID);
8428: l_insert_flag VARCHAR2(1) := 'Y';
8429: l_creation_date DATE := SYSDATE;
8430: l_last_update_date DATE := SYSDATE;

Line 8427: l_cal_period_id NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_PERIOD',FND_GLOBAL.USER_ID);

8423: l_version_start_date DATE;
8424:
8425: -- Bug#5723800 : Begin
8426: l_dataset_code NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_DATASET',FND_GLOBAL.USER_ID);
8427: l_cal_period_id NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_PERIOD',FND_GLOBAL.USER_ID);
8428: l_insert_flag VARCHAR2(1) := 'Y';
8429: l_creation_date DATE := SYSDATE;
8430: l_last_update_date DATE := SYSDATE;
8431: l_last_Updated_by NUMBER := FND_GLOBAL.User_Id;

Line 8431: l_last_Updated_by NUMBER := FND_GLOBAL.User_Id;

8427: l_cal_period_id NUMBER := FND_PROFILE.VALUE_SPECIFIC('FEM_PERIOD',FND_GLOBAL.USER_ID);
8428: l_insert_flag VARCHAR2(1) := 'Y';
8429: l_creation_date DATE := SYSDATE;
8430: l_last_update_date DATE := SYSDATE;
8431: l_last_Updated_by NUMBER := FND_GLOBAL.User_Id;
8432: l_created_by NUMBER := FND_GLOBAL.User_Id;
8433: l_last_update_login NUMBER := FND_GLOBAL.Login_Id;
8434: -- Bug#5723800 : End
8435:

Line 8432: l_created_by NUMBER := FND_GLOBAL.User_Id;

8428: l_insert_flag VARCHAR2(1) := 'Y';
8429: l_creation_date DATE := SYSDATE;
8430: l_last_update_date DATE := SYSDATE;
8431: l_last_Updated_by NUMBER := FND_GLOBAL.User_Id;
8432: l_created_by NUMBER := FND_GLOBAL.User_Id;
8433: l_last_update_login NUMBER := FND_GLOBAL.Login_Id;
8434: -- Bug#5723800 : End
8435:
8436: CURSOR l_version_csr (c_version_id IN NUMBER)

Line 8433: l_last_update_login NUMBER := FND_GLOBAL.Login_Id;

8429: l_creation_date DATE := SYSDATE;
8430: l_last_update_date DATE := SYSDATE;
8431: l_last_Updated_by NUMBER := FND_GLOBAL.User_Id;
8432: l_created_by NUMBER := FND_GLOBAL.User_Id;
8433: l_last_update_login NUMBER := FND_GLOBAL.Login_Id;
8434: -- Bug#5723800 : End
8435:
8436: CURSOR l_version_csr (c_version_id IN NUMBER)
8437: IS