DBA Data[Home] [Help]

APPS.AR_ARHLVOUT_XMLP_PKG dependencies on FND_GLOBAL

Line 5: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

1: PACKAGE BODY AR_ARHLVOUT_XMLP_PKG AS
2: /* $Header: ARHLVOUTB.pls 120.0 2008/01/24 14:53:02 dwkrishn noship $ */
3: FUNCTION AFTERPFORM RETURN BOOLEAN IS
4: BEGIN
5: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
6: SELECT
7: BAT.BATCH_NAME,
8: BAT.ORIGINAL_SYSTEM,
9: TRUNC(BAT.CREATION_DATE),

Line 28: AND p_lkp.security_group_id (+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HZ_IMP_BATCH_DEDUP_ACTIONS',222)

24: FND_LOOKUP_VALUES CP_LKP
25: WHERE BATCH_ID = P_BATCH_ID
26: AND p_lkp.language (+) = USERENV('LANG')
27: AND p_lkp.view_application_id (+) = 222
28: AND p_lkp.security_group_id (+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HZ_IMP_BATCH_DEDUP_ACTIONS',222)
29: AND p_lkp.lookup_type (+) = 'HZ_IMP_BATCH_DEDUP_ACTIONS'
30: AND p_lkp.lookup_code (+) = BD_ACTION_ON_PARTIES
31: AND a_lkp.language (+) = USERENV('LANG')
32: AND a_lkp.view_application_id (+) = 222

Line 33: AND a_lkp.security_group_id (+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HZ_IMP_BATCH_DEDUP_ACTIONS',222)

29: AND p_lkp.lookup_type (+) = 'HZ_IMP_BATCH_DEDUP_ACTIONS'
30: AND p_lkp.lookup_code (+) = BD_ACTION_ON_PARTIES
31: AND a_lkp.language (+) = USERENV('LANG')
32: AND a_lkp.view_application_id (+) = 222
33: AND a_lkp.security_group_id (+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HZ_IMP_BATCH_DEDUP_ACTIONS',222)
34: AND a_lkp.lookup_type (+) = 'HZ_IMP_BATCH_DEDUP_ACTIONS'
35: AND a_lkp.lookup_code (+) = BD_ACTION_ON_ADDRESSES
36: AND c_lkp.language (+) = USERENV('LANG')
37: AND c_lkp.view_application_id (+) = 222

Line 38: AND c_lkp.security_group_id (+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HZ_IMP_BATCH_DEDUP_ACTIONS',222)

34: AND a_lkp.lookup_type (+) = 'HZ_IMP_BATCH_DEDUP_ACTIONS'
35: AND a_lkp.lookup_code (+) = BD_ACTION_ON_ADDRESSES
36: AND c_lkp.language (+) = USERENV('LANG')
37: AND c_lkp.view_application_id (+) = 222
38: AND c_lkp.security_group_id (+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HZ_IMP_BATCH_DEDUP_ACTIONS',222)
39: AND c_lkp.lookup_type (+) = 'HZ_IMP_BATCH_DEDUP_ACTIONS'
40: AND c_lkp.lookup_code (+) = BD_ACTION_ON_CONTACTS
41: AND cp_lkp.language (+) = USERENV('LANG')
42: AND cp_lkp.view_application_id (+) = 222

Line 43: AND cp_lkp.security_group_id (+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HZ_IMP_BATCH_DEDUP_ACTIONS',222)

39: AND c_lkp.lookup_type (+) = 'HZ_IMP_BATCH_DEDUP_ACTIONS'
40: AND c_lkp.lookup_code (+) = BD_ACTION_ON_CONTACTS
41: AND cp_lkp.language (+) = USERENV('LANG')
42: AND cp_lkp.view_application_id (+) = 222
43: AND cp_lkp.security_group_id (+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HZ_IMP_BATCH_DEDUP_ACTIONS',222)
44: AND cp_lkp.lookup_type (+) = 'HZ_IMP_BATCH_DEDUP_ACTIONS'
45: AND cp_lkp.lookup_code (+) = BD_ACTION_ON_CONTACT_POINTS;
46: RETURN (TRUE);
47: EXCEPTION