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_TRANSACTIONS_PKG

Line 48: 2) modifying tbh calls igs_uc_transactions_pkg to add x_auto_generated_flag

44: While generating the LD transaction, removed the validation which is
45: checking the P_free_format value to be not null when decision = W.
46: smaddali 02-oct-2002 modified for bug 2603384
47: 1) added 3 new parameters p_cond_cat, p_cond_nae ,p_auto_generated
48: 2) modifying tbh calls igs_uc_transactions_pkg to add x_auto_generated_flag
49: 3) passing calues of p_cond_cat and p_cond_name to x_test_cond_cat and x_test_cond_name
50: instead of NULL in tbh calls of igs_uc_transactions_pkg
51: rbezawad 02-Apr-2002 Modified w.r.t. UCCR002 DLD. Bug No:2278817.
52: 1) Passed Entry year, Entry month fields for LC type transactions.

Line 50: instead of NULL in tbh calls of igs_uc_transactions_pkg

46: smaddali 02-oct-2002 modified for bug 2603384
47: 1) added 3 new parameters p_cond_cat, p_cond_nae ,p_auto_generated
48: 2) modifying tbh calls igs_uc_transactions_pkg to add x_auto_generated_flag
49: 3) passing calues of p_cond_cat and p_cond_name to x_test_cond_cat and x_test_cond_name
50: instead of NULL in tbh calls of igs_uc_transactions_pkg
51: rbezawad 02-Apr-2002 Modified w.r.t. UCCR002 DLD. Bug No:2278817.
52: 1) Passed Entry year, Entry month fields for LC type transactions.
53: 2) RX Transactions are validated to always accept decision value 'A'.
54: 3) Inst_reference field is added as data model is effected.

