DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PQP_CONFIGURATION_VALUES

Line 16: g_start_reason pqp_configuration_values.pcv_information1%TYPE;

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);

Line 17: g_scheme_category pqp_configuration_values.pcv_information1%TYPE;

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);

Line 18: g_scheme_status pqp_configuration_values.pcv_information1%TYPE;

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;

Line 34: g_leaving_reason pqp_configuration_values.pcv_information1%TYPE;

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,

Line 37: -- pcv_information1 pqp_configuration_values.pcv_information1%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,

Line 38: -- pcv_information2 pqp_configuration_values.pcv_information2%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,

Line 39: -- pcv_information3 pqp_configuration_values.pcv_information3%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,

Line 40: -- pcv_information4 pqp_configuration_values.pcv_information4%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,

Line 41: -- pcv_information5 pqp_configuration_values.pcv_information5%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,

Line 42: -- pcv_information6 pqp_configuration_values.pcv_information6%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,

Line 43: -- pcv_information7 pqp_configuration_values.pcv_information7%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,

Line 44: -- pcv_information8 pqp_configuration_values.pcv_information8%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,

Line 45: -- pcv_information9 pqp_configuration_values.pcv_information9%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,

Line 46: -- pcv_information10 pqp_configuration_values.pcv_information10%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,

Line 47: -- pcv_information11 pqp_configuration_values.pcv_information11%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,

Line 48: -- pcv_information12 pqp_configuration_values.pcv_information12%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,

Line 49: -- pcv_information13 pqp_configuration_values.pcv_information13%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,

Line 50: -- pcv_information14 pqp_configuration_values.pcv_information14%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,

Line 51: -- pcv_information15 pqp_configuration_values.pcv_information15%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,

Line 52: -- pcv_information16 pqp_configuration_values.pcv_information16%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

Line 53: -- pcv_information17 pqp_configuration_values.pcv_information17%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: -- );

Line 54: -- pcv_information18 pqp_configuration_values.pcv_information18%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: -- );
58:

Line 55: -- pcv_information19 pqp_configuration_values.pcv_information19%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:
59: TYPE r_element_details IS RECORD(

Line 56: -- pcv_information20 pqp_configuration_values.pcv_information20%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(
60: element_type_id NUMBER