1 PACKAGE AP_WEB_DB_UI_SETUP_PKG AS
2 /* $Header: apwdbuis.pls 120.5 2006/06/27 16:47:28 nammishr ship $ */
3
4 /* AP Lookup Codes */
5 ---------------------------------------------------------------------------------------------------
6 SUBTYPE lookupCodes_displayedField IS AP_LOOKUP_CODES.displayed_field%TYPE;
7 SUBTYPE lookupCodes_lookupCode IS AP_LOOKUP_CODES.lookup_code%TYPE;
8 SUBTYPE lookupCodes_lookupType IS AP_LOOKUP_CODES.lookup_type%TYPE;
9
10 /*AK Region Items */
11 ---------------------------------------------------------------------------------------------------
12 SUBTYPE regItem_regionCode IS AK_REGION_ITEMS_VL.region_code%TYPE;
13
14 /* AK Regions */
15 SUBTYPE reg_name IS AK_REGIONS_VL.name%TYPE;
16
17 /*AK Flow Region Relations */
18 ---------------------------------------------------------------------------------------------------
19 SUBTYPE flowReg_fromRegionCode IS AK_FLOW_REGION_RELATIONS.from_region_code%TYPE;
20 SUBTYPE flowReg_fromRegionApplID IS AK_FLOW_REGION_RELATIONS.from_region_appl_id%TYPE;
21 SUBTYPE flowReg_fromPageCode IS AK_FLOW_REGION_RELATIONS.from_page_code%TYPE;
22 SUBTYPE flowReg_fromPageApplID IS AK_FLOW_REGION_RELATIONS.from_page_appl_id%TYPE;
23 SUBTYPE flowReg_toPageCode IS AK_FLOW_REGION_RELATIONS.to_page_code%TYPE;
24 SUBTYPE flowReg_toPageApplID IS AK_FLOW_REGION_RELATIONS.to_page_appl_id%TYPE;
25 SUBTYPE flowReg_flowCode IS AK_FLOW_REGION_RELATIONS.flow_code%TYPE;
26 SUBTYPE flowReg_flowApplID IS AK_FLOW_REGION_RELATIONS.flow_application_id%TYPE;
27
28 TYPE LookupCodesCursor IS REF CURSOR;
29 TYPE PromptsCursor IS REF CURSOR;
30 TYPE ReportAuthorsCursor IS REF CURSOR;
31
32
33
34 ----------------------------------------------------------------------------------------------
35 -- Name: GetDisplayValForLookupCode
36 -- Desc: get the cursor of the displayed fields for the given lookup type and code
37 -- Params: p_lookup_type - the given lookup type
38 -- p_lookup_code - the given lookup code
39 -- p_displayed_field - the returned cursor
40 -- Returns: true - succeeded
41 -- false - failed
42 --------------------------------------------------------------------------------
43 FUNCTION GetDisplayValForLookupCode(p_lookup_type IN lookupCodes_lookupType,
44 p_lookup_code IN lookupCodes_lookupCode,
45 p_displayed_field OUT NOCOPY lookupCodes_displayedField)
46 RETURN BOOLEAN;
47 ----------------------------------------------------------------------------------------------
48
49 ---------------------------------------------------------------------------------------
50 -- Name: GetAKPageRowID
51 -- Desc: get the AK page row id
52 -- Params: p_from_region_code - the given region code
53 -- p_from_page_code - the give "from" page code
54 -- p_to_page_code - the give to "to" page code
55 -- p_flow_code - the given flow code
56 -- p_application_id - the given application id
57 -- p_row_id - the returned row id
58 -- Returns: true - succeeded
59 -- false - failed
60 --------------------------------------------------------------------------------
61 FUNCTION GetAKPageRowID(P_FROM_REGION_CODE IN flowReg_fromRegionCode,
62 P_FROM_PAGE_CODE IN flowReg_fromPageCode,
63 P_TO_PAGE_CODE IN flowReg_toPageCode,
64 P_FLOW_CODE IN flowReg_flowCode,
65 P_APPLICATION_ID IN flowReg_flowApplID,
66 P_ROW_ID OUT NOCOPY VARCHAR2)
67 RETURN BOOLEAN;
68 ---------------------------------------------------------------------------------------
69
70
71 END AP_WEB_DB_UI_SETUP_PKG;