[Home] [Help]
6517: /******************************************************************
6518: Created By : smaddali
6519: Date Created By : 11-Jun-03
6520: Purpose : loads each record in the hercules view ivstarh into the interface table
6521: igs_uc_istarh_ints with record status N
6522: Known limitations,enhancements,remarks:
6523: Change History
6524: Who When What
6525: jbaber 15-Sep-05 Load NULL for lasteducation and educationleavedate for bug 4589994
6551: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6552: l_new_max_timestamp igs_uc_ivstarh_2003_v.timestamp%TYPE ;
6553: l_count NUMBER ;
6554:
6555: l_appno igs_uc_istarh_ints.appno%TYPE;
6556: l_checkdigit NUMBER;
6557:
6558: BEGIN
6559: -- set syncronization required to false
6578: -- Determine actual appno
6579: get_appno(c_ivstarh_rec.appno, NULL, l_appno, l_checkdigit);
6580:
6581: -- Obsolete matching records in interface table with status N
6582: UPDATE igs_uc_istarh_ints SET record_status = 'O'
6583: WHERE record_status = 'N' AND appno = l_appno ;
6584:
6585: -- copy hercules record into interface table with record status N
6586: INSERT INTO igs_uc_istarh_ints ( appno,
6582: UPDATE igs_uc_istarh_ints SET record_status = 'O'
6583: WHERE record_status = 'N' AND appno = l_appno ;
6584:
6585: -- copy hercules record into interface table with record status N
6586: INSERT INTO igs_uc_istarh_ints ( appno,
6587: ethnic,
6588: socialclass,
6589: pocceduchangedate,
6590: pocc,
6652: /******************************************************************
6653: Created By : jbaber
6654: Date Created By : 15-Aug-05
6655: Purpose : loads each record in the hercules view ivgstarh into the interface table
6656: igs_uc_istarh_ints with record status N
6657: Known limitations,enhancements,remarks:
6658: Change History
6659: Who When What
6660: ***************************************************************** */
6677: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6678: l_new_max_timestamp igs_uc_ivgstarh_2006_v.timestamp%TYPE ;
6679: l_count NUMBER ;
6680:
6681: l_appno igs_uc_istarh_ints.appno%TYPE;
6682: l_checkdigit NUMBER;
6683:
6684: BEGIN
6685: -- set syncronization required to false
6704: -- Determine actual appno
6705: get_appno(c_ivgstarh_rec.appno, NULL, l_appno, l_checkdigit);
6706:
6707: -- Obsolete matching records in interface table with status N
6708: UPDATE igs_uc_istarh_ints SET record_status = 'O'
6709: WHERE record_status = 'N' AND appno = l_appno ;
6710:
6711: -- copy hercules record into interface table with record status N
6712: INSERT INTO igs_uc_istarh_ints ( appno,
6708: UPDATE igs_uc_istarh_ints SET record_status = 'O'
6709: WHERE record_status = 'N' AND appno = l_appno ;
6710:
6711: -- copy hercules record into interface table with record status N
6712: INSERT INTO igs_uc_istarh_ints ( appno,
6713: ethnic,
6714: record_status,
6715: error_code
6716: )
6785: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6786: l_new_max_timestamp igs_uc_ivnstarh_2006_v.timestamp%TYPE ;
6787: l_count NUMBER ;
6788:
6789: l_appno igs_uc_istarh_ints.appno%TYPE;
6790: l_checkdigit NUMBER;
6791:
6792: BEGIN
6793: -- set syncronization required to false
6812: -- Determine actual appno
6813: get_appno(c_ivnstarh_rec.appno, NULL, l_appno, l_checkdigit);
6814:
6815: -- Obsolete matching records in interface table with status N
6816: UPDATE igs_uc_istarh_ints SET record_status = 'O'
6817: WHERE record_status = 'N' AND appno = l_appno ;
6818:
6819: -- copy hercules record into interface table with record status N
6820: INSERT INTO igs_uc_istarh_ints ( appno,
6816: UPDATE igs_uc_istarh_ints SET record_status = 'O'
6817: WHERE record_status = 'N' AND appno = l_appno ;
6818:
6819: -- copy hercules record into interface table with record status N
6820: INSERT INTO igs_uc_istarh_ints ( appno,
6821: ethnic,
6822: dependants,
6823: married,
6824: record_status,