APPS.ZX_LINES_DET_FACTORS_PKG SQL Statements

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

Line: 27

   SELECT  APPLICATION_ID,
           ENTITY_CODE,
           EVENT_CLASS_CODE,
           EVENT_TYPE_CODE,
           LINE_LEVEL_ACTION,
           TRX_ID,
           TRX_LINE_ID,
           TRX_LEVEL_TYPE,
           DEFAULT_TAXATION_COUNTRY,
           DOCUMENT_SUB_TYPE,
           TAX_INVOICE_DATE,
           TAX_INVOICE_NUMBER,
           LINE_INTENDED_USE ,
           PRODUCT_FISC_CLASSIFICATION ,
           PRODUCT_TYPE ,
           PRODUCT_CATEGORY ,
           USER_DEFINED_FISC_CLASS,
           ASSESSABLE_VALUE,
           INPUT_TAX_CLASSIFICATION_CODE,
           OUTPUT_TAX_CLASSIFICATION_CODE,
           USER_UPD_DET_FACTORS_FLAG,
           TAX_EVENT_CLASS_CODE
    FROM  ZX_LINES_DET_FACTORS
    WHERE application_id = p_transaction_rec.application_id
      AND entity_code = p_transaction_rec.entity_code
      AND event_class_code = p_transaction_rec.event_class_code
      AND trx_id = p_transaction_rec.trx_id
    FOR UPDATE NOWAIT;

Line: 58

 | PROCEDURE  update_line_det_attribs : Update only the determining applicable |
 | at line level back to zx_lines_det_factors                                  |
 * ===========================================================================*/
PROCEDURE update_line_det_attribs (
  p_trx_biz_category         IN  VARCHAR2,
  p_line_intended_use        IN  VARCHAR2,
  p_prod_fisc_class          IN  VARCHAR2,
  p_prod_category            IN  VARCHAR2,
  p_product_type             IN  VARCHAR2,
  p_user_def_fisc_class      IN  VARCHAR2,
  p_assessable_value         IN  NUMBER,
  p_tax_classification_code  IN  VARCHAR2,
  p_display_tax_classif_flag IN  VARCHAR2,
  p_transaction_line_rec     IN  ZX_API_PUB.transaction_line_rec_type,
  x_return_status            OUT NOCOPY VARCHAR2
 )  IS
  l_api_name                 CONSTANT  VARCHAR2(30) := 'UPDATE_LINE_DET_ATTRIBS';

Line: 89

   |  Update zx_lines_det_factors            |
   +-----------------------------------------*/
   UPDATE ZX_LINES_DET_FACTORS SET
         trx_business_category         = p_trx_biz_category,
         line_intended_use             = p_line_intended_use,
         user_defined_fisc_class       = p_user_def_fisc_class,
         product_fisc_classification   = p_prod_fisc_class,
         product_category              = p_prod_category,
         product_type                  = p_product_type,
         assessable_value              = p_assessable_value,
         input_tax_classification_code = decode(p_display_tax_classif_flag,'Y', p_tax_classification_code,
                                                                                input_tax_classification_code),
         user_upd_det_factors_flag     = 'Y',
         tax_processing_completed_flag = 'N',
         object_version_number         = object_version_number+1,
         line_level_action             = decode(line_level_action,'SYNCHRONIZE', 'UPDATE', line_level_action)
     WHERE application_id    = p_transaction_line_rec.application_id
       AND entity_code       = p_transaction_line_rec.entity_code
       AND event_class_code  = p_transaction_line_rec.event_class_code
       AND trx_id            = p_transaction_line_rec.trx_id
       AND trx_line_id       = p_transaction_line_rec.trx_line_id
       AND trx_level_type    = p_transaction_line_rec.trx_level_type;

Line: 122

  END update_line_det_attribs;

Line: 125

 | PROCEDURE  update_header_det_attribs : Calls the defaulting API to redefault|
 | tax determining attributes since the taxation country has changed           |
 | Also update the lines_det_factors with these values for UI to reflect the   |
 | changes.                                                                    |
 * ===========================================================================*/
PROCEDURE update_header_det_attribs (
  p_taxation_country         IN             VARCHAR2,
  p_document_subtype         IN             VARCHAR2,
  p_tax_invoice_date         IN             DATE,
  p_tax_invoice_number       IN             VARCHAR2,
  p_display_tax_classif_flag IN             VARCHAR2,
  p_transaction_rec          IN             ZX_API_PUB.transaction_rec_type,
  p_event_class_rec          IN  OUT NOCOPY ZX_API_PUB.event_class_rec_type,
  x_return_status            OUT     NOCOPY VARCHAR2
 )  IS
  l_api_name                 CONSTANT  VARCHAR2(30) := 'UPDATE_HEADER_DET_ATTRIBS';

Line: 217

     UPDATE ZX_LINES_DET_FACTORS SET
          default_taxation_country      = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
          document_sub_type             = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
          line_intended_use             = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
          user_defined_fisc_class       = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
          product_fisc_classification   = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
          product_category              = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
          assessable_value              = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
          input_tax_classification_code = decode(p_display_tax_classif_flag,'Y',ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.input_tax_classification_code(i),
                                                                                input_tax_classification_code),
          tax_invoice_date              = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),
          tax_invoice_number            = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_number(i),
          user_upd_det_factors_flag     ='Y',
          tax_processing_completed_flag ='N',
          object_version_number         = object_version_number+1,
          line_level_action             = decode(line_level_action,'SYNCHRONIZE', 'UPDATE', line_level_action)
        WHERE application_id    = p_transaction_rec.application_id
          AND entity_code       = p_transaction_rec.entity_code
          AND event_class_code  = p_transaction_rec.event_class_code
          AND trx_id            = p_transaction_rec.trx_id ;

Line: 253

 END update_header_det_attribs;