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.

[Home] [Help]

APPS.JA_CN_POST_UTILITY_PKG dependencies on FND_GLOBAL

Line 283: , fnd_global.USER_ID

279: , gp.period_year
280: , decode(gp.period_num,1,'Y','N')
281: , 'O'
282: , SYSDATE
283: , fnd_global.USER_ID
284: , SYSDATE
285: , fnd_global.USER_ID
286: , fnd_global.LOGIN_ID
287: FROM gl_ledgers led

Line 285: , fnd_global.USER_ID

281: , 'O'
282: , SYSDATE
283: , fnd_global.USER_ID
284: , SYSDATE
285: , fnd_global.USER_ID
286: , fnd_global.LOGIN_ID
287: FROM gl_ledgers led
288: , gl_periods gp
289: WHERE led.ledger_id=p_ledger_id

Line 286: , fnd_global.LOGIN_ID

282: , SYSDATE
283: , fnd_global.USER_ID
284: , SYSDATE
285: , fnd_global.USER_ID
286: , fnd_global.LOGIN_ID
287: FROM gl_ledgers led
288: , gl_periods gp
289: WHERE led.ledger_id=p_ledger_id
290: AND led.period_set_name = gp.period_set_name

Line 398: , fnd_global.USER_ID

394: , 0
395: , 0
396: , 0
397: , l_period_month
398: , fnd_global.USER_ID
399: , SYSDATE
400: , fnd_global.USER_ID
401: , SYSDATE
402: , fnd_global.LOGIN_ID

Line 400: , fnd_global.USER_ID

396: , 0
397: , l_period_month
398: , fnd_global.USER_ID
399: , SYSDATE
400: , fnd_global.USER_ID
401: , SYSDATE
402: , fnd_global.LOGIN_ID
403: FROM ja_cn_account_balances_v a
404: WHERE a.ledger_id = p_ledger_id

Line 402: , fnd_global.LOGIN_ID

398: , fnd_global.USER_ID
399: , SYSDATE
400: , fnd_global.USER_ID
401: , SYSDATE
402: , fnd_global.LOGIN_ID
403: FROM ja_cn_account_balances_v a
404: WHERE a.ledger_id = p_ledger_id
405: AND a.legal_entity_id = p_legal_entity_ID
406: AND a.period_name = l_prior_period_name;

Line 532: , last_updated_by = fnd_global.USER_ID

528: SET func_begin_balance_dr = l_ret_acct_balance_dr_beq
529: , func_begin_balance_cr = l_ret_acct_balance_cr_beq
530: , orig_begin_balance_dr = l_ret_acct_balance_dr
531: , Orig_Begin_Balance_Cr = l_ret_acct_balance_cr
532: , last_updated_by = fnd_global.USER_ID
533: , last_update_date = SYSDATE
534: , last_update_login = fnd_global.LOGIN_ID
535: WHERE ledger_id = p_ledger_id
536: AND legal_entity_id = p_legal_entity_ID

Line 534: , last_update_login = fnd_global.LOGIN_ID

530: , orig_begin_balance_dr = l_ret_acct_balance_dr
531: , Orig_Begin_Balance_Cr = l_ret_acct_balance_cr
532: , last_updated_by = fnd_global.USER_ID
533: , last_update_date = SYSDATE
534: , last_update_login = fnd_global.LOGIN_ID
535: WHERE ledger_id = p_ledger_id
536: AND legal_entity_id = p_legal_entity_ID
537: AND company_segment = l_ret_company_segment
538: AND period_name = p_period_name

Line 604: , fnd_global.USER_ID

600: , 0
601: , 0
602: , 0
603: , l_period_month
604: , fnd_global.USER_ID
605: , SYSDATE
606: , fnd_global.USER_ID
607: , SYSDATE
608: , fnd_global.LOGIN_ID);

Line 606: , fnd_global.USER_ID

602: , 0
603: , l_period_month
604: , fnd_global.USER_ID
605: , SYSDATE
606: , fnd_global.USER_ID
607: , SYSDATE
608: , fnd_global.LOGIN_ID);
609: END IF;
610: EXCEPTION --get retain ccid and its balance

Line 608: , fnd_global.LOGIN_ID);

604: , fnd_global.USER_ID
605: , SYSDATE
606: , fnd_global.USER_ID
607: , SYSDATE
608: , fnd_global.LOGIN_ID);
609: END IF;
610: EXCEPTION --get retain ccid and its balance
611: WHEN NO_DATA_FOUND THEN
612: IF( G_PROC_LEVEL >= g_debug_devel )

