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_PULL_LEVEL_VALUES dependencies on MSD_COMMON_UTILITIES

Line 24: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;

20: errbuf OUT NOCOPY VARCHAR2,
21: retcode OUT NOCOPY VARCHAR2,
22: p_comp_refresh IN NUMBER) IS
23: -- ,p_launched_from IN NUMBER DEFAULT NULL) IS --jarorad
24: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
25: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;
26: x_instance VARCHAR2(40) := '';
27: x_level_id NUMBER := 0;
28: v_sql_stmt varchar2(4000);

Line 25: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;

21: retcode OUT NOCOPY VARCHAR2,
22: p_comp_refresh IN NUMBER) IS
23: -- ,p_launched_from IN NUMBER DEFAULT NULL) IS --jarorad
24: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
25: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;
26: x_instance VARCHAR2(40) := '';
27: x_level_id NUMBER := 0;
28: v_sql_stmt varchar2(4000);
29: g_retcode varchar2(5) := '0';

Line 124: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,

120: p_source_table => x_source_table,
121: p_dest_table => x_dest_table,
122: p_instance_id => Relationship_Rec.instance,
123: p_level_id => Relationship_Rec.level_id,
124: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,
125: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
126: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
127: p_parent_level_id => Relationship_Rec.parent_level_id,
128: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,

Line 125: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,

121: p_dest_table => x_dest_table,
122: p_instance_id => Relationship_Rec.instance,
123: p_level_id => Relationship_Rec.level_id,
124: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,
125: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
126: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
127: p_parent_level_id => Relationship_Rec.parent_level_id,
128: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
129: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,

Line 126: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,

122: p_instance_id => Relationship_Rec.instance,
123: p_level_id => Relationship_Rec.level_id,
124: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,
125: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
126: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
127: p_parent_level_id => Relationship_Rec.parent_level_id,
128: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
129: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,
130: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,

Line 128: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,

124: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,
125: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
126: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
127: p_parent_level_id => Relationship_Rec.parent_level_id,
128: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
129: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,
130: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,
131: p_update_lvl_table => 0,
132: /* OPM Comment Rajesh Patangya */

Line 129: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,

125: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
126: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
127: p_parent_level_id => Relationship_Rec.parent_level_id,
128: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
129: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,
130: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,
131: p_update_lvl_table => 0,
132: /* OPM Comment Rajesh Patangya */
133: p_delete_flag => x_delete_flag,

Line 130: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,

126: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
127: p_parent_level_id => Relationship_Rec.parent_level_id,
128: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
129: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,
130: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,
131: p_update_lvl_table => 0,
132: /* OPM Comment Rajesh Patangya */
133: p_delete_flag => x_delete_flag,
134: p_seq_num => l_seq_num

Line 166: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,

162: p_source_table => x_source_table,
163: p_dest_table => x_dest_table,
164: p_instance_id => Relationship_Rec.instance,
165: p_level_id => Relationship_Rec.level_id,
166: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,
167: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
168: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
169: p_parent_level_id => Relationship_Rec.parent_level_id,
170: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,

Line 167: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,

163: p_dest_table => x_dest_table,
164: p_instance_id => Relationship_Rec.instance,
165: p_level_id => Relationship_Rec.level_id,
166: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,
167: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
168: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
169: p_parent_level_id => Relationship_Rec.parent_level_id,
170: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
171: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,

Line 168: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,

164: p_instance_id => Relationship_Rec.instance,
165: p_level_id => Relationship_Rec.level_id,
166: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,
167: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
168: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
169: p_parent_level_id => Relationship_Rec.parent_level_id,
170: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
171: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,
172: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,

Line 170: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,

166: p_level_value_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_COLUMN,
167: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
168: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
169: p_parent_level_id => Relationship_Rec.parent_level_id,
170: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
171: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,
172: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,
173: p_update_lvl_table => 1,
174: /* OPM Comment Rajesh Patangya */

Line 171: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,

167: p_level_value_pk_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_PK_COLUMN,
168: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
169: p_parent_level_id => Relationship_Rec.parent_level_id,
170: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
171: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,
172: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,
173: p_update_lvl_table => 1,
174: /* OPM Comment Rajesh Patangya */
175: p_delete_flag => x_delete_flag,

Line 172: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,

168: p_level_value_desc_column => MSD_COMMON_UTILITIES.LEVEL_VALUE_DESC_COLUMN,
169: p_parent_level_id => Relationship_Rec.parent_level_id,
170: p_parent_value_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_COLUMN,
171: p_parent_value_pk_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_PK_COLUMN,
172: p_parent_value_desc_column => MSD_COMMON_UTILITIES.PARENT_LEVEL_VALUE_DESC_COLUMN,
173: p_update_lvl_table => 1,
174: /* OPM Comment Rajesh Patangya */
175: p_delete_flag => x_delete_flag,
176: p_seq_num => l_seq_num

Line 214: MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE,

210:
211: For Level_Rec IN Level_Cursor LOOP
212: MSD_COLLECT_LEVEL_VALUES.fix_orphans(Level_Rec.instance,
213: Level_Rec.level_id,
214: MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE,
215: MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE,
216: null);
217: end loop;
218:

Line 215: MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE,

211: For Level_Rec IN Level_Cursor LOOP
212: MSD_COLLECT_LEVEL_VALUES.fix_orphans(Level_Rec.instance,
213: Level_Rec.level_id,
214: MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE,
215: MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE,
216: null);
217: end loop;
218:
219: