DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_PERIOD_QUOTAS

Line 81: -- Period quotas rec ( CN_PERIOD_QUOTAS )

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,

Line 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,

Line 86: period_payment cn_period_quotas.period_payment%TYPE := 0,

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,

Line 87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,

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,

Line 88: attribute1 cn_period_quotas.attribute1%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,

Line 89: attribute2 cn_period_quotas.attribute2%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,

Line 90: attribute3 cn_period_quotas.attribute3%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,

Line 91: attribute4 cn_period_quotas.attribute4%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,

Line 92: attribute5 cn_period_quotas.attribute5%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,

Line 93: attribute6 cn_period_quotas.attribute6%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,

Line 94: attribute7 cn_period_quotas.attribute7%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,

Line 95: attribute8 cn_period_quotas.attribute8%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,

Line 96: attribute9 cn_period_quotas.attribute9%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,

Line 97: attribute10 cn_period_quotas.attribute10%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,

Line 98: attribute11 cn_period_quotas.attribute11%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,

Line 99: attribute12 cn_period_quotas.attribute12%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,

Line 100: attribute13 cn_period_quotas.attribute13%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

Line 101: attribute14 cn_period_quotas.attribute14%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
105: );

Line 102: attribute15 cn_period_quotas.attribute15%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: );
106:

Line 104: org_id cn_period_quotas.org_id%TYPE := 0

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