PACKAGE BODY: APPS.AR_ARHLVOUT_XMLP_PKG

Source

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),
10       BAT.LOAD_TYPE,
11       BAT.TOTAL_BATCH_RECORDS,
12       BAT.TOTAL_RECORDS_IMPORTED,
13       BAT.IMPORT_STATUS,
14       P_LKP.MEANING,
15       A_LKP.MEANING,
16       C_LKP.MEANING,
17       CP_LKP.MEANING
18     INTO P_BATCH_NAME,P_ORIG_SYS,P_CRE_DT,P_LOAD_TYPE,P_TOT_B_REC,P_TOT_REC_IMP,P_IMP_STATUS,P_ACT_PARTIES,P_ACT_ADDR,P_ACT_CTS,P_ACT_CPT
19     FROM
20       HZ_IMP_BATCH_SUMMARY BAT,
21       FND_LOOKUP_VALUES P_LKP,
22       FND_LOOKUP_VALUES A_LKP,
23       FND_LOOKUP_VALUES C_LKP,
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
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
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
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
48     WHEN NO_DATA_FOUND THEN
49       RETURN (FALSE);
50   END AFTERPFORM;
51   FUNCTION AFTERREPORT RETURN BOOLEAN IS
52   BEGIN
53     /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
54     RETURN (TRUE);
55   END AFTERREPORT;
56   FUNCTION BEFOREREPORT RETURN BOOLEAN IS
57   BEGIN
58     /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
59     RETURN (TRUE);
60   END BEFOREREPORT;
61 END AR_ARHLVOUT_XMLP_PKG;