[Home] [Help]
PACKAGE: APPS.AP_CARD_DATABASE_PKG
Source
1 PACKAGE AP_CARD_DATABASE_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwpcdbs.pls 115.3 2002/12/26 10:14:41 srinvenk noship $ */
3
4 -------------------------------------------------------------------------------
5 /*HR Employees */
6 -------------------------------------------------------------------------------
7 SUBTYPE empCurrent_employeeID IS HR_EMPLOYEES_CURRENT_V.employee_id%TYPE;
8 SUBTYPE empCurrent_fullName IS HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
9 SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
10 SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%TYPE;
11 SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
12 SUBTYPE empCurrent_orgID IS HR_EMPLOYEES_CURRENT_V.ORGANIZATION_ID%TYPE;
13
14 -------------------------------------------------------------------------------
15 /* AP Lookup Codes */
16 -------------------------------------------------------------------------------
17 SUBTYPE lookupCodes_displayedField IS AP_LOOKUP_CODES.displayed_field%TYPE;
18 SUBTYPE lookupCodes_lookupCode IS AP_LOOKUP_CODES.lookup_code%TYPE;
19 SUBTYPE lookupCodes_lookupType IS AP_LOOKUP_CODES.lookup_type%TYPE;
20
21 -------------------------------------------------------------------------------
22 /* AP Card Profiles */
23 -------------------------------------------------------------------------------
24 SUBTYPE cardProf_profileName IS AP_CARD_PROFILES.profile_name%TYPE;
25 SUBTYPE cardProf_directAcctEntryFlag IS AP_CARD_PROFILES.direct_acct_entry_flag%TYPE;
26 SUBTYPE cardProf_cardGLSetID IS AP_CARD_PROFILES.card_gl_set_id%TYPE;
27 SUBTYPE cardProf_empNotifLookupCode IS AP_CARD_PROFILES.emp_notification_lookup_code%TYPE;
28 SUBTYPE cardProf_mgrApprvlLookupCode IS AP_CARD_PROFILES.mgr_approval_lookup_code%TYPE;
29
30 -------------------------------------------------------------------------------
31 /* GL Sets Of Books */
32 -------------------------------------------------------------------------------
33 SUBTYPE glsob_chartOfAccountsID IS GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
34
35 -------------------------------------------------------------------------------
36 /* AP Card Programs */
37 -------------------------------------------------------------------------------
38 SUBTYPE cardProgs_cardProgID IS AP_CARD_PROGRAMS.card_program_id%TYPE;
39 SUBTYPE cardProgs_cardProgName IS AP_CARD_PROGRAMS.card_program_name%TYPE;
40 SUBTYPE cardProgs_cardProgCurrCode IS AP_CARD_PROGRAMS.card_program_currency_code%TYPE;
41
42 -------------------------------------------------------------------------------
43 /* Currency */
44 -------------------------------------------------------------------------------
45 SUBTYPE curr_name IS FND_CURRENCIES_VL.name%TYPE;
46 SUBTYPE curr_currCode IS FND_CURRENCIES_VL.currency_code%TYPE;
47 SUBTYPE curr_precision IS FND_CURRENCIES_VL.precision%TYPE;
48 SUBTYPE curr_minAcctUnit IS FND_CURRENCIES_VL.minimum_accountable_unit%TYPE;
49
50 -------------------------------------------------------------------------------
51 /*AK Flow Region Relations */
52 -------------------------------------------------------------------------------
53 SUBTYPE flowReg_fromRegionCode IS AK_FLOW_REGION_RELATIONS.from_region_code%TYPE;
54 SUBTYPE flowReg_fromRegionApplID IS AK_FLOW_REGION_RELATIONS.from_region_appl_id%TYPE;
55 SUBTYPE flowReg_fromPageCode IS AK_FLOW_REGION_RELATIONS.from_page_code%TYPE;
56 SUBTYPE flowReg_fromPageApplID IS AK_FLOW_REGION_RELATIONS.from_page_appl_id%TYPE;
57 SUBTYPE flowReg_toPageCode IS AK_FLOW_REGION_RELATIONS.to_page_code%TYPE;
58 SUBTYPE flowReg_toPageApplID IS AK_FLOW_REGION_RELATIONS.to_page_appl_id%TYPE;
59 SUBTYPE flowReg_flowCode IS AK_FLOW_REGION_RELATIONS.flow_code%TYPE;
60 SUBTYPE flowReg_flowApplID IS AK_FLOW_REGION_RELATIONS.flow_application_id%TYPE;
61
62 -------------------------------------------------------------------------------
63 -------------------------------------------------------------------------------
64 TYPE prompts_table IS table of varchar2(50)
65 index by binary_integer;
66
67 TYPE LookupCodesCursor IS REF CURSOR;
68
69 TYPE EmployeeInfoRec IS RECORD (
70 employee_id empCurrent_employeeID,
71 employee_name empCurrent_fullName,
72 employee_num empCurrent_empNum,
73 emp_ccid empCurrent_defaultCodeCombID
74 );
75
76 -------------------------------------------------------------------------------
77 FUNCTION GetCardProgramCurrencyCode(
78 p_card_prog_id IN cardProgs_cardProgID,
79 p_curr_code OUT NOCOPY cardProgs_cardProgCurrCode
80 ) RETURN BOOLEAN;
81 -------------------------------------------------------------------------------
82
83 -- Name: GetLookupCodesCursor
84 -- Desc: get the cursor reference of the lookup codes for the given lookup type
85 -- Params: p_lookup_type - the given lookup type
86 -- p_lookup_codes - the returned lookup code cursor
87 -- Returns: true - succeeded
88 -- false - failed
89 -------------------------------------------------------------------------------
90 FUNCTION GetLookupCodesCursor(p_lookup_type IN lookupCodes_lookupType,
91 p_lookup_codes OUT NOCOPY LookupCodesCursor)
92 RETURN BOOLEAN;
93
94 -------------------------------------------------------------------------------
95 FUNCTION GetCurrCodeProperties(
96 p_curr_code IN curr_currCode,
97 p_curr_name OUT NOCOPY curr_name,
98 p_precision OUT NOCOPY curr_precision,
99 p_minimum_acct_unit OUT NOCOPY curr_minAcctUnit
100 ) RETURN BOOLEAN;
101
102 -------------------------------------------------------------------------------
103 FUNCTION GetCOAofSOB(
104 p_chart_of_accounts OUT NOCOPY glsob_chartOfAccountsID
105 ) RETURN BOOLEAN;
106
107 -------------------------------------------------------------------------------
108 -- Name: GetAKPageRowID
109 -- Desc: get the AK page row id
110 -- Params: p_from_region_code - the given region code
111 -- p_from_page_code - the give "from" page code
112 -- p_to_page_code - the give to "to" page code
113 -- p_flow_code - the given flow code
114 -- p_application_id - the given application id
115 -- p_row_id - the returned row id
116 -- Returns: true - succeeded
117 -- false - failed
118 -------------------------------------------------------------------------------
119 FUNCTION GetAKPageRowID(P_FROM_REGION_CODE IN flowReg_fromRegionCode,
120 P_FROM_PAGE_CODE IN flowReg_fromPageCode,
121 P_TO_PAGE_CODE IN flowReg_toPageCode,
122 P_FLOW_CODE IN flowReg_flowCode,
123 P_APPLICATION_ID IN flowReg_flowApplID,
124 P_ROW_ID OUT NOCOPY VARCHAR2)
125 RETURN BOOLEAN;
126 -------------------------------------------------------------------------------
127 FUNCTION GetEmployeeInfo(p_employee_id IN empCurrent_employeeID,
128 p_emp_info_rec OUT NOCOPY EmployeeInfoRec
129 ) RETURN BOOLEAN;
130
131 -------------------------------------------------------------------------------
132 PROCEDURE getPrompts( c_region_application_id in number,
133 c_region_code in varchar2,
134 c_title out nocopy AK_REGIONS_VL.NAME%TYPE,
135 c_prompts out nocopy prompts_table);
136 -------------------------------------------------------------------
137 -- Name: RaiseException
138 -- Desc: common routine for handling unrecoverrable(database) errors
139 -- Params: p_calling_squence - the name of the caller function
140 -- p_debug_info - additional error message
141 -- p_set_name - fnd message name
142 -- p_params - fnd message parameters
143 -------------------------------------------------------------------
144 PROCEDURE RaiseException(
145 p_calling_sequence IN VARCHAR2,
146 p_debug_info IN VARCHAR2 DEFAULT '',
147 p_set_name IN VARCHAR2 DEFAULT NULL,
148 p_params IN VARCHAR2 DEFAULT ''
149 );
150
151 -------------------------------------------------------------------
152 FUNCTION jsPrepString_long(p_string in long,
153 p_alertflag in boolean default FALSE,
154 p_jsargflag in boolean default FALSE) RETURN LONG;
155 -------------------------------------------------------------------
156 FUNCTION jsPrepString(p_string in varchar2,
157 p_alertflag in boolean default FALSE,
158 p_jsargflag in boolean default FALSE) RETURN VARCHAR2;
159
160
161
162 END AP_CARD_DATABASE_PKG;