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

Line 67: IF (px_system_id IS NULL) OR (px_system_id = fnd_api.g_miss_num) THEN

63:
64: is
65: CURSOR c2 IS SELECT csi_systems_s.NEXTVAL FROM sys.dual;
66: BEGIN
67: IF (px_system_id IS NULL) OR (px_system_id = fnd_api.g_miss_num) THEN
68: OPEN c2;
69: FETCH c2 INTO px_system_id;
70: CLOSE c2;
71: END IF;

Line 119: decode( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),

115: program_id,
116: program_update_date
117: ) VALUES (
118: px_system_id,
119: decode( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
120: decode( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
121: decode( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),
123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),

Line 120: decode( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),

116: program_update_date
117: ) VALUES (
118: px_system_id,
119: decode( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
120: decode( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
121: decode( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),
123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),

Line 121: decode( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),

117: ) VALUES (
118: px_system_id,
119: decode( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
120: decode( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
121: decode( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),
123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),

Line 122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),

118: px_system_id,
119: decode( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
120: decode( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
121: decode( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),
123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),

Line 123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),

119: decode( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
120: decode( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
121: decode( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),
123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),

Line 124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),

120: decode( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
121: decode( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),
123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),

Line 125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),

121: decode( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),
123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),

Line 126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),

122: decode( p_parent_system_id, fnd_api.g_miss_num, NULL, p_parent_system_id),
123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),

Line 127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),

123: decode( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),

Line 128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),

124: decode( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),
132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),

Line 129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),

125: decode( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),
132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),

Line 130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),

126: decode( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),
132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),
134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),

Line 131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),

127: decode( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),
132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),
134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),
135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),

Line 132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),

128: decode( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),
132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),
134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),
135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),

Line 133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),

129: decode( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),
132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),
134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),
135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),

Line 134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),

130: decode( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),
132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),
134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),
135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),

Line 135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),

131: decode( p_autocreated_from_system_id,fnd_api.g_miss_num, NULL, p_autocreated_from_system_id),
132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),
134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),
135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),

Line 136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),

132: decode( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),
134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),
135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),

Line 137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),

133: decode( p_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_start_date_active),
134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),
135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),

Line 138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),

134: decode( p_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_end_date_active),
135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),

Line 139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),

135: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),

Line 140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),

136: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),

Line 141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),

137: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),

Line 142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),

138: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),

Line 143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),

139: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),

Line 144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),

140: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),

Line 145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),

141: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),

Line 146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),

142: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),

Line 147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),

143: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

Line 148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),

144: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

Line 149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),

145: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

Line 150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),

146: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

Line 151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

147: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

Line 152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

148: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),

Line 153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

149: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),

Line 154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

150: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),
158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),

Line 155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

151: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),
158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
159: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),

Line 156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),

152: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),
158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
159: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
160: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),

Line 157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),

153: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),
158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
159: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
160: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
161: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date)

Line 158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),

154: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),
158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
159: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
160: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
161: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date)
162: );

Line 159: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),

155: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),
158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
159: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
160: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
161: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date)
162: );
163:

Line 160: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),

156: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),
158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
159: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
160: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
161: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date)
162: );
163:
164: INSERT INTO csi_systems_tl(

Line 161: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date)

157: decode( p_operating_unit_id, fnd_api.g_miss_num, NULL, p_operating_unit_id),
158: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
159: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
160: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
161: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date)
162: );
163:
164: INSERT INTO csi_systems_tl(
165: system_id ,

Line 180: decode( p_name, fnd_api.g_miss_char, NULL, p_name),

176: SELECT
177: px_system_id,
178: L.language_code,
179: userenv('LANG'),
180: decode( p_name, fnd_api.g_miss_char, NULL, p_name),
181: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
182: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
183: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
184: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

Line 181: decode( p_description, fnd_api.g_miss_char, NULL, p_description),

177: px_system_id,
178: L.language_code,
179: userenv('LANG'),
180: decode( p_name, fnd_api.g_miss_char, NULL, p_name),
181: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
182: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
183: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
184: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
185: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

Line 182: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

178: L.language_code,
179: userenv('LANG'),
180: decode( p_name, fnd_api.g_miss_char, NULL, p_name),
181: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
182: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
183: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
184: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
185: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
186: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)

Line 183: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

179: userenv('LANG'),
180: decode( p_name, fnd_api.g_miss_char, NULL, p_name),
181: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
182: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
183: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
184: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
185: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
186: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
187: FROM fnd_languages L

