DBA Data[Home] [Help]

APPS.OKL_QUL_PVT dependencies on OKL_QUOTE_SUBPOOL_USAGE

Line 34: id okl_quote_subpool_usage.id%TYPE

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

Line 35: ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE

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

Line 36: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE

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

Line 37: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE

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

Line 38: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE

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

Line 39: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE

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

Line 40: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE

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

Line 41: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE

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

Line 42: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE

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

Line 43: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE

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

Line 44: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE

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

Line 45: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE

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

Line 46: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE

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

Line 47: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE

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

Line 48: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE

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

Line 49: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE

45: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
46: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
47: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
48: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
49: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
50: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
51: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE

Line 50: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE

46: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
47: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
48: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
49: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
50: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
51: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE

Line 51: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE

47: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
48: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
49: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
50: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
51: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE

Line 52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE

48: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
49: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
50: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
51: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE

Line 53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE

49: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
50: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
51: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE

Line 54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE

50: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
51: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE

Line 55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE

51: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE

Line 56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE

52: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE

Line 57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE

53: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE

Line 58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE

54: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
62: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE

Line 59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE

55: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
62: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
63: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE

Line 60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE

56: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
62: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
63: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
64: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE

Line 61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE

57: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
62: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
63: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
64: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
65: );

Line 62: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE

58: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
62: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
63: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
64: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
65: );
66:

Line 63: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE

59: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
62: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
63: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
64: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
65: );
66:
67: -- view record structure

Line 64: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE

60: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
62: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
63: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
64: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
65: );
66:
67: -- view record structure
68: TYPE qulv_rec_type IS RECORD (

Line 69: id okl_quote_subpool_usage.id%TYPE

65: );
66:
67: -- view record structure
68: TYPE qulv_rec_type IS RECORD (
69: id okl_quote_subpool_usage.id%TYPE
70: ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE
71: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE

Line 70: ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE

66:
67: -- view record structure
68: TYPE qulv_rec_type IS RECORD (
69: id okl_quote_subpool_usage.id%TYPE
70: ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE
71: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE

Line 71: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE

67: -- view record structure
68: TYPE qulv_rec_type IS RECORD (
69: id okl_quote_subpool_usage.id%TYPE
70: ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE
71: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE

Line 72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE

68: TYPE qulv_rec_type IS RECORD (
69: id okl_quote_subpool_usage.id%TYPE
70: ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE
71: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE

Line 73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE

69: id okl_quote_subpool_usage.id%TYPE
70: ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE
71: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE

Line 74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE

70: ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE
71: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE

Line 75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE

71: ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE

Line 76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE

72: ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE

Line 77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE

73: ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE

Line 78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE

74: ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE

Line 79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE

75: ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE

Line 80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE

76: ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE

Line 81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE

77: ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE

Line 82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE

78: ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE

Line 83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE

79: ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE

Line 84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE

80: ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE

Line 85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE

81: ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE

Line 86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE

82: ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE

Line 87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE

83: ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE

Line 88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE

84: ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE

Line 89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE

85: ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE

Line 90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE

86: ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE

Line 91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE

87: ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE

Line 92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE

88: ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE

Line 93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE

89: ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
97: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE

Line 94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE

90: ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
97: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
98: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE

Line 95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE

91: ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
97: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
98: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
99: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE

Line 96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE

92: ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
97: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
98: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
99: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
100: );

Line 97: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE

93: ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
97: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
98: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
99: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
100: );
101:

Line 98: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE

94: ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
97: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
98: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
99: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
100: );
101:
102: TYPE qulv_tbl_type IS TABLE OF qulv_rec_type INDEX BY BINARY_INTEGER;

Line 99: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE

95: ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96: ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
97: ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
98: ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
99: ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
100: );
101:
102: TYPE qulv_tbl_type IS TABLE OF qulv_rec_type INDEX BY BINARY_INTEGER;
103: