[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_dist (p_invoice_id IN number,
p_Line_Type IN varchar2,
p_GL_Date IN date,
p_Period_Name IN varchar2,
p_Type_1099 IN varchar2,
p_Income_Tax_Region IN varchar2,
p_Amount IN number,
p_Vat_Code IN varchar2,
p_Code_Combination_Id IN number,
p_PA_Quantity IN number,
p_Description IN varchar2,
-- Bug 1105325. Passing the project info.
p_Project_Acct_Cont IN varchar2,
p_Project_Id IN number,
p_Task_Id IN number,
p_Expenditure_Type IN varchar2,
p_Expenditure_Org_Id IN number,
p_Exp_item_date IN date,
--Bug# 763539 . Passin the attribute category and the attributes
p_Attribute_Category IN varchar2,
p_Attribute1 IN varchar2,
p_Attribute2 IN varchar2,
p_Attribute3 IN varchar2,
p_Attribute4 IN varchar2,
p_Attribute5 IN varchar2,
p_Attribute6 IN varchar2,
p_Attribute7 IN varchar2,
p_Attribute8 IN varchar2,
p_Attribute9 IN varchar2,
p_Attribute10 IN varchar2,
p_Attribute11 IN varchar2,
p_Attribute12 IN varchar2,
p_Attribute13 IN varchar2,
p_Attribute14 IN varchar2,
p_Attribute15 IN varchar2,
--backport. Exists in 11i but not in 11.0
p_invoice_distribution_id IN number,
p_Tax_Code_Id IN NUMBER,
p_tax_recoverable_flag IN varchar2,
p_tax_recovery_rate IN number,
p_tax_code_override_flag IN varchar2,
p_tax_recovery_override_flag IN varchar2,
p_po_distribution_id IN number,
--end backport.
p_Calling_Sequence IN varchar2,
p_company_prepaid_invoice_id IN number DEFAULT NULL,
p_cc_reversal_flag IN varchar2 DEFAULT NULL)
IS
BEGIN
NULL;
AP_INVOICE_DISTRIBUTIONS_PKG.insert_dist(
X_invoice_id => p_invoice_Id,
X_invoice_distribution_id => null,
X_Line_Type => p_Line_Type,
X_GL_Date => p_gl_Date,
X_Period_Name => p_period_Name,
X_Type_1099 => null,
X_Income_Tax_Region => null,
X_Amount => -(p_Amount),
X_Tax_Code_Id => null,
X_Code_Combination_Id => p_code_combination_id,
X_PA_Quantity => null,
X_Description => null,
X_tax_recoverable_flag => null,
X_tax_recovery_rate => null,
X_tax_code_override_flag => null,
X_tax_recovery_override_flag => null,
X_po_distribution_id => null,
X_Attribute_Category => null,
X_Attribute1 => null,
X_Attribute2 => null,
X_Attribute3 => null,
X_Attribute4 => null,
X_Attribute5 => null,
X_Attribute6 => null,
X_Attribute7 => null,
X_Attribute8 => null,
X_Attribute9 => null,
X_Attribute10 => null,
X_Attribute11 => null,
X_Attribute12 => null,
X_Attribute13 => null,
X_Attribute14 => null,
X_Attribute15 => null,
X_Calling_Sequence => p_calling_sequence,
X_company_prepaid_invoice_id => p_company_prepaid_invoice_id,
X_cc_reversal_flag => 'Y');
FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_WEB_WRAPPER_PKG.insert_dist');
END insert_dist;
Create an ame_util.approverInsertionsTable containing 1 approver
insertion record with the employee_id set to l_curr_approver_id,
api_insertion set to 'Y', and authority set to 'Y' and passing the
table to ame_api.insertApprovers.
*/
l_debug_info VARCHAR2(200);
l_recApprover.api_insertion := ame_util.apiAuthorityInsertion; -- 'A'
l_debug_info := 'Done Calling AME_API.insertApprovers';
/*Call AME UpdateApprovalStatus2 api to let AME know the
expense report is rejected */
------------------------------------------------------
l_debug_info := 'Call AMEs updateApprovalAtatus api';
AME_API.updateApprovalStatus2(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
transactionIdIn => p_item_key,
approvalStatusIn => AME_UTIL.rejectStatus,
approverPersonIdIn => l_approver_id,
approverUserIdIn => NULL,
transactionTypeIn => p_item_type);
/*Call AME UpdateApprovalStatus api to let AME know the
expense report is forwarded */
------------------------------------------------------
l_debug_info := 'Call AMEs updateApprovalStatus api';
AME_API.updateApprovalStatus2(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
transactionIdIn => p_item_key,
approvalStatusIn => ame_util.noResponseStatus,
approverPersonIdIn => l_forward_from_id,
approverUserIdIn => NULL,
transactionTypeIn => p_item_type,
forwardeeIn => l_recApprover);
AME_API2.updateApprovalStatus2(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
transactionTypeIn => p_item_type,
transactionIdIn => l_itemkey,
approvalStatusIn => ame_util.noResponseStatus,
approverNameIn => l_forward_from_name,
forwardeeIn => l_recApprover);