DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on FND_GLOBAL

Line 2351: fnd_global.user_id USER_ID_1,

2347: p_trx_line_dist_tbl.GLOBAL_ATTRIBUTE1(i),
2348: NVL(p_trx_line_dist_tbl.TOTAL_INC_TAX_AMT(i),0),
2349: DECODE(ZX_API_PUB.G_PUB_SRVC,'CALCULATE_TAX', ZX_SECURITY.G_ICX_SESSION_ID, null),
2350: SYSDATE SYSTEM_DATE_1,
2351: fnd_global.user_id USER_ID_1,
2352: SYSDATE SYSTEM_DATE_2,
2353: fnd_global.user_id USER_ID_2,
2354: fnd_global.conc_login_id
2355: FROM DUAL

Line 2353: fnd_global.user_id USER_ID_2,

2349: DECODE(ZX_API_PUB.G_PUB_SRVC,'CALCULATE_TAX', ZX_SECURITY.G_ICX_SESSION_ID, null),
2350: SYSDATE SYSTEM_DATE_1,
2351: fnd_global.user_id USER_ID_1,
2352: SYSDATE SYSTEM_DATE_2,
2353: fnd_global.user_id USER_ID_2,
2354: fnd_global.conc_login_id
2355: FROM DUAL
2356: WHERE p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IS NOT NULL
2357: AND NOT EXISTS (SELECT 'Y'

Line 2354: fnd_global.conc_login_id

2350: SYSDATE SYSTEM_DATE_1,
2351: fnd_global.user_id USER_ID_1,
2352: SYSDATE SYSTEM_DATE_2,
2353: fnd_global.user_id USER_ID_2,
2354: fnd_global.conc_login_id
2355: FROM DUAL
2356: WHERE p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IS NOT NULL
2357: AND NOT EXISTS (SELECT 'Y'
2358: FROM zx_errors_gt err_gt

Line 2948: fnd_global.user_id USER_ID_1,

2944: p_trx_line_dist_tbl.GLOBAL_ATTRIBUTE1(i),
2945: NVL(p_trx_line_dist_tbl.TOTAL_INC_TAX_AMT(i),0),
2946: DECODE(ZX_API_PUB.G_PUB_SRVC,'CALCULATE_TAX', ZX_SECURITY.G_ICX_SESSION_ID, null),
2947: SYSDATE SYSTEM_DATE_1,
2948: fnd_global.user_id USER_ID_1,
2949: SYSDATE SYSTEM_DATE_2,
2950: fnd_global.user_id USER_ID_2,
2951: fnd_global.conc_login_id
2952: FROM DUAL

Line 2950: fnd_global.user_id USER_ID_2,

2946: DECODE(ZX_API_PUB.G_PUB_SRVC,'CALCULATE_TAX', ZX_SECURITY.G_ICX_SESSION_ID, null),
2947: SYSDATE SYSTEM_DATE_1,
2948: fnd_global.user_id USER_ID_1,
2949: SYSDATE SYSTEM_DATE_2,
2950: fnd_global.user_id USER_ID_2,
2951: fnd_global.conc_login_id
2952: FROM DUAL
2953: WHERE p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IS NOT NULL
2954: AND p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IN

Line 2951: fnd_global.conc_login_id

2947: SYSDATE SYSTEM_DATE_1,
2948: fnd_global.user_id USER_ID_1,
2949: SYSDATE SYSTEM_DATE_2,
2950: fnd_global.user_id USER_ID_2,
2951: fnd_global.conc_login_id
2952: FROM DUAL
2953: WHERE p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IS NOT NULL
2954: AND p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IN
2955: ('CREATE',

Line 3396: LAST_UPDATED_BY = fnd_global.user_id,

3392: TOTAL_INC_TAX_AMT = DECODE(p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i), 'NO_CHANGE', TOTAL_INC_TAX_AMT,
3393: NVL(p_trx_line_dist_tbl.TOTAL_INC_TAX_AMT(i),0)),
3394: ICX_SESSION_ID = DECODE (ZX_API_PUB.G_PUB_SRVC,'CALCULATE_TAX', ZX_SECURITY.G_ICX_SESSION_ID, null),
3395: LAST_UPDATE_DATE = sysdate,
3396: LAST_UPDATED_BY = fnd_global.user_id,
3397: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
3398: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
3399: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
3400: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE

Line 3397: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

3393: NVL(p_trx_line_dist_tbl.TOTAL_INC_TAX_AMT(i),0)),
3394: ICX_SESSION_ID = DECODE (ZX_API_PUB.G_PUB_SRVC,'CALCULATE_TAX', ZX_SECURITY.G_ICX_SESSION_ID, null),
3395: LAST_UPDATE_DATE = sysdate,
3396: LAST_UPDATED_BY = fnd_global.user_id,
3397: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
3398: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
3399: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
3400: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
3401: AND TRX_ID = p_trx_line_dist_tbl.TRX_ID(i)

Line 3699: LAST_UPDATED_BY = fnd_global.user_id,

3695: TOTAL_INC_TAX_AMT = DECODE(p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i), 'NO_CHANGE', TOTAL_INC_TAX_AMT,
3696: NVL(p_trx_line_dist_tbl.TOTAL_INC_TAX_AMT(i),0)),
3697: ICX_SESSION_ID = DECODE (ZX_API_PUB.G_PUB_SRVC,'CALCULATE_TAX', ZX_SECURITY.G_ICX_SESSION_ID, null),
3698: LAST_UPDATE_DATE = sysdate,
3699: LAST_UPDATED_BY = fnd_global.user_id,
3700: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
3701: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
3702: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
3703: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE

Line 3700: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

3696: NVL(p_trx_line_dist_tbl.TOTAL_INC_TAX_AMT(i),0)),
3697: ICX_SESSION_ID = DECODE (ZX_API_PUB.G_PUB_SRVC,'CALCULATE_TAX', ZX_SECURITY.G_ICX_SESSION_ID, null),
3698: LAST_UPDATE_DATE = sysdate,
3699: LAST_UPDATED_BY = fnd_global.user_id,
3700: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
3701: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
3702: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
3703: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
3704: AND TRX_ID = p_trx_line_dist_tbl.TRX_ID(i)