[Home] [Help]
PACKAGE: APPS.ASO_QUOTE_RELATED_OBJECTS_PKG
Source
1 PACKAGE ASO_QUOTE_RELATED_OBJECTS_PKG AUTHID CURRENT_USER as
2 /* $Header: asotobjs.pls 120.1 2005/06/29 12:39:27 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_QUOTE_RELATED_OBJECTS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_RELATED_OBJECT_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_OBJECT_TYPE_CODE VARCHAR2,
22 p_QUOTE_OBJECT_ID NUMBER,
23 p_OBJECT_TYPE_CODE VARCHAR2,
24 p_OBJECT_ID NUMBER,
25 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
26 p_RECIPROCAL_FLAG VARCHAR2,
27 p_OBJECT_VERSION_NUMBER NUMBER
28
29 );
30 -- p_QUOTE_OBJECT_CODE NUMBER);
31
32 PROCEDURE Update_Row(
33 p_RELATED_OBJECT_ID NUMBER,
34 p_CREATION_DATE DATE,
35 p_CREATED_BY NUMBER,
36 p_LAST_UPDATE_DATE DATE,
37 p_LAST_UPDATED_BY NUMBER,
38 p_LAST_UPDATE_LOGIN NUMBER,
39 p_REQUEST_ID NUMBER,
40 p_PROGRAM_APPLICATION_ID NUMBER,
41 p_PROGRAM_ID NUMBER,
42 p_PROGRAM_UPDATE_DATE DATE,
43 p_QUOTE_OBJECT_TYPE_CODE VARCHAR2,
44 p_QUOTE_OBJECT_ID NUMBER,
45 p_OBJECT_TYPE_CODE VARCHAR2,
46 p_OBJECT_ID NUMBER,
47 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
48 p_RECIPROCAL_FLAG VARCHAR2,
49 p_OBJECT_VERSION_NUMBER NUMBER
50 );
51 -- p_QUOTE_OBJECT_CODE NUMBER);
52
53 PROCEDURE Lock_Row(
54 --p_OBJECT_VERSION_NUMBER NUMBER,
55 p_RELATED_OBJECT_ID NUMBER,
56 p_CREATION_DATE DATE,
57 p_CREATED_BY NUMBER,
58 p_LAST_UPDATE_DATE DATE,
59 p_LAST_UPDATED_BY NUMBER,
60 p_LAST_UPDATE_LOGIN NUMBER,
61 p_REQUEST_ID NUMBER,
62 p_PROGRAM_APPLICATION_ID NUMBER,
63 p_PROGRAM_ID NUMBER,
64 p_PROGRAM_UPDATE_DATE DATE,
65 p_QUOTE_OBJECT_TYPE_CODE VARCHAR2,
66 p_QUOTE_OBJECT_ID NUMBER,
67 p_OBJECT_TYPE_CODE VARCHAR2,
68 p_OBJECT_ID NUMBER,
69 p_RELATIONSHIP_TYPE_CODE VARCHAR2,
70 p_RECIPROCAL_FLAG VARCHAR2);
71 -- p_QUOTE_OBJECT_CODE NUMBER);
72
73 PROCEDURE Delete_Row(
74 p_RELATED_OBJECT_ID NUMBER);
75 End ASO_QUOTE_RELATED_OBJECTS_PKG;