APPS.PJM_PROJECT_PARAM_PUB SQL Statements

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

Line: 72

  SELECT seiban_number_flag
  ,      start_date
  ,      completion_date
  FROM   pjm_projects_all_v
  WHERE  project_id = X_project_id;

Line: 79

  SELECT planning_group
  FROM   pjm_project_parameters
  WHERE  project_id = X_project_id;

Line: 84

  SELECT p.project_control_level
  ,      m.default_cost_group_id
  ,      m.primary_cost_method
  ,      m.eam_enabled_flag
  ,      p.transfer_ipv
  ,      p.transfer_erv
  ,      p.transfer_freight
  ,      p.transfer_tax
  ,      p.transfer_misc
  ,      p.ipv_expenditure_type
  ,      p.erv_expenditure_type
  ,      p.freight_expenditure_type
  ,      p.tax_expenditure_type
  ,      p.misc_expenditure_type
  ,      p.ppv_expenditure_type
  ,      p.dir_item_expenditure_type
  FROM   pjm_org_parameters p
  ,      mtl_parameters m
  WHERE  p.organization_id = X_organization_id
  AND    m.organization_id = p.organization_id;

Line: 106

  SELECT default_discrete_class
  FROM   wip_parameters wp
  WHERE  organization_id = X_organization_id
  AND NOT ( P_param_data.cost_group_id is not null
          AND NOT EXISTS (
            SELECT null
            FROM   cst_cg_wip_acct_classes
            WHERE  cost_group_id = P_param_data.cost_group_id
            AND    organization_id = wp.organization_id
            AND    class_code = wp.default_discrete_class
          )
  );

Line: 288

  SELECT project_id
  FROM   pjm_project_parameters
  WHERE  organization_id = X_organization_id
  AND    project_id = X_project_id;

Line: 295

  SELECT cost_group_id
  FROM   cst_cost_groups
  WHERE  organization_id = X_organization_id
  AND    cost_group_id = X_cost_group_id
  UNION ALL
  SELECT default_cost_group_id
  FROM   mtl_parameters
  WHERE  organization_id = X_organization_id
  AND    default_cost_group_id = X_cost_group_id
  UNION ALL
  SELECT cost_group_id
  FROM   CST_COST_GROUP_ACCOUNTS
  WHERE  organization_id = X_organization_id
  AND    cost_group_id = X_cost_group_id;

Line: 316

  SELECT class_code
  FROM   wip_accounting_classes wac
  WHERE  class_code = X_class_code
  AND    organization_id = X_organization_id
  AND    class_type = X_class_type
  AND NOT ( X_cost_group_id <> G_cost_group_id
          AND NOT EXISTS (
            SELECT null
            FROM   cst_cg_wip_acct_classes
            WHERE  cost_group_id = X_cost_group_id
            AND    organization_id = wac.organization_id
            AND    class_code = wac.class_code
          )
  );

Line: 333

  SELECT expenditure_type
  FROM   cst_proj_exp_types_val_v
  WHERE  expenditure_type = X_expenditure_type
  AND    cost_element_id = X_cost_element_id
  AND    trunc(sysdate)
         BETWEEN sys_link_start_date
         AND     nvl(sys_link_end_date , trunc(sysdate))
  AND    trunc(sysdate)
         BETWEEN exp_type_start_date
         AND     nvl(exp_type_end_date , trunc(sysdate));

Line: 687

  PJM_PROJECT_PARAMS_PKG.insert_row
  ( X_rowid                        => l_rowid
  , X_project_id                   => l_param_data.project_id
  , X_organization_id              => l_param_data.organization_id
  , X_seiban_number_flag           => G_seiban_flag
  , X_costing_group_id             => l_param_data.cost_group_id
  , X_planning_group               => G_planning_group
  , X_wip_acct_class_code          => l_param_data.wip_acct_class_code
  , X_eam_acct_class_code          => l_param_data.eam_acct_class_code
  , X_start_date_active            => l_param_data.start_date_active
  , X_end_date_active              => l_param_data.end_date_active
  , X_ipv_expenditure_type         => l_param_data.ipv_expenditure_type
  , X_erv_expenditure_type         => l_param_data.erv_expenditure_type
  , X_freight_expenditure_type     => l_param_data.freight_expenditure_type
  , X_tax_expenditure_type         => l_param_data.tax_expenditure_type
  , X_misc_expenditure_type        => l_param_data.misc_expenditure_type
  , X_ppv_expenditure_type         => l_param_data.ppv_expenditure_type
  , X_dir_item_expenditure_type    => l_param_data.dir_item_expenditure_type
  , X_attribute_category           => l_param_data.attr_category
  , X_attribute1                   => l_param_data.attr1
  , X_attribute2                   => l_param_data.attr2
  , X_attribute3                   => l_param_data.attr3
  , X_attribute4                   => l_param_data.attr4
  , X_attribute5                   => l_param_data.attr5
  , X_attribute6                   => l_param_data.attr6
  , X_attribute7                   => l_param_data.attr7
  , X_attribute8                   => l_param_data.attr8
  , X_attribute9                   => l_param_data.attr9
  , X_attribute10                  => l_param_data.attr10
  , X_attribute11                  => l_param_data.attr11
  , X_attribute12                  => l_param_data.attr12
  , X_attribute13                  => l_param_data.attr13
  , X_attribute14                  => l_param_data.attr14
  , X_attribute15                  => l_param_data.attr15
  , X_creation_date                => sysdate
  , X_created_by                   => l_user_id
  , X_last_update_date             => sysdate
  , X_last_updated_by              => l_user_id
  , X_last_update_login            => l_login_id
  );

Line: 872

PROCEDURE update_planning_group
( P_api_version             IN            NUMBER
, P_init_msg_list           IN            VARCHAR2
, P_commit                  IN            VARCHAR2
, X_return_status           OUT NOCOPY    VARCHAR2
, X_msg_count               OUT NOCOPY    NUMBER
, X_msg_data                OUT NOCOPY    VARCHAR2
, P_project_id              IN            NUMBER
, P_planning_group          IN            VARCHAR2
) IS

l_api_name     CONSTANT VARCHAR2(30) := 'UPDATE_PLANNING_GROUP';

Line: 887

  SELECT lookup_code
  FROM   fnd_common_lookups
  WHERE  application_id = 704
  AND    lookup_type = 'PLANNING_GROUP'
  AND    lookup_code = P_planning_group
  AND    sysdate BETWEEN nvl( start_date_active , sysdate - 1)
                 AND     nvl( end_date_active , sysdate + 1)
  AND    nvl( enabled_flag , 'N' ) = 'Y';

Line: 902

  SAVEPOINT update_planning_group;

Line: 941

  PJM_PROJECT_PARAMS_PKG.update_planning_group
  ( X_project_id         => P_project_id
  , X_planning_group     => P_planning_group );

Line: 961

    ROLLBACK TO update_planning_group;

Line: 967

    ROLLBACK TO update_planning_group;

Line: 973

    ROLLBACK TO update_planning_group;

Line: 982

END update_planning_group;