eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_AGREEMENT_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 511


FUNCTION check_add_update
	( 	p_funding_id       		IN 	NUMBER
		,p_funding_reference		IN 	VARCHAR2
 	)
RETURN VARCHAR2
IS
BEGIN
RETURN(PA_AGREEMENT_CORE.CHECK_ADD_UPDATE(	p_funding_id
						,p_funding_reference));

Line: 521


END check_add_update;

Line: 662


PROCEDURE summary_funding_insert_row
(p_agreement_id                 IN	NUMBER
 ,p_project_id			IN	NUMBER
 ,p_task_id			IN	NUMBER
 ,p_login_id			IN	VARCHAR2
 ,p_user_id			IN	VARCHAR2
 )
IS
BEGIN
PA_FUNDING_CORE.SUMMARY_FUNDING_INSERT_ROW(	p_agreement_id
 ,p_project_id
 ,p_task_id
 ,p_login_id
 ,p_user_id
 ,'DRAFT');

Line: 677


END summary_funding_insert_row;

Line: 692


PROCEDURE summary_funding_update_row
(p_agreement_id                 IN	NUMBER
 ,p_project_id			IN	NUMBER
 ,p_task_id			IN	NUMBER
 ,p_login_id			IN	VARCHAR2
 ,p_user_id			IN	VARCHAR2
 )
IS
BEGIN
-- dbms_output.put_line('Inside: PA_AGREEMENT_UTILS.SUMMARY_FUNDING_UPDATE_ROW');

Line: 702


PA_FUNDING_CORE.SUMMARY_FUNDING_UPDATE_ROW(	p_agreement_id
 ,p_project_id
 ,p_task_id
 ,p_login_id
 ,p_user_id
 ,'DRAFT');

Line: 708


END summary_funding_update_row;

Line: 720


PROCEDURE summary_funding_delete_row
(p_agreement_id                 IN	NUMBER
 ,p_project_id			IN	NUMBER
 ,p_task_id			IN	NUMBER
 ,p_login_id			IN	VARCHAR2
 ,p_user_id			IN	VARCHAR2
 )
IS
BEGIN
PA_FUNDING_CORE.SUMMARY_FUNDING_DELETE_ROW(	p_agreement_id
,p_project_id
 ,p_task_id
,p_login_id
 ,p_user_id
,'DRAFT');

Line: 735


END summary_funding_delete_row;

Line: 932


           p_Last_Update_Date               IN DATE,
           p_Last_Updated_By                IN NUMBER,
           p_Creation_Date                  IN DATE,
           p_Created_By                     IN NUMBER,
           p_Last_Update_Login              IN NUMBER,
           p_Owned_By_Person_Id             IN NUMBER,
           p_Term_Id                        IN NUMBER,
           p_Revenue_Limit_Flag             IN VARCHAR2,
           p_Amount                         IN NUMBER,
           p_Description                    IN VARCHAR2,
           p_Expiration_Date                IN DATE,
           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_Template_Flag                  IN VARCHAR2,
           p_pm_agreement_reference         IN VARCHAR2,
           p_pm_product_code                IN VARCHAR2,
           p_agreement_currency_code        IN VARCHAR2 DEFAULT NULL,
           p_owning_organization_id         IN NUMBER   DEFAULT NULL,
           p_invoice_limit_flag             IN VARCHAR2 DEFAULT NULL,
           p_customer_order_number          IN VARCHAR2 DEFAULT NULL,
           p_advance_required               IN VARCHAR2 DEFAULT NULL,
           p_start_date                     IN DATE     DEFAULT NULL,
           p_billing_sequence               IN NUMBER   DEFAULT NULL,
           p_line_of_account                IN VARCHAR2 DEFAULT NULL,
           p_Attribute11                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute12                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute13                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute14                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute15                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute16                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute17                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute18                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute19                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute20                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute21                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute22                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute23                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute24                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute25                    IN VARCHAR2 DEFAULT NULL)
IS
np_p_Agreement_Id Number :=p_Agreement_Id; /*file.sql.39*/

