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_MV_DATA_UPLD dependencies on IGS_UC_ISTRPQR_INTS

Line 1464: || replaced igs_uc_mv_ivstarpqr with igs_uc_istrpqr_ints

1460: || rbezawad 25-Sep-2002 Removed code which is populating IGS_UC_MV_IVQUAL.GNVQDATE as the column is obsoleted.
1461: || smaddali 29-jan-03 Enhanced processing for *P and *R transactions to populate subject_id and ebl_result as part of build UCCR005 , bug #2749404
1462: || rbezawad 25-Feb-03 Modified procedure transfer_to_starpqr for processing Previous results of an applicant upto maximum 21 sets w.r.t. Bug 2810932.
1463: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208
1464: || replaced igs_uc_mv_ivstarpqr with igs_uc_istrpqr_ints
1465: || smaddali 26-aug-03 Modified procedure for *P transaction , to populate grade1 and 2 fields instead of Grade field, for bug#3114629
1466: || smaddali 4-sep-03 Obsoleting existing 'N' records for bug#3122898
1467: */
1468:

Line 1469: ln_appno igs_uc_istrpqr_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));

1465: || smaddali 26-aug-03 Modified procedure for *P transaction , to populate grade1 and 2 fields instead of Grade field, for bug#3114629
1466: || smaddali 4-sep-03 Obsoleting existing 'N' records for bug#3122898
1467: */
1468:
1469: ln_appno igs_uc_istrpqr_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1470:
1471: -- smaddali added the declarations for bug# 2749404
1472: l_sitting igs_uc_istrpqr_ints.sitting%TYPE;
1473: l_grade1 igs_uc_istrpqr_ints.grade1%TYPE;

Line 1472: l_sitting igs_uc_istrpqr_ints.sitting%TYPE;

1468:
1469: ln_appno igs_uc_istrpqr_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1470:
1471: -- smaddali added the declarations for bug# 2749404
1472: l_sitting igs_uc_istrpqr_ints.sitting%TYPE;
1473: l_grade1 igs_uc_istrpqr_ints.grade1%TYPE;
1474: l_grade2 igs_uc_istrpqr_ints.grade2%TYPE;
1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;
1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;

Line 1473: l_grade1 igs_uc_istrpqr_ints.grade1%TYPE;

1469: ln_appno igs_uc_istrpqr_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1470:
1471: -- smaddali added the declarations for bug# 2749404
1472: l_sitting igs_uc_istrpqr_ints.sitting%TYPE;
1473: l_grade1 igs_uc_istrpqr_ints.grade1%TYPE;
1474: l_grade2 igs_uc_istrpqr_ints.grade2%TYPE;
1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;
1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;
1477: l_exam_board_code igs_uc_istrpqr_ints.examboard%TYPE;

Line 1474: l_grade2 igs_uc_istrpqr_ints.grade2%TYPE;

1470:
1471: -- smaddali added the declarations for bug# 2749404
1472: l_sitting igs_uc_istrpqr_ints.sitting%TYPE;
1473: l_grade1 igs_uc_istrpqr_ints.grade1%TYPE;
1474: l_grade2 igs_uc_istrpqr_ints.grade2%TYPE;
1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;
1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;
1477: l_exam_board_code igs_uc_istrpqr_ints.examboard%TYPE;
1478: l_year_date igs_uc_istrpqr_ints.yearofexam%TYPE ;

Line 1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;

1471: -- smaddali added the declarations for bug# 2749404
1472: l_sitting igs_uc_istrpqr_ints.sitting%TYPE;
1473: l_grade1 igs_uc_istrpqr_ints.grade1%TYPE;
1474: l_grade2 igs_uc_istrpqr_ints.grade2%TYPE;
1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;
1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;
1477: l_exam_board_code igs_uc_istrpqr_ints.examboard%TYPE;
1478: l_year_date igs_uc_istrpqr_ints.yearofexam%TYPE ;
1479: l_lending_board igs_uc_istrpqr_ints.lendingboard%TYPE ;

Line 1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;

1472: l_sitting igs_uc_istrpqr_ints.sitting%TYPE;
1473: l_grade1 igs_uc_istrpqr_ints.grade1%TYPE;
1474: l_grade2 igs_uc_istrpqr_ints.grade2%TYPE;
1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;
1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;
1477: l_exam_board_code igs_uc_istrpqr_ints.examboard%TYPE;
1478: l_year_date igs_uc_istrpqr_ints.yearofexam%TYPE ;
1479: l_lending_board igs_uc_istrpqr_ints.lendingboard%TYPE ;
1480: l_pr_start_pos NUMBER;

Line 1477: l_exam_board_code igs_uc_istrpqr_ints.examboard%TYPE;

1473: l_grade1 igs_uc_istrpqr_ints.grade1%TYPE;
1474: l_grade2 igs_uc_istrpqr_ints.grade2%TYPE;
1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;
1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;
1477: l_exam_board_code igs_uc_istrpqr_ints.examboard%TYPE;
1478: l_year_date igs_uc_istrpqr_ints.yearofexam%TYPE ;
1479: l_lending_board igs_uc_istrpqr_ints.lendingboard%TYPE ;
1480: l_pr_start_pos NUMBER;
1481: -- end of change by smaddali for bug#2749404

Line 1478: l_year_date igs_uc_istrpqr_ints.yearofexam%TYPE ;

