APPS.CSD_RO_BULLETINS_PKG dependencies on CSD_RO_BULLETINS

Line 1: PACKAGE BODY CSD_RO_BULLETINS_PKG as

1: PACKAGE BODY CSD_RO_BULLETINS_PKG as
2: /* $Header: csdtrobb.pls 120.0 2008/01/12 02:24:57 rfieldma noship $ */
3: -- Start of Comments
4: -- Package name : CSD_RO_BULLETINS_PKG
5: -- Purpose : table handler for CSD_RO_BULLETINS

Line 4: -- Package name : CSD_RO_BULLETINS_PKG

1: PACKAGE BODY CSD_RO_BULLETINS_PKG as
2: /* $Header: csdtrobb.pls 120.0 2008/01/12 02:24:57 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

Line 5: -- Purpose : table handler for CSD_RO_BULLETINS

1: PACKAGE BODY CSD_RO_BULLETINS_PKG as
2: /* $Header: csdtrobb.pls 120.0 2008/01/12 02:24:57 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:

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_RO_BULLETINS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_RO_BULLETINS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtrobb.pls';
13: /*--------------------------------------------------*/
14: /* procedure name: Insert_Row */
15: /* description : Inserts a row */

Line 16: /* CSD_RO_BULLETINS */

12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtrobb.pls';
13: /*--------------------------------------------------*/
14: /* procedure name: Insert_Row */
15: /* description : Inserts a row */
16: /* CSD_RO_BULLETINS */
17: /* params: p_RO_BULLETIN_ID NUMBER not req */
18: /* p_REPAIR_LINE_ID NUMBER not req */
19: /* p_BULLETIN_ID NUMBER not req */
20: /* p_LAST_VIEWED_DATE DATE not req */

Line 46: CURSOR C2 IS SELECT CSD_RO_BULLETINS_S1.nextval FROM sys.dual;

42: ,p_LAST_UPDATED_BY IN NUMBER
43: ,p_LAST_UPDATE_DATE IN DATE
44: ,p_LAST_UPDATE_LOGIN IN NUMBER)
45: IS
46: CURSOR C2 IS SELECT CSD_RO_BULLETINS_S1.nextval FROM sys.dual;
47: BEGIN
48: If (px_RO_BULLETIN_ID IS NULL) OR (px_RO_BULLETIN_ID = FND_API.G_MISS_NUM) THEN
49: OPEN C2;
50: FETCH C2 INTO px_RO_BULLETIN_ID;

Line 53: INSERT INTO CSD_RO_BULLETINS(

49: OPEN C2;
50: FETCH C2 INTO px_RO_BULLETIN_ID;
51: CLOSE C2;
52: END IF;
53: INSERT INTO CSD_RO_BULLETINS(
54: RO_BULLETIN_ID
55: ,REPAIR_LINE_ID
56: ,BULLETIN_ID
57: ,LAST_VIEWED_DATE

Line 86: /* CSD_RO_BULLETINS */

82:
83: /*--------------------------------------------------*/
84: /* procedure name: Update_Row */
85: /* description : Updates a row */
86: /* CSD_RO_BULLETINS */
87: /* params: p_RO_BULLETIN_ID NUMBER required */
88: /* p_REPAIR_LINE_ID NUMBER not req */
89: /* p_BULLETIN_ID NUMBER not req */
90: /* p_LAST_VIEWED_DATE DATE not req */

Line 117: Update CSD_RO_BULLETINS

113: ,p_LAST_UPDATE_DATE IN DATE
114: ,p_LAST_UPDATE_LOGIN IN NUMBER)
115: IS
116: BEGIN
117: Update CSD_RO_BULLETINS
118: SET
119: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
120: ,BULLETIN_ID = decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, BULLETIN_ID, p_BULLETIN_ID)
121: ,LAST_VIEWED_DATE = decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, LAST_VIEWED_DATE, p_LAST_VIEWED_DATE)

Line 142: /* description : Deletes a row in CSD_RO_BULLETINS */

138:
139:
140: /*-------------------------------------------------- */
141: /* procedure name: Delete_Row */
142: /* description : Deletes a row in CSD_RO_BULLETINS */
143: /* params: P_RO_BULLETIN_ID NUMBER required */
144: /* */
145: /*-------------------------------------------------- */
146: PROCEDURE Delete_Row(

Line 150: DELETE FROM CSD_RO_BULLETINS

146: PROCEDURE Delete_Row(
147: p_RO_BULLETIN_ID IN NUMBER)
148: IS
149: BEGIN
150: DELETE FROM CSD_RO_BULLETINS
151: WHERE RO_BULLETIN_ID = p_RO_BULLETIN_ID;
152: If (SQL%NOTFOUND) then
153: RAISE NO_DATA_FOUND;
154: End If;

Line 161: /* CSD_RO_BULLETINS */

157:
158: /*-------------------------------------------------- */
159: /* procedure name: Lock_Row */
160: /* description : Locks ro */
161: /* CSD_RO_BULLETINS */
162: /* params: p_RO_BULLETIN_ID NUMBER required */
163: /* p_OBJECT_VERSION_NUMBER NUMBER required */
164: /*-------------------------------------------------- */
165: PROCEDURE Lock_Row(

Line 172: FROM CSD_RO_BULLETINS

168:
169: IS
170: CURSOR C IS
171: SELECT *
172: FROM CSD_RO_BULLETINS
173: WHERE RO_BULLETIN_ID = p_RO_BULLETIN_ID
174: FOR UPDATE of RO_BULLETIN_ID NOWAIT;
175: Recinfo C%ROWTYPE;
176: BEGIN

Line 233: END CSD_RO_BULLETINS_PKG;

229: APP_EXCEPTION.RAISE_EXCEPTION;
230: End IF;
231: END Lock_Row;
232:
233: END CSD_RO_BULLETINS_PKG;