1 PACKAGE pay_costing_kff_util_pkg AUTHID CURRENT_USER AS
2 /* $Header: pykffutl.pkh 115.4 2003/09/25 10:09:00 swinton ship $ */
3 /*===========================================================================*
4 | Copyright (c) 1994 Oracle Corporation |
5 | All rights reserved. |
6 *===========================================================================*/
7 /*
8 REM
9 REM Version Date Author Reason
10 REM 115.4 25-Sep-2003 swinton Enhancement 3121279. Added:
11 REM - cost_keyflex_segment_defined function
12 REM - get_cost_keyflex_segment_value
13 REM function
14 REM - get_cost_keyflex_structure function
15 REM - validate_costing_keyflex procedure
16 REM The above are required to support the
17 REM View Cost Allocation Keyflex OA
18 REM Framework pages.
19 REM 115.3 25-MAY-2003 A.Logue NOCOPY changes. Bug 2961843.
20 REM 110.2 29-Oct-1999 A.Logue costing_kff_null_default_segs
21 REM procedure.
22 REM 110.0 24-Dec-1998 S.Billing Created file
23 REM
24 */
25
26
27
28 PROCEDURE costing_kff_seg_behaviour (
29 p_level IN VARCHAR2,
30 p_cost_id_flex_num IN NUMBER,
31 p_required OUT NOCOPY VARCHAR2,
32 p_allownulls OUT NOCOPY VARCHAR2
33 );
34
35 PROCEDURE costing_kff_null_default_segs(
36 p_level IN VARCHAR2,
37 p_cost_id_flex_num IN NUMBER,
38 p_segment1 IN OUT NOCOPY VARCHAR2,
39 p_segment2 IN OUT NOCOPY VARCHAR2,
40 p_segment3 IN OUT NOCOPY VARCHAR2,
41 p_segment4 IN OUT NOCOPY VARCHAR2,
42 p_segment5 IN OUT NOCOPY VARCHAR2,
43 p_segment6 IN OUT NOCOPY VARCHAR2,
44 p_segment7 IN OUT NOCOPY VARCHAR2,
45 p_segment8 IN OUT NOCOPY VARCHAR2,
46 p_segment9 IN OUT NOCOPY VARCHAR2,
47 p_segment10 IN OUT NOCOPY VARCHAR2,
48 p_segment11 IN OUT NOCOPY VARCHAR2,
49 p_segment12 IN OUT NOCOPY VARCHAR2,
50 p_segment13 IN OUT NOCOPY VARCHAR2,
51 p_segment14 IN OUT NOCOPY VARCHAR2,
52 p_segment15 IN OUT NOCOPY VARCHAR2,
53 p_segment16 IN OUT NOCOPY VARCHAR2,
54 p_segment17 IN OUT NOCOPY VARCHAR2,
55 p_segment18 IN OUT NOCOPY VARCHAR2,
56 p_segment19 IN OUT NOCOPY VARCHAR2,
57 p_segment20 IN OUT NOCOPY VARCHAR2,
58 p_segment21 IN OUT NOCOPY VARCHAR2,
59 p_segment22 IN OUT NOCOPY VARCHAR2,
60 p_segment23 IN OUT NOCOPY VARCHAR2,
61 p_segment24 IN OUT NOCOPY VARCHAR2,
62 p_segment25 IN OUT NOCOPY VARCHAR2,
63 p_segment26 IN OUT NOCOPY VARCHAR2,
64 p_segment27 IN OUT NOCOPY VARCHAR2,
65 p_segment28 IN OUT NOCOPY VARCHAR2,
66 p_segment29 IN OUT NOCOPY VARCHAR2,
67 p_segment30 IN OUT NOCOPY VARCHAR2
68 );
69
70 function cost_keyflex_segment_defined (
71 p_cost_id_flex_num in number,
72 p_segment_name in varchar2) return varchar2;
73
74 function get_cost_keyflex_segment_value (
75 p_segment_name in varchar2,
76 p_value_set_id in number,
77 p_value_set_application_id in number,
78 p_assignment_id in number,
79 p_cost_allocation_id in number,
80 p_element_entry_id in number,
81 p_effective_date in date
82 ) return varchar2;
83
84 procedure validate_costing_keyflex (
85 p_cost_id_flex_num in number
86 , p_concat_segments in varchar2
87 , p_validation_date in date
88 , p_resp_appl_id in number
89 , p_resp_id in number
90 , p_user_id in number
91 , p_cost_allocation_keyflex_id out nocopy number
92 , p_error_segment_num out nocopy number
93 , p_error_segment_name out nocopy varchar2
94 , p_application_col_name out nocopy varchar2
95 , p_error_message out nocopy varchar2
96 ) ;
97
98 function get_cost_keyflex_structure (
99 p_cost_id_flex_num in number
100 ) return varchar2;
101
102 END pay_costing_kff_util_pkg;