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.AMS_VENUE_RATES_PVT dependencies on FND_API

Line 69: rate_id NUMBER := FND_API.G_MISS_NUM,

65:
66: --===================================================================
67: TYPE venue_rates_rec_type IS RECORD
68: (
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,

Line 70: last_update_date DATE := FND_API.G_MISS_DATE,

66: --===================================================================
67: TYPE venue_rates_rec_type IS RECORD
68: (
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 71: last_updated_by NUMBER := FND_API.G_MISS_NUM,

67: TYPE venue_rates_rec_type IS RECORD
68: (
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 72: creation_date DATE := FND_API.G_MISS_DATE,

68: (
69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 73: created_by NUMBER := FND_API.G_MISS_NUM,

69: rate_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,

Line 74: last_update_login NUMBER := FND_API.G_MISS_NUM,

70: last_update_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,

Line 75: object_version_number NUMBER := FND_API.G_MISS_NUM,

71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,

Line 76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

72: creation_date DATE := FND_API.G_MISS_DATE,
73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 77: venue_id NUMBER := FND_API.G_MISS_NUM,

73: created_by NUMBER := FND_API.G_MISS_NUM,
74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,

Line 78: metric_id NUMBER := FND_API.G_MISS_NUM,

74: last_update_login NUMBER := FND_API.G_MISS_NUM,
75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 79: transactional_value NUMBER := FND_API.G_MISS_NUM,

75: object_version_number NUMBER := FND_API.G_MISS_NUM,
76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

76: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 81: functional_value NUMBER := FND_API.G_MISS_NUM,

77: venue_id NUMBER := FND_API.G_MISS_NUM,
78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

78: metric_id NUMBER := FND_API.G_MISS_NUM,
79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

79: transactional_value NUMBER := FND_API.G_MISS_NUM,
80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

80: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

81: functional_value NUMBER := FND_API.G_MISS_NUM,
82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

82: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

83: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

84: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

85: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

86: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

87: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

88: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

89: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

90: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

91: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

92: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

93: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR

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

94: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102:

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

95: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102:
103: );

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

96: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102:
103: );
104:

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

97: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102:
103: );
104:
105: g_miss_venue_rates_rec venue_rates_rec_type;

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

118: -- Parameters
119: --
120: -- IN
121: -- p_api_version_number IN NUMBER Required
122: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
123: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_venue_rates_rec IN venue_rates_rec_type Required
126: --

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

119: --
120: -- IN
121: -- p_api_version_number IN NUMBER Required
122: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
123: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_venue_rates_rec IN venue_rates_rec_type Required
126: --
127: -- OUT

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

120: -- IN
121: -- p_api_version_number IN NUMBER Required
122: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
123: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_venue_rates_rec IN venue_rates_rec_type Required
126: --
127: -- OUT
128: -- x_return_status OUT VARCHAR2

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

137: --
138:
139: PROCEDURE Create_Venue_Rates(
140: p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144:
145: x_return_status OUT NOCOPY VARCHAR2,

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

138:
139: PROCEDURE Create_Venue_Rates(
140: p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144:
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,

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

139: PROCEDURE Create_Venue_Rates(
140: p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144:
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,

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

162: -- Parameters
163: --
164: -- IN
165: -- p_api_version_number IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
167: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_venue_rates_rec IN venue_rates_rec_type Required
170: --

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

163: --
164: -- IN
165: -- p_api_version_number IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
167: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_venue_rates_rec IN venue_rates_rec_type Required
170: --
171: -- OUT

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

164: -- IN
165: -- p_api_version_number IN NUMBER Required
166: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
167: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
168: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169: -- p_venue_rates_rec IN venue_rates_rec_type Required
170: --
171: -- OUT
172: -- x_return_status OUT VARCHAR2

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

181: --
182:
183: PROCEDURE Update_Venue_Rates(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188:
189: x_return_status OUT NOCOPY VARCHAR2,

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

182:
183: PROCEDURE Update_Venue_Rates(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188:
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,

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

183: PROCEDURE Update_Venue_Rates(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188:
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,

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

206: -- Parameters
207: --
208: -- IN
209: -- p_api_version_number IN NUMBER Required
210: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
213: -- p_RATE_ID IN NUMBER
214: -- p_object_version_number IN NUMBER Optional Default = NULL

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

207: --
208: -- IN
209: -- p_api_version_number IN NUMBER Required
210: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
213: -- p_RATE_ID IN NUMBER
214: -- p_object_version_number IN NUMBER Optional Default = NULL
215: --

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

208: -- IN
209: -- p_api_version_number IN NUMBER Required
210: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
213: -- p_RATE_ID IN NUMBER
214: -- p_object_version_number IN NUMBER Optional Default = NULL
215: --
216: -- OUT

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

226: --
227:
228: PROCEDURE Delete_Venue_Rates(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,

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

227:
228: PROCEDURE Delete_Venue_Rates(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,

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

228: PROCEDURE Delete_Venue_Rates(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_rate_id IN NUMBER,

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

249: -- Parameters
250: --
251: -- IN
252: -- p_api_version_number IN NUMBER Required
253: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
254: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
255: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
256: -- p_venue_rates_rec IN venue_rates_rec_type Required
257: --

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

250: --
251: -- IN
252: -- p_api_version_number IN NUMBER Required
253: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
254: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
255: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
256: -- p_venue_rates_rec IN venue_rates_rec_type Required
257: --
258: -- OUT

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

251: -- IN
252: -- p_api_version_number IN NUMBER Required
253: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
254: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
255: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
256: -- p_venue_rates_rec IN venue_rates_rec_type Required
257: --
258: -- OUT
259: -- x_return_status OUT VARCHAR2

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

268: --
269:
270: PROCEDURE Lock_Venue_Rates(
271: p_api_version_number IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273:
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,

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

292: -- End of Comments
293:
294: PROCEDURE Validate_venue_rates(
295: p_api_version_number IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: p_venue_rates_rec IN venue_rates_rec_type,
299: p_validation_mode IN VARCHAR2,
300: x_return_status OUT NOCOPY VARCHAR2,

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

293:
294: PROCEDURE Validate_venue_rates(
295: p_api_version_number IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: p_venue_rates_rec IN venue_rates_rec_type,
299: p_validation_mode IN VARCHAR2,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,

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

331: -- End of Comments
332:
333: PROCEDURE Validate_venue_rates_rec(
334: p_api_version_number IN NUMBER,
335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,
339: p_venue_rates_rec IN venue_rates_rec_type