1 PACKAGE CSD_RO_BULLETINS_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtrobs.pls 120.0 2008/01/12 02:24:23 rfieldma noship $ */
3 -- Start of Comments
4 -- Package name : CSD_RO_BULLETINS_PKG
5 -- Purpose : Table handler for CSD_RO_BULLETINS
6 -- History : Jan-10-2008 rfieldma created
7 -- NOTE :
8 -- End of Comments
9 /*--------------------------------------------------*/
10 /* procedure name: Insert_Row */
11 /* description : Inserts a row */
12 /* CSD_RO_BULLETINS */
13 /* params: p_RO_BULLETIN_ID NUMBER not req */
14 /* p_REPAIR_LINE_ID NUMBER not req */
15 /* p_BULLETIN_ID NUMBER not req */
16 /* p_LAST_VIEWED_DATE DATE not req */
17 /* p_SOURCE_TYPE VARCHAR2 not req */
18 /* p_SOURCE_ID NUMBER not req */
19 /* p_OBJECT_VERSION_NUMBER NUMBER req */
20 /* p_CREATED_BY NUMBER req */
21 /* p_CREATION_DATE DATE req */
22 /* p_LAST_UPDATED_BY NUMBER req */
23 /* p_LAST_UPDATE_DATE DATE req */
24 /* p_LAST_UPDATE_LOGIN not req */
25 /* */
26 /*--------------------------------------------------*/
27 PROCEDURE Insert_Row(
28 px_RO_BULLETIN_ID IN OUT NOCOPY NUMBER
29 ,p_REPAIR_LINE_ID IN NUMBER
30 ,p_BULLETIN_ID IN NUMBER
31 ,p_LAST_VIEWED_DATE IN DATE
32 ,p_LAST_VIEWED_BY IN NUMBER
33 ,p_SOURCE_TYPE IN VARCHAR2
34 ,p_SOURCE_ID IN NUMBER
35 ,p_OBJECT_VERSION_NUMBER IN NUMBER
36 ,p_CREATED_BY IN NUMBER
37 ,p_CREATION_DATE IN DATE
38 ,p_LAST_UPDATED_BY IN NUMBER
39 ,p_LAST_UPDATE_DATE IN DATE
40 ,p_LAST_UPDATE_LOGIN IN NUMBER);
41
42 /*--------------------------------------------------*/
43 /* procedure name: Update_Row */
44 /* description : Updates a row */
45 /* CSD_RO_BULLETINS */
46 /* params: p_RO_BULLETIN_ID NUMBER required */
47 /* p_REPAIR_LINE_ID NUMBER not req */
48 /* p_BULLETIN_ID NUMBER not req */
49 /* p_LAST_VIEWED_DATE DATE not req */
50 /* p_SOURCE_TYPE VARCHAR2 not req */
51 /* p_SOURCE_ID VARCHAR2 not req */
52 /* p_OBJECT_VERSION_NUMBER NUMBER req */
53 /* p_CREATED_BY NUMBER req */
54 /* p_CREATION_DATE DATE req */
55 /* p_LAST_UPDATED_BY NUMBER req */
56 /* p_LAST_UPDATE_DATE DATE req */
57 /* p_LAST_UPDATE_LOGIN not req */
58 /* */
59 /*--------------------------------------------------*/
60 PROCEDURE Update_Row(
61 p_RO_BULLETIN_ID IN NUMBER
62 ,p_REPAIR_LINE_ID IN NUMBER
63 ,p_BULLETIN_ID IN NUMBER
64 ,p_LAST_VIEWED_DATE IN DATE
65 ,p_LAST_VIEWED_BY IN NUMBER
66 ,p_SOURCE_TYPE IN VARCHAR2
67 ,p_SOURCE_ID IN NUMBER
68 ,p_OBJECT_VERSION_NUMBER IN NUMBER
69 ,p_CREATED_BY IN NUMBER
70 ,p_CREATION_DATE IN DATE
71 ,p_LAST_UPDATED_BY IN NUMBER
72 ,p_LAST_UPDATE_DATE IN DATE
73 ,p_LAST_UPDATE_LOGIN IN NUMBER);
74
75 /*-------------------------------------------------- */
79 /* params: p_RO_BULLETIN_ID NUMBER required */
76 /* procedure name: Lock_Row */
77 /* description : Locks ro */
78 /* CSD_RO_BULLETINS */
80 /* p_OBJECT_VERSION_NUMBER NUMBER required */
81 /*-------------------------------------------------- */
82 PROCEDURE Lock_Row(
83 p_RO_BULLETIN_ID IN NUMBER
84 ,p_OBJECT_VERSION_NUMBER IN NUMBER);
85
86 /*-------------------------------------------------- */
87 /* procedure name: Delete_Row */
88 /* description : Deletes a row in CSD_RO_BULLETINS */
89 /* params: P_RO_BULLETIN_ID NUMBER required */
90 /* */
91 /*-------------------------------------------------- */
92 PROCEDURE Delete_Row(
93 p_RO_BULLETIN_ID IN NUMBER);
94
95
96
97 END CSD_RO_BULLETINS_PKG;