PACKAGE: APPS.ASO_PRICE_RLTSHIPS_PKG

Source

1 PACKAGE ASO_PRICE_RLTSHIPS_PKG as
2 /* $Header: asotprls.pls 120.1 2005/06/29 12:40:12 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_PRICE_RELATIONSHIPS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_ADJ_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_PROGRAM_APPLICATION_ID NUMBER,
18           p_PROGRAM_ID    NUMBER,
19           p_PROGRAM_UPDATE_DATE    DATE,
20           p_REQUEST_ID     NUMBER,
21           p_QUOTE_LINE_ID  NUMBER,
22           p_PRICE_ADJUSTMENT_ID  NUMBER,
23           p_RLTD_PRICE_ADJ_ID  NUMBER,
24 		p_quote_shipment_id                         NUMBER := NULL,
25           p_OBJECT_VERSION_NUMBER  NUMBER
26 		);
27 
28 PROCEDURE Update_Row(
29           p_ADJ_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_PROGRAM_APPLICATION_ID NUMBER,
36           p_PROGRAM_ID    NUMBER,
37           p_PROGRAM_UPDATE_DATE    DATE,
38           p_REQUEST_ID     NUMBER,
39           p_QUOTE_LINE_ID  NUMBER,
40           p_PRICE_ADJUSTMENT_ID  NUMBER,
41           p_RLTD_PRICE_ADJ_ID  NUMBER,
42 		p_quote_shipment_id  NUMBER,
43           p_OBJECT_VERSION_NUMBER  NUMBER
44 		);
45 
46 PROCEDURE Lock_Row(
47           --p_OBJECT_VERSION_NUMBER  NUMBER,
48           p_ADJ_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_PROGRAM_APPLICATION_ID NUMBER,
55           p_PROGRAM_ID    NUMBER,
56           p_PROGRAM_UPDATE_DATE    DATE,
57           p_REQUEST_ID     NUMBER,
58           p_QUOTE_LINE_ID  NUMBER,
59           p_PRICE_ADJUSTMENT_ID  NUMBER,
60           p_RLTD_PRICE_ADJ_ID  NUMBER,
61 		p_quote_shipment_id                         NUMBER := NULL);
62 
63 PROCEDURE Delete_Row(
64     p_ADJ_RELATIONSHIP_ID  NUMBER);
65 
66 End ASO_PRICE_RLTSHIPS_PKG;