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.EDW_VBH_SETUP dependencies on EDW_SOURCE_INSTANCES

Line 11: from edw_source_instances

7:
8: begin
9: select warehouse_to_instance_link
10: into p_db_link
11: from edw_source_instances
12: where instance_code=p_instance
13: and warehouse_to_instance_link is not null
14: and enabled_flag='Y';
15: p_status:=true;

Line 26: l_instance_code edw_source_instances.instance_code%TYPE;

22:
23: PROCEDURE INSERT_INTO_EDW_SET_OF_BOOKS(
24: p_status out nocopy boolean,
25: p_errMsg out nocopy varchar2) AS
26: l_instance_code edw_source_instances.instance_code%TYPE;
27: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
28: l_insert_stmt varchar2(20000);
29: l_cursor_id integer;
30: l_rows_inserted integer:=0;

Line 27: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;

23: PROCEDURE INSERT_INTO_EDW_SET_OF_BOOKS(
24: p_status out nocopy boolean,
25: p_errMsg out nocopy varchar2) AS
26: l_instance_code edw_source_instances.instance_code%TYPE;
27: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
28: l_insert_stmt varchar2(20000);
29: l_cursor_id integer;
30: l_rows_inserted integer:=0;
31: l_stmt varchar2(100);

Line 34: from edw_source_instances

30: l_rows_inserted integer:=0;
31: l_stmt varchar2(100);
32: cursor l_source_instances_cur is
33: select INSTANCE_CODE,WAREHOUSE_TO_INSTANCE_LINK
34: from edw_source_instances
35: where WAREHOUSE_TO_INSTANCE_LINK is not null
36: and enabled_flag ='Y'
37: order by instance_code;
38: begin

Line 88: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;

84:
85: end insert_into_edw_set_of_books;
86:
87: procedure insert_source(p_status out nocopy boolean,p_errMsg out nocopy varchar2) is
88: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
89: l_instance_code edw_source_instances.instance_code%TYPE;
90: l_insert_stmt varchar2(20000);
91: l_delete_stmt varchar2(200);
92: l_stmt varchar2(1000);

Line 89: l_instance_code edw_source_instances.instance_code%TYPE;

85: end insert_into_edw_set_of_books;
86:
87: procedure insert_source(p_status out nocopy boolean,p_errMsg out nocopy varchar2) is
88: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
89: l_instance_code edw_source_instances.instance_code%TYPE;
90: l_insert_stmt varchar2(20000);
91: l_delete_stmt varchar2(200);
92: l_stmt varchar2(1000);
93:

Line 96: from edw_source_instances

92: l_stmt varchar2(1000);
93:
94: cursor l_source_instances_cur is
95: select warehouse_to_instance_link, INSTANCE_CODE
96: from edw_source_instances
97: where WAREHOUSE_TO_INSTANCE_LINK is not null
98: and enabled_flag='Y';
99:
100: begin

Line 151: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;

147: end insert_source;
148:
149:
150: procedure insert_cons_to_source(p_status out nocopy boolean,p_errMsg out nocopy varchar2) is
151: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
152: l_insert_stmt varchar2(20000);
153: l_delete_stmt varchar2(200);
154: l_delete_cursor_id integer;
155: l_insert_cursor_id integer;

Line 162: from edw_source_instances

158: l_stmt varchar2(100);
159:
160: cursor l_source_instances_cur is
161: select WAREHOUSE_TO_INSTANCE_LINK
162: from edw_source_instances
163: where WAREHOUSE_TO_INSTANCE_LINK is not null
164: and enabled_flag ='Y';
165:
166: begin

Line 219: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;

215: end insert_cons_to_source;
216:
217:
218: procedure insert_equi_to_source(p_status out nocopy boolean, p_errMsg out nocopy varchar2) is
219: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
220: l_insert_stmt varchar2(20000);
221: l_delete_stmt varchar2(200);
222: l_delete_cursor_id integer;
223: l_insert_cursor_id integer;

Line 230: from edw_source_instances

226: l_stmt varchar2(100);
227:
228: cursor l_source_instances_cur is
229: select WAREHOUSE_TO_INSTANCE_LINK
230: from edw_source_instances
231: where WAREHOUSE_TO_INSTANCE_LINK is not null
232: and enabled_flag='Y';
233:
234: begin

Line 369: l_db_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;

365: return boolean IS
366:
367: l_status BOOLEAN := TRUE;
368: l_instance_code VARCHAR2(30);
369: l_db_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
370: --l_db_link VARCHAR2(30);
371: l_progress VARCHAR2(3):= '000';
372: l_dummy VARCHAR2(30);
373: l_dummy_int NUMBER;

Line 380: FROM edw_source_instances

376: l_temp number := 0;
377:
378: CURSOR instances IS
379: SELECT instance_code, warehouse_to_instance_link
380: FROM edw_source_instances
381: WHERE enabled_flag = 'Y';
382:
383: BEGIN
384:

Line 429: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;

425: procedure check_valid_consolidation
426: (p_instance in varchar2,p_from_ledger_id in number,
427: p_to_ledger_id in number,p_result out nocopy boolean,
428: p_status out nocopy boolean,p_error_mesg out nocopy varchar2)AS
429: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
430: l_select_stmt varchar2(20000);
431: l_cursor_id integer;
432: l_rows_selected integer:=0;
433: l_count number;

Line 498: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;

494: p_consolidation_name in varchar2,
495: p_consolidation_id out nocopy number,
496: p_status out nocopy boolean,
497: p_error_mesg out nocopy varchar2)AS
498: l_instance_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
499: l_select_stmt varchar2(20000);
500: l_cursor_id integer;
501: l_rows_selected integer:=0;
502: l_count number;

Line 638: l_db_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;

634: l_consolidation_id number;
635: l_status boolean;
636: l_err_msg varchar2(100);
637: --l_db_link varchar2(30);
638: l_db_link edw_source_instances.WAREHOUSE_TO_INSTANCE_LINK%TYPE;
639: l_from_value_set_id number;
640: l_to_value_set_id number;
641: l_select_stmt varchar2(200);
642: l_cursor_id number;