Line 212: igs_uc_transactions_pkg.insert_row (

208: CLOSE cur_find_trans;
209:
210: IF l_cnt > 0 THEN
211: P_return1 := 0;
212: igs_uc_transactions_pkg.insert_row (
213: x_mode => p_mode, --jchakrab modified for 4380412
214: x_rowid => lv_rowid,
215: x_uc_tran_id => l_uc_tran_id,
216: x_transaction_id => NULL,

Line 258: igs_uc_transactions_pkg.update_row(

254: OPEN c_transactions(l_uc_tran_id);
255: FETCH c_transactions INTO l_transactions;
256: CLOSE c_transactions;
257:
258: igs_uc_transactions_pkg.update_row(
259: x_rowid => l_transactions.rowid,
260: x_uc_tran_id => l_transactions.uc_tran_id,
261: x_transaction_id => l_transactions.transaction_id,
262: x_datetimestamp => l_transactions.datetimestamp,

Line 308: igs_uc_transactions_pkg.insert_row (

304: IF P_App_no IS NOT NULL AND P_Choice_no IS NOT NULL AND P_Hold IS NOT NULL
305: AND p_system_code IS NOT NULL AND p_ucas_cycle IS NOT NULL THEN
306: IF P_Course IS NOT NULL OR P_Entry_point IS NOT NULL THEN
307: P_return1 := 0;
308: igs_uc_transactions_pkg.insert_row (
309: x_mode => p_mode, --jchakrab modified for 4380412
310: x_rowid => lv_rowid,
311: x_uc_tran_id => l_uc_tran_id,
312: x_transaction_id => NULL,

Line 357: igs_uc_transactions_pkg.insert_row (

353: IF P_App_no IS NOT NULL AND P_Choice_no IS NOT NULL AND P_Decision IS NOT NULL AND P_Hold IS NOT NULL
354: AND p_system_code IS NOT NULL AND p_ucas_cycle IS NOT NULL THEN
355: P_return1 := 0;
356:
357: igs_uc_transactions_pkg.insert_row (
358: x_mode => p_mode, --jchakrab modified for 4380412
359: x_rowid => lv_rowid,
360: x_uc_tran_id => l_uc_tran_id,
361: x_transaction_id => NULL,

Line 403: igs_uc_transactions_pkg.update_row(

399: OPEN c_transactions(l_uc_tran_id);
400: FETCH c_transactions INTO l_transactions;
401: CLOSE c_transactions;
402:
403: igs_uc_transactions_pkg.update_row(
404: x_rowid => l_transactions.rowid,
405: x_uc_tran_id => l_transactions.uc_tran_id,
406: x_transaction_id => l_transactions.transaction_id,
407: x_datetimestamp => l_transactions.datetimestamp,

Line 458: igs_uc_transactions_pkg.insert_row (

454: P_return1 := 1;
455: P_return2:= 'IGS_UC_NO_LK_FOR_LA';
456: ELSE
457: P_return1 := 0;
458: igs_uc_transactions_pkg.insert_row (
459: x_mode => p_mode, --jchakrab modified for 4380412
460: x_rowid => lv_rowid,
461: x_uc_tran_id => l_uc_tran_id,
462: x_transaction_id => NULL,

Line 530: igs_uc_transactions_pkg.insert_row (

526: END IF;
527:
528: IF l_generate = 'Y' THEN
529: P_return1 := 0;
530: igs_uc_transactions_pkg.insert_row (
531: x_mode => p_mode, --jchakrab modified for 4380412
532: x_rowid => lv_rowid,
533: x_uc_tran_id => l_uc_tran_id,
534: x_transaction_id => NULL,

Line 583: igs_uc_transactions_pkg.insert_row (

579: CLOSE cur_app_choice_decision;
580:
581: IF l_decision = 'U' AND l_reply = 'F' THEN
582: P_return1 := 0;
583: igs_uc_transactions_pkg.insert_row (
584: x_mode => p_mode, --jchakrab modified for 4380412
585: x_rowid => lv_rowid,
586: x_uc_tran_id => l_uc_tran_id,
587: x_transaction_id => NULL,

Line 633: igs_uc_transactions_pkg.insert_row (

629: IF (P_Decision IN ('C','I') AND ((P_Course IS NOT NULL AND P_Campus IS NOT NULL) OR
630: (P_Entry_month IS NOT NULL AND P_Entry_Year IS NOT NULL) OR (P_Entry_point IS NOT NULL)))
631: OR (P_Decision NOT IN ('C','I') AND (P_Course IS NULL AND P_Campus IS NULL AND P_Entry_month IS NULL AND P_Entry_year IS NULL AND P_Entry_point IS NULL)) THEN
632: P_return1 := 0;
633: igs_uc_transactions_pkg.insert_row (
634: x_mode => p_mode, --jchakrab modified for 4380412
635: x_rowid => lv_rowid,
636: x_uc_tran_id => l_uc_tran_id,
637: x_transaction_id => NULL,

Line 716: igs_uc_transactions_pkg.insert_row (

712: END IF;
713:
714: IF l_generate_tran = 'Y' THEN
715: P_return1 := 0;
716: igs_uc_transactions_pkg.insert_row (
717: x_mode => p_mode, --jchakrab modified for 4380412
718: x_rowid => lv_rowid,
719: x_uc_tran_id => l_uc_tran_id,
720: x_transaction_id => NULL,

Line 768: igs_uc_transactions_pkg.insert_row (

764: FETCH cur_find_RD INTO l_cnt;
765: CLOSE cur_find_RD;
766: IF l_cnt > 0 THEN
767: P_return1 := 0;
768: igs_uc_transactions_pkg.insert_row (
769: x_mode => p_mode, --jchakrab modified for 4380412
770: x_rowid => lv_rowid,
771: x_uc_tran_id => l_uc_tran_id,
772: x_transaction_id => NULL,

Line 852: igs_uc_transactions_pkg.insert_row (

848: END IF;
849:
850: IF l_generate_tran = 'Y' THEN
851: P_return1 := 0;
852: igs_uc_transactions_pkg.insert_row (
853: x_mode => p_mode, --jchakrab modified for 4380412
854: x_rowid => lv_rowid,
855: x_uc_tran_id => l_uc_tran_id,
856: x_transaction_id => NULL,

Line 904: igs_uc_transactions_pkg.insert_row (

900: AND p_system_code IS NOT NULL AND p_ucas_cycle IS NOT NULL THEN
901: IF P_Free_Format ='.R1' OR P_Free_Format = '.R2' OR P_Free_Format = '.R3'
902: OR P_Free_Format = '.R4' OR P_Free_Format = '.R5' OR P_Free_Format = '.R6' THEN
903: P_return1 := 0;
904: igs_uc_transactions_pkg.insert_row (
905: x_mode => p_mode, --jchakrab modified for 4380412
906: x_rowid => lv_rowid,
907: x_uc_tran_id => l_uc_tran_id,
908: x_transaction_id => NULL,

Line 955: igs_uc_transactions_pkg.insert_row (

951: CLOSE cur_app_choice_decision;
952:
953: IF l_decision = 'U' AND l_reply = 'F' THEN
954: P_return1 := 0;
955: igs_uc_transactions_pkg.insert_row (
956: x_mode => p_mode, --jchakrab modified for 4380412
957: x_rowid => lv_rowid,
958: x_uc_tran_id => l_uc_tran_id,
959: x_transaction_id => NULL,

Line 1011: igs_uc_transactions_pkg.insert_row (

1007: ELSE
1008: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');
1009: END IF;
1010:
1011: igs_uc_transactions_pkg.insert_row (
1012: x_mode => p_mode, --jchakrab modified for 4380412
1013: x_rowid => lv_rowid,
1014: x_uc_tran_id => l_uc_tran_id,
1015: x_transaction_id => NULL,

Line 1065: igs_uc_transactions_pkg.insert_row (

1061: CLOSE cur_find_trans;
1062:
1063: IF l_cnt > 0 THEN
1064: P_return1 := 0;
1065: igs_uc_transactions_pkg.insert_row (
1066: x_mode => p_mode, --jchakrab modified for 4380412
1067: x_rowid => lv_rowid,
1068: x_uc_tran_id => l_uc_tran_id,
1069: x_transaction_id => NULL,

Line 1111: igs_uc_transactions_pkg.update_row(

1107: OPEN c_transactions(l_uc_tran_id);
1108: FETCH c_transactions INTO l_transactions;
1109: CLOSE c_transactions;
1110:
1111: igs_uc_transactions_pkg.update_row(
1112: x_rowid => l_transactions.rowid,
1113: x_uc_tran_id => l_transactions.uc_tran_id,
1114: x_transaction_id => l_transactions.transaction_id,
1115: x_datetimestamp => l_transactions.datetimestamp,

Line 1163: igs_uc_transactions_pkg.insert_row (

1159: IF P_Decision IN ('W','X') THEN
1160: IF P_Free_Format IS NOT NULL THEN
1161: P_return1 := 0;
1162:
1163: igs_uc_transactions_pkg.insert_row (
1164: x_mode => p_mode, --jchakrab modified for 4380412
1165: x_rowid => lv_rowid,
1166: x_uc_tran_id => l_uc_tran_id,
1167: x_transaction_id => NULL,

Line 1209: igs_uc_transactions_pkg.update_row(

1205: OPEN c_transactions(l_uc_tran_id);
1206: FETCH c_transactions INTO l_transactions;
1207: CLOSE c_transactions;
1208:
1209: igs_uc_transactions_pkg.update_row(
1210: x_rowid => l_transactions.rowid,
1211: x_uc_tran_id => l_transactions.uc_tran_id,
1212: x_transaction_id => l_transactions.transaction_id,
1213: x_datetimestamp => l_transactions.datetimestamp,

Line 1276: igs_uc_transactions_pkg.insert_row (

1272: ELSE
1273: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');
1274: END IF;
1275:
1276: igs_uc_transactions_pkg.insert_row (
1277: x_mode => p_mode, --jchakrab modified for 4380412
1278: x_rowid => lv_rowid,
1279: x_uc_tran_id => l_uc_tran_id,
1280: x_transaction_id => NULL,

Line 1442: 1) added new column auto_generated_flag to tbh calls to igs_uc_transactions_pkg

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
1445: fields with proper values rather than with NULL
1446: ayedubat 05-DEC-2002 Changed the Log file generations of transactions being processed in the current run for bug: 2462078

Line 1556: igs_uc_transactions_pkg.update_row (

1552: ELSE
1553: l_soc:=uc_transaction_rec.SOC;
1554: END IF;
1555:
1556: igs_uc_transactions_pkg.update_row (
1557: x_mode => 'R',
1558: x_rowid => uc_transaction_rec.ROWID,
1559: x_uc_tran_id => uc_transaction_rec.UC_Tran_Id,
1560: x_transaction_id => tranin_rec.transactionid,

Line 1845: igs_uc_transactions_pkg.update_row (

1841: ELSE
1842: l_soc:=uc_transaction_rec.SOC;
1843: END IF;
1844:
1845: igs_uc_transactions_pkg.update_row (
1846: x_mode => 'R',
1847: x_rowid => uc_transaction_rec.ROWID,
1848: x_uc_tran_id => uc_transaction_rec.UC_Tran_Id,
1849: x_transaction_id => tranin_rec.transactionid,