[Home] [Help]
PACKAGE: APPS.GHR_AGENCY_POSITION_COPY
Source
1 PACKAGE ghr_agency_position_copy AUTHID CURRENT_USER AS
2 /* $Header: ghpocagn.pkh 120.0 2005/05/29 03:30:19 appldev noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |--------------------------<agency_get_max_seq>--------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start of Comments}
8 --
9 -- Description:
10 -- Allows clients to override the Federal get_max_seq routine and
11 -- hence return their own values. Should be used if position sequence
12 -- is using a sequence generator or other method for generating sequence.
13 --
14 -- Prerequisites:
15 --
16 --
17 -- In Parameters:
18 -- p_segment1 - p_segment30.
19 --
20 -- Post Success:
21 -- Returns a numeric value.
22 --
23 -- Post Failure:
24 -- An application error will be raised and processing is terminated.
25 --
26 -- Developer Implementation Notes:
27 --
28 -- Access Status:
29 --
30 --
31 -- {End of Comments}
32 -- ---------------------------------------------------------------------------
33 function agency_get_max_seq
34 (p_seq_location in VARCHAR2,
35 p_business_group_id in NUMBER default NULL,
36 p_segment1 in VARCHAR2 default NULL,
37 p_segment2 in VARCHAR2 default NULL,
38 p_segment3 in VARCHAR2 default NULL,
39 p_segment4 in VARCHAR2 default NULL,
40 p_segment5 in VARCHAR2 default NULL,
41 p_segment6 in VARCHAR2 default NULL,
42 p_segment7 in VARCHAR2 default NULL,
43 p_segment8 in VARCHAR2 default NULL,
44 p_segment9 in VARCHAR2 default NULL,
45 p_segment10 in VARCHAR2 default NULL,
46 p_segment11 in VARCHAR2 default NULL,
47 p_segment12 in VARCHAR2 default NULL,
48 p_segment13 in VARCHAR2 default NULL,
49 p_segment14 in VARCHAR2 default NULL,
50 p_segment15 in VARCHAR2 default NULL,
51 p_segment16 in VARCHAR2 default NULL,
52 p_segment17 in VARCHAR2 default NULL,
53 p_segment18 in VARCHAR2 default NULL,
54 p_segment19 in VARCHAR2 default NULL,
55 p_segment20 in VARCHAR2 default NULL,
56 p_segment21 in VARCHAR2 default NULL,
57 p_segment22 in VARCHAR2 default NULL,
58 p_segment23 in VARCHAR2 default NULL,
59 p_segment24 in VARCHAR2 default NULL,
60 p_segment25 in VARCHAR2 default NULL,
61 p_segment26 in VARCHAR2 default NULL,
62 p_segment27 in VARCHAR2 default NULL,
63 p_segment28 in VARCHAR2 default NULL,
64 p_segment29 in VARCHAR2 default NULL,
65 p_segment30 in VARCHAR2 default NULL)
66 return VARCHAR2;
67
68 ----------------------------------------------------------------------------
69 END ghr_agency_position_copy;
70
71 --
72
73