Line 184: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

180: decode( p_name, fnd_api.g_miss_char, NULL, p_name),
181: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
182: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
183: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
184: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
185: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
186: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
187: FROM fnd_languages L
188: WHERE L.installed_flag IN ('I','B')

Line 185: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

181: decode( p_description, fnd_api.g_miss_char, NULL, p_description),
182: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
183: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
184: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
185: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
186: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
187: FROM fnd_languages L
188: WHERE L.installed_flag IN ('I','B')
189: AND NOT EXISTS

Line 186: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)

182: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
183: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
184: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
185: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
186: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
187: FROM fnd_languages L
188: WHERE L.installed_flag IN ('I','B')
189: AND NOT EXISTS
190: (SELECT NULL

Line 198: p_system_id NUMBER := fnd_api.g_miss_num ,

194:
195: END insert_row;
196:
197: PROCEDURE update_row(
198: p_system_id NUMBER := fnd_api.g_miss_num ,
199: p_customer_id NUMBER := fnd_api.g_miss_num ,
200: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
201: p_system_number VARCHAR2 := fnd_api.g_miss_char,
202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,

Line 199: p_customer_id NUMBER := fnd_api.g_miss_num ,

195: END insert_row;
196:
197: PROCEDURE update_row(
198: p_system_id NUMBER := fnd_api.g_miss_num ,
199: p_customer_id NUMBER := fnd_api.g_miss_num ,
200: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
201: p_system_number VARCHAR2 := fnd_api.g_miss_char,
202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,

Line 200: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,

196:
197: PROCEDURE update_row(
198: p_system_id NUMBER := fnd_api.g_miss_num ,
199: p_customer_id NUMBER := fnd_api.g_miss_num ,
200: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
201: p_system_number VARCHAR2 := fnd_api.g_miss_char,
202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,

Line 201: p_system_number VARCHAR2 := fnd_api.g_miss_char,

197: PROCEDURE update_row(
198: p_system_id NUMBER := fnd_api.g_miss_num ,
199: p_customer_id NUMBER := fnd_api.g_miss_num ,
200: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
201: p_system_number VARCHAR2 := fnd_api.g_miss_char,
202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,

Line 202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,

198: p_system_id NUMBER := fnd_api.g_miss_num ,
199: p_customer_id NUMBER := fnd_api.g_miss_num ,
200: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
201: p_system_number VARCHAR2 := fnd_api.g_miss_char,
202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,

Line 203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,

199: p_customer_id NUMBER := fnd_api.g_miss_num ,
200: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
201: p_system_number VARCHAR2 := fnd_api.g_miss_char,
202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,

Line 204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,

200: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
201: p_system_number VARCHAR2 := fnd_api.g_miss_char,
202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,

Line 205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,

201: p_system_number VARCHAR2 := fnd_api.g_miss_char,
202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,

Line 206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,

202: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,

Line 207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,

203: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,

Line 208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,

204: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,

Line 209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,

205: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
213: p_start_date_active DATE := fnd_api.g_miss_date,

Line 210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,

206: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
213: p_start_date_active DATE := fnd_api.g_miss_date,
214: p_end_date_active DATE := fnd_api.g_miss_date,

Line 211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,

207: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
213: p_start_date_active DATE := fnd_api.g_miss_date,
214: p_end_date_active DATE := fnd_api.g_miss_date,
215: p_context VARCHAR2 := fnd_api.g_miss_char,

Line 212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,

208: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
213: p_start_date_active DATE := fnd_api.g_miss_date,
214: p_end_date_active DATE := fnd_api.g_miss_date,
215: p_context VARCHAR2 := fnd_api.g_miss_char,
216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,

Line 213: p_start_date_active DATE := fnd_api.g_miss_date,

209: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
213: p_start_date_active DATE := fnd_api.g_miss_date,
214: p_end_date_active DATE := fnd_api.g_miss_date,
215: p_context VARCHAR2 := fnd_api.g_miss_char,
216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,

Line 214: p_end_date_active DATE := fnd_api.g_miss_date,

210: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
213: p_start_date_active DATE := fnd_api.g_miss_date,
214: p_end_date_active DATE := fnd_api.g_miss_date,
215: p_context VARCHAR2 := fnd_api.g_miss_char,
216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,

Line 215: p_context VARCHAR2 := fnd_api.g_miss_char,

211: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
213: p_start_date_active DATE := fnd_api.g_miss_date,
214: p_end_date_active DATE := fnd_api.g_miss_date,
215: p_context VARCHAR2 := fnd_api.g_miss_char,
216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,

Line 216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,

212: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
213: p_start_date_active DATE := fnd_api.g_miss_date,
214: p_end_date_active DATE := fnd_api.g_miss_date,
215: p_context VARCHAR2 := fnd_api.g_miss_char,
216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,

Line 217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,

213: p_start_date_active DATE := fnd_api.g_miss_date,
214: p_end_date_active DATE := fnd_api.g_miss_date,
215: p_context VARCHAR2 := fnd_api.g_miss_char,
216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,

Line 218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,

214: p_end_date_active DATE := fnd_api.g_miss_date,
215: p_context VARCHAR2 := fnd_api.g_miss_char,
216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,

Line 219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,

215: p_context VARCHAR2 := fnd_api.g_miss_char,
216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,

Line 220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,

216: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,

Line 221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,

217: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,

Line 222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,

218: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,

Line 223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,

219: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,

Line 224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,

220: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,

Line 225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,

221: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,

Line 226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,

222: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,

Line 227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,

223: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
231: p_created_by NUMBER := fnd_api.g_miss_num ,

Line 228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,

224: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
231: p_created_by NUMBER := fnd_api.g_miss_num ,
232: p_creation_date DATE := fnd_api.g_miss_date,

Line 229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,

225: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
231: p_created_by NUMBER := fnd_api.g_miss_num ,
232: p_creation_date DATE := fnd_api.g_miss_date,
233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,

Line 230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,

226: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
231: p_created_by NUMBER := fnd_api.g_miss_num ,
232: p_creation_date DATE := fnd_api.g_miss_date,
233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
234: p_last_update_date DATE := fnd_api.g_miss_date,

Line 231: p_created_by NUMBER := fnd_api.g_miss_num ,

227: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
231: p_created_by NUMBER := fnd_api.g_miss_num ,
232: p_creation_date DATE := fnd_api.g_miss_date,
233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
234: p_last_update_date DATE := fnd_api.g_miss_date,
235: p_last_update_login NUMBER := fnd_api.g_miss_num ,

Line 232: p_creation_date DATE := fnd_api.g_miss_date,

228: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
231: p_created_by NUMBER := fnd_api.g_miss_num ,
232: p_creation_date DATE := fnd_api.g_miss_date,
233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
234: p_last_update_date DATE := fnd_api.g_miss_date,
235: p_last_update_login NUMBER := fnd_api.g_miss_num ,
236: p_object_version_number NUMBER := fnd_api.g_miss_num ,

Line 233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,

229: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
231: p_created_by NUMBER := fnd_api.g_miss_num ,
232: p_creation_date DATE := fnd_api.g_miss_date,
233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
234: p_last_update_date DATE := fnd_api.g_miss_date,
235: p_last_update_login NUMBER := fnd_api.g_miss_num ,
236: p_object_version_number NUMBER := fnd_api.g_miss_num ,
237: p_name VARCHAR2 := fnd_api.g_miss_char,

Line 234: p_last_update_date DATE := fnd_api.g_miss_date,

230: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
231: p_created_by NUMBER := fnd_api.g_miss_num ,
232: p_creation_date DATE := fnd_api.g_miss_date,
233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
234: p_last_update_date DATE := fnd_api.g_miss_date,
235: p_last_update_login NUMBER := fnd_api.g_miss_num ,
236: p_object_version_number NUMBER := fnd_api.g_miss_num ,
237: p_name VARCHAR2 := fnd_api.g_miss_char,
238: p_description VARCHAR2 := fnd_api.g_miss_char,

Line 235: p_last_update_login NUMBER := fnd_api.g_miss_num ,

231: p_created_by NUMBER := fnd_api.g_miss_num ,
232: p_creation_date DATE := fnd_api.g_miss_date,
233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
234: p_last_update_date DATE := fnd_api.g_miss_date,
235: p_last_update_login NUMBER := fnd_api.g_miss_num ,
236: p_object_version_number NUMBER := fnd_api.g_miss_num ,
237: p_name VARCHAR2 := fnd_api.g_miss_char,
238: p_description VARCHAR2 := fnd_api.g_miss_char,
239: p_operating_unit_id NUMBER := fnd_api.g_miss_num,

Line 236: p_object_version_number NUMBER := fnd_api.g_miss_num ,

232: p_creation_date DATE := fnd_api.g_miss_date,
233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
234: p_last_update_date DATE := fnd_api.g_miss_date,
235: p_last_update_login NUMBER := fnd_api.g_miss_num ,
236: p_object_version_number NUMBER := fnd_api.g_miss_num ,
237: p_name VARCHAR2 := fnd_api.g_miss_char,
238: p_description VARCHAR2 := fnd_api.g_miss_char,
239: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
240: p_request_id NUMBER ,

Line 237: p_name VARCHAR2 := fnd_api.g_miss_char,

233: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
234: p_last_update_date DATE := fnd_api.g_miss_date,
235: p_last_update_login NUMBER := fnd_api.g_miss_num ,
236: p_object_version_number NUMBER := fnd_api.g_miss_num ,
237: p_name VARCHAR2 := fnd_api.g_miss_char,
238: p_description VARCHAR2 := fnd_api.g_miss_char,
239: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
240: p_request_id NUMBER ,
241: p_program_application_id NUMBER ,

Line 238: p_description VARCHAR2 := fnd_api.g_miss_char,

234: p_last_update_date DATE := fnd_api.g_miss_date,
235: p_last_update_login NUMBER := fnd_api.g_miss_num ,
236: p_object_version_number NUMBER := fnd_api.g_miss_num ,
237: p_name VARCHAR2 := fnd_api.g_miss_char,
238: p_description VARCHAR2 := fnd_api.g_miss_char,
239: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
240: p_request_id NUMBER ,
241: p_program_application_id NUMBER ,
242: p_program_id NUMBER ,

Line 239: p_operating_unit_id NUMBER := fnd_api.g_miss_num,

235: p_last_update_login NUMBER := fnd_api.g_miss_num ,
236: p_object_version_number NUMBER := fnd_api.g_miss_num ,
237: p_name VARCHAR2 := fnd_api.g_miss_char,
238: p_description VARCHAR2 := fnd_api.g_miss_char,
239: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
240: p_request_id NUMBER ,
241: p_program_application_id NUMBER ,
242: p_program_id NUMBER ,
243: p_program_update_date DATE )

Line 248: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),

244: IS
245: BEGIN
246: update csi_systems_b
247: set
248: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
249: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
250: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),

Line 249: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),

245: BEGIN
246: update csi_systems_b
247: set
248: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
249: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
250: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),

