APPS.AMS_SOURCECODE_PVT dependencies on AMS_GENERATED_CODES

Line 866: FROM ams_generated_codes gde

862: l_ref_sequence NUMBER; -- reference number used to determine if sequences exhausted
863:
864: CURSOR c_sequence_value (x_code_key VARCHAR2) IS
865: SELECT gde.scode_number_element
866: FROM ams_generated_codes gde
867: WHERE gde.scode_char_element = x_code_key
868: FOR UPDATE
869: ;
870: BEGIN

Line 899: INSERT INTO ams_generated_codes (

895: IF l_sequence_value IS NULL THEN
896: l_sequence_value := 0;
897:
898: -- Create a generated code
899: INSERT INTO ams_generated_codes (
900: gen_code_id,
901: last_update_date,
902: last_updated_by,
903: creation_date,

Line 949: UPDATE ams_generated_codes gde

945: END LOOP;
946:
947: -- Update the generate code with the new
948: -- upper limit of the numeric sequence.
949: UPDATE ams_generated_codes gde
950: SET gde.scode_number_element = l_sequence_value
951: WHERE gde.scode_char_element = l_code_chars;
952:
953: COMMIT;