APPS.AMS_EVHRULES_PVT dependencies on AMS_SOURCE_CODES

Line 164: FROM ams_source_codes

160: WHERE event_header_id = p_evh_rec.event_header_id;
161:
162: CURSOR c_source_code IS
163: SELECT 1
164: FROM ams_source_codes
165: WHERE source_code = p_evh_rec.source_code
166: AND active_flag = 'Y';
167:
168: l_msg_data VARCHAR2(2000);

Line 278: -- otherwise revoke the old one and add the new one to ams_source_codes

274: x_return_status := FND_API.g_ret_sts_error;
275: RETURN;
276: END IF;
277:
278: -- otherwise revoke the old one and add the new one to ams_source_codes
279: AMS_SourceCode_PVT.revoke_sourcecode(
280: p_api_version => 1.0,
281: p_init_msg_list => FND_API.g_false,
282: p_commit => FND_API.g_false,

Line 534: SELECT ams_source_codes_s.NEXTVAL

530: )
531: IS
532: l_pk NUMBER;
533: CURSOR c_seq IS
534: SELECT ams_source_codes_s.NEXTVAL
535: FROM DUAL;
536: BEGIN
537: OPEN c_seq;
538: FETCH c_seq INTO l_pk;

Line 540: INSERT INTO ams_source_codes(

536: BEGIN
537: OPEN c_seq;
538: FETCH c_seq INTO l_pk;
539: CLOSE c_seq;
540: INSERT INTO ams_source_codes(
541: source_code_id,
542: last_update_date,
543: last_updated_by,
544: creation_date,

Line 597: FROM ams_source_codes

593: WHERE event_header_id = p_evh_id;
594:
595: CURSOR c_source_code IS
596: SELECT source_code_id
597: FROM ams_source_codes
598: WHERE source_code = x_source_code
599: AND active_flag = 'Y';
600:
601: CURSOR c_setup_id IS

Line 655: -- otherwise revoke the old one and add the new one to ams_source_codes

651: x_return_status := FND_API.g_ret_sts_error;
652: RETURN;
653: END IF;
654:
655: -- otherwise revoke the old one and add the new one to ams_source_codes
656: AMS_SourceCode_PVT.revoke_sourcecode(
657: p_api_version => 1.0,
658: p_init_msg_list => FND_API.g_false,
659: p_commit => FND_API.g_false,

Line 724: FROM ams_source_codes

720: WHERE event_offer_id = p_evo_id;
721:
722: CURSOR c_source_code IS
723: SELECT source_code_id
724: FROM ams_source_codes
725: WHERE source_code = x_source_code
726: AND active_flag = 'Y';
727:
728: CURSOR c_setup_id IS

Line 783: -- otherwise revoke the old one and add the new one to ams_source_codes

779: x_return_status := FND_API.g_ret_sts_error;
780: RETURN;
781: END IF;
782:
783: -- otherwise revoke the old one and add the new one to ams_source_codes
784: AMS_SourceCode_PVT.revoke_sourcecode(
785: p_api_version => 1.0,
786: p_init_msg_list => FND_API.g_false,
787: p_commit => FND_API.g_false,

Line 854: FROM ams_source_codes

850: WHERE event_offer_id = p_evo_id;
851:
852: CURSOR c_source_code IS
853: SELECT source_code_id
854: FROM ams_source_codes
855: WHERE source_code = x_source_code
856: AND active_flag = 'Y';
857:
858: CURSOR c_setup_id IS

Line 913: -- otherwise revoke the old one and add the new one to ams_source_codes

909: x_return_status := FND_API.g_ret_sts_error;
910: RETURN;
911: END IF;
912:
913: -- otherwise revoke the old one and add the new one to ams_source_codes
914: AMS_SourceCode_PVT.revoke_sourcecode(
915: p_api_version => 1.0,
916: p_init_msg_list => FND_API.g_false,
917: p_commit => FND_API.g_false,