[Home] [Help]
PACKAGE: APPS.ASO_HEADER_RELATIONSHIPS_PKG
Source
1 PACKAGE ASO_HEADER_RELATIONSHIPS_PKG as
2 /* $Header: asotheds.pls 120.1 2005/06/29 12:39:00 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_HEADER_RELATIONSHIPS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_HEADER_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_RELATED_HEADER_ID NUMBER,
23 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
24 p_RECIPROCAL_FLAG VARCHAR2,
25 p_OBJECT_VERSION_NUMBER NUMBER
26 );
27
28 PROCEDURE Update_Row(
29 p_HEADER_RELATIONSHIP_ID NUMBER,
30 p_CREATION_DATE DATE,
31 p_CREATED_BY NUMBER,
32 p_LAST_UPDATE_DATE DATE,
33 p_LAST_UPDATED_BY NUMBER,
34 p_LAST_UPDATE_LOGIN NUMBER,
35 p_REQUEST_ID NUMBER,
36 p_PROGRAM_APPLICATION_ID NUMBER,
37 p_PROGRAM_ID NUMBER,
38 p_PROGRAM_UPDATE_DATE DATE,
39 p_QUOTE_HEADER_ID NUMBER,
40 p_RELATED_HEADER_ID NUMBER,
41 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
42 p_RECIPROCAL_FLAG VARCHAR2,
43 p_OBJECT_VERSION_NUMBER NUMBER
44 );
45
46 PROCEDURE Lock_Row(
47 --p_OBJECT_VERSION_NUMBER NUMBER,
48 p_HEADER_RELATIONSHIP_ID NUMBER,
49 p_CREATION_DATE DATE,
50 p_CREATED_BY NUMBER,
51 p_LAST_UPDATE_DATE DATE,
52 p_LAST_UPDATED_BY NUMBER,
53 p_LAST_UPDATE_LOGIN NUMBER,
54 p_REQUEST_ID NUMBER,
55 p_PROGRAM_APPLICATION_ID NUMBER,
56 p_PROGRAM_ID NUMBER,
57 p_PROGRAM_UPDATE_DATE DATE,
58 p_QUOTE_HEADER_ID NUMBER,
59 p_RELATED_HEADER_ID NUMBER,
60 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
61 p_RECIPROCAL_FLAG VARCHAR2);
62
63 PROCEDURE Delete_Row(
64 p_HEADER_RELATIONSHIP_ID NUMBER);
65 End ASO_HEADER_RELATIONSHIPS_PKG;