1 Package pay_csk_shd AUTHID CURRENT_USER as
2 /* $Header: pycskrhi.pkh 115.0 99/07/17 05:55:45 porting ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Record Type Specification |
6 -- ----------------------------------------------------------------------------
7 --
8 Type g_rec_type Is Record
9 (
10 costing_keyflex_id number(15),
11 concatenated_segments varchar2(240),
12 id_flex_num number(15),
13 summary_flag varchar2(9), -- Increased length
14 enabled_flag varchar2(9), -- Increased length
15 start_date_active date,
16 end_date_active date,
17 segment1 varchar2(60),
18 segment2 varchar2(60),
19 segment3 varchar2(60),
20 segment4 varchar2(60),
21 segment5 varchar2(60),
22 segment6 varchar2(60),
23 segment7 varchar2(60),
24 segment8 varchar2(60),
25 segment9 varchar2(60),
26 segment10 varchar2(60),
27 segment11 varchar2(60),
28 segment12 varchar2(60),
29 segment13 varchar2(60),
30 segment14 varchar2(60),
31 segment15 varchar2(60),
32 segment16 varchar2(60),
33 segment17 varchar2(60),
34 segment18 varchar2(60),
35 segment19 varchar2(60),
36 segment20 varchar2(60),
37 segment21 varchar2(60),
38 segment22 varchar2(60),
39 segment23 varchar2(60),
40 segment24 varchar2(60),
41 segment25 varchar2(60),
42 segment26 varchar2(60),
43 segment27 varchar2(60),
44 segment28 varchar2(60),
45 segment29 varchar2(60),
46 segment30 varchar2(60)
47 );
48 --
49 -- ----------------------------------------------------------------------------
50 -- | Global Definitions - Internal Development Use Only |
51 -- ----------------------------------------------------------------------------
52 --
53 g_old_rec g_rec_type; -- Global record definition
54 --
55 -- ----------------------------------------------------------------------------
56 -- |-----------------------------< convert_args >-----------------------------|
57 -- ----------------------------------------------------------------------------
58 -- {Start Of Comments}
59 --
60 -- Description:
61 -- This function is used to turn attribute arguments into the record
62 -- structure g_rec_type.
63 --
64 -- Pre Conditions:
65 -- This is a private function and can only be called from the ins or upd
66 -- attribute processes.
67 --
68 -- In Arguments:
69 --
70 -- Post Success:
71 -- A returning record structure will be returned.
72 --
73 -- Post Failure:
74 -- No direct error handling is required within this function. Any possible
75 -- errors within this function will be a PL/SQL value error due to conversion
76 -- of datatypes or data lengths.
77 --
78 -- Developer Implementation Notes:
79 -- None.
80 --
81 -- Access Status:
82 -- Internal Table Handler Use Only.
83 --
84 -- {End Of Comments}
85 -- ----------------------------------------------------------------------------
86 Function convert_args
87 (
88 p_costing_keyflex_id in number,
89 p_concatenated_segments in varchar2,
90 p_id_flex_num in number,
91 p_summary_flag in varchar2,
92 p_enabled_flag in varchar2,
93 p_start_date_active in date,
94 p_end_date_active in date,
95 p_segment1 in varchar2,
96 p_segment2 in varchar2,
97 p_segment3 in varchar2,
98 p_segment4 in varchar2,
99 p_segment5 in varchar2,
100 p_segment6 in varchar2,
101 p_segment7 in varchar2,
102 p_segment8 in varchar2,
103 p_segment9 in varchar2,
104 p_segment10 in varchar2,
105 p_segment11 in varchar2,
106 p_segment12 in varchar2,
107 p_segment13 in varchar2,
108 p_segment14 in varchar2,
109 p_segment15 in varchar2,
110 p_segment16 in varchar2,
111 p_segment17 in varchar2,
112 p_segment18 in varchar2,
113 p_segment19 in varchar2,
114 p_segment20 in varchar2,
115 p_segment21 in varchar2,
116 p_segment22 in varchar2,
117 p_segment23 in varchar2,
118 p_segment24 in varchar2,
119 p_segment25 in varchar2,
120 p_segment26 in varchar2,
121 p_segment27 in varchar2,
122 p_segment28 in varchar2,
123 p_segment29 in varchar2,
124 p_segment30 in varchar2
125 )
126 Return g_rec_type;
127 --
128 end pay_csk_shd;