APPS.AMS_CAMPAIGN_SCHEDULES_B_PKG dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 1: PACKAGE BODY AMS_CAMPAIGN_SCHEDULES_B_PKG as

1: PACKAGE BODY AMS_CAMPAIGN_SCHEDULES_B_PKG as
2: /* $Header: amstschb.pls 120.3 2006/05/31 11:56:41 srivikri ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_CAMPAIGN_SCHEDULES_B_PKG

2: /* $Header: amstschb.pls 120.3 2006/05/31 11:56:41 srivikri ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_CAMPAIGN_SCHEDULES_B_PKG
7: -- Purpose
8: -- Table api to create/insert/update campaign Schedules.
9: -- History
10: -- 22-Jan-2000 ptendulk Created.

Line 29: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_CAMPAIGN_SCHEDULES_B_PKG';

25: -- End of Comments
26: -- ===============================================================
27:
28:
29: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_CAMPAIGN_SCHEDULES_B_PKG';
30: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstschb.pls';
31:
32: -- ===============================================================
33: -- Start of Comments

Line 190: INSERT INTO AMS_CAMPAIGN_SCHEDULES_B(

186: END IF ;
187:
188: -- end ptendulk 26-sep-2001
189:
190: INSERT INTO AMS_CAMPAIGN_SCHEDULES_B(
191: schedule_id,
192: last_update_date,
193: last_updated_by,
194: creation_date,

Line 610: UPDATE ams_campaign_schedules_b

606:
607: -- end soagrawa 26-sep-2001
608: -- Debug Message Commented by ptendulk Bug 2767243
609: -- ams_utility_pvt.debug_message('Transaction currency :: '||p_transaction_currency_code);
610: UPDATE ams_campaign_schedules_b
611: SET schedule_id = DECODE( p_schedule_id, FND_API.g_miss_num, schedule_id, p_schedule_id),
612: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
613: -- last update date modified by soagrawa on 31-jan-2002 for bug# 2160058, 2204087
614: last_updated_by = FND_GLOBAL.USER_ID,

Line 763: DELETE FROM ams_campaign_schedules_b

759: p_schedule_id NUMBER)
760: IS
761: BEGIN
762:
763: DELETE FROM ams_campaign_schedules_b
764: WHERE schedule_id = p_schedule_id;
765: If (SQL%NOTFOUND) THEN
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: End If;

Line 790: FROM ams_campaign_schedules_b

786:
787: IS
788: CURSOR C IS
789: SELECT *
790: FROM ams_campaign_schedules_b
791: WHERE schedule_id = p_schedule_id
792: FOR UPDATE OF schedule_id NOWAIT;
793: Recinfo C%ROWTYPE;
794: BEGIN

Line 828: from ams_campaign_schedules_b B

824: begin
825: delete from ams_campaign_schedules_tl T
826: where not exists
827: (select NULL
828: from ams_campaign_schedules_b B
829: where B.schedule_id = T.schedule_ID
830: );
831:
832: update ams_campaign_schedules_tl T set (

Line 905: END AMS_CAMPAIGN_SCHEDULES_B_PKG;

901:
902:
903:
904:
905: END AMS_CAMPAIGN_SCHEDULES_B_PKG;