PACKAGE: APPS.ASO_LINE_RELATIONSHIPS_PKG

Source

1 PACKAGE ASO_LINE_RELATIONSHIPS_PKG as
2 /* $Header: asotlins.pls 120.1 2005/06/29 12:39:19 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_LINE_RELATIONSHIPS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_LINE_RELATIONSHIP_ID   IN OUT NOCOPY /* file.sql.39 change */  NUMBER,
12           p_CREATION_DATE    DATE,
13           p_CREATED_BY    NUMBER,
14           p_LAST_UPDATED_BY    NUMBER,
15           p_LAST_UPDATE_DATE    DATE,
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_LINE_ID    NUMBER,
22           p_RELATED_QUOTE_LINE_ID    NUMBER,
23           p_RECIPROCAL_FLAG    VARCHAR2,
24           p_RELATIONSHIP_TYPE_CODE    VARCHAR2,
25           p_OBJECT_VERSION_NUMBER  NUMBER);
26 
27 PROCEDURE Update_Row(
28           p_LINE_RELATIONSHIP_ID    NUMBER,
29           p_CREATION_DATE    DATE,
30           p_CREATED_BY    NUMBER,
31           p_LAST_UPDATED_BY    NUMBER,
32           p_LAST_UPDATE_DATE    DATE,
33           p_LAST_UPDATE_LOGIN    NUMBER,
34           p_REQUEST_ID    NUMBER,
35           p_PROGRAM_APPLICATION_ID    NUMBER,
36           p_PROGRAM_ID    NUMBER,
37           p_PROGRAM_UPDATE_DATE    DATE,
38           p_QUOTE_LINE_ID    NUMBER,
39           p_RELATED_QUOTE_LINE_ID    NUMBER,
40           p_RECIPROCAL_FLAG    VARCHAR2,
41           p_RELATIONSHIP_TYPE_CODE    VARCHAR2,
42           p_OBJECT_VERSION_NUMBER  NUMBER);
43 
44 PROCEDURE Lock_Row(
45           --p_OBJECT_VERSION_NUMBER  NUMBER,
46           p_LINE_RELATIONSHIP_ID    NUMBER,
47           p_CREATION_DATE    DATE,
48           p_CREATED_BY    NUMBER,
49           p_LAST_UPDATED_BY    NUMBER,
50           p_LAST_UPDATE_DATE    DATE,
51           p_LAST_UPDATE_LOGIN    NUMBER,
52           p_REQUEST_ID    NUMBER,
53           p_PROGRAM_APPLICATION_ID    NUMBER,
54           p_PROGRAM_ID    NUMBER,
55           p_PROGRAM_UPDATE_DATE    DATE,
56           p_QUOTE_LINE_ID    NUMBER,
57           p_RELATED_QUOTE_LINE_ID    NUMBER,
58           p_RECIPROCAL_FLAG    VARCHAR2,
59           p_RELATIONSHIP_TYPE_CODE    VARCHAR2);
60 
61 PROCEDURE Delete_Row(
62     p_LINE_RELATIONSHIP_ID  NUMBER);
63 End ASO_LINE_RELATIONSHIPS_PKG;