Line 250: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),

246: update csi_systems_b
247: set
248: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
249: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
250: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),

Line 251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),

247: set
248: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
249: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
250: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),

Line 252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),

248: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
249: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
250: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),

Line 253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),

249: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
250: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),
257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),

Line 254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),

250: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),
257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),
258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),

Line 255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),

251: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),
257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),
258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),

Line 256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),

252: ship_to_contact_id = decode( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),
257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),
258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),

Line 257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),

253: bill_to_contact_id = decode( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),
257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),
258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),

Line 258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),

254: technical_contact_id = decode( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),
257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),
258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),

Line 259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),

255: service_admin_contact_id = decode( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),
257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),
258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),

Line 260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),

256: ship_to_site_use_id = decode( p_ship_to_site_use_id, fnd_api.g_miss_num, ship_to_site_use_id, p_ship_to_site_use_id),
257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),
258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

Line 261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),

257: bill_to_site_use_id = decode( p_bill_to_site_use_id, fnd_api.g_miss_num, bill_to_site_use_id, p_bill_to_site_use_id),
258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

Line 262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),

258: install_site_use_id = decode( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

Line 263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),

259: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

Line 264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

260: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

Line 265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

261: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

Line 266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

262: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

Line 267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

263: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

Line 268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

264: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

Line 269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