1474: l_grade2 igs_uc_istrpqr_ints.grade2%TYPE;
1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;
1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;
1477: l_exam_board_code igs_uc_istrpqr_ints.examboard%TYPE;
1478: l_year_date igs_uc_istrpqr_ints.yearofexam%TYPE ;
1479: l_lending_board igs_uc_istrpqr_ints.lendingboard%TYPE ;
1480: l_pr_start_pos NUMBER;
1481: -- end of change by smaddali for bug#2749404
1482:

Line 1479: l_lending_board igs_uc_istrpqr_ints.lendingboard%TYPE ;

1475: l_ebl_code igs_uc_istrpqr_ints.eblsubject%TYPE ;
1476: l_matchind igs_uc_istrpqr_ints.matchind%TYPE := TRIM(SUBSTR(p_record_data,17,1)) ;
1477: l_exam_board_code igs_uc_istrpqr_ints.examboard%TYPE;
1478: l_year_date igs_uc_istrpqr_ints.yearofexam%TYPE ;
1479: l_lending_board igs_uc_istrpqr_ints.lendingboard%TYPE ;
1480: l_pr_start_pos NUMBER;
1481: -- end of change by smaddali for bug#2749404
1482:
1483:

Line 1493: UPDATE igs_uc_istrpqr_ints SET record_status = 'D'

1489: fnd_file.put_line( fnd_file.log, fnd_message.get());
1490:
1491: -- update all records in interface table for the current applicant ,marvin type with status L
1492: -- to status D,i.e processed for this applicant
1493: UPDATE igs_uc_istrpqr_ints SET record_status = 'D'
1494: WHERE record_status = 'L' AND appno = ln_appno
1495: AND marvin_type = SUBSTR(p_trans_type,2,1) ;
1496:
1497: -- update all records in interface table for the current applicant, marvin type with status N

Line 1499: UPDATE igs_uc_istrpqr_ints SET record_status = 'O' , error_code = NULL

1495: AND marvin_type = SUBSTR(p_trans_type,2,1) ;
1496:
1497: -- update all records in interface table for the current applicant, marvin type with status N
1498: -- to status O,i.e obsolete for this applicant
1499: UPDATE igs_uc_istrpqr_ints SET record_status = 'O' , error_code = NULL
1500: WHERE record_status = 'N' AND appno = ln_appno
1501: AND marvin_type = SUBSTR(p_trans_type,2,1) ;
1502:
1503: -- reinstate records with status L of the other marvin type for this applicant

Line 1506: UPDATE igs_uc_istrpqr_ints SET record_status = 'N'

1502:
1503: -- reinstate records with status L of the other marvin type for this applicant
1504: IF p_trans_type = '*R' THEN
1505: -- set matching records in interface table with status L to N
1506: UPDATE igs_uc_istrpqr_ints SET record_status = 'N'
1507: WHERE record_status = 'L' AND appno = ln_appno
1508: AND marvin_type = 'P' ;
1509: ELSIF p_trans_type = '*P' THEN
1510: -- set matching records in interface table with status L to N

Line 1511: UPDATE igs_uc_istrpqr_ints SET record_status = 'N'

1507: WHERE record_status = 'L' AND appno = ln_appno
1508: AND marvin_type = 'P' ;
1509: ELSIF p_trans_type = '*P' THEN
1510: -- set matching records in interface table with status L to N
1511: UPDATE igs_uc_istrpqr_ints SET record_status = 'N'
1512: WHERE record_status = 'L' AND appno = ln_appno
1513: AND marvin_type = 'R';
1514: END IF ;
1515:

Line 1520: -- and insert previous results data into igs_uc_istrpqr_ints table.

1516: --Assign the Previous Result details starting location.
1517: l_pr_start_pos := 18;
1518:
1519: --To loop through the maximum 21 sets of previous results i.e., from 18 to 227 positions
1520: -- and insert previous results data into igs_uc_istrpqr_ints table.
1521: WHILE TRIM(SUBSTR(p_record_data,l_pr_start_pos,2)) IS NOT NULL AND l_pr_start_pos <= 218 LOOP
1522: -- extract field values
1523: l_year_date := LPAD(TRIM(SUBSTR(p_record_data,l_pr_start_pos,2)),2,'0') ;
1524: l_sitting := TRIM(SUBSTR(p_record_data,(l_pr_start_pos+2),1)) ; --Extracts String from Position 20

Line 1539: UPDATE igs_uc_istrpqr_ints SET record_status = 'O'

1535: l_lending_board := TRIM(SUBSTR(p_record_data,(l_pr_start_pos+9),1)) ;
1536: END IF ; -- end of *p/*r transaction
1537:
1538: -- Obsolete matching records in interface table with status N
1539: UPDATE igs_uc_istrpqr_ints SET record_status = 'O'
1540: WHERE record_status = 'N' AND appno = ln_appno
1541: AND yearofexam = l_year_date AND sitting = l_sitting
1542: AND examboard = l_exam_board_code AND eblsubject = l_ebl_code ;
1543:

Line 1544: INSERT INTO igs_uc_istrpqr_ints(

1540: WHERE record_status = 'N' AND appno = ln_appno
1541: AND yearofexam = l_year_date AND sitting = l_sitting
1542: AND examboard = l_exam_board_code AND eblsubject = l_ebl_code ;
1543:
1544: INSERT INTO igs_uc_istrpqr_ints(
1545: appno,
1546: subjectid,
1547: eblresult,
1548: eblamended,