APPS.AMS_VENUE_RATES_B_PKG dependencies on AMS_VENUE_RATES_B

Line 1: PACKAGE BODY AMS_VENUE_RATES_B_PKG as

1: PACKAGE BODY AMS_VENUE_RATES_B_PKG as
2: /* $Header: amstvrtb.pls 115.5 2003/03/28 23:19:44 soagrawa ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_VENUE_RATES_B_PKG

2: /* $Header: amstvrtb.pls 115.5 2003/03/28 23:19:44 soagrawa ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_VENUE_RATES_B_PKG
7: -- Purpose
8: --
9: -- History
10: -- 10-MAY-2002 GMADANA Added Rate_code.

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_VENUE_RATES_B_PKG';

15: -- End of Comments
16: -- ===============================================================
17:
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_VENUE_RATES_B_PKG';
20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstvrtb.pls';
21:
22:
23: ----------------------------------------------------------

Line 78: cursor C is select ROWID from AMS_venue_rates_b

74: IS
75: x_rowid VARCHAR2(30);
76: l_rowid VARCHAR2(20);
77:
78: cursor C is select ROWID from AMS_venue_rates_b
79: where rate_ID = px_rate_id;
80:
81:
82: BEGIN

Line 88: INSERT INTO AMS_VENUE_RATES_B(

84:
85: px_object_version_number := 1;
86:
87:
88: INSERT INTO AMS_VENUE_RATES_B(
89: rate_id,
90: last_update_date,
91: last_updated_by,
92: creation_date,

Line 249: Update AMS_VENUE_RATES_B

245:
246: IS
247: BEGIN
248:
249: Update AMS_VENUE_RATES_B
250: SET
251: rate_id = DECODE( p_rate_id, FND_API.g_miss_num, rate_id, p_rate_id),
252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 328: DELETE FROM AMS_VENUE_RATES_B

324: PROCEDURE Delete_Row(
325: p_RATE_ID NUMBER)
326: IS
327: BEGIN
328: DELETE FROM AMS_VENUE_RATES_B
329: WHERE RATE_ID = p_RATE_ID;
330: If (SQL%NOTFOUND) then
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: End If;

Line 390: FROM AMS_VENUE_RATES_B

386:
387: IS
388: CURSOR C IS
389: SELECT *
390: FROM AMS_VENUE_RATES_B
391: WHERE RATE_ID = p_RATE_ID
392: FOR UPDATE of RATE_ID NOWAIT;
393: Recinfo C%ROWTYPE;
394: BEGIN

Line 512: from AMS_VENUE_RATES_B B

508: begin
509: delete from AMS_VENUE_RATES_TL T
510: where not exists
511: (select NULL
512: from AMS_VENUE_RATES_B B
513: where B.RATE_ID = T.RATE_ID
514: );
515:
516: update AMS_VENUE_RATES_TL T set (

Line 570: END AMS_VENUE_RATES_B_PKG;

566: and T.LANGUAGE = L.LANGUAGE_CODE);
567: end ADD_LANGUAGE;
568:
569:
570: END AMS_VENUE_RATES_B_PKG;