[Home] [Help]
PACKAGE: APPS.AS_TCA_PVT
Source
1 PACKAGE AS_TCA_PVT as
2 /* $Header: asxvtcas.pls 120.1 2005/06/05 22:53:21 appldev $ */
3
4 --
5 -- NAME
6 -- AS_TCA_PVT
7 --
8 -- HISTORY
9 -- 05/19/00 ACNG Create
10 --
11
12 -- Procedure to validate the party_id
13 --
14 -- Validation:
15 -- Check if this party is in the HZ_PARTY table
16 --
17 -- NOTES:
18 --
19 PROCEDURE Validate_party_id (
20 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
21 p_party_id IN NUMBER,
22 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
24 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 );
26
27 -- Procedure to validate the party__site_id
28 --
29 -- Validation:
30 -- Check if this party is in the HZ_PARTY_SITES table
31 --
32 -- NOTES:
33 --
34 PROCEDURE Validate_party_site_id (
35 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36 p_party_id IN NUMBER,
37 p_party_site_id IN NUMBER,
38 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
39 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
40 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 );
42
43 -- Procedure to validate the contact_point_id
44 --
45 -- Validation:
46 -- Check if this party is in the HZ_CONTACT_POINTS table
47 --
48 -- NOTES:
49 --
50 PROCEDURE Validate_contact_point_id (
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_party_id IN NUMBER,
53 p_org_contact_id IN NUMBER,
54 p_contact_point_id IN NUMBER,
55 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
56 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
57 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 );
59
60 -- Procedure to validate the contact_id
61 --
62 -- Validation:
63 -- Check if this party is in the HZ_ORG_CONTACTS table
64 --
65 -- NOTES:
66 --
67 PROCEDURE Validate_contact_id (
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69 p_party_id IN NUMBER,
70 p_contact_id IN NUMBER,
71 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
72 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
73 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 );
75
76 END AS_TCA_PVT;