APPS.BEN_CACHE SQL Statements

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

Line: 32

                                               selected instance query values
                                               being assigned to the instance
                                               cache.
        17 May 99        mhoyes     115.7    - Added p_lkup_query to Write_BGP_Cache.
                                             - PLSQL tuning. Removed g_package.
        22 May 00        mhoyes     115.8    - Added parameter p_lkup_query
                                               to Write_BGP_Cache.
        28 Jun 00        mhoyes     115.8    - Upgraded for multiple value hashing.
        13 Jul 00        mhoyes     115.9    - Upgraded for non mandatory hash values.
        19 Sep 01        mhoyes     115.10   - Added check_list_duplicate.
        24-Dec-02        bmanyam    115.4    NOCOPY Changes
*/
-- ------------------------------------------------------------------------------
  --
  -- Declare globals
  --
procedure Write_MastDet_Cache
  (p_mastercol_name    in     varchar2
  ,p_detailcol_name    in     varchar2
  ,p_masterfkcol_name  in     varchar2 default null
  ,p_masterfk1col_name in     varchar2 default null
  ,p_masterfk2col_name in     varchar2 default null
  ,p_masterfk3col_name in     varchar2 default null
  ,p_masterfk4col_name in     varchar2 default null
  ,p_masterfk5col_name in     varchar2 default null
  ,p_lkup_name         in     varchar2
  ,p_inst_name         in     varchar2
  ,p_lkup_query        in     varchar2
  ,p_inst_query        in     varchar2
  ,p_nonmand_hv        in     boolean  default false
  ,p_coninst_query     in     varchar2 default null
  ,p_conlkup_name      in     varchar2 default null
  ,p_dtconlkup_ccolnm  in     varchar2 default null
  ,p_dtconlkup_value   in     date     default null
  ,p_instcolnm_set     in     ben_cache.InstColNmType
                             default ben_cache.g_instcolnm_set
  ,p_curparm_set       in     ben_cache.CurParmType
                             default ben_cache.g_curparm_set
  )

is
  --
  l_proc varchar2(72) := 'Write_MastDet_Cache';

Line: 1018

  l_curparm_set.delete;

Line: 1050

  l_lkup_selclause   := ' select master.'||p_masterpkcol_name||', '
                        ||'      master.business_group_id ';

Line: 1269

    l_lkup_subquery      := ' and master.'||p_masterpkcol_name||' in(select ';

Line: 1319

    l_inst_selclause := 'select ';

Line: 1341

    l_inst_selclause := 'select * ';