APPS.AMW_UTILITY_PVT dependencies on DUAL

Line 68: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

64: l_sql VARCHAR2(4000);
65: l_count NUMBER;
66:
67: BEGIN
68: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
69: l_sql := l_sql || ' WHERE ' || UPPER(p_pk_name) || ' = :b1';
70:
71: IF p_additional_where_clause IS NOT NULL THEN
72: -- given time, incorporate bind_parse

Line 126: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;

122: , p_lookup_code => p_lookup_code
123: , p_view_application_id => 242
124: );
125: ELSE
126: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;
127: l_sql := l_sql || ' WHERE LOOKUP_TYPE = :b1';
128: l_sql := l_sql || ' AND LOOKUP_CODE = :b2';
129: l_sql := l_sql || ' AND ENABLED_FLAG = ''Y'')';
130:

Line 225: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

221: l_bind_tbl col_val_tbl;
222:
223: BEGIN
224:
225: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
226: -- l_sql := l_sql || ' WHERE ' || p_where_clause;
227:
228: bind_parse (p_where_clause, l_bind_tbl);
229:

Line 653: -- FROM dual

649: -- get_employess_name
650: -- USAGE
651: -- Example:
652: -- SELECT AMW_Utility_PVT.get_employee_name (party_id)
653: -- FROM dual
654: -- HISTORY
655: -- 6/19/2003 mpande Created.
656: ---------------------------------------------------------------------
657: FUNCTION get_employee_name (

Line 1392: SELECT 'Y' INTO l_dummy from dual

1388: FUNCTION exist_in_latest_hier(p_org_id in number,p_proc_id in number) return varchar2
1389: is
1390: l_dummy varchar2(1) := 'N';
1391: BEGIN
1392: SELECT 'Y' INTO l_dummy from dual
1393: where exists ( select 1 from amw_latest_hierarchies
1394: where organization_id = p_org_id
1395: and (parent_id = p_proc_id or child_id = p_proc_id));
1396: return l_dummy;

Line 1518: into dummy_count from dual;

1514: (ap.approval_date is not null and ap.approval_end_date is null and aphd.hierarchy_type = 'A' and aca.approval_date is not null and aca.deletion_approval_date is null)
1515: )
1516: and ap.process_id = aphd.parent_child_id
1517: and ap.process_id = p_process_id and ap.revision_number = p_revision_number))
1518: into dummy_count from dual;
1519:
1520: if dummy_count > 0 then
1521: return GET_LOOKUP_MEANING('AMW_YES_NO','Y');
1522: else

Line 1868: SELECT amw_debug_log_s.nextval INTO g_session_id FROM DUAL;

1864: FND_GLOBAL.RESP_ID(),
1865: FND_GLOBAL.RESP_APPL_ID());
1866: END IF;
1867:
1868: SELECT amw_debug_log_s.nextval INTO g_session_id FROM DUAL;
1869:
1870: FND_LOG_REPOSITORY.INIT( SESSION_ID=> g_session_id);
1871: g_initialize_log := TRUE;
1872: IF FND_LOG_REPOSITORY.CHECK_ACCESS_INTERNAL (l_module, l_log_level) THEN