47: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
48: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
49: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE,
50: p_tps_parameter_int_value IN OUT NOCOPY ece_xref_data.xref_int_value%TYPE,
51: p_tps_parameter_name IN OUT NOCOPY vea_parameters.name%TYPE
52: )
53: IS
54: --{
55: l_api_name CONSTANT VARCHAR2(30) := 'getParameterIntValue';
61: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
62: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE)
63: IS
64: SELECT PA.name
65: FROM vea_parameters PA,
66: vea_program_units PU,
67: vea_layer_headers LH
68: WHERE PA.parameter_id = p_tps_parameter_id
69: AND LH.layer_provider_code = p_layer_provider_code
138:
139: ========================================================================*/
140: PROCEDURE
141: saveBranchToGlobal(
142: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
143: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
144: p_layer_id IN vea_layers.layer_id%TYPE,
145: p_sequence_number IN vea_layers.sequence_number%TYPE,
146: p_tps_parameter1_name IN vea_parameters.name%TYPE,
142: p_layer_provider_code IN vea_parameters.layer_provider_code%TYPE,
143: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
144: p_layer_id IN vea_layers.layer_id%TYPE,
145: p_sequence_number IN vea_layers.sequence_number%TYPE,
146: p_tps_parameter1_name IN vea_parameters.name%TYPE,
147: p_tps_parameter1_int_value IN ece_xref_data.xref_int_value%TYPE,
148: p_tps_parameter2_name IN vea_parameters.name%TYPE,
149: p_tps_parameter2_int_value IN ece_xref_data.xref_int_value%TYPE,
150: p_tps_parameter3_name IN vea_parameters.name%TYPE,
144: p_layer_id IN vea_layers.layer_id%TYPE,
145: p_sequence_number IN vea_layers.sequence_number%TYPE,
146: p_tps_parameter1_name IN vea_parameters.name%TYPE,
147: p_tps_parameter1_int_value IN ece_xref_data.xref_int_value%TYPE,
148: p_tps_parameter2_name IN vea_parameters.name%TYPE,
149: p_tps_parameter2_int_value IN ece_xref_data.xref_int_value%TYPE,
150: p_tps_parameter3_name IN vea_parameters.name%TYPE,
151: p_tps_parameter3_int_value IN ece_xref_data.xref_int_value%TYPE,
152: p_tps_parameter4_name IN vea_parameters.name%TYPE,
146: p_tps_parameter1_name IN vea_parameters.name%TYPE,
147: p_tps_parameter1_int_value IN ece_xref_data.xref_int_value%TYPE,
148: p_tps_parameter2_name IN vea_parameters.name%TYPE,
149: p_tps_parameter2_int_value IN ece_xref_data.xref_int_value%TYPE,
150: p_tps_parameter3_name IN vea_parameters.name%TYPE,
151: p_tps_parameter3_int_value IN ece_xref_data.xref_int_value%TYPE,
152: p_tps_parameter4_name IN vea_parameters.name%TYPE,
153: p_tps_parameter4_int_value IN ece_xref_data.xref_int_value%TYPE,
154: p_tps_parameter5_name IN vea_parameters.name%TYPE,
148: p_tps_parameter2_name IN vea_parameters.name%TYPE,
149: p_tps_parameter2_int_value IN ece_xref_data.xref_int_value%TYPE,
150: p_tps_parameter3_name IN vea_parameters.name%TYPE,
151: p_tps_parameter3_int_value IN ece_xref_data.xref_int_value%TYPE,
152: p_tps_parameter4_name IN vea_parameters.name%TYPE,
153: p_tps_parameter4_int_value IN ece_xref_data.xref_int_value%TYPE,
154: p_tps_parameter5_name IN vea_parameters.name%TYPE,
155: p_tps_parameter5_int_value IN ece_xref_data.xref_int_value%TYPE,
156: p_tps_parameter6_name IN vea_parameters.name%TYPE,
150: p_tps_parameter3_name IN vea_parameters.name%TYPE,
151: p_tps_parameter3_int_value IN ece_xref_data.xref_int_value%TYPE,
152: p_tps_parameter4_name IN vea_parameters.name%TYPE,
153: p_tps_parameter4_int_value IN ece_xref_data.xref_int_value%TYPE,
154: p_tps_parameter5_name IN vea_parameters.name%TYPE,
155: p_tps_parameter5_int_value IN ece_xref_data.xref_int_value%TYPE,
156: p_tps_parameter6_name IN vea_parameters.name%TYPE,
157: p_tps_parameter6_int_value IN ece_xref_data.xref_int_value%TYPE,
158: p_tps_parameter7_name IN vea_parameters.name%TYPE,
152: p_tps_parameter4_name IN vea_parameters.name%TYPE,
153: p_tps_parameter4_int_value IN ece_xref_data.xref_int_value%TYPE,
154: p_tps_parameter5_name IN vea_parameters.name%TYPE,
155: p_tps_parameter5_int_value IN ece_xref_data.xref_int_value%TYPE,
156: p_tps_parameter6_name IN vea_parameters.name%TYPE,
157: p_tps_parameter6_int_value IN ece_xref_data.xref_int_value%TYPE,
158: p_tps_parameter7_name IN vea_parameters.name%TYPE,
159: p_tps_parameter7_int_value IN ece_xref_data.xref_int_value%TYPE,
160: p_tps_parameter8_name IN vea_parameters.name%TYPE,
154: p_tps_parameter5_name IN vea_parameters.name%TYPE,
155: p_tps_parameter5_int_value IN ece_xref_data.xref_int_value%TYPE,
156: p_tps_parameter6_name IN vea_parameters.name%TYPE,
157: p_tps_parameter6_int_value IN ece_xref_data.xref_int_value%TYPE,
158: p_tps_parameter7_name IN vea_parameters.name%TYPE,
159: p_tps_parameter7_int_value IN ece_xref_data.xref_int_value%TYPE,
160: p_tps_parameter8_name IN vea_parameters.name%TYPE,
161: p_tps_parameter8_int_value IN ece_xref_data.xref_int_value%TYPE,
162: p_tps_parameter9_name IN vea_parameters.name%TYPE,
156: p_tps_parameter6_name IN vea_parameters.name%TYPE,
157: p_tps_parameter6_int_value IN ece_xref_data.xref_int_value%TYPE,
158: p_tps_parameter7_name IN vea_parameters.name%TYPE,
159: p_tps_parameter7_int_value IN ece_xref_data.xref_int_value%TYPE,
160: p_tps_parameter8_name IN vea_parameters.name%TYPE,
161: p_tps_parameter8_int_value IN ece_xref_data.xref_int_value%TYPE,
162: p_tps_parameter9_name IN vea_parameters.name%TYPE,
163: p_tps_parameter9_int_value IN ece_xref_data.xref_int_value%TYPE,
164: p_tps_parameter10_name IN vea_parameters.name%TYPE,
158: p_tps_parameter7_name IN vea_parameters.name%TYPE,
159: p_tps_parameter7_int_value IN ece_xref_data.xref_int_value%TYPE,
160: p_tps_parameter8_name IN vea_parameters.name%TYPE,
161: p_tps_parameter8_int_value IN ece_xref_data.xref_int_value%TYPE,
162: p_tps_parameter9_name IN vea_parameters.name%TYPE,
163: p_tps_parameter9_int_value IN ece_xref_data.xref_int_value%TYPE,
164: p_tps_parameter10_name IN vea_parameters.name%TYPE,
165: p_tps_parameter10_int_value IN ece_xref_data.xref_int_value%TYPE)
166: IS
160: p_tps_parameter8_name IN vea_parameters.name%TYPE,
161: p_tps_parameter8_int_value IN ece_xref_data.xref_int_value%TYPE,
162: p_tps_parameter9_name IN vea_parameters.name%TYPE,
163: p_tps_parameter9_int_value IN ece_xref_data.xref_int_value%TYPE,
164: p_tps_parameter10_name IN vea_parameters.name%TYPE,
165: p_tps_parameter10_int_value IN ece_xref_data.xref_int_value%TYPE)
166: IS
167: --{
168: l_api_name CONSTANT VARCHAR2(30) := 'saveBranchToGlobal';
346: l_tps_parameter7_int_value ece_xref_data.xref_int_value%TYPE;
347: l_tps_parameter8_int_value ece_xref_data.xref_int_value%TYPE;
348: l_tps_parameter9_int_value ece_xref_data.xref_int_value%TYPE;
349: l_tps_parameter10_int_value ece_xref_data.xref_int_value%TYPE;
350: l_tps_parameter1_name vea_parameters.name%TYPE;
351: l_tps_parameter2_name vea_parameters.name%TYPE;
352: l_tps_parameter3_name vea_parameters.name%TYPE;
353: l_tps_parameter4_name vea_parameters.name%TYPE;
354: l_tps_parameter5_name vea_parameters.name%TYPE;
347: l_tps_parameter8_int_value ece_xref_data.xref_int_value%TYPE;
348: l_tps_parameter9_int_value ece_xref_data.xref_int_value%TYPE;
349: l_tps_parameter10_int_value ece_xref_data.xref_int_value%TYPE;
350: l_tps_parameter1_name vea_parameters.name%TYPE;
351: l_tps_parameter2_name vea_parameters.name%TYPE;
352: l_tps_parameter3_name vea_parameters.name%TYPE;
353: l_tps_parameter4_name vea_parameters.name%TYPE;
354: l_tps_parameter5_name vea_parameters.name%TYPE;
355: l_tps_parameter6_name vea_parameters.name%TYPE;
348: l_tps_parameter9_int_value ece_xref_data.xref_int_value%TYPE;
349: l_tps_parameter10_int_value ece_xref_data.xref_int_value%TYPE;
350: l_tps_parameter1_name vea_parameters.name%TYPE;
351: l_tps_parameter2_name vea_parameters.name%TYPE;
352: l_tps_parameter3_name vea_parameters.name%TYPE;
353: l_tps_parameter4_name vea_parameters.name%TYPE;
354: l_tps_parameter5_name vea_parameters.name%TYPE;
355: l_tps_parameter6_name vea_parameters.name%TYPE;
356: l_tps_parameter7_name vea_parameters.name%TYPE;
349: l_tps_parameter10_int_value ece_xref_data.xref_int_value%TYPE;
350: l_tps_parameter1_name vea_parameters.name%TYPE;
351: l_tps_parameter2_name vea_parameters.name%TYPE;
352: l_tps_parameter3_name vea_parameters.name%TYPE;
353: l_tps_parameter4_name vea_parameters.name%TYPE;
354: l_tps_parameter5_name vea_parameters.name%TYPE;
355: l_tps_parameter6_name vea_parameters.name%TYPE;
356: l_tps_parameter7_name vea_parameters.name%TYPE;
357: l_tps_parameter8_name vea_parameters.name%TYPE;
350: l_tps_parameter1_name vea_parameters.name%TYPE;
351: l_tps_parameter2_name vea_parameters.name%TYPE;
352: l_tps_parameter3_name vea_parameters.name%TYPE;
353: l_tps_parameter4_name vea_parameters.name%TYPE;
354: l_tps_parameter5_name vea_parameters.name%TYPE;
355: l_tps_parameter6_name vea_parameters.name%TYPE;
356: l_tps_parameter7_name vea_parameters.name%TYPE;
357: l_tps_parameter8_name vea_parameters.name%TYPE;
358: l_tps_parameter9_name vea_parameters.name%TYPE;
351: l_tps_parameter2_name vea_parameters.name%TYPE;
352: l_tps_parameter3_name vea_parameters.name%TYPE;
353: l_tps_parameter4_name vea_parameters.name%TYPE;
354: l_tps_parameter5_name vea_parameters.name%TYPE;
355: l_tps_parameter6_name vea_parameters.name%TYPE;
356: l_tps_parameter7_name vea_parameters.name%TYPE;
357: l_tps_parameter8_name vea_parameters.name%TYPE;
358: l_tps_parameter9_name vea_parameters.name%TYPE;
359: l_tps_parameter10_name vea_parameters.name%TYPE;
352: l_tps_parameter3_name vea_parameters.name%TYPE;
353: l_tps_parameter4_name vea_parameters.name%TYPE;
354: l_tps_parameter5_name vea_parameters.name%TYPE;
355: l_tps_parameter6_name vea_parameters.name%TYPE;
356: l_tps_parameter7_name vea_parameters.name%TYPE;
357: l_tps_parameter8_name vea_parameters.name%TYPE;
358: l_tps_parameter9_name vea_parameters.name%TYPE;
359: l_tps_parameter10_name vea_parameters.name%TYPE;
360: --
353: l_tps_parameter4_name vea_parameters.name%TYPE;
354: l_tps_parameter5_name vea_parameters.name%TYPE;
355: l_tps_parameter6_name vea_parameters.name%TYPE;
356: l_tps_parameter7_name vea_parameters.name%TYPE;
357: l_tps_parameter8_name vea_parameters.name%TYPE;
358: l_tps_parameter9_name vea_parameters.name%TYPE;
359: l_tps_parameter10_name vea_parameters.name%TYPE;
360: --
361: --
354: l_tps_parameter5_name vea_parameters.name%TYPE;
355: l_tps_parameter6_name vea_parameters.name%TYPE;
356: l_tps_parameter7_name vea_parameters.name%TYPE;
357: l_tps_parameter8_name vea_parameters.name%TYPE;
358: l_tps_parameter9_name vea_parameters.name%TYPE;
359: l_tps_parameter10_name vea_parameters.name%TYPE;
360: --
361: --
362: --}
355: l_tps_parameter6_name vea_parameters.name%TYPE;
356: l_tps_parameter7_name vea_parameters.name%TYPE;
357: l_tps_parameter8_name vea_parameters.name%TYPE;
358: l_tps_parameter9_name vea_parameters.name%TYPE;
359: l_tps_parameter10_name vea_parameters.name%TYPE;
360: --
361: --
362: --}
363: BEGIN
2546: p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE ,
2547: p_id IN vea_layers.layer_id%TYPE := NULL,
2548: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
2549: p_tp_layer_name IN vea_tp_layers.name%TYPE,
2550: p_tps_parameter1_name IN vea_parameters.name%TYPE,
2551: p_tps_parameter2_name IN vea_parameters.name%TYPE,
2552: p_tps_parameter3_name IN vea_parameters.name%TYPE,
2553: p_tps_parameter4_name IN vea_parameters.name%TYPE,
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2547: p_id IN vea_layers.layer_id%TYPE := NULL,
2548: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
2549: p_tp_layer_name IN vea_tp_layers.name%TYPE,
2550: p_tps_parameter1_name IN vea_parameters.name%TYPE,
2551: p_tps_parameter2_name IN vea_parameters.name%TYPE,
2552: p_tps_parameter3_name IN vea_parameters.name%TYPE,
2553: p_tps_parameter4_name IN vea_parameters.name%TYPE,
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2548: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
2549: p_tp_layer_name IN vea_tp_layers.name%TYPE,
2550: p_tps_parameter1_name IN vea_parameters.name%TYPE,
2551: p_tps_parameter2_name IN vea_parameters.name%TYPE,
2552: p_tps_parameter3_name IN vea_parameters.name%TYPE,
2553: p_tps_parameter4_name IN vea_parameters.name%TYPE,
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2556: p_tps_parameter7_name IN vea_parameters.name%TYPE,
2549: p_tp_layer_name IN vea_tp_layers.name%TYPE,
2550: p_tps_parameter1_name IN vea_parameters.name%TYPE,
2551: p_tps_parameter2_name IN vea_parameters.name%TYPE,
2552: p_tps_parameter3_name IN vea_parameters.name%TYPE,
2553: p_tps_parameter4_name IN vea_parameters.name%TYPE,
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2556: p_tps_parameter7_name IN vea_parameters.name%TYPE,
2557: p_tps_parameter8_name IN vea_parameters.name%TYPE,
2550: p_tps_parameter1_name IN vea_parameters.name%TYPE,
2551: p_tps_parameter2_name IN vea_parameters.name%TYPE,
2552: p_tps_parameter3_name IN vea_parameters.name%TYPE,
2553: p_tps_parameter4_name IN vea_parameters.name%TYPE,
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2556: p_tps_parameter7_name IN vea_parameters.name%TYPE,
2557: p_tps_parameter8_name IN vea_parameters.name%TYPE,
2558: p_tps_parameter9_name IN vea_parameters.name%TYPE,
2551: p_tps_parameter2_name IN vea_parameters.name%TYPE,
2552: p_tps_parameter3_name IN vea_parameters.name%TYPE,
2553: p_tps_parameter4_name IN vea_parameters.name%TYPE,
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2556: p_tps_parameter7_name IN vea_parameters.name%TYPE,
2557: p_tps_parameter8_name IN vea_parameters.name%TYPE,
2558: p_tps_parameter9_name IN vea_parameters.name%TYPE,
2559: p_tps_parameter10_name IN vea_parameters.name%TYPE
2552: p_tps_parameter3_name IN vea_parameters.name%TYPE,
2553: p_tps_parameter4_name IN vea_parameters.name%TYPE,
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2556: p_tps_parameter7_name IN vea_parameters.name%TYPE,
2557: p_tps_parameter8_name IN vea_parameters.name%TYPE,
2558: p_tps_parameter9_name IN vea_parameters.name%TYPE,
2559: p_tps_parameter10_name IN vea_parameters.name%TYPE
2560: )
2553: p_tps_parameter4_name IN vea_parameters.name%TYPE,
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2556: p_tps_parameter7_name IN vea_parameters.name%TYPE,
2557: p_tps_parameter8_name IN vea_parameters.name%TYPE,
2558: p_tps_parameter9_name IN vea_parameters.name%TYPE,
2559: p_tps_parameter10_name IN vea_parameters.name%TYPE
2560: )
2561: IS
2554: p_tps_parameter5_name IN vea_parameters.name%TYPE,
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2556: p_tps_parameter7_name IN vea_parameters.name%TYPE,
2557: p_tps_parameter8_name IN vea_parameters.name%TYPE,
2558: p_tps_parameter9_name IN vea_parameters.name%TYPE,
2559: p_tps_parameter10_name IN vea_parameters.name%TYPE
2560: )
2561: IS
2562: --{
2555: p_tps_parameter6_name IN vea_parameters.name%TYPE,
2556: p_tps_parameter7_name IN vea_parameters.name%TYPE,
2557: p_tps_parameter8_name IN vea_parameters.name%TYPE,
2558: p_tps_parameter9_name IN vea_parameters.name%TYPE,
2559: p_tps_parameter10_name IN vea_parameters.name%TYPE
2560: )
2561: IS
2562: --{
2563: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS';
2805: --{
2806: l_location := '0120';
2807: --
2808:
2809: l_tps_parameter1_id := vea_parameters_sv.getId
2810: (
2811: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2812: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2813: p_name => p_tps_parameter1_name
2830: THEN
2831: --{
2832: l_location := '0140';
2833: --
2834: l_tps_parameter2_id := vea_parameters_sv.getId
2835: (
2836: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2837: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2838: p_name => p_tps_parameter2_name
2854: THEN
2855: --{
2856: l_location := '0160';
2857: --
2858: l_tps_parameter3_id := vea_parameters_sv.getId
2859: (
2860: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2861: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2862: p_name => p_tps_parameter3_name
2877: THEN
2878: --{
2879: l_location := '0180';
2880: --
2881: l_tps_parameter4_id := vea_parameters_sv.getId
2882: (
2883: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2884: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2885: p_name => p_tps_parameter4_name
2900: THEN
2901: --{
2902: l_location := '0200';
2903: --
2904: l_tps_parameter5_id := vea_parameters_sv.getId
2905: (
2906: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2907: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2908: p_name => p_tps_parameter5_name
2923: THEN
2924: --{
2925: l_location := '0220';
2926: --
2927: l_tps_parameter6_id := vea_parameters_sv.getId
2928: (
2929: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2930: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2931: p_name => p_tps_parameter6_name
2946: THEN
2947: --{
2948: l_location := '0240';
2949: --
2950: l_tps_parameter7_id := vea_parameters_sv.getId
2951: (
2952: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2953: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2954: p_name => p_tps_parameter7_name
2969: THEN
2970: --{
2971: l_location := '0260';
2972: --
2973: l_tps_parameter8_id := vea_parameters_sv.getId
2974: (
2975: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2976: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
2977: p_name => p_tps_parameter8_name
2992: THEN
2993: --{
2994: l_location := '0280';
2995: --
2996: l_tps_parameter9_id := vea_parameters_sv.getId
2997: (
2998: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
2999: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
3000: p_name => p_tps_parameter9_name
3015: THEN
3016: --{
3017: l_location := '0300';
3018: --
3019: l_tps_parameter10_id := vea_parameters_sv.getId
3020: (
3021: p_layer_provider_code => vea_layer_headers_sv.g_tps_program_unit_lp_code,
3022: p_program_unit_id => vea_layer_headers_sv.g_tps_program_unit_id,
3023: p_name => p_tps_parameter10_name