APPS.PAY_STANDARD_CHECK dependencies on STANDARD

Line 1: PACKAGE BODY pay_standard_check AS

1: PACKAGE BODY pay_standard_check AS
2: /* $Header: pystdchk.pkb 120.2 2006/01/30 07:08:56 alogue noship $ */
3:
4: cursor csr_relevant_total_chk(l_batch_id in number,
5: l_meaning in varchar2) is

Line 15: and hrl.lookup_code like '_TOTAL_COLUMN_%' -- must be a standard total

11: where l_meaning = piv.name -- restrict to input value parameter
12: and piv.name = hrl.meaning -- join piv-hrl on name of input value
13:
14: and hrl.lookup_type = 'CONTROL_TYPE' -- restrict to relevant lookup
15: and hrl.lookup_code like '_TOTAL_COLUMN_%' -- must be a standard total
16:
17: and pbl.element_type_id = piv.element_type_id -- join piv-pbl on element_type_id
18: and pbl.batch_id = l_batch_id ; -- restrict to batch_id parameter
19: -- and effective_date_condition. depends on wether its the effective date or sysdate thats inportant for processing

Line 49: -- Given a batch id it will carry out any standard totals

45: -- NAME
46: -- pay_user_check.check_control
47: --
48: -- DESCRIPTION
49: -- Given a batch id it will carry out any standard totals
50: -- and insert any necessary messages into the message table and
51: -- update statuses that are required. The p_standard_status is updated
52: -- to true to signify that the control total has been dealt with
53: -- at this point. If the control total is not

Line 51: -- update statuses that are required. The p_standard_status is updated

47: --
48: -- DESCRIPTION
49: -- Given a batch id it will carry out any standard totals
50: -- and insert any necessary messages into the message table and
51: -- update statuses that are required. The p_standard_status is updated
52: -- to true to signify that the control total has been dealt with
53: -- at this point. If the control total is not
54: -- recognised as standard then no action is taken.
55:

Line 54: -- recognised as standard then no action is taken.

50: -- and insert any necessary messages into the message table and
51: -- update statuses that are required. The p_standard_status is updated
52: -- to true to signify that the control total has been dealt with
53: -- at this point. If the control total is not
54: -- recognised as standard then no action is taken.
55:
56: --
57:
58:

Line 126: -- as a standard control

122:
123: if(p_control_type='_COUNT_LINES_') then
124:
125: p_std_status := 'V'; -- set to valid to signify the total will be interpreted
126: -- as a standard control
127:
128: -- get number of lines in batch
129:
130: select count(*) into l_n_lines

Line 147: -- Deal with a standard total

143: end if;
144:
145: end if;
146:
147: -- Deal with a standard total
148: if (instr (p_control_type,'_TOTAL_COLUMN_') = 1) then
149: -- only check if control is recognisable as an arithmetic sum.
150: -- _TOTAL_COLUMN_ must be the first characters in the string
151:

Line 236: end pay_standard_check;

232:
233: end check_control;
234:
235:
236: end pay_standard_check;