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

Line 109: DECODE( x_last_updated_by, FND_API.g_miss_num, NULL, x_last_updated_by),

105: object_version_number,
106: process_objective_id,
107: requestor_id
108: ) VALUES (
109: DECODE( x_last_updated_by, FND_API.g_miss_num, NULL, x_last_updated_by),
110: DECODE( x_last_update_date, FND_API.g_miss_date, NULL, x_last_update_date),
111: DECODE( x_created_by, FND_API.g_miss_num, NULL, x_created_by),
112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),
113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),

Line 110: DECODE( x_last_update_date, FND_API.g_miss_date, NULL, x_last_update_date),

106: process_objective_id,
107: requestor_id
108: ) VALUES (
109: DECODE( x_last_updated_by, FND_API.g_miss_num, NULL, x_last_updated_by),
110: DECODE( x_last_update_date, FND_API.g_miss_date, NULL, x_last_update_date),
111: DECODE( x_created_by, FND_API.g_miss_num, NULL, x_created_by),
112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),
113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),
114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),

Line 111: DECODE( x_created_by, FND_API.g_miss_num, NULL, x_created_by),

107: requestor_id
108: ) VALUES (
109: DECODE( x_last_updated_by, FND_API.g_miss_num, NULL, x_last_updated_by),
110: DECODE( x_last_update_date, FND_API.g_miss_date, NULL, x_last_update_date),
111: DECODE( x_created_by, FND_API.g_miss_num, NULL, x_created_by),
112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),
113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),
114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),
115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),

Line 112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),

108: ) VALUES (
109: DECODE( x_last_updated_by, FND_API.g_miss_num, NULL, x_last_updated_by),
110: DECODE( x_last_update_date, FND_API.g_miss_date, NULL, x_last_update_date),
111: DECODE( x_created_by, FND_API.g_miss_num, NULL, x_created_by),
112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),
113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),
114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),
115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),
116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),

Line 113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),

109: DECODE( x_last_updated_by, FND_API.g_miss_num, NULL, x_last_updated_by),
110: DECODE( x_last_update_date, FND_API.g_miss_date, NULL, x_last_update_date),
111: DECODE( x_created_by, FND_API.g_miss_num, NULL, x_created_by),
112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),
113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),
114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),
115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),
116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),
117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),

Line 114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),

110: DECODE( x_last_update_date, FND_API.g_miss_date, NULL, x_last_update_date),
111: DECODE( x_created_by, FND_API.g_miss_num, NULL, x_created_by),
112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),
113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),
114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),
115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),
116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),
117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),
118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),

Line 115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),

111: DECODE( x_created_by, FND_API.g_miss_num, NULL, x_created_by),
112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),
113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),
114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),
115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),
116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),
117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),
118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),
119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),

Line 116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),

112: DECODE( x_creation_date, FND_API.g_miss_date, NULL, x_creation_date),
113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),
114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),
115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),
116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),
117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),
118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),
119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),
120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),

Line 117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),

113: DECODE( x_last_update_login, FND_API.g_miss_num, NULL, x_last_update_login),
114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),
115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),
116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),
117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),
118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),
119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),
120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),
121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),

Line 118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),

114: DECODE( x_objective_type, FND_API.g_miss_char, NULL, x_objective_type),
115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),
116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),
117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),
118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),
119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),
120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),
121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),
122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),

Line 119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),

115: DECODE( x_start_date, FND_API.g_miss_date, NULL, x_start_date),
116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),
117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),
118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),
119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),
120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),
121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),
122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),
123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),

Line 120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),

116: DECODE( x_end_date, FND_API.g_miss_date, NULL, x_end_date),
117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),
118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),
119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),
120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),
121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),
122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),
123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),
124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),

Line 121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),

117: DECODE( x_attribute_category, FND_API.g_miss_char, NULL, x_attribute_category),
118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),
119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),
120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),
121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),
122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),
123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),
124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),
125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),

Line 122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),

