APPS.PAY_MONITOR_BALANCE_RETRIEVAL dependencies on PAY_MONITOR_BALANCE_RETRIEVAL

Line 1: PACKAGE BODY pay_monitor_balance_retrieval AS

1: PACKAGE BODY pay_monitor_balance_retrieval AS
2: /* $Header: pymnblrt.pkb 120.0 2005/05/29 06:47:48 appldev noship $ */
3: --
4: -------------------------------------------------------------------------
5: -- PROCEDURE monitor_balance_retrieval

Line 18: -- into the table pay_monitor_balance_retrievals.

14: -- value is null, then the default 'Monitoring all calls to route' is
15: -- set as the module name, otherwise the module name will be set to the value
16: -- in the session variable.
17: -- The code then calls output_bal_retrieval_data to insert monitoring data
18: -- into the table pay_monitor_balance_retrievals.
19: -------------------------------------------------------------------------
20: procedure monitor_balance_retrieval(p_defined_balance_id number
21: ,p_assignment_action_id number
22: ,p_reason varchar2) is

Line 26: l_module_name pay_monitor_balance_retrievals.module_name%type;

22: ,p_reason varchar2) is
23: --
24: l_profile varchar2(2);
25: l_proc varchar2(80);
26: l_module_name pay_monitor_balance_retrievals.module_name%type;
27: --
28: BEGIN
29: l_proc := 'pay_monitor_balance_retrieval.monitor_balance_retrieval';
30: --

Line 29: l_proc := 'pay_monitor_balance_retrieval.monitor_balance_retrieval';

25: l_proc varchar2(80);
26: l_module_name pay_monitor_balance_retrievals.module_name%type;
27: --
28: BEGIN
29: l_proc := 'pay_monitor_balance_retrieval.monitor_balance_retrieval';
30: --
31: hr_utility.set_location('Entering: '||l_proc, 10);
32: --
33: -- this will be a call to get_profile once the profile is set up

Line 72: -- to be written to table pay_monitor_balance_retrievals, and to be commited

68: -- PROCEDURE output_bal_retrieval_data
69: -------------------------------------------------------------------------
70: -- Description:
71: -- output_bal_retrieval_data is an autonomous transaction, enabling data
72: -- to be written to table pay_monitor_balance_retrievals, and to be commited
73: -- independently of the package from which it is called.
74: --------------------------------------------------------------------------
75: PROCEDURE output_bal_retrieval_data(p_module_name varchar2
76: ,p_date_monitored date

Line 87: l_proc := 'pay_monitor_balance_retrieval.output_bal_retrieval_data';

83: l_proc varchar2(80);
84: --
85: BEGIN
86: --
87: l_proc := 'pay_monitor_balance_retrieval.output_bal_retrieval_data';
88: --
89: hr_utility.set_location('Entering: '||l_proc, 10);
90: --
91: -- insert values into table pay_monitor_balance_retrievals

Line 91: -- insert values into table pay_monitor_balance_retrievals

87: l_proc := 'pay_monitor_balance_retrieval.output_bal_retrieval_data';
88: --
89: hr_utility.set_location('Entering: '||l_proc, 10);
90: --
91: -- insert values into table pay_monitor_balance_retrievals
92: --
93: insert into pay_monitor_balance_retrievals
94: (module_name
95: ,date_monitored

Line 93: insert into pay_monitor_balance_retrievals

89: hr_utility.set_location('Entering: '||l_proc, 10);
90: --
91: -- insert values into table pay_monitor_balance_retrievals
92: --
93: insert into pay_monitor_balance_retrievals
94: (module_name
95: ,date_monitored
96: ,defined_balance_id
97: ,assignment_action_id

Line 275: END pay_monitor_balance_retrieval;

271: SessionVarValues := EmptyTable;
272: SessionVarCount := 0;
273: END clear_session_vars;
274: --------------------------------------------------------------------------------
275: END pay_monitor_balance_retrieval;