APPS.EDW_HR_PRSN_TYP_M_C SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

 l_rows_inserted            Number:=0;

Line: 69

   edw_log.put_line('Total rows inserted : '||g_row_count);

Line: 93

    l_rows_inserted NUMBER :=0;

Line: 103

   Insert Into
    EDW_HR_PTYP_PRSN_TYP_LSTG@EDW_APPS_TO_WH(
    PERSON_TYPE_PK,
    ALL_FK,
    NAME,
    PERSON_TYPE_DP,
    INSTANCE,
    POTENTIAL_WORKER_FLAG,
    PW_EMPLOYEE_TYPE,
    EMP_DIRECT_HIRE_FLAG,
    DH_PERMANENT_TYPE,
    DH_INTERN_TYPE,
    DH_FXD_TRM_LOWER_TYPE,
    DH_FXD_TRM_UPPER_TYPE,
    DH_EMP_STUDENT_FLAG,
    EMP_CNTNGNT_WRKFRC_FLAG,
    CW_AGNCY_CNTRCTR_TYPE,
    CW_SELF_EMPLOYED_TYPE,
    CW_CONSULTANT_TYPE,
    PW_EX_EMPLOYEE_TYPE,
    PW_APPLICANT_TYPE,
    NON_WORKER_FLAG,
    NW_CONTACT_FLAG,
    NW_DEPENDENT_TYPE,
    NW_RETIREE_TYPE,
    NW_BENEFICIARY_TYPE,
    SRVIVING_FMLY_MBR_TYPE,
    SRVIVING_SPOUSE_TYPE,
    EX_APPLICANT_TYPE,
    OTHER_TYPE,
    PARTICIPANT_TYPE,
    FORMER_SPOUSE_TYPE,
    FORMER_FMLY_MBR_TYPE,
    LAST_UPDATE_DATE,
    CREATION_DATE,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    PW_EMPLOYEE_FLAG,
    DH_PERMANENT_FLAG,
    DH_INTERN_FLAG,
    DH_FXD_TRM_LOWER_FLAG,
    DH_FXD_TRM_UPPER_FLAG,
    CW_AGNCY_CNTRCTR_FLAG,
    CW_SELF_EMPLOYED_FLAG,
    CW_CONSULTANT_FLAG,
    PW_EX_EMPLOYEE_FLAG,
    PW_APPLICANT_FLAG,
    NW_DEPENDENT_FLAG,
    NW_RETIREE_FLAG,
    NW_BENEFICIARY_FLAG,
    SRVIVING_FMLY_MBR_FLAG,
    SRVIVING_SPOUSE_FLAG,
    EX_APPLICANT_FLAG,
    OTHER_FLAG,
    PARTICIPANT_FLAG,
    FORMER_SPOUSE_FLAG,
    FORMER_FMLY_MBR_FLAG,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select PERSON_TYPE_PK,
    NVL(ALL_FK, 'NA_EDW'),
NAME,
PERSON_TYPE_DP,
INSTANCE,
POTENTIAL_WORKER_FLAG,
PW_EMPLOYEE_TYPE,
EMP_DIRECT_HIRE_FLAG,
DH_PERMANENT_TYPE,
DH_INTERN_TYPE,
DH_FXD_TRM_LOWER_TYPE,
DH_FXD_TRM_UPPER_TYPE,
DH_EMP_STUDENT_FLAG,
EMP_CNTNGNT_WRKFRC_FLAG,
CW_AGNCY_CNTRCTR_TYPE,
CW_SELF_EMPLOYED_TYPE,
CW_CONSULTANT_TYPE,
PW_EX_EMPLOYEE_TYPE,
PW_APPLICANT_TYPE,
NON_WORKER_FLAG,
NW_CONTACT_FLAG,
NW_DEPENDENT_TYPE,
NW_RETIREE_TYPE,
NW_BENEFICIARY_TYPE,
SRVIVING_FMLY_MBR_TYPE,
SRVIVING_SPOUSE_TYPE,
EX_APPLICANT_TYPE,
OTHER_TYPE,
PARTICIPANT_TYPE,
FORMER_SPOUSE_TYPE,
FORMER_FMLY_MBR_TYPE,
LAST_UPDATE_DATE,
CREATION_DATE,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
PW_EMPLOYEE_FLAG,
DH_PERMANENT_FLAG,
DH_INTERN_FLAG,
DH_FXD_TRM_LOWER_FLAG,
DH_FXD_TRM_UPPER_FLAG,
CW_AGNCY_CNTRCTR_FLAG,
CW_SELF_EMPLOYED_FLAG,
CW_CONSULTANT_FLAG,
PW_EX_EMPLOYEE_FLAG,
PW_APPLICANT_FLAG,
NW_DEPENDENT_FLAG,
NW_RETIREE_FLAG,
NW_BENEFICIARY_FLAG,
SRVIVING_FMLY_MBR_FLAG,
SRVIVING_SPOUSE_FLAG,
EX_APPLICANT_FLAG,
OTHER_FLAG,
PARTICIPANT_FLAG,
FORMER_SPOUSE_FLAG,
FORMER_FMLY_MBR_FLAG,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_PTYP_PRSN_TYP_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and sysdate;

Line: 229

   l_rows_inserted := sql%rowcount;

Line: 230

   EDW_HR_PRSN_TYP_M_C.g_row_count := EDW_HR_PRSN_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 231

   edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the EDW_HR_PTYP_PRSN_TYP_LSTG staging table');