1 PACKAGE AP_WEB_CUST_DFLEX_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwdfcfs.pls 120.12 2012/05/11 11:47:55 rveliche ship $ */
3
4 PROCEDURE CustomPopulatePoplist(
5 P_ExpenseTypeName IN VARCHAR2,
6 P_CustomFieldName IN VARCHAR2,
7 P_NumOfPoplistElem OUT NOCOPY NUMBER,
8 P_PoplistArray OUT NOCOPY AP_WEB_DFLEX_PKG.PoplistValues_A);
9
10 PROCEDURE CustomPopulateDefault(
11 P_ExpenseTypeName IN VARCHAR2,
12 P_CustomFieldName IN VARCHAR2,
13 P_DefaultValue OUT NOCOPY VARCHAR2);
14
15 PROCEDURE CustomValidateDFlexValues(
16 p_exp_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
17 p_exp_line_info IN AP_WEB_DFLEX_PKG.ExpReportLineRec,
18 p_custom_fields_array IN AP_WEB_DFLEX_PKG.CustomFields_A,
19 p_custom_field_record IN AP_WEB_DFLEX_PKG.CustomFieldRec,
20 p_validation_level IN VARCHAR2,
21 p_result_message IN OUT NOCOPY VARCHAR2,
22 p_message_type IN OUT NOCOPY VARCHAR2,
23 p_receipt_index IN BINARY_INTEGER);
24
25 PROCEDURE CustomCalculateAmount(
26 p_exp_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec, -- epxense report header details
27 p_exp_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec, -- expense report line detail
28 p_custom_fields_array IN AP_WEB_DFLEX_PKG.CustomFields_A, -- custom field details
29 -- p_addon_rates used for mileage category only
30 p_addon_rates IN OIE_ADDON_RATES_T, -- array of additional rate types
31 p_report_line_id IN NUMBER DEFAULT NULL, -- report line id
32 -- below fields are used for per diem category only
33 p_daily_breakup_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identifer for daily breakups
34 p_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date
35 p_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date
36 p_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of amount
37 p_number_of_meals IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of number of meals
38 p_meals_amount IN OIE_PDM_NUMBER_T DEFAULT NULL,-- array of meals amount
39 p_breakfast_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL,-- array of breakfast flag
40 p_lunch_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of lunch flag
41 p_dinner_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of dinner flag
42 p_accommodation_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of accommodation amount
43 p_accommodation_flag IN OIE_PDM_VARCHAR_1_T DEFAULT NULL, -- array of accommodation flag
44 p_hotel_name IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of hotel name
45 p_night_rate_Type IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of night rate type
46 p_night_rate_amount IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of night rate amount
47 p_pdm_rate IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of pdm rate
48 p_rate_Type_code IN OIE_PDM_VARCHAR_80_T DEFAULT NULL, -- array of rate type code
49 p_pdm_breakup_dest_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of unique identified for multiple destinations
50 p_pdm_destination_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations for each breakup period
51 p_dest_start_date IN OIE_PDM_DATE_T DEFAULT NULL, -- array of start date for each location
52 p_dest_end_date IN OIE_PDM_DATE_T DEFAULT NULL,-- array of end date for each location
53 p_location_id IN OIE_PDM_NUMBER_T DEFAULT NULL, -- array of locations
54 -- bug 5358186
55 p_cust_meals_amount IN OUT NOCOPY OIE_PDM_NUMBER_T, -- array of modified meals amount
56 p_cust_accommodation_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified accommodation amount
57 p_cust_night_rate_amount IN OUT NOCOPY OIE_PDM_NUMBER_T,-- array of modified night rate amount
58 p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T-- array of modified pdm rate
59 );
60
61 FUNCTION CustomValidateCostCenter(
62 p_cs_error OUT NOCOPY VARCHAR2,
63 p_CostCenterValue IN AP_EXPENSE_FEED_DISTS.cost_center%TYPE,
64 p_CostCenterValid IN OUT NOCOPY BOOLEAN,
65 p_employee_id IN NUMBER DEFAULT null) return BOOLEAN;
66
67 FUNCTION CustomDefaultCostCenter(
68 p_employee_id IN NUMBER) return VARCHAR2;
69
70 PROCEDURE CustomValidateLine(
71 p_exp_header_info IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
72 p_exp_line_info IN AP_WEB_DFLEX_PKG.ExpReportLineRec,
73 p_custom_fields_array IN AP_WEB_DFLEX_PKG.CustomFields_A,
74 p_message_array IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError);
75
76 -- Bug: 7365109, Custom Validate the address style
77 FUNCTION CustomGetCountyProvince(
78 p_addressstyle IN per_addresses.style%TYPE,
79 p_region IN OUT NOCOPY per_addresses.region_1%TYPE) return BOOLEAN;
80
81 -- Bug: 11817808, Custom code to mark payment trxns
82 FUNCTION CustomMarkPaymentTrxn return BOOLEAN;
83
84 -- Bug: 13856129, Custom to determine self approvals
85 FUNCTION CustomApprovalStatus(
86 p_item_key IN VARCHAR2,
87 p_employee_id IN NUMBER,
88 p_approver_id IN NUMBER,
89 p_continue_flag IN OUT NOCOPY BOOLEAN) return BOOLEAN;
90
91
92
93 END AP_WEB_CUST_DFLEX_PKG;
[Home] [Help]