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_T_TXN_SYSTEMS_PKG dependencies on FND_API

Line 59: IF (px_transaction_system_id IS NULL) OR (px_transaction_system_id = fnd_api.g_miss_num) THEN

55:
56: IS
57: CURSOR c2 IS SELECT csi_t_txn_systems_s.nextval FROM sys.dual;
58: BEGIN
59: IF (px_transaction_system_id IS NULL) OR (px_transaction_system_id = fnd_api.g_miss_num) THEN
60: OPEN c2;
61: FETCH c2 INTO px_transaction_system_id;
62: CLOSE c2;
63: END IF;

Line 107: DECODE( p_transaction_line_id, fnd_api.g_miss_num, NULL, p_transaction_line_id),

103: last_update_login,
104: object_version_number
105: ) VALUES (
106: px_transaction_system_id,
107: DECODE( p_transaction_line_id, fnd_api.g_miss_num, NULL, p_transaction_line_id),
108: DECODE( p_system_name, fnd_api.g_miss_char, NULL, p_system_name),
109: DECODE( p_description, fnd_api.g_miss_char, NULL, p_description),
110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),

Line 108: DECODE( p_system_name, fnd_api.g_miss_char, NULL, p_system_name),

104: object_version_number
105: ) VALUES (
106: px_transaction_system_id,
107: DECODE( p_transaction_line_id, fnd_api.g_miss_num, NULL, p_transaction_line_id),
108: DECODE( p_system_name, fnd_api.g_miss_char, NULL, p_system_name),
109: DECODE( p_description, fnd_api.g_miss_char, NULL, p_description),
110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),

Line 109: DECODE( p_description, fnd_api.g_miss_char, NULL, p_description),

105: ) VALUES (
106: px_transaction_system_id,
107: DECODE( p_transaction_line_id, fnd_api.g_miss_num, NULL, p_transaction_line_id),
108: DECODE( p_system_name, fnd_api.g_miss_char, NULL, p_system_name),
109: DECODE( p_description, fnd_api.g_miss_char, NULL, p_description),
110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),

Line 110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),

106: px_transaction_system_id,
107: DECODE( p_transaction_line_id, fnd_api.g_miss_num, NULL, p_transaction_line_id),
108: DECODE( p_system_name, fnd_api.g_miss_char, NULL, p_system_name),
109: DECODE( p_description, fnd_api.g_miss_char, NULL, p_description),
110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),

Line 111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),

107: DECODE( p_transaction_line_id, fnd_api.g_miss_num, NULL, p_transaction_line_id),
108: DECODE( p_system_name, fnd_api.g_miss_char, NULL, p_system_name),
109: DECODE( p_description, fnd_api.g_miss_char, NULL, p_description),
110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),

Line 112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),

108: DECODE( p_system_name, fnd_api.g_miss_char, NULL, p_system_name),
109: DECODE( p_description, fnd_api.g_miss_char, NULL, p_description),
110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),

Line 113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),

109: DECODE( p_description, fnd_api.g_miss_char, NULL, p_description),
110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),

Line 114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),

110: DECODE( p_system_type_code, fnd_api.g_miss_char, NULL, p_system_type_code),
111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),

Line 115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),

111: DECODE( p_system_number, fnd_api.g_miss_char, NULL, p_system_number),
112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),

Line 116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),

112: DECODE( p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id),
113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),

Line 117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),

113: DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_bill_to_contact_id),
114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),

Line 118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),

114: DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_ship_to_contact_id),
115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),

Line 119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),

115: DECODE( p_technical_contact_id, fnd_api.g_miss_num, NULL, p_technical_contact_id),
116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),
123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),

Line 120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),

116: DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_service_admin_contact_id),
117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),
123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),
124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),

Line 121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),

117: DECODE( p_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_ship_to_site_use_id),
118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),
123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),
124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),
125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),

Line 122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),

118: DECODE( p_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_bill_to_site_use_id),
119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),
123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),
124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),
125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),

Line 123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),

