PACKAGE: APPS.CSP_REQ_LINE_DETAILS_PKG

Source

1 PACKAGE CSP_REQ_LINE_DETAILS_PKG AUTHID CURRENT_USER as
2 /* $Header: csptrlds.pls 120.1 2011/06/02 13:02:33 vmandava ship $ */
3 -- Start of Comments
4 -- Package name     : CSP_REQ_LINE_DETAILS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 TYPE internal_user_hooks_rec IS RECORD
11 (REQ_LINE_DETAIL_ID NUMBER ,
12  REQUIREMENT_LINE_ID   NUMBER ,
13  CREATED_BY    NUMBER ,
14  CREATION_DATE    DATE ,
15  LAST_UPDATED_BY    NUMBER ,
16  LAST_UPDATE_DATE    DATE ,
17  LAST_UPDATE_LOGIN    NUMBER ,
18  SOURCE_TYPE VARCHAR2(30) ,
19  SOURCE_ID NUMBER);
20 
21 user_hook_rec  CSP_REQ_LINE_DETAILS_PKG.internal_user_hooks_rec;
22 
23 PROCEDURE Insert_Row(
24           px_REQ_LINE_DETAIL_ID   IN OUT NOCOPY NUMBER,
25           p_REQUIREMENT_LINE_ID   NUMBER,
26           p_CREATED_BY    NUMBER,
27           p_CREATION_DATE    DATE,
28           p_LAST_UPDATED_BY    NUMBER,
29           p_LAST_UPDATE_DATE    DATE,
30           p_LAST_UPDATE_LOGIN    NUMBER,
31           p_SOURCE_TYPE VARCHAR2,
32           p_SOURCE_ID NUMBER,
33           p_DML_MODE VARCHAR2 DEFAULT NULL);
34 
35 PROCEDURE Update_Row(
36           px_REQ_LINE_DETAIL_ID   IN OUT NOCOPY NUMBER,
37           p_REQUIREMENT_LINE_ID   NUMBER,
38           p_CREATED_BY    NUMBER,
39           p_CREATION_DATE    DATE,
40           p_LAST_UPDATED_BY    NUMBER,
41           p_LAST_UPDATE_DATE    DATE,
42           p_LAST_UPDATE_LOGIN    NUMBER,
43           p_SOURCE_TYPE VARCHAR2,
44           p_SOURCE_ID NUMBER,
45           p_DML_MODE VARCHAR2 DEFAULT NULL);
46 
47 PROCEDURE Lock_Row(
48           px_REQ_LINE_DETAIL_ID   IN OUT NOCOPY NUMBER,
49           p_REQUIREMENT_LINE_ID   NUMBER,
50           p_CREATED_BY    NUMBER,
51           p_CREATION_DATE    DATE,
52           p_LAST_UPDATED_BY    NUMBER,
53           p_LAST_UPDATE_DATE    DATE,
54           p_LAST_UPDATE_LOGIN    NUMBER,
55           p_SOURCE_TYPE VARCHAR2,
56           p_SOURCE_ID NUMBER
57           );
58 
59 PROCEDURE Delete_Row(
60     px_REQ_LINE_DETAIL_ID  NUMBER,
61     p_DML_MODE VARCHAR2 DEFAULT NULL);
62 End CSP_REQ_LINE_DETAILS_PKG;