APPS.JMF_GTA_TRX_LINES_ALL_PKG SQL Statements

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

Line: 106

PROCEDURE Insert_Row
(p_rowid                         IN  OUT NOCOPY VARCHAR2
,p_org_id                        IN  NUMBER
,p_gta_trx_header_id             IN  NUMBER
,p_gta_trx_line_id               IN  NUMBER
,p_matched_flag                  IN  VARCHAR2
,p_line_number                   IN  VARCHAR2
,p_ar_trx_line_id                IN  NUMBER
,p_inventory_item_id             IN  NUMBER
,p_item_number                   IN  VARCHAR2
,p_item_description              IN  VARCHAR2
,p_item_model                    IN  VARCHAR2
,p_item_tax_denomination         IN  VARCHAR2
,p_tax_rate                      IN  NUMBER
,p_uom                           IN  VARCHAR2
,p_uom_name                      IN  VARCHAR2
,p_quantity                      IN  NUMBER
,p_price_flag                    IN  VARCHAR2
,p_unit_price                    IN  NUMBER
,p_unit_tax_price                IN  NUMBER
,p_amount                        IN  NUMBER
,p_original_currency_amount      IN  NUMBER
,p_tax_amount                    IN  NUMBER
,p_discount_flag                 IN  VARCHAR2
,p_enabled_flag                  IN  VARCHAR2
,p_request_id                    IN  NUMBER
,p_program_application_id        IN  NUMBER
,p_program_id                    IN  NUMBER
,p_program_update_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_attribute11                   IN  VARCHAR2
,p_attribute12                   IN  VARCHAR2
,p_attribute13                   IN  VARCHAR2
,p_attribute14                   IN  VARCHAR2
,p_attribute15                   IN  VARCHAR2
,p_creation_date                 IN  DATE
,p_created_by                    IN  NUMBER
,p_last_update_date              IN  DATE
,p_last_updated_by               IN  NUMBER
,p_last_update_login             IN  NUMBER
)
IS
l_procedure_name    VARCHAR2(100)   :='Insert_Row';

Line: 162

SELECT
  ROWID
FROM
  jmf_gta_trx_lines_all
WHERE gta_trx_line_id=p_gta_trx_line_id;

Line: 182

  INSERT INTO jmf_gta_trx_lines_all(
     org_id
    ,gta_trx_header_id
    ,gta_trx_line_id
    ,matched_flag
    ,line_number
    ,ar_trx_line_id
    ,inventory_item_id
    ,item_number
    ,item_description
    ,item_model
    ,item_tax_denomination
    ,tax_rate
    ,uom
    ,uom_name
    ,quantity
    ,price_flag
    ,unit_price
    ,unit_tax_price
    ,amount
    ,original_currency_amount
    ,tax_amount
    ,discount_flag
    ,enabled_flag
    ,request_id
    ,program_application_id
    ,program_id
    ,program_update_date
    ,attribute_category
    ,attribute1
    ,attribute2
    ,attribute3
    ,attribute4
    ,attribute5
    ,attribute6
    ,attribute7
    ,attribute8
    ,attribute9
    ,attribute10
    ,attribute11
    ,attribute12
    ,attribute13
    ,attribute14
    ,attribute15
    ,creation_date
    ,created_by
    ,last_update_date
    ,last_updated_by
    ,last_update_login
    )
  VALUES(
     p_org_id
    ,p_gta_trx_header_id
    ,p_gta_trx_line_id
    ,p_matched_flag
    ,p_line_number
    ,p_ar_trx_line_id
    ,p_inventory_item_id
    ,p_item_number
    ,p_item_description
    ,p_item_model
    ,p_item_tax_denomination
    ,p_tax_rate
    ,p_uom
    ,p_uom_name
    ,p_quantity
    ,p_price_flag
    ,p_unit_price
    ,p_unit_tax_price
    ,p_amount
    ,p_original_currency_amount
    ,p_tax_amount
    ,p_discount_flag
    ,p_enabled_flag
    ,p_request_id
    ,p_program_application_id
    ,p_program_id
    ,p_program_update_date
    ,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_creation_date
    ,p_created_by
    ,p_last_update_date
    ,p_last_updated_by
    ,p_last_update_login
    );

Line: 303

END Insert_Row;

Line: 373

PROCEDURE Update_Row
(p_rowid                         IN  OUT NOCOPY VARCHAR2
,p_org_id       	         IN  NUMBER
,p_gta_trx_header_id	         IN  NUMBER
,p_gta_trx_line_id	         IN  NUMBER
,p_line_number  	         IN  VARCHAR2
,p_item_number                   IN  VARCHAR2
,p_item_description	         IN  VARCHAR2
,p_item_model                    IN  VARCHAR2
,p_item_tax_denomination	 IN  VARCHAR2
,p_tax_rate     	         IN  NUMBER
,p_uom_name     	         IN  VARCHAR2
,p_quantity     	         IN  NUMBER
,p_unit_price   	         IN  NUMBER
,p_amount       	         IN  NUMBER
,p_original_currency_amount	 IN  NUMBER
,p_enabled_flag 	         IN  VARCHAR2
,p_request_id   	         IN  NUMBER
,p_program_application_id	 IN  NUMBER
,p_program_id   	         IN  NUMBER
,p_program_update_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_attribute11  	         IN  VARCHAR2
,p_attribute12  	         IN  VARCHAR2
,p_attribute13  	         IN  VARCHAR2
,p_attribute14  	         IN  VARCHAR2
,p_attribute15  	         IN  VARCHAR2
,p_creation_date                 IN  DATE
,p_created_by                    IN  NUMBER
,p_last_update_date              IN  DATE
,p_last_updated_by               IN  NUMBER
,p_last_update_login             IN  NUMBER
)
IS
l_procedure_name    VARCHAR2(100)   :='Update_Row';

Line: 434

  UPDATE jmf_gta_trx_lines_all
    SET
      org_id                        =    p_org_id
     ,gta_trx_header_id             =    p_gta_trx_header_id
     ,gta_trx_line_id               =    p_gta_trx_line_id
     ,line_number                   =    p_line_number
     ,item_number                   =    p_item_number
     ,item_description              =    p_item_description
     ,item_model                    =    p_item_model
     ,item_tax_denomination         =    p_item_tax_denomination
     ,tax_rate                      =    p_tax_rate
     ,uom_name                      =    p_uom_name
     ,quantity                      =    p_quantity
     ,unit_price                    =    p_unit_price
     ,amount                        =    p_amount
     ,original_currency_amount      =    p_original_currency_amount
     ,enabled_flag                  =    p_enabled_flag
     ,request_id                    =    p_request_id
     ,program_application_id        =    p_program_application_id
     ,program_id                    =    p_program_id
     ,program_update_date           =    p_program_update_date
     ,attribute_category            =    p_attribute_category
     ,attribute1                    =    p_attribute1
     ,attribute2                    =    p_attribute2
     ,attribute3                    =    p_attribute3
     ,attribute4                    =    p_attribute4
     ,attribute5                    =    p_attribute5
     ,attribute6                    =    p_attribute6
     ,attribute7                    =	 p_attribute7
     ,attribute8                    =    p_attribute8
     ,attribute9                    =    p_attribute9
     ,attribute10                   =    p_attribute10
     ,attribute11                   =    p_attribute11
     ,attribute12                   =    p_attribute12
     ,attribute13                   =    p_attribute13
     ,attribute14                   =    p_attribute14
     ,attribute15                   =    p_attribute15
     ,creation_date                 =    p_creation_date
     ,created_by                    =    p_created_by
     ,last_update_date              =    p_last_update_date
     ,last_updated_by               =    p_last_updated_by
     ,last_update_login             =    p_last_update_login
   WHERE ROWID=p_rowid;

Line: 494

END Update_Row;

Line: 586

,p_program_update_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_attribute11  	         IN  VARCHAR2
,p_attribute12  	         IN  VARCHAR2
,p_attribute13  	         IN  VARCHAR2
,p_attribute14  	         IN  VARCHAR2
,p_attribute15  	         IN  VARCHAR2
,p_creation_date                 IN  DATE
,p_created_by                    IN  NUMBER
,p_last_update_date              IN  DATE
,p_last_updated_by               IN  NUMBER
,p_last_update_login             IN  NUMBER
)
IS
l_procedure_name    VARCHAR2(100)   :='Lock_Row';

Line: 615

SELECT
  *
FROM
  jmf_gta_trx_lines_all
WHERE ROWID=p_rowid
 FOR UPDATE OF gta_trx_line_id NOWAIT;

Line: 644

    FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 742

       (recinfo.last_update_date=p_last_update_date)
       AND
       (recinfo.last_updated_by=p_last_updated_by)
       AND
       (
        (recinfo.last_update_login=p_last_update_login)
        OR
        (
         (recinfo.last_update_login IS NULL)
         AND
         (p_last_update_login IS NULL)
        )
       )
       AND
       (
        (recinfo.request_id=p_request_id)
        OR
        (
         (recinfo.request_id IS NULL)
         AND
         (p_request_id IS NULL)
        )
       )
       AND
       (
        (recinfo.program_application_id=p_program_application_id)
        OR
        (
         (recinfo.program_application_id IS NULL)
         AND
         (p_program_application_id IS NULL)
        )
       )
       AND
       (
        (recinfo.program_id=p_program_id)
        OR
        (
         (recinfo.program_id IS NULL)
         AND
         (p_program_id IS NULL)
        )
       )
       AND
       (
        (recinfo.program_update_date=p_program_update_date)
        OR
        (
         (recinfo.program_update_date IS NULL)
         AND
         (p_program_update_date IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute_category=p_attribute_category)
        OR
        (
         (recinfo.attribute_category IS NULL)
         AND
         (p_attribute_category IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute1=p_attribute1)
        OR
        (
         (recinfo.attribute1 IS NULL)
         AND
         (p_attribute1 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute2=p_attribute2)
        OR
        (
         (recinfo.attribute2 IS NULL)
         AND
         (p_attribute2 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute3=p_attribute3)
        OR
        (
         (recinfo.attribute3 IS NULL)
         AND
         (p_attribute3 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute4=p_attribute4)
        OR
        (
         (recinfo.attribute4 IS NULL)
         AND
         (p_attribute4 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute5=p_attribute5)
        OR
        (
         (recinfo.attribute5 IS NULL)
         AND
         (p_attribute5 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute6=p_attribute6)
        OR
        (
         (recinfo.attribute6 IS NULL)
         AND
         (p_attribute6 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute7=p_attribute7)
        OR
        (
         (recinfo.attribute7 IS NULL)
         AND
         (p_attribute7 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute8=p_attribute8)
        OR
        (
         (recinfo.attribute8 IS NULL)
         AND
         (p_attribute8 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute9=p_attribute9)
        OR
        (
         (recinfo.attribute9 IS NULL)
         AND
         (p_attribute9 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute10=p_attribute10)
        OR
        (
         (recinfo.attribute10 IS NULL)
         AND
         (p_attribute10 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute11=p_attribute11)
        OR
        (
         (recinfo.attribute11 IS NULL)
         AND
         (p_attribute11 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute12=p_attribute12)
        OR
        (
         (recinfo.attribute12 IS NULL)
         AND
         (p_attribute12 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute13=p_attribute13)
        OR
        (
         (recinfo.attribute13 IS NULL)
         AND
         (p_attribute13 IS NULL)
        )
       )
      AND
       (
        (recinfo.attribute14=p_attribute14)
        OR
        (
         (recinfo.attribute14 IS NULL)
         AND
         (p_attribute14 IS NULL)
        )
       )
       AND
       (
        (recinfo.attribute15=p_attribute15)
        OR
        (
         (recinfo.attribute15 IS NULL)
         AND
         (p_attribute15 IS NULL)
        )
       )
     )

  THEN
     RETURN;

Line: 1000

PROCEDURE Delete_Row
(p_rowid                         IN OUT NOCOPY VARCHAR2
)
IS
l_procedure_name    VARCHAR2(100)   :='Delete_Row';

Line: 1021

  DELETE
  FROM JMF_GTA_TRX_LINES_ALL
  WHERE ROWID = p_rowid;

Line: 1040

END Delete_Row;