118: DECODE( x_attribute1, FND_API.g_miss_char, NULL, x_attribute1),
119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),
120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),
121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),
122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),
123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),
124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),
125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),
126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),

Line 123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),

119: DECODE( x_attribute2, FND_API.g_miss_char, NULL, x_attribute2),
120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),
121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),
122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),
123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),
124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),
125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),
126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),
127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),

Line 124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),

120: DECODE( x_attribute3, FND_API.g_miss_char, NULL, x_attribute3),
121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),
122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),
123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),
124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),
125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),
126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),
127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),
128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),

Line 125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),

121: DECODE( x_attribute4, FND_API.g_miss_char, NULL, x_attribute4),
122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),
123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),
124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),
125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),
126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),
127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),
128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),
129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),

Line 126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),

122: DECODE( x_attribute5, FND_API.g_miss_char, NULL, x_attribute5),
123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),
124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),
125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),
126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),
127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),
128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),
129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),
130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),

Line 127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),

123: DECODE( x_attribute6, FND_API.g_miss_char, NULL, x_attribute6),
124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),
125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),
126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),
127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),
128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),
129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),
130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),
131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),

Line 128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),

124: DECODE( x_attribute7, FND_API.g_miss_char, NULL, x_attribute7),
125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),
126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),
127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),
128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),
129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),
130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),
131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),
132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),

Line 129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),

125: DECODE( x_attribute8, FND_API.g_miss_char, NULL, x_attribute8),
126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),
127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),
128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),
129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),
130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),
131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),
132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),
133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),

Line 130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),

126: DECODE( x_attribute9, FND_API.g_miss_char, NULL, x_attribute9),
127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),
128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),
129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),
130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),
131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),
132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),
133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),
134: DECODE( x_object_version_number, FND_API.g_miss_num, NULL, x_object_version_number),

Line 131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),

127: DECODE( x_attribute10, FND_API.g_miss_char, NULL, x_attribute10),
128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),
129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),
130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),
131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),
132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),
133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),
134: DECODE( x_object_version_number, FND_API.g_miss_num, NULL, x_object_version_number),
135: DECODE( x_process_objective_id, FND_API.g_miss_num, NULL, x_process_objective_id),

Line 132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),

128: DECODE( x_attribute11, FND_API.g_miss_char, NULL, x_attribute11),
129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),
130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),
131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),
132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),
133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),
134: DECODE( x_object_version_number, FND_API.g_miss_num, NULL, x_object_version_number),
135: DECODE( x_process_objective_id, FND_API.g_miss_num, NULL, x_process_objective_id),
136: DECODE( x_requestor_id, FND_API.g_miss_num, NULL, x_requestor_id));

Line 133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),

129: DECODE( x_attribute12, FND_API.g_miss_char, NULL, x_attribute12),
130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),
131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),
132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),
133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),
134: DECODE( x_object_version_number, FND_API.g_miss_num, NULL, x_object_version_number),
135: DECODE( x_process_objective_id, FND_API.g_miss_num, NULL, x_process_objective_id),
136: DECODE( x_requestor_id, FND_API.g_miss_num, NULL, x_requestor_id));
137:

Line 134: DECODE( x_object_version_number, FND_API.g_miss_num, NULL, x_object_version_number),

130: DECODE( x_attribute13, FND_API.g_miss_char, NULL, x_attribute13),
131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),
132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),
133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),
134: DECODE( x_object_version_number, FND_API.g_miss_num, NULL, x_object_version_number),
135: DECODE( x_process_objective_id, FND_API.g_miss_num, NULL, x_process_objective_id),
136: DECODE( x_requestor_id, FND_API.g_miss_num, NULL, x_requestor_id));
137:
138: insert into AMW_process_objectives_TL (

Line 135: DECODE( x_process_objective_id, FND_API.g_miss_num, NULL, x_process_objective_id),

131: DECODE( x_attribute14, FND_API.g_miss_char, NULL, x_attribute14),
132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),
133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),
134: DECODE( x_object_version_number, FND_API.g_miss_num, NULL, x_object_version_number),
135: DECODE( x_process_objective_id, FND_API.g_miss_num, NULL, x_process_objective_id),
136: DECODE( x_requestor_id, FND_API.g_miss_num, NULL, x_requestor_id));
137:
138: insert into AMW_process_objectives_TL (
139: process_objective_id,

Line 136: DECODE( x_requestor_id, FND_API.g_miss_num, NULL, x_requestor_id));

132: DECODE( x_attribute15, FND_API.g_miss_char, NULL, x_attribute15),
133: DECODE( x_security_group_id, FND_API.g_miss_num, NULL, x_security_group_id),
134: DECODE( x_object_version_number, FND_API.g_miss_num, NULL, x_object_version_number),
135: DECODE( x_process_objective_id, FND_API.g_miss_num, NULL, x_process_objective_id),
136: DECODE( x_requestor_id, FND_API.g_miss_num, NULL, x_requestor_id));
137:
138: insert into AMW_process_objectives_TL (
139: process_objective_id,
140: NAME,

Line 234: last_updated_by = DECODE( x_last_updated_by, FND_API.g_miss_num, last_updated_by, x_last_updated_by),

230: IS
231: BEGIN
232: Update AMW_PROCESS_OBJECTIVES_B
233: SET
234: last_updated_by = DECODE( x_last_updated_by, FND_API.g_miss_num, last_updated_by, x_last_updated_by),
235: last_update_date = DECODE( x_last_update_date, FND_API.g_miss_date, last_update_date, x_last_update_date),
236: --created_by = DECODE( x_created_by, FND_API.g_miss_num, created_by, x_created_by),
237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),
238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),

Line 235: last_update_date = DECODE( x_last_update_date, FND_API.g_miss_date, last_update_date, x_last_update_date),

231: BEGIN
232: Update AMW_PROCESS_OBJECTIVES_B
233: SET
234: last_updated_by = DECODE( x_last_updated_by, FND_API.g_miss_num, last_updated_by, x_last_updated_by),
235: last_update_date = DECODE( x_last_update_date, FND_API.g_miss_date, last_update_date, x_last_update_date),
236: --created_by = DECODE( x_created_by, FND_API.g_miss_num, created_by, x_created_by),
237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),
238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),
239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),

Line 236: --created_by = DECODE( x_created_by, FND_API.g_miss_num, created_by, x_created_by),

232: Update AMW_PROCESS_OBJECTIVES_B
233: SET
234: last_updated_by = DECODE( x_last_updated_by, FND_API.g_miss_num, last_updated_by, x_last_updated_by),
235: last_update_date = DECODE( x_last_update_date, FND_API.g_miss_date, last_update_date, x_last_update_date),
236: --created_by = DECODE( x_created_by, FND_API.g_miss_num, created_by, x_created_by),
237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),
238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),
239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),
240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),

Line 237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),

233: SET
234: last_updated_by = DECODE( x_last_updated_by, FND_API.g_miss_num, last_updated_by, x_last_updated_by),
235: last_update_date = DECODE( x_last_update_date, FND_API.g_miss_date, last_update_date, x_last_update_date),
236: --created_by = DECODE( x_created_by, FND_API.g_miss_num, created_by, x_created_by),
237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),
238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),
239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),
240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),
241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),

Line 238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),

234: last_updated_by = DECODE( x_last_updated_by, FND_API.g_miss_num, last_updated_by, x_last_updated_by),
235: last_update_date = DECODE( x_last_update_date, FND_API.g_miss_date, last_update_date, x_last_update_date),
236: --created_by = DECODE( x_created_by, FND_API.g_miss_num, created_by, x_created_by),
237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),
238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),
239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),
240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),
241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),
242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),

Line 239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),

235: last_update_date = DECODE( x_last_update_date, FND_API.g_miss_date, last_update_date, x_last_update_date),
236: --created_by = DECODE( x_created_by, FND_API.g_miss_num, created_by, x_created_by),
237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),
238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),
239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),
240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),
241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),
242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),
243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),

