APPS.IGS_EN_GEN_009 dependencies on IGS_EN_MERGE_ID_ROWS

Line 548: obsolete_person_id IGS_EN_MERGE_ID_ROWS.obsolete_person_id%TYPE,

544:
545: BEGIN
546: DECLARE
547: TYPE t_merge_type IS RECORD (
548: obsolete_person_id IGS_EN_MERGE_ID_ROWS.obsolete_person_id%TYPE,
549: obsolete_id_row_info IGS_EN_MERGE_ID_ROWS.obsolete_id_row_info%TYPE,
550: current_person_id IGS_EN_MERGE_ID_ROWS.current_person_id%TYPE,
551: current_id_row_info IGS_EN_MERGE_ID_ROWS.current_id_row_info%TYPE,
552: table_alias IGS_EN_MERGE_ID_ROWS.table_alias%TYPE,

Line 549: obsolete_id_row_info IGS_EN_MERGE_ID_ROWS.obsolete_id_row_info%TYPE,

545: BEGIN
546: DECLARE
547: TYPE t_merge_type IS RECORD (
548: obsolete_person_id IGS_EN_MERGE_ID_ROWS.obsolete_person_id%TYPE,
549: obsolete_id_row_info IGS_EN_MERGE_ID_ROWS.obsolete_id_row_info%TYPE,
550: current_person_id IGS_EN_MERGE_ID_ROWS.current_person_id%TYPE,
551: current_id_row_info IGS_EN_MERGE_ID_ROWS.current_id_row_info%TYPE,
552: table_alias IGS_EN_MERGE_ID_ROWS.table_alias%TYPE,
553: action_id IGS_EN_MRG_ID_ACT_CH.action_id%TYPE,

Line 550: current_person_id IGS_EN_MERGE_ID_ROWS.current_person_id%TYPE,

546: DECLARE
547: TYPE t_merge_type IS RECORD (
548: obsolete_person_id IGS_EN_MERGE_ID_ROWS.obsolete_person_id%TYPE,
549: obsolete_id_row_info IGS_EN_MERGE_ID_ROWS.obsolete_id_row_info%TYPE,
550: current_person_id IGS_EN_MERGE_ID_ROWS.current_person_id%TYPE,
551: current_id_row_info IGS_EN_MERGE_ID_ROWS.current_id_row_info%TYPE,
552: table_alias IGS_EN_MERGE_ID_ROWS.table_alias%TYPE,
553: action_id IGS_EN_MRG_ID_ACT_CH.action_id%TYPE,
554: perform_action_id IGS_EN_MRG_ID_ACT_CH.perform_action_ind%TYPE );

Line 551: current_id_row_info IGS_EN_MERGE_ID_ROWS.current_id_row_info%TYPE,

547: TYPE t_merge_type IS RECORD (
548: obsolete_person_id IGS_EN_MERGE_ID_ROWS.obsolete_person_id%TYPE,
549: obsolete_id_row_info IGS_EN_MERGE_ID_ROWS.obsolete_id_row_info%TYPE,
550: current_person_id IGS_EN_MERGE_ID_ROWS.current_person_id%TYPE,
551: current_id_row_info IGS_EN_MERGE_ID_ROWS.current_id_row_info%TYPE,
552: table_alias IGS_EN_MERGE_ID_ROWS.table_alias%TYPE,
553: action_id IGS_EN_MRG_ID_ACT_CH.action_id%TYPE,
554: perform_action_id IGS_EN_MRG_ID_ACT_CH.perform_action_ind%TYPE );
555: v_merge_record t_merge_type;

Line 552: table_alias IGS_EN_MERGE_ID_ROWS.table_alias%TYPE,

548: obsolete_person_id IGS_EN_MERGE_ID_ROWS.obsolete_person_id%TYPE,
549: obsolete_id_row_info IGS_EN_MERGE_ID_ROWS.obsolete_id_row_info%TYPE,
550: current_person_id IGS_EN_MERGE_ID_ROWS.current_person_id%TYPE,
551: current_id_row_info IGS_EN_MERGE_ID_ROWS.current_id_row_info%TYPE,
552: table_alias IGS_EN_MERGE_ID_ROWS.table_alias%TYPE,
553: action_id IGS_EN_MRG_ID_ACT_CH.action_id%TYPE,
554: perform_action_id IGS_EN_MRG_ID_ACT_CH.perform_action_ind%TYPE );
555: v_merge_record t_merge_type;
556: CURSOR c_get_merge_data IS

Line 564: FROM IGS_EN_MERGE_ID_ROWS smir, IGS_EN_MRG_ID_ACT_CH smiac

560: smir.current_id_row_info,
561: smir.table_alias,
562: smiac.action_id,
563: smiac.perform_action_ind
564: FROM IGS_EN_MERGE_ID_ROWS smir, IGS_EN_MRG_ID_ACT_CH smiac
565: WHERE smir.smir_id = p_smir_id AND
566: smir.smir_id = smiac.smir_id;
567: l_seqval NUMBER;
568: