1 PACKAGE BODY AP_WEB_DB_UI_SETUP_PKG AS
2 /* $Header: apwdbuib.pls 120.6 2006/06/27 16:47:57 nammishr ship $ */
3
4
5 ----------------------------------------------------------------------------------------------
6 FUNCTION GetDisplayValForLookupCode(p_lookup_type IN lookupCodes_lookupType,
7 p_lookup_code IN lookupCodes_lookupCode,
8 p_displayed_field OUT NOCOPY lookupCodes_displayedField)
9 RETURN BOOLEAN IS
10 ----------------------------------------------------------------------------------------------
11 BEGIN
12 SELECT displayed_field
13 INTO p_displayed_field
14 FROM ap_lookup_codes
15 WHERE lookup_type = p_lookup_type
16 AND lookup_code = p_lookup_code;
17
18 return TRUE;
19 EXCEPTION
20 WHEN NO_DATA_FOUND THEN
21 return FALSE;
22 WHEN OTHERS THEN
23 AP_WEB_DB_UTIL_PKG.RaiseException('GetDisplayValForLookupCode');
24 APP_EXCEPTION.RAISE_EXCEPTION;
25 return FALSE;
26 END GetDisplayValForLookupCode;
27
28 ---------------------------------------------------------------------------------------
29 FUNCTION GetAKPageRowID(P_FROM_REGION_CODE IN flowReg_fromRegionCode,
30 P_FROM_PAGE_CODE IN flowReg_fromPageCode,
31 P_TO_PAGE_CODE IN flowReg_toPageCode,
32 P_FLOW_CODE IN flowReg_flowCode,
33 P_APPLICATION_ID IN flowReg_flowApplID,
34 P_ROW_ID OUT NOCOPY VARCHAR2)
35 RETURN BOOLEAN IS
36 ---------------------------------------------------------------------------------------
37 BEGIN
38
39 SELECT rowidtochar(ROWID)
40 INTO P_ROW_ID
41 FROM AK_FLOW_REGION_RELATIONS
42 WHERE FROM_REGION_CODE = P_FROM_REGION_CODE
43 AND FROM_REGION_APPL_ID = P_APPLICATION_ID
44 AND FROM_PAGE_CODE = P_FROM_PAGE_CODE
45 AND FROM_PAGE_APPL_ID = P_APPLICATION_ID
46 AND TO_PAGE_CODE = P_TO_PAGE_CODE
47 AND TO_PAGE_APPL_ID = P_APPLICATION_ID
48 AND FLOW_CODE = P_FLOW_CODE
49 AND FLOW_APPLICATION_ID = P_APPLICATION_ID;
50
51 return TRUE;
52 EXCEPTION
53 WHEN NO_DATA_FOUND THEN
54 return FALSE;
55 WHEN OTHERS THEN
56 AP_WEB_DB_UTIL_PKG.RaiseException('GetAKPageRowID');
57 APP_EXCEPTION.RAISE_EXCEPTION;
58 return FALSE;
59 END GetAKPageRowID;
60
61
62
63 END AP_WEB_DB_UI_SETUP_PKG;