119: DECODE( p_install_site_use_id, fnd_api.g_miss_num, NULL, p_install_site_use_id),
120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),
123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),
124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),
125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),

Line 124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),

120: DECODE( p_coterminate_day_month, fnd_api.g_miss_char, NULL, p_coterminate_day_month),
121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),
123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),
124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),
125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),

Line 125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),

121: DECODE( p_config_system_type, fnd_api.g_miss_char, NULL, p_config_system_type),
122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),
123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),
124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),
125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),

Line 126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),

122: DECODE( p_start_date_active, fnd_api.g_miss_date, NULL, p_start_date_active),
123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),
124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),
125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),

Line 127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),

123: DECODE( p_end_date_active, fnd_api.g_miss_date, NULL, p_end_date_active),
124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),
125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),

Line 128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),

124: DECODE( p_context, fnd_api.g_miss_char, NULL, p_context),
125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),

Line 129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),

125: DECODE( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),

Line 130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),

126: DECODE( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),

Line 131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),

127: DECODE( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),

Line 132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),

128: DECODE( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),

Line 133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),

129: DECODE( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),

Line 134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),

130: DECODE( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),

Line 135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),

131: DECODE( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),

Line 136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),

132: DECODE( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

Line 137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),

133: DECODE( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

Line 138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),

134: DECODE( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

Line 139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),

135: DECODE( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
143: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

Line 140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

136: DECODE( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
143: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
144: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

Line 141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

137: DECODE( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
143: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
144: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
145: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));

Line 142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

138: DECODE( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
143: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
144: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
145: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
146: END insert_row;

Line 143: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

139: DECODE( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
143: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
144: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
145: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
146: END insert_row;
147:

Line 144: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

140: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
143: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
144: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
145: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
146: END insert_row;
147:
148: PROCEDURE Update_Row(

Line 145: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));

141: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
142: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
143: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
144: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
145: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
146: END insert_row;
147:
148: PROCEDURE Update_Row(
149: p_transaction_system_id NUMBER,

Line 194: transaction_line_id = DECODE( p_transaction_line_id, fnd_api.g_miss_num, transaction_line_id, p_transaction_line_id),

190: IS
191: BEGIN
192: UPDATE csi_t_txn_systems
193: SET
194: transaction_line_id = DECODE( p_transaction_line_id, fnd_api.g_miss_num, transaction_line_id, p_transaction_line_id),
195: system_name = DECODE( p_system_name, fnd_api.g_miss_char, system_name, p_system_name),
196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),
197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),

Line 195: system_name = DECODE( p_system_name, fnd_api.g_miss_char, system_name, p_system_name),

191: BEGIN
192: UPDATE csi_t_txn_systems
193: SET
194: transaction_line_id = DECODE( p_transaction_line_id, fnd_api.g_miss_num, transaction_line_id, p_transaction_line_id),
195: system_name = DECODE( p_system_name, fnd_api.g_miss_char, system_name, p_system_name),
196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),
197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),

Line 196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),

192: UPDATE csi_t_txn_systems
193: SET
194: transaction_line_id = DECODE( p_transaction_line_id, fnd_api.g_miss_num, transaction_line_id, p_transaction_line_id),
195: system_name = DECODE( p_system_name, fnd_api.g_miss_char, system_name, p_system_name),
196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),
197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
200: 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 197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),

193: SET
194: transaction_line_id = DECODE( p_transaction_line_id, fnd_api.g_miss_num, transaction_line_id, p_transaction_line_id),
195: system_name = DECODE( p_system_name, fnd_api.g_miss_char, system_name, p_system_name),
196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),
197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
201: 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 198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),

194: transaction_line_id = DECODE( p_transaction_line_id, fnd_api.g_miss_num, transaction_line_id, p_transaction_line_id),
195: system_name = DECODE( p_system_name, fnd_api.g_miss_char, system_name, p_system_name),
196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),
197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),

Line 199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),

195: system_name = DECODE( p_system_name, fnd_api.g_miss_char, system_name, p_system_name),
196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),
197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
203: 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 200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),

