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.BIL_DO_L1_BASE_GRP_PKG dependencies on BIL_DO_L1_BASE_GRP_TEMP

Line 64: from bil_do_l1_base_grp_temp

60: ) is
61:
62: CURSOR lvl_cur(l_level number) is
63: select child_sales_group_id, Hier_level
64: from bil_do_l1_base_grp_temp
65: where Hier_level = l_level;
66:
67: l_profile_option number := FND_PROFILE.VALUE('BIL_DO_L1_GRP_AGGR_LVL');
68: /*Fetching the hirarchial level to which data need to be retrieved.*/

Line 129: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_BASE_GRP_TEMP',p_debug=>G_Debug);

125: ,p_level => l_profile_option
126: ,p_degree => p_degree);
127:
128: /*Analyze the table after insertion*/
129: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_BASE_GRP_TEMP',p_debug=>G_Debug);
130: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_BASE_GRP_TEMP', cascade=>TRUE,
131: degree=>G_Degree, estimate_percent=>99, granularity=>'GLOBAL');
132:
133:

Line 130: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_BASE_GRP_TEMP', cascade=>TRUE,

126: ,p_degree => p_degree);
127:
128: /*Analyze the table after insertion*/
129: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_BASE_GRP_TEMP',p_debug=>G_Debug);
130: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_BASE_GRP_TEMP', cascade=>TRUE,
131: degree=>G_Degree, estimate_percent=>99, granularity=>'GLOBAL');
132:
133:
134: IF G_Trace THEN

Line 192: l_insert_statement := 'INSERT INTO /+ APPEND PARALLEL(bgt,'||p_degree||') / bil_do_l1_base_grp_temp bgt';

188: l_parent_group VARCHAR2(50) := 'PARENT_GROUP';
189: l_sales VARCHAR2(20) := 'SALES';
190: l_stime DATE := sysdate;
191: BEGIN
192: l_insert_statement := 'INSERT INTO /*+ APPEND PARALLEL(bgt,'||p_degree||') */ bil_do_l1_base_grp_temp bgt';
193: l_insert_statement := l_insert_statement||'( child_sales_group_id,sales_group_id,Hier_level,creation_date,created_by';
194: l_insert_statement := l_insert_statement||',last_update_date,last_updated_by,last_update_login,request_id';
195: l_insert_statement := l_insert_statement||',program_application_id,program_id,program_update_date) ';
196:

Line 267: l_insert_statement := 'INSERT INTO /+ APPEND PARALLEL(bgt,'||p_degree||') / bil_do_l1_base_grp_temp bgt';

263: l_stime DATE := sysdate;
264: BEGIN
265: /* inserting data for the given level */
266: l_level := p_level + 1;
267: l_insert_statement := 'INSERT INTO /*+ APPEND PARALLEL(bgt,'||p_degree||') */ bil_do_l1_base_grp_temp bgt';
268: l_insert_statement := l_insert_statement||' ( child_sales_group_id, sales_group_id, Hier_level, creation_date';
269: l_insert_statement := l_insert_statement||', created_by, last_update_date, last_updated_by, last_update_login';
270: l_insert_statement := l_insert_statement||', request_id, program_application_id, program_id, program_update_date)';
271:

Line 343: l_insert_statement := 'INSERT INTO /+ APPEND PARALLEL(bgt,'||p_degree||') / bil_do_l1_base_grp_temp bgt';

339: l_stime DATE := sysdate;
340: BEGIN
341: l_level := p_level + 1;
342:
343: l_insert_statement := 'INSERT INTO /*+ APPEND PARALLEL(bgt,'||p_degree||') */ bil_do_l1_base_grp_temp bgt';
344: l_insert_statement := l_insert_statement||' ( child_sales_group_id, sales_group_id, Hier_level, creation_date';
345: l_insert_statement := l_insert_statement||', created_by, last_update_date, last_updated_by, last_update_login';
346: l_insert_statement := l_insert_statement||', request_id, program_application_id, program_id, program_update_date)';
347:

Line 354: l_select_statement :=l_select_statement||' (select child_sales_group_id from bil_do_l1_base_grp_temp';

350: l_select_statement :=l_select_statement||' , :G_user_id, :G_login_id, :G_request_id, :G_appl_id';
351: l_select_statement :=l_select_statement||' , :G_program_id, :l_sysdate';
352: l_select_statement :=l_select_statement||' from jtf_rs_groups_denorm den, jtf_rs_group_usages usg ';
353: l_select_statement :=l_select_statement||' where den.parent_group_id in ';
354: l_select_statement :=l_select_statement||' (select child_sales_group_id from bil_do_l1_base_grp_temp';
355: l_select_statement :=l_select_statement||' where Hier_level = :p_level)';
356: l_select_statement :=l_select_statement||' and (den.start_date_active <= :l_sysdate OR den.start_date_active is null)';
357: l_select_statement :=l_select_statement||' and (den.end_date_active >= :l_sysdate OR den.End_date_active is null)';
358: l_select_statement :=l_select_statement||' and den.parent_group_id <> den.group_id AND usg.group_id = den.group_id AND usg.usage = :l_sales)';

Line 398: EXECUTE IMMEDIATE 'truncate table bil.bil_do_l1_base_grp_temp';

394: *Truncate the table
395: *******************/
396: PROCEDURE Truncate_table is
397: BEGIN
398: EXECUTE IMMEDIATE 'truncate table bil.bil_do_l1_base_grp_temp';
399: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp is truncated',p_debug=>G_Debug);
400: END;
401:
402: /*************************

Line 399: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp is truncated',p_debug=>G_Debug);

395: *******************/
396: PROCEDURE Truncate_table is
397: BEGIN
398: EXECUTE IMMEDIATE 'truncate table bil.bil_do_l1_base_grp_temp';
399: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp is truncated',p_debug=>G_Debug);
400: END;
401:
402: /*************************
403: *Alter tables to logging

Line 407: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_base_grp_temp LOGGING';

403: *Alter tables to logging
404: *************************/
405: PROCEDURE Reset_Table_Usages IS
406: BEGIN
407: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_base_grp_temp LOGGING';
408: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to logging', p_debug=>G_Debug);
409: END Reset_Table_Usages;
410:
411: /***********************************************************

Line 408: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to logging', p_debug=>G_Debug);

404: *************************/
405: PROCEDURE Reset_Table_Usages IS
406: BEGIN
407: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_base_grp_temp LOGGING';
408: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to logging', p_debug=>G_Debug);
409: END Reset_Table_Usages;
410:
411: /***********************************************************
412: * Alter all the tables used to nologging, drop the indexes

Line 417: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_base_grp_temp NOLOGGING';

413: ***********************************************************/
414: PROCEDURE Set_Table_Usages IS
415: BEGIN
416:
417: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_base_grp_temp NOLOGGING';
418:
419: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to nologging',p_debug=>G_Debug);
420:
421: END Set_Table_Usages;

Line 419: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to nologging',p_debug=>G_Debug);

415: BEGIN
416:
417: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_base_grp_temp NOLOGGING';
418:
419: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to nologging',p_debug=>G_Debug);
420:
421: END Set_Table_Usages;
422:
423: END BIL_DO_L1_BASE_GRP_PKG;