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_PR_SPA_COMPLETE_INT

Line 1406: p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,

1402: END;
1403:
1404: PROCEDURE insert_program_completion
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,

Line 1418: l_program_code igs_pr_spa_complete_int.course_cd%TYPE;

1414:
1415: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_PROGRAM_COMPLETION';
1416: l_person_id hz_parties.party_id%TYPE;
1417: l_person_number hz_parties.party_number%TYPE;
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

Line 1438: INSERT INTO igs_pr_spa_complete_int

1434: l_program_code := v_dummy.program_code;
1435: END LOOP;
1436:
1437: IF ( RTRIM(LTRIM(p_program_complete)) ='true') THEN
1438: INSERT INTO igs_pr_spa_complete_int
1439: (BATCH_ID,
1440: PERSON_NUMBER,
1441: COURSE_CD,
1442: COMPLETE_DT,