PACKAGE: APPS.ASO_PRICE_ADJ_ATTRIBS_PKG

Source

1 PACKAGE ASO_PRICE_ADJ_ATTRIBS_PKG AUTHID CURRENT_USER as
2 /* $Header: asotpaas.pls 120.1 2005/06/29 12:39:34 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_PRICE_ADJ_ATTRIBS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_PRICE_ADJ_ATTRIB_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_PROGRAM_APPLICATION_ID    NUMBER,
18           p_PROGRAM_ID    NUMBER,
19           p_PROGRAM_UPDATE_DATE    DATE,
20           p_REQUEST_ID    NUMBER,
21           p_PRICE_ADJUSTMENT_ID    NUMBER,
22           p_PRICING_CONTEXT    VARCHAR2,
23           p_PRICING_ATTRIBUTE    VARCHAR2,
24           p_PRICING_ATTR_VALUE_FROM    VARCHAR2,
25           p_PRICING_ATTR_VALUE_TO    VARCHAR2,
26           p_COMPARISON_OPERATOR    VARCHAR2,
27           p_FLEX_TITLE    VARCHAR2,
28           p_OBJECT_VERSION_NUMBER  NUMBER
29 		);
30 
31 PROCEDURE Update_Row(
32           p_PRICE_ADJ_ATTRIB_ID    NUMBER,
33           p_CREATION_DATE    DATE,
34           p_CREATED_BY    NUMBER,
35           p_LAST_UPDATE_DATE    DATE,
36           p_LAST_UPDATED_BY    NUMBER,
37           p_LAST_UPDATE_LOGIN    NUMBER,
38           p_PROGRAM_APPLICATION_ID    NUMBER,
39           p_PROGRAM_ID    NUMBER,
40           p_PROGRAM_UPDATE_DATE    DATE,
41           p_REQUEST_ID    NUMBER,
42           p_PRICE_ADJUSTMENT_ID    NUMBER,
43           p_PRICING_CONTEXT    VARCHAR2,
44           p_PRICING_ATTRIBUTE    VARCHAR2,
45           p_PRICING_ATTR_VALUE_FROM    VARCHAR2,
46           p_PRICING_ATTR_VALUE_TO    VARCHAR2,
47           p_COMPARISON_OPERATOR    VARCHAR2,
48           p_FLEX_TITLE    VARCHAR2,
49           p_OBJECT_VERSION_NUMBER  NUMBER
50 		);
51 
52 PROCEDURE Lock_Row(
53           --p_OBJECT_VERSION_NUMBER  NUMBER,
54           p_PRICE_ADJ_ATTRIB_ID    NUMBER,
55           p_CREATION_DATE    DATE,
56           p_CREATED_BY    NUMBER,
57           p_LAST_UPDATE_DATE    DATE,
58           p_LAST_UPDATED_BY    NUMBER,
59           p_LAST_UPDATE_LOGIN    NUMBER,
60           p_PROGRAM_APPLICATION_ID    NUMBER,
61           p_PROGRAM_ID    NUMBER,
62           p_PROGRAM_UPDATE_DATE    DATE,
63           p_REQUEST_ID    NUMBER,
64           p_PRICE_ADJUSTMENT_ID    NUMBER,
65           p_PRICING_CONTEXT    VARCHAR2,
66           p_PRICING_ATTRIBUTE    VARCHAR2,
67           p_PRICING_ATTR_VALUE_FROM    VARCHAR2,
68           p_PRICING_ATTR_VALUE_TO    VARCHAR2,
69           p_COMPARISON_OPERATOR    VARCHAR2,
70           p_FLEX_TITLE    VARCHAR2);
71 
72 PROCEDURE Delete_Row(
73     p_PRICE_ADJ_ATTRIB_ID  NUMBER);
74 End ASO_PRICE_ADJ_ATTRIBS_PKG;