The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT min(object_approval_id)
FROM aso_apr_obj_approvals
WHERE object_id = (SELECT object_id
FROM aso_apr_obj_approvals
WHERE object_approval_id = P_Object_approval_id)
AND approval_status = 'PEND';
PROCEDURE update_approval_status (
p_update_header_or_detail_flag IN VARCHAR2,
p_object_approval_id IN NUMBER,
p_approval_det_id IN NUMBER,
p_status IN VARCHAR2,
note IN VARCHAR2
) is
pragma AUTONOMOUS_TRANSACTION;
'Start update_approval_status procedure ',
1,
'N'
);
'Flag is :' || p_update_header_or_detail_flag,
1,
'N'
);
IF p_update_header_or_detail_flag = 'HEADER' THEN
select nvl(object_version_number,0) into l_object_version_number
from aso_apr_obj_approvals
where object_approval_id=p_object_approval_id;
UPDATE aso_apr_obj_approvals
SET approval_status = p_status,
object_version_number = l_object_version_number,
last_update_date = SYSDATE,
last_updated_by = g_user_id,
last_update_login = g_user_id
WHERE object_approval_id = p_object_approval_id;
UPDATE aso_apr_obj_approvals
SET approval_status = p_status,
object_version_number = l_object_version_number,
last_update_date = SYSDATE,
end_date = SYSDATE,
last_updated_by = g_user_id,
last_update_login = g_user_id
WHERE object_approval_id = p_object_approval_id;
IF p_update_header_or_detail_flag = 'DETAIL' THEN
UPDATE aso_apr_approval_details
SET approver_status = p_status,
date_received = SYSDATE,
last_update_date = SYSDATE,
approver_comments = note,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.user_id
WHERE approval_det_id = p_approval_det_id;
'End update_approval_status procedure ',
1,
'N'
);
end update_approval_status;
SELECT DISTINCT object_id, object_type, application_id
FROM aso_apr_obj_approvals aoa
WHERE object_approval_id = c_object_approval_id;
-- inserting rule details
ame_api3.getApplicableRules1(applicationIdIn =>l_application_id,
transactionTypeIn =>l_object_type,
transactionIdIn => l_object_id,
ruleIdsOut => x_rules_list_id);
insertruledetails(approvalid => l_approval_id,
p_rule_list_ids=> x_rules_list_id);
update_approval_status (
p_update_header_or_detail_flag => 'HEADER' ,
p_object_approval_id => l_approval_id,
p_approval_det_id =>null,
p_status => 'REJ',
note => null);
update_entity(
p_object_approval_id => l_approval_id,
p_status => 'REJECT');
SELECT quote_name, quote_number,org_id,quote_header_id
FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
WHERE qha.quote_header_id = aoa.object_id
AND aoa.object_approval_id = c_approval_id;
select nvl(fnd_profile.value('ASO_QUOTE_APPROVER_RESP'),-1) into l_resp_id from dual; -- bug 7657061
SELECT aso_apr_obj_det_s.NEXTVAL into l_approval_detail_id FROM sys.dual;
/* insert to approver record here since all information is available here
--------------------------------------------------------------------------------------- */
insertapprovershistory
(l_approval_det_id => l_approval_detail_id,
l_approval_id => l_approval_id,
l_approver_person_id => l_next_approver_id,
l_approver_user_id => l_next_fnd_usr_id,
l_order_number => g_next_approvers(l_approver_index).approver_order_number,
l_NAME => g_next_approvers(l_approver_index).name,
l_ITEM_CLASS => g_next_approvers(l_approver_index).item_class,
l_ITEM_ID => g_next_approvers(l_approver_index).item_id,
l_ACTION_TYPE_ID => g_next_approvers(l_approver_index).action_type_id, --ACTION_TYPE_ID
l_GROUP_OR_CHAIN_ID => g_next_approvers(l_approver_index).group_or_chain_id,
L_OCCURRENCE => g_next_approvers(l_approver_index).occurrence,
L_AUTHORITY => g_next_approvers(l_approver_index).authority ,
l_APPROVER_CATEGORY => g_next_approvers(l_approver_index).approver_category);
g_next_approvers.delete;
PROCEDURE update_Action_history_approve (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
l_approval_det_id NUMBER;
'Begin update_Action_history_approve Procedure ',
1,
'N'
);
'Calling the update table procedure setting approver status to APPR',
1,
'N'
);
update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'APPR',
note => l_note);
'Exception in update_Action_history_approve Procedure SqlCode :' || SQLERRM,
1,
'N'
);
END update_Action_history_approve;
PROCEDURE update_Action_history_reject (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
l_approval_det_id NUMBER;
'Start of update_Action_history_REJECTED Procedure',
1,
'N'
);
'Calling the update table procedure setting approver status to REJ',
1,
'N'
);
update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'REJ',
note => l_note);
'End of update_Action_history_rejected Procedure',
1,
'N'
);
END update_action_history_reject;
PROCEDURE update_action_history_timedout (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
l_approval_det_id NUMBER;
'begin update_action_history_timedout Procedure',
1,
'N'
);
'Calling the update table procedure setting approver status to TOUT',
1,
'N'
);
update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'TOUT',
note => l_note);
'End of update_action_history_timedout Procedure',
1,
'N'
);
END update_action_history_timedout;
select name,item_class, item_id,action_type_id,group_or_chain_id,OCCURRENCE
from aso_apr_approval_details
where APPROVAL_DET_ID =l_approval_det_id;
SELECT DISTINCT object_id, object_type, application_id
FROM aso_apr_obj_approvals aoa
WHERE object_approval_id = c_object_approval_id;
ame_api2.updateApprovalStatus2(
applicationIdIn=>l_application_id,
transactionIdIn=>l_object_id,
transactionTypeIn=>l_object_type,
approvalStatusIn => l_current_approver.approval_status,
approverNameIn=>l_current_approver.name,
itemClassIn=> l_current_approver.item_class,
itemIdIn=> l_current_approver.item_id,
actionTypeIdIn=> l_current_approver.action_type_id,
groupOrChainIdIn=> l_current_approver.group_or_chain_id,
occurrenceIn=> l_current_approver.occurrence
);
SELECT wfi.item_type, wfi.item_key
FROM wf_items wfi, wf_item_activity_statuses wfias
WHERE wfi.parent_item_key = p_itemkey
AND wfi.item_type = p_itemtype
AND wfi.parent_item_type = p_itemtype
AND wfias.item_type = wfi.item_type
AND wfias.item_key = wfi.item_key
AND wfias.activity_status = 'NOTIFIED'
AND wfias.notification_id IS NOT NULL
AND wfi.item_key <> itemkey;
SELECT parent_item_type, parent_item_key
INTO l_parent_item_type, l_parent_item_key
FROM wf_items
WHERE item_type = itemtype AND item_key = itemkey;
AND approverlist (i).api_insertion = ame_util.oamgenerated
AND approverlist (i).group_or_chain_id =l_current_appr_group_id)
THEN
-- pp_debug('In beat by first resp group_or_chain_id'||approverlist (i).group_or_chain_id);
select name into l_child_username
from aso_apr_approval_details
where approval_det_id=l_approval_det_id;
SELECT count(*)
INTO l_abort
FROM wf_item_attribute_values
WHERE item_type = l_child_wf_cur.item_type
AND NAME = 'RECEIVER_USERNAME'
AND text_value = l_child_username
AND item_key = l_child_wf_cur.item_key;
aso_pa_apr_wf_pvt.update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'NR',
note => l_note);
aso_pa_apr_wf_pvt.update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'NR',
note => l_note);
SELECT parent_item_type, parent_item_key
INTO l_parent_item_type, l_parent_item_key
FROM wf_items
WHERE item_type = itemtype
AND item_key = itemkey;
SELECT parent_item_type, parent_item_key
INTO l_parent_item_type, l_parent_item_key
FROM wf_items
WHERE item_type = itemtype
AND item_key = itemkey;
SELECT parent_item_type, parent_item_key
INTO l_parent_item_type, l_parent_item_key
FROM wf_items
WHERE item_type = itemtype
AND item_key = itemkey;
PROCEDURE update_Action_history_pending(
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2)
IS
l_approval_det_id number;
l_api_name VARCHAR2(500) := 'update_Action_history_pending';
select nvl(APPROVER_CATEGORY,'A')
into l_approver_category
from ASO_APR_APPROVAL_DETAILS
where APPROVAL_DET_ID=l_approval_det_id;
update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'PEND',
note => null);
update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'NR',
note => null);
'Exception in update_Action_history_pending Procedure SqlCode :' || SQLERRM,
1,
'N'
);
'update_Action_history_pending',
itemtype,
itemkey,
TO_CHAR (
actid
),
funcmode
);
END update_Action_history_pending;
PROCEDURE update_Action_history_fyi(
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2)
IS
l_approval_det_id number;
l_api_name VARCHAR2(500) := 'update_Action_history_fyi';
update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'NR',
note => null);
'Exception in update_Action_history_fyi Procedure SqlCode :' || SQLERRM,
1,
'N'
);
'update_Action_history_fyi',
itemtype,
itemkey,
TO_CHAR (
actid
),
funcmode
);
END update_Action_history_fyi;
PROCEDURE update_entity(
p_object_approval_id IN NUMBER,
--p_approval_det_id IN NUMBER,
p_status IN VARCHAR2) AS
l_contract_approval_level VARCHAR2 (240);
SELECT object_id
FROM aso_apr_obj_approvals
WHERE object_approval_id = c_object_approval_id;
SELECT contract_approval_level
FROM aso_quote_headers_all
WHERE quote_header_id = c_quote_header_id;
SELECT last_update_date,org_id
FROM aso_quote_headers_all
WHERE quote_header_id = c_quote_header_id;
SELECT quote_status_id
FROM aso_quote_statuses_b
WHERE status_code = v_status;
SELECT approver_person_id,approver_user_id
FROM aso_apr_approval_details
WHERE object_approval_id = c_object_approval_id
AND approver_sequence = (select max(approver_sequence)
FROM aso_apr_approval_details
WHERE object_approval_id = c_object_approval_id)
and rownum=1;
SELECT user_id
FROM fnd_user
WHERE employee_id = c_employee_id;
SELECT approver_person_id,approver_user_id
FROM aso_apr_approval_details
WHERE object_approval_id = c_object_approval_id
AND approver_status = 'REJ';
'Begin Update Entity Procedure ',
1,
'N'
);
FETCH get_latest_date INTO l_quote_header_rec.last_update_date, l_quote_header_rec.org_id;
'Before calling update quote: Setting the single org context to org_id: '|| l_quote_header_rec.org_id,
1,
'N'
);
'Calling the update quote API in ASO_UPDATE_QUOTE_PUB package ',
1,
'N'
);
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_control_rec => l_control_rec,
p_qte_header_rec => l_quote_header_rec,
p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,
p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
x_qte_header_rec => x_qte_header_rec,
x_qte_line_tbl => x_qte_line_tbl,
x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,
x_hd_payment_tbl => x_hd_payment_tbl,
x_hd_shipment_tbl => x_hd_shipment_tbl,
x_hd_freight_charge_tbl => x_hd_freight_charge_tbl,
x_hd_tax_detail_tbl => x_hd_tax_detail_tbl,
x_line_attr_ext_tbl => x_line_attr_ext_tbl,
x_line_rltship_tbl => x_line_rltship_tbl,
x_price_adjustment_tbl => x_price_adjustment_tbl,
x_price_adj_attr_tbl => x_price_adj_attr_tbl,
x_price_adj_rltship_tbl => x_price_adj_rltship_tbl,
x_ln_price_attributes_tbl => x_ln_price_attributes_tbl,
x_ln_payment_tbl => x_ln_payment_tbl,
x_ln_shipment_tbl => x_ln_shipment_tbl,
x_ln_freight_charge_tbl => x_ln_freight_charge_tbl,
x_ln_tax_detail_tbl => x_ln_tax_detail_tbl,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
'Return Status from update quote API is :' || x_return_status,
1,
'N'
);
--RAISE update_quote_exception;
'After calling update quote Setting the org context to multi-org org_id:null',
1,
'N'
);
'End update entity procedure ',
1,
'N'
);
'Exception in update entity ',
1,
'N'
);
'Exception in update entity ',
1,
'N'
);
'Exception in update entity ',
1,
'N'
);
END UPDATE_ENTITY;
SELECT wfi.item_type, wfi.item_key
FROM wf_items wfi, wf_item_activity_statuses wfias
WHERE wfi.parent_item_key = p_itemkey
AND wfi.item_type = p_itemtype
AND wfi.parent_item_type = p_itemtype
AND wfias.item_type = wfi.item_type
AND wfias.item_key = wfi.item_key
AND wfias.activity_status = 'NOTIFIED'
AND wfias.notification_id IS NOT NULL;
SELECT aoa.requester_userid, fu.employee_id
FROM aso_apr_obj_approvals aoa, fnd_user fu
WHERE object_approval_id = l_approval_id
AND aoa.requester_userid = fu.user_id
AND SYSDATE BETWEEN fu.start_date AND NVL (
fu.end_date,
SYSDATE
);
SELECT user_name
FROM fnd_user
WHERE user_id = l_user_id;
select object_id into l_object_id
from aso_apr_obj_approvals
where object_approval_id=approval_id
and approval_Status='PEND';
aso_pa_apr_wf_pvt.update_approval_status (
p_update_header_or_detail_flag => 'HEADER' ,
p_object_approval_id => approval_id,
p_approval_det_id =>null,
p_status => 'CAN',
note => null);
aso_pa_apr_wf_pvt.update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'CAN',
note => null);
aso_pa_apr_wf_pvt.update_approval_status (
p_update_header_or_detail_flag => 'DETAIL' ,
p_object_approval_id => null,
p_approval_det_id =>l_approval_det_id,
p_status => 'CAN',
note => null);
PROCEDURE UPDATE_ENTITY_REJECT (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
l_approval_id NUMBER;
'Begin UPDATE_ENTITY_REJECT Procedure ',
1,
'N'
);
aso_debug_pub.ADD ('Calling the update entity procedure setting quote status to REJECTED',1,'N' );
update_approval_status (
p_update_header_or_detail_flag => 'HEADER' ,
p_object_approval_id => l_approval_id,
p_approval_det_id =>null,
p_status => 'REJ',
note => null);
update_entity(
p_object_approval_id => l_approval_id,
-- p_approval_det_id => NULL,
p_status => 'REJECT');
aso_debug_pub.ADD ('End of UPDATE_ENTITY_REJECT Procedure',1,'N');
'Exception in UPDATE_ENTITY_REJECT Procedure SqlCode :' || SQLERRM,
1,
'N'
);
'UPDATE_ENTITY_REJECT',
itemtype,
itemkey,
TO_CHAR (
actid
),
funcmode
);
END UPDATE_ENTITY_REJECT;
PROCEDURE UPDATE_ENTITY_approved (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
l_approval_id NUMBER;
'Begin update_Action_history_approved Procedure ',
1,
'N'
);
aso_debug_pub.ADD ('Calling the update entity procedure setting quote status to APPROVED',1,'N' );
update_approval_status (
p_update_header_or_detail_flag => 'HEADER' ,
p_object_approval_id => l_approval_id,
p_approval_det_id =>null,
p_status => 'APPR',
note => null);
select count(*) into l_apr_count
from aso_apr_approval_details
where approver_category='A'
and object_approval_id=l_approval_id;
update_entity(
p_object_approval_id => l_approval_id,
-- p_approval_det_id => NULL,
p_status => 'APPROVE');
aso_debug_pub.ADD ('End of UPDATE_ENTITY_approve Procedure',1,'N');
'Exception in UPDATE_ENTITY_approve Procedure SqlCode :' || SQLERRM,
1,
'N'
);
'UPDATE_ENTITY_approve',
itemtype,
itemkey,
TO_CHAR (
actid
),
funcmode
);
END UPDATE_ENTITY_approved;
procedure insertapprovershistory
(l_approval_det_id IN number,
l_approval_id IN number,
l_approver_person_id IN number,
l_approver_user_id in number,
l_order_number IN number,
l_NAME IN VARCHAR2,
l_ITEM_CLASS IN VARCHAR2,
l_ITEM_ID IN VARCHAR2,
l_ACTION_TYPE_ID IN NUMBER,
l_GROUP_OR_CHAIN_ID IN NUMBER,
L_OCCURRENCE IN NUMBER,
L_AUTHORITY IN VARCHAR2,
l_APPROVER_CATEGORY IN VARCHAR2)
is
pragma AUTONOMOUS_TRANSACTION;
aso_apr_approvals_pkg.detail_insert_row (
l_approval_detail,
l_approval_id,
l_approver_person_id, --p_APPROVER_PERSON_ID
l_approver_user_id, --p_APPROVER_USER_ID
l_order_number, --p_approver_sequence
'PEND', -- p_APPROVER_STATUS
NULL -- p_APPROVER_COMMENTS
,
NULL -- p_DATE_SENT
,
NULL -- p_DATE_RECEIVED
,
SYSDATE -- p_CREATION_DATE
,
SYSDATE -- p_LAST_UPDATE_DATE
,
g_user_id -- P_CREATED_BY
,
g_user_id -- P_UPDATED_BY
,
fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
,
NULL -- p_ATTRIBUTE1
,
NULL -- p_ATTRIBUTE2
,
NULL -- p_ATTRIBUTE3
,
NULL -- p_ATTRIBUTE4
,
NULL -- p_ATTRIBUTE5
,
NULL -- p_ATTRIBUTE6
,
NULL -- p_ATTRIBUTE7
,
NULL -- p_ATTRIBUTE8
,
NULL -- p_ATTRIBUTE9
,
NULL -- p_ATTRIBUTE10
,
NULL -- p_ATTRIBUTE11
,
NULL -- p_ATTRIBUTE12
,
NULL -- p_ATTRIBUTE13
,
NULL -- p_ATTRIBUTE14
,
NULL -- p_ATTRIBUTE15
,
NULL -- p_Attribute16
,
NULL -- p_Attribute17
,
NULL -- p_Attribute18
,
NULL -- p_Attribute19
,
NULL -- p_Attribute20
,
NULL -- p_CONTEXT
,
NULL -- p_SECURITY_GROUP_ID
,
NULL, -- p_OBJECT_VERSION_NUMBER,
l_name, -- NAME
l_item_id, --ITEM_ID
l_item_class, --ITEM_CLASS
l_action_type_id, --ACTION_TYPE_ID
l_group_or_chain_id, --GROUP OR CHAIN ID
l_occurrence, -- occurrence
L_AUTHORITY, -- Authority
l_approver_category -- approver category
);
end insertapprovershistory;
procedure insertruledetails(approvalid number, p_rule_list_ids ame_util.idList) IS
pragma AUTONOMOUS_TRANSACTION;
delete from aso_apr_rules
where object_approval_id=approvalid;
aso_apr_approvals_pkg.rule_insert_row (
p_rule_id,
p_rule_list_ids (i),
null, --rule_action_id
SYSDATE -- P_CREATION_DATE
,
g_user_id -- P_CREATED_BY
,
SYSDATE -- p_LAST_UPDATE_DATE
,
g_user_id -- P_UPDATED_BY
,
fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
,
approvalid,
NULL -- p_ATTRIBUTE1
,
NULL -- p_ATTRIBUTE2
,
NULL -- p_ATTRIBUTE3
,
NULL -- p_ATTRIBUTE4
,
NULL -- p_ATTRIBUTE5
,
NULL -- p_ATTRIBUTE6
,
NULL -- p_ATTRIBUTE7
,
NULL -- p_ATTRIBUTE8
,
NULL -- p_ATTRIBUTE9
,
NULL -- p_ATTRIBUTE10
,
NULL -- p_ATTRIBUTE11
,
NULL -- p_ATTRIBUTE12
,
NULL -- p_ATTRIBUTE13
,
NULL -- p_ATTRIBUTE14
,
NULL -- p_ATTRIBUTE15
,
NULL -- p_Attribute16
,
NULL -- p_Attribute17
,
NULL -- p_Attribute18
,
NULL -- p_Attribute19
,
NULL -- p_Attribute20
,
NULL -- p_CONTEXT
,
NULL -- p_SECURITY_GROUP_ID
,
null -- p_OBJECT_VERSION_NUMBER
);
end insertruledetails;
select object_id into l_qte_header_id
from aso_apr_obj_approvals
where object_approval_id=l_approval_id;
select quote_name,quote_number into l_quote_name,l_qte_number
from aso_quote_headers_all
where quote_header_id=l_qte_header_id;
select nvl(fnd_profile.value('ASO_QUOTE_APPROVER_RESP'),-1) into l_resp_id from dual;