[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
P_Last_Updated_By IN Number,
P_Last_Update_Login IN Number,
P_Program_Application_Id IN Number Default null,
P_Program_Id IN Number Default null,
P_Request_Id IN Number Default null,
P_Awt_Success OUT NOCOPY Varchar2,
P_Invoice_Payment_Id IN Number Default null,
P_Check_Id IN Number Default null,
p_checkrun_id in number default null)
IS
l_return_value NUMBER := 0;
,P_Last_Updated_By
,P_Last_Update_Login
,P_Program_Application_Id
,P_Program_Id
,P_Request_Id
,P_Invoice_Payment_Id
,P_Check_Id);
P_Last_Updated_By IN Number,
P_Last_Update_Login IN Number,
P_Program_Application_Id IN Number Default null,
P_Program_Id IN Number Default null,
P_Request_Id IN Number Default null,
P_Awt_Success OUT NOCOPY Varchar2 ,
P_Dist_Line_No IN Number Default null,
P_New_Invoice_Id IN Number Default null,
P_New_Dist_Line_No IN Number Default null)
IS
l_return_value NUMBER := 0;
,P_Last_Updated_By
,P_Last_Update_Login
,P_Program_Application_Id
,P_Program_Id
,P_Request_Id
,P_Dist_Line_No
,P_New_Invoice_Id
,P_New_Dist_Line_No);
P_Last_Updated_By IN Number,
P_Last_Update_Login IN Number,
P_Program_Application_Id IN Number Default null,
P_Program_Id IN Number Default null,
P_Request_Id IN Number Default null,
P_Awt_Success OUT NOCOPY Varchar2,
P_checkrun_id in number default null)
IS
l_return_value NUMBER := 0;
,P_Last_Updated_By
,P_Last_Update_Login
,P_Program_Application_Id
,P_Program_Id
,P_Request_Id);
* Name : Ap_Extended_Insert_Dist *
* Purpose : This is a dummy procedure which will verify whether the *
* Regional Extended Package is installed (JG_EXTENDED_ *
* WITHHOLDING_PKG). If installed, then the routine to *
* insert distribution lines will be executed dynamically. *
* *
**************************************************************************/
PROCEDURE Ap_Extended_Insert_Dist
(P_Invoice_Id IN Number,
P_Invoice_Distribution_id IN Number, -- Add new Column
P_Distribution_Line_Number 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_Tax_Code_ID IN Number, -- Add new Column
P_Code_Combination_Id IN Number,
P_PA_Quantity IN Number,
P_Description IN Varchar2,
P_tax_recoverable_flag IN Varchar2, -- Add new Column
P_tax_recovery_rate IN Number, -- Add new Column
P_tax_code_override_flag IN Varchar2, -- Add new Column
P_tax_recovery_override_flag IN Varchar2, -- Add new Column
P_po_distribution_id IN Number, -- Add new Column
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,
P_Calling_Sequence IN Varchar2)
IS
l_Calling_Sequence VARCHAR2(150);
JG_EXTENDED_WITHHOLDING_PKG.Jg_Extended_Insert_Dist
(P_Invoice_Id
,P_Invoice_Distribution_id
,P_Distribution_Line_Number
,P_Line_Type
,P_GL_Date
,P_Period_Name
,P_Type_1099
,P_Income_Tax_Region
,P_Amount
,P_Tax_Code_ID
,P_Code_Combination_Id
,P_PA_Quantity
,P_Description
,P_Tax_Recoverable_Flag
,P_Tax_recovery_rate
,P_Tax_code_override_flag
,P_Tax_recovery_override_flag
,P_Po_distribution_id
,P_Attribute_Category
,P_Attribute1
,P_Attribute2
,P_Attribute3
,P_Attribute4
,P_Attribute5
,P_Attribute6
,P_Attribute7
,P_Attribute8
,P_Attribute9
,P_Attribute10
,P_Attribute11
,P_Attribute12
,P_Attribute13
,P_Attribute14
,P_Attribute15
,P_Calling_Sequence);
END Ap_Extended_Insert_Dist;
P_last_update_login IN Number,
P_calling_sequence IN Varchar2)
IS
l_return_value NUMBER := 0;
,P_last_update_login
,l_calling_sequence);
SELECT 'EXIST' Awt
FROM ap_invoice_distributions apid
,jl_zz_ap_inv_dis_wh jid
,jl_zz_ap_sup_awt_cd jsw
,ap_tax_codes apc
WHERE apid.invoice_distribution_id = P_Invoice_Distribution_Id
AND apid.invoice_id = jid.invoice_id
AND apid.distribution_line_number= jid.distribution_line_number
AND jid.supp_awt_code_id = jsw.supp_awt_code_id
AND apc.tax_id = jsw.tax_id
AND apc.name = P_Tax_Name
AND nvl(apid.global_attribute2,-1) = nvl(P_Global_Attribute2,-1);