PACKAGE: APPS.CSP_REQ_LINE_DETAILS_PKG

Source

1 PACKAGE CSP_REQ_LINE_DETAILS_PKG  as
2 /* $Header: csptrlds.pls 120.0 2005/05/25 11:42:17 appldev noship $ */
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 
34 PROCEDURE Update_Row(
35           px_REQ_LINE_DETAIL_ID   IN OUT NOCOPY NUMBER,
36           p_REQUIREMENT_LINE_ID   NUMBER,
37           p_CREATED_BY    NUMBER,
38           p_CREATION_DATE    DATE,
39           p_LAST_UPDATED_BY    NUMBER,
40           p_LAST_UPDATE_DATE    DATE,
41           p_LAST_UPDATE_LOGIN    NUMBER,
42           p_SOURCE_TYPE VARCHAR2,
43           p_SOURCE_ID NUMBER);
44 
45 PROCEDURE Lock_Row(
46           px_REQ_LINE_DETAIL_ID   IN OUT NOCOPY NUMBER,
47           p_REQUIREMENT_LINE_ID   NUMBER,
48           p_CREATED_BY    NUMBER,
49           p_CREATION_DATE    DATE,
50           p_LAST_UPDATED_BY    NUMBER,
51           p_LAST_UPDATE_DATE    DATE,
52           p_LAST_UPDATE_LOGIN    NUMBER,
53           p_SOURCE_TYPE VARCHAR2,
54           p_SOURCE_ID NUMBER
55           );
56 
57 PROCEDURE Delete_Row(
58     px_REQ_LINE_DETAIL_ID  NUMBER);
59 End CSP_REQ_LINE_DETAILS_PKG;