APPS.MSC_CL_GMP_UTILITY dependencies on DUAL

Line 2998: ||'FROM dual';

2994: uom_conv_cursor :=
2995: 'SELECT '
2996: ||' GMICUOM.uom_conversion'||at_apps_link
2997: ||' (:pitem, 0, :pqty, :pfrom_um, :pto_um, 0) '
2998: ||'FROM dual';
2999: v_matl_qty := -1;
3000: OPEN c_uom_conv FOR uom_conv_cursor USING
3001: formula_detail_tab(j).opm_item_id,
3002: formula_detail_tab(j).primary_qty,

Line 6789: INTO cur_time FROM sys.dual ;

6785: BEGIN
6786: cur_time := NULL ;
6787:
6788: SELECT to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')
6789: INTO cur_time FROM sys.dual ;
6790:
6791: log_message(cur_time);
6792: EXCEPTION
6793: WHEN OTHERS THEN

Line 8122: 'SELECT fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' FROM dual ';

8118: LOG_MESSAGE(' get_profile_value called for profile '
8119: ||profile_name||' with dblink '||pdblink);
8120:
8121: uom_code_dblink :=
8122: 'SELECT fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' FROM dual ';
8123:
8124: OPEN uom_code_ref for uom_code_dblink ;
8125: FETCH uom_code_ref INTO l_gmp_um_code;
8126: CLOSE uom_code_ref;

Line 10841: FROM dual ;

10837:
10838: SELECT DECODE(porigination_type,1,NULL,porder_no) ,
10839: DECODE(porigination_type,1,porder_no,NULL)
10840: INTO t_order_number, t_wip_entity_name
10841: FROM dual ;
10842:
10843: statement_demands :=
10844: ' INSERT INTO msc_st_demands ( '
10845: ||' organization_id, inventory_item_id, sr_instance_id, '

Line 15393: for further processing If Pl/SQL Tbl new_rec has any residual rows,

15389: || ' from_time, '
15390: || ' to_time ';
15391:
15392: /* The cursor is opened and the values are stored in a PL/SQL table
15393: for further processing If Pl/SQL Tbl new_rec has any residual rows,
15394: we Need to clean before populating the New Table - 12/17/99 */
15395:
15396: IF new_rec.COUNT > 0 THEN
15397: new_rec.delete;

Line 15666: SELECT to_char(new_rec(old_weekly).cal_date,'D') INTO week_num FROM dual;

15662: period_char := TO_CHAR(new_rec(old_period).cal_date,'MON-YYYY');
15663: weekly_seq := 0;
15664: period_seq := 0;
15665:
15666: SELECT to_char(new_rec(old_weekly).cal_date,'D') INTO week_num FROM dual;
15667: week_num := (week_num - 7) * -1;
15668: week_end := new_rec(old_weekly).cal_date + week_num;
15669:
15670: /*

Line 15807: SELECT TO_CHAR(new_rec(j).cal_date,'D') INTO week_num FROM dual;

15803: 2,
15804: p_INSTANCE_ID) ;
15805:
15806: week_num := 0;
15807: SELECT TO_CHAR(new_rec(j).cal_date,'D') INTO week_num FROM dual;
15808: week_num := (week_num - 7) * -1;
15809: prior_weekly := old_weekly;
15810: old_weekly := j;
15811: week_end := new_rec(old_weekly).cal_date + week_num;

Line 17183: l_stmt := 'SELECT 1 FROM dual WHERE '||

17179:
17180: l_opm_org := plsqltbl_rec(k).organization_id ;
17181:
17182: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
17183: l_stmt := 'SELECT 1 FROM dual WHERE '||
17184: l_opm_org||MSC_CL_GMP_UTILITY.g_in_str_org ;
17185: OPEN l_cur for l_stmt ;
17186: FETCH l_cur INTO l_org_specific ;
17187: IF l_cur%NOTFOUND THEN

Line 18940: INTO l_aps_compatible FROM DUAL ;

18936: org_str := NULL ;
18937: in_position := -10 ;
18938:
18939: SELECT MSC_CL_GMP_UTILITY.is_aps_compatible
18940: INTO l_aps_compatible FROM DUAL ;
18941:
18942: IF l_aps_compatible = 1 THEN
18943:
18944: /*sql_stmt := 'SELECT MSC_CL_PULL.get_org_str(' || instance_id || ') FROM dual ' ;

Line 18944: /*sql_stmt := 'SELECT MSC_CL_PULL.get_org_str(' || instance_id || ') FROM dual ' ;

18940: INTO l_aps_compatible FROM DUAL ;
18941:
18942: IF l_aps_compatible = 1 THEN
18943:
18944: /*sql_stmt := 'SELECT MSC_CL_PULL.get_org_str(' || instance_id || ') FROM dual ' ;
18945: OPEN c_str FOR sql_stmt ;
18946: FETCH c_str INTO org_str ;
18947: log_message(' String From APS : ' || org_str);
18948: CLOSE c_str ;*/