APPS.CSI_TRANSACTIONS_PKG dependencies on FND_API

Line 67: IF (px_transaction_id IS NULL) or (px_transaction_id = fnd_api.g_miss_num) THEN

63:
64: IS
65: CURSOR c2 IS SELECT csi_transactions_s.nextval FROM sys.dual;
66: BEGIN
67: IF (px_transaction_id IS NULL) or (px_transaction_id = fnd_api.g_miss_num) THEN
68: OPEN c2;
69: FETCH c2 INTO px_transaction_id;
70: CLOSE c2;
71: END IF;

Line 121: decode( p_transaction_date, fnd_api.g_miss_date, to_date(null), p_transaction_date),

117: split_reason_code,
118: gl_interface_status_code
119: ) values (
120: px_transaction_id,
121: decode( p_transaction_date, fnd_api.g_miss_date, to_date(null), p_transaction_date),
122: decode( p_source_transaction_date, fnd_api.g_miss_date, to_date(null), p_source_transaction_date),
123: decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),
124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),

Line 122: decode( p_source_transaction_date, fnd_api.g_miss_date, to_date(null), p_source_transaction_date),

118: gl_interface_status_code
119: ) values (
120: px_transaction_id,
121: decode( p_transaction_date, fnd_api.g_miss_date, to_date(null), p_transaction_date),
122: decode( p_source_transaction_date, fnd_api.g_miss_date, to_date(null), p_source_transaction_date),
123: decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),
124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),

Line 123: decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),

119: ) values (
120: px_transaction_id,
121: decode( p_transaction_date, fnd_api.g_miss_date, to_date(null), p_transaction_date),
122: decode( p_source_transaction_date, fnd_api.g_miss_date, to_date(null), p_source_transaction_date),
123: decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),
124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),

Line 124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),

120: px_transaction_id,
121: decode( p_transaction_date, fnd_api.g_miss_date, to_date(null), p_transaction_date),
122: decode( p_source_transaction_date, fnd_api.g_miss_date, to_date(null), p_source_transaction_date),
123: decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),
124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),

Line 125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),

121: decode( p_transaction_date, fnd_api.g_miss_date, to_date(null), p_transaction_date),
122: decode( p_source_transaction_date, fnd_api.g_miss_date, to_date(null), p_source_transaction_date),
123: decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),
124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),

Line 126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),

122: decode( p_source_transaction_date, fnd_api.g_miss_date, to_date(null), p_source_transaction_date),
123: decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),
124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),

Line 127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),

123: decode( p_transaction_type_id, fnd_api.g_miss_num, null, p_transaction_type_id),
124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),

Line 128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),

124: decode( p_txn_sub_type_id, fnd_api.g_miss_num, null, p_txn_sub_type_id),
125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),

Line 129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),

125: decode( p_source_group_ref_id, fnd_api.g_miss_num, null, p_source_group_ref_id),
126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),

Line 130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),

126: decode( p_source_group_ref, fnd_api.g_miss_char, null, p_source_group_ref),
127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),

Line 131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),

127: decode( p_source_header_ref_id, fnd_api.g_miss_num, null, p_source_header_ref_id),
128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),

Line 132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),

128: decode( p_source_header_ref, fnd_api.g_miss_char, null, p_source_header_ref),
129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),

Line 133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),

129: decode( p_source_line_ref_id, fnd_api.g_miss_num, null, p_source_line_ref_id),
130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),

Line 134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),

130: decode( p_source_line_ref, fnd_api.g_miss_char, null, p_source_line_ref),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),

Line 135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),

131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num, null, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),

Line 136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),

132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num, null, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140: decode( p_context, fnd_api.g_miss_char, null, p_context),

Line 137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),

133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num, null, p_inv_material_transaction_id),
134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140: decode( p_context, fnd_api.g_miss_char, null, p_context),
141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),

Line 138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),

134: decode( p_transaction_quantity, fnd_api.g_miss_num, null, p_transaction_quantity),
135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140: decode( p_context, fnd_api.g_miss_char, null, p_context),
141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),

Line 139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),

135: decode( p_transaction_uom_code, fnd_api.g_miss_char, null, p_transaction_uom_code),
136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140: decode( p_context, fnd_api.g_miss_char, null, p_context),
141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),

