[Home] [Help]
PACKAGE: APPS.AP_WEB_DB_EXPTEMPLATE_PKG
Source
1 PACKAGE AP_WEB_DB_EXPTEMPLATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwdbets.pls 115.12 2003/08/15 10:59:50 jrautiai ship $ */
3
4 ---------------------------------------------------------------------------------------------------
5 SUBTYPE expTempl_paramID IS AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE;
6 SUBTYPE expTempl_reportID IS AP_EXPENSE_REPORT_PARAMS.expense_report_id%TYPE;
7 SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
8 SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9 SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10 SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11 SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12 SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13 SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14 SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;
15 SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;
16 SUBTYPE expTempl_paExpenditureType IS AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE;
17 SUBTYPE expTempl_calcAmtFlag IS AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;
18
19
20
21 SUBTYPE expTypes_reportID IS AP_EXPENSE_REPORTS.expense_report_id%TYPE;
22 SUBTYPE expTypes_reportType IS AP_EXPENSE_REPORTS.report_type%TYPE;
23 ---------------------------------------------------------------------------------------------------
24
25 TYPE TemplateCursor IS REF CURSOR;
26 TYPE ExpTypesOfTemplateCursor IS REF CURSOR;
27 TYPE AllExpenseTypesCursor IS REF CURSOR;
28 TYPE ExpenseTypesCursor IS REF CURSOR;
29 TYPE WebExpenseTypesCursor IS REF CURSOR;
30 TYPE JustificationExpTypeCursor IS REF CURSOR;
31
32 --------------------------------------------------------------------------------------------
33 TYPE ExpTypeInfoRec IS RECORD (
34 flex_concat expTempl_flexConcat,
35 vat_code expTempl_vatCode,
36 amt_incl_tax expTempl_amtInclTaxFlag,
37 line_type expTempl_lineTypeLookupCode,
38 pa_exp_type expTempl_paExpendituretype
39 ); /* End TYPE ExpTypeInfoRec */
40 --------------------------------------------------------------------------------------------
41
42 --------------------------------------------------------------------------------------------
43 FUNCTION GetWebEnabledTemplatesCursor(p_cursor OUT NOCOPY TemplateCursor)
44 RETURN BOOLEAN;
45 --------------------------------------------------------------------------------------------
46
47 --------------------------------------------------------------------------------------------
48 FUNCTION GetExpTypesOfTemplateCursor(p_xtemplateid IN expTypes_reportID,
49 p_cursor OUT NOCOPY ExpTypesOfTemplateCursor)
50 RETURN BOOLEAN;
51 --------------------------------------------------------------------------------------------
52
53 --------------------------------------------------------------------------------------------
54 FUNCTION GetAllExpenseTypesCursor(p_cursor OUT NOCOPY AllExpenseTypesCursor)
55 RETURN BOOLEAN;
56 --------------------------------------------------------------------------------------------
57
58 --------------------------------------------------------------------------------------------
59 FUNCTION GetExpTypesCursor(p_report_id IN expTempl_reportID,
60 p_cursor OUT NOCOPY ExpenseTypesCursor)
61 RETURN BOOLEAN;
62 --------------------------------------------------------------------------------------------
63
64 --------------------------------------------------------------------------------------------
65 FUNCTION GetWebExpTypesCursor(p_cursor OUT NOCOPY WebExpenseTypesCursor)
66 RETURN BOOLEAN;
67 --------------------------------------------------------------------------------------------
68
69 --------------------------------------------------------------------------------------------
70 FUNCTION GetJustifReqdExpTypesCursor(p_cursor OUT NOCOPY JustificationExpTypeCursor)
71 RETURN BOOLEAN;
72 --------------------------------------------------------------------------------------------
73
74 --------------------------------------------------------------------------------------------
75 FUNCTION GetTemplateName(P_TemplateID IN expTypes_reportID,
76 P_TemplateName OUT NOCOPY expTypes_reportType)
77
78 RETURN BOOLEAN;
79 --------------------------------------------------------------------------------------------
80
81 --------------------------------------------------------------------------------------------
82 FUNCTION GetExpTemplateId(
83 p_report_type IN expTypes_reportType,
84 p_exp_temp_id OUT NOCOPY expTypes_reportID)
85 RETURN BOOLEAN;
86 --------------------------------------------------------------------------------------------
87
88 -------------------------------------------------------------------
89 FUNCTION GetExpTypePrompt(p_parameter_id IN expTempl_paramID,
90 p_exp_prompt OUT NOCOPY expTempl_prompt
91 ) RETURN BOOLEAN;
92 -------------------------------------------------------------------
93
94 -------------------------------------------------------------------
95 FUNCTION GetPersonalParamID(p_parameter_id OUT NOCOPY expTempl_paramID)
96 RETURN BOOLEAN;
97 -------------------------------------------------------------------
98
99 --------------------------------------------------------------------------------------------
100 FUNCTION GetExpTypeInfo(P_ExpTypeID IN expTempl_paramID,
101 P_ExpTypeRec IN OUT NOCOPY ExpTypeInfoRec)
102 RETURN BOOLEAN;
103 --------------------------------------------------------------------------------------------
104
105 --------------------------------------------------------------------------------------------
106 FUNCTION IsExpTemplateWebEnabled(p_expense_report_id IN ap_expense_reports.expense_report_id%TYPE)
107 RETURN VARCHAR2;
108 --------------------------------------------------------------------------------------------
109
110 --------------------------------------------------------------------------------------------
111 FUNCTION GetNumWebEnabledExpTemplates(p_count OUT NOCOPY NUMBER)
112 RETURN BOOLEAN;
113 --------------------------------------------------------------------------------------------
114
115 ----------------------------------------------------------------------------
116 FUNCTION Get_ItemDesc_LookupCode(
117 p_xtype IN VARCHAR2,
118 p_item_description OUT NOCOPY expTempl_prompt,
119 p_line_type_lookup_code OUT NOCOPY expTempl_lineTypeLookupCode,
120 p_require_receipt_amount OUT NOCOPY expTempl_requireReceiptAmt
121 ) RETURN BOOLEAN;
122
123 FUNCTION GetDefaultTemplateId(
124 p_default_template_id OUT NOCOPY AP_SYSTEM_PARAMETERS.expense_report_id%TYPE
125 ) RETURN BOOLEAN;
126
127 FUNCTION IsCustomCalculateEnabled(p_template_id IN VARCHAR2,
128 p_parameter_id IN VARCHAR2)
129 RETURN BOOLEAN;
130
131 -------------------------------------------------------------------
132 FUNCTION GetRequireReceiptAmt(P_ExpTypeID IN expTempl_paramID,
133 p_require_receipt_amount OUT NOCOPY expTempl_requireReceiptAmt
134 ) RETURN BOOLEAN;
135 -------------------------------------------------------------------
136
137 /* jrautiai ADJ Fix Start */
138 FUNCTION GetRoundingParamID(p_parameter_id OUT NOCOPY expTempl_paramID)
139 RETURN BOOLEAN;
140 /* jrautiai ADJ Fix End */
141
142 END AP_WEB_DB_EXPTEMPLATE_PKG;