DBA Data[Home] [Help]

APPS.BEN_CWB_SUMMARY_PKG dependencies on BEN_CWB_SUMMARY

Line 1: package BEN_CWB_SUMMARY_PKG as

1: package BEN_CWB_SUMMARY_PKG as
2: /* $Header: bencwbsm.pkh 120.1.12010000.1 2008/07/29 12:07:53 appldev ship $ */
3: -- --------------------------------------------------------------------------
4: -- |--------------------------< update_or_insert >---------------------------|
5: -- --------------------------------------------------------------------------

Line 12: procedure update_or_insert (p_sum_rec in ben_cwb_summary%rowtype);

8: -- given combination. If the record is already locked, a new record will be
9: -- inserted with status "P". If there exists no records with the given
10: -- combination, a new record will be inserted with status null.
11: --
12: procedure update_or_insert (p_sum_rec in ben_cwb_summary%rowtype);
13: --
14: -- --------------------------------------------------------------------------
15: -- |----------------------< consolidate_summary_rec >------------------------|
16: -- --------------------------------------------------------------------------

Line 27: -- split rows in ben_cwb_summary

23: -- |--------------------< consolidate_summary_rec_all >----------------------|
24: -- --------------------------------------------------------------------------
25: -- Description
26: -- This procedure consolidates the summary records for all persons having
27: -- split rows in ben_cwb_summary
28: procedure consolidate_summary_rec_all;
29: --
30: -- --------------------------------------------------------------------------
31: -- |----------------------< refresh_summary_group_pl >-----------------------|

Line 56: -- into ben_cwb_summary

52: -- --------------------------------------------------------------------------
53: -- Description
54: -- This procedure stores the given summary values in a pl/sql table.
55: -- save_pl_sql_tab needs to be called finally to save the values in the table
56: -- into ben_cwb_summary
57: procedure update_or_insert_pl_sql_tab
58: (p_group_per_in_ler_id in number
59: ,p_group_pl_id in number
60: ,p_group_oipl_id in number

Line 101: -- ben_cwb_summary table.

97: -- |---------------------------< save_pl_sql_tab >---------------------------|
98: -- --------------------------------------------------------------------------
99: -- Description
100: -- This procedures updates the data in g_summary_tab to
101: -- ben_cwb_summary table.
102: --
103: procedure save_pl_sql_tab;
104: --
105: -- --------------------------------------------------------------------------

Line 155: end BEN_CWB_SUMMARY_PKG;

151: -- with -1 person_ids.
152: --
153: procedure refresh_summary_all_plans;
154: --
155: end BEN_CWB_SUMMARY_PKG;
156: