DBA Data[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;