DBA Data[Home] [Help]

APPS.GCS_DP_DYNAMIC_PKG dependencies on FND_GLOBAL

Line 416: FND_GLOBAL.USER_ID,

412: SUM(fb.ytd_credit_balance_e) YTD_CREDIT_BALANCE_E,
413: SUM(NVL(fb.xtd_balance_f, fb.xtd_balance_e)) XTD_BALANCE_E,
414: SUM(NVL(fb.ytd_balance_f, fb.ytd_balance_e)) YTD_BALANCE_E,
415: SYSDATE,
416: FND_GLOBAL.USER_ID,
417: SYSDATE,
418: FND_GLOBAL.USER_ID,
419: FND_GLOBAL.LOGIN_ID ';
420: l_from_text := '

Line 418: FND_GLOBAL.USER_ID,

414: SUM(NVL(fb.ytd_balance_f, fb.ytd_balance_e)) YTD_BALANCE_E,
415: SYSDATE,
416: FND_GLOBAL.USER_ID,
417: SYSDATE,
418: FND_GLOBAL.USER_ID,
419: FND_GLOBAL.LOGIN_ID ';
420: l_from_text := '
421: FROM fem_balances fb,
422: fem_ledgers_attr fla,

Line 419: FND_GLOBAL.LOGIN_ID ';

415: SYSDATE,
416: FND_GLOBAL.USER_ID,
417: SYSDATE,
418: FND_GLOBAL.USER_ID,
419: FND_GLOBAL.LOGIN_ID ';
420: l_from_text := '
421: FROM fem_balances fb,
422: fem_ledgers_attr fla,
423: gcs_entity_cctr_orgs geco,

Line 1080: FND_GLOBAL.USER_ID,

1076: ''EXPENSE'', NVL(xtd_balance_e,0),
1077: NVL(ytd_balance_e,0))),
1078: SUM (NVL (ytd_balance_e, 0)),
1079: SYSDATE,
1080: FND_GLOBAL.USER_ID,
1081: SYSDATE,
1082: FND_GLOBAL.USER_ID,
1083: FND_GLOBAL.LOGIN_ID
1084: FROM gcs_entry_lines_gt fb,

Line 1082: FND_GLOBAL.USER_ID,

1078: SUM (NVL (ytd_balance_e, 0)),
1079: SYSDATE,
1080: FND_GLOBAL.USER_ID,
1081: SYSDATE,
1082: FND_GLOBAL.USER_ID,
1083: FND_GLOBAL.LOGIN_ID
1084: FROM gcs_entry_lines_gt fb,
1085: fem_ln_items_attr flia,
1086: fem_ext_acct_types_attr fea_attr

Line 1083: FND_GLOBAL.LOGIN_ID

1079: SYSDATE,
1080: FND_GLOBAL.USER_ID,
1081: SYSDATE,
1082: FND_GLOBAL.USER_ID,
1083: FND_GLOBAL.LOGIN_ID
1084: FROM gcs_entry_lines_gt fb,
1085: fem_ln_items_attr flia,
1086: fem_ext_acct_types_attr fea_attr
1087: WHERE fb.line_item_id = flia.line_item_id

Line 1120: FND_GLOBAL.USER_ID,

1116: 'EXPENSE', NVL(xtd_balance_e,0),
1117: NVL(ytd_balance_e,0))),
1118: SUM (NVL (ytd_balance_e, 0)),
1119: SYSDATE,
1120: FND_GLOBAL.USER_ID,
1121: SYSDATE,
1122: FND_GLOBAL.USER_ID,
1123: FND_GLOBAL.LOGIN_ID
1124: FROM gcs_entry_lines_gt fb,

Line 1122: FND_GLOBAL.USER_ID,

1118: SUM (NVL (ytd_balance_e, 0)),
1119: SYSDATE,
1120: FND_GLOBAL.USER_ID,
1121: SYSDATE,
1122: FND_GLOBAL.USER_ID,
1123: FND_GLOBAL.LOGIN_ID
1124: FROM gcs_entry_lines_gt fb,
1125: fem_ln_items_attr flia,
1126: fem_ext_acct_types_attr fea_attr

Line 1123: FND_GLOBAL.LOGIN_ID

1119: SYSDATE,
1120: FND_GLOBAL.USER_ID,
1121: SYSDATE,
1122: FND_GLOBAL.USER_ID,
1123: FND_GLOBAL.LOGIN_ID
1124: FROM gcs_entry_lines_gt fb,
1125: fem_ln_items_attr flia,
1126: fem_ext_acct_types_attr fea_attr
1127: WHERE fb.line_item_id = flia.line_item_id

Line 1617: FND_GLOBAL.USER_ID,

1613: SUM(fb.ytd_credit_balance_e) YTD_CREDIT_BALANCE_E,
1614: SUM(NVL(fb.xtd_balance_f, fb.xtd_balance_e)) XTD_BALANCE_E,
1615: SUM(NVL(fb.ytd_balance_f, fb.ytd_balance_e)) YTD_BALANCE_E,
1616: SYSDATE,
1617: FND_GLOBAL.USER_ID,
1618: SYSDATE,
1619: FND_GLOBAL.USER_ID,
1620: FND_GLOBAL.LOGIN_ID
1621: FROM fem_balances fb,

Line 1619: FND_GLOBAL.USER_ID,

1615: SUM(NVL(fb.ytd_balance_f, fb.ytd_balance_e)) YTD_BALANCE_E,
1616: SYSDATE,
1617: FND_GLOBAL.USER_ID,
1618: SYSDATE,
1619: FND_GLOBAL.USER_ID,
1620: FND_GLOBAL.LOGIN_ID
1621: FROM fem_balances fb,
1622: fem_ledgers_attr fla,
1623: gcs_entity_cctr_orgs geco,

Line 1620: FND_GLOBAL.LOGIN_ID

1616: SYSDATE,
1617: FND_GLOBAL.USER_ID,
1618: SYSDATE,
1619: FND_GLOBAL.USER_ID,
1620: FND_GLOBAL.LOGIN_ID
1621: FROM fem_balances fb,
1622: fem_ledgers_attr fla,
1623: gcs_entity_cctr_orgs geco,
1624: gcs_cons_impact_analyses gcia,

Line 1665: FND_GLOBAL.USER_ID,

1661: SUM(fb.ytd_credit_balance_e) YTD_CREDIT_BALANCE_E,
1662: SUM(NVL(fb.xtd_balance_f, fb.xtd_balance_e)) XTD_BALANCE_E,
1663: SUM(NVL(fb.ytd_balance_f, fb.ytd_balance_e)) YTD_BALANCE_E,
1664: SYSDATE,
1665: FND_GLOBAL.USER_ID,
1666: SYSDATE,
1667: FND_GLOBAL.USER_ID,
1668: FND_GLOBAL.LOGIN_ID
1669: FROM fem_balances fb,

Line 1667: FND_GLOBAL.USER_ID,

1663: SUM(NVL(fb.ytd_balance_f, fb.ytd_balance_e)) YTD_BALANCE_E,
1664: SYSDATE,
1665: FND_GLOBAL.USER_ID,
1666: SYSDATE,
1667: FND_GLOBAL.USER_ID,
1668: FND_GLOBAL.LOGIN_ID
1669: FROM fem_balances fb,
1670: fem_ledgers_attr fla,
1671: gcs_entity_cctr_orgs geco,

Line 1668: FND_GLOBAL.LOGIN_ID

1664: SYSDATE,
1665: FND_GLOBAL.USER_ID,
1666: SYSDATE,
1667: FND_GLOBAL.USER_ID,
1668: FND_GLOBAL.LOGIN_ID
1669: FROM fem_balances fb,
1670: fem_ledgers_attr fla,
1671: gcs_entity_cctr_orgs geco,
1672: gcs_cons_impact_analyses gcia,

Line 1705: || fnd_global.user_id ||', '|| fnd_global.login_id ||', '|| p_source_ledger_id ||', '

1701: 'EXECUTE IMMEDIATE g_insert_statement '
1702: || g_nl
1703: || ' USING '
1704: || x_stat_entry_id || ', ' || x_entry_id ||', '
1705: || fnd_global.user_id ||', '|| fnd_global.login_id ||', '|| p_source_ledger_id ||', '
1706: || g_ledger_ssc_attr_id ||', '
1707: || g_ledger_ssc_ver_id ||', '
1708: || p_currency_type_code ||', '|| p_hierarchy_id ||', '
1709: || p_entity_id ||', '|| p_balance_type_code ||', '

Line 1722: fnd_global.user_id, fnd_global.user_id, fnd_global.login_id, p_source_ledger_id,

1718: );
1719: END IF;
1720: EXECUTE IMMEDIATE g_insert_statement
1721: USING x_stat_entry_id, x_entry_id,
1722: fnd_global.user_id, fnd_global.user_id, fnd_global.login_id, p_source_ledger_id,
1723: g_ledger_ssc_attr_id, g_ledger_ssc_ver_id, p_currency_type_code,
1724: p_entity_id, p_balance_type_code, g_ln_item_vs_id, g_li_eat_attr_id,
1725: g_eatc_batc_attr_id, g_li_eat_ver_id, g_eatc_batc_ver_id,
1726: p_source_currency_code, p_source_dataset_code, p_run_name,