The following lines contain the word 'select', 'insert', 'update' or 'delete':
If the return status is Success then insert the record in the table
AR_CMGT_GUARANTOR_DATA
*/
SAVEPOINT GUAR_CREDIT_REQ_PVT;
/* If the credit request is created successfully for the guarantor the insert a
record in table AR_CMGT_GUARANTOR_DATA for this request */
IF x_return_status <> FND_API.G_RET_STS_SUCCESS
THEN
ROLLBACK TO GUAR_CREDIT_REQ_PVT;
INSERT INTO AR_CMGT_GUARANTOR_DATA
(
datapoint_id ,
credit_request_id ,
Guarantor_credit_request_id,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
currency ,
guaranteed_amount ,
funding_available_from ,
funding_available_to ,
notes ,
case_folder_id ,
asset_class_code ,
asset_type_code ,
description ,
quantity ,
uom_code ,
reference_type ,
appraiser ,
appraiser_phone ,
valuation ,
valuation_method_code ,
valuation_date ,
acquisition_date ,
asset_identifier ,
party_id,
contact_party_id
)
VALUES
(
AR_CMGT_GUARANTOR_DATA_S.nextval,
p_parent_credit_request_id,
x_guarantor_credit_request_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id,
p_currency,
p_guaranted_amount,
p_funding_available_from,
p_funding_available_to,
p_notes,
p_case_folder_id,
p_asset_class_code,
p_asset_type_code ,
p_description ,
p_quantity,
p_uom_code,
p_reference_type,
p_appraiser ,
p_appraiser_phone,
p_valuation ,
p_valuation_method_code,
p_valuation_date ,
p_acquisition_date,
p_asset_identifier,
p_party_id,
p_contact_party_id
);