Line 140: decode( p_context, fnd_api.g_miss_char, null, p_context),

136: decode( p_transacted_by, fnd_api.g_miss_num, null, p_transacted_by),
137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140: decode( p_context, fnd_api.g_miss_char, null, p_context),
141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),

Line 141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),

137: decode( p_transaction_status_code, fnd_api.g_miss_char, null, p_transaction_status_code),
138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140: decode( p_context, fnd_api.g_miss_char, null, p_context),
141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),

Line 142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),

138: decode( p_transaction_action_code, fnd_api.g_miss_char, null, p_transaction_action_code),
139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140: decode( p_context, fnd_api.g_miss_char, null, p_context),
141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),

Line 143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),

139: decode( p_message_id, fnd_api.g_miss_num, null, p_message_id),
140: decode( p_context, fnd_api.g_miss_char, null, p_context),
141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),

Line 144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),

140: decode( p_context, fnd_api.g_miss_char, null, p_context),
141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),

Line 145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),

141: decode( p_attribute1, fnd_api.g_miss_char, null, p_attribute1),
142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),

Line 146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),

142: decode( p_attribute2, fnd_api.g_miss_char, null, p_attribute2),
143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),

Line 147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),

143: decode( p_attribute3, fnd_api.g_miss_char, null, p_attribute3),
144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),

Line 148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),

144: decode( p_attribute4, fnd_api.g_miss_char, null, p_attribute4),
145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),

Line 149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),

145: decode( p_attribute5, fnd_api.g_miss_char, null, p_attribute5),
146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),

Line 150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),

146: decode( p_attribute6, fnd_api.g_miss_char, null, p_attribute6),
147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),

Line 151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),

147: decode( p_attribute7, fnd_api.g_miss_char, null, p_attribute7),
148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),

Line 152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),

148: decode( p_attribute8, fnd_api.g_miss_char, null, p_attribute8),
149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),

Line 153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),

149: decode( p_attribute9, fnd_api.g_miss_char, null, p_attribute9),
150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),

Line 154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),

150: decode( p_attribute10, fnd_api.g_miss_char, null, p_attribute10),
151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),

Line 155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),

151: decode( p_attribute11, fnd_api.g_miss_char, null, p_attribute11),
152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),

Line 156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),

152: decode( p_attribute12, fnd_api.g_miss_char, null, p_attribute12),
153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),

Line 157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),

153: decode( p_attribute13, fnd_api.g_miss_char, null, p_attribute13),
154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),
161: decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),

Line 158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),

154: decode( p_attribute14, fnd_api.g_miss_char, null, p_attribute14),
155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),
161: decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),
162: decode( p_split_reason_code, fnd_api.g_miss_char, null, p_split_reason_code),

Line 159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),

155: decode( p_attribute15, fnd_api.g_miss_char, null, p_attribute15),
156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),
161: decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),
162: decode( p_split_reason_code, fnd_api.g_miss_char, null, p_split_reason_code),
163: decode( p_gl_interface_status_code, fnd_api.g_miss_num, null, p_gl_interface_status_code)

Line 160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),

156: decode( p_created_by, fnd_api.g_miss_num, null, p_created_by),
157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),
161: decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),
162: decode( p_split_reason_code, fnd_api.g_miss_char, null, p_split_reason_code),
163: decode( p_gl_interface_status_code, fnd_api.g_miss_num, null, p_gl_interface_status_code)
164: );

Line 161: decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),

157: decode( p_creation_date, fnd_api.g_miss_date, to_date(null), p_creation_date),
158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),
161: decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),
162: decode( p_split_reason_code, fnd_api.g_miss_char, null, p_split_reason_code),
163: decode( p_gl_interface_status_code, fnd_api.g_miss_num, null, p_gl_interface_status_code)
164: );
165:

Line 162: decode( p_split_reason_code, fnd_api.g_miss_char, null, p_split_reason_code),

158: decode( p_last_updated_by, fnd_api.g_miss_num, null, p_last_updated_by),
159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),
161: decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),
162: decode( p_split_reason_code, fnd_api.g_miss_char, null, p_split_reason_code),
163: decode( p_gl_interface_status_code, fnd_api.g_miss_num, null, p_gl_interface_status_code)
164: );
165:
166: -- commit;