Line 240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),

236: --created_by = DECODE( x_created_by, FND_API.g_miss_num, created_by, x_created_by),
237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),
238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),
239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),
240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),
241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),
242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),
243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),
244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),

Line 241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),

237: --creation_date = DECODE( x_creation_date, FND_API.g_miss_date, creation_date, x_creation_date),
238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),
239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),
240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),
241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),
242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),
243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),
244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),
245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),

Line 242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),

238: last_update_login = DECODE( x_last_update_login, FND_API.g_miss_num, last_update_login, x_last_update_login),
239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),
240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),
241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),
242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),
243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),
244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),
245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),
246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),

Line 243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),

239: objective_type = DECODE( x_objective_type, FND_API.g_miss_char, objective_type, x_objective_type),
240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),
241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),
242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),
243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),
244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),
245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),
246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),
247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),

Line 244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),

240: start_date = DECODE( x_start_date, FND_API.g_miss_date, start_date, x_start_date),
241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),
242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),
243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),
244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),
245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),
246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),
247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),
248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),

Line 245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),

241: end_date = DECODE( x_end_date, FND_API.g_miss_date, end_date, x_end_date),
242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),
243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),
244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),
245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),
246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),
247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),
248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),
249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),

Line 246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),

242: attribute_category = DECODE( x_attribute_category, FND_API.g_miss_char, attribute_category, x_attribute_category),
243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),
244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),
245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),
246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),
247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),
248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),
249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),
250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),

Line 247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),

243: attribute1 = DECODE( x_attribute1, FND_API.g_miss_char, attribute1, x_attribute1),
244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),
245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),
246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),
247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),
248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),
249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),
250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),
251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),

Line 248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),

244: attribute2 = DECODE( x_attribute2, FND_API.g_miss_char, attribute2, x_attribute2),
245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),
246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),
247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),
248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),
249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),
250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),
251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),
252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),

Line 249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),

245: attribute3 = DECODE( x_attribute3, FND_API.g_miss_char, attribute3, x_attribute3),
246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),
247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),
248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),
249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),
250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),
251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),
252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),
253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),

Line 250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),

246: attribute4 = DECODE( x_attribute4, FND_API.g_miss_char, attribute4, x_attribute4),
247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),
248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),
249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),
250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),
251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),
252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),
253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),
254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),

Line 251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),

247: attribute5 = DECODE( x_attribute5, FND_API.g_miss_char, attribute5, x_attribute5),
248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),
249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),
250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),
251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),
252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),
253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),
254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),
255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),

Line 252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),

248: attribute6 = DECODE( x_attribute6, FND_API.g_miss_char, attribute6, x_attribute6),
249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),
250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),
251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),
252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),
253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),
254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),
255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),
256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),

Line 253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),

249: attribute7 = DECODE( x_attribute7, FND_API.g_miss_char, attribute7, x_attribute7),
250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),
251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),
252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),
253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),
254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),
255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),
256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),
257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),

Line 254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),

250: attribute8 = DECODE( x_attribute8, FND_API.g_miss_char, attribute8, x_attribute8),
251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),
252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),
253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),
254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),
255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),
256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),
257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),
258: security_group_id = DECODE( x_security_group_id, FND_API.g_miss_num, security_group_id, x_security_group_id),

Line 255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),

251: attribute9 = DECODE( x_attribute9, FND_API.g_miss_char, attribute9, x_attribute9),
252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),
253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),
254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),
255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),
256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),
257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),
258: security_group_id = DECODE( x_security_group_id, FND_API.g_miss_num, security_group_id, x_security_group_id),
259: object_version_number = DECODE( x_object_version_number, FND_API.g_miss_num, object_version_number, x_object_version_number)

Line 256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),

