[Home] [Help]
PACKAGE: APPS.IES_TCA_BP_PKG
Source
1 PACKAGE IES_TCA_BP_PKG AUTHID CURRENT_USER AS
2 /* $Header: iestcbps.pls 120.1 2005/06/16 11:16:18 appldev $ */
3
4 Procedure create_organization(
5 p_api_version number,
6 p_user_name varchar2,
7 p_org_name varchar2,
8 p_content_source_type varchar2,
9 x_party_id OUT NOCOPY /* file.sql.39 change */ number,
10 x_party_number OUT NOCOPY /* file.sql.39 change */ number,
11 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
12 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
13 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2,
14 x_profile_id OUT NOCOPY /* file.sql.39 change */ number
15 );
16
17
18 Procedure create_person(
19 p_api_version number,
20 p_user_name varchar2,
21 p_first_name varchar2,
22 p_middle_name varchar2 default FND_API.G_MISS_CHAR,
23 p_last_name varchar2,
24 p_title varchar2 default FND_API.G_MISS_CHAR,
25 p_content_source_type varchar2,
26 x_party_id OUT NOCOPY /* file.sql.39 change */ number,
27 x_party_number OUT NOCOPY /* file.sql.39 change */ number,
28 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
29 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
30 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2,
31 x_profile_id OUT NOCOPY /* file.sql.39 change */ number
32 );
33
34 Procedure create_location (
35 p_api_version number,
36 p_user_name varchar2,
37 p_address1 varchar2,
38 p_address2 varchar2 DEFAULT FND_API.G_MISS_CHAR,
39 p_address3 varchar2 DEFAULT FND_API.G_MISS_CHAR,
40 p_address4 varchar2 DEFAULT FND_API.G_MISS_CHAR,
41 p_city varchar2 DEFAULT FND_API.G_MISS_CHAR,
42 p_postal_code varchar2 DEFAULT FND_API.G_MISS_CHAR,
43 p_province varchar2 DEFAULT FND_API.G_MISS_CHAR,
44 p_state varchar2 DEFAULT FND_API.G_MISS_CHAR,
45 p_country varchar2,
46 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
47 x_location_id OUT NOCOPY /* file.sql.39 change */ number,
48 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
49 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2
50 );
51
52 procedure create_party_site(
53 p_api_version number,
54 p_user_name varchar2,
55 p_party_id number,
56 p_location_id number,
57 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
58 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
59 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2,
60 x_party_site_id OUT NOCOPY /* file.sql.39 change */ number,
61 x_party_site_number OUT NOCOPY /* file.sql.39 change */ number);
62
63
64 Procedure create_org_contact(
65 p_api_version number,
66 p_user_name varchar2,
67 p_org_party_id number,
68 p_person_party_id number,
69 p_party_relationship_type varchar2,
70 p_content_source_type varchar2,
71 p_party_site_id number,
72 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
73 x_org_contact_id OUT NOCOPY /* file.sql.39 change */ number,
74 x_party_rel_id OUT NOCOPY /* file.sql.39 change */ number,
75 x_party_id OUT NOCOPY /* file.sql.39 change */ number,
76 x_party_number OUT NOCOPY /* file.sql.39 change */ number,
77 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
78 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2);
79
80
81 procedure update_org_contact(
82 p_api_version number,
83 p_user_name varchar2,
84 p_org_contact_id number,
85 p_party_site_id number,
86 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
87 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
88 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2);
89
90 procedure update_party_site(
91 p_api_version number,
92 p_user_name varchar2,
93 p_party_site_id number,
94 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
95 x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
96 x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2);
97
98
99 END IES_TCA_BP_PKG;