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.IBC_AUDIT_LOGS_PKG dependencies on FND_API

Line 62: (px_AUDIT_LOG_ID = FND_API.G_MISS_NUM))

58: BEGIN
59:
60: -- Primary key validation check
61: IF ((px_AUDIT_LOG_ID IS NULL) OR
62: (px_AUDIT_LOG_ID = FND_API.G_MISS_NUM))
63: THEN
64: OPEN c2;
65: FETCH c2 INTO px_AUDIT_LOG_ID;
66: CLOSE c2;

Line 118: DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE2),

114: p_USER_ID,
115: p_TIME_STAMP,
116: p_OBJECT_TYPE,
117: p_OBJECT_VALUE1,
118: DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE2),
119: DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE3),
120: DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),
121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),

Line 119: DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE3),

115: p_TIME_STAMP,
116: p_OBJECT_TYPE,
117: p_OBJECT_VALUE1,
118: DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE2),
119: DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE3),
120: DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),
121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123:

Line 120: DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),

116: p_OBJECT_TYPE,
117: p_OBJECT_VALUE1,
118: DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE2),
119: DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE3),
120: DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),
121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123:
124: FND_GLOBAL.RESP_APPL_ID,

Line 121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),

117: p_OBJECT_VALUE1,
118: DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE2),
119: DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE3),
120: DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),
121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123:
124: FND_GLOBAL.RESP_APPL_ID,
125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),

Line 122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),

118: DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE2),
119: DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE3),
120: DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),
121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123:
124: FND_GLOBAL.RESP_APPL_ID,
125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),

Line 125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),

121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123:
124: FND_GLOBAL.RESP_APPL_ID,
125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),

Line 126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),

122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123:
124: FND_GLOBAL.RESP_APPL_ID,
125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),

Line 127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),

123:
124: FND_GLOBAL.RESP_APPL_ID,
125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),

Line 128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),

124: FND_GLOBAL.RESP_APPL_ID,
125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),

Line 129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),

125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),

Line 130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),

126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),

Line 131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),

127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),

Line 132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),

128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),

Line 133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),

129: DECODE(P_EXTRA_INFO1_TYPE,FND_API.G_MISS_CHAR,NULL,p_EXTRA_INFO1_TYPE),
130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),

Line 134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),

130: DECODE(P_EXTRA_INFO1_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_REF_TYPE),
131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),

Line 135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),

131: DECODE(P_EXTRA_INFO1_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO1_VALUE),
132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),

Line 136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),

132: DECODE(P_EXTRA_INFO2_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_TYPE),
133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),

Line 137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),

133: DECODE(P_EXTRA_INFO2_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_REF_TYPE),
134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),
141: DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),

Line 138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),

134: DECODE(P_EXTRA_INFO2_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO2_VALUE),
135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),
141: DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),
142: DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),

Line 139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),

135: DECODE(P_EXTRA_INFO3_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_TYPE),
136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),
141: DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),
142: DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),
143: DECODE(P_EXTRA_INFO5_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_VALUE),

Line 140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),

136: DECODE(P_EXTRA_INFO3_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_REF_TYPE),
137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),
141: DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),
142: DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),
143: DECODE(P_EXTRA_INFO5_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_VALUE),
144:

Line 141: DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),

137: DECODE(P_EXTRA_INFO3_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO3_VALUE),
138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),
141: DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),
142: DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),
143: DECODE(P_EXTRA_INFO5_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_VALUE),
144:
145: p_OBJECT_VERSION_NUMBER,

Line 142: DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),

138: DECODE(P_EXTRA_INFO4_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_TYPE),
139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),
141: DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),
142: DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),
143: DECODE(P_EXTRA_INFO5_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_VALUE),
144:
145: p_OBJECT_VERSION_NUMBER,
146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 143: DECODE(P_EXTRA_INFO5_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_VALUE),

139: DECODE(P_EXTRA_INFO4_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_REF_TYPE),
140: DECODE(P_EXTRA_INFO4_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO4_VALUE),
141: DECODE(P_EXTRA_INFO5_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_TYPE),
142: DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),
143: DECODE(P_EXTRA_INFO5_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_VALUE),
144:
145: p_OBJECT_VERSION_NUMBER,
146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147: p_creation_date),

Line 146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

142: DECODE(P_EXTRA_INFO5_REF_TYPE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_REF_TYPE),
143: DECODE(P_EXTRA_INFO5_VALUE,FND_API.G_MISS_CHAR,NULL,P_EXTRA_INFO5_VALUE),
144:
145: p_OBJECT_VERSION_NUMBER,
146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147: p_creation_date),
148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

144:
145: p_OBJECT_VERSION_NUMBER,
146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147: p_creation_date),
148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147: p_creation_date),
148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );

Line 154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );
157:
158:

Line 320: p_ACTIVITY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

316: END LOCK_ROW;
317:
318: /*PROCEDURE UPDATE_ROW (
319: p_AUDIT_LOG_ID IN NUMBER,
320: p_ACTIVITY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_parent_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 321: p_parent_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

317:
318: /*PROCEDURE UPDATE_ROW (
319: p_AUDIT_LOG_ID IN NUMBER,
320: p_ACTIVITY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_parent_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 322: p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

318: /*PROCEDURE UPDATE_ROW (
319: p_AUDIT_LOG_ID IN NUMBER,
320: p_ACTIVITY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_parent_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

319: p_AUDIT_LOG_ID IN NUMBER,
320: p_ACTIVITY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_parent_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

320: p_ACTIVITY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_parent_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,

321: p_parent_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322: p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

322: p_DESCRIPTION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

323: p_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: p_OBJECT_VALUE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

324: p_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: p_OBJECT_VALUE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332:

Line 329: p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

325: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: p_OBJECT_VALUE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332:
333: P_OBJECT_STATUS IN VARCHAR2 DEFAULT NULL,

Line 330: p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

326: p_OBJECT_TYPE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: p_OBJECT_VALUE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332:
333: P_OBJECT_STATUS IN VARCHAR2 DEFAULT NULL,
334: P_INTERNAL_FLAG IN VARCHAR2 DEFAULT NULL,

Line 331: p_OBJECT_VALUE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

327: p_OBJECT_VALUE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_OBJECT_VALUE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_OBJECT_VALUE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_OBJECT_VALUE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: p_OBJECT_VALUE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332:
333: P_OBJECT_STATUS IN VARCHAR2 DEFAULT NULL,
334: P_INTERNAL_FLAG IN VARCHAR2 DEFAULT NULL,
335: P_MESSAGE_APPLICATION IN VARCHAR2 DEFAULT NULL,

Line 353: p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,

349: P_EXTRA_INFO5_TYPE IN VARCHAR2 DEFAULT NULL,
350: P_EXTRA_INFO5_REF_TYPE IN VARCHAR2 DEFAULT NULL,
351: P_EXTRA_INFO5_VALUE IN VARCHAR2 DEFAULT NULL,
352:
353: p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_TIME_STAMP IN DATE DEFAULT FND_API.G_MISS_DATE,
355: p_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356: ) IS
357: BEGIN

Line 354: p_TIME_STAMP IN DATE DEFAULT FND_API.G_MISS_DATE,

350: P_EXTRA_INFO5_REF_TYPE IN VARCHAR2 DEFAULT NULL,
351: P_EXTRA_INFO5_VALUE IN VARCHAR2 DEFAULT NULL,
352:
353: p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_TIME_STAMP IN DATE DEFAULT FND_API.G_MISS_DATE,
355: p_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356: ) IS
357: BEGIN
358: UPDATE IBC_AUDIT_LOGS SET

Line 355: p_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM

351: P_EXTRA_INFO5_VALUE IN VARCHAR2 DEFAULT NULL,
352:
353: p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_TIME_STAMP IN DATE DEFAULT FND_API.G_MISS_DATE,
355: p_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356: ) IS
357: BEGIN
358: UPDATE IBC_AUDIT_LOGS SET
359: ACTIVITY = DECODE(p_ACTIVITY,FND_API.G_MISS_CHAR,ACTIVITY,p_ACTIVITY),

Line 359: ACTIVITY = DECODE(p_ACTIVITY,FND_API.G_MISS_CHAR,ACTIVITY,p_ACTIVITY),

355: p_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356: ) IS
357: BEGIN
358: UPDATE IBC_AUDIT_LOGS SET
359: ACTIVITY = DECODE(p_ACTIVITY,FND_API.G_MISS_CHAR,ACTIVITY,p_ACTIVITY),
360: PARENT_ID = DECODE(p_parent_id,FND_API.G_MISS_CHAR,parent_id,p_parent_id),
361: USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),
362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),

Line 360: PARENT_ID = DECODE(p_parent_id,FND_API.G_MISS_CHAR,parent_id,p_parent_id),

356: ) IS
357: BEGIN
358: UPDATE IBC_AUDIT_LOGS SET
359: ACTIVITY = DECODE(p_ACTIVITY,FND_API.G_MISS_CHAR,ACTIVITY,p_ACTIVITY),
360: PARENT_ID = DECODE(p_parent_id,FND_API.G_MISS_CHAR,parent_id,p_parent_id),
361: USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),
362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),

Line 361: USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),

357: BEGIN
358: UPDATE IBC_AUDIT_LOGS SET
359: ACTIVITY = DECODE(p_ACTIVITY,FND_API.G_MISS_CHAR,ACTIVITY,p_ACTIVITY),
360: PARENT_ID = DECODE(p_parent_id,FND_API.G_MISS_CHAR,parent_id,p_parent_id),
361: USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),
362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),

Line 362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),

358: UPDATE IBC_AUDIT_LOGS SET
359: ACTIVITY = DECODE(p_ACTIVITY,FND_API.G_MISS_CHAR,ACTIVITY,p_ACTIVITY),
360: PARENT_ID = DECODE(p_parent_id,FND_API.G_MISS_CHAR,parent_id,p_parent_id),
361: USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),
362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),

Line 363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),

359: ACTIVITY = DECODE(p_ACTIVITY,FND_API.G_MISS_CHAR,ACTIVITY,p_ACTIVITY),
360: PARENT_ID = DECODE(p_parent_id,FND_API.G_MISS_CHAR,parent_id,p_parent_id),
361: USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),
362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),
367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),

Line 364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),

360: PARENT_ID = DECODE(p_parent_id,FND_API.G_MISS_CHAR,parent_id,p_parent_id),
361: USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),
362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),
367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),
368: OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),

Line 365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),

361: USER_ID = DECODE(p_USER_ID,FND_API.G_MISS_NUM,USER_ID,p_USER_ID),
362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),
367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),
368: OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),
369: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),

Line 366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),

362: TIME_STAMP = DECODE(p_TIME_STAMP,FND_API.G_MISS_DATE,TIME_STAMP,p_TIME_STAMP),
363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),
367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),
368: OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),
369: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
370: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),

363: OBJECT_TYPE = DECODE(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),
367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),
368: OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),
369: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
370: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
371: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

Line 368: OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),

364: OBJECT_VALUE1 = DECODE(p_OBJECT_VALUE1,FND_API.G_MISS_CHAR,OBJECT_VALUE1,p_OBJECT_VALUE1),
365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),
367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),
368: OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),
369: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
370: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
371: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
372: NULL, SYSDATE, p_last_update_date),

Line 369: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),

365: OBJECT_VALUE2 = DECODE(p_OBJECT_VALUE2,FND_API.G_MISS_CHAR,OBJECT_VALUE2,p_OBJECT_VALUE2),
366: OBJECT_VALUE3 = DECODE(p_OBJECT_VALUE3,FND_API.G_MISS_CHAR,OBJECT_VALUE3,p_OBJECT_VALUE3),
367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),
368: OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),
369: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
370: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
371: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
372: NULL, SYSDATE, p_last_update_date),
373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

Line 371: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

367: OBJECT_VALUE4 = DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,OBJECT_VALUE4,p_OBJECT_VALUE4),
368: OBJECT_VALUE5 = DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,OBJECT_VALUE5,p_OBJECT_VALUE5),
369: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
370: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
371: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
372: NULL, SYSDATE, p_last_update_date),
373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
374: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
375: p_last_updated_by),

Line 373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

369: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
370: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
371: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
372: NULL, SYSDATE, p_last_update_date),
373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
374: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
375: p_last_updated_by),
376: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
377: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 376: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,

372: NULL, SYSDATE, p_last_update_date),
373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
374: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
375: p_last_updated_by),
376: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
377: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
378: p_last_update_login)
379:
380: WHERE AUDIT_LOG_ID = p_AUDIT_LOG_ID

Line 382: FND_API.G_MISS_NUM,

378: p_last_update_login)
379:
380: WHERE AUDIT_LOG_ID = p_AUDIT_LOG_ID
381: AND object_version_number = DECODE(p_object_version_number,
382: FND_API.G_MISS_NUM,
383: object_version_number,
384: p_object_version_number);
385:
386: IF (SQL%NOTFOUND) THEN