Line 163: decode( p_gl_interface_status_code, fnd_api.g_miss_num, null, p_gl_interface_status_code)

159: decode( p_last_update_date, fnd_api.g_miss_date, to_date(null), p_last_update_date),
160: decode( p_last_update_login, fnd_api.g_miss_num, null, p_last_update_login),
161: decode( p_object_version_number, fnd_api.g_miss_num, null, p_object_version_number),
162: decode( p_split_reason_code, fnd_api.g_miss_char, null, p_split_reason_code),
163: decode( p_gl_interface_status_code, fnd_api.g_miss_num, null, p_gl_interface_status_code)
164: );
165:
166: -- commit;
167: end insert_row;

Line 174: p_transaction_id NUMBER := fnd_api.g_miss_num ,

170: /* --- this procedure is used to update the record into csi_transactions table. --- */
171: /* ---------------------------------------------------------------------------------- */
172:
173: PROCEDURE update_row(
174: p_transaction_id NUMBER := fnd_api.g_miss_num ,
175: p_transaction_date DATE := fnd_api.g_miss_date,
176: p_source_transaction_date DATE := fnd_api.g_miss_date,
177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,

Line 175: p_transaction_date DATE := fnd_api.g_miss_date,

171: /* ---------------------------------------------------------------------------------- */
172:
173: PROCEDURE update_row(
174: p_transaction_id NUMBER := fnd_api.g_miss_num ,
175: p_transaction_date DATE := fnd_api.g_miss_date,
176: p_source_transaction_date DATE := fnd_api.g_miss_date,
177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,

Line 176: p_source_transaction_date DATE := fnd_api.g_miss_date,

172:
173: PROCEDURE update_row(
174: p_transaction_id NUMBER := fnd_api.g_miss_num ,
175: p_transaction_date DATE := fnd_api.g_miss_date,
176: p_source_transaction_date DATE := fnd_api.g_miss_date,
177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,

Line 177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,

173: PROCEDURE update_row(
174: p_transaction_id NUMBER := fnd_api.g_miss_num ,
175: p_transaction_date DATE := fnd_api.g_miss_date,
176: p_source_transaction_date DATE := fnd_api.g_miss_date,
177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,

Line 178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,

174: p_transaction_id NUMBER := fnd_api.g_miss_num ,
175: p_transaction_date DATE := fnd_api.g_miss_date,
176: p_source_transaction_date DATE := fnd_api.g_miss_date,
177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,

Line 179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,

175: p_transaction_date DATE := fnd_api.g_miss_date,
176: p_source_transaction_date DATE := fnd_api.g_miss_date,
177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,

Line 180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,

176: p_source_transaction_date DATE := fnd_api.g_miss_date,
177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,

Line 181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,

177: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,

Line 182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,

178: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,

Line 183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,

179: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,

Line 184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,

180: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,

Line 185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,

181: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,

Line 186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,

182: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190: p_transacted_by NUMBER := fnd_api.g_miss_num ,

Line 187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,

183: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190: p_transacted_by NUMBER := fnd_api.g_miss_num ,
191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,

Line 188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,

184: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190: p_transacted_by NUMBER := fnd_api.g_miss_num ,
191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,

Line 189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,

185: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190: p_transacted_by NUMBER := fnd_api.g_miss_num ,
191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193: p_message_id NUMBER := fnd_api.g_miss_num ,

Line 190: p_transacted_by NUMBER := fnd_api.g_miss_num ,

186: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190: p_transacted_by NUMBER := fnd_api.g_miss_num ,
191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193: p_message_id NUMBER := fnd_api.g_miss_num ,
194: p_context VARCHAR2 := fnd_api.g_miss_char,

Line 191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,

187: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190: p_transacted_by NUMBER := fnd_api.g_miss_num ,
191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193: p_message_id NUMBER := fnd_api.g_miss_num ,
194: p_context VARCHAR2 := fnd_api.g_miss_char,
195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,

Line 192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,

188: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190: p_transacted_by NUMBER := fnd_api.g_miss_num ,
191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193: p_message_id NUMBER := fnd_api.g_miss_num ,
194: p_context VARCHAR2 := fnd_api.g_miss_char,
195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,

Line 193: p_message_id NUMBER := fnd_api.g_miss_num ,

189: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
190: p_transacted_by NUMBER := fnd_api.g_miss_num ,
191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193: p_message_id NUMBER := fnd_api.g_miss_num ,
194: p_context VARCHAR2 := fnd_api.g_miss_char,
195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,

Line 194: p_context VARCHAR2 := fnd_api.g_miss_char,

190: p_transacted_by NUMBER := fnd_api.g_miss_num ,
191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193: p_message_id NUMBER := fnd_api.g_miss_num ,
194: p_context VARCHAR2 := fnd_api.g_miss_char,
195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,

Line 195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,

191: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193: p_message_id NUMBER := fnd_api.g_miss_num ,
194: p_context VARCHAR2 := fnd_api.g_miss_char,
195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,

Line 196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,

192: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
193: p_message_id NUMBER := fnd_api.g_miss_num ,
194: p_context VARCHAR2 := fnd_api.g_miss_char,
195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,

Line 197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,

193: p_message_id NUMBER := fnd_api.g_miss_num ,
194: p_context VARCHAR2 := fnd_api.g_miss_char,
195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,

Line 198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,

194: p_context VARCHAR2 := fnd_api.g_miss_char,
195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,

Line 199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,

195: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,

Line 200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,

196: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,

Line 201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,

197: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,

Line 202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,

198: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,

Line 203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,

199: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,

Line 204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,

200: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,

Line 205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,

201: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,

Line 206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,

202: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210: p_created_by NUMBER := fnd_api.g_miss_num ,

Line 207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,

203: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210: p_created_by NUMBER := fnd_api.g_miss_num ,
211: p_creation_date DATE := fnd_api.g_miss_date,

Line 208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,

204: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210: p_created_by NUMBER := fnd_api.g_miss_num ,
211: p_creation_date DATE := fnd_api.g_miss_date,
212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,

Line 209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,

205: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210: p_created_by NUMBER := fnd_api.g_miss_num ,
211: p_creation_date DATE := fnd_api.g_miss_date,
212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213: p_last_update_date DATE := fnd_api.g_miss_date,

Line 210: p_created_by NUMBER := fnd_api.g_miss_num ,

206: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210: p_created_by NUMBER := fnd_api.g_miss_num ,
211: p_creation_date DATE := fnd_api.g_miss_date,
212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213: p_last_update_date DATE := fnd_api.g_miss_date,
214: p_last_update_login NUMBER := fnd_api.g_miss_num ,

Line 211: p_creation_date DATE := fnd_api.g_miss_date,

207: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210: p_created_by NUMBER := fnd_api.g_miss_num ,
211: p_creation_date DATE := fnd_api.g_miss_date,
212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213: p_last_update_date DATE := fnd_api.g_miss_date,
214: p_last_update_login NUMBER := fnd_api.g_miss_num ,
215: p_object_version_number NUMBER := fnd_api.g_miss_num ,

Line 212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,

208: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210: p_created_by NUMBER := fnd_api.g_miss_num ,
211: p_creation_date DATE := fnd_api.g_miss_date,
212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213: p_last_update_date DATE := fnd_api.g_miss_date,
214: p_last_update_login NUMBER := fnd_api.g_miss_num ,
215: p_object_version_number NUMBER := fnd_api.g_miss_num ,
216: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,

Line 213: p_last_update_date DATE := fnd_api.g_miss_date,

209: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
210: p_created_by NUMBER := fnd_api.g_miss_num ,
211: p_creation_date DATE := fnd_api.g_miss_date,
212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213: p_last_update_date DATE := fnd_api.g_miss_date,
214: p_last_update_login NUMBER := fnd_api.g_miss_num ,
215: p_object_version_number NUMBER := fnd_api.g_miss_num ,
216: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
217: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num

Line 214: p_last_update_login NUMBER := fnd_api.g_miss_num ,

210: p_created_by NUMBER := fnd_api.g_miss_num ,
211: p_creation_date DATE := fnd_api.g_miss_date,
212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213: p_last_update_date DATE := fnd_api.g_miss_date,
214: p_last_update_login NUMBER := fnd_api.g_miss_num ,
215: p_object_version_number NUMBER := fnd_api.g_miss_num ,
216: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
217: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
218: )

Line 215: p_object_version_number NUMBER := fnd_api.g_miss_num ,

211: p_creation_date DATE := fnd_api.g_miss_date,
212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213: p_last_update_date DATE := fnd_api.g_miss_date,
214: p_last_update_login NUMBER := fnd_api.g_miss_num ,
215: p_object_version_number NUMBER := fnd_api.g_miss_num ,
216: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
217: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
218: )
219: is

Line 216: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,

212: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
213: p_last_update_date DATE := fnd_api.g_miss_date,
214: p_last_update_login NUMBER := fnd_api.g_miss_num ,
215: p_object_version_number NUMBER := fnd_api.g_miss_num ,
216: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
217: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
218: )
219: is
220: BEGIN

Line 217: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num

213: p_last_update_date DATE := fnd_api.g_miss_date,
214: p_last_update_login NUMBER := fnd_api.g_miss_num ,
215: p_object_version_number NUMBER := fnd_api.g_miss_num ,
216: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
217: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
218: )
219: is
220: BEGIN
221: update csi_transactions