Line: 990


        p_last_update_date              =>       p_last_update_date,
        p_last_updated_by               =>       p_last_updated_by,
        p_creation_date                 =>       p_creation_date,
        p_created_by                    =>       p_created_by,
        p_last_update_login             =>       p_last_update_login,
        p_owned_by_person_id            =>       p_owned_by_person_id,
        p_term_id                       =>       p_term_id,
        p_revenue_limit_flag            =>       p_revenue_limit_flag,
        p_amount                        =>       p_amount,
        p_description                   =>       p_description,
        p_expiration_date               =>       p_expiration_date,
        p_attribute_category            =>       p_attribute_category,
        p_attribute1                    =>       p_attribute1,
        p_attribute2                    =>       p_attribute2,
        p_attribute3                    =>       p_attribute3,
        p_attribute4                    =>       p_attribute4,
        p_attribute5                    =>       p_attribute5,
        p_attribute6                    =>       p_attribute6,
        p_attribute7                    =>       p_attribute7,
        p_attribute8                    =>       p_attribute8,
        p_attribute9                    =>       p_attribute9,
        p_attribute10                   =>       p_attribute10,
        p_template_flag                 =>       p_template_flag,
        p_pm_agreement_reference        =>       p_pm_agreement_reference,
        p_pm_product_code               =>       p_pm_product_code,
        p_owning_organization_id        =>       p_owning_organization_id,
        p_agreement_currency_code       =>       p_agreement_currency_code,
        p_invoice_limit_flag            =>       p_invoice_limit_flag,
        p_customer_order_number         =>       p_customer_order_number,
        p_advance_required              =>       p_advance_required,
        p_start_date                    =>       p_start_date,
        p_billing_sequence              =>       p_billing_sequence,
        p_line_of_account               =>       p_line_of_account,
        p_attribute11                   =>       p_attribute11,
        p_attribute12                   =>       p_attribute12,
        p_attribute13                   =>       p_attribute13,
        p_attribute14                   =>       p_attribute14,
        p_attribute15                   =>       p_attribute15,
        p_attribute16                   =>       p_attribute16,
        p_attribute17                   =>       p_attribute17,
        p_attribute18                   =>       p_attribute18,
        p_attribute19                   =>       p_attribute19,
        p_attribute20                   =>       p_attribute20,
        p_attribute21                   =>       p_attribute21,
        p_attribute22                   =>       p_attribute22,
        p_attribute23                   =>       p_attribute23,
        p_attribute24                   =>       p_attribute24,
        p_attribute25                   =>       p_attribute25
         );

Line: 1076


PROCEDURE Delete_agreement(p_agreement_id IN NUMBER )
IS
BEGIN
PA_AGREEMENT_CORE.DELETE_AGREEMENT(p_agreement_id);

Line: 1080


END Delete_agreement;

Line: 1096


 PROCEDURE Update_agreement(
           p_Agreement_Id               IN      NUMBER,
           p_Customer_Id                IN      NUMBER,
           p_Agreement_Num              IN      VARCHAR2,
           p_Agreement_Type             IN      VARCHAR2,
           p_Last_Update_Date           IN      DATE,
           p_Last_Updated_By            IN      NUMBER,
           p_Last_Update_Login          IN      NUMBER,
           p_Owned_By_Person_Id         IN      NUMBER,
           p_Term_Id                    IN      NUMBER,
           p_Revenue_Limit_Flag         IN      VARCHAR2,
           p_Amount                     IN      NUMBER,
           p_Description                IN      VARCHAR2,
           p_Expiration_Date            IN      DATE,
           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_Template_Flag              IN      VARCHAR2,
           p_pm_agreement_reference     IN      VARCHAR2,
           p_pm_product_code            IN      VARCHAR2,
           p_agreement_currency_code    IN      VARCHAR2 DEFAULT NULL,
           p_owning_organization_id     IN      NUMBER  DEFAULT NULL,
           p_invoice_limit_flag         IN      VARCHAR2 DEFAULT NULL,
           p_customer_order_number          IN VARCHAR2 DEFAULT NULL,
           p_advance_required               IN VARCHAR2 DEFAULT NULL,
           p_start_date                     IN DATE     DEFAULT NULL,
           p_billing_sequence               IN NUMBER   DEFAULT NULL,
           p_line_of_account                IN VARCHAR2 DEFAULT NULL,
           p_Attribute11                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute12                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute13                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute14                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute15                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute16                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute17                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute18                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute19                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute20                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute21                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute22                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute23                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute24                    IN VARCHAR2 DEFAULT NULL,
           p_Attribute25                    IN VARCHAR2 DEFAULT NULL)
 IS
 BEGIN
 -- dbms_output.put_line('Inside: pa_agreement_utils.update_agreement');

Line: 1150


 PA_AGREEMENT_CORE.UPDATE_AGREEMENT(
        p_agreement_id                  =>       p_agreement_id,
        p_customer_id                   =>       p_customer_id,
        p_agreement_num                 =>       p_agreement_num,
        p_agreement_type                =>       p_agreement_type,
        p_last_update_date              =>       p_last_update_date,
        p_last_updated_by               =>       p_last_updated_by,
        p_last_update_login             =>       p_last_update_login,
        p_owned_by_person_id            =>       p_owned_by_person_id,
        p_term_id                       =>       p_term_id,
        p_revenue_limit_flag            =>       p_revenue_limit_flag,
        p_amount                        =>       p_amount,
        p_description                   =>       p_description,
        p_expiration_date               =>       p_expiration_date,
        p_attribute_category            =>       p_attribute_category,
        p_attribute1                    =>       p_attribute1,
        p_attribute2                    =>       p_attribute2,
        p_attribute3                    =>       p_attribute3,
        p_attribute4                    =>       p_attribute4,
        p_attribute5                    =>       p_attribute5,
        p_attribute6                    =>       p_attribute6,
        p_attribute7                    =>       p_attribute7,
        p_attribute8                    =>       p_attribute8,
        p_attribute9                    =>       p_attribute9,
        p_attribute10                   =>       p_attribute10,
        p_template_flag                 =>       p_template_flag,
        p_pm_agreement_reference        =>       p_pm_agreement_reference,
        p_pm_product_code               =>       p_pm_product_code,
        p_owning_organization_id        =>       p_owning_organization_id,
        p_agreement_currency_code       =>       p_agreement_currency_code,
        p_invoice_limit_flag            =>       p_invoice_limit_flag,
        p_customer_order_number         =>       p_customer_order_number,
        p_advance_required              =>       p_advance_required,
        p_start_date                    =>       p_start_date,
        p_billing_sequence              =>       p_billing_sequence,
        p_line_of_account               =>       p_line_of_account,
        p_attribute11                   =>       p_attribute11,
        p_attribute12                   =>       p_attribute12,
        p_attribute13                   =>       p_attribute13,
        p_attribute14                   =>       p_attribute14,
        p_attribute15                   =>       p_attribute15,
        p_attribute16                   =>       p_attribute16,
        p_attribute17                   =>       p_attribute17,
        p_attribute18                   =>       p_attribute18,
        p_attribute19                   =>       p_attribute19,
        p_attribute20                   =>       p_attribute20,
        p_attribute21                   =>       p_attribute21,
        p_attribute22                   =>       p_attribute22,
        p_attribute23                   =>       p_attribute23,
        p_attribute24                   =>       p_attribute24,
        p_attribute25                   =>       p_attribute25);

Line: 1202


 END update_agreement;

Line: 1221


            p_Last_Update_Date        IN     DATE,
            p_Last_Updated_By         IN     NUMBER,
            p_Creation_Date           IN     DATE,
            p_Created_By              IN     NUMBER,
            p_Last_Update_Login       IN     NUMBER,
            p_Agreement_Id            IN     NUMBER,
            p_Project_Id              IN     NUMBER,
            p_Task_id                 IN     NUMBER,
            p_Allocated_Amount        IN     NUMBER,
            p_Date_Allocated          IN     DATE,
            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_pm_funding_reference    IN     VARCHAR2,
            p_pm_product_code         IN     VARCHAR2,
            p_project_rate_type       IN     VARCHAR2   DEFAULT NULL,
            p_project_rate_date       IN     DATE       DEFAULT NULL,
            p_project_exchange_rate   IN     NUMBER     DEFAULT NULL,
            p_projfunc_rate_type      IN     VARCHAR2   DEFAULT NULL,
            p_projfunc_rate_date      IN     DATE       DEFAULT NULL,
            p_projfunc_exchange_rate  IN     NUMBER     DEFAULT NULL,
            x_err_code                OUT    NOCOPY NUMBER,/*file.sql.39*/
            x_err_msg                 OUT    NOCOPY VARCHAR2,/*file.sql.39*/
            p_funding_category        IN     VARCHAR2   /* For Bug 2244796  */

                      )
  IS
temp varchar2(20) := 'DRAFT';

Line: 1270


            p_last_update_date             =>   p_last_update_date,
            p_last_updated_by              =>   p_last_updated_by,
            p_creation_date                =>   p_creation_date,
            p_created_by                   =>   p_created_by,
            p_last_update_login            =>   p_last_update_login,
            p_agreement_id                 =>   p_agreement_id,
            p_project_id                   =>   p_project_id,
            p_task_id                      =>   p_task_id,
            p_budget_type_code             =>   temp,
            p_allocated_amount             =>   p_allocated_amount,
            p_date_allocated               =>   p_date_allocated,
            p_attribute_category           =>   p_attribute_category,
            p_attribute1                   =>   p_attribute1,
            p_attribute2                   =>   p_attribute2,
            p_attribute3                   =>   p_attribute3,
            p_attribute4                   =>   p_attribute4,
            p_attribute5                   =>   p_attribute5,
            p_attribute6                   =>   p_attribute6,
            p_attribute7                   =>   p_attribute7,
            p_attribute8                   =>   p_attribute8,
            p_attribute9                   =>   p_attribute9,
            p_attribute10                  =>   p_attribute10,
            p_pm_funding_reference         =>   p_pm_funding_reference,
            p_pm_product_code              =>   p_pm_product_code,
            p_project_rate_type            =>   p_project_rate_type,
            p_project_rate_date            =>   p_project_rate_date,
            p_project_exchange_rate        =>   p_project_exchange_rate,
            p_projfunc_rate_type           =>   p_projfunc_rate_type,
            p_projfunc_rate_date           =>   p_projfunc_rate_date,
            p_projfunc_exchange_rate       =>   p_projfunc_exchange_rate,
            x_err_code                     =>   l_err_code,
            x_err_msg                      =>   l_err_msg,
            p_funding_category             =>   p_funding_category   /* For Bug2244796 */
          );

Line: 1331


  PROCEDURE Update_funding(
            p_Project_Funding_Id      IN     NUMBER,
            p_Last_Update_Date        IN     DATE,
            p_Last_Updated_By         IN     NUMBER,
            p_Last_Update_Login       IN     NUMBER,
            p_Agreement_Id            IN     NUMBER,
            p_Project_Id              IN     NUMBER,
            p_Task_id                 IN     NUMBER,
            p_Allocated_Amount        IN     NUMBER,
            p_Date_Allocated          IN     DATE,
            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_pm_funding_reference    IN     VARCHAR2,
            p_pm_product_code         IN     VARCHAR2,
            p_project_rate_type       IN     VARCHAR2   DEFAULT NULL,
            p_project_rate_date       IN     DATE       DEFAULT NULL,
            p_project_exchange_rate   IN     NUMBER     DEFAULT NULL,
            p_projfunc_rate_type      IN     VARCHAR2   DEFAULT NULL,
            p_projfunc_rate_date      IN     DATE       DEFAULT NULL,
            p_projfunc_exchange_rate  IN     NUMBER     DEFAULT NULL,
            x_err_code                OUT    NOCOPY NUMBER,/*File.sql.39*/
            x_err_msg                 OUT    NOCOPY VARCHAR2,/*File.sql.39*/
            p_funding_category        IN     VARCHAR2   /* For Bug2244796 */ )
  IS

 l_err_code  NUMBER;

Line: 1373


  PA_FUNDING_CORE.UPDATE_FUNDING(
            p_project_funding_id           =>   p_project_funding_id,
            p_last_update_date             =>   p_last_update_date,
            p_last_updated_by              =>   p_last_updated_by,
            p_last_update_login            =>   p_last_update_login,
            p_agreement_id                 =>   p_agreement_id,
            p_project_id                   =>   p_project_id,
            p_task_id                      =>   p_task_id,
            p_budget_type_code             =>   'DRAFT',
            p_allocated_amount             =>   p_allocated_amount,
            p_date_allocated               =>   p_date_allocated,
            p_attribute_category           =>   p_attribute_category,
            p_attribute1                   =>   p_attribute1,
            p_attribute2                   =>   p_attribute2,
            p_attribute3                   =>   p_attribute3,
            p_attribute4                   =>   p_attribute4,
            p_attribute5                   =>   p_attribute5,
            p_attribute6                   =>   p_attribute6,
            p_attribute7                   =>   p_attribute7,
            p_attribute8                   =>   p_attribute8,
            p_attribute9                   =>   p_attribute9,
            p_attribute10                  =>   p_attribute10,
            p_pm_funding_reference         =>   p_pm_funding_reference,
            p_pm_product_code              =>   p_pm_product_code,
            p_project_rate_type            =>   p_project_rate_type,
            p_project_rate_date            =>   p_project_rate_date,
            p_project_exchange_rate        =>   p_project_exchange_rate,
            p_projfunc_rate_type           =>   p_projfunc_rate_type,
            p_projfunc_rate_date           =>   p_projfunc_rate_date,
            p_projfunc_exchange_rate       =>   p_projfunc_exchange_rate,
            x_err_code                     =>   l_err_code,
            x_err_msg                      =>   l_err_msg,
            p_funding_category             =>   p_funding_category   /* For Bug2244796 */
);

Line: 1417


  END update_funding;

Line: 1432


  PROCEDURE Delete_funding(p_project_funding_id IN NUMBER)
  IS
  BEGIN
   PA_FUNDING_CORE.DELETE_FUNDING(p_project_funding_id);

Line: 1436


  END Delete_funding;