The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_status (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_commit IN VARCHAR2 := fnd_api.g_false,
p_validation_level IN NUMBER := fnd_api.g_miss_num,
p_tangible_id IN NUMBER,
p_credit_app_id IN NUMBER,
p_new_status_category IN VARCHAR2,
p_new_status IN VARCHAR2,
p_last_update_date IN DATE := fnd_api.g_miss_date,
x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
l_api_version NUMBER := 1.0;
l_api_name VARCHAR2 (50) := 'Update_Status';
SELECT object_id, last_update_date, related_object_id
FROM aso_quote_related_objects
WHERE relationship_type_code = 'THIRDPARTY_FINANCING'
AND object_type_code = 'CREDIT_APPLICATION'
AND quote_object_id = lc_qte_header_id;
SELECT qh.quote_source_code, qh.last_update_date, qh.resource_id,
qh.quote_status_id, qs.status_code
FROM aso_quote_headers_all qh, aso_quote_statuses_b qs
WHERE qh.quote_header_id = lc_quote_id
AND qh.quote_status_id = qs.quote_status_id;
SELECT quote_status_id
FROM aso_quote_statuses_b
WHERE status_code = lc_status_code;
SAVEPOINT update_status_pvt;
'Update_Status Begin',
1,
'Y'
);
'Update_Status: P_API_VERSION '|| p_api_version,
1,
'Y'
);
'Update_Status: P_INIT_MSG_LIST '|| p_init_msg_list,
1,
'Y'
);
'Update_Status: P_COMMIT '|| p_commit,
1,
'Y'
);
'Update_Status: p_validation_level '|| p_validation_level,
1,
'Y'
);
'Update_Status: p_tangible_id '|| p_tangible_id,
1,
'Y'
);
'Update_Status: p_credit_app_id '|| p_credit_app_id,
1,
'Y'
);
'Update_Status: p_new_status_category '|| p_new_status_category,
1,
'Y'
);
'Update_Status: p_new_status '|| p_new_status,
1,
'Y'
);
'Update_Status: p_last_update_date '
|| TO_CHAR (
p_last_update_date,
'DD-MON-YY HH24:MI:SS'
),
1,
'Y'
);
l_related_obj_rec.last_update_date,
l_related_obj_id;
'Update_Status: The first time that it is called to change quote to financing pending',
1,
'Y'
);
l_qte_header_rec.last_update_date,
l_qte_resource_id,
l_quote_status_id,
l_current_status_code;
'Update_Status: getting information for quote '|| l_quote_header_id,
1,
'Y'
);
'Update_Status: quote current status '|| l_current_status_code,
1,
'Y'
);
'Update_Status: quote last update date '
|| TO_CHAR (
l_qte_header_rec.last_update_date,
'DD-MON-YY HH24:MI:SS'
),
1,
'Y'
);
* p_last_update_date must be passed in as the same value in quote header record.
*/
IF p_new_status_category = g_financing_pending
AND l_current_status_code <> 'FINANCING PENDING'
THEN
IF p_last_update_date = fnd_api.g_miss_date
OR p_last_update_date IS NULL
THEN
IF fnd_msg_pub.check_msg_level (
fnd_msg_pub.g_msg_lvl_error
)
THEN
fnd_message.set_name (
'ASO',
'API_INVALID_ID'
);
'LAST_UPDATE_DATE',
FALSE
);
ELSIF p_last_update_date <> l_qte_header_rec.last_update_date
THEN
IF fnd_msg_pub.check_msg_level (
fnd_msg_pub.g_msg_lvl_error
)
THEN
fnd_message.set_name (
'ASO',
'ASO_API_RECORD_CHANGED'
);
'Update_Status: after Create_related_obj return_status: '
|| x_return_status,
1,
'Y'
);
aso_related_obj_pvt.update_related_obj (
p_api_version_number => 1.0,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => fnd_api.g_valid_level_none,
p_related_obj_rec => l_related_obj_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
'Update_Status: after Update_related_obj return_status: '
|| x_return_status,
1,
'Y'
);
'ASO_API_ERROR_IN_UPDATE_RLTN'
);
'Update_Status: Updating quote status to '
|| l_qte_header_rec.quote_status_id,
1,
'Y'
);
aso_quote_pub.update_quote (
p_api_version_number => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_qte_header_rec => l_qte_header_rec,
x_qte_header_rec => lx_qte_header_rec,
x_qte_line_tbl => lx_qte_line_tbl,
x_qte_line_dtl_tbl => lx_qte_line_dtl_tbl,
x_hd_price_attributes_tbl => lx_hd_price_attr_tbl,
x_hd_payment_tbl => lx_hd_payment_tbl,
x_hd_shipment_tbl => lx_hd_shipment_tbl,
x_hd_freight_charge_tbl => lx_hd_freight_charge_tbl,
x_hd_tax_detail_tbl => lx_hd_tax_detail_tbl,
x_line_attr_ext_tbl => lx_line_attr_ext_tbl,
x_line_rltship_tbl => lx_line_rltship_tbl,
x_price_adjustment_tbl => lx_price_adjustment_tbl,
x_price_adj_attr_tbl => lx_price_adj_attr_tbl,
x_price_adj_rltship_tbl => lx_price_adj_rltship_tbl,
x_ln_price_attributes_tbl => lx_ln_price_attr_tbl,
x_ln_payment_tbl => lx_ln_payment_tbl,
x_ln_shipment_tbl => lx_ln_shipment_tbl,
x_ln_freight_charge_tbl => lx_ln_freight_charge_tbl,
x_ln_tax_detail_tbl => lx_ln_tax_detail_tbl,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
'Update_Status: after Update_Quote return_status: '|| x_return_status,
1,
'Y'
);
'ASO_API_ERROR_IN_UPDATE_QUOTE'
);
'Update_Status End',
1,
'Y'
);
END update_status;