Line 223: transaction_date = decode( p_transaction_date, fnd_api.g_miss_date, transaction_date, p_transaction_date),

219: is
220: BEGIN
221: update csi_transactions
222: set
223: transaction_date = decode( p_transaction_date, fnd_api.g_miss_date, transaction_date, p_transaction_date),
224: source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),
225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),
226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),

Line 224: source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),

220: BEGIN
221: update csi_transactions
222: set
223: transaction_date = decode( p_transaction_date, fnd_api.g_miss_date, transaction_date, p_transaction_date),
224: source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),
225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),
226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),

Line 225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),

221: update csi_transactions
222: set
223: transaction_date = decode( p_transaction_date, fnd_api.g_miss_date, transaction_date, p_transaction_date),
224: source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),
225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),
226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),

Line 226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),

222: set
223: transaction_date = decode( p_transaction_date, fnd_api.g_miss_date, transaction_date, p_transaction_date),
224: source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),
225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),
226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),

Line 227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),

223: transaction_date = decode( p_transaction_date, fnd_api.g_miss_date, transaction_date, p_transaction_date),
224: source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),
225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),
226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),

Line 228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),

224: source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),
225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),
226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),

Line 229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),

225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),
226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),

Line 230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),

226: txn_sub_type_id = decode( p_txn_sub_type_id, fnd_api.g_miss_num, txn_sub_type_id, p_txn_sub_type_id),
227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),

