eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_LOAD_PROCESS_FLOWS dependencies on PAY_PARAMETER_SETS

Line 39: -- Procedure used to upload seed data for the table PAY_PARAMETER_SETS

35: -- |--------------------------< load_parameter_sets >--------------------------|
36: -- ----------------------------------------------------------------------------
37: --
38: -- Description:
39: -- Procedure used to upload seed data for the table PAY_PARAMETER_SETS
40: --
41: -- ----------------------------------------------------------------------------
42: procedure load_parameter_sets
43: ( p_set_name in varchar2

Line 53: from pay_parameter_sets pps,

49: ) AS
50:
51: cursor ppsexists(p_set_name varchar2) is
52: select pps.set_id
53: from pay_parameter_sets pps,
54: pay_parameters pp,
55: pay_parameter_definitions ppd,
56: PER_BUSINESS_GROUPS pbg
57: where ppd.parameter_name = p_set_name

Line 98: UPDATE PAY_PARAMETER_SETS SET

94: hr_utility.trace('After getting bg_name : '||l_business_group_id);
95:
96: if(found = TRUE) then
97:
98: UPDATE PAY_PARAMETER_SETS SET
99: description = p_desc
100: , wrapper_pkg = p_wrap_pkg
101: , LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
102: , LAST_UPDATE_DATE = SYSDATE

Line 115: INSERT INTO PAY_PARAMETER_SETS (

111:
112:
113: hr_utility.trace('After get_set_name_id : '||l_set_name_id);
114:
115: INSERT INTO PAY_PARAMETER_SETS (
116: set_id
117: , set_name_id
118: , description
119: , wrapper_pkg

Line 128: PAY_PARAMETER_SETS_S.nextval

124: ,LAST_UPDATE_LOGIN
125: ,CREATION_DATE
126: ,CREATED_BY )
127: VALUES (
128: PAY_PARAMETER_SETS_S.nextval
129: , l_set_name_id
130: , p_desc
131: , p_wrap_pkg
132: , l_business_group_id

Line 176: pay_parameter_sets pps,

172: cursor psvexists( p_set_name varchar2
173: ,p_param_name varchar2) is
174: select psv.set_variable_id
175: from pay_para_set_variables psv,
176: pay_parameter_sets pps,
177: pay_parameters pp1,
178: pay_parameters pp2,
179: pay_parameter_definitions ppd1,
180: pay_parameter_definitions ppd2,

Line 205: pay_parameter_sets pps

201: cursor c_get_set_id ( p_set_name in varchar2 ) IS
202: select pps.set_id
203: from PAY_PARAMETERS pp,
204: PAY_PARAMETER_DEFINITIONS ppd,
205: pay_parameter_sets pps
206: where ppd.parameter_name = p_set_name
207: and ppd.parameter_def_id = pp.parameter_def_id
208: and pp.parameter_id = pps.set_name_id;
209: --

Line 333: pay_parameter_sets pps_flow,

329: select psov.shared_variable_id
330: from pay_para_set_override_vars psov,
331: pay_para_set_variables psv_flow,
332: pay_para_set_variables psv_set,
333: pay_parameter_sets pps_flow,
334: pay_parameter_sets pps_set,
335: pay_parameters pp_flow,
336: pay_parameters pp_flow_param,
337: pay_parameters pp_set,

Line 334: pay_parameter_sets pps_set,

330: from pay_para_set_override_vars psov,
331: pay_para_set_variables psv_flow,
332: pay_para_set_variables psv_set,
333: pay_parameter_sets pps_flow,
334: pay_parameter_sets pps_set,
335: pay_parameters pp_flow,
336: pay_parameters pp_flow_param,
337: pay_parameters pp_set,
338: pay_parameters pp_set_param,

Line 371: pay_parameter_sets pps,

367: from pay_parameters pp1,
368: pay_parameters pp2,
369: pay_parameter_definitions ppd1,
370: pay_parameter_definitions ppd2,
371: pay_parameter_sets pps,
372: pay_para_set_variables psv
373: where ppd1.parameter_name = p_flow_or_set_name
374: and ppd1.parameter_def_id = pp1.parameter_def_id
375: and pp1.parameter_id = pps.set_name_id

Line 477: pay_parameter_sets pps,

473:
474: cursor ppfexists(p_flow_name varchar2) is
475: select ppf.process_flow_id
476: from pay_process_flows ppf,
477: pay_parameter_sets pps,
478: pay_parameters pp,
479: pay_parameter_definitions ppd,
480: per_business_groups pbg
481: where ppd.parameter_name = p_flow_name

Line 493: pay_parameter_sets pps

489: cursor c_get_set_id ( flow_name in varchar2 ) IS
490: select pps.set_id
491: from PAY_PARAMETERS pp,
492: PAY_PARAMETER_DEFINITIONS ppd,
493: pay_parameter_sets pps
494: where ppd.parameter_name = flow_name
495: and ppd.parameter_def_id = pp.parameter_def_id
496: and pp.parameter_id = pps.set_name_id;
497: --

Line 595: pay_parameter_sets pps1,

591: ,p_set_name varchar2) is
592: select pfs.process_flow_set_id
593: from pay_process_flow_sets pfs,
594: pay_process_flows ppf,
595: pay_parameter_sets pps1,
596: pay_parameter_sets pps2,
597: pay_parameters pp1,
598: pay_parameters pp2,
599: pay_parameter_definitions ppd1,

Line 596: pay_parameter_sets pps2,

592: select pfs.process_flow_set_id
593: from pay_process_flow_sets pfs,
594: pay_process_flows ppf,
595: pay_parameter_sets pps1,
596: pay_parameter_sets pps2,
597: pay_parameters pp1,
598: pay_parameters pp2,
599: pay_parameter_definitions ppd1,
600: pay_parameter_definitions ppd2,

Line 618: pay_parameter_sets pps,

614:
615: cursor c_get_flow_id ( p_flow_name in varchar2 ) IS
616: select ppf.process_flow_id
617: from pay_process_flows ppf,
618: pay_parameter_sets pps,
619: PAY_PARAMETERS pp,
620: PAY_PARAMETER_DEFINITIONS ppd
621: where ppd.parameter_name = p_flow_name
622: and ppd.parameter_def_id = pp.parameter_def_id

Line 630: pay_parameter_sets pps

626: cursor c_get_set_id ( p_set_name in varchar2 ) IS
627: select pps.set_id
628: from PAY_PARAMETERS pp,
629: PAY_PARAMETER_DEFINITIONS ppd,
630: pay_parameter_sets pps
631: where ppd.parameter_name = p_set_name
632: and ppd.parameter_def_id = pp.parameter_def_id
633: and pp.parameter_id = pps.set_name_id;
634: --