APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_GENERATED_CODES

Line 434: FROM ams_generated_codes gde

430: IS
431: PRAGMA AUTONOMOUS_TRANSACTION;
432: CURSOR c_sequence_value IS
433: SELECT gde.scode_number_element
434: FROM ams_generated_codes gde
435: WHERE gde.scode_char_element = p_campaign_source_code
436: FOR UPDATE ;
437:
438: CURSOR c_setup_suffix IS

Line 463: INSERT INTO ams_generated_codes (

459:
460: IF l_seq IS NULL THEN
461: l_seq := 0 ;
462:
463: INSERT INTO ams_generated_codes (
464: gen_code_id,
465: last_update_date,
466: last_updated_by,
467: creation_date,

Line 498: UPDATE ams_generated_codes gde

494: EXIT WHEN AMS_SourceCode_PVT.is_source_code_unique (l_source_code) = FND_API.g_true;
495: l_seq := l_seq + 1 ;
496: END LOOP;
497:
498: UPDATE ams_generated_codes gde
499: SET gde.scode_number_element = l_seq + 1
500: WHERE gde.scode_char_element = p_campaign_source_code ;
501: COMMIT ;
502: