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

Line 680: fnd_user_id := fnd_global.user_id;

676: END IF;
677: -- If we have reached the desired parent entity, create the necessary rows.
678: -- Otherwise keep going up the hierarchy.
679: IF p_current_entity_id = p_parent_entity_id THEN
680: fnd_user_id := fnd_global.user_id;
681: fnd_login_id := fnd_global.login_id;
682: -- Initialize the previous end date to be the day prior to the start date
683: -- of the new range
684: last_end_date := p_start_date - 1;

Line 681: fnd_login_id := fnd_global.login_id;

677: -- If we have reached the desired parent entity, create the necessary rows.
678: -- Otherwise keep going up the hierarchy.
679: IF p_current_entity_id = p_parent_entity_id THEN
680: fnd_user_id := fnd_global.user_id;
681: fnd_login_id := fnd_global.login_id;
682: -- Initialize the previous end date to be the day prior to the start date
683: -- of the new range
684: last_end_date := p_start_date - 1;
685: -- Go through each of the delta rows, and perform the necessary actions

Line 1457: FND_GLOBAL.USER_ID,

1453: other_row.treatment_id,
1454: null,
1455: 1,
1456: sysdate,
1457: FND_GLOBAL.USER_ID,
1458: sysdate,
1459: FND_GLOBAL.USER_ID,
1460: FND_GLOBAL.LOGIN_ID,
1461: other_row.end_date,

Line 1459: FND_GLOBAL.USER_ID,

1455: 1,
1456: sysdate,
1457: FND_GLOBAL.USER_ID,
1458: sysdate,
1459: FND_GLOBAL.USER_ID,
1460: FND_GLOBAL.LOGIN_ID,
1461: other_row.end_date,
1462: 'N',
1463: other_row.actual_ownership_flag);

Line 1460: FND_GLOBAL.LOGIN_ID,

1456: sysdate,
1457: FND_GLOBAL.USER_ID,
1458: sysdate,
1459: FND_GLOBAL.USER_ID,
1460: FND_GLOBAL.LOGIN_ID,
1461: other_row.end_date,
1462: 'N',
1463: other_row.actual_ownership_flag);
1464: UPDATE gcs_cons_relationships r

Line 1467: last_updated_by = FND_GLOBAL.USER_ID,

1463: other_row.actual_ownership_flag);
1464: UPDATE gcs_cons_relationships r
1465: SET end_date = l_start_date - 1,
1466: last_update_date = sysdate,
1467: last_updated_by = FND_GLOBAL.USER_ID,
1468: last_update_login = FND_GLOBAL.LOGIN_ID
1469: WHERE r.cons_relationship_id = other_row.cons_relationship_id;
1470: ELSE
1471: UPDATE gcs_cons_relationships r

Line 1468: last_update_login = FND_GLOBAL.LOGIN_ID

1464: UPDATE gcs_cons_relationships r
1465: SET end_date = l_start_date - 1,
1466: last_update_date = sysdate,
1467: last_updated_by = FND_GLOBAL.USER_ID,
1468: last_update_login = FND_GLOBAL.LOGIN_ID
1469: WHERE r.cons_relationship_id = other_row.cons_relationship_id;
1470: ELSE
1471: UPDATE gcs_cons_relationships r
1472: SET dominant_parent_flag = 'N',

Line 1475: last_updated_by = FND_GLOBAL.USER_ID,

1471: UPDATE gcs_cons_relationships r
1472: SET dominant_parent_flag = 'N',
1473: curr_treatment_id = null,
1474: last_update_date = sysdate,
1475: last_updated_by = FND_GLOBAL.USER_ID,
1476: last_update_login = FND_GLOBAL.LOGIN_ID
1477: WHERE r.cons_relationship_id = other_row.cons_relationship_id;
1478: END IF;
1479: END LOOP;

Line 1476: last_update_login = FND_GLOBAL.LOGIN_ID

1472: SET dominant_parent_flag = 'N',
1473: curr_treatment_id = null,
1474: last_update_date = sysdate,
1475: last_updated_by = FND_GLOBAL.USER_ID,
1476: last_update_login = FND_GLOBAL.LOGIN_ID
1477: WHERE r.cons_relationship_id = other_row.cons_relationship_id;
1478: END IF;
1479: END LOOP;
1480: ELSIF l_treat_type = 'NONE' THEN

Line 1521: FND_GLOBAL.USER_ID,

1517: l_treat_id,
1518: null,
1519: 1,
1520: sysdate,
1521: FND_GLOBAL.USER_ID,
1522: sysdate,
1523: FND_GLOBAL.USER_ID,
1524: FND_GLOBAL.LOGIN_ID,
1525: future_full_row.end_date,

Line 1523: FND_GLOBAL.USER_ID,

1519: 1,
1520: sysdate,
1521: FND_GLOBAL.USER_ID,
1522: sysdate,
1523: FND_GLOBAL.USER_ID,
1524: FND_GLOBAL.LOGIN_ID,
1525: future_full_row.end_date,
1526: 'N',
1527: 'Y');

Line 1524: FND_GLOBAL.LOGIN_ID,

1520: sysdate,
1521: FND_GLOBAL.USER_ID,
1522: sysdate,
1523: FND_GLOBAL.USER_ID,
1524: FND_GLOBAL.LOGIN_ID,
1525: future_full_row.end_date,
1526: 'N',
1527: 'Y');
1528: IF future_full_row.end_date IS NOT NULL THEN

Line 1558: FND_GLOBAL.USER_ID,

1554: l_treat_id,
1555: l_ccy_treat_id,
1556: 1,
1557: sysdate,
1558: FND_GLOBAL.USER_ID,
1559: sysdate,
1560: FND_GLOBAL.USER_ID,
1561: FND_GLOBAL.LOGIN_ID,
1562: null,

Line 1560: FND_GLOBAL.USER_ID,

1556: 1,
1557: sysdate,
1558: FND_GLOBAL.USER_ID,
1559: sysdate,
1560: FND_GLOBAL.USER_ID,
1561: FND_GLOBAL.LOGIN_ID,
1562: null,
1563: 'Y',
1564: 'Y');

Line 1561: FND_GLOBAL.LOGIN_ID,

1557: sysdate,
1558: FND_GLOBAL.USER_ID,
1559: sysdate,
1560: FND_GLOBAL.USER_ID,
1561: FND_GLOBAL.LOGIN_ID,
1562: null,
1563: 'Y',
1564: 'Y');
1565: END IF;

Line 1601: FND_GLOBAL.USER_ID,

1597: r.treatment_id,
1598: null,
1599: 1,
1600: sysdate,
1601: FND_GLOBAL.USER_ID,
1602: sysdate,
1603: FND_GLOBAL.USER_ID,
1604: FND_GLOBAL.LOGIN_ID,
1605: r.end_date,

Line 1603: FND_GLOBAL.USER_ID,

1599: 1,
1600: sysdate,
1601: FND_GLOBAL.USER_ID,
1602: sysdate,
1603: FND_GLOBAL.USER_ID,
1604: FND_GLOBAL.LOGIN_ID,
1605: r.end_date,
1606: 'N',
1607: 'Y'

Line 1604: FND_GLOBAL.LOGIN_ID,

1600: sysdate,
1601: FND_GLOBAL.USER_ID,
1602: sysdate,
1603: FND_GLOBAL.USER_ID,
1604: FND_GLOBAL.LOGIN_ID,
1605: r.end_date,
1606: 'N',
1607: 'Y'
1608: FROM gcs_cons_relationships r

Line 1690: FND_GLOBAL.USER_ID,

1686: l_treat_id,
1687: l_ccy_treat_id,
1688: 1,
1689: sysdate,
1690: FND_GLOBAL.USER_ID,
1691: sysdate,
1692: FND_GLOBAL.USER_ID,
1693: FND_GLOBAL.LOGIN_ID,
1694: future_rel_row.start_date - 1,

Line 1692: FND_GLOBAL.USER_ID,

1688: 1,
1689: sysdate,
1690: FND_GLOBAL.USER_ID,
1691: sysdate,
1692: FND_GLOBAL.USER_ID,
1693: FND_GLOBAL.LOGIN_ID,
1694: future_rel_row.start_date - 1,
1695: 'Y',
1696: 'Y');

Line 1693: FND_GLOBAL.LOGIN_ID,

1689: sysdate,
1690: FND_GLOBAL.USER_ID,
1691: sysdate,
1692: FND_GLOBAL.USER_ID,
1693: FND_GLOBAL.LOGIN_ID,
1694: future_rel_row.start_date - 1,
1695: 'Y',
1696: 'Y');
1697: INSERT INTO gcs_cons_relationships

Line 1726: FND_GLOBAL.USER_ID,

1722: l_treat_id,
1723: null,
1724: 1,
1725: sysdate,
1726: FND_GLOBAL.USER_ID,
1727: sysdate,
1728: FND_GLOBAL.USER_ID,
1729: FND_GLOBAL.LOGIN_ID,
1730: null,

Line 1728: FND_GLOBAL.USER_ID,

1724: 1,
1725: sysdate,
1726: FND_GLOBAL.USER_ID,
1727: sysdate,
1728: FND_GLOBAL.USER_ID,
1729: FND_GLOBAL.LOGIN_ID,
1730: null,
1731: 'N',
1732: 'Y');

Line 1729: FND_GLOBAL.LOGIN_ID,

1725: sysdate,
1726: FND_GLOBAL.USER_ID,
1727: sysdate,
1728: FND_GLOBAL.USER_ID,
1729: FND_GLOBAL.LOGIN_ID,
1730: null,
1731: 'N',
1732: 'Y');
1733: END IF;

Line 1779: FND_GLOBAL.USER_ID,

1775: l_treat_id,
1776: l_ccy_treat_id,
1777: 1,
1778: sysdate,
1779: FND_GLOBAL.USER_ID,
1780: sysdate,
1781: FND_GLOBAL.USER_ID,
1782: FND_GLOBAL.LOGIN_ID,
1783: null,

Line 1781: FND_GLOBAL.USER_ID,

1777: 1,
1778: sysdate,
1779: FND_GLOBAL.USER_ID,
1780: sysdate,
1781: FND_GLOBAL.USER_ID,
1782: FND_GLOBAL.LOGIN_ID,
1783: null,
1784: 'Y',
1785: 'Y');

Line 1782: FND_GLOBAL.LOGIN_ID,

1778: sysdate,
1779: FND_GLOBAL.USER_ID,
1780: sysdate,
1781: FND_GLOBAL.USER_ID,
1782: FND_GLOBAL.LOGIN_ID,
1783: null,
1784: 'Y',
1785: 'Y');
1786: END IF;

Line 1946: FND_GLOBAL.USER_ID,

1942: p_treat_id,
1943: l_ccy_treat_id,
1944: 1,
1945: sysdate,
1946: FND_GLOBAL.USER_ID,
1947: sysdate,
1948: FND_GLOBAL.USER_ID,
1949: FND_GLOBAL.LOGIN_ID,
1950: dominant_rel_row.start_date - 1,

Line 1948: FND_GLOBAL.USER_ID,

1944: 1,
1945: sysdate,
1946: FND_GLOBAL.USER_ID,
1947: sysdate,
1948: FND_GLOBAL.USER_ID,
1949: FND_GLOBAL.LOGIN_ID,
1950: dominant_rel_row.start_date - 1,
1951: 'Y',
1952: 'Y');

Line 1949: FND_GLOBAL.LOGIN_ID,

