[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_Invoice_Payment_Id IN Number Default null,
P_Check_Id IN Number Default null)
RETURN NUMBER
IS
l_country_code Varchar2(10);
SELECT DISTINCT Org_Id
into l_ou_id
FROM AP_SELECTED_INVOICES_ALL
WHERE checkrun_name = P_Checkrun_Name
AND checkrun_id = P_Checkrun_id;
P_Last_Updated_By,
P_Last_Update_Login,
P_Program_Application_Id,
P_Program_Id,
P_Request_Id,
l_awt_success,
P_Invoice_Payment_Id,
P_Check_Id);
P_Last_Updated_By,
P_Last_Update_Login,
P_Program_Application_Id,
P_Program_Id,
P_Request_Id,
l_awt_success);
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_Dist_Line_No IN Number Default null,
P_New_Invoice_Id IN Number Default null,
P_New_Dist_Line_No IN Number Default null)
RETURN NUMBER
IS
l_country_code Varchar2(10);
P_Last_Updated_By,
P_Last_Update_Login,
P_Program_Application_Id,
P_Program_Id,
P_Request_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)
RETURN NUMBER
IS
l_country_code Varchar2(10);
P_Last_Updated_By,
P_Last_Update_Login,
P_Program_Application_Id,
P_Program_Id,
P_Request_Id);
* Name : Jg_Extended_Insert_Dist *
* Purpose : Regional Extended Routine for Insertion *
* *
**************************************************************************/
PROCEDURE JG_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_country_code Varchar2(10);
Jl_Zz_Ap_Withholding_Pkg.Jl_Zz_Ap_Ext_Insert_Dist
(P_Invoice_Id,
P_Invoice_Distribution_id, -- Add new column
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, -- Add new column
P_Code_Combination_Id,
P_PA_Quantity,
P_Description,
P_tax_recoverable_flag, -- Add new Column
P_tax_recovery_rate, -- Add new Column
P_tax_code_override_flag, -- Add new Column
P_tax_recovery_override_flag, -- Add new Column
P_po_distribution_id, -- Add new Column
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 JG_EXTENDED_INSERT_DIST;
* Purpose : Regional Extended Routine for Insertion on Prepay line *
* *
**************************************************************************/
FUNCTION Jg_Ext_Withholding_Prepay
(P_prepay_dist_id IN Number,
P_invoice_id IN Number,
-- Bug 4559474 : R12 KI
P_inv_dist_id IN Number,
P_user_id IN Number,
P_last_update_login IN Number,
P_calling_sequence IN Varchar2
)
RETURN NUMBER
IS
l_country_code VARCHAR2(10);
P_last_update_login,
P_calling_sequence
);