APPS.AMS_SOURCECODE_PVT dependencies on AMS_SOURCE_CODES

Line 36: FROM ams_source_codes

32: RETURN VARCHAR2 IS
33:
34: CURSOR c_source_code IS
35: SELECT 1
36: FROM ams_source_codes
37: WHERE source_code = p_source_code;
38:
39: l_dummy NUMBER;
40:

Line 230: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)

226: l_code VARCHAR2(30);
227: l_dummy NUMBER;
228:
229: CURSOR c_seq IS
230: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)
231: FROM DUAL;
232:
233: CURSOR c_prefix IS
234: SELECT tag

Line 370: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)

366:
367: l_code VARCHAR2(30);
368:
369: CURSOR c_seq IS
370: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)
371: FROM DUAL;
372:
373: BEGIN
374:

Line 415: FROM ams_source_codes

411: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
412:
413: CURSOR c_source_code IS
414: SELECT source_code_id, active_flag
415: FROM ams_source_codes
416: WHERE source_code = p_sourcecode;
417:
418: CURSOR c_active_object IS
419: SELECT 'x'

Line 420: FROM ams_source_codes

416: WHERE source_code = p_sourcecode;
417:
418: CURSOR c_active_object IS
419: SELECT 'x'
420: FROM ams_source_codes
421: WHERE arc_source_code_for = p_sourcecode_for
422: AND source_code_for_id = p_sourcecode_for_id
423: AND active_flag = 'Y';
424:

Line 426: SELECT AMS_SOURCE_CODES_S.NEXTVAL

422: AND source_code_for_id = p_sourcecode_for_id
423: AND active_flag = 'Y';
424:
425: CURSOR c_sourcecode_seq IS
426: SELECT AMS_SOURCE_CODES_S.NEXTVAL
427: FROM DUAL;
428:
429: CURSOR c_related_source_code IS
430: SELECT 1

Line 431: FROM ams_source_codes

427: FROM DUAL;
428:
429: CURSOR c_related_source_code IS
430: SELECT 1
431: FROM ams_source_codes
432: WHERE source_code = p_related_sourcecode;
433:
434: l_return_status VARCHAR2(1);
435: l_sc_active_flag varchar2(1) := 'Y';

Line 538: insert into AMS_SOURCE_CODES (

534: fetch c_sourcecode_seq into l_sourcecode_id;
535: close c_sourcecode_seq;
536:
537: -- insert source code
538: insert into AMS_SOURCE_CODES (
539: SOURCE_CODE_ID,
540: LAST_UPDATE_DATE,
541: LAST_UPDATED_BY,
542: CREATION_DATE,

Line 707: update AMS_SOURCE_CODES

703: END IF;
704:
705: x_return_status := FND_API.g_ret_sts_success;
706:
707: update AMS_SOURCE_CODES
708: set active_flag = 'N',
709: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
710: where SOURCE_CODE = p_sourcecode;
711:

Line 811: update AMS_SOURCE_CODES

807: AMS_Utility_PVT.debug_message(' modifying source code record');
808:
809: END IF;
810:
811: update AMS_SOURCE_CODES
812: set ARC_SOURCE_CODE_FOR = p_object_type,
813: SOURCE_CODE_FOR_ID = p_object_id,
814: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
815: ACTIVE_FLAG = 'Y'

Line 911: ams_source_codes_gen_s.NEXTVAL,

907: scode_char_element,
908: scode_number_element,
909: arc_source_code_for
910: ) VALUES (
911: ams_source_codes_gen_s.NEXTVAL,
912: SYSDATE,
913: FND_GLOBAL.user_id,
914: SYSDATE,
915: FND_GLObAL.user_id,