1 PACKAGE per_sg_org_info_leg_hook AUTHID CURRENT_USER AS
2 /* $Header: pesglhoi.pkh 120.0 2011/03/29 00:08:22 jalin noship $ */
3
4 TYPE char_tab_type IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
5
6 PROCEDURE CHECK_SG_ORG_INFO_TYPE_CREATE
7 (p_org_info_type_code IN VARCHAR2 --Organization Information type
8 ,p_organization_id IN NUMBER --Organization ID
9 ,p_org_information1 IN VARCHAR2
10 ,p_org_information2 IN VARCHAR2
11 ,p_org_information3 IN VARCHAR2
12 ,p_org_information4 IN VARCHAR2
13 ,p_org_information5 IN VARCHAR2
14 ,p_org_information6 IN VARCHAR2
15 ,p_org_information7 IN VARCHAR2
16 ,p_org_information8 IN VARCHAR2
17 ,p_org_information9 IN VARCHAR2
18 ,p_org_information10 IN VARCHAR2
19 ,p_org_information11 IN VARCHAR2
20 ,p_org_information12 IN VARCHAR2
21 ,p_org_information13 IN VARCHAR2
22 ,p_org_information14 IN VARCHAR2
23 ,p_org_information15 IN VARCHAR2
24 ,p_org_information16 IN VARCHAR2
25 ,p_org_information17 IN VARCHAR2
26 ,p_org_information18 IN VARCHAR2
27 ,p_org_information19 IN VARCHAR2
28 ,p_org_information20 IN VARCHAR2
29 );
30
31 PROCEDURE CHECK_SG_ORG_INFO_TYPE_UPDATE
32 (p_org_info_type_code IN VARCHAR2 --Organization Information type
33 ,p_org_information_id IN NUMBER --Organization Information ID
34 ,p_org_information1 IN VARCHAR2
35 ,p_org_information2 IN VARCHAR2
36 ,p_org_information3 IN VARCHAR2
37 ,p_org_information4 IN VARCHAR2
38 ,p_org_information5 IN VARCHAR2
39 ,p_org_information6 IN VARCHAR2
40 ,p_org_information7 IN VARCHAR2
41 ,p_org_information8 IN VARCHAR2
42 ,p_org_information9 IN VARCHAR2
43 ,p_org_information10 IN VARCHAR2
44 ,p_org_information11 IN VARCHAR2
45 ,p_org_information12 IN VARCHAR2
46 ,p_org_information13 IN VARCHAR2
47 ,p_org_information14 IN VARCHAR2
48 ,p_org_information15 IN VARCHAR2
49 ,p_org_information16 IN VARCHAR2
50 ,p_org_information17 IN VARCHAR2
51 ,p_org_information18 IN VARCHAR2
52 ,p_org_information19 IN VARCHAR2
53 ,p_org_information20 IN VARCHAR2
54 );
55
56 --------------------------------------------------------------------------
57 -- --
58 -- Name : RAISE_MESSAGE --
59 -- Type : PROCEDURE --
60 -- Access : Public --
61 -- Description : Procedure to raise the error message --
62 -- --
63 -- Parameters : --
64 -- IN : p_application_id NUMBER --
65 -- p_message_name VARCHAR2 --
66 -- p_token_name CHAR_TAB_TYPE --
67 -- p_token_value CHAR_TAB_TYPE --
68 -- --
69 ---------------------------------------------------------------------------
70 PROCEDURE raise_message(p_application_id IN NUMBER
71 ,p_message_name IN VARCHAR2
72 ,p_token_name IN OUT NOCOPY char_tab_type
73 ,p_token_value IN OUT NOCOPY char_tab_type
74 );
75
76
77 END per_sg_org_info_leg_hook;