Line 231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),

227: source_group_ref_id = decode( p_source_group_ref_id, fnd_api.g_miss_num, source_group_ref_id, p_source_group_ref_id),
228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),

Line 232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),

228: source_group_ref = decode( p_source_group_ref, fnd_api.g_miss_char, source_group_ref, p_source_group_ref),
229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),

Line 233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),

229: source_header_ref_id = decode( p_source_header_ref_id, fnd_api.g_miss_num, source_header_ref_id, p_source_header_ref_id),
230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),

Line 234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),

230: source_header_ref = decode( p_source_header_ref, fnd_api.g_miss_char, source_header_ref, p_source_header_ref),
231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),

Line 235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),

231: source_line_ref_id = decode( p_source_line_ref_id, fnd_api.g_miss_num, source_line_ref_id, p_source_line_ref_id),
232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),

Line 236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),

232: source_line_ref = decode( p_source_line_ref, fnd_api.g_miss_char, source_line_ref, p_source_line_ref),
233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),

Line 237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),

233: source_dist_ref_id1 = decode( p_source_dist_ref_id1, fnd_api.g_miss_num, source_dist_ref_id1, p_source_dist_ref_id1),
234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),

Line 238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),

234: source_dist_ref_id2 = decode( p_source_dist_ref_id2, fnd_api.g_miss_num, source_dist_ref_id2, p_source_dist_ref_id2),
235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

Line 239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),

235: inv_material_transaction_id = decode( p_inv_material_transaction_id, fnd_api.g_miss_num, inv_material_transaction_id, p_inv_material_transaction_id),
236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

Line 240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),

236: transaction_quantity = decode( p_transaction_quantity, fnd_api.g_miss_num, transaction_quantity, p_transaction_quantity),
237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

Line 241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),

237: transaction_uom_code = decode( p_transaction_uom_code, fnd_api.g_miss_char, transaction_uom_code, p_transaction_uom_code),
238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

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

238: transacted_by = decode( p_transacted_by, fnd_api.g_miss_num, transacted_by, p_transacted_by),
239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

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

239: transaction_status_code = decode( p_transaction_status_code, fnd_api.g_miss_char, transaction_status_code, p_transaction_status_code),
240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

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

240: transaction_action_code = decode( p_transaction_action_code, fnd_api.g_miss_char, transaction_action_code, p_transaction_action_code),
241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

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

241: message_id = decode( p_message_id, fnd_api.g_miss_num, message_id, p_message_id),
242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

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

242: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

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

243: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

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

244: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

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

245: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

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

246: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

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

247: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

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

248: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

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

249: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

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

250: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

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

251: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

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

252: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
260: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

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

253: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
260: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
261: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

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

254: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
260: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
261: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
262: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

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

255: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
260: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
261: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
262: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
263: object_version_number = object_version_number+1,

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

256: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
260: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
261: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
262: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
263: object_version_number = object_version_number+1,
264: --decode( p_object_version_NUMBER, fnd_api.g_miss_num, object_version_NUMBER, p_object_version_NUMBER),

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

257: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
260: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
261: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
262: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
263: object_version_number = object_version_number+1,
264: --decode( p_object_version_NUMBER, fnd_api.g_miss_num, object_version_NUMBER, p_object_version_NUMBER),
265: split_reason_code = decode( p_split_reason_code, fnd_api.g_miss_char, split_reason_code, p_split_reason_code),

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

258: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
259: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
260: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
261: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
262: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
263: object_version_number = object_version_number+1,
264: --decode( p_object_version_NUMBER, fnd_api.g_miss_num, object_version_NUMBER, p_object_version_NUMBER),
265: split_reason_code = decode( p_split_reason_code, fnd_api.g_miss_char, split_reason_code, p_split_reason_code),
266: gl_interface_status_code = decode( p_gl_interface_status_code, fnd_api.g_miss_num, gl_interface_status_code, p_gl_interface_status_code)

Line 264: --decode( p_object_version_NUMBER, fnd_api.g_miss_num, object_version_NUMBER, p_object_version_NUMBER),

260: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
261: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
262: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
263: object_version_number = object_version_number+1,
264: --decode( p_object_version_NUMBER, fnd_api.g_miss_num, object_version_NUMBER, p_object_version_NUMBER),
265: split_reason_code = decode( p_split_reason_code, fnd_api.g_miss_char, split_reason_code, p_split_reason_code),
266: gl_interface_status_code = decode( p_gl_interface_status_code, fnd_api.g_miss_num, gl_interface_status_code, p_gl_interface_status_code)
267:
268: WHERE transaction_id = p_transaction_id;

Line 265: split_reason_code = decode( p_split_reason_code, fnd_api.g_miss_char, split_reason_code, p_split_reason_code),

261: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
262: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
263: object_version_number = object_version_number+1,
264: --decode( p_object_version_NUMBER, fnd_api.g_miss_num, object_version_NUMBER, p_object_version_NUMBER),
265: split_reason_code = decode( p_split_reason_code, fnd_api.g_miss_char, split_reason_code, p_split_reason_code),
266: gl_interface_status_code = decode( p_gl_interface_status_code, fnd_api.g_miss_num, gl_interface_status_code, p_gl_interface_status_code)
267:
268: WHERE transaction_id = p_transaction_id;
269:

Line 266: gl_interface_status_code = decode( p_gl_interface_status_code, fnd_api.g_miss_num, gl_interface_status_code, p_gl_interface_status_code)

262: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
263: object_version_number = object_version_number+1,
264: --decode( p_object_version_NUMBER, fnd_api.g_miss_num, object_version_NUMBER, p_object_version_NUMBER),
265: split_reason_code = decode( p_split_reason_code, fnd_api.g_miss_char, split_reason_code, p_split_reason_code),
266: gl_interface_status_code = decode( p_gl_interface_status_code, fnd_api.g_miss_num, gl_interface_status_code, p_gl_interface_status_code)
267:
268: WHERE transaction_id = p_transaction_id;
269:
270: IF (SQL%NOTFOUND) THEN