265: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

Line 270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

266: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

Line 271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

267: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

Line 272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

268: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

Line 273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

269: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

Line 274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

270: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

Line 275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

271: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

Line 276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

272: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

273: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

Line 278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

274: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

Line 279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

275: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

Line 280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

276: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

Line 281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

277: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
285: object_version_number = object_version_number+1,

Line 282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

278: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
285: object_version_number = object_version_number+1,
286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),

Line 283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

279: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
285: object_version_number = object_version_number+1,
286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
287: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),

Line 284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

280: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
285: object_version_number = object_version_number+1,
286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
287: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
288: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),

Line 286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),

282: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
285: object_version_number = object_version_number+1,
286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
287: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
288: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
289: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
290: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)

Line 287: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),

283: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
285: object_version_number = object_version_number+1,
286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
287: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
288: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
289: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
290: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
291: WHERE system_id = p_system_id;

Line 288: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),

284: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
285: object_version_number = object_version_number+1,
286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
287: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
288: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
289: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
290: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
291: WHERE system_id = p_system_id;
292:

Line 289: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),

285: object_version_number = object_version_number+1,
286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
287: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
288: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
289: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
290: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
291: WHERE system_id = p_system_id;
292:
293: UPDATE csi_systems_tl

Line 290: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)

286: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
287: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
288: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
289: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
290: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
291: WHERE system_id = p_system_id;
292:
293: UPDATE csi_systems_tl
294: SET source_lang = userenv('LANG'),

