eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PERFORMANCE_PVT dependencies on FND_API

Line 74: offer_performance_id NUMBER := FND_API.G_MISS_NUM,

70:
71: --===================================================================
72: TYPE offer_perf_rec_type IS RECORD
73: (
74: offer_performance_id NUMBER := FND_API.G_MISS_NUM,
75: list_header_id NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: last_updated_by NUMBER := FND_API.G_MISS_NUM,
78: creation_date DATE := FND_API.G_MISS_DATE,

Line 75: list_header_id NUMBER := FND_API.G_MISS_NUM,

71: --===================================================================
72: TYPE offer_perf_rec_type IS RECORD
73: (
74: offer_performance_id NUMBER := FND_API.G_MISS_NUM,
75: list_header_id NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: last_updated_by NUMBER := FND_API.G_MISS_NUM,
78: creation_date DATE := FND_API.G_MISS_DATE,
79: created_by NUMBER := FND_API.G_MISS_NUM,

Line 76: last_update_date DATE := FND_API.G_MISS_DATE,

72: TYPE offer_perf_rec_type IS RECORD
73: (
74: offer_performance_id NUMBER := FND_API.G_MISS_NUM,
75: list_header_id NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: last_updated_by NUMBER := FND_API.G_MISS_NUM,
78: creation_date DATE := FND_API.G_MISS_DATE,
79: created_by NUMBER := FND_API.G_MISS_NUM,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 77: last_updated_by NUMBER := FND_API.G_MISS_NUM,

73: (
74: offer_performance_id NUMBER := FND_API.G_MISS_NUM,
75: list_header_id NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: last_updated_by NUMBER := FND_API.G_MISS_NUM,
78: creation_date DATE := FND_API.G_MISS_DATE,
79: created_by NUMBER := FND_API.G_MISS_NUM,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 78: creation_date DATE := FND_API.G_MISS_DATE,

74: offer_performance_id NUMBER := FND_API.G_MISS_NUM,
75: list_header_id NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: last_updated_by NUMBER := FND_API.G_MISS_NUM,
78: creation_date DATE := FND_API.G_MISS_DATE,
79: created_by NUMBER := FND_API.G_MISS_NUM,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 79: created_by NUMBER := FND_API.G_MISS_NUM,

75: list_header_id NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: last_updated_by NUMBER := FND_API.G_MISS_NUM,
78: creation_date DATE := FND_API.G_MISS_DATE,
79: created_by NUMBER := FND_API.G_MISS_NUM,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 80: last_update_login NUMBER := FND_API.G_MISS_NUM,

76: last_update_date DATE := FND_API.G_MISS_DATE,
77: last_updated_by NUMBER := FND_API.G_MISS_NUM,
78: creation_date DATE := FND_API.G_MISS_DATE,
79: created_by NUMBER := FND_API.G_MISS_NUM,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 81: object_version_number NUMBER := FND_API.G_MISS_NUM,

77: last_updated_by NUMBER := FND_API.G_MISS_NUM,
78: creation_date DATE := FND_API.G_MISS_DATE,
79: created_by NUMBER := FND_API.G_MISS_NUM,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: channel_id NUMBER := FND_API.G_MISS_NUM,

Line 82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,

78: creation_date DATE := FND_API.G_MISS_DATE,
79: created_by NUMBER := FND_API.G_MISS_NUM,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: channel_id NUMBER := FND_API.G_MISS_NUM,
86: start_date DATE := FND_API.G_MISS_DATE,

Line 83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,

79: created_by NUMBER := FND_API.G_MISS_NUM,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: channel_id NUMBER := FND_API.G_MISS_NUM,
86: start_date DATE := FND_API.G_MISS_DATE,
87: end_date DATE := FND_API.G_MISS_DATE,

Line 84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,

80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: channel_id NUMBER := FND_API.G_MISS_NUM,
86: start_date DATE := FND_API.G_MISS_DATE,
87: end_date DATE := FND_API.G_MISS_DATE,
88: estimated_value NUMBER := FND_API.G_MISS_NUM,

Line 85: channel_id NUMBER := FND_API.G_MISS_NUM,

81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: channel_id NUMBER := FND_API.G_MISS_NUM,
86: start_date DATE := FND_API.G_MISS_DATE,
87: end_date DATE := FND_API.G_MISS_DATE,
88: estimated_value NUMBER := FND_API.G_MISS_NUM,
89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 86: start_date DATE := FND_API.G_MISS_DATE,

82: product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: channel_id NUMBER := FND_API.G_MISS_NUM,
86: start_date DATE := FND_API.G_MISS_DATE,
87: end_date DATE := FND_API.G_MISS_DATE,
88: estimated_value NUMBER := FND_API.G_MISS_NUM,
89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 87: end_date DATE := FND_API.G_MISS_DATE,

83: product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: channel_id NUMBER := FND_API.G_MISS_NUM,
86: start_date DATE := FND_API.G_MISS_DATE,
87: end_date DATE := FND_API.G_MISS_DATE,
88: estimated_value NUMBER := FND_API.G_MISS_NUM,
89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 88: estimated_value NUMBER := FND_API.G_MISS_NUM,

84: product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: channel_id NUMBER := FND_API.G_MISS_NUM,
86: start_date DATE := FND_API.G_MISS_DATE,
87: end_date DATE := FND_API.G_MISS_DATE,
88: estimated_value NUMBER := FND_API.G_MISS_NUM,
89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

85: channel_id NUMBER := FND_API.G_MISS_NUM,
86: start_date DATE := FND_API.G_MISS_DATE,
87: end_date DATE := FND_API.G_MISS_DATE,
88: estimated_value NUMBER := FND_API.G_MISS_NUM,
89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

86: start_date DATE := FND_API.G_MISS_DATE,
87: end_date DATE := FND_API.G_MISS_DATE,
88: estimated_value NUMBER := FND_API.G_MISS_NUM,
89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

87: end_date DATE := FND_API.G_MISS_DATE,
88: estimated_value NUMBER := FND_API.G_MISS_NUM,
89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

88: estimated_value NUMBER := FND_API.G_MISS_NUM,
89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

89: required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

90: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

91: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

92: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

93: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

94: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

95: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

96: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

97: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

98: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

99: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: security_group_id NUMBER := FND_API.G_MISS_NUM,
107: requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

100: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: security_group_id NUMBER := FND_API.G_MISS_NUM,
107: requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

101: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: security_group_id NUMBER := FND_API.G_MISS_NUM,
107: requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: description VARCHAR2(4000) := FND_API.G_MISS_CHAR

Line 106: security_group_id NUMBER := FND_API.G_MISS_NUM,

102: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: security_group_id NUMBER := FND_API.G_MISS_NUM,
107: requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
110: );

Line 107: requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

103: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: security_group_id NUMBER := FND_API.G_MISS_NUM,
107: requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
110: );
111:

Line 108: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

104: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: security_group_id NUMBER := FND_API.G_MISS_NUM,
107: requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
110: );
111:
112: g_miss_offer_perf_rec offer_perf_rec_type;

Line 109: description VARCHAR2(4000) := FND_API.G_MISS_CHAR

105: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: security_group_id NUMBER := FND_API.G_MISS_NUM,
107: requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
110: );
111:
112: g_miss_offer_perf_rec offer_perf_rec_type;
113: TYPE offer_perf_tbl_type IS TABLE OF offer_perf_rec_type INDEX BY BINARY_INTEGER;

Line 130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

126: -- Parameters
127: --
128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_offer_perf_rec IN offer_perf_rec_type Required
134: --

Line 131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

127: --
128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_offer_perf_rec IN offer_perf_rec_type Required
134: --
135: -- OUT

Line 132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_offer_perf_rec IN offer_perf_rec_type Required
134: --
135: -- OUT
136: -- x_return_status OUT VARCHAR2

Line 149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

145: --
146:
147: PROCEDURE Create_Offer_Performance(
148: p_api_version_number IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152:
153: x_return_status OUT NOCOPY VARCHAR2,

Line 150: p_commit IN VARCHAR2 := FND_API.G_FALSE,

146:
147: PROCEDURE Create_Offer_Performance(
148: p_api_version_number IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152:
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,

Line 151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

147: PROCEDURE Create_Offer_Performance(
148: p_api_version_number IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152:
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,

Line 174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

170: -- Parameters
171: --
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_offer_perf_rec IN offer_perf_rec_type Required
178: --

Line 175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

171: --
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_offer_perf_rec IN offer_perf_rec_type Required
178: --
179: -- OUT

Line 176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_offer_perf_rec IN offer_perf_rec_type Required
178: --
179: -- OUT
180: -- x_return_status OUT VARCHAR2

Line 193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

189: --
190:
191: PROCEDURE Update_Offer_Performance(
192: p_api_version_number IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196:
197: x_return_status OUT NOCOPY VARCHAR2,

Line 194: p_commit IN VARCHAR2 := FND_API.G_FALSE,

190:
191: PROCEDURE Update_Offer_Performance(
192: p_api_version_number IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196:
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,

Line 195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

191: PROCEDURE Update_Offer_Performance(
192: p_api_version_number IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196:
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,

Line 218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

214: -- Parameters
215: --
216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_OFFER_PERFORMANCE_ID IN NUMBER
222: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

215: --
216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_OFFER_PERFORMANCE_ID IN NUMBER
222: -- p_object_version_number IN NUMBER Optional Default = NULL
223: --

Line 220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_OFFER_PERFORMANCE_ID IN NUMBER
222: -- p_object_version_number IN NUMBER Optional Default = NULL
223: --
224: -- OUT

Line 238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

234: --
235:
236: PROCEDURE Delete_Offer_Performance(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,

Line 239: p_commit IN VARCHAR2 := FND_API.G_FALSE,

235:
236: PROCEDURE Delete_Offer_Performance(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,

Line 240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

236: PROCEDURE Delete_Offer_Performance(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_offer_performance_id IN NUMBER,

Line 261: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

257: -- Parameters
258: --
259: -- IN
260: -- p_api_version_number IN NUMBER Required
261: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
262: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_offer_perf_rec IN offer_perf_rec_type Required
265: --

Line 262: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

258: --
259: -- IN
260: -- p_api_version_number IN NUMBER Required
261: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
262: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_offer_perf_rec IN offer_perf_rec_type Required
265: --
266: -- OUT

Line 263: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

259: -- IN
260: -- p_api_version_number IN NUMBER Required
261: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
262: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_offer_perf_rec IN offer_perf_rec_type Required
265: --
266: -- OUT
267: -- x_return_status OUT VARCHAR2

Line 280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

276: --
277:
278: PROCEDURE Lock_Offer_Performance(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281:
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,

Line 304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

300: -- End of Comments
301:
302: PROCEDURE Validate_offer_performance(
303: p_api_version_number IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_offer_perf_rec IN offer_perf_rec_type,
307: p_validation_mode IN VARCHAR2,
308: x_return_status OUT NOCOPY VARCHAR2,

Line 305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

301:
302: PROCEDURE Validate_offer_performance(
303: p_api_version_number IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_offer_perf_rec IN offer_perf_rec_type,
307: p_validation_mode IN VARCHAR2,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,

Line 343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

339: -- End of Comments
340:
341: PROCEDURE Validate_offer_perf_rec(
342: p_api_version_number IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,
347: p_offer_perf_rec IN offer_perf_rec_type