1 PACKAGE igs_or_gen_012_pkg AS
2 /* $Header: IGSOR12S.pls 120.3 2006/02/06 23:39:41 pkpatel ship $ */
3
4
5
6 PROCEDURE create_organization (
7 p_institution_cd IN VARCHAR2,
8 p_name IN VARCHAR2,
9 p_status IN VARCHAR2,
10 p_attribute_category IN VARCHAR2,
11 p_attribute1 IN VARCHAR2,
12 p_attribute2 IN VARCHAR2,
13 p_attribute3 IN VARCHAR2,
14 p_attribute4 IN VARCHAR2,
15 p_attribute5 IN VARCHAR2,
16 p_attribute6 IN VARCHAR2,
17 p_attribute7 IN VARCHAR2,
18 p_attribute8 IN VARCHAR2,
19 p_attribute9 IN VARCHAR2,
20 p_attribute10 IN VARCHAR2,
21 p_attribute11 IN VARCHAR2,
22 p_attribute12 IN VARCHAR2,
23 p_attribute13 IN VARCHAR2,
24 p_attribute14 IN VARCHAR2,
25 p_attribute15 IN VARCHAR2,
26 p_attribute16 IN VARCHAR2,
27 p_attribute17 IN VARCHAR2,
28 p_attribute18 IN VARCHAR2,
29 p_attribute19 IN VARCHAR2,
30 p_attribute20 IN VARCHAR2,
31 p_return_status OUT NOCOPY VARCHAR2,
32 p_msg_data OUT NOCOPY VARCHAR2,
33 p_party_id OUT NOCOPY NUMBER,
34 p_object_version_number IN OUT NOCOPY NUMBER,
35 p_attribute21 IN VARCHAR2 DEFAULT NULL,
36 p_attribute22 IN VARCHAR2 DEFAULT NULL,
37 p_attribute23 IN VARCHAR2 DEFAULT NULL,
38 p_attribute24 IN VARCHAR2 DEFAULT NULL
39 );
40
41 PROCEDURE update_organization (
42 p_party_id IN NUMBER,
43 p_institution_cd IN VARCHAR2,
44 p_name IN VARCHAR2,
45 p_status IN VARCHAR2,
46 p_last_update IN OUT NOCOPY DATE,
47 p_attribute_category IN VARCHAR2,
48 p_attribute1 IN VARCHAR2,
49 p_attribute2 IN VARCHAR2,
50 p_attribute3 IN VARCHAR2,
51 p_attribute4 IN VARCHAR2,
52 p_attribute5 IN VARCHAR2,
53 p_attribute6 IN VARCHAR2,
54 p_attribute7 IN VARCHAR2,
55 p_attribute8 IN VARCHAR2,
56 p_attribute9 IN VARCHAR2,
57 p_attribute10 IN VARCHAR2,
58 p_attribute11 IN VARCHAR2,
59 p_attribute12 IN VARCHAR2,
60 p_attribute13 IN VARCHAR2,
61 p_attribute14 IN VARCHAR2,
62 p_attribute15 IN VARCHAR2,
63 p_attribute16 IN VARCHAR2,
64 p_attribute17 IN VARCHAR2,
65 p_attribute18 IN VARCHAR2,
66 p_attribute19 IN VARCHAR2,
67 p_attribute20 IN VARCHAR2,
68 p_return_status OUT NOCOPY VARCHAR2,
69 p_msg_data OUT NOCOPY VARCHAR2,
70 p_object_version_number IN OUT NOCOPY NUMBER,
71 p_attribute21 IN VARCHAR2 DEFAULT NULL,
72 p_attribute22 IN VARCHAR2 DEFAULT NULL,
73 p_attribute23 IN VARCHAR2 DEFAULT NULL,
74 p_attribute24 IN VARCHAR2 DEFAULT NULL
75 );
76
77 PROCEDURE get_where_clause(
78 p_function_name IN fnd_lookup_values.lookup_code%TYPE,
79 p_where_clause OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE get_where_clause_form(
83 p_function_name IN fnd_lookup_values.lookup_code%TYPE,
84 p_where_clause OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE get_where_clause_api(
88 p_function_name IN fnd_lookup_values.lookup_code%TYPE,
89 p_where_clause OUT NOCOPY VARCHAR2
90 );
91
92 PROCEDURE get_where_clause_form1(
93 p_function_name IN fnd_lookup_values.lookup_code%TYPE,
94 p_where_clause OUT NOCOPY VARCHAR2
95 );
96
97 PROCEDURE get_where_clause_api1(
98 p_function_name IN fnd_lookup_values.lookup_code%TYPE,
99 p_where_clause OUT NOCOPY VARCHAR2
100 );
101
102 END igs_or_gen_012_pkg;