PACKAGE: APPS.ASO_QUOTE_LINE_ATTRIBS_EXT_PKG

Source

1 PACKAGE ASO_QUOTE_LINE_ATTRIBS_EXT_PKG AUTHID CURRENT_USER as
2 /* $Header: asotlats.pls 120.1 2005/06/29 12:39:06 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_QUOTE_LINE_ATTRIBS_EXT_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_LINE_ATTRIBUTE_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_APPLICATION_ID NUMBER,
22           p_STATUS     VARCHAR2,
23           p_QUOTE_LINE_ID    NUMBER,
24           p_ATTRIBUTE_TYPE_CODE    VARCHAR2,
25 		p_QUOTE_HEADER_ID NUMBER,
26 		p_QUOTE_SHIPMENT_ID NUMBER,
27           p_NAME    VARCHAR2,
28           p_VALUE    VARCHAR2,
29            p_VALUE_TYPE VARCHAR2,
30           p_START_DATE_ACTIVE    DATE,
31           p_END_DATE_ACTIVE    DATE,
32           p_OBJECT_VERSION_NUMBER  NUMBER
33 		);
34 
35 PROCEDURE Update_Row(
36           p_LINE_ATTRIBUTE_ID    NUMBER,
37           p_CREATION_DATE    DATE,
38           p_CREATED_BY    NUMBER,
39           p_LAST_UPDATE_DATE    DATE,
40           p_LAST_UPDATED_BY    NUMBER,
41           p_LAST_UPDATE_LOGIN    NUMBER,
42           p_REQUEST_ID    NUMBER,
43           p_PROGRAM_APPLICATION_ID    NUMBER,
44           p_PROGRAM_ID    NUMBER,
45           p_PROGRAM_UPDATE_DATE    DATE,
46           p_APPLICATION_ID NUMBER,
47           p_STATUS     VARCHAR2,
48           p_QUOTE_LINE_ID    NUMBER,
49           p_ATTRIBUTE_TYPE_CODE    VARCHAR2,
50 		p_QUOTE_HEADER_ID NUMBER,
51 		p_QUOTE_SHIPMENT_ID NUMBER,
52           p_NAME    VARCHAR2,
53           p_VALUE    VARCHAR2,
54           p_VALUE_TYPE VARCHAR2,
55           p_START_DATE_ACTIVE    DATE,
56           p_END_DATE_ACTIVE    DATE,
57           p_OBJECT_VERSION_NUMBER  NUMBER
58 		);
59 
60 PROCEDURE Lock_Row(
61           --p_OBJECT_VERSION_NUMBER  NUMBER,
62           p_LINE_ATTRIBUTE_ID    NUMBER,
63           p_CREATION_DATE    DATE,
64           p_CREATED_BY    NUMBER,
65           p_LAST_UPDATE_DATE    DATE,
66           p_LAST_UPDATED_BY    NUMBER,
67           p_LAST_UPDATE_LOGIN    NUMBER,
68           p_REQUEST_ID    NUMBER,
69           p_PROGRAM_APPLICATION_ID    NUMBER,
70           p_PROGRAM_ID    NUMBER,
71           p_PROGRAM_UPDATE_DATE    DATE,
72            p_APPLICATION_ID NUMBER,
73            p_STATUS     VARCHAR2,
74           p_QUOTE_LINE_ID    NUMBER,
75           p_ATTRIBUTE_TYPE_CODE    VARCHAR2,
76 		p_QUOTE_HEADER_ID NUMBER,
77 		p_QUOTE_SHIPMENT_ID NUMBER,
78           p_NAME    VARCHAR2,
79           p_VALUE    VARCHAR2,
80            p_VALUE_TYPE VARCHAR2,
81           p_START_DATE_ACTIVE    DATE,
82           p_END_DATE_ACTIVE    DATE);
83 
84 PROCEDURE Delete_Row(
85     p_LINE_ATTRIB_ID  NUMBER);
86 
87 PROCEDURE Delete_Row(
88     p_QUOTE_LINE_ID  NUMBER);
89 
90 End ASO_QUOTE_LINE_ATTRIBS_EXT_PKG;