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_TRAN_PROCESSOR_PKG dependencies on IGS_UC_OFFER_CONDS

Line 1338: p_comments_in_offer OUT NOCOPY igs_uc_offer_conds.marvin_code%TYPE ) IS

1334:
1335: PROCEDURE transaction_population(p_condition_category1 IN igs_uc_transactions.test_cond_cat%TYPE ,
1336: p_condition_name1 IN igs_uc_transactions.test_cond_name%TYPE ,
1337: p_soc1 OUT NOCOPY igs_uc_transactions.SOC%TYPE,
1338: p_comments_in_offer OUT NOCOPY igs_uc_offer_conds.marvin_code%TYPE ) IS
1339:
1340: /*********************************************************************
1341: Created By : pmarada
1342: Date Created By : 01-Nov-2003

Line 1352: CURSOR c_offer_conds (cp_condition_category igs_uc_offer_conds.condition_category%TYPE,

1348: Who When What
1349:
1350: **********************************************************************/
1351:
1352: CURSOR c_offer_conds (cp_condition_category igs_uc_offer_conds.condition_category%TYPE,
1353: cp_condition_name igs_uc_offer_conds.condition_name%TYPE) IS
1354: SELECT marvin_code, summ_of_cond FROM igs_uc_offer_conds
1355: WHERE condition_category = cp_condition_category
1356: AND condition_name = cp_condition_name;

Line 1353: cp_condition_name igs_uc_offer_conds.condition_name%TYPE) IS

1349:
1350: **********************************************************************/
1351:
1352: CURSOR c_offer_conds (cp_condition_category igs_uc_offer_conds.condition_category%TYPE,
1353: cp_condition_name igs_uc_offer_conds.condition_name%TYPE) IS
1354: SELECT marvin_code, summ_of_cond FROM igs_uc_offer_conds
1355: WHERE condition_category = cp_condition_category
1356: AND condition_name = cp_condition_name;
1357:

Line 1354: SELECT marvin_code, summ_of_cond FROM igs_uc_offer_conds

1350: **********************************************************************/
1351:
1352: CURSOR c_offer_conds (cp_condition_category igs_uc_offer_conds.condition_category%TYPE,
1353: cp_condition_name igs_uc_offer_conds.condition_name%TYPE) IS
1354: SELECT marvin_code, summ_of_cond FROM igs_uc_offer_conds
1355: WHERE condition_category = cp_condition_category
1356: AND condition_name = cp_condition_name;
1357:
1358: l_offer_conds c_offer_conds%ROWTYPE;

Line 1427: igs_uc_offer_conds table with status

1423: Date Created By : 23-JAN-2002
1424: Purpose: To write into TRANIN when the 'sent_to_ucas' and 'hold_flag' flag is no.
1425: and cycle is 2003 then write the transaction details in Tranin and
1426: Also updates igs_uc_transactions with info. from TRANIN and update the
1427: igs_uc_offer_conds table with status
1428: Know limitations, enhancements or remarks
1429: Change History
1430: Who When What
1431: rbezawad 4-Apr-2002 1) Inistitution Reference Column is added w.r.t. UCCR002 Data Model Change.

Line 1440: rbezawad 16-Jul-2002 Added logic to populate the columns SUMM_OF_COND, LETTER_TEXT columns of table IGS_UC_OFFER_CONDS w.r.t. Bug 2461913.

1436: Also while inserting records into traning, the columns TRANSACTIONID,TIMESTAMP,UPDATER,ERRORCODE values are passed as NULL.
1437: These modifications are done as part of 2450438.
1438: rbezawad 16-Jul-2002 While inserting Transactions into Tranin, for the program_code and Campus fields, logic is added to replace the '*' character with ' '.
1439: Added logic for better reporting while exporting transactions. Modifications are done w.r.t. Bug 2462096
1440: rbezawad 16-Jul-2002 Added logic to populate the columns SUMM_OF_COND, LETTER_TEXT columns of table IGS_UC_OFFER_CONDS w.r.t. Bug 2461913.
1441: smaddali 02-oct-2002 Modified for bug 2603384
1442: 1) added new column auto_generated_flag to tbh calls to igs_uc_transactions_pkg
1443: 2) modified cursor cur_records_to_write to fetch column auto_generated_flag
1444: 3) modified igs_uc_transactions.update_row call to update test_cond_cat and name

