eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IREFRNC_INTS

Line 11507: igs_uc_irefrnc_ints with record status N

11503: /******************************************************************
11504: Created By : smaddali
11505: Date Created By : 11-Jun-03
11506: Purpose : loads each record in the hercules view ivreference into the interface table
11507: igs_uc_irefrnc_ints with record status N
11508: Known limitations,enhancements,remarks:
11509: Change History
11510: Who When What
11511: ***************************************************************** */

Line 11559: UPDATE igs_uc_irefrnc_ints SET record_status = 'O'

11555: -- set x_sync_read to true if the loop is entered even once
11556: g_sync_reqd := TRUE;
11557:
11558: -- Obsolete matching records in interface table with status N
11559: UPDATE igs_uc_irefrnc_ints SET record_status = 'O'
11560: WHERE record_status = 'N' AND appno = c_ivreference_rec.appno
11561: AND refereename = c_ivreference_rec.refereename ;
11562:
11563: -- copy hercules record into interface table with record status N

Line 11564: INSERT INTO igs_uc_irefrnc_ints ( appno,

11560: WHERE record_status = 'N' AND appno = c_ivreference_rec.appno
11561: AND refereename = c_ivreference_rec.refereename ;
11562:
11563: -- copy hercules record into interface table with record status N
11564: INSERT INTO igs_uc_irefrnc_ints ( appno,
11565: refereename,
11566: refereepost,
11567: estabname,
11568: address1,

Line 11632: igs_uc_irefrnc_ints with record status N

11628: /******************************************************************
11629: Created By : jbaber
11630: Date Created By : 07-Jul-05
11631: Purpose : loads each record in the hercules view ivreference into the interface table
11632: igs_uc_irefrnc_ints with record status N
11633: Known limitations,enhancements,remarks:
11634: Change History
11635: Who When What
11636: ***************************************************************** */

Line 11668: l_appno igs_uc_irefrnc_ints.appno%TYPE;

11664: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11665: l_new_max_timestamp igs_uc_ivreference_2006_v.timestamp%TYPE ;
11666: l_count NUMBER ;
11667:
11668: l_appno igs_uc_irefrnc_ints.appno%TYPE;
11669: l_checkdigit NUMBER;
11670:
11671: BEGIN
11672: -- set syncronization required to false

Line 11692: UPDATE igs_uc_irefrnc_ints SET record_status = 'O'

11688:
11689: get_appno(c_ivreference_rec.appno, NULL, l_appno, l_checkdigit);
11690:
11691: -- Obsolete matching records in interface table with status N
11692: UPDATE igs_uc_irefrnc_ints SET record_status = 'O'
11693: WHERE record_status = 'N' AND appno = l_appno
11694: AND refereename = c_ivreference_rec.refereename ;
11695:
11696: -- copy hercules record into interface table with record status N

Line 11697: INSERT INTO igs_uc_irefrnc_ints ( appno,

11693: WHERE record_status = 'N' AND appno = l_appno
11694: AND refereename = c_ivreference_rec.refereename ;
11695:
11696: -- copy hercules record into interface table with record status N
11697: INSERT INTO igs_uc_irefrnc_ints ( appno,
11698: refereename,
11699: refereepost,
11700: estabname,
11701: address1,

Line 11769: igs_uc_irefrnc_ints with record status N

11765: /******************************************************************
11766: Created By : jbaber
11767: Date Created By : 16-Aug-05
11768: Purpose : loads each record in the hercules view ivgreference into the interface table
11769: igs_uc_irefrnc_ints with record status N
11770: Known limitations,enhancements,remarks:
11771: Change History
11772: Who When What
11773: ***************************************************************** */

Line 11804: l_appno igs_uc_irefrnc_ints.appno%TYPE;

11800: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11801: l_new_max_timestamp igs_uc_ivgreference_2006_v.timestamp%TYPE ;
11802: l_count NUMBER ;
11803:
11804: l_appno igs_uc_irefrnc_ints.appno%TYPE;
11805: l_checkdigit NUMBER;
11806:
11807: BEGIN
11808: -- set syncronization required to false

Line 11828: UPDATE igs_uc_irefrnc_ints SET record_status = 'O'

11824:
11825: get_appno(c_ivgreference_rec.appno, NULL, l_appno, l_checkdigit);
11826:
11827: -- Obsolete matching records in interface table with status N
11828: UPDATE igs_uc_irefrnc_ints SET record_status = 'O'
11829: WHERE record_status = 'N' AND appno = l_appno
11830: AND refereename = c_ivgreference_rec.refereename ;
11831:
11832: -- copy hercules record into interface table with record status N

Line 11833: INSERT INTO igs_uc_irefrnc_ints ( appno,

11829: WHERE record_status = 'N' AND appno = l_appno
11830: AND refereename = c_ivgreference_rec.refereename ;
11831:
11832: -- copy hercules record into interface table with record status N
11833: INSERT INTO igs_uc_irefrnc_ints ( appno,
11834: refereename,
11835: refereepost,
11836: estabname,
11837: address1,

Line 11903: igs_uc_irefrnc_ints with record status N

11899: /******************************************************************
11900: Created By : jbaber
11901: Date Created By : 16-Aug-05
11902: Purpose : loads each record in the hercules view ivnreference into the interface table
11903: igs_uc_irefrnc_ints with record status N
11904: Known limitations,enhancements,remarks:
11905: Change History
11906: Who When What
11907: ***************************************************************** */

Line 11938: l_appno igs_uc_irefrnc_ints.appno%TYPE;

11934: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11935: l_new_max_timestamp igs_uc_ivnreference_2006_v.timestamp%TYPE ;
11936: l_count NUMBER ;
11937:
11938: l_appno igs_uc_irefrnc_ints.appno%TYPE;
11939: l_checkdigit NUMBER;
11940:
11941: BEGIN
11942: -- set syncronization required to false

Line 11962: UPDATE igs_uc_irefrnc_ints SET record_status = 'O'

11958:
11959: get_appno(c_ivnreference_rec.appno, NULL, l_appno, l_checkdigit);
11960:
11961: -- Obsolete matching records in interface table with status N
11962: UPDATE igs_uc_irefrnc_ints SET record_status = 'O'
11963: WHERE record_status = 'N' AND appno = l_appno
11964: AND refereename = c_ivnreference_rec.refereename ;
11965:
11966: -- copy hercules record into interface table with record status N

Line 11967: INSERT INTO igs_uc_irefrnc_ints ( appno,

11963: WHERE record_status = 'N' AND appno = l_appno
11964: AND refereename = c_ivnreference_rec.refereename ;
11965:
11966: -- copy hercules record into interface table with record status N
11967: INSERT INTO igs_uc_irefrnc_ints ( appno,
11968: refereename,
11969: refereepost,
11970: estabname,
11971: address1,