DBA Data[Home] [Help]

APPS.AMS_CAMPAIGN_PVT dependencies on AMS_CAMPAIGNS_ALL_B_S

Line 53: SELECT ams_campaigns_all_b_s.NEXTVAL

49: l_bu_id NUMBER;
50: l_org_id NUMBER;
51:
52: CURSOR c_camp_seq IS
53: SELECT ams_campaigns_all_b_s.NEXTVAL
54: FROM DUAL;
55:
56: CURSOR c_camp_count(camp_id IN NUMBER) IS
57: SELECT COUNT(*)

Line 1340: UPDATE ams_campaigns_all_b SET

1336: -----------------------------------------------------------------
1337: -- budget_amount_tc, budget_amount_fc, media_type_code, media_id,
1338: -- channel_id are commented out by julou on 01/23/00
1339: -----------------------------------------------------------------
1340: UPDATE ams_campaigns_all_b SET
1341: last_update_date = SYSDATE,
1342: last_updated_by = FND_GLOBAL.user_id,
1343: last_update_login = FND_GLOBAL.conc_login_id,
1344: object_version_number = l_camp_rec.object_version_number + 1,