APPS.HXT_GEN_AAI dependencies on DUAL

Line 408: FROM sys.dual;

404:
405: /* Cursor to Create unique ID for AAI row */
406: CURSOR create_unique_id IS
407: SELECT hxt_seqno.nextval
408: FROM sys.dual;
409: l_id NUMBER(15);
410:
411: BEGIN
412: g_debug :=hr_utility.debug_enabled;

Line 462: -- fnd_message.set_name('HXT', 'HXT_39124_ROW_IN_DUAL_NF');

458: IF create_unique_id%NOTFOUND THEN
459: if g_debug then
460: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',60);
461: end if;
462: -- fnd_message.set_name('HXT', 'HXT_39124_ROW_IN_DUAL_NF');
463: -- fnd_message.error;
464: hr_utility.set_message(809,'HXT_39124_ROW_IN_DUAL_NF');
465: hr_utility.raise_error;
466: END IF;

Line 464: hr_utility.set_message(809,'HXT_39124_ROW_IN_DUAL_NF');

460: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',60);
461: end if;
462: -- fnd_message.set_name('HXT', 'HXT_39124_ROW_IN_DUAL_NF');
463: -- fnd_message.error;
464: hr_utility.set_message(809,'HXT_39124_ROW_IN_DUAL_NF');
465: hr_utility.raise_error;
466: END IF;
467: CLOSE create_unique_id;
468: END IF;

Line 678: FROM sys.dual;

674:
675: /* Cursor to Create unique ID for AAI row */
676: /* CURSOR create_unique_id IS
677: SELECT hxt_seqno.nextval
678: FROM sys.dual;
679:
680: l_id NUMBER(15);
681: */
682: l_effective_start_date DATE;