Line 1490: FROM igs_uc_offer_conds a

1486: a.effective_from, a.effective_to, a.status, a.marvin_code,
1487: a.summ_of_cond, a.letter_text, a.created_by,
1488: a.creation_date, a.last_updated_by,
1489: a.last_update_date, a.last_update_login, a.decision
1490: FROM igs_uc_offer_conds a
1491: WHERE a.condition_category = cp_test_cond_cat
1492: AND a.condition_name = cp_test_cond_name;
1493:
1494: l_app_no igs_uc_transactions.app_no%TYPE;

Line 1590: --If errorcode returned from 'TranIn' view success then the status field in IGS_UC_OFFER_CONDS should be updated accordingly.

1586: x_part_time => uc_transaction_rec.part_time);
1587: -- Check for 'XA' and 'XD' type transactions.
1588:
1589: IF uc_transaction_rec.transaction_type = 'XA' OR uc_transaction_rec.transaction_type = 'XD' THEN
1590: --If errorcode returned from 'TranIn' view success then the status field in IGS_UC_OFFER_CONDS should be updated accordingly.
1591: --Also if errorcode returned is not success then the status field in IGS_UC_OFFER_CONDS should be updated with corresponding to failed.
1592:
1593: IF tranin_rec.errorcode = 0 THEN
1594: FOR offer_conds_rec1 IN cur_offer_conds(uc_transaction_rec.test_cond_cat,uc_transaction_rec.test_cond_name)

Line 1591: --Also if errorcode returned is not success then the status field in IGS_UC_OFFER_CONDS should be updated with corresponding to failed.

1587: -- Check for 'XA' and 'XD' type transactions.
1588:
1589: IF uc_transaction_rec.transaction_type = 'XA' OR uc_transaction_rec.transaction_type = 'XD' THEN
1590: --If errorcode returned from 'TranIn' view success then the status field in IGS_UC_OFFER_CONDS should be updated accordingly.
1591: --Also if errorcode returned is not success then the status field in IGS_UC_OFFER_CONDS should be updated with corresponding to failed.
1592:
1593: IF tranin_rec.errorcode = 0 THEN
1594: FOR offer_conds_rec1 IN cur_offer_conds(uc_transaction_rec.test_cond_cat,uc_transaction_rec.test_cond_name)
1595: LOOP

