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_LIST_SRC_FIELDS_PKG dependencies on AMS_LIST_SRC_FIELDS

Line 1: PACKAGE BODY AMS_LIST_SRC_FIELDS_PKG as

1: PACKAGE BODY AMS_LIST_SRC_FIELDS_PKG as
2: /* $Header: amstlsfb.pls 120.3 2006/06/07 08:40:33 bmuthukr noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_LIST_SRC_FIELDS_PKG

2: /* $Header: amstlsfb.pls 120.3 2006/06/07 08:40:33 bmuthukr noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_LIST_SRC_FIELDS_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_LIST_SRC_FIELDS_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_LIST_SRC_FIELDS_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstlsfb.pls';
19:
20:
21: ----------------------------------------------------------

Line 83: INSERT INTO AMS_LIST_SRC_FIELDS(

79:
80: px_object_version_number := 1;
81:
82:
83: INSERT INTO AMS_LIST_SRC_FIELDS(
84: list_source_field_id,
85: last_update_date,
86: last_updated_by,
87: creation_date,

Line 145: insert into AMS_LIST_SRC_FIELDS_TL (

141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
142: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
143: );
144:
145: insert into AMS_LIST_SRC_FIELDS_TL (
146: LANGUAGE,
147: SOURCE_LANG,
148: source_column_meaning,
149: LIST_SOURCE_field_ID,

Line 177: from AMS_LIST_SRC_FIELDS_TL T

173: from FND_LANGUAGES L
174: where L.INSTALLED_FLAG in ('I', 'B')
175: and not exists
176: (select NULL
177: from AMS_LIST_SRC_FIELDS_TL T
178: where T.LIST_source_field_ID = px_LIST_SOURCE_field_ID
179: and T.LANGUAGE = L.LANGUAGE_CODE);
180:
181: END Insert_Row;

Line 236: Update AMS_LIST_SRC_FIELDS

232: )
233:
234: IS
235: BEGIN
236: Update AMS_LIST_SRC_FIELDS
237: SET
238: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
239: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 275: update AMS_LIST_SRC_FIELDS_TL set

271: IF (SQL%NOTFOUND) THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: update AMS_LIST_SRC_FIELDS_TL set
276: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
277: LAST_UPDATE_DATE = sysdate,
278: -- Modified for bug 5237401. bmuthukr
279: --LAST_UPDATE_BY = FND_GLOBAL.user_id,

Line 314: DELETE FROM AMS_LIST_SRC_FIELDS

310: PROCEDURE Delete_Row(
311: p_LIST_SOURCE_FIELD_ID NUMBER)
312: IS
313: BEGIN
314: DELETE FROM AMS_LIST_SRC_FIELDS
315: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID;
316: If (SQL%NOTFOUND) then
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: End If;

Line 320: DELETE FROM AMS_LIST_SRC_FIELDS_TL

316: If (SQL%NOTFOUND) then
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: End If;
319:
320: DELETE FROM AMS_LIST_SRC_FIELDS_TL
321: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID;
322: If (SQL%NOTFOUND) then
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: End If;

Line 381: FROM AMS_LIST_SRC_FIELDS

377:
378: IS
379: CURSOR C IS
380: SELECT *
381: FROM AMS_LIST_SRC_FIELDS
382: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
383: FOR UPDATE of LIST_SOURCE_FIELD_ID NOWAIT;
384: Recinfo C%ROWTYPE;
385: BEGIN

Line 442: INSERT INTO AMS_LIST_SRC_FIELDS(

438:
439: px_object_version_number := 1;
440:
441:
442: INSERT INTO AMS_LIST_SRC_FIELDS(
443: list_source_field_id,
444: last_update_date,
445: last_updated_by,
446: creation_date,

Line 512: insert into AMS_LIST_SRC_FIELDS_TL (

508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),
509: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
510: );
511:
512: insert into AMS_LIST_SRC_FIELDS_TL (
513: LANGUAGE,
514: SOURCE_LANG,
515: source_column_meaning,
516: LIST_SOURCE_field_ID,

Line 544: from AMS_LIST_SRC_FIELDS_TL T

540: from FND_LANGUAGES L
541: where L.INSTALLED_FLAG in ('I', 'B')
542: and not exists
543: (select NULL
544: from AMS_LIST_SRC_FIELDS_TL T
545: where T.LIST_source_field_ID = px_LIST_SOURCE_field_ID
546: and T.LANGUAGE = L.LANGUAGE_CODE);
547:
548: END Insert_Row;

Line 607: Update AMS_LIST_SRC_FIELDS

603: )
604:
605: IS
606: BEGIN
607: Update AMS_LIST_SRC_FIELDS
608: SET
609: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 649: update AMS_LIST_SRC_FIELDS_TL set

645: IF (SQL%NOTFOUND) THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: END IF;
648:
649: update AMS_LIST_SRC_FIELDS_TL set
650: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
651: LAST_UPDATE_DATE = sysdate,
652: -- Added for bug 5237401. bmuthukr.
653: --LAST_UPDATE_BY = FND_GLOBAL.user_id,

Line 709: FROM ams_list_src_fields

705: l_last_updated_by number;
706:
707: CURSOR c_obj_verno IS
708: SELECT object_version_number, last_updated_by
709: FROM ams_list_src_fields
710: WHERE list_source_field_id = x_list_source_field_id;
711:
712: CURSOR c_chk_exists is
713: SELECT 'x'

Line 714: FROM ams_list_src_fields

710: WHERE list_source_field_id = x_list_source_field_id;
711:
712: CURSOR c_chk_exists is
713: SELECT 'x'
714: FROM ams_list_src_fields
715: WHERE list_source_field_id = x_list_source_field_id;
716:
717: CURSOR c_get_id is
718: SELECT ams_list_src_fields_s.NEXTVAL

Line 718: SELECT ams_list_src_fields_s.NEXTVAL

714: FROM ams_list_src_fields
715: WHERE list_source_field_id = x_list_source_field_id;
716:
717: CURSOR c_get_id is
718: SELECT ams_list_src_fields_s.NEXTVAL
719: FROM DUAL;
720: BEGIN
721: if X_OWNER = 'SEED' then
722: l_user_id := 1;

Line 744: ams_list_src_fields_pkg.Insert_Row (

740: END IF;
741:
742: l_obj_verno := 1;
743:
744: ams_list_src_fields_pkg.Insert_Row (
745: px_list_source_field_id => l_list_source_field_id,
746: p_last_update_date => SYSDATE,
747: p_last_updated_by => l_user_id,
748: p_creation_date => SYSDATE,

Line 790: ams_list_src_fields_pkg.Update_Row (

786: if (l_last_updated_by in (1,2,0) OR
787: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
788:
789:
790: ams_list_src_fields_pkg.Update_Row (
791: p_list_source_field_id => x_list_source_field_id,
792: p_last_update_date => SYSDATE,
793: p_last_updated_by => l_user_id,
794: p_last_update_login => 0,

Line 839: FROM AMS_LIST_SRC_FIELDS_TL

835: ) is
836:
837: cursor c_last_updated_by is
838: select last_update_by
839: FROM AMS_LIST_SRC_FIELDS_TL
840: where list_source_field_id = x_list_source_field_id
841: and USERENV('LANG') = LANGUAGE;
842:
843: l_last_updated_by number;

Line 855: update AMS_LIST_SRC_FIELDS_TL set

851:
852: if (l_last_updated_by in (1,2,0) OR
853: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
854:
855: update AMS_LIST_SRC_FIELDS_TL set
856: source_column_meaning = nvl(x_source_column_meaning,
857: source_column_meaning),
858: source_lang = userenv('LANG'),
859: last_update_date = sysdate,

Line 871: delete from AMS_LIST_SRC_FIELDS_TL T

867:
868: procedure ADD_LANGUAGE
869: is
870: begin
871: delete from AMS_LIST_SRC_FIELDS_TL T
872: where not exists
873: (select NULL
874: from AMS_LIST_SRC_FIELDS B
875: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID

Line 874: from AMS_LIST_SRC_FIELDS B

870: begin
871: delete from AMS_LIST_SRC_FIELDS_TL T
872: where not exists
873: (select NULL
874: from AMS_LIST_SRC_FIELDS B
875: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID
876: );
877:
878: update AMS_LIST_SRC_FIELDS_TL T set (

Line 878: update AMS_LIST_SRC_FIELDS_TL T set (

874: from AMS_LIST_SRC_FIELDS B
875: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID
876: );
877:
878: update AMS_LIST_SRC_FIELDS_TL T set (
879: SOURCE_COLUMN_MEANING
880: ) = (select
881: B.SOURCE_COLUMN_MEANING
882: from AMS_LIST_SRC_FIELDS_TL B

Line 882: from AMS_LIST_SRC_FIELDS_TL B

878: update AMS_LIST_SRC_FIELDS_TL T set (
879: SOURCE_COLUMN_MEANING
880: ) = (select
881: B.SOURCE_COLUMN_MEANING
882: from AMS_LIST_SRC_FIELDS_TL B
883: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID
884: and B.LANGUAGE = T.SOURCE_LANG)
885: where (
886: T.LIST_SOURCE_FIELD_ID,

Line 891: from AMS_LIST_SRC_FIELDS_TL SUBB, AMS_LIST_SRC_FIELDS_TL SUBT

887: T.LANGUAGE
888: ) in (select
889: SUBT.LIST_SOURCE_FIELD_ID,
890: SUBT.LANGUAGE
891: from AMS_LIST_SRC_FIELDS_TL SUBB, AMS_LIST_SRC_FIELDS_TL SUBT
892: where SUBB.LIST_SOURCE_FIELD_ID = SUBT.LIST_SOURCE_FIELD_ID
893: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
894: and (SUBB.SOURCE_COLUMN_MEANING <> SUBT.SOURCE_COLUMN_MEANING
895: or (SUBB.SOURCE_COLUMN_MEANING is null and SUBT.SOURCE_COLUMN_MEANING is not null)

Line 899: insert into AMS_LIST_SRC_FIELDS_TL (

895: or (SUBB.SOURCE_COLUMN_MEANING is null and SUBT.SOURCE_COLUMN_MEANING is not null)
896: or (SUBB.SOURCE_COLUMN_MEANING is not null and SUBT.SOURCE_COLUMN_MEANING is null)
897: ));
898:
899: insert into AMS_LIST_SRC_FIELDS_TL (
900: LAST_UPDATE_LOGIN,
901: SOURCE_COLUMN_MEANING,
902: CREATION_DATE,
903: CREATED_BY,

Line 919: from AMS_LIST_SRC_FIELDS_TL B, FND_LANGUAGES L

915: B.LAST_UPDATE_DATE,
916: B.LAST_UPDATE_BY,
917: L.LANGUAGE_CODE,
918: B.SOURCE_LANG
919: from AMS_LIST_SRC_FIELDS_TL B, FND_LANGUAGES L
920: where L.INSTALLED_FLAG in ('I', 'B')
921: and B.LANGUAGE = userenv('LANG')
922: and not exists
923: (select NULL

Line 924: from AMS_LIST_SRC_FIELDS_TL T

920: where L.INSTALLED_FLAG in ('I', 'B')
921: and B.LANGUAGE = userenv('LANG')
922: and not exists
923: (select NULL
924: from AMS_LIST_SRC_FIELDS_TL T
925: where T.LIST_SOURCE_FIELD_ID = B.LIST_SOURCE_FIELD_ID
926: and T.LANGUAGE = L.LANGUAGE_CODE);
927: end ADD_LANGUAGE;
928:

Line 929: END AMS_LIST_SRC_FIELDS_PKG;

925: where T.LIST_SOURCE_FIELD_ID = B.LIST_SOURCE_FIELD_ID
926: and T.LANGUAGE = L.LANGUAGE_CODE);
927: end ADD_LANGUAGE;
928:
929: END AMS_LIST_SRC_FIELDS_PKG;