The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE MLIST_UPDATE_OUTCOME
( p_action_key IN VARCHAR2,
p_list_header_id IN NUMBER,
p_list_entry_id IN NUMBER,
p_outcome_id IN NUMBER,
p_reason_id IN NUMBER,
p_result_id IN NUMBER,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2
) IS
l_creation_date DATE := SYSDATE;
l_last_update_date DATE := SYSDATE;
l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
UPDATE Ams_list_entries
SET outcome_id = p_outcome_id,
reason_id = p_reason_id,
result_id = p_result_id,
last_update_date = l_last_update_date,
last_updated_by = l_last_updated_by,
last_update_login = l_last_update_login
WHERE list_entry_id = p_list_entry_id
AND list_header_id = p_list_header_id;
END; -- End procedure MLIST_UPDATE_OUTCOME
l_last_update_date DATE := SYSDATE;
l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
MLIST_UPDATE_OUTCOME
( p_action_key => p_action_key,
p_list_header_id => l_list_header_id,
p_list_entry_id => l_list_entry_id,
p_outcome_id => l_outcome_id,
p_reason_id => l_reason_id,
p_result_id => l_result_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
p_entered_by => l_last_updated_by,
p_entered_date => l_last_update_date,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_creation_date => l_creation_date,
p_created_by => l_created_by,
p_last_update_login => l_last_update_login,
p_party_id => l_party_id,
x_jtf_note_id => l_jtf_note_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
l_last_update_date DATE := SYSDATE;
l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
MLIST_UPDATE_OUTCOME
( p_action_key => p_action_key,
p_list_header_id => l_list_header_id,
p_list_entry_id => l_list_entry_id,
p_outcome_id => l_outcome_id,
p_reason_id => l_reason_id,
p_result_id => l_result_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
p_entered_by => l_last_updated_by,
p_entered_date => l_last_update_date,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_creation_date => l_creation_date,
p_created_by => l_created_by,
p_last_update_login => l_last_update_login,
p_party_id => l_party_id,
x_jtf_note_id => l_jtf_note_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
l_last_update_date DATE := SYSDATE;
l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
MLIST_UPDATE_OUTCOME
( p_action_key => p_action_key,
p_list_header_id => l_list_header_id,
p_list_entry_id => l_list_entry_id,
p_outcome_id => l_outcome_id,
p_reason_id => l_reason_id,
p_result_id => l_result_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
p_entered_by => l_last_updated_by,
p_entered_date => l_last_update_date,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_creation_date => l_creation_date,
p_created_by => l_created_by,
p_last_update_login => l_last_update_login,
p_party_id => l_party_id,
x_jtf_note_id => l_jtf_note_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
l_last_update_date DATE := SYSDATE;
l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
p_last_update_date => l_last_update_date,
p_lead_id => NULL,
p_lead_number => NULL,
p_description => l_description,
p_status_code => l_status_code,
p_source_code => l_source_code, -- Added by Sumita for bug # 3812865 on 10.14.2004
p_source_code_id => l_source_code_id,
p_customer_id => l_customer_id,
p_contact_party_id => l_contact_party_id,
p_address_id => l_address_id,
p_sales_stage_id => l_sales_stage_id,
p_win_probability => l_win_probability,
p_total_amount => NULL,
p_total_revenue_forecast_amt => l_total_revenue_forecast_amt, --code added for R12
p_channel_code => l_channel_code,
p_decision_date => l_decision_date,
p_currency_code => l_currency_code,
p_vehicle_response_code => l_vehicle_response_code,
p_customer_budget => l_customer_budget,
--Code commented for R12 enhancement --Start
/* p_close_competitor_code => l_close_competitor_code,
p_close_competitor_id => l_close_competitor_id,
p_close_competitor => l_close_competitor, */
--Code commented for R12 enhancement --End
p_close_comment => l_close_comment,
p_parent_project => l_parent_project,
p_freeze_flag => l_freeze_flag,
p_salesgroup_id => l_salesgroup_id,
p_called_node => l_called_node,
p_action_key => l_action_key, -- Added by Sumita for bug # 3812865 on 10.14.2004
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_lead_id => l_lead_id
);
MLIST_UPDATE_OUTCOME
( p_action_key => p_action_key,
p_list_header_id => l_list_header_id,
p_list_entry_id => l_list_entry_id,
p_outcome_id => l_outcome_id,
p_reason_id => l_reason_id,
p_result_id => l_result_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
p_entered_by => l_last_updated_by,
p_entered_date => l_last_update_date,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_creation_date => l_creation_date,
p_created_by => l_created_by,
p_last_update_login => l_last_update_login,
p_party_id => l_party_id,
x_jtf_note_id => l_jtf_note_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
l_last_update_date DATE := SYSDATE;
l_last_updated_by NUMBER := FND_PROFILE.Value('USER_ID'); --REVIEW
l_last_update_login NUMBER := FND_PROFILE.Value('LOGIN_ID'); -- REVIEW
p_entered_by => l_last_updated_by,
p_entered_date => l_last_update_date,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_creation_date => l_creation_date,
p_created_by => l_created_by,
p_last_update_login => l_last_update_login,
p_party_id => l_party_id,
x_jtf_note_id => l_jtf_note_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);