1 PACKAGE hr_efc_stubs AUTHID CURRENT_USER AS
2 /* $Header: hrefcstb.pkh 115.2 2002/12/05 11:38:37 apholt noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------< cust_valid_budget_unit >----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- Description:
9 -- Validates that budget_unit passed in has been defined as a customer
10 -- specific budget unit of measure, indicating money.
11 --
12 -- ----------------------------------------------------------------------------
13 FUNCTION cust_valid_budget_unit(p_uom IN VARCHAR2
14 ,p_business_group_id IN NUMBER) RETURN VARCHAR2;
15 --
16 -- ----------------------------------------------------------------------------
17 -- |--------------------< cust_validate_hr_summary >--------------------------|
18 -- ----------------------------------------------------------------------------
19 --
20 -- Description:
21 --
22 -- Validates that the column in the hr_summary table should be converted.
23 -- This function must be modified to include all customer defined lookup
24 -- values for num_value1 (p_colname = 'NUM_VALUE1') and num_value2
25 -- (p_colname = 'NUM_VALUE2').
26 --
27 -- This function should return 'Y' if the monetary type matches, otherwise
28 -- it should return 'N'.
29 --
30 -- ----------------------------------------------------------------------------
31 FUNCTION cust_validate_hr_summary(p_colname VARCHAR2
32 ,p_item VARCHAR2
33 ,p_business_group_id NUMBER) RETURN VARCHAR2;
34 --
35 -- ----------------------------------------------------------------------------
36 -- |----------------------< chk_customer_mapping >----------------------------|
37 -- ----------------------------------------------------------------------------
38 --
39 -- Description:
40 --
41 -- For specific customer payment_types, defined in pay_payment_types, and not
42 -- seeded by Oracle HRMS, have to define the mapping between the original
43 -- payment_type and the payment_type to be used after EFC conversion.
44 --
45 -- Post Success:
46 -- Should return the payment_type_name, and territory_code for the new
47 -- payment_type. A new payment type should ALWAYS be returned.
48 --
49 -- ----------------------------------------------------------------------------
50 procedure chk_customer_mapping(p_payment_type IN varchar2
51 ,p_territory_code IN varchar2
52 ,p_new_payment_type OUT NOCOPY varchar2
53 ,p_new_territory_code OUT NOCOPY varchar2);
54 --
55 -- ----------------------------------------------------------------------------
56 -- |----------------------< cust_find_row_size >------------------------------|
57 -- ----------------------------------------------------------------------------
58 --
59 -- Description:
60 -- Customer specific version of a function which will estimate the
61 -- size of a row. This will override the function supplied by Oracle to
62 -- estimate the size of a row.
63 -- If you wish to use the estimation function supplied by Oracle, this
64 -- function must return 0.
65 --
66 -- ----------------------------------------------------------------------------
67 FUNCTION cust_find_row_size(p_table IN varchar2) RETURN number;
68 --
69 -- ----------------------------------------------------------------------------
70 -- |------------------< cust_process_cross_bg_data >---------------------------|
71 -- ----------------------------------------------------------------------------
72 --
73 -- Description:
74 -- Customer specific version of a function which will determine if data
75 -- spanning business groups will be converted. This will override the function
76 -- supplied by Oracle for this purpose, which by default will convert the data.
77 -- If you wish NOT to convert on the next run, this function must return 'N'.
78 --
79 -- ----------------------------------------------------------------------------
80 FUNCTION cust_process_cross_bg_data RETURN varchar2;
81 --
82 END hr_efc_stubs;
[Home] [Help]