1945: sysdate,
1946: FND_GLOBAL.USER_ID,
1947: sysdate,
1948: FND_GLOBAL.USER_ID,
1949: FND_GLOBAL.LOGIN_ID,
1950: dominant_rel_row.start_date - 1,
1951: 'Y',
1952: 'Y');
1953: IF dominant_rel_row.end_date IS NULL OR

Line 1988: FND_GLOBAL.USER_ID,

1984: p_treat_id,
1985: null,
1986: 1,
1987: sysdate,
1988: FND_GLOBAL.USER_ID,
1989: sysdate,
1990: FND_GLOBAL.USER_ID,
1991: FND_GLOBAL.LOGIN_ID,
1992: l_temp_end_date,

Line 1990: FND_GLOBAL.USER_ID,

1986: 1,
1987: sysdate,
1988: FND_GLOBAL.USER_ID,
1989: sysdate,
1990: FND_GLOBAL.USER_ID,
1991: FND_GLOBAL.LOGIN_ID,
1992: l_temp_end_date,
1993: 'N',
1994: 'Y');

Line 1991: FND_GLOBAL.LOGIN_ID,

1987: sysdate,
1988: FND_GLOBAL.USER_ID,
1989: sysdate,
1990: FND_GLOBAL.USER_ID,
1991: FND_GLOBAL.LOGIN_ID,
1992: l_temp_end_date,
1993: 'N',
1994: 'Y');
1995: END IF;

Line 2047: FND_GLOBAL.USER_ID,

2043: p_treat_id,
2044: l_ccy_treat_id,
2045: 1,
2046: sysdate,
2047: FND_GLOBAL.USER_ID,
2048: sysdate,
2049: FND_GLOBAL.USER_ID,
2050: FND_GLOBAL.LOGIN_ID,
2051: p_end_date,

Line 2049: FND_GLOBAL.USER_ID,

2045: 1,
2046: sysdate,
2047: FND_GLOBAL.USER_ID,
2048: sysdate,
2049: FND_GLOBAL.USER_ID,
2050: FND_GLOBAL.LOGIN_ID,
2051: p_end_date,
2052: 'Y',
2053: 'Y');

Line 2050: FND_GLOBAL.LOGIN_ID,

2046: sysdate,
2047: FND_GLOBAL.USER_ID,
2048: sysdate,
2049: FND_GLOBAL.USER_ID,
2050: FND_GLOBAL.LOGIN_ID,
2051: p_end_date,
2052: 'Y',
2053: 'Y');
2054: END IF;

Line 2167: FND_GLOBAL.USER_ID,

2163: null,
2164: null,
2165: 1,
2166: sysdate,
2167: FND_GLOBAL.USER_ID,
2168: sysdate,
2169: FND_GLOBAL.USER_ID,
2170: FND_GLOBAL.LOGIN_ID,
2171: l_end_date,

Line 2169: FND_GLOBAL.USER_ID,

2165: 1,
2166: sysdate,
2167: FND_GLOBAL.USER_ID,
2168: sysdate,
2169: FND_GLOBAL.USER_ID,
2170: FND_GLOBAL.LOGIN_ID,
2171: l_end_date,
2172: 'Y',
2173: 'Y'

Line 2170: FND_GLOBAL.LOGIN_ID,

2166: sysdate,
2167: FND_GLOBAL.USER_ID,
2168: sysdate,
2169: FND_GLOBAL.USER_ID,
2170: FND_GLOBAL.LOGIN_ID,
2171: l_end_date,
2172: 'Y',
2173: 'Y'
2174: FROM fem_entities_attr fea,

Line 2335: fnd_global.user_id,

2331: (l_hier_info(l_counter).hier_id,
2332: l_base_balance_type,
2333: l_base_ds_code,
2334: sysdate,
2335: fnd_global.user_id,
2336: sysdate,
2337: fnd_global.user_id,
2338: fnd_global.login_id);
2339:

Line 2337: fnd_global.user_id,

2333: l_base_ds_code,
2334: sysdate,
2335: fnd_global.user_id,
2336: sysdate,
2337: fnd_global.user_id,
2338: fnd_global.login_id);
2339:
2340: -- Create a dataset for the analyze balance type
2341: FEM_DIMENSION_UTIL_PKG.new_dataset(x_err_code => l_analyze_err_code,

Line 2338: fnd_global.login_id);

2334: sysdate,
2335: fnd_global.user_id,
2336: sysdate,
2337: fnd_global.user_id,
2338: fnd_global.login_id);
2339:
2340: -- Create a dataset for the analyze balance type
2341: FEM_DIMENSION_UTIL_PKG.new_dataset(x_err_code => l_analyze_err_code,
2342: x_num_msg => l_analyze_num_msg,

Line 2374: fnd_global.user_id,

2370: (l_hier_info(l_counter).hier_id,
2371: l_analyze_balance_type,
2372: l_analyze_ds_code,
2373: sysdate,
2374: fnd_global.user_id,
2375: sysdate,
2376: fnd_global.user_id,
2377: fnd_global.login_id);
2378: END LOOP;

Line 2376: fnd_global.user_id,

2372: l_analyze_ds_code,
2373: sysdate,
2374: fnd_global.user_id,
2375: sysdate,
2376: fnd_global.user_id,
2377: fnd_global.login_id);
2378: END LOOP;
2379: END IF;
2380: END Update_Hierarchies_Datatype;

Line 2377: fnd_global.login_id);

2373: sysdate,
2374: fnd_global.user_id,
2375: sysdate,
2376: fnd_global.user_id,
2377: fnd_global.login_id);
2378: END LOOP;
2379: END IF;
2380: END Update_Hierarchies_Datatype;
2381:

Line 2534: fnd_global.user_id,

2530: (p_hierarchy_id,
2531: l_base_balance_type,
2532: l_base_ds_code,
2533: sysdate,
2534: fnd_global.user_id,
2535: sysdate,
2536: fnd_global.user_id,
2537: fnd_global.login_id);
2538:

Line 2536: fnd_global.user_id,

2532: l_base_ds_code,
2533: sysdate,
2534: fnd_global.user_id,
2535: sysdate,
2536: fnd_global.user_id,
2537: fnd_global.login_id);
2538:
2539: -- Create a dataset for the analyze balance type
2540: FEM_DIMENSION_UTIL_PKG.new_dataset(x_err_code => l_analyze_err_code,

Line 2537: fnd_global.login_id);

2533: sysdate,
2534: fnd_global.user_id,
2535: sysdate,
2536: fnd_global.user_id,
2537: fnd_global.login_id);
2538:
2539: -- Create a dataset for the analyze balance type
2540: FEM_DIMENSION_UTIL_PKG.new_dataset(x_err_code => l_analyze_err_code,
2541: x_num_msg => l_analyze_num_msg,

Line 2573: fnd_global.user_id,

2569: (p_hierarchy_id,
2570: l_analyze_balance_type,
2571: l_analyze_ds_code,
2572: sysdate,
2573: fnd_global.user_id,
2574: sysdate,
2575: fnd_global.user_id,
2576: fnd_global.login_id);
2577: END LOOP;

Line 2575: fnd_global.user_id,

2571: l_analyze_ds_code,
2572: sysdate,
2573: fnd_global.user_id,
2574: sysdate,
2575: fnd_global.user_id,
2576: fnd_global.login_id);
2577: END LOOP;
2578: END IF;
2579: END Handle_Datatypes;

Line 2576: fnd_global.login_id);

2572: sysdate,
2573: fnd_global.user_id,
2574: sysdate,
2575: fnd_global.user_id,
2576: fnd_global.login_id);
2577: END LOOP;
2578: END IF;
2579: END Handle_Datatypes;
2580: