eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_CAMPAIGN_PVT dependencies on AMS_CAMPAIGNS_ALL_B

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 64: from ams_campaigns_all_b

60:
61: /**
62: CURSOR c_parent_business_unit (p_parent_campaign_id IN NUMBER, p_org_id IN NUMBER) IS
63: SELECT business_unit_id
64: from ams_campaigns_all_b
65: where campaign_id = p_parent_campaign_id
66: and exists (
67: SELECT 1 FROM hr_all_organization_units_vl
68: WHERE business_group_id IN (

Line 82: from ams_campaigns_all_b

78: **/
79:
80: CURSOR c_parent_business_unit (p_parent_campaign_id IN NUMBER) IS
81: SELECT business_unit_id
82: from ams_campaigns_all_b
83: where campaign_id = p_parent_campaign_id
84: and exists (
85: SELECT 1
86: FROM hr_all_organization_units_vl

Line 95: from ams_campaigns_all_b

91: AND organization_id = business_unit_id);
92:
93: CURSOR c_parent_confi_flag (p_parent_campaign_id IN NUMBER) IS
94: select private_flag
95: from ams_campaigns_all_b
96: where campaign_id = p_parent_campaign_id;
97:
98: l_access_rec AMS_Access_Pvt.access_rec_type ;
99: l_dummy_id NUMBER ;

Line 276: INSERT INTO ams_campaigns_all_b(

272: -----------------------------------------------------------------
273: -- budget_amount_tc, budget_amount_fc, media_type_code, media_id,
274: -- channel_id are commented out by julou on 01/23/00
275: -----------------------------------------------------------------
276: INSERT INTO ams_campaigns_all_b(
277: campaign_id,
278: last_update_date,
279: last_updated_by,
280: creation_date,

Line 747: FROM ams_campaigns_all_b

743: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
744:
745: CURSOR c_camp IS
746: SELECT status_code
747: FROM ams_campaigns_all_b
748: WHERE campaign_id = p_camp_id
749: AND object_version_number = p_object_version ;
750: l_status VARCHAR2(30);
751:

Line 802: DELETE FROM ams_campaigns_all_b

798: END IF ;
799: CLOSE c_camp ;
800:
801: IF l_status = 'NEW' THEN
802: DELETE FROM ams_campaigns_all_b
803: WHERE campaign_id = p_camp_id
804: AND object_version_number = p_object_version ;
805: ELSE
806: UPDATE ams_campaigns_all_b

Line 806: UPDATE ams_campaigns_all_b

802: DELETE FROM ams_campaigns_all_b
803: WHERE campaign_id = p_camp_id
804: AND object_version_number = p_object_version ;
805: ELSE
806: UPDATE ams_campaigns_all_b
807: SET active_flag = 'N'
808: WHERE campaign_id = p_camp_id
809: AND object_version_number = p_object_version;
810: END IF ;

Line 813: -- UPDATE ams_campaigns_all_b

809: AND object_version_number = p_object_version;
810: END IF ;
811: -- End of code modified by ptendulk on 11-Feb-2001
812:
813: -- UPDATE ams_campaigns_all_b
814: -- SET active_flag = 'N'
815: -- WHERE campaign_id = p_camp_id
816: -- AND object_version_number = p_object_version;
817:

Line 912: FROM ams_campaigns_all_b

908: l_camp_id NUMBER;
909:
910: CURSOR c_camp_b IS
911: SELECT campaign_id
912: FROM ams_campaigns_all_b
913: WHERE campaign_id = p_camp_id
914: AND object_version_number = p_object_version
915: FOR UPDATE NOWAIT;
916:

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,

Line 1830: 'ams_campaigns_all_b',

1826: IF p_validation_mode = JTF_PLSQL_API.g_create
1827: AND p_camp_rec.campaign_id IS NOT NULL
1828: THEN
1829: IF AMS_Utility_PVT.check_uniqueness(
1830: 'ams_campaigns_all_b',
1831: 'campaign_id = ' || p_camp_rec.campaign_id
1832: ) = FND_API.g_false
1833: THEN
1834: AMS_Utility_PVT.Error_Message('AMS_CAMP_DUPLICATE_ID');

Line 2357: FROM ams_campaigns_all_b

2353: IS
2354:
2355: CURSOR c_parent_type IS
2356: SELECT rollup_type,status_code
2357: FROM ams_campaigns_all_b
2358: WHERE campaign_id = p_camp_rec.parent_campaign_id;
2359:
2360: l_parent_type VARCHAR2(30);
2361: l_status_code VARCHAR2(30);

Line 2515: 'ams_campaigns_all_b',

2511: ELSE
2512:
2513: --aranka added 07/27/02
2514: IF AMS_Utility_PVT.check_uniqueness(
2515: 'ams_campaigns_all_b',
2516: 'source_code = ''' || p_camp_rec.source_code || ''''
2517: -- 'source_code = ''' || p_camp_rec.source_code ||
2518: -- ''' AND rollup_type = ''RCAM'''
2519: ) = FND_API.g_false

Line 2542: 'ams_campaigns_all_b',

2538:
2539: --aranka added 07/27/02
2540: --sam added
2541: IF AMS_Utility_PVT.check_uniqueness(
2542: 'ams_campaigns_all_b',
2543: 'source_code = ''' || p_camp_rec.source_code || ''''
2544: ) = FND_API.g_false
2545: THEN
2546: AMS_Utility_PVT.Error_Message('AMS_CAMP_DUPLICATE_CODE');