252: attribute10 = DECODE( x_attribute10, FND_API.g_miss_char, attribute10, x_attribute10),
253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),
254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),
255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),
256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),
257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),
258: security_group_id = DECODE( x_security_group_id, FND_API.g_miss_num, security_group_id, x_security_group_id),
259: object_version_number = DECODE( x_object_version_number, FND_API.g_miss_num, object_version_number, x_object_version_number)
260: ---process_objective_id = DECODE( x_process_objective_id, FND_API.g_miss_num, process_objective_id, x_process_objective_id)

Line 257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),

253: attribute11 = DECODE( x_attribute11, FND_API.g_miss_char, attribute11, x_attribute11),
254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),
255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),
256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),
257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),
258: security_group_id = DECODE( x_security_group_id, FND_API.g_miss_num, security_group_id, x_security_group_id),
259: object_version_number = DECODE( x_object_version_number, FND_API.g_miss_num, object_version_number, x_object_version_number)
260: ---process_objective_id = DECODE( x_process_objective_id, FND_API.g_miss_num, process_objective_id, x_process_objective_id)
261: WHERE PROCESS_OBJECTIVE_ID = x_PROCESS_OBJECTIVE_ID;

Line 258: security_group_id = DECODE( x_security_group_id, FND_API.g_miss_num, security_group_id, x_security_group_id),

254: attribute12 = DECODE( x_attribute12, FND_API.g_miss_char, attribute12, x_attribute12),
255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),
256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),
257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),
258: security_group_id = DECODE( x_security_group_id, FND_API.g_miss_num, security_group_id, x_security_group_id),
259: object_version_number = DECODE( x_object_version_number, FND_API.g_miss_num, object_version_number, x_object_version_number)
260: ---process_objective_id = DECODE( x_process_objective_id, FND_API.g_miss_num, process_objective_id, x_process_objective_id)
261: WHERE PROCESS_OBJECTIVE_ID = x_PROCESS_OBJECTIVE_ID;
262: ---AND object_version_number = x_object_version_number;

Line 259: object_version_number = DECODE( x_object_version_number, FND_API.g_miss_num, object_version_number, x_object_version_number)

255: attribute13 = DECODE( x_attribute13, FND_API.g_miss_char, attribute13, x_attribute13),
256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),
257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),
258: security_group_id = DECODE( x_security_group_id, FND_API.g_miss_num, security_group_id, x_security_group_id),
259: object_version_number = DECODE( x_object_version_number, FND_API.g_miss_num, object_version_number, x_object_version_number)
260: ---process_objective_id = DECODE( x_process_objective_id, FND_API.g_miss_num, process_objective_id, x_process_objective_id)
261: WHERE PROCESS_OBJECTIVE_ID = x_PROCESS_OBJECTIVE_ID;
262: ---AND object_version_number = x_object_version_number;
263:

Line 260: ---process_objective_id = DECODE( x_process_objective_id, FND_API.g_miss_num, process_objective_id, x_process_objective_id)

256: attribute14 = DECODE( x_attribute14, FND_API.g_miss_char, attribute14, x_attribute14),
257: attribute15 = DECODE( x_attribute15, FND_API.g_miss_char, attribute15, x_attribute15),
258: security_group_id = DECODE( x_security_group_id, FND_API.g_miss_num, security_group_id, x_security_group_id),
259: object_version_number = DECODE( x_object_version_number, FND_API.g_miss_num, object_version_number, x_object_version_number)
260: ---process_objective_id = DECODE( x_process_objective_id, FND_API.g_miss_num, process_objective_id, x_process_objective_id)
261: WHERE PROCESS_OBJECTIVE_ID = x_PROCESS_OBJECTIVE_ID;
262: ---AND object_version_number = x_object_version_number;
263:
264: IF (SQL%NOTFOUND) THEN

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261: WHERE PROCESS_OBJECTIVE_ID = x_PROCESS_OBJECTIVE_ID;
262: ---AND object_version_number = x_object_version_number;
263:
264: IF (SQL%NOTFOUND) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: update AMW_PROCESS_OBJECTIVEs_TL set
269: NAME = X_NAME,

Line 279: raise FND_API.G_EXC_UNEXPECTED_ERROR;

275: where PROCESS_OBJECTIVE_ID = x_PROCESS_OBJECTIVE_ID
276: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
277:
278: if (sql%notfound) then
279: raise FND_API.G_EXC_UNEXPECTED_ERROR;
280: end if;
281: END Update_Row;
282:
283:

Line 308: raise FND_API.G_EXC_UNEXPECTED_ERROR;

304: delete from AMW_process_objectives_TL
305: where process_objective_ID = X_process_objective_ID;
306:
307: if (sql%notfound) then
308: raise FND_API.G_EXC_UNEXPECTED_ERROR;
309: end if;
310:
311: DELETE FROM AMW_PROCESS_OBJECTIVES_B
312: WHERE PROCESS_OBJECTIVE_ID = x_PROCESS_OBJECTIVE_ID;

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310:
311: DELETE FROM AMW_PROCESS_OBJECTIVES_B
312: WHERE PROCESS_OBJECTIVE_ID = x_PROCESS_OBJECTIVE_ID;
313: If (SQL%NOTFOUND) then
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: End If;
316: END Delete_Row ;
317:
318:

Line 600: p_commit in varchar2 := FND_API.G_FALSE,

596:
597: procedure delete_proc_obj (
598: p_object_type varchar2,
599: p_pk1 number,
600: p_commit in varchar2 := FND_API.G_FALSE,
601: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
603: x_return_status out nocopy varchar2,
604: x_msg_count out nocopy number,

Line 601: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

597: procedure delete_proc_obj (
598: p_object_type varchar2,
599: p_pk1 number,
600: p_commit in varchar2 := FND_API.G_FALSE,
601: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
603: x_return_status out nocopy varchar2,
604: x_msg_count out nocopy number,
605: x_msg_data out nocopy varchar2

Line 602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

598: p_object_type varchar2,
599: p_pk1 number,
600: p_commit in varchar2 := FND_API.G_FALSE,
601: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
602: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
603: x_return_status out nocopy varchar2,
604: x_msg_count out nocopy number,
605: x_msg_data out nocopy varchar2
606: ) is

Line 611: x_return_status := FND_API.G_RET_STS_SUCCESS;

607:
608: L_API_NAME CONSTANT VARCHAR2(30) := 'delete_proc_obj';
609:
610: begin
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612: IF FND_API.to_Boolean( p_init_msg_list ) THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615: IF FND_GLOBAL.User_Id IS NULL THEN

Line 612: IF FND_API.to_Boolean( p_init_msg_list ) THEN

608: L_API_NAME CONSTANT VARCHAR2(30) := 'delete_proc_obj';
609:
610: begin
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612: IF FND_API.to_Boolean( p_init_msg_list ) THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615: IF FND_GLOBAL.User_Id IS NULL THEN
616: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 617: RAISE FND_API.G_EXC_ERROR;

613: FND_MSG_PUB.initialize;
614: END IF;
615: IF FND_GLOBAL.User_Id IS NULL THEN
616: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: delete from amw_objective_associations where object_type = p_object_type and pk1 = p_pk1;
621:

Line 623: WHEN FND_API.G_EXC_ERROR THEN

619:
620: delete from amw_objective_associations where object_type = p_object_type and pk1 = p_pk1;
621:
622: exception
623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
627:

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

621:
622: exception
623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK;

Line 626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

622: exception
623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

624: ROLLBACK;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
632:

Line 630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
632:
633: WHEN OTHERS THEN
634: ROLLBACK;

Line 631: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
632:
633: WHEN OTHERS THEN
634: ROLLBACK;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

631: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
632:
633: WHEN OTHERS THEN
634: ROLLBACK;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
637: THEN
638: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
639: END IF;

Line 640: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

636: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
637: THEN
638: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
639: END IF;
640: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
641:
642: end delete_proc_obj;
643:
644: