APPS.OKL_QQH_PVT dependencies on OKL_QUICK_QUOTES_B

Line 34: id okl_quick_quotes_b.id%TYPE

30: ------------------
31:
32: -- Do not include WHO columns in the base table record structure
33: TYPE qqh_rec_type IS RECORD (
34: id okl_quick_quotes_b.id%TYPE
35: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
36: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE

Line 35: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE

31:
32: -- Do not include WHO columns in the base table record structure
33: TYPE qqh_rec_type IS RECORD (
34: id okl_quick_quotes_b.id%TYPE
35: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
36: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE

Line 36: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE

32: -- Do not include WHO columns in the base table record structure
33: TYPE qqh_rec_type IS RECORD (
34: id okl_quick_quotes_b.id%TYPE
35: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
36: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE

Line 37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE

33: TYPE qqh_rec_type IS RECORD (
34: id okl_quick_quotes_b.id%TYPE
35: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
36: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE

Line 38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE

34: id okl_quick_quotes_b.id%TYPE
35: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
36: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE

Line 39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE

35: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
36: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE

Line 40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE

36: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE

Line 41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE

37: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE

Line 42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE

38: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE

Line 43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE

39: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE

Line 44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE

40: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE

Line 45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE

41: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE

Line 46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE

42: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE

Line 47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE

43: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE

Line 48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE

44: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52: ,reference_number okl_quick_quotes_b.reference_number%TYPE

Line 49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE

45: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52: ,reference_number okl_quick_quotes_b.reference_number%TYPE
53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE

Line 50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE

46: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52: ,reference_number okl_quick_quotes_b.reference_number%TYPE
53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54: ,org_id okl_quick_quotes_b.org_id%TYPE

Line 51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE

47: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52: ,reference_number okl_quick_quotes_b.reference_number%TYPE
53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54: ,org_id okl_quick_quotes_b.org_id%TYPE
55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE

Line 52: ,reference_number okl_quick_quotes_b.reference_number%TYPE

48: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52: ,reference_number okl_quick_quotes_b.reference_number%TYPE
53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54: ,org_id okl_quick_quotes_b.org_id%TYPE
55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56: ,currency_code okl_quick_quotes_b.currency_code%TYPE

Line 53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE

49: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52: ,reference_number okl_quick_quotes_b.reference_number%TYPE
53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54: ,org_id okl_quick_quotes_b.org_id%TYPE
55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56: ,currency_code okl_quick_quotes_b.currency_code%TYPE
57: ,term okl_quick_quotes_b.term%TYPE

Line 54: ,org_id okl_quick_quotes_b.org_id%TYPE

50: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52: ,reference_number okl_quick_quotes_b.reference_number%TYPE
53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54: ,org_id okl_quick_quotes_b.org_id%TYPE
55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56: ,currency_code okl_quick_quotes_b.currency_code%TYPE
57: ,term okl_quick_quotes_b.term%TYPE
58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE

Line 55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE

51: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52: ,reference_number okl_quick_quotes_b.reference_number%TYPE
53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54: ,org_id okl_quick_quotes_b.org_id%TYPE
55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56: ,currency_code okl_quick_quotes_b.currency_code%TYPE
57: ,term okl_quick_quotes_b.term%TYPE
58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE

Line 56: ,currency_code okl_quick_quotes_b.currency_code%TYPE

52: ,reference_number okl_quick_quotes_b.reference_number%TYPE
53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54: ,org_id okl_quick_quotes_b.org_id%TYPE
55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56: ,currency_code okl_quick_quotes_b.currency_code%TYPE
57: ,term okl_quick_quotes_b.term%TYPE
58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE

Line 57: ,term okl_quick_quotes_b.term%TYPE

53: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54: ,org_id okl_quick_quotes_b.org_id%TYPE
55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56: ,currency_code okl_quick_quotes_b.currency_code%TYPE
57: ,term okl_quick_quotes_b.term%TYPE
58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE

Line 58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE

54: ,org_id okl_quick_quotes_b.org_id%TYPE
55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56: ,currency_code okl_quick_quotes_b.currency_code%TYPE
57: ,term okl_quick_quotes_b.term%TYPE
58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE

Line 59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE

55: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56: ,currency_code okl_quick_quotes_b.currency_code%TYPE
57: ,term okl_quick_quotes_b.term%TYPE
58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE

Line 60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE

56: ,currency_code okl_quick_quotes_b.currency_code%TYPE
57: ,term okl_quick_quotes_b.term%TYPE
58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE

Line 61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE

57: ,term okl_quick_quotes_b.term%TYPE
58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE

Line 62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE

58: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE

Line 63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE

59: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE

Line 64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE

60: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE

Line 65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE

61: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE

Line 66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE

62: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE

Line 67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE

63: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71: ,target_rate okl_quick_quotes_b.target_rate%TYPE

Line 68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE

64: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71: ,target_rate okl_quick_quotes_b.target_rate%TYPE
72: ,target_amount okl_quick_quotes_b.target_amount%TYPE

Line 69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE

65: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71: ,target_rate okl_quick_quotes_b.target_rate%TYPE
72: ,target_amount okl_quick_quotes_b.target_amount%TYPE
73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE

Line 70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE

66: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71: ,target_rate okl_quick_quotes_b.target_rate%TYPE
72: ,target_amount okl_quick_quotes_b.target_amount%TYPE
73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE

Line 71: ,target_rate okl_quick_quotes_b.target_rate%TYPE

67: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71: ,target_rate okl_quick_quotes_b.target_rate%TYPE
72: ,target_amount okl_quick_quotes_b.target_amount%TYPE
73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75: ,target_periods okl_quick_quotes_b.target_periods%TYPE

Line 72: ,target_amount okl_quick_quotes_b.target_amount%TYPE

68: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71: ,target_rate okl_quick_quotes_b.target_rate%TYPE
72: ,target_amount okl_quick_quotes_b.target_amount%TYPE
73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75: ,target_periods okl_quick_quotes_b.target_periods%TYPE
76: ,iir okl_quick_quotes_b.iir%TYPE

Line 73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE

69: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71: ,target_rate okl_quick_quotes_b.target_rate%TYPE
72: ,target_amount okl_quick_quotes_b.target_amount%TYPE
73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75: ,target_periods okl_quick_quotes_b.target_periods%TYPE
76: ,iir okl_quick_quotes_b.iir%TYPE
77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE

Line 74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE

70: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71: ,target_rate okl_quick_quotes_b.target_rate%TYPE
72: ,target_amount okl_quick_quotes_b.target_amount%TYPE
73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75: ,target_periods okl_quick_quotes_b.target_periods%TYPE
76: ,iir okl_quick_quotes_b.iir%TYPE
77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE

Line 75: ,target_periods okl_quick_quotes_b.target_periods%TYPE

71: ,target_rate okl_quick_quotes_b.target_rate%TYPE
72: ,target_amount okl_quick_quotes_b.target_amount%TYPE
73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75: ,target_periods okl_quick_quotes_b.target_periods%TYPE
76: ,iir okl_quick_quotes_b.iir%TYPE
77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE

Line 76: ,iir okl_quick_quotes_b.iir%TYPE

72: ,target_amount okl_quick_quotes_b.target_amount%TYPE
73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75: ,target_periods okl_quick_quotes_b.target_periods%TYPE
76: ,iir okl_quick_quotes_b.iir%TYPE
77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80: ,pirr okl_quick_quotes_b.pirr%TYPE

Line 77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE

73: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75: ,target_periods okl_quick_quotes_b.target_periods%TYPE
76: ,iir okl_quick_quotes_b.iir%TYPE
77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80: ,pirr okl_quick_quotes_b.pirr%TYPE
81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE

Line 78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE

74: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75: ,target_periods okl_quick_quotes_b.target_periods%TYPE
76: ,iir okl_quick_quotes_b.iir%TYPE
77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80: ,pirr okl_quick_quotes_b.pirr%TYPE
81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
82: ,airr okl_quick_quotes_b.airr%TYPE

Line 79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE

75: ,target_periods okl_quick_quotes_b.target_periods%TYPE
76: ,iir okl_quick_quotes_b.iir%TYPE
77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80: ,pirr okl_quick_quotes_b.pirr%TYPE
81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
82: ,airr okl_quick_quotes_b.airr%TYPE
83: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE

Line 80: ,pirr okl_quick_quotes_b.pirr%TYPE

76: ,iir okl_quick_quotes_b.iir%TYPE
77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80: ,pirr okl_quick_quotes_b.pirr%TYPE
81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
82: ,airr okl_quick_quotes_b.airr%TYPE
83: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
84: -- abhsaxen - added - start

Line 81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE

77: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80: ,pirr okl_quick_quotes_b.pirr%TYPE
81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
82: ,airr okl_quick_quotes_b.airr%TYPE
83: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
84: -- abhsaxen - added - start
85: ,sts_code okl_quick_quotes_b.sts_code%TYPE

Line 82: ,airr okl_quick_quotes_b.airr%TYPE

78: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80: ,pirr okl_quick_quotes_b.pirr%TYPE
81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
82: ,airr okl_quick_quotes_b.airr%TYPE
83: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
84: -- abhsaxen - added - start
85: ,sts_code okl_quick_quotes_b.sts_code%TYPE
86: -- abhsaxen - added - end

Line 83: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE

79: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80: ,pirr okl_quick_quotes_b.pirr%TYPE
81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
82: ,airr okl_quick_quotes_b.airr%TYPE
83: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
84: -- abhsaxen - added - start
85: ,sts_code okl_quick_quotes_b.sts_code%TYPE
86: -- abhsaxen - added - end
87: );

Line 85: ,sts_code okl_quick_quotes_b.sts_code%TYPE

81: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
82: ,airr okl_quick_quotes_b.airr%TYPE
83: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
84: -- abhsaxen - added - start
85: ,sts_code okl_quick_quotes_b.sts_code%TYPE
86: -- abhsaxen - added - end
87: );
88:
89: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure

Line 99: id okl_quick_quotes_b.id%TYPE

95: );
96:
97: -- view record structure
98: TYPE qqhv_rec_type IS RECORD (
99: id okl_quick_quotes_b.id%TYPE
100: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
101: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE

Line 100: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE

96:
97: -- view record structure
98: TYPE qqhv_rec_type IS RECORD (
99: id okl_quick_quotes_b.id%TYPE
100: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
101: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE

Line 101: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE

97: -- view record structure
98: TYPE qqhv_rec_type IS RECORD (
99: id okl_quick_quotes_b.id%TYPE
100: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
101: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE

Line 102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE

98: TYPE qqhv_rec_type IS RECORD (
99: id okl_quick_quotes_b.id%TYPE
100: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
101: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE

Line 103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE

99: id okl_quick_quotes_b.id%TYPE
100: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
101: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE

Line 104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE

100: ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
101: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE

Line 105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE

101: ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE

Line 106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE

102: ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE

Line 107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE

103: ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE

Line 108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE

104: ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE

Line 109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE

105: ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE

Line 110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE

106: ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE

Line 111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE

107: ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE

Line 112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE

108: ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE

Line 113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE

109: ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117: ,reference_number okl_quick_quotes_b.reference_number%TYPE

Line 114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE

110: ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117: ,reference_number okl_quick_quotes_b.reference_number%TYPE
118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE

Line 115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE

111: ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117: ,reference_number okl_quick_quotes_b.reference_number%TYPE
118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119: ,org_id okl_quick_quotes_b.org_id%TYPE

Line 116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE

112: ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117: ,reference_number okl_quick_quotes_b.reference_number%TYPE
118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119: ,org_id okl_quick_quotes_b.org_id%TYPE
120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE

Line 117: ,reference_number okl_quick_quotes_b.reference_number%TYPE

113: ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117: ,reference_number okl_quick_quotes_b.reference_number%TYPE
118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119: ,org_id okl_quick_quotes_b.org_id%TYPE
120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121: ,currency_code okl_quick_quotes_b.currency_code%TYPE

Line 118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE

114: ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117: ,reference_number okl_quick_quotes_b.reference_number%TYPE
118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119: ,org_id okl_quick_quotes_b.org_id%TYPE
120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121: ,currency_code okl_quick_quotes_b.currency_code%TYPE
122: ,term okl_quick_quotes_b.term%TYPE

Line 119: ,org_id okl_quick_quotes_b.org_id%TYPE

115: ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117: ,reference_number okl_quick_quotes_b.reference_number%TYPE
118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119: ,org_id okl_quick_quotes_b.org_id%TYPE
120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121: ,currency_code okl_quick_quotes_b.currency_code%TYPE
122: ,term okl_quick_quotes_b.term%TYPE
123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE

Line 120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE

116: ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117: ,reference_number okl_quick_quotes_b.reference_number%TYPE
118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119: ,org_id okl_quick_quotes_b.org_id%TYPE
120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121: ,currency_code okl_quick_quotes_b.currency_code%TYPE
122: ,term okl_quick_quotes_b.term%TYPE
123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE

Line 121: ,currency_code okl_quick_quotes_b.currency_code%TYPE

117: ,reference_number okl_quick_quotes_b.reference_number%TYPE
118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119: ,org_id okl_quick_quotes_b.org_id%TYPE
120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121: ,currency_code okl_quick_quotes_b.currency_code%TYPE
122: ,term okl_quick_quotes_b.term%TYPE
123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE

Line 122: ,term okl_quick_quotes_b.term%TYPE

118: ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119: ,org_id okl_quick_quotes_b.org_id%TYPE
120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121: ,currency_code okl_quick_quotes_b.currency_code%TYPE
122: ,term okl_quick_quotes_b.term%TYPE
123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE

Line 123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE

119: ,org_id okl_quick_quotes_b.org_id%TYPE
120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121: ,currency_code okl_quick_quotes_b.currency_code%TYPE
122: ,term okl_quick_quotes_b.term%TYPE
123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE

Line 124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE

120: ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121: ,currency_code okl_quick_quotes_b.currency_code%TYPE
122: ,term okl_quick_quotes_b.term%TYPE
123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE

Line 125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE

121: ,currency_code okl_quick_quotes_b.currency_code%TYPE
122: ,term okl_quick_quotes_b.term%TYPE
123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE

Line 126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE

122: ,term okl_quick_quotes_b.term%TYPE
123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE

Line 127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE

123: ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE

Line 128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE

124: ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE

Line 129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE

125: ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE

Line 130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE

126: ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE

Line 131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE

127: ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE

Line 132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE

128: ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136: ,target_rate okl_quick_quotes_b.target_rate%TYPE

Line 133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE

129: ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136: ,target_rate okl_quick_quotes_b.target_rate%TYPE
137: ,target_amount okl_quick_quotes_b.target_amount%TYPE

Line 134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE

130: ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136: ,target_rate okl_quick_quotes_b.target_rate%TYPE
137: ,target_amount okl_quick_quotes_b.target_amount%TYPE
138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE

Line 135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE

131: ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136: ,target_rate okl_quick_quotes_b.target_rate%TYPE
137: ,target_amount okl_quick_quotes_b.target_amount%TYPE
138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE

Line 136: ,target_rate okl_quick_quotes_b.target_rate%TYPE

132: ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136: ,target_rate okl_quick_quotes_b.target_rate%TYPE
137: ,target_amount okl_quick_quotes_b.target_amount%TYPE
138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140: ,target_periods okl_quick_quotes_b.target_periods%TYPE

Line 137: ,target_amount okl_quick_quotes_b.target_amount%TYPE

133: ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136: ,target_rate okl_quick_quotes_b.target_rate%TYPE
137: ,target_amount okl_quick_quotes_b.target_amount%TYPE
138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140: ,target_periods okl_quick_quotes_b.target_periods%TYPE
141: ,iir okl_quick_quotes_b.iir%TYPE

Line 138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE

134: ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136: ,target_rate okl_quick_quotes_b.target_rate%TYPE
137: ,target_amount okl_quick_quotes_b.target_amount%TYPE
138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140: ,target_periods okl_quick_quotes_b.target_periods%TYPE
141: ,iir okl_quick_quotes_b.iir%TYPE
142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE

Line 139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE

135: ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136: ,target_rate okl_quick_quotes_b.target_rate%TYPE
137: ,target_amount okl_quick_quotes_b.target_amount%TYPE
138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140: ,target_periods okl_quick_quotes_b.target_periods%TYPE
141: ,iir okl_quick_quotes_b.iir%TYPE
142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE

Line 140: ,target_periods okl_quick_quotes_b.target_periods%TYPE

136: ,target_rate okl_quick_quotes_b.target_rate%TYPE
137: ,target_amount okl_quick_quotes_b.target_amount%TYPE
138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140: ,target_periods okl_quick_quotes_b.target_periods%TYPE
141: ,iir okl_quick_quotes_b.iir%TYPE
142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE

Line 141: ,iir okl_quick_quotes_b.iir%TYPE

137: ,target_amount okl_quick_quotes_b.target_amount%TYPE
138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140: ,target_periods okl_quick_quotes_b.target_periods%TYPE
141: ,iir okl_quick_quotes_b.iir%TYPE
142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145: ,pirr okl_quick_quotes_b.pirr%TYPE

Line 142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE

138: ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140: ,target_periods okl_quick_quotes_b.target_periods%TYPE
141: ,iir okl_quick_quotes_b.iir%TYPE
142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145: ,pirr okl_quick_quotes_b.pirr%TYPE
146: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE

Line 143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE

139: ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140: ,target_periods okl_quick_quotes_b.target_periods%TYPE
141: ,iir okl_quick_quotes_b.iir%TYPE
142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145: ,pirr okl_quick_quotes_b.pirr%TYPE
146: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
147: ,airr okl_quick_quotes_b.airr%TYPE

Line 144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE

140: ,target_periods okl_quick_quotes_b.target_periods%TYPE
141: ,iir okl_quick_quotes_b.iir%TYPE
142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145: ,pirr okl_quick_quotes_b.pirr%TYPE
146: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
147: ,airr okl_quick_quotes_b.airr%TYPE
148: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE

Line 145: ,pirr okl_quick_quotes_b.pirr%TYPE

141: ,iir okl_quick_quotes_b.iir%TYPE
142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145: ,pirr okl_quick_quotes_b.pirr%TYPE
146: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
147: ,airr okl_quick_quotes_b.airr%TYPE
148: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
149: ,short_description okl_quick_quotes_tl.short_description%TYPE

Line 146: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE

142: ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145: ,pirr okl_quick_quotes_b.pirr%TYPE
146: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
147: ,airr okl_quick_quotes_b.airr%TYPE
148: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
149: ,short_description okl_quick_quotes_tl.short_description%TYPE
150: ,description okl_quick_quotes_tl.description%TYPE

Line 147: ,airr okl_quick_quotes_b.airr%TYPE

143: ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145: ,pirr okl_quick_quotes_b.pirr%TYPE
146: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
147: ,airr okl_quick_quotes_b.airr%TYPE
148: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
149: ,short_description okl_quick_quotes_tl.short_description%TYPE
150: ,description okl_quick_quotes_tl.description%TYPE
151: ,comments okl_quick_quotes_tl.comments%TYPE

Line 148: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE

144: ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145: ,pirr okl_quick_quotes_b.pirr%TYPE
146: ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
147: ,airr okl_quick_quotes_b.airr%TYPE
148: ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
149: ,short_description okl_quick_quotes_tl.short_description%TYPE
150: ,description okl_quick_quotes_tl.description%TYPE
151: ,comments okl_quick_quotes_tl.comments%TYPE
152: -- abhsaxen - added - start

Line 153: ,sts_code okl_quick_quotes_b.sts_code%TYPE

149: ,short_description okl_quick_quotes_tl.short_description%TYPE
150: ,description okl_quick_quotes_tl.description%TYPE
151: ,comments okl_quick_quotes_tl.comments%TYPE
152: -- abhsaxen - added - start
153: ,sts_code okl_quick_quotes_b.sts_code%TYPE
154: -- abhsaxen - added - end
155: );
156:
157: TYPE qqhv_tbl_type IS TABLE OF qqhv_rec_type INDEX BY BINARY_INTEGER;