77: --
78: g_miss_plan_element_rec_tbl plan_element_rec_tbl_type;
79:
80: --
81: -- Period quotas rec ( CN_PERIOD_QUOTAS )
82: --
83: TYPE period_quotas_rec_type IS RECORD (
84: period_name cn_periods.period_name%TYPE := cn_api.g_miss_char,
85: period_target cn_period_quotas.period_target%TYPE := 0,
81: -- Period quotas rec ( CN_PERIOD_QUOTAS )
82: --
83: TYPE period_quotas_rec_type IS RECORD (
84: period_name cn_periods.period_name%TYPE := cn_api.g_miss_char,
85: period_target cn_period_quotas.period_target%TYPE := 0,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
82: --
83: TYPE period_quotas_rec_type IS RECORD (
84: period_name cn_periods.period_name%TYPE := cn_api.g_miss_char,
85: period_target cn_period_quotas.period_target%TYPE := 0,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
83: TYPE period_quotas_rec_type IS RECORD (
84: period_name cn_periods.period_name%TYPE := cn_api.g_miss_char,
85: period_target cn_period_quotas.period_target%TYPE := 0,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
84: period_name cn_periods.period_name%TYPE := cn_api.g_miss_char,
85: period_target cn_period_quotas.period_target%TYPE := 0,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
85: period_target cn_period_quotas.period_target%TYPE := 0,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
104: org_id cn_period_quotas.org_id%TYPE := 0
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
104: org_id cn_period_quotas.org_id%TYPE := 0
105: );
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
104: org_id cn_period_quotas.org_id%TYPE := 0
105: );
106:
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
104: org_id cn_period_quotas.org_id%TYPE := 0
105: );
106:
107: --
108: -- Period Quotas table Type