Line 700: , LAST_UPDATED_BY = fnd_global.USER_ID

696: SET FUNC_PERIOD_NET_DR = FUNC_PERIOD_NET_DR + p_balance_rec.FUNC_PERIOD_NET_DR
697: , FUNC_PERIOD_NET_CR = FUNC_PERIOD_NET_CR + p_balance_rec.FUNC_PERIOD_NET_CR
698: , ORIG_PERIOD_NET_DR = ORIG_PERIOD_NET_DR + p_balance_rec.ORIG_PERIOD_NET_DR
699: , ORIG_PERIOD_NET_CR = ORIG_PERIOD_NET_CR + p_balance_rec.ORIG_PERIOD_NET_CR
700: , LAST_UPDATED_BY = fnd_global.USER_ID
701: , LAST_UPDATE_DATE = SYSDATE
702: , LAST_UPDATE_LOGIN = fnd_global.login_id
703: WHERE ledger_id = p_balance_rec.ledger_id
704: AND LEGAL_ENTITY_ID = p_balance_rec.LEGAL_ENTITY_ID

Line 702: , LAST_UPDATE_LOGIN = fnd_global.login_id

698: , ORIG_PERIOD_NET_DR = ORIG_PERIOD_NET_DR + p_balance_rec.ORIG_PERIOD_NET_DR
699: , ORIG_PERIOD_NET_CR = ORIG_PERIOD_NET_CR + p_balance_rec.ORIG_PERIOD_NET_CR
700: , LAST_UPDATED_BY = fnd_global.USER_ID
701: , LAST_UPDATE_DATE = SYSDATE
702: , LAST_UPDATE_LOGIN = fnd_global.login_id
703: WHERE ledger_id = p_balance_rec.ledger_id
704: AND LEGAL_ENTITY_ID = p_balance_rec.LEGAL_ENTITY_ID
705: AND COMPANY_SEGMENT = p_balance_rec.COMPANY_SEGMENT
706: AND PERIOD_NAME = p_balance_rec.PERIOD_NAME

Line 804: , fnd_global.USER_ID

800: , p_balance_rec.FUNC_PERIOD_NET_CR
801: , p_balance_rec.ORIG_PERIOD_NET_DR
802: , p_balance_rec.ORIG_PERIOD_NET_CR
803: , p_balance_rec.PERIOD_MON
804: , fnd_global.USER_ID
805: , SYSDATE
806: , fnd_global.USER_ID
807: , SYSDATE
808: , fnd_global.login_id

Line 806: , fnd_global.USER_ID

802: , p_balance_rec.ORIG_PERIOD_NET_CR
803: , p_balance_rec.PERIOD_MON
804: , fnd_global.USER_ID
805: , SYSDATE
806: , fnd_global.USER_ID
807: , SYSDATE
808: , fnd_global.login_id
809: );
810: END IF; --SQL%ROWCOUNT = 0

Line 808: , fnd_global.login_id

804: , fnd_global.USER_ID
805: , SYSDATE
806: , fnd_global.USER_ID
807: , SYSDATE
808: , fnd_global.login_id
809: );
810: END IF; --SQL%ROWCOUNT = 0
811: ELSE --p_current_period_flag='Y'
812: UPDATE ja_cn_account_balances

Line 817: , LAST_UPDATED_BY = fnd_global.USER_ID

813: SET FUNC_begin_BALANCE_DR = FUNC_begin_BALANCE_DR + p_balance_rec.FUNC_PERIOD_NET_DR
814: , FUNC_begin_BALANCE_CR = FUNC_begin_BALANCE_cR + p_balance_rec.FUNC_PERIOD_NET_CR
815: , ORIG_begin_BALANCE_DR = FUNC_begin_BALANCE_DR + p_balance_rec.ORIG_PERIOD_NET_DR
816: , ORIG_begin_BALANCE_CR = FUNC_begin_BALANCE_cR + p_balance_rec.ORIG_PERIOD_NET_CR
817: , LAST_UPDATED_BY = fnd_global.USER_ID
818: , LAST_UPDATE_DATE = SYSDATE
819: , LAST_UPDATE_LOGIN = fnd_global.login_id
820: WHERE ledger_id = p_balance_rec.ledger_id
821: AND LEGAL_ENTITY_ID = p_balance_rec.LEGAL_ENTITY_ID

Line 819: , LAST_UPDATE_LOGIN = fnd_global.login_id

815: , ORIG_begin_BALANCE_DR = FUNC_begin_BALANCE_DR + p_balance_rec.ORIG_PERIOD_NET_DR
816: , ORIG_begin_BALANCE_CR = FUNC_begin_BALANCE_cR + p_balance_rec.ORIG_PERIOD_NET_CR
817: , LAST_UPDATED_BY = fnd_global.USER_ID
818: , LAST_UPDATE_DATE = SYSDATE
819: , LAST_UPDATE_LOGIN = fnd_global.login_id
820: WHERE ledger_id = p_balance_rec.ledger_id
821: AND LEGAL_ENTITY_ID = p_balance_rec.LEGAL_ENTITY_ID
822: AND COMPANY_SEGMENT = p_balance_rec.COMPANY_SEGMENT
823: AND PERIOD_NAME = p_balance_rec.PERIOD_NAME

Line 920: , fnd_global.USER_ID

916: , 0
917: , 0
918: , 0
919: , p_balance_rec.PERIOD_MON
920: , fnd_global.USER_ID
921: , SYSDATE
922: , fnd_global.USER_ID
923: , SYSDATE
924: , fnd_global.login_id

Line 922: , fnd_global.USER_ID

918: , 0
919: , p_balance_rec.PERIOD_MON
920: , fnd_global.USER_ID
921: , SYSDATE
922: , fnd_global.USER_ID
923: , SYSDATE
924: , fnd_global.login_id
925: );
926: END IF; --SQL%ROWCOUNT = 0

Line 924: , fnd_global.login_id

920: , fnd_global.USER_ID
921: , SYSDATE
922: , fnd_global.USER_ID
923: , SYSDATE
924: , fnd_global.login_id
925: );
926: END IF; --SQL%ROWCOUNT = 0
927: END IF;--p_current_period_flag='Y'
928:

Line 1119: , fnd_global.USER_ID

1115: , 0
1116: , jcp.period_num - jcp.period_year*1000
1117: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1)
1118: , jcp.period_num
1119: , fnd_global.USER_ID
1120: , SYSDATE
1121: , fnd_global.USER_ID
1122: , SYSDATE
1123: , fnd_global.LOGIN_ID

Line 1121: , fnd_global.USER_ID

1117: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1)
1118: , jcp.period_num
1119: , fnd_global.USER_ID
1120: , SYSDATE
1121: , fnd_global.USER_ID
1122: , SYSDATE
1123: , fnd_global.LOGIN_ID
1124: FROM ja_cn_code_combination_v jcc
1125: , FND_FLEX_VALUES ffv

Line 1123: , fnd_global.LOGIN_ID

1119: , fnd_global.USER_ID
1120: , SYSDATE
1121: , fnd_global.USER_ID
1122: , SYSDATE
1123: , fnd_global.LOGIN_ID
1124: FROM ja_cn_code_combination_v jcc
1125: , FND_FLEX_VALUES ffv
1126: , ja_cn_periods jcp
1127: WHERE jcc.ledger_id = p_ledger_id

Line 1201: , fnd_global.USER_ID

1197: , 0
1198: , jcp.period_num - jcp.period_year*1000
1199: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1)
1200: , jcp.period_num
1201: , fnd_global.USER_ID
1202: , SYSDATE
1203: , fnd_global.USER_ID
1204: , SYSDATE
1205: , fnd_global.LOGIN_ID

Line 1203: , fnd_global.USER_ID

1199: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1)
1200: , jcp.period_num
1201: , fnd_global.USER_ID
1202: , SYSDATE
1203: , fnd_global.USER_ID
1204: , SYSDATE
1205: , fnd_global.LOGIN_ID
1206: FROM ja_cn_code_combination_v jcc
1207: , FND_FLEX_VALUES ffv

Line 1205: , fnd_global.LOGIN_ID

1201: , fnd_global.USER_ID
1202: , SYSDATE
1203: , fnd_global.USER_ID
1204: , SYSDATE
1205: , fnd_global.LOGIN_ID
1206: FROM ja_cn_code_combination_v jcc
1207: , FND_FLEX_VALUES ffv
1208: , ja_cn_periods jcp
1209: WHERE jcc.ledger_id = p_ledger_id

Line 1412: , fnd_global.USER_ID

1408: , ORIG_PERIOD_NET_DR
1409: , ORIG_PERIOD_NET_CR
1410: , PERIOD_MON
1411: , ACCOUNT_TYPE
1412: , fnd_global.USER_ID
1413: , SYSDATE
1414: , fnd_global.USER_ID
1415: , SYSDATE
1416: , fnd_global.LOGIN_ID

Line 1414: , fnd_global.USER_ID

1410: , PERIOD_MON
1411: , ACCOUNT_TYPE
1412: , fnd_global.USER_ID
1413: , SYSDATE
1414: , fnd_global.USER_ID
1415: , SYSDATE
1416: , fnd_global.LOGIN_ID
1417: FROM ja_cn_account_balances_post_gt;
1418:

Line 1416: , fnd_global.LOGIN_ID

1412: , fnd_global.USER_ID
1413: , SYSDATE
1414: , fnd_global.USER_ID
1415: , SYSDATE
1416: , fnd_global.LOGIN_ID
1417: FROM ja_cn_account_balances_post_gt;
1418:
1419: /* -- delete the old parent account balance
1420: DELETE ja_cn_account_balances jcb

Line 1491: , fnd_global.USER_ID

1487: , SUM(nvl(gb.period_net_dr,0))
1488: , SUM(nvl(gb.period_net_cr,0))
1489: , gb.period_num
1490: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1)
1491: , fnd_global.USER_ID
1492: , SYSDATE
1493: , fnd_global.USER_ID
1494: , SYSDATE
1495: , fnd_global.LOGIN_ID

Line 1493: , fnd_global.USER_ID

1489: , gb.period_num
1490: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1)
1491: , fnd_global.USER_ID
1492: , SYSDATE
1493: , fnd_global.USER_ID
1494: , SYSDATE
1495: , fnd_global.LOGIN_ID
1496: FROM gl_balances gb
1497: , ja_cn_code_combination_v jcc

Line 1495: , fnd_global.LOGIN_ID

1491: , fnd_global.USER_ID
1492: , SYSDATE
1493: , fnd_global.USER_ID
1494: , SYSDATE
1495: , fnd_global.LOGIN_ID
1496: FROM gl_balances gb
1497: , ja_cn_code_combination_v jcc
1498: , fnd_flex_values ffv
1499: WHERE gb.ledger_id = p_ledger_id

Line 1650: , fnd_global.USER_ID

1646: , SUM(nvl(FUNC_PERIOD_NET_DR,0))
1647: , SUM(nvl(FUNC_PERIOD_NET_CR,0))
1648: , jcb.period_mon
1649: , jcc.parent_type
1650: , fnd_global.USER_ID
1651: , SYSDATE
1652: , fnd_global.USER_ID
1653: , SYSDATE
1654: , fnd_global.LOGIN_ID

Line 1652: , fnd_global.USER_ID

1648: , jcb.period_mon
1649: , jcc.parent_type
1650: , fnd_global.USER_ID
1651: , SYSDATE
1652: , fnd_global.USER_ID
1653: , SYSDATE
1654: , fnd_global.LOGIN_ID
1655: FROM ja_cn_account_balances jcb
1656: , JA_CN_ACCOUNT_CHILDREN_GT jcc

Line 1654: , fnd_global.LOGIN_ID

1650: , fnd_global.USER_ID
1651: , SYSDATE
1652: , fnd_global.USER_ID
1653: , SYSDATE
1654: , fnd_global.LOGIN_ID
1655: FROM ja_cn_account_balances jcb
1656: , JA_CN_ACCOUNT_CHILDREN_GT jcc
1657: , ja_cn_periods jcp
1658: WHERE jcc.child_account = jcb.account_segment

Line 1731: , fnd_global.USER_ID

1727: , SUM(nvl(gb.period_net_dr,0))
1728: , SUM(nvl(gb.period_net_cr,0))
1729: , gb.period_num
1730: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1)
1731: , fnd_global.USER_ID
1732: , SYSDATE
1733: , fnd_global.USER_ID
1734: , SYSDATE
1735: , fnd_global.LOGIN_ID

Line 1733: , fnd_global.USER_ID

1729: , gb.period_num
1730: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1)
1731: , fnd_global.USER_ID
1732: , SYSDATE
1733: , fnd_global.USER_ID
1734: , SYSDATE
1735: , fnd_global.LOGIN_ID
1736: FROM ja_cn_periods jcp
1737: , ja_cn_account_balances jca

Line 1735: , fnd_global.LOGIN_ID

1731: , fnd_global.USER_ID
1732: , SYSDATE
1733: , fnd_global.USER_ID
1734: , SYSDATE
1735: , fnd_global.LOGIN_ID
1736: FROM ja_cn_periods jcp
1737: , ja_cn_account_balances jca
1738: , FND_FLEX_VALUE_CHILDREN_V ffvc
1739: , fnd_flex_values ffv