[Home] [Help]
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
58: and ppd.parameter_def_id = pp.parameter_def_id
59: and pp.parameter_id = pps.set_name_id
63:
64: cursor c_get_set_name_id (p_set_name varchar2) IS
65: select pp.parameter_id
66: from PAY_PARAMETERS pp,
67: PAY_PARAMETER_DEFINITIONS ppd
68: where ppd.parameter_name = p_set_name
69: and ppd.parameter_def_id = pp.parameter_def_id;
70: --
71:
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,
181: per_business_groups pbg
182: where ppd1.parameter_name = p_set_name
183: and ppd1.parameter_def_id = pp1.parameter_def_id
176: pay_parameter_sets pps,
177: pay_parameters pp1,
178: pay_parameters pp2,
179: pay_parameter_definitions ppd1,
180: pay_parameter_definitions ppd2,
181: per_business_groups pbg
182: where ppd1.parameter_name = p_set_name
183: and ppd1.parameter_def_id = pp1.parameter_def_id
184: and pp1.parameter_id = pps.set_name_id
193:
194: cursor get_param_id( l_parameter_name in varchar2) is
195: select pp.parameter_id
196: from pay_parameters pp,
197: pay_parameter_definitions ppd
198: where ppd.parameter_name = l_parameter_name
199: and ppd.parameter_def_id = pp.parameter_def_id;
200:
201: cursor c_get_set_id ( p_set_name in varchar2 ) IS
200:
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;
335: pay_parameters pp_flow,
336: pay_parameters pp_flow_param,
337: pay_parameters pp_set,
338: pay_parameters pp_set_param,
339: pay_parameter_definitions ppd_flow,
340: pay_parameter_definitions ppd_flow_param,
341: pay_parameter_definitions ppd_set,
342: pay_parameter_definitions ppd_set_param,
343: per_business_groups pbg
336: pay_parameters pp_flow_param,
337: pay_parameters pp_set,
338: pay_parameters pp_set_param,
339: pay_parameter_definitions ppd_flow,
340: pay_parameter_definitions ppd_flow_param,
341: pay_parameter_definitions ppd_set,
342: pay_parameter_definitions ppd_set_param,
343: per_business_groups pbg
344: where ppd_flow.parameter_name = p_flow_name
337: pay_parameters pp_set,
338: pay_parameters pp_set_param,
339: pay_parameter_definitions ppd_flow,
340: pay_parameter_definitions ppd_flow_param,
341: pay_parameter_definitions ppd_set,
342: pay_parameter_definitions ppd_set_param,
343: per_business_groups pbg
344: where ppd_flow.parameter_name = p_flow_name
345: and ppd_flow.parameter_def_id = pp_flow.parameter_def_id
338: pay_parameters pp_set_param,
339: pay_parameter_definitions ppd_flow,
340: pay_parameter_definitions ppd_flow_param,
341: pay_parameter_definitions ppd_set,
342: pay_parameter_definitions ppd_set_param,
343: per_business_groups pbg
344: where ppd_flow.parameter_name = p_flow_name
345: and ppd_flow.parameter_def_id = pp_flow.parameter_def_id
346: and pp_flow.parameter_id = pps_flow.set_name_id
365: p_param_name in varchar2) is
366: select psv.set_variable_id
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
366: select psv.set_variable_id
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
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
482: and ppd.parameter_def_id = pp.parameter_def_id
483: and pp.parameter_id = pps.set_name_id
488:
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;
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,
601: per_business_groups pbg
602: where ppd1.parameter_name = p_flow_name
603: and ppd1.parameter_def_id = pp1.parameter_def_id
596: pay_parameter_sets pps2,
597: pay_parameters pp1,
598: pay_parameters pp2,
599: pay_parameter_definitions ppd1,
600: pay_parameter_definitions ppd2,
601: per_business_groups pbg
602: where ppd1.parameter_name = p_flow_name
603: and ppd1.parameter_def_id = pp1.parameter_def_id
604: and pp1.parameter_id = pps1.set_name_id
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
623: and pp.parameter_id = pps.set_name_id
624: and pps.set_id = ppf.set_id;
625:
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;