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.

[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_ISTARA_INTS

Line 4997: igs_uc_istara_ints with record status N

4993: /******************************************************************
4994: Created By : smaddali
4995: Date Created By : 11-Jun-03
4996: Purpose : loads each record in the hercules view ivstara into the interface table
4997: igs_uc_istara_ints with record status N
4998: Known limitations,enhancements,remarks:
4999: Change History
5000: Who When What
5001: ***************************************************************** */

Line 5056: UPDATE igs_uc_istara_ints SET record_status = 'O'

5052: -- set x_sync_read to true if the loop is entered even once
5053: g_sync_reqd := TRUE;
5054:
5055: -- Obsolete matching records in interface table with status N
5056: UPDATE igs_uc_istara_ints SET record_status = 'O'
5057: WHERE record_status = 'N' AND appno = c_ivstara_rec.appno;
5058:
5059: -- copy hercules record into interface table with record status N
5060: INSERT INTO igs_uc_istara_ints ( appno,

Line 5060: INSERT INTO igs_uc_istara_ints ( appno,

5056: UPDATE igs_uc_istara_ints SET record_status = 'O'
5057: WHERE record_status = 'N' AND appno = c_ivstara_rec.appno;
5058:
5059: -- copy hercules record into interface table with record status N
5060: INSERT INTO igs_uc_istara_ints ( appno,
5061: addressarea,
5062: address1,
5063: address2,
5064: address3,

Line 5141: igs_uc_istara_ints with record status N

5137: /******************************************************************
5138: Created By : jbaber
5139: Date Created By : 11-Jun-03
5140: Purpose : loads each record in the hercules view ivstara into the interface table
5141: igs_uc_istara_ints with record status N
5142: Known limitations,enhancements,remarks:
5143: Change History
5144: Who When What
5145: ***************************************************************** */

Line 5179: l_appno igs_uc_istara_ints.appno%TYPE;

5175: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5176: l_new_max_timestamp igs_uc_ivstara_2006_v.timestamp%TYPE ;
5177: l_count NUMBER ;
5178:
5179: l_appno igs_uc_istara_ints.appno%TYPE;
5180: l_checkdigit NUMBER;
5181:
5182: BEGIN
5183: -- set syncronization required to false

Line 5204: UPDATE igs_uc_istara_ints SET record_status = 'O'

5200: -- Determine actual appno
5201: get_appno(c_ivstara_rec.appno, NULL, l_appno, l_checkdigit);
5202:
5203: -- Obsolete matching records in interface table with status N
5204: UPDATE igs_uc_istara_ints SET record_status = 'O'
5205: WHERE record_status = 'N' AND appno = l_appno;
5206:
5207: -- copy hercules record into interface table with record status N
5208: INSERT INTO igs_uc_istara_ints ( appno,

Line 5208: INSERT INTO igs_uc_istara_ints ( appno,

5204: UPDATE igs_uc_istara_ints SET record_status = 'O'
5205: WHERE record_status = 'N' AND appno = l_appno;
5206:
5207: -- copy hercules record into interface table with record status N
5208: INSERT INTO igs_uc_istara_ints ( appno,
5209: addressarea,
5210: address1,
5211: address2,
5212: address3,

Line 5282: igs_uc_istara_ints with record status N

5278: /******************************************************************
5279: Created By : jbaber
5280: Date Created By : 11-Jul-06
5281: Purpose : loads each record in the hercules view ivstara into the interface table
5282: igs_uc_istara_ints with record status N
5283: Known limitations,enhancements,remarks:
5284: Change History
5285: Who When What
5286: ***************************************************************** */

Line 5323: l_appno igs_uc_istara_ints.appno%TYPE;

5319: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5320: l_new_max_timestamp igs_uc_ivstara_2007_v.timestamp%TYPE ;
5321: l_count NUMBER ;
5322:
5323: l_appno igs_uc_istara_ints.appno%TYPE;
5324: l_checkdigit NUMBER;
5325:
5326: BEGIN
5327: -- set syncronization required to false

Line 5348: UPDATE igs_uc_istara_ints SET record_status = 'O'

5344: -- Determine actual appno
5345: get_appno(c_ivstara_rec.appno, NULL, l_appno, l_checkdigit);
5346:
5347: -- Obsolete matching records in interface table with status N
5348: UPDATE igs_uc_istara_ints SET record_status = 'O'
5349: WHERE record_status = 'N' AND appno = l_appno;
5350:
5351: -- copy hercules record into interface table with record status N
5352: INSERT INTO igs_uc_istara_ints ( appno,

Line 5352: INSERT INTO igs_uc_istara_ints ( appno,

5348: UPDATE igs_uc_istara_ints SET record_status = 'O'
5349: WHERE record_status = 'N' AND appno = l_appno;
5350:
5351: -- copy hercules record into interface table with record status N
5352: INSERT INTO igs_uc_istara_ints ( appno,
5353: addressarea,
5354: address1,
5355: address2,
5356: address3,

Line 5433: igs_uc_istara_ints with record status N

5429: /******************************************************************
5430: Created By : jbaber
5431: Date Created By : 12-Aug-03
5432: Purpose : loads each record in the hercules view ivgstara into the interface table
5433: igs_uc_istara_ints with record status N
5434: Known limitations,enhancements,remarks:
5435: Change History
5436: Who When What
5437: ***************************************************************** */

Line 5467: l_appno igs_uc_istara_ints.appno%TYPE;

5463: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5464: l_new_max_timestamp igs_uc_ivgstara_2006_v.timestamp%TYPE ;
5465: l_count NUMBER ;
5466:
5467: l_appno igs_uc_istara_ints.appno%TYPE;
5468: l_checkdigit NUMBER;
5469:
5470: BEGIN
5471: -- set syncronization required to false

Line 5492: UPDATE igs_uc_istara_ints SET record_status = 'O'

5488: -- Determine actual appno
5489: get_appno(c_ivgstara_rec.appno, NULL, l_appno, l_checkdigit);
5490:
5491: -- Obsolete matching records in interface table with status N
5492: UPDATE igs_uc_istara_ints SET record_status = 'O'
5493: WHERE record_status = 'N' AND appno = l_appno;
5494:
5495: -- copy hercules record into interface table with record status N
5496: INSERT INTO igs_uc_istara_ints ( appno,

Line 5496: INSERT INTO igs_uc_istara_ints ( appno,

5492: UPDATE igs_uc_istara_ints SET record_status = 'O'
5493: WHERE record_status = 'N' AND appno = l_appno;
5494:
5495: -- copy hercules record into interface table with record status N
5496: INSERT INTO igs_uc_istara_ints ( appno,
5497: addressarea,
5498: address1,
5499: address2,
5500: address3,

Line 5563: igs_uc_istara_ints with record status N

5559: /******************************************************************
5560: Created By : jbaber
5561: Date Created By : 11-Jul-06
5562: Purpose : loads each record in the hercules view ivgstara into the interface table
5563: igs_uc_istara_ints with record status N
5564: Known limitations,enhancements,remarks:
5565: Change History
5566: Who When What
5567: ***************************************************************** */

Line 5604: l_appno igs_uc_istara_ints.appno%TYPE;

5600: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5601: l_new_max_timestamp igs_uc_ivgstara_2007_v.timestamp%TYPE ;
5602: l_count NUMBER ;
5603:
5604: l_appno igs_uc_istara_ints.appno%TYPE;
5605: l_checkdigit NUMBER;
5606:
5607: BEGIN
5608: -- set syncronization required to false

Line 5629: UPDATE igs_uc_istara_ints SET record_status = 'O'

5625: -- Determine actual appno
5626: get_appno(c_ivgstara_rec.appno, NULL, l_appno, l_checkdigit);
5627:
5628: -- Obsolete matching records in interface table with status N
5629: UPDATE igs_uc_istara_ints SET record_status = 'O'
5630: WHERE record_status = 'N' AND appno = l_appno;
5631:
5632: -- copy hercules record into interface table with record status N
5633: INSERT INTO igs_uc_istara_ints ( appno,

Line 5633: INSERT INTO igs_uc_istara_ints ( appno,

5629: UPDATE igs_uc_istara_ints SET record_status = 'O'
5630: WHERE record_status = 'N' AND appno = l_appno;
5631:
5632: -- copy hercules record into interface table with record status N
5633: INSERT INTO igs_uc_istara_ints ( appno,
5634: addressarea,
5635: address1,
5636: address2,
5637: address3,

Line 5714: igs_uc_istara_ints with record status N

5710: /******************************************************************
5711: Created By : jbaber
5712: Date Created By : 12-Aug-03
5713: Purpose : loads each record in the hercules view ivnstara into the interface table
5714: igs_uc_istara_ints with record status N
5715: Known limitations,enhancements,remarks:
5716: Change History
5717: Who When What
5718: ***************************************************************** */

Line 5748: l_appno igs_uc_istara_ints.appno%TYPE;

5744: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5745: l_new_max_timestamp igs_uc_ivnstara_2006_v.timestamp%TYPE ;
5746: l_count NUMBER ;
5747:
5748: l_appno igs_uc_istara_ints.appno%TYPE;
5749: l_checkdigit NUMBER;
5750:
5751: BEGIN
5752: -- set syncronization required to false

Line 5773: UPDATE igs_uc_istara_ints SET record_status = 'O'

5769: -- Determine actual appno
5770: get_appno(c_ivnstara_rec.appno, NULL, l_appno, l_checkdigit);
5771:
5772: -- Obsolete matching records in interface table with status N
5773: UPDATE igs_uc_istara_ints SET record_status = 'O'
5774: WHERE record_status = 'N' AND appno = l_appno;
5775:
5776: -- copy hercules record into interface table with record status N
5777: INSERT INTO igs_uc_istara_ints ( appno,

Line 5777: INSERT INTO igs_uc_istara_ints ( appno,

5773: UPDATE igs_uc_istara_ints SET record_status = 'O'
5774: WHERE record_status = 'N' AND appno = l_appno;
5775:
5776: -- copy hercules record into interface table with record status N
5777: INSERT INTO igs_uc_istara_ints ( appno,
5778: addressarea,
5779: address1,
5780: address2,
5781: address3,

Line 5844: igs_uc_istara_ints with record status N

5840: /******************************************************************
5841: Created By : jbaber
5842: Date Created By : 11-Jul-06
5843: Purpose : loads each record in the hercules view ivnstara into the interface table
5844: igs_uc_istara_ints with record status N
5845: Known limitations,enhancements,remarks:
5846: Change History
5847: Who When What
5848: ***************************************************************** */

Line 5885: l_appno igs_uc_istara_ints.appno%TYPE;

5881: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5882: l_new_max_timestamp igs_uc_ivnstara_2007_v.timestamp%TYPE ;
5883: l_count NUMBER ;
5884:
5885: l_appno igs_uc_istara_ints.appno%TYPE;
5886: l_checkdigit NUMBER;
5887:
5888: BEGIN
5889: -- set syncronization required to false

Line 5910: UPDATE igs_uc_istara_ints SET record_status = 'O'

5906: -- Determine actual appno
5907: get_appno(c_ivnstara_rec.appno, NULL, l_appno, l_checkdigit);
5908:
5909: -- Obsolete matching records in interface table with status N
5910: UPDATE igs_uc_istara_ints SET record_status = 'O'
5911: WHERE record_status = 'N' AND appno = l_appno;
5912:
5913: -- copy hercules record into interface table with record status N
5914: INSERT INTO igs_uc_istara_ints ( appno,

Line 5914: INSERT INTO igs_uc_istara_ints ( appno,

5910: UPDATE igs_uc_istara_ints SET record_status = 'O'
5911: WHERE record_status = 'N' AND appno = l_appno;
5912:
5913: -- copy hercules record into interface table with record status N
5914: INSERT INTO igs_uc_istara_ints ( appno,
5915: addressarea,
5916: address1,
5917: address2,
5918: address3,