Line 295: name = decode( p_name, fnd_api.g_miss_char, name, p_name),

291: WHERE system_id = p_system_id;
292:
293: UPDATE csi_systems_tl
294: SET source_lang = userenv('LANG'),
295: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
296: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
298: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
299: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

Line 296: description = decode( p_description, fnd_api.g_miss_char, description, p_description),

292:
293: UPDATE csi_systems_tl
294: SET source_lang = userenv('LANG'),
295: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
296: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
298: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
299: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
300: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

Line 297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

293: UPDATE csi_systems_tl
294: SET source_lang = userenv('LANG'),
295: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
296: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
298: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
299: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
300: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
301: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)

Line 298: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

294: SET source_lang = userenv('LANG'),
295: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
296: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
298: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
299: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
300: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
301: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)
302: WHERE system_id = p_system_id

Line 299: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

295: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
296: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
298: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
299: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
300: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
301: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)
302: WHERE system_id = p_system_id
303: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);

Line 300: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

296: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
298: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
299: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
300: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
301: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)
302: WHERE system_id = p_system_id
303: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);
304:

Line 301: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)

297: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
298: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
299: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
300: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
301: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)
302: WHERE system_id = p_system_id
303: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);
304:
305: IF (SQL%NOTFOUND) THEN

Line 312: p_system_id NUMBER := fnd_api.g_miss_num ,

