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

Line 1: PACKAGE BODY asg_base AS

1: PACKAGE BODY asg_base AS
2: /*$Header: asgbaseb.pls 120.5 2006/05/09 13:52:01 rsripada noship $*/
3:
4: -- DESCRIPTION
5: -- Contains functions to retrieve information during a synch session.

Line 105: 'asg_base',g_stmt_level);

101: FOR curr_index in 1..sql_string_tbl.count LOOP
102: IF(asg_helper.check_is_log_enabled(g_stmt_level))
103: THEN
104: asg_helper.log(sql_string_tbl(curr_index),
105: 'asg_base',g_stmt_level);
106: END IF;
107: END LOOP;
108: EXCEPTION
109: WHEN OTHERS THEN

Line 627: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$all_config ' ||

623: l_param VARCHAR2(30) := 'VERSION';
624: begin
625: IF (g_olite_version IS NULL) THEN
626: l_qry_string := 'SELECT value ' ||
627: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$all_config ' ||
628: 'WHERE param = :1';
629: EXECUTE IMMEDIATE l_qry_string
630: INTO g_olite_version
631: USING l_param;

Line 634: asg_helper.log('Olite version : '||g_olite_version,'asg_base',g_stmt_level);

630: INTO g_olite_version
631: USING l_param;
632: END IF;
633: l_version := to_number(substr(g_olite_version,1,instr(g_olite_version,'.')-1));
634: asg_helper.log('Olite version : '||g_olite_version,'asg_base',g_stmt_level);
635: if(l_version < 10) then
636: asg_helper.log('Not checking for device switch since Olite version is '||
637: 'less than 10.0.0.0.0','asg_base',g_stmt_level);
638: else

Line 637: 'less than 10.0.0.0.0','asg_base',g_stmt_level);

633: l_version := to_number(substr(g_olite_version,1,instr(g_olite_version,'.')-1));
634: asg_helper.log('Olite version : '||g_olite_version,'asg_base',g_stmt_level);
635: if(l_version < 10) then
636: asg_helper.log('Not checking for device switch since Olite version is '||
637: 'less than 10.0.0.0.0','asg_base',g_stmt_level);
638: else
639: asg_helper.log('Checking for device switch','asg_base',g_stmt_level);
640: open c_get_dev_type(p_user_name);
641: fetch c_get_dev_type into l_prev_dev_type;

Line 639: asg_helper.log('Checking for device switch','asg_base',g_stmt_level);

635: if(l_version < 10) then
636: asg_helper.log('Not checking for device switch since Olite version is '||
637: 'less than 10.0.0.0.0','asg_base',g_stmt_level);
638: else
639: asg_helper.log('Checking for device switch','asg_base',g_stmt_level);
640: open c_get_dev_type(p_user_name);
641: fetch c_get_dev_type into l_prev_dev_type;
642: close c_get_dev_type;
643:

Line 646: asg_helper.log('Previous device : '||l_prev_dev_type,'asg_base',g_stmt_level);

642: close c_get_dev_type;
643:
644: l_curr_dev_type := get_device_type_name;
645: p_device_type := l_curr_dev_type;
646: asg_helper.log('Previous device : '||l_prev_dev_type,'asg_base',g_stmt_level);
647: asg_helper.log('Current device : '||l_curr_dev_type,'asg_base',g_stmt_level);
648:
649: if (l_prev_dev_type is null) then
650: /*First time synch*/

Line 647: asg_helper.log('Current device : '||l_curr_dev_type,'asg_base',g_stmt_level);

643:
644: l_curr_dev_type := get_device_type_name;
645: p_device_type := l_curr_dev_type;
646: asg_helper.log('Previous device : '||l_prev_dev_type,'asg_base',g_stmt_level);
647: asg_helper.log('Current device : '||l_curr_dev_type,'asg_base',g_stmt_level);
648:
649: if (l_prev_dev_type is null) then
650: /*First time synch*/
651: update asg_user set current_device = l_curr_dev_type

Line 655: l_qry_string := 'update '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q '

651: update asg_user set current_device = l_curr_dev_type
652: where user_name = p_user_name;
653: elsif(l_prev_dev_type <> l_curr_dev_type ) then
654: /*device switch detected .Set to complete refresh*/
655: l_qry_string := 'update '||asg_base.G_OLITE_SCHEMA||'.c$pub_list_q '
656: ||'set comp_ref = ''Y'' '||' where name IN '
657: ||' ( select item_id from asg_pub_item)' ;
658: execute immediate l_qry_string;
659: update asg_user set current_device = l_curr_dev_type

Line 662: 'asg_base',g_stmt_level);

658: execute immediate l_qry_string;
659: update asg_user set current_device = l_curr_dev_type
660: where user_name = p_user_name;
661: asg_helper.log('Device switch detected. Doing complete refresh',
662: 'asg_base',g_stmt_level);
663: else
664: /*Device type is same.Do nothing*/
665: null;
666: end if;

Line 671: 'asg_base',g_stmt_level);

667: end if;
668: exception
669: when others then
670: asg_helper.log('Exception in detect_device_switch',
671: 'asg_base',g_stmt_level);
672: end detect_device_switch;
673:
674: -- Returns G_YES if the user is a valid MFS user
675: FUNCTION is_mobile_user(p_user_id IN NUMBER)

Line 729: END asg_base;

725: WHERE user_id = p_user_id and enabled = 'Y';
726:
727: END get_user_app_responsibility;
728:
729: END asg_base;