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_DA_XML_PKG dependencies on IGS_DA_REQ_STDNTS

Line 955: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,

951:
952: END;
953:
954: PROCEDURE update_stdnts_err (
955: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
956: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
957: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
958: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
959: p_error_code IN igs_da_req_stdnts.error_code%TYPE,

Line 958: p_report_text IN igs_da_req_stdnts.report_text%TYPE,

954: PROCEDURE update_stdnts_err (
955: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
956: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
957: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
958: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
959: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
960: x_return_status OUT NOCOPY VARCHAR2
961: ) IS
962: l_err_msg_pos1 VARCHAR2(30);

Line 959: p_error_code IN igs_da_req_stdnts.error_code%TYPE,

955: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
956: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
957: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
958: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
959: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
960: x_return_status OUT NOCOPY VARCHAR2
961: ) IS
962: l_err_msg_pos1 VARCHAR2(30);
963: l_person_id hz_parties.party_id%TYPE;

Line 969: FROM igs_da_req_stdnts drs

965:
966:
967: CURSOR c1 IS
968: SELECT ROWID,drs.*
969: FROM igs_da_req_stdnts drs
970: WHERE drs.batch_id = p_batch_id
971: AND drs.person_id = l_person_id;
972:
973: l_found BOOLEAN := FALSE;

Line 983: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW

979: get_person_details (p_person_id_code,p_person_id_code_type,l_person_id,l_person_number);
980:
981: l_err_msg_pos1 := 'IGS_PROGRAM_ERROR C1';
982: FOR v_dummy IN c1 LOOP
983: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
984: (v_dummy.ROWID,
985: v_dummy.batch_id,
986: v_dummy.igs_da_req_stdnts_id,
987: v_dummy.person_id,

Line 986: v_dummy.igs_da_req_stdnts_id,

982: FOR v_dummy IN c1 LOOP
983: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
984: (v_dummy.ROWID,
985: v_dummy.batch_id,
986: v_dummy.igs_da_req_stdnts_id,
987: v_dummy.person_id,
988: v_dummy.program_code,
989: v_dummy.wif_program_code,
990: v_dummy.special_program_code,

Line 1029: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,

1025: END;
1026:
1027:
1028: PROCEDURE update_req_students (
1029: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1030: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1031: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1032: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
1033: p_academicsubprogram_codes IN VARCHAR2,

Line 1032: p_report_text IN igs_da_req_stdnts.report_text%TYPE,

1028: PROCEDURE update_req_students (
1029: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
1030: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1031: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1032: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
1033: p_academicsubprogram_codes IN VARCHAR2,
1034: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1035: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
1036: x_return_status OUT NOCOPY VARCHAR2

Line 1034: p_program_code IN igs_da_req_stdnts.program_code%TYPE,

1030: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1031: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1032: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
1033: p_academicsubprogram_codes IN VARCHAR2,
1034: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1035: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
1036: x_return_status OUT NOCOPY VARCHAR2
1037: ) IS
1038:

Line 1035: p_error_code IN igs_da_req_stdnts.error_code%TYPE,

1031: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1032: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
1033: p_academicsubprogram_codes IN VARCHAR2,
1034: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1035: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
1036: x_return_status OUT NOCOPY VARCHAR2
1037: ) IS
1038:
1039: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REQ_STUDENTS';

Line 1064: FROM igs_da_req_stdnts drs

1060: WHERE ds.s_control_num = 1;
1061:
1062: CURSOR c1 IS
1063: SELECT ROWID,drs.*
1064: FROM igs_da_req_stdnts drs
1065: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1066: AND drs.person_id = l_person_id
1067: AND drs.program_major_code = RTRIM(LTRIM(p_program_code));
1068:

Line 1071: FROM igs_da_req_stdnts drs

1067: AND drs.program_major_code = RTRIM(LTRIM(p_program_code));
1068:
1069: CURSOR c2 IS
1070: SELECT ROWID,drs.*
1071: FROM igs_da_req_stdnts drs
1072: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1073: AND drs.person_id = l_person_id
1074: AND drs.program_major_code = RTRIM(LTRIM(p_program_code))
1075: AND EXISTS (SELECT 'X'

Line 1102: FROM igs_da_req_stdnts drs

1098: OR drw.track_unit_set_cd1 IS NULL));
1099:
1100: CURSOR c3 IS
1101: SELECT ROWID,drs.*
1102: FROM igs_da_req_stdnts drs
1103: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1104: AND drs.person_id = l_person_id
1105: AND drs.program_code = RTRIM(LTRIM(p_program_code));
1106:

Line 1109: FROM igs_da_req_stdnts drs

1105: AND drs.program_code = RTRIM(LTRIM(p_program_code));
1106:
1107: CURSOR c4 IS
1108: SELECT ROWID,drs.*
1109: FROM igs_da_req_stdnts drs
1110: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1111: AND drs.person_id = l_person_id
1112: AND drs.special_program_code = RTRIM(LTRIM(p_program_code));
1113:

Line 1116: FROM igs_da_req_stdnts drs

1112: AND drs.special_program_code = RTRIM(LTRIM(p_program_code));
1113:
1114: CURSOR c5 IS
1115: SELECT ROWID,drs.*
1116: FROM igs_da_req_stdnts drs
1117: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1118: AND drs.person_id = l_person_id
1119: AND drs.wif_program_code = RTRIM(LTRIM(p_program_code))
1120: AND exists (SELECT 'X'

Line 1193: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW

1189:
1190: IF (l_progmajor_ind = 'Y' ) THEN
1191: IF ((l_prog_comparison_type ='DP') OR (l_prog_comparison_type ='SP')) THEN
1192: FOR v_dummy IN c1 LOOP
1193: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1194: (v_dummy.ROWID,
1195: v_dummy.batch_id,
1196: v_dummy.igs_da_req_stdnts_id,
1197: v_dummy.person_id,

Line 1196: v_dummy.igs_da_req_stdnts_id,

1192: FOR v_dummy IN c1 LOOP
1193: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1194: (v_dummy.ROWID,
1195: v_dummy.batch_id,
1196: v_dummy.igs_da_req_stdnts_id,
1197: v_dummy.person_id,
1198: v_dummy.program_code,
1199: v_dummy.wif_program_code,
1200: v_dummy.special_program_code,

Line 1211: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW

1207: l_found := TRUE;
1208: END LOOP;
1209: ELSIF (l_prog_comparison_type ='WIF') THEN
1210: FOR v_dummy IN c2 LOOP
1211: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1212: (v_dummy.ROWID,
1213: v_dummy.batch_id,
1214: v_dummy.igs_da_req_stdnts_id,
1215: v_dummy.person_id,

Line 1214: v_dummy.igs_da_req_stdnts_id,

1210: FOR v_dummy IN c2 LOOP
1211: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1212: (v_dummy.ROWID,
1213: v_dummy.batch_id,
1214: v_dummy.igs_da_req_stdnts_id,
1215: v_dummy.person_id,
1216: v_dummy.program_code,
1217: v_dummy.wif_program_code,
1218: v_dummy.special_program_code,

Line 1231: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW

1227: END IF;
1228: ELSE
1229: IF (l_prog_comparison_type ='DP') THEN
1230: FOR v_dummy IN c3 LOOP
1231: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1232: (v_dummy.ROWID,
1233: v_dummy.batch_id,
1234: v_dummy.igs_da_req_stdnts_id,
1235: v_dummy.person_id,

Line 1234: v_dummy.igs_da_req_stdnts_id,

1230: FOR v_dummy IN c3 LOOP
1231: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1232: (v_dummy.ROWID,
1233: v_dummy.batch_id,
1234: v_dummy.igs_da_req_stdnts_id,
1235: v_dummy.person_id,
1236: v_dummy.program_code,
1237: v_dummy.wif_program_code,
1238: v_dummy.special_program_code,

Line 1249: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW

1245: l_found := TRUE;
1246: END LOOP;
1247: ELSIF (l_prog_comparison_type ='SP') THEN
1248: FOR v_dummy IN c4 LOOP
1249: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1250: (v_dummy.ROWID,
1251: v_dummy.batch_id,
1252: v_dummy.igs_da_req_stdnts_id,
1253: v_dummy.person_id,

Line 1252: v_dummy.igs_da_req_stdnts_id,

1248: FOR v_dummy IN c4 LOOP
1249: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1250: (v_dummy.ROWID,
1251: v_dummy.batch_id,
1252: v_dummy.igs_da_req_stdnts_id,
1253: v_dummy.person_id,
1254: v_dummy.program_code,
1255: v_dummy.wif_program_code,
1256: v_dummy.special_program_code,

Line 1267: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW

1263: l_found := TRUE;
1264: END LOOP;
1265: ELSIF (l_prog_comparison_type ='WIF') THEN
1266: FOR v_dummy IN c5 LOOP
1267: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1268: (v_dummy.ROWID,
1269: v_dummy.batch_id,
1270: v_dummy.igs_da_req_stdnts_id,
1271: v_dummy.person_id,

Line 1270: v_dummy.igs_da_req_stdnts_id,

1266: FOR v_dummy IN c5 LOOP
1267: IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW
1268: (v_dummy.ROWID,
1269: v_dummy.batch_id,
1270: v_dummy.igs_da_req_stdnts_id,
1271: v_dummy.person_id,
1272: v_dummy.program_code,
1273: v_dummy.wif_program_code,
1274: v_dummy.special_program_code,

Line 1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,

1314: (
1315: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
1316: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1317: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1318: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1319: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
1320: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
1321: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
1322: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,

Line 1337: FROM igs_da_req_stdnts drs

1333: l_program_code igs_pr_stu_acad_stat_int.course_cd%TYPE;
1334:
1335: CURSOR c1 IS
1336: SELECT drs.program_code
1337: FROM igs_da_req_stdnts drs
1338: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1339: AND drs.person_id = l_person_id
1340: AND ((drs.program_major_code = RTRIM(LTRIM(p_program_code))) OR (drs.program_code = RTRIM(LTRIM(p_program_code))));
1341:

Line 1409: p_program_code IN igs_da_req_stdnts.program_code%TYPE,

1405: (
1406: p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,
1407: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1408: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
1409: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
1410: p_program_complete IN VARCHAR2,
1411: p_program_complete_date IN VARCHAR2,
1412: x_return_status OUT NOCOPY VARCHAR2
1413: ) IS

Line 1422: FROM igs_da_req_stdnts drs

1418: l_program_code igs_pr_spa_complete_int.course_cd%TYPE;
1419:
1420: CURSOR c1 IS
1421: SELECT drs.program_code
1422: FROM igs_da_req_stdnts drs
1423: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1424: AND drs.person_id = l_person_id
1425: AND ((drs.program_major_code = RTRIM(LTRIM(p_program_code))) OR (drs.program_code = RTRIM(LTRIM(p_program_code))));
1426:

Line 1476: p_batch_id IN IGS_DA_REQ_STDNTS.BATCH_ID%TYPE

1472: END;
1473:
1474: /*****************************************************************/
1475: PROCEDURE Submit_Event (
1476: p_batch_id IN IGS_DA_REQ_STDNTS.BATCH_ID%TYPE
1477: )
1478: IS
1479:
1480: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

Line 1491: l_doc_id IGS_DA_REQ_STDNTS.BATCH_ID%TYPE;

1487: l_party_type VARCHAR2(30) :='C';
1488: l_debug_level NUMBER := 0;
1489: l_wif NUMBER := 0;
1490: l_count NUMBER := 0;
1491: l_doc_id IGS_DA_REQ_STDNTS.BATCH_ID%TYPE;
1492: l_batch_profile VARCHAR2(1) := 'N';
1493:
1494: CURSOR c_student IS
1495: SELECT drs.person_id

Line 1496: FROM igs_da_req_stdnts drs

1492: l_batch_profile VARCHAR2(1) := 'N';
1493:
1494: CURSOR c_student IS
1495: SELECT drs.person_id
1496: FROM igs_da_req_stdnts drs
1497: WHERE drs.batch_id = p_batch_id;
1498:
1499:
1500: CURSOR c_party_data IS

Line 1545: FROM igs_da_req_stdnts drs

1541: /******************************************************************************/
1542:
1543: CURSOR c_wif IS
1544: SELECT count(drs.wif_program_code)
1545: FROM igs_da_req_stdnts drs
1546: WHERE drs.batch_id = p_batch_id
1547: AND wif_program_code is not null;
1548:
1549: CURSOR c_transaction_wif_data IS

Line 1688: (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE

1684: END;
1685: /*****************************************************************************************/
1686:
1687: PROCEDURE process_reply_failure
1688: (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE
1689: ) IS
1690: l_da_wf_admin_id fnd_profile_options.profile_option_name%TYPE := FND_PROFILE.VALUE('IGS_DA_WF_ADMIN');
1691: CURSOR c_request_status IS
1692: SELECT 'X'

Line 1758: (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE

1754: ecx_debug.pop('IGS_DA_XML_PKG.PROCESS_REPLY_FAILURE');
1755: END;
1756:
1757: PROCEDURE update_request_status
1758: (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE
1759: ) IS
1760: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REQUEST_STATUS' ;
1761: l_request_status VARCHAR2(30) := 'SUBMITTED';
1762: l_RETURN_STATUS VARCHAR2(10);

Line 1782: from igs_da_req_stdnts

1778: -- Get the current error count of students that failed in the pre-processing and could not make it in the Request XML Document
1779: -- of the selected batch_id
1780: select count(*)
1781: into l_request_err_count
1782: from igs_da_req_stdnts
1783: where batch_id = p_batch_id
1784: and error_code ='PRE- SUBMISSION FAILURE';
1785:
1786: -- Get the current error count of students that failed with the a element in the ReplyXML

Line 1792: from igs_da_req_stdnts

1788: -- need to be changed for NLS
1789: -- need to add 'REPLY_ERROR' to IGS_LOOKUP_VALUES.
1790: select count(*)
1791: into l_reply_err_count
1792: from igs_da_req_stdnts
1793: where batch_id = p_batch_id
1794: and error_code ='REPLY_ERROR';
1795:
1796: -- Get the current count of students not containing reports

Line 1800: from igs_da_req_stdnts

1796: -- Get the current count of students not containing reports
1797: -- in the selected batch_id
1798: select count(*)
1799: into l_noClob_count
1800: from igs_da_req_stdnts
1801: where batch_id = p_batch_id
1802: and report_text is null;
1803:
1804: -- Get the current count of students containing reports

Line 1808: from igs_da_req_stdnts

1804: -- Get the current count of students containing reports
1805: -- in the selected batch_id
1806: select count(*)
1807: into l_clob_count
1808: from igs_da_req_stdnts
1809: where batch_id = p_batch_id
1810: and report_text is not null;
1811:
1812: --Set the current Status of the batch requst.

Line 1844: PROCEDURE launch_notify_err_wf (p_batch_id igs_da_req_stdnts.batch_id%TYPE) IS

1840: RAISE ;
1841:
1842: END;
1843:
1844: PROCEDURE launch_notify_err_wf (p_batch_id igs_da_req_stdnts.batch_id%TYPE) IS
1845: l_item_key VARCHAR2(100);
1846: -- cursor to find the requestor
1847: CURSOR c_req (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
1848: SELECT user_name

Line 1884: PROCEDURE pre_submit_event (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE) IS

1880: WF_CORE.Context('IGS_DA_XML_PKG','launch_notify_err_wf',l_item_key);
1881: RAISE;
1882: END launch_notify_err_wf;
1883:
1884: PROCEDURE pre_submit_event (p_batch_id IN igs_da_req_stdnts.batch_id%TYPE) IS
1885: /*
1886: This procedure filters out the erroroneous record from the batch and show
1887: the error message through the html report. It can happen that in a batch id,
1888: which is having more than 1 students and 1 student's record fails to meet the

Line 1894: CURSOR c_list_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,

1890: no call to submit_event, which generates the XML Message will be made.
1891: */
1892:
1893: -- cursor to fetch the list of person_id in the given batch_id
1894: CURSOR c_list_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1895: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1896: SELECT person_id, igs_da_req_stdnts_id
1897: FROM igs_da_req_stdnts
1898: WHERE batch_id = cp_batch_id

Line 1895: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS

1891: */
1892:
1893: -- cursor to fetch the list of person_id in the given batch_id
1894: CURSOR c_list_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1895: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1896: SELECT person_id, igs_da_req_stdnts_id
1897: FROM igs_da_req_stdnts
1898: WHERE batch_id = cp_batch_id
1899: AND igs_da_req_stdnts_id=cp_igs_da_req_stdnts_id;

Line 1896: SELECT person_id, igs_da_req_stdnts_id

1892:
1893: -- cursor to fetch the list of person_id in the given batch_id
1894: CURSOR c_list_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1895: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1896: SELECT person_id, igs_da_req_stdnts_id
1897: FROM igs_da_req_stdnts
1898: WHERE batch_id = cp_batch_id
1899: AND igs_da_req_stdnts_id=cp_igs_da_req_stdnts_id;
1900:

Line 1897: FROM igs_da_req_stdnts

1893: -- cursor to fetch the list of person_id in the given batch_id
1894: CURSOR c_list_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1895: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1896: SELECT person_id, igs_da_req_stdnts_id
1897: FROM igs_da_req_stdnts
1898: WHERE batch_id = cp_batch_id
1899: AND igs_da_req_stdnts_id=cp_igs_da_req_stdnts_id;
1900:
1901: -- curosr to count the person_id in the batch_id

Line 1899: AND igs_da_req_stdnts_id=cp_igs_da_req_stdnts_id;

1895: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1896: SELECT person_id, igs_da_req_stdnts_id
1897: FROM igs_da_req_stdnts
1898: WHERE batch_id = cp_batch_id
1899: AND igs_da_req_stdnts_id=cp_igs_da_req_stdnts_id;
1900:
1901: -- curosr to count the person_id in the batch_id
1902: CURSOR c_count_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS
1903: SELECT count(*)

Line 1902: CURSOR c_count_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS

1898: WHERE batch_id = cp_batch_id
1899: AND igs_da_req_stdnts_id=cp_igs_da_req_stdnts_id;
1900:
1901: -- curosr to count the person_id in the batch_id
1902: CURSOR c_count_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS
1903: SELECT count(*)
1904: FROM igs_da_req_stdnts
1905: WHERE batch_id = cp_batch_id;
1906:

Line 1904: FROM igs_da_req_stdnts

1900:
1901: -- curosr to count the person_id in the batch_id
1902: CURSOR c_count_person_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS
1903: SELECT count(*)
1904: FROM igs_da_req_stdnts
1905: WHERE batch_id = cp_batch_id;
1906:
1907: l_count_person_id NUMBER;
1908:

Line 1910: CURSOR c_person_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,

1906:
1907: l_count_person_id NUMBER;
1908:
1909: -- cursor to validate the record from the view IGS_DA_XML_PERSON_V
1910: CURSOR c_person_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1911: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1912: SELECT person_code_qualifier,
1913: person_id_code,
1914: name_type,

Line 1911: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS

1907: l_count_person_id NUMBER;
1908:
1909: -- cursor to validate the record from the view IGS_DA_XML_PERSON_V
1910: CURSOR c_person_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1911: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1912: SELECT person_code_qualifier,
1913: person_id_code,
1914: name_type,
1915: name_first,

Line 1925: CURSOR c_degprg_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,

1921: -- cursor to validate the record from the view IGS_DA_XML_DEGREEPROGRAM_V
1922: /* removing this chech as igs_da_xml_degreeprogram_v has three cols only and
1923: all of them are not null
1924:
1925: CURSOR c_degprg_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1926: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1927: SELECT institution_cd
1928: FROM igs_da_xml_degreeprogram_v
1929: WHERE batch_id = cp_batch_id

Line 1926: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS

1922: /* removing this chech as igs_da_xml_degreeprogram_v has three cols only and
1923: all of them are not null
1924:
1925: CURSOR c_degprg_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1926: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1927: SELECT institution_cd
1928: FROM igs_da_xml_degreeprogram_v
1929: WHERE batch_id = cp_batch_id
1930: AND person_id = cp_person_id;

Line 1933: CURSOR c_acadprg_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,

1929: WHERE batch_id = cp_batch_id
1930: AND person_id = cp_person_id;
1931: */
1932: -- cursor to validate the record from the view IGS_DA_XML_ACADEMICPROGRAM_V
1933: CURSOR c_acadprg_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1934: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1935: SELECT program_type,
1936: program_code,
1937: program_catalog_year

Line 1934: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS

1930: AND person_id = cp_person_id;
1931: */
1932: -- cursor to validate the record from the view IGS_DA_XML_ACADEMICPROGRAM_V
1933: CURSOR c_acadprg_v (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1934: cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1935: SELECT program_type,
1936: program_code,
1937: program_catalog_year
1938: FROM igs_da_xml_academicprogram_v

Line 1942: -- cursor to update igs_da_req_stdnts

1938: FROM igs_da_xml_academicprogram_v
1939: WHERE batch_id = cp_batch_id
1940: AND person_id = cp_person_id;
1941:
1942: -- cursor to update igs_da_req_stdnts
1943: CURSOR c_req_stdnts (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1944: cp_person_id igs_da_req_stdnts.person_id%TYPE,
1945: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1946: SELECT rowid, a.*

Line 1943: CURSOR c_req_stdnts (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,

1939: WHERE batch_id = cp_batch_id
1940: AND person_id = cp_person_id;
1941:
1942: -- cursor to update igs_da_req_stdnts
1943: CURSOR c_req_stdnts (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1944: cp_person_id igs_da_req_stdnts.person_id%TYPE,
1945: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1946: SELECT rowid, a.*
1947: FROM igs_da_req_stdnts a

Line 1944: cp_person_id igs_da_req_stdnts.person_id%TYPE,

1940: AND person_id = cp_person_id;
1941:
1942: -- cursor to update igs_da_req_stdnts
1943: CURSOR c_req_stdnts (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1944: cp_person_id igs_da_req_stdnts.person_id%TYPE,
1945: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1946: SELECT rowid, a.*
1947: FROM igs_da_req_stdnts a
1948: WHERE batch_id = cp_batch_id

Line 1945: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS

1941:
1942: -- cursor to update igs_da_req_stdnts
1943: CURSOR c_req_stdnts (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1944: cp_person_id igs_da_req_stdnts.person_id%TYPE,
1945: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1946: SELECT rowid, a.*
1947: FROM igs_da_req_stdnts a
1948: WHERE batch_id = cp_batch_id
1949: AND person_id = cp_person_id

Line 1947: FROM igs_da_req_stdnts a

1943: CURSOR c_req_stdnts (cp_batch_id igs_da_req_stdnts.batch_id%TYPE,
1944: cp_person_id igs_da_req_stdnts.person_id%TYPE,
1945: cp_igs_da_req_stdnts_id igs_da_req_stdnts.igs_da_req_stdnts_id%TYPE) IS
1946: SELECT rowid, a.*
1947: FROM igs_da_req_stdnts a
1948: WHERE batch_id = cp_batch_id
1949: AND person_id = cp_person_id
1950: AND igs_da_req_stdnts_id = cp_igs_da_req_stdnts_id;
1951:

Line 1950: AND igs_da_req_stdnts_id = cp_igs_da_req_stdnts_id;

1946: SELECT rowid, a.*
1947: FROM igs_da_req_stdnts a
1948: WHERE batch_id = cp_batch_id
1949: AND person_id = cp_person_id
1950: AND igs_da_req_stdnts_id = cp_igs_da_req_stdnts_id;
1951:
1952: -- cursor to run for each req_stdnts_id
1953: CURSOR c_req_stdnts_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS
1954: SELECT igs_da_req_stdnts_id

Line 1953: CURSOR c_req_stdnts_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS

1949: AND person_id = cp_person_id
1950: AND igs_da_req_stdnts_id = cp_igs_da_req_stdnts_id;
1951:
1952: -- cursor to run for each req_stdnts_id
1953: CURSOR c_req_stdnts_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS
1954: SELECT igs_da_req_stdnts_id
1955: FROM igs_da_req_stdnts
1956: WHERE batch_id = cp_batch_id;
1957: ctr_tbl NUMBER;

Line 1954: SELECT igs_da_req_stdnts_id

1950: AND igs_da_req_stdnts_id = cp_igs_da_req_stdnts_id;
1951:
1952: -- cursor to run for each req_stdnts_id
1953: CURSOR c_req_stdnts_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS
1954: SELECT igs_da_req_stdnts_id
1955: FROM igs_da_req_stdnts
1956: WHERE batch_id = cp_batch_id;
1957: ctr_tbl NUMBER;
1958: pid_exists VARCHAR2(1);

Line 1955: FROM igs_da_req_stdnts

1951:
1952: -- cursor to run for each req_stdnts_id
1953: CURSOR c_req_stdnts_id (cp_batch_id igs_da_req_stdnts.batch_id%TYPE) IS
1954: SELECT igs_da_req_stdnts_id
1955: FROM igs_da_req_stdnts
1956: WHERE batch_id = cp_batch_id;
1957: ctr_tbl NUMBER;
1958: pid_exists VARCHAR2(1);
1959: v_report_text VARCHAR2(4000);

Line 1972: FUNCTION get_person (pp_person_id igs_da_req_stdnts.person_id%TYPE) RETURN VARCHAR2 IS

1968: -- need to be changed for NLS
1969: -- needt to add 'PRE-SUBMISSION FAILURE' to IGS_LOOKUP_VALUES.
1970: l_error_code VARCHAR2(30) := 'PRE- SUBMISSION FAILURE';
1971:
1972: FUNCTION get_person (pp_person_id igs_da_req_stdnts.person_id%TYPE) RETURN VARCHAR2 IS
1973: CURSOR c_get_pers (cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1974: SELECT party_name||' ('||party_number||') '
1975: FROM hz_parties
1976: WHERE party_id = cp_person_id;

Line 1973: CURSOR c_get_pers (cp_person_id igs_da_req_stdnts.person_id%TYPE) IS

1969: -- needt to add 'PRE-SUBMISSION FAILURE' to IGS_LOOKUP_VALUES.
1970: l_error_code VARCHAR2(30) := 'PRE- SUBMISSION FAILURE';
1971:
1972: FUNCTION get_person (pp_person_id igs_da_req_stdnts.person_id%TYPE) RETURN VARCHAR2 IS
1973: CURSOR c_get_pers (cp_person_id igs_da_req_stdnts.person_id%TYPE) IS
1974: SELECT party_name||' ('||party_number||') '
1975: FROM hz_parties
1976: WHERE party_id = cp_person_id;
1977: v_get_pers VARCHAR2(4000);

Line 2007: FOR rec_list_person_id IN c_list_person_id(p_batch_id,rec_req_stdnts_id.igs_da_req_stdnts_id)

2003: -- loop through the list of person id in the given batch
2004: -- to identify the missing attribute
2005: FOR rec_req_stdnts_id IN c_req_stdnts_id(p_batch_id)
2006: LOOP
2007: FOR rec_list_person_id IN c_list_person_id(p_batch_id,rec_req_stdnts_id.igs_da_req_stdnts_id)
2008: LOOP
2009: -- check whether PersonIdCodeQualifier, PersonIdCode
2010: -- NameType, NameFirst, NameLast exist for the person id or not
2011: FOR rec_person_v IN c_person_v (p_batch_id,rec_list_person_id.person_id)

Line 2088: UPDATE igs_da_req_stdnts

2084: IF v_report_text IS NOT NULL THEN
2085: v_report_text := ' Error Report

'||v_report_text||' '|| ' ';
2086: END IF;
2087: IF v_report_text IS NOT NULL THEN
2088: UPDATE igs_da_req_stdnts
2089: SET report_text = v_report_text,
2090: -- bug fix 3438386 - update error code for internal request failues.
2091: error_code = l_error_code
2092: WHERE batch_id = p_batch_id

Line 2094: AND igs_da_req_stdnts_id = rec_req_stdnts_id.igs_da_req_stdnts_id;

2090: -- bug fix 3438386 - update error code for internal request failues.
2091: error_code = l_error_code
2092: WHERE batch_id = p_batch_id
2093: AND person_id = rec_list_person_id.person_id
2094: AND igs_da_req_stdnts_id = rec_req_stdnts_id.igs_da_req_stdnts_id;
2095: END IF;
2096: /*
2097: igs_da_req_stdnts_pkg.update_row (
2098: X_ROWID => rec_req_stdnts.ROWID,

Line 2097: igs_da_req_stdnts_pkg.update_row (

2093: AND person_id = rec_list_person_id.person_id
2094: AND igs_da_req_stdnts_id = rec_req_stdnts_id.igs_da_req_stdnts_id;
2095: END IF;
2096: /*
2097: igs_da_req_stdnts_pkg.update_row (
2098: X_ROWID => rec_req_stdnts.ROWID,
2099: X_BATCH_ID => rec_req_stdnts.batch_id,
2100: X_IGS_DA_REQ_STDNTS_ID => rec_req_stdnts.igs_da_req_stdnts_id,
2101: X_PERSON_ID => rec_req_stdnts.person_id,

Line 2100: X_IGS_DA_REQ_STDNTS_ID => rec_req_stdnts.igs_da_req_stdnts_id,

2096: /*
2097: igs_da_req_stdnts_pkg.update_row (
2098: X_ROWID => rec_req_stdnts.ROWID,
2099: X_BATCH_ID => rec_req_stdnts.batch_id,
2100: X_IGS_DA_REQ_STDNTS_ID => rec_req_stdnts.igs_da_req_stdnts_id,
2101: X_PERSON_ID => rec_req_stdnts.person_id,
2102: X_PROGRAM_CODE => rec_req_stdnts.program_code,
2103: X_WIF_PROGRAM_CODE => rec_req_stdnts.wif_program_code,
2104: X_SPECIAL_PROGRAM_CODE => rec_req_stdnts.special_program_code,

Line 2122: END LOOP; -- FOR rec_list_person_id IN c_list_person_id(p_batch_id,rec_req_stdnts_id.igs_da_req_stdnts_id)

2118: l_name_last_exists :='N';
2119: l_prog_type_exists :='N';
2120: l_prog_code_exists :='N';
2121: l_prog_cat_exists :='N';
2122: END LOOP; -- FOR rec_list_person_id IN c_list_person_id(p_batch_id,rec_req_stdnts_id.igs_da_req_stdnts_id)
2123: END LOOP; -- FOR rec_req_stdnts_id IN c_req_stdnts_id(p_batch_id)
2124: /*
2125: now, check the count and directly call the
2126: submit_event else first launch the workflow to notify the error