308: END update_row;
309:
310:
311: PROCEDURE update_row_for_mu(
312: p_system_id NUMBER := fnd_api.g_miss_num ,
313: p_customer_id NUMBER := fnd_api.g_miss_num ,
314: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
315: p_system_number VARCHAR2 := fnd_api.g_miss_char,
316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,

Line 313: p_customer_id NUMBER := fnd_api.g_miss_num ,

309:
310:
311: PROCEDURE update_row_for_mu(
312: p_system_id NUMBER := fnd_api.g_miss_num ,
313: p_customer_id NUMBER := fnd_api.g_miss_num ,
314: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
315: p_system_number VARCHAR2 := fnd_api.g_miss_char,
316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,

Line 314: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,

310:
311: PROCEDURE update_row_for_mu(
312: p_system_id NUMBER := fnd_api.g_miss_num ,
313: p_customer_id NUMBER := fnd_api.g_miss_num ,
314: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
315: p_system_number VARCHAR2 := fnd_api.g_miss_char,
316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,

Line 315: p_system_number VARCHAR2 := fnd_api.g_miss_char,

311: PROCEDURE update_row_for_mu(
312: p_system_id NUMBER := fnd_api.g_miss_num ,
313: p_customer_id NUMBER := fnd_api.g_miss_num ,
314: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
315: p_system_number VARCHAR2 := fnd_api.g_miss_char,
316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,

Line 316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,

312: p_system_id NUMBER := fnd_api.g_miss_num ,
313: p_customer_id NUMBER := fnd_api.g_miss_num ,
314: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
315: p_system_number VARCHAR2 := fnd_api.g_miss_char,
316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,

Line 317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,

313: p_customer_id NUMBER := fnd_api.g_miss_num ,
314: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
315: p_system_number VARCHAR2 := fnd_api.g_miss_char,
316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,

Line 318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,

314: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
315: p_system_number VARCHAR2 := fnd_api.g_miss_char,
316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,

Line 319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,

315: p_system_number VARCHAR2 := fnd_api.g_miss_char,
316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,

Line 320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,

316: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,

Line 321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,

317: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,

Line 322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,

318: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,

Line 323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,

319: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
327: p_start_date_active DATE := fnd_api.g_miss_date,

Line 324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,

320: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
327: p_start_date_active DATE := fnd_api.g_miss_date,
328: p_end_date_active DATE := fnd_api.g_miss_date,

Line 325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,

321: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
327: p_start_date_active DATE := fnd_api.g_miss_date,
328: p_end_date_active DATE := fnd_api.g_miss_date,
329: p_context VARCHAR2 := fnd_api.g_miss_char,

Line 326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,

322: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
327: p_start_date_active DATE := fnd_api.g_miss_date,
328: p_end_date_active DATE := fnd_api.g_miss_date,
329: p_context VARCHAR2 := fnd_api.g_miss_char,
330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,

Line 327: p_start_date_active DATE := fnd_api.g_miss_date,

323: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
327: p_start_date_active DATE := fnd_api.g_miss_date,
328: p_end_date_active DATE := fnd_api.g_miss_date,
329: p_context VARCHAR2 := fnd_api.g_miss_char,
330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,

Line 328: p_end_date_active DATE := fnd_api.g_miss_date,

324: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
327: p_start_date_active DATE := fnd_api.g_miss_date,
328: p_end_date_active DATE := fnd_api.g_miss_date,
329: p_context VARCHAR2 := fnd_api.g_miss_char,
330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,

Line 329: p_context VARCHAR2 := fnd_api.g_miss_char,

325: p_autocreated_from_system_id NUMBER := fnd_api.g_miss_num ,
326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
327: p_start_date_active DATE := fnd_api.g_miss_date,
328: p_end_date_active DATE := fnd_api.g_miss_date,
329: p_context VARCHAR2 := fnd_api.g_miss_char,
330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,

Line 330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,

326: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
327: p_start_date_active DATE := fnd_api.g_miss_date,
328: p_end_date_active DATE := fnd_api.g_miss_date,
329: p_context VARCHAR2 := fnd_api.g_miss_char,
330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,

Line 331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,

327: p_start_date_active DATE := fnd_api.g_miss_date,
328: p_end_date_active DATE := fnd_api.g_miss_date,
329: p_context VARCHAR2 := fnd_api.g_miss_char,
330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,

Line 332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,

328: p_end_date_active DATE := fnd_api.g_miss_date,
329: p_context VARCHAR2 := fnd_api.g_miss_char,
330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,

Line 333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,

329: p_context VARCHAR2 := fnd_api.g_miss_char,
330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,

Line 334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,

330: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,

Line 335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,

331: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,

Line 336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,

332: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,

Line 337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,

333: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,

Line 338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,

334: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,

Line 339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,

335: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,

Line 340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,

336: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,

Line 341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,

337: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
345: p_created_by NUMBER := fnd_api.g_miss_num ,

Line 342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,

338: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
345: p_created_by NUMBER := fnd_api.g_miss_num ,
346: p_creation_date DATE := fnd_api.g_miss_date,

Line 343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,

339: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
345: p_created_by NUMBER := fnd_api.g_miss_num ,
346: p_creation_date DATE := fnd_api.g_miss_date,
347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,

Line 344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,

340: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
345: p_created_by NUMBER := fnd_api.g_miss_num ,
346: p_creation_date DATE := fnd_api.g_miss_date,
347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
348: p_last_update_date DATE := fnd_api.g_miss_date,

Line 345: p_created_by NUMBER := fnd_api.g_miss_num ,

341: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
345: p_created_by NUMBER := fnd_api.g_miss_num ,
346: p_creation_date DATE := fnd_api.g_miss_date,
347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
348: p_last_update_date DATE := fnd_api.g_miss_date,
349: p_last_update_login NUMBER := fnd_api.g_miss_num ,

Line 346: p_creation_date DATE := fnd_api.g_miss_date,

342: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
345: p_created_by NUMBER := fnd_api.g_miss_num ,
346: p_creation_date DATE := fnd_api.g_miss_date,
347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
348: p_last_update_date DATE := fnd_api.g_miss_date,
349: p_last_update_login NUMBER := fnd_api.g_miss_num ,
350: p_object_version_number NUMBER := fnd_api.g_miss_num ,

Line 347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,

343: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
345: p_created_by NUMBER := fnd_api.g_miss_num ,
346: p_creation_date DATE := fnd_api.g_miss_date,
347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
348: p_last_update_date DATE := fnd_api.g_miss_date,
349: p_last_update_login NUMBER := fnd_api.g_miss_num ,
350: p_object_version_number NUMBER := fnd_api.g_miss_num ,
351: p_name VARCHAR2 := fnd_api.g_miss_char,

Line 348: p_last_update_date DATE := fnd_api.g_miss_date,

344: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
345: p_created_by NUMBER := fnd_api.g_miss_num ,
346: p_creation_date DATE := fnd_api.g_miss_date,
347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
348: p_last_update_date DATE := fnd_api.g_miss_date,
349: p_last_update_login NUMBER := fnd_api.g_miss_num ,
350: p_object_version_number NUMBER := fnd_api.g_miss_num ,
351: p_name VARCHAR2 := fnd_api.g_miss_char,
352: p_description VARCHAR2 := fnd_api.g_miss_char,

Line 349: p_last_update_login NUMBER := fnd_api.g_miss_num ,

345: p_created_by NUMBER := fnd_api.g_miss_num ,
346: p_creation_date DATE := fnd_api.g_miss_date,
347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
348: p_last_update_date DATE := fnd_api.g_miss_date,
349: p_last_update_login NUMBER := fnd_api.g_miss_num ,
350: p_object_version_number NUMBER := fnd_api.g_miss_num ,
351: p_name VARCHAR2 := fnd_api.g_miss_char,
352: p_description VARCHAR2 := fnd_api.g_miss_char,
353: p_operating_unit_id NUMBER := fnd_api.g_miss_num,

Line 350: p_object_version_number NUMBER := fnd_api.g_miss_num ,

346: p_creation_date DATE := fnd_api.g_miss_date,
347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
348: p_last_update_date DATE := fnd_api.g_miss_date,
349: p_last_update_login NUMBER := fnd_api.g_miss_num ,
350: p_object_version_number NUMBER := fnd_api.g_miss_num ,
351: p_name VARCHAR2 := fnd_api.g_miss_char,
352: p_description VARCHAR2 := fnd_api.g_miss_char,
353: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
354: p_request_id NUMBER ,

Line 351: p_name VARCHAR2 := fnd_api.g_miss_char,

347: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
348: p_last_update_date DATE := fnd_api.g_miss_date,
349: p_last_update_login NUMBER := fnd_api.g_miss_num ,
350: p_object_version_number NUMBER := fnd_api.g_miss_num ,
351: p_name VARCHAR2 := fnd_api.g_miss_char,
352: p_description VARCHAR2 := fnd_api.g_miss_char,
353: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
354: p_request_id NUMBER ,
355: p_program_application_id NUMBER ,

Line 352: p_description VARCHAR2 := fnd_api.g_miss_char,

348: p_last_update_date DATE := fnd_api.g_miss_date,
349: p_last_update_login NUMBER := fnd_api.g_miss_num ,
350: p_object_version_number NUMBER := fnd_api.g_miss_num ,
351: p_name VARCHAR2 := fnd_api.g_miss_char,
352: p_description VARCHAR2 := fnd_api.g_miss_char,
353: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
354: p_request_id NUMBER ,
355: p_program_application_id NUMBER ,
356: p_program_id NUMBER ,

Line 353: p_operating_unit_id NUMBER := fnd_api.g_miss_num,

349: p_last_update_login NUMBER := fnd_api.g_miss_num ,
350: p_object_version_number NUMBER := fnd_api.g_miss_num ,
351: p_name VARCHAR2 := fnd_api.g_miss_char,
352: p_description VARCHAR2 := fnd_api.g_miss_char,
353: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
354: p_request_id NUMBER ,
355: p_program_application_id NUMBER ,
356: p_program_id NUMBER ,
357: p_program_update_date DATE )

Line 362: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),

358: IS
359: BEGIN
360: update csi_systems_b
361: set
362: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
363: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
364: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
365: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
366: ship_to_contact_id = null,

Line 363: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),

359: BEGIN
360: update csi_systems_b
361: set
362: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
363: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
364: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
365: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
366: ship_to_contact_id = null,
367: bill_to_contact_id = null,

Line 364: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),

360: update csi_systems_b
361: set
362: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
363: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
364: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
365: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
366: ship_to_contact_id = null,
367: bill_to_contact_id = null,
368: technical_contact_id = null,

Line 365: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),

361: set
362: customer_id = decode( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
363: system_type_code = decode( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
364: system_number = decode( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
365: parent_system_id = decode( p_parent_system_id, fnd_api.g_miss_num, parent_system_id, p_parent_system_id),
366: ship_to_contact_id = null,
367: bill_to_contact_id = null,
368: technical_contact_id = null,
369: service_admin_contact_id = null,

Line 373: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),

369: service_admin_contact_id = null,
370: ship_to_site_use_id = null,
371: bill_to_site_use_id = null,
372: install_site_use_id = null,
373: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
374: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
375: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),

Line 374: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),

370: ship_to_site_use_id = null,
371: bill_to_site_use_id = null,
372: install_site_use_id = null,
373: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
374: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
375: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

Line 375: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),

371: bill_to_site_use_id = null,
372: install_site_use_id = null,
373: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
374: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
375: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

Line 376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),

372: install_site_use_id = null,
373: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
374: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
375: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

Line 377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),

373: coterminate_day_month = decode( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
374: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
375: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

Line 378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

374: autocreated_from_system_id = decode( p_autocreated_from_system_id,fnd_api.g_miss_num, autocreated_from_system_id, p_autocreated_from_system_id),
375: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

Line 379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

375: config_system_type = decode(p_config_system_type,fnd_api.g_miss_char, config_system_type, p_config_system_type),
376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

Line 380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

376: start_date_active = decode( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

Line 381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

377: end_date_active = decode( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

Line 382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

378: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

Line 383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

379: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

Line 384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

380: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

Line 385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

381: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

Line 386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

382: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

Line 387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

383: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

Line 388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

384: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

Line 389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

385: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

Line 390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

386: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

387: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

Line 392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

388: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

Line 393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

389: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

Line 394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

390: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

Line 395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

391: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
399: object_version_number = object_version_number+1,

Line 396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

392: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
399: object_version_number = object_version_number+1,
400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),

Line 397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

393: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
399: object_version_number = object_version_number+1,
400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
401: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),

Line 398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

394: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
395: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
399: object_version_number = object_version_number+1,
400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
401: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
402: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),

