APPS.BEN_CACHE dependencies on BEN_CACHE

Line 1: package body ben_cache as

1: package body ben_cache as
2: /* $Header: bencache.pkb 115.11 2002/12/24 15:43:59 bmanyam ship $ */
3: -- ---------------------------------------------------------------------------
4: /*
5: +==============================================================================+

Line 66: ,p_instcolnm_set in ben_cache.InstColNmType

62: ,p_coninst_query in varchar2 default null
63: ,p_conlkup_name in varchar2 default null
64: ,p_dtconlkup_ccolnm in varchar2 default null
65: ,p_dtconlkup_value in date default null
66: ,p_instcolnm_set in ben_cache.InstColNmType
67: default ben_cache.g_instcolnm_set
68: ,p_curparm_set in ben_cache.CurParmType
69: default ben_cache.g_curparm_set
70: )

Line 67: default ben_cache.g_instcolnm_set

63: ,p_conlkup_name in varchar2 default null
64: ,p_dtconlkup_ccolnm in varchar2 default null
65: ,p_dtconlkup_value in date default null
66: ,p_instcolnm_set in ben_cache.InstColNmType
67: default ben_cache.g_instcolnm_set
68: ,p_curparm_set in ben_cache.CurParmType
69: default ben_cache.g_curparm_set
70: )
71:

Line 68: ,p_curparm_set in ben_cache.CurParmType

64: ,p_dtconlkup_ccolnm in varchar2 default null
65: ,p_dtconlkup_value in date default null
66: ,p_instcolnm_set in ben_cache.InstColNmType
67: default ben_cache.g_instcolnm_set
68: ,p_curparm_set in ben_cache.CurParmType
69: default ben_cache.g_curparm_set
70: )
71:
72: is

Line 69: default ben_cache.g_curparm_set

65: ,p_dtconlkup_value in date default null
66: ,p_instcolnm_set in ben_cache.InstColNmType
67: default ben_cache.g_instcolnm_set
68: ,p_curparm_set in ben_cache.CurParmType
69: default ben_cache.g_curparm_set
70: )
71:
72: is
73: --

Line 919: ,p_masid_set in ben_cache.IdType default ben_cache.g_id_set

915: ,p_masterfk2col_name in varchar2 default null
916: ,p_masterfk3col_name in varchar2 default null
917: ,p_masterfk4col_name in varchar2 default null
918: ,p_masterfk5col_name in varchar2 default null
919: ,p_masid_set in ben_cache.IdType default ben_cache.g_id_set
920: ,p_tabdet_set in ben_cache.TabDetType default ben_cache.g_tabdet_set
921: ,p_table1_name in varchar2
922: ,p_tab1jncol_name in varchar2 default null
923: ,p_table2_name in varchar2 default null

Line 920: ,p_tabdet_set in ben_cache.TabDetType default ben_cache.g_tabdet_set

916: ,p_masterfk3col_name in varchar2 default null
917: ,p_masterfk4col_name in varchar2 default null
918: ,p_masterfk5col_name in varchar2 default null
919: ,p_masid_set in ben_cache.IdType default ben_cache.g_id_set
920: ,p_tabdet_set in ben_cache.TabDetType default ben_cache.g_tabdet_set
921: ,p_table1_name in varchar2
922: ,p_tab1jncol_name in varchar2 default null
923: ,p_table2_name in varchar2 default null
924: ,p_tab2jncol_name in varchar2 default null

Line 939: ,p_instcolnm_set in ben_cache.InstColNmType

935: ,p_inst_whclause in varchar2 default null
936: ,p_inst_queryorby in varchar2 default null
937: ,p_lkup_subqyhint in varchar2 default null
938: ,p_lkup_query in varchar2 default null
939: ,p_instcolnm_set in ben_cache.InstColNmType
940: default ben_cache.g_instcolnm_set
941: ,p_curparm_set in ben_cache.CurParmType
942: default ben_cache.g_curparm_set
943: )

Line 940: default ben_cache.g_instcolnm_set

936: ,p_inst_queryorby in varchar2 default null
937: ,p_lkup_subqyhint in varchar2 default null
938: ,p_lkup_query in varchar2 default null
939: ,p_instcolnm_set in ben_cache.InstColNmType
940: default ben_cache.g_instcolnm_set
941: ,p_curparm_set in ben_cache.CurParmType
942: default ben_cache.g_curparm_set
943: )
944:

Line 941: ,p_curparm_set in ben_cache.CurParmType

937: ,p_lkup_subqyhint in varchar2 default null
938: ,p_lkup_query in varchar2 default null
939: ,p_instcolnm_set in ben_cache.InstColNmType
940: default ben_cache.g_instcolnm_set
941: ,p_curparm_set in ben_cache.CurParmType
942: default ben_cache.g_curparm_set
943: )
944:
945: is

Line 942: default ben_cache.g_curparm_set

938: ,p_lkup_query in varchar2 default null
939: ,p_instcolnm_set in ben_cache.InstColNmType
940: default ben_cache.g_instcolnm_set
941: ,p_curparm_set in ben_cache.CurParmType
942: default ben_cache.g_curparm_set
943: )
944:
945: is
946: --

Line 949: l_tabdet_set ben_cache.TabDetType;

945: is
946: --
947: l_proc varchar2(72) := 'Write_BGP_Cache';
948: --
949: l_tabdet_set ben_cache.TabDetType;
950: l_curparm_set ben_cache.CurParmType;
951: l_selinstcolnm_set ben_cache.InstColNmType;
952: l_selinstcol_num pls_integer;
953: l_instcolnm_num pls_integer;

Line 950: l_curparm_set ben_cache.CurParmType;

946: --
947: l_proc varchar2(72) := 'Write_BGP_Cache';
948: --
949: l_tabdet_set ben_cache.TabDetType;
950: l_curparm_set ben_cache.CurParmType;
951: l_selinstcolnm_set ben_cache.InstColNmType;
952: l_selinstcol_num pls_integer;
953: l_instcolnm_num pls_integer;
954: --

Line 951: l_selinstcolnm_set ben_cache.InstColNmType;

947: l_proc varchar2(72) := 'Write_BGP_Cache';
948: --
949: l_tabdet_set ben_cache.TabDetType;
950: l_curparm_set ben_cache.CurParmType;
951: l_selinstcolnm_set ben_cache.InstColNmType;
952: l_selinstcol_num pls_integer;
953: l_instcolnm_num pls_integer;
954: --
955: l_torrw_num pls_integer;

Line 1401: ben_cache.Write_MastDet_Cache

1397: ||' '||l_inst_fromclause
1398: ||' '||l_inst_whereclause
1399: ||' '||l_inst_queryorby;
1400: --
1401: ben_cache.Write_MastDet_Cache
1402: (p_mastercol_name => p_masterpkcol_name
1403: ,p_detailcol_name => p_masterpkcol_name
1404: ,p_masterfkcol_name => p_masterfkcol_name
1405: ,p_masterfk1col_name => p_masterfk1col_name

Line 1422: (p_list in out nocopy ben_cache.IdType

1418: --
1419: end Write_BGP_Cache;
1420: --
1421: function check_list_duplicate
1422: (p_list in out nocopy ben_cache.IdType
1423: ,p_id in number
1424: )
1425: return boolean
1426: is

Line 1516: end ben_cache;

1512: end if;
1513: --
1514: end;
1515: --
1516: end ben_cache;