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.MSD_CS_DEFN_UTL2 dependencies on MSD_CS_DEFN_UTL2

Line 1: package body msd_cs_defn_utl2 as

1: package body msd_cs_defn_utl2 as
2: /* $Header: msdcsu2b.pls 115.8 2003/11/04 18:40:57 dkang ship $ */
3:
4:
5: g_defn_para_list g_type_defn_para_rec_list;

Line 112: l_list(l_ctr).para_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 1);

108: -- 'CHAR:Prompt_Name:ValueSet_Name:Remote_Yes_No:Multi_Yes_NO:Default_Column_Name_For_Multi:code'
109:
110: IF substr(upper(para_type), 1, 5) = 'CHAR:' then /* Character type */
111: l_list(l_ctr).para_type := 'CHAR';
112: l_list(l_ctr).para_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 1);
113: l_list(l_ctr).vs_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 2);
114: l_remote_flag := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 3);
115: l_list(l_ctr).multi_input_flag :=
116: nvl(upper(msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 4)), 'N');

Line 113: l_list(l_ctr).vs_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 2);

109:
110: IF substr(upper(para_type), 1, 5) = 'CHAR:' then /* Character type */
111: l_list(l_ctr).para_type := 'CHAR';
112: l_list(l_ctr).para_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 1);
113: l_list(l_ctr).vs_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 2);
114: l_remote_flag := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 3);
115: l_list(l_ctr).multi_input_flag :=
116: nvl(upper(msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 4)), 'N');
117: /* remote dblink flag is set to Y */

Line 114: l_remote_flag := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 3);

110: IF substr(upper(para_type), 1, 5) = 'CHAR:' then /* Character type */
111: l_list(l_ctr).para_type := 'CHAR';
112: l_list(l_ctr).para_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 1);
113: l_list(l_ctr).vs_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 2);
114: l_remote_flag := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 3);
115: l_list(l_ctr).multi_input_flag :=
116: nvl(upper(msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 4)), 'N');
117: /* remote dblink flag is set to Y */
118: IF (upper(l_remote_flag) = 'Y' and p_instance is not NULL) THEN

Line 116: nvl(upper(msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 4)), 'N');

112: l_list(l_ctr).para_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 1);
113: l_list(l_ctr).vs_name := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 2);
114: l_remote_flag := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 3);
115: l_list(l_ctr).multi_input_flag :=
116: nvl(upper(msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 4)), 'N');
117: /* remote dblink flag is set to Y */
118: IF (upper(l_remote_flag) = 'Y' and p_instance is not NULL) THEN
119: msd_common_utilities.get_db_link(p_instance, l_dblink, l_retcode);
120: l_list(l_ctr).sql_stmt :=

Line 129: l_list(l_ctr).default_code := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 6);

125: genereate_sql_from_vs(l_list(l_ctr).vs_name, null,
126: l_val_col, l_id_col);
127: END IF;
128:
129: l_list(l_ctr).default_code := msd_cs_defn_utl2.get_char_property(p_cond, start_pos, end_pos, 6);
130: IF l_list(l_ctr).default_code IS NOT NULL THEN
131: l_list(l_ctr).default_val := get_default_value(l_val_col,
132: l_id_col,
133: l_list(l_ctr).sql_stmt,