Line 400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),

396: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
399: object_version_number = object_version_number+1,
400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
401: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
402: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
403: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
404: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)

Line 401: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),

397: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
399: object_version_number = object_version_number+1,
400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
401: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
402: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
403: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
404: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
405: WHERE system_id = p_system_id;

Line 402: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),

398: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
399: object_version_number = object_version_number+1,
400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
401: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
402: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
403: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
404: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
405: WHERE system_id = p_system_id;
406:

Line 403: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),

399: object_version_number = object_version_number+1,
400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
401: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
402: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
403: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
404: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
405: WHERE system_id = p_system_id;
406:
407: UPDATE csi_systems_tl

Line 404: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)

400: operating_unit_id = decode(p_operating_unit_id,fnd_api.g_miss_num,operating_unit_id,p_operating_unit_id),
401: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
402: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
403: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
404: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date)
405: WHERE system_id = p_system_id;
406:
407: UPDATE csi_systems_tl
408: SET source_lang = userenv('LANG'),

Line 409: name = decode( p_name, fnd_api.g_miss_char, name, p_name),

405: WHERE system_id = p_system_id;
406:
407: UPDATE csi_systems_tl
408: SET source_lang = userenv('LANG'),
409: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
410: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
412: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
413: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

Line 410: description = decode( p_description, fnd_api.g_miss_char, description, p_description),

406:
407: UPDATE csi_systems_tl
408: SET source_lang = userenv('LANG'),
409: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
410: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
412: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
413: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
414: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

Line 411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

407: UPDATE csi_systems_tl
408: SET source_lang = userenv('LANG'),
409: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
410: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
412: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
413: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
414: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
415: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)

Line 412: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

408: SET source_lang = userenv('LANG'),
409: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
410: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
412: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
413: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
414: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
415: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)
416: WHERE system_id = p_system_id

Line 413: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

409: name = decode( p_name, fnd_api.g_miss_char, name, p_name),
410: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
412: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
413: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
414: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
415: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)
416: WHERE system_id = p_system_id
417: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);

Line 414: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

410: description = decode( p_description, fnd_api.g_miss_char, description, p_description),
411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
412: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
413: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
414: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
415: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)
416: WHERE system_id = p_system_id
417: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);
418:

Line 415: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)

411: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
412: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
413: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
414: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
415: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login)
416: WHERE system_id = p_system_id
417: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);
418:
419: IF (SQL%NOTFOUND) THEN