Line 1596: igs_uc_offer_conds_pkg.update_row (

1592:
1593: IF tranin_rec.errorcode = 0 THEN
1594: FOR offer_conds_rec1 IN cur_offer_conds(uc_transaction_rec.test_cond_cat,uc_transaction_rec.test_cond_name)
1595: LOOP
1596: igs_uc_offer_conds_pkg.update_row (
1597: x_mode => 'R',
1598: x_rowid => offer_conds_rec1.ROWID,
1599: x_condition_category => offer_conds_rec1.condition_category,
1600: x_condition_name => offer_conds_rec1.condition_name,

Line 1613: igs_uc_offer_conds_pkg.update_row (

1609: END LOOP;
1610: ELSE
1611: FOR offer_conds_rec1 IN cur_offer_conds(uc_transaction_rec.test_cond_cat,uc_transaction_rec.test_cond_name)
1612: LOOP
1613: igs_uc_offer_conds_pkg.update_row (
1614: x_mode => 'R',
1615: x_rowid => offer_conds_rec1.ROWID,
1616: x_condition_category => offer_conds_rec1.condition_category,
1617: x_condition_name => offer_conds_rec1.condition_name,

Line 1657: igs_uc_offer_conds table with status.

1653: Date Created By : 10-June-2003
1654: Purpose: To write into TRANIN when the 'sent_to_ucas' and 'hold_flag' flag is no.
1655: and cycle is 2004 then write the transaction details into Tranin and
1656: Also updates igs_uc_transactions with info. from TRANIN, and update the
1657: igs_uc_offer_conds table with status.
1658: Know limitations, enhancements or remarks
1659: Change History (reverse chronological order - newest change first)
1660:
1661: Who When What

Line 1706: FROM igs_uc_offer_conds a

1702: a.effective_from, a.effective_to, a.status, a.marvin_code,
1703: a.summ_of_cond, a.letter_text, a.created_by,
1704: a.creation_date, a.last_updated_by,
1705: a.last_update_date, a.last_update_login, a.decision
1706: FROM igs_uc_offer_conds a
1707: WHERE a.condition_category = cp_test_cond_cat
1708: AND a.condition_name = cp_test_cond_name;
1709:
1710: -- Cursor to convert 8-digit appno to 9 digit NUMBER with check digit for UC315 - UCAS 2006 Support

Line 1879: --If errorcode returned from 'TranIn' view success then the status field in IGS_UC_OFFER_CONDS should be updated accordingly.

1875: x_part_time => uc_transaction_rec.part_time);
1876: -- Check for 'XA' and 'XD' type transactions.
1877:
1878: IF uc_transaction_rec.transaction_type = 'XA' OR uc_transaction_rec.transaction_type = 'XD' THEN
1879: --If errorcode returned from 'TranIn' view success then the status field in IGS_UC_OFFER_CONDS should be updated accordingly.
1880: --Also if errorcode returned is not success then the status field in IGS_UC_OFFER_CONDS should be updated with corresponding to failed.
1881:
1882: IF tranin_rec.errorcode = 0 THEN
1883: FOR offer_conds_rec1 IN cur_offer_conds(uc_transaction_rec.test_cond_cat,uc_transaction_rec.test_cond_name)

Line 1880: --Also if errorcode returned is not success then the status field in IGS_UC_OFFER_CONDS should be updated with corresponding to failed.

1876: -- Check for 'XA' and 'XD' type transactions.
1877:
1878: IF uc_transaction_rec.transaction_type = 'XA' OR uc_transaction_rec.transaction_type = 'XD' THEN
1879: --If errorcode returned from 'TranIn' view success then the status field in IGS_UC_OFFER_CONDS should be updated accordingly.
1880: --Also if errorcode returned is not success then the status field in IGS_UC_OFFER_CONDS should be updated with corresponding to failed.
1881:
1882: IF tranin_rec.errorcode = 0 THEN
1883: FOR offer_conds_rec1 IN cur_offer_conds(uc_transaction_rec.test_cond_cat,uc_transaction_rec.test_cond_name)
1884: LOOP

Line 1885: igs_uc_offer_conds_pkg.update_row (

1881:
1882: IF tranin_rec.errorcode = 0 THEN
1883: FOR offer_conds_rec1 IN cur_offer_conds(uc_transaction_rec.test_cond_cat,uc_transaction_rec.test_cond_name)
1884: LOOP
1885: igs_uc_offer_conds_pkg.update_row (
1886: x_mode => 'R',
1887: x_rowid => offer_conds_rec1.ROWID,
1888: x_condition_category => offer_conds_rec1.condition_category,
1889: x_condition_name => offer_conds_rec1.condition_name,

Line 1903: igs_uc_offer_conds_pkg.update_row (

1899: END LOOP;
1900: ELSE
1901: FOR offer_conds_rec1 IN cur_offer_conds(uc_transaction_rec.test_cond_cat,uc_transaction_rec.test_cond_name)
1902: LOOP
1903: igs_uc_offer_conds_pkg.update_row (
1904: x_mode => 'R',
1905: x_rowid => offer_conds_rec1.ROWID,
1906: x_condition_category => offer_conds_rec1.condition_category,
1907: x_condition_name => offer_conds_rec1.condition_name,