196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),
197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
204: 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 201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),

197: system_type_code = DECODE( p_system_type_code, fnd_api.g_miss_char, system_type_code, p_system_type_code),
198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
204: 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),
205: 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 202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),

198: system_number = DECODE( p_system_number, fnd_api.g_miss_char, system_number, p_system_number),
199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
204: 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),
205: 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),
206: 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 203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),

199: customer_id = DECODE( p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id),
200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
204: 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),
205: 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),
206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),

Line 204: 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),

200: bill_to_contact_id = DECODE( p_bill_to_contact_id, fnd_api.g_miss_num, bill_to_contact_id, p_bill_to_contact_id),
201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
204: 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),
205: 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),
206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),

Line 205: 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),

201: ship_to_contact_id = DECODE( p_ship_to_contact_id, fnd_api.g_miss_num, ship_to_contact_id, p_ship_to_contact_id),
202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
204: 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),
205: 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),
206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),
209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),

Line 206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),

202: technical_contact_id = DECODE( p_technical_contact_id, fnd_api.g_miss_num, technical_contact_id, p_technical_contact_id),
203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
204: 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),
205: 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),
206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),
209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),

Line 207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),

203: service_admin_contact_id = DECODE( p_service_admin_contact_id, fnd_api.g_miss_num, service_admin_contact_id, p_service_admin_contact_id),
204: 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),
205: 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),
206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),
209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),

Line 208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),

204: 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),
205: 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),
206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),
209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),
212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

Line 209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),

205: 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),
206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),
209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),
212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

Line 210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),

206: install_site_use_id = DECODE( p_install_site_use_id, fnd_api.g_miss_num, install_site_use_id, p_install_site_use_id),
207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),
209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),
212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

Line 211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),

207: coterminate_day_month = DECODE( p_coterminate_day_month, fnd_api.g_miss_char, coterminate_day_month, p_coterminate_day_month),
208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),
209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),
212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

Line 212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

208: config_system_type = DECODE( p_config_system_type, fnd_api.g_miss_char, config_system_type, p_config_system_type),
209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),
212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

Line 213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

209: start_date_active = DECODE( p_start_date_active, fnd_api.g_miss_date, start_date_active, p_start_date_active),
210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),
212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

Line 214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

210: end_date_active = DECODE( p_end_date_active, fnd_api.g_miss_date, end_date_active, p_end_date_active),
211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),
212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

Line 215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

211: context = DECODE( p_context, fnd_api.g_miss_char, context, p_context),
212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

Line 216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

212: attribute1 = DECODE( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

Line 217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

213: attribute2 = DECODE( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

Line 218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

214: attribute3 = DECODE( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

Line 219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

215: attribute4 = DECODE( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

Line 220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

216: attribute5 = DECODE( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

Line 221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

217: attribute6 = DECODE( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

Line 222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

218: attribute7 = DECODE( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

Line 223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

219: attribute8 = DECODE( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

220: attribute9 = DECODE( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

Line 225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

221: attribute10 = DECODE( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
229: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

Line 226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

222: attribute11 = DECODE( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
229: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
230: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

Line 227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

223: attribute12 = DECODE( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
229: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
230: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
231: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

Line 228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

224: attribute13 = DECODE( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
229: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
230: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
231: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
232: object_version_number = object_version_number+1

Line 229: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

225: attribute14 = DECODE( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
229: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
230: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
231: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
232: object_version_number = object_version_number+1
233: WHERE transaction_system_id = p_transaction_system_id;

Line 230: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

226: attribute15 = DECODE( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
229: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
230: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
231: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
232: object_version_number = object_version_number+1
233: WHERE transaction_system_id = p_transaction_system_id;
234:

Line 231: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

227: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
228: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
229: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
230: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
231: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
232: object_version_number = object_version_number+1
233: WHERE transaction_system_id = p_transaction_system_id;
234:
235: IF (SQL%NOTFOUND) THEN