eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_RO_BULLETINS_PKG dependencies on FND_API

Line 48: If (px_RO_BULLETIN_ID IS NULL) OR (px_RO_BULLETIN_ID = FND_API.G_MISS_NUM) THEN

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;
51: CLOSE C2;
52: END IF;

Line 69: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)

65: ,LAST_UPDATE_DATE
66: ,LAST_UPDATE_LOGIN
67: ) VALUES (
68: px_RO_BULLETIN_ID
69: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
70: ,decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, NULL, p_BULLETIN_ID)
71: ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)
72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)

Line 70: ,decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, NULL, p_BULLETIN_ID)

66: ,LAST_UPDATE_LOGIN
67: ) VALUES (
68: px_RO_BULLETIN_ID
69: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
70: ,decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, NULL, p_BULLETIN_ID)
71: ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)
72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)

Line 71: ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)

67: ) VALUES (
68: px_RO_BULLETIN_ID
69: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
70: ,decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, NULL, p_BULLETIN_ID)
71: ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)
72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

Line 72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)

68: px_RO_BULLETIN_ID
69: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
70: ,decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, NULL, p_BULLETIN_ID)
71: ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)
72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)

69: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
70: ,decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, NULL, p_BULLETIN_ID)
71: ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)
72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

Line 74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)

70: ,decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, NULL, p_BULLETIN_ID)
71: ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)
72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
78: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

71: ,decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_VIEWED_DATE)
72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
78: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
79: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

Line 76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

72: ,decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_VIEWED_BY)
73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
78: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
79: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
80: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));

Line 77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

73: ,decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TYPE)
74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
78: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
79: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
80: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
81: END Insert_Row;

Line 78: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

74: ,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
78: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
79: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
80: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
81: END Insert_Row;
82:

Line 79: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

75: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
78: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
79: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
80: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
81: END Insert_Row;
82:
83: /*--------------------------------------------------*/

Line 80: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));

76: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
77: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
78: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
79: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
80: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
81: END Insert_Row;
82:
83: /*--------------------------------------------------*/
84: /* procedure name: Update_Row */

Line 119: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)

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)
122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)

Line 120: ,BULLETIN_ID = decode( p_BULLETIN_ID, FND_API.G_MISS_NUM, BULLETIN_ID, p_BULLETIN_ID)

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)
122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)

Line 121: ,LAST_VIEWED_DATE = decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, LAST_VIEWED_DATE, p_LAST_VIEWED_DATE)

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)
122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

Line 122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)

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)
122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

Line 123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)

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)
122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_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)
122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
128: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

121: ,LAST_VIEWED_DATE = decode( p_LAST_VIEWED_DATE, FND_API.G_MISS_DATE, LAST_VIEWED_DATE, p_LAST_VIEWED_DATE)
122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
128: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
129: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

Line 126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

122: ,LAST_VIEWED_BY = decode( p_LAST_VIEWED_BY, FND_API.G_MISS_NUM, LAST_VIEWED_BY, p_LAST_VIEWED_BY)
123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
128: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
129: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
130: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

123: ,SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_CHAR, SOURCE_TYPE, p_SOURCE_TYPE)
124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
128: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
129: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
130: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
131: where RO_BULLETIN_ID = p_RO_BULLETIN_ID;

Line 128: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

124: ,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
128: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
129: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
130: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
131: where RO_BULLETIN_ID = p_RO_BULLETIN_ID;
132:

Line 129: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

125: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
128: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
129: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
130: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
131: where RO_BULLETIN_ID = p_RO_BULLETIN_ID;
132:
133: IF (SQL%NOTFOUND) THEN

Line 130: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

126: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
127: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
128: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
129: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
130: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
131: where RO_BULLETIN_ID = p_RO_BULLETIN_ID;
132:
133: IF (SQL%NOTFOUND) THEN
134: RAISE NO_DATA_FOUND;