DBA Data[Home] [Help]

APPS.AMS_VENUE_RATES_PUB 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: rate_code 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: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category 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: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category 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: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category 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: rate_code 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: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category 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: attribute_category 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: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category 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: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category 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: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category 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: rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: attribute_category 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: attribute_category 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: g_miss_venue_rates_rec venue_rates_rec_type;

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: g_miss_venue_rates_rec venue_rates_rec_type;
105: TYPE venue_rates_tbl_type IS TABLE OF venue_rates_rec_type INDEX BY BINARY_INTEGER;

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

123: -- Parameters
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_venue_rates_rec IN venue_rates_rec_type Required
130: --
131: -- OUT

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

124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_venue_rates_rec IN venue_rates_rec_type Required
130: --
131: -- OUT
132: -- x_return_status OUT VARCHAR2

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

141: --
142:
143: PROCEDURE Create_Venue_Rates(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,

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

142:
143: PROCEDURE Create_Venue_Rates(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,

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

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

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

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

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

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

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

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

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

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

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

208: --
209: -- IN
210: -- p_api_version_number IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
212: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
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: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,

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: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_rate_id IN NUMBER,

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

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

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

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

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

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