59: /* --- This procedure is used to update the record into csi_transactions table. --- */
60: /* ---------------------------------------------------------------------------------- */
61:
62: PROCEDURE update_row(
63: p_transaction_id NUMBER := fnd_api.g_miss_num ,
64: p_transaction_date DATE := fnd_api.g_miss_date,
65: p_source_transaction_date DATE := fnd_api.g_miss_date,
66: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
60: /* ---------------------------------------------------------------------------------- */
61:
62: PROCEDURE update_row(
63: p_transaction_id NUMBER := fnd_api.g_miss_num ,
64: p_transaction_date DATE := fnd_api.g_miss_date,
65: p_source_transaction_date DATE := fnd_api.g_miss_date,
66: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
61:
62: PROCEDURE update_row(
63: p_transaction_id NUMBER := fnd_api.g_miss_num ,
64: p_transaction_date DATE := fnd_api.g_miss_date,
65: p_source_transaction_date DATE := fnd_api.g_miss_date,
66: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
62: PROCEDURE update_row(
63: p_transaction_id NUMBER := fnd_api.g_miss_num ,
64: p_transaction_date DATE := fnd_api.g_miss_date,
65: p_source_transaction_date DATE := fnd_api.g_miss_date,
66: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
63: p_transaction_id NUMBER := fnd_api.g_miss_num ,
64: p_transaction_date DATE := fnd_api.g_miss_date,
65: p_source_transaction_date DATE := fnd_api.g_miss_date,
66: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
64: p_transaction_date DATE := fnd_api.g_miss_date,
65: p_source_transaction_date DATE := fnd_api.g_miss_date,
66: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
65: p_source_transaction_date DATE := fnd_api.g_miss_date,
66: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
66: p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
67: p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
68: p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
69: p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
70: p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
71: p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
72: p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
73: p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
74: p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
75: p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
76: p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
77: p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
78: p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
79: p_transacted_by NUMBER := fnd_api.g_miss_num ,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
80: p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
81: p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
82: p_message_id NUMBER := fnd_api.g_miss_num ,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
83: p_context VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99: p_created_by NUMBER := fnd_api.g_miss_num ,
92: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99: p_created_by NUMBER := fnd_api.g_miss_num ,
100: p_creation_date DATE := fnd_api.g_miss_date,
93: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99: p_created_by NUMBER := fnd_api.g_miss_num ,
100: p_creation_date DATE := fnd_api.g_miss_date,
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
94: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99: p_created_by NUMBER := fnd_api.g_miss_num ,
100: p_creation_date DATE := fnd_api.g_miss_date,
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102: p_last_update_date DATE := fnd_api.g_miss_date,
95: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99: p_created_by NUMBER := fnd_api.g_miss_num ,
100: p_creation_date DATE := fnd_api.g_miss_date,
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102: p_last_update_date DATE := fnd_api.g_miss_date,
103: p_last_update_login NUMBER := fnd_api.g_miss_num ,
96: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99: p_created_by NUMBER := fnd_api.g_miss_num ,
100: p_creation_date DATE := fnd_api.g_miss_date,
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102: p_last_update_date DATE := fnd_api.g_miss_date,
103: p_last_update_login NUMBER := fnd_api.g_miss_num ,
104: p_object_version_NUMBER NUMBER := fnd_api.g_miss_num ,
97: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99: p_created_by NUMBER := fnd_api.g_miss_num ,
100: p_creation_date DATE := fnd_api.g_miss_date,
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102: p_last_update_date DATE := fnd_api.g_miss_date,
103: p_last_update_login NUMBER := fnd_api.g_miss_num ,
104: p_object_version_NUMBER NUMBER := fnd_api.g_miss_num ,
105: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
98: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99: p_created_by NUMBER := fnd_api.g_miss_num ,
100: p_creation_date DATE := fnd_api.g_miss_date,
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102: p_last_update_date DATE := fnd_api.g_miss_date,
103: p_last_update_login NUMBER := fnd_api.g_miss_num ,
104: p_object_version_NUMBER NUMBER := fnd_api.g_miss_num ,
105: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
106: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
99: p_created_by NUMBER := fnd_api.g_miss_num ,
100: p_creation_date DATE := fnd_api.g_miss_date,
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102: p_last_update_date DATE := fnd_api.g_miss_date,
103: p_last_update_login NUMBER := fnd_api.g_miss_num ,
104: p_object_version_NUMBER NUMBER := fnd_api.g_miss_num ,
105: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
106: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
107: );
100: p_creation_date DATE := fnd_api.g_miss_date,
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102: p_last_update_date DATE := fnd_api.g_miss_date,
103: p_last_update_login NUMBER := fnd_api.g_miss_num ,
104: p_object_version_NUMBER NUMBER := fnd_api.g_miss_num ,
105: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
106: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
107: );
108: /*
101: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102: p_last_update_date DATE := fnd_api.g_miss_date,
103: p_last_update_login NUMBER := fnd_api.g_miss_num ,
104: p_object_version_NUMBER NUMBER := fnd_api.g_miss_num ,
105: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
106: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
107: );
108: /*
109: PROCEDURE lock_row(
102: p_last_update_date DATE := fnd_api.g_miss_date,
103: p_last_update_login NUMBER := fnd_api.g_miss_num ,
104: p_object_version_NUMBER NUMBER := fnd_api.g_miss_num ,
105: p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
106: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
107: );
108: /*
109: PROCEDURE lock_row(
110: p_transaction_id NUMBER,