12: g_extract_type VARCHAR2(100);
13: g_cutover_date DATE;
14: g_ext_dfn_id NUMBER;
15: g_paypoint VARCHAR2(10);
16: g_start_reason pqp_configuration_values.pcv_information1%TYPE;
17: g_scheme_category pqp_configuration_values.pcv_information1%TYPE;
18: g_scheme_status pqp_configuration_values.pcv_information1%TYPE;
19: g_ser_start_date DATE;
20: g_opt_in VARCHAR2(10);
13: g_cutover_date DATE;
14: g_ext_dfn_id NUMBER;
15: g_paypoint VARCHAR2(10);
16: g_start_reason pqp_configuration_values.pcv_information1%TYPE;
17: g_scheme_category pqp_configuration_values.pcv_information1%TYPE;
18: g_scheme_status pqp_configuration_values.pcv_information1%TYPE;
19: g_ser_start_date DATE;
20: g_opt_in VARCHAR2(10);
21: g_opt_out VARCHAR2(10);
14: g_ext_dfn_id NUMBER;
15: g_paypoint VARCHAR2(10);
16: g_start_reason pqp_configuration_values.pcv_information1%TYPE;
17: g_scheme_category pqp_configuration_values.pcv_information1%TYPE;
18: g_scheme_status pqp_configuration_values.pcv_information1%TYPE;
19: g_ser_start_date DATE;
20: g_opt_in VARCHAR2(10);
21: g_opt_out VARCHAR2(10);
22: g_active_asg_sts_id NUMBER;
30: g_effective_start_date DATE;
31: g_effective_end_date DATE;
32:
33: -- Leaving reason variable
34: g_leaving_reason pqp_configuration_values.pcv_information1%TYPE;
35:
36: -- TYPE r_config_values IS RECORD (
37: -- pcv_information1 pqp_configuration_values.pcv_information1%TYPE,
38: -- pcv_information2 pqp_configuration_values.pcv_information2%TYPE,
33: -- Leaving reason variable
34: g_leaving_reason pqp_configuration_values.pcv_information1%TYPE;
35:
36: -- TYPE r_config_values IS RECORD (
37: -- pcv_information1 pqp_configuration_values.pcv_information1%TYPE,
38: -- pcv_information2 pqp_configuration_values.pcv_information2%TYPE,
39: -- pcv_information3 pqp_configuration_values.pcv_information3%TYPE,
40: -- pcv_information4 pqp_configuration_values.pcv_information4%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
34: g_leaving_reason pqp_configuration_values.pcv_information1%TYPE;
35:
36: -- TYPE r_config_values IS RECORD (
37: -- pcv_information1 pqp_configuration_values.pcv_information1%TYPE,
38: -- pcv_information2 pqp_configuration_values.pcv_information2%TYPE,
39: -- pcv_information3 pqp_configuration_values.pcv_information3%TYPE,
40: -- pcv_information4 pqp_configuration_values.pcv_information4%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
35:
36: -- TYPE r_config_values IS RECORD (
37: -- pcv_information1 pqp_configuration_values.pcv_information1%TYPE,
38: -- pcv_information2 pqp_configuration_values.pcv_information2%TYPE,
39: -- pcv_information3 pqp_configuration_values.pcv_information3%TYPE,
40: -- pcv_information4 pqp_configuration_values.pcv_information4%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
36: -- TYPE r_config_values IS RECORD (
37: -- pcv_information1 pqp_configuration_values.pcv_information1%TYPE,
38: -- pcv_information2 pqp_configuration_values.pcv_information2%TYPE,
39: -- pcv_information3 pqp_configuration_values.pcv_information3%TYPE,
40: -- pcv_information4 pqp_configuration_values.pcv_information4%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
37: -- pcv_information1 pqp_configuration_values.pcv_information1%TYPE,
38: -- pcv_information2 pqp_configuration_values.pcv_information2%TYPE,
39: -- pcv_information3 pqp_configuration_values.pcv_information3%TYPE,
40: -- pcv_information4 pqp_configuration_values.pcv_information4%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
38: -- pcv_information2 pqp_configuration_values.pcv_information2%TYPE,
39: -- pcv_information3 pqp_configuration_values.pcv_information3%TYPE,
40: -- pcv_information4 pqp_configuration_values.pcv_information4%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
39: -- pcv_information3 pqp_configuration_values.pcv_information3%TYPE,
40: -- pcv_information4 pqp_configuration_values.pcv_information4%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
40: -- pcv_information4 pqp_configuration_values.pcv_information4%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
41: -- pcv_information5 pqp_configuration_values.pcv_information5%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
42: -- pcv_information6 pqp_configuration_values.pcv_information6%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
43: -- pcv_information7 pqp_configuration_values.pcv_information7%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
44: -- pcv_information8 pqp_configuration_values.pcv_information8%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
45: -- pcv_information9 pqp_configuration_values.pcv_information9%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
53: -- pcv_information17 pqp_configuration_values.pcv_information17%TYPE,
46: -- pcv_information10 pqp_configuration_values.pcv_information10%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
53: -- pcv_information17 pqp_configuration_values.pcv_information17%TYPE,
54: -- pcv_information18 pqp_configuration_values.pcv_information18%TYPE,
47: -- pcv_information11 pqp_configuration_values.pcv_information11%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
53: -- pcv_information17 pqp_configuration_values.pcv_information17%TYPE,
54: -- pcv_information18 pqp_configuration_values.pcv_information18%TYPE,
55: -- pcv_information19 pqp_configuration_values.pcv_information19%TYPE,
48: -- pcv_information12 pqp_configuration_values.pcv_information12%TYPE,
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
53: -- pcv_information17 pqp_configuration_values.pcv_information17%TYPE,
54: -- pcv_information18 pqp_configuration_values.pcv_information18%TYPE,
55: -- pcv_information19 pqp_configuration_values.pcv_information19%TYPE,
56: -- pcv_information20 pqp_configuration_values.pcv_information20%TYPE
49: -- pcv_information13 pqp_configuration_values.pcv_information13%TYPE,
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
53: -- pcv_information17 pqp_configuration_values.pcv_information17%TYPE,
54: -- pcv_information18 pqp_configuration_values.pcv_information18%TYPE,
55: -- pcv_information19 pqp_configuration_values.pcv_information19%TYPE,
56: -- pcv_information20 pqp_configuration_values.pcv_information20%TYPE
57: -- );
50: -- pcv_information14 pqp_configuration_values.pcv_information14%TYPE,
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
53: -- pcv_information17 pqp_configuration_values.pcv_information17%TYPE,
54: -- pcv_information18 pqp_configuration_values.pcv_information18%TYPE,
55: -- pcv_information19 pqp_configuration_values.pcv_information19%TYPE,
56: -- pcv_information20 pqp_configuration_values.pcv_information20%TYPE
57: -- );
58:
51: -- pcv_information15 pqp_configuration_values.pcv_information15%TYPE,
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
53: -- pcv_information17 pqp_configuration_values.pcv_information17%TYPE,
54: -- pcv_information18 pqp_configuration_values.pcv_information18%TYPE,
55: -- pcv_information19 pqp_configuration_values.pcv_information19%TYPE,
56: -- pcv_information20 pqp_configuration_values.pcv_information20%TYPE
57: -- );
58:
59: TYPE r_element_details IS RECORD(
52: -- pcv_information16 pqp_configuration_values.pcv_information16%TYPE,
53: -- pcv_information17 pqp_configuration_values.pcv_information17%TYPE,
54: -- pcv_information18 pqp_configuration_values.pcv_information18%TYPE,
55: -- pcv_information19 pqp_configuration_values.pcv_information19%TYPE,
56: -- pcv_information20 pqp_configuration_values.pcv_information20%TYPE
57: -- );
58:
59: TYPE r_element_details IS RECORD(
60: element_type_id NUMBER