APPS.AMS_VENUE_RATES_PVT dependencies on AMS_VENUE_RATES_PVT

Line 1: PACKAGE BODY AMS_Venue_Rates_PVT as

1: PACKAGE BODY AMS_Venue_Rates_PVT as
2: /* $Header: amsvvrtb.pls 115.5 2002/12/24 18:59:46 mukumar ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_Venue_Rates_PVT

2: /* $Header: amsvvrtb.pls 115.5 2002/12/24 18:59:46 mukumar ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_Venue_Rates_PVT
7: -- Purpose
8: --
9: -- History
10: -- 10-MAY-2002 GMADANA Added Rate_code.

Line 18: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Venue_Rates_PVT';

14: -- End of Comments
15: -- ===============================================================
16:
17:
18: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Venue_Rates_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvvrtb.pls';
20:
21: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
22: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 51: l_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type := p_venue_rates_rec;

47: l_object_version_number NUMBER := 1;
48: l_org_id NUMBER := FND_API.G_MISS_NUM;
49: l_RATE_ID NUMBER;
50: l_dummy NUMBER;
51: l_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type := p_venue_rates_rec;
52:
53: CURSOR c_id IS
54: SELECT AMS_VENUE_RATES_B_s.NEXTVAL
55: FROM dual;

Line 291: l_tar_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type := P_venue_rates_rec;

287: -- Local Variables
288: l_object_version_number NUMBER;
289: l_RATE_ID NUMBER;
290: l_ref_venue_rates_rec c_get_Venue_Rates%ROWTYPE ;
291: l_tar_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type := P_venue_rates_rec;
292: l_rowid ROWID;
293:
294: BEGIN
295: -- Standard Start of API savepoint

Line 1272: l_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type;

1268: IS
1269: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Venue_Rates';
1270: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1271: l_object_version_number NUMBER;
1272: l_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type;
1273:
1274: BEGIN
1275: -- Standard Start of API savepoint
1276: SAVEPOINT VALIDATE_Venue_Rates_;

Line 1428: END AMS_Venue_Rates_PVT;

1424: p_data => x_msg_data
1425: );
1426: END Validate_venue_rates_Rec;
1427:
1428: END AMS_Venue_Rates_PVT;