PACKAGE: APPS.ASO_PARTY_RELATIONSHIPS_PKG

Source

1 PACKAGE ASO_PARTY_RELATIONSHIPS_PKG as
2 /* $Header: asotpars.pls 120.1 2005/06/29 12:39:48 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_PARTY_RELATIONSHIPS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_PARTY_RELATIONSHIP_ID   IN OUT NOCOPY /* file.sql.39 change */  NUMBER,
12           p_CREATION_DATE    DATE,
13           p_CREATED_BY    NUMBER,
14           p_LAST_UPDATE_DATE    DATE,
15           p_LAST_UPDATED_BY    NUMBER,
16           p_LAST_UPDATE_LOGIN    NUMBER,
17           p_REQUEST_ID    NUMBER,
18           p_PROGRAM_APPLICATION_ID    NUMBER,
19           p_PROGRAM_ID    NUMBER,
20           p_PROGRAM_UPDATE_DATE    DATE,
21           p_QUOTE_HEADER_ID    NUMBER,
22           p_QUOTE_LINE_ID    NUMBER,
23           p_OBJECT_TYPE_CODE    VARCHAR2,
24           p_OBJECT_ID    NUMBER,
25           p_RELATIONSHIP_TYPE_CODE    VARCHAR,
26           p_OBJECT_VERSION_NUMBER  NUMBER
27 		);
28 
29 PROCEDURE Update_Row(
30           p_PARTY_RELATIONSHIP_ID    NUMBER,
31           p_CREATION_DATE    DATE,
32           p_CREATED_BY    NUMBER,
33           p_LAST_UPDATE_DATE    DATE,
34           p_LAST_UPDATED_BY    NUMBER,
35           p_LAST_UPDATE_LOGIN    NUMBER,
36           p_REQUEST_ID    NUMBER,
37           p_PROGRAM_APPLICATION_ID    NUMBER,
38           p_PROGRAM_ID    NUMBER,
39           p_PROGRAM_UPDATE_DATE    DATE,
40           p_QUOTE_HEADER_ID    NUMBER,
41           p_QUOTE_LINE_ID    NUMBER,
42           p_OBJECT_TYPE_CODE    VARCHAR2,
43           p_OBJECT_ID    NUMBER,
44 	     p_RELATIONSHIP_TYPE_CODE    VARCHAR,
45           p_OBJECT_VERSION_NUMBER  NUMBER
46 	  );
47 
48 PROCEDURE Lock_Row(
49           --p_OBJECT_VERSION_NUMBER  NUMBER,
50           p_PARTY_RELATIONSHIP_ID    NUMBER,
51           p_CREATION_DATE    DATE,
52           p_CREATED_BY    NUMBER,
53           p_LAST_UPDATE_DATE    DATE,
54           p_LAST_UPDATED_BY    NUMBER,
55           p_LAST_UPDATE_LOGIN    NUMBER,
56           p_REQUEST_ID    NUMBER,
57           p_PROGRAM_APPLICATION_ID    NUMBER,
58           p_PROGRAM_ID    NUMBER,
59           p_PROGRAM_UPDATE_DATE    DATE,
60           p_QUOTE_HEADER_ID    NUMBER,
61           p_QUOTE_LINE_ID    NUMBER,
62           p_OBJECT_TYPE_CODE    VARCHAR2,
63           p_OBJECT_ID    NUMBER,
64 	  p_RELATIONSHIP_TYPE_CODE    VARCHAR);
65 
66 PROCEDURE Delete_Row(
67     p_PARTY_RELATIONSHIP_ID  NUMBER);
68 End ASO_PARTY_RELATIONSHIPS_PKG;