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_AD_SS_GEN_001 dependencies on IGS_SS_APPL_PERSTAT

Line 80: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,

76: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,
77: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,
78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee Bug 2622488
80: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
81: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,
82: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,
83: x_return_status OUT NOCOPY VARCHAR2);
84: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]

Line 81: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,

77: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE,
78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee Bug 2622488
80: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
81: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,
82: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,
83: x_return_status OUT NOCOPY VARCHAR2);
84: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]
85: --** added by nshee

Line 1300: FROM igs_ss_appl_perstat

1296: l_stmt_count NUMBER;
1297: BEGIN
1298: SELECT COUNT(ss_perstat_id)
1299: INTO l_stmt_count
1300: FROM igs_ss_appl_perstat
1301: WHERE person_id = p_person_id
1302: AND ss_adm_appl_id = p_adm_appl_id;
1303:
1304: IF l_stmt_count = 0 THEN

Line 1307: INSERT INTO igs_ss_appl_perstat

1303:
1304: IF l_stmt_count = 0 THEN
1305: FOR c_perstat_types_data IN c_perstat_types(p_admission_application_type) LOOP
1306: BEGIN
1307: INSERT INTO igs_ss_appl_perstat
1308: (ss_perstat_id,
1309: person_id,
1310: ss_adm_appl_id,
1311: admission_application_type,

Line 1345: logDetail('insert igs_ss_appl_perstat' || SQLERRM ||

1341: p_return_status := 'S';
1342: END IF;
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: logDetail('insert igs_ss_appl_perstat' || SQLERRM ||
1346: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1347: 'S');
1348: p_return_status := 'E';
1349: p_message_data := 'IGS_GE_UNHANDLED_EXP';

Line 1397: DELETE FROM igs_ss_appl_perstat

1393:
1394: -- dvivekan
1395: -- deleting the per stmt rows not having attachments
1396:
1397: DELETE FROM igs_ss_appl_perstat
1398: WHERE ss_adm_appl_id = p_adm_appl_number
1399: AND person_id = p_person_id;
1400:
1401: --added by nshee during build for Applicant-BOSS SS Bug 2622488

Line 1457: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,

1453:
1454: END delete_ss_appl_stg;
1455:
1456: --Procedure for transferring Personal Statements/Attachments
1457: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
1458: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,
1459: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,
1460: x_return_status OUT NOCOPY VARCHAR2) IS
1461: /*****************************************************************************************

Line 1458: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,

1454: END delete_ss_appl_stg;
1455:
1456: --Procedure for transferring Personal Statements/Attachments
1457: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
1458: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,
1459: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,
1460: x_return_status OUT NOCOPY VARCHAR2) IS
1461: /*****************************************************************************************
1462: Created By: [email protected]

Line 1483: FROM igs_ss_appl_perstat ps

1479: lv_mode VARCHAR2(1) DEFAULT 'R';
1480:
1481: CURSOR c_ss_appl_perstat IS
1482: SELECT ps.*
1483: FROM igs_ss_appl_perstat ps
1484: WHERE ps.ss_adm_appl_id = p_ss_adm_appl_id
1485: AND ps.person_id = p_person_id;
1486:
1487: CURSOR c_ad_appl_perstat IS

Line 1532: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IGS_SS_APPL_PERSTAT',

1528: EXIT WHEN c_ad_appl_perstat%NOTFOUND;
1529: */
1530:
1531: l_from_pk1_value := IGS_GE_NUMBER.TO_CANN(c_ss_appl_perstat_rec.SS_PERSTAT_ID);
1532: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IGS_SS_APPL_PERSTAT',
1533: X_from_pk1_value => l_from_pk1_value,
1534: X_from_pk2_value => NULL,
1535: X_from_pk3_value => NULL,
1536: X_from_pk4_value => NULL,

Line 1551: fnd_attached_documents2_pkg.delete_attachments(X_entity_name => 'IGS_SS_APPL_PERSTAT',

1547: X_program_id => NULL,
1548: X_request_id => NULL,
1549: X_automatically_added_flag => 'N');
1550:
1551: fnd_attached_documents2_pkg.delete_attachments(X_entity_name => 'IGS_SS_APPL_PERSTAT',
1552: X_pk1_value => l_from_pk1_value,
1553: X_pk2_value => NULL,
1554: X_pk3_value => NULL,
1555: X_pk4_value => NULL,

Line 1572: DELETE FROM igs_ss_appl_perstat

1568: WHEN OTHERS THEN
1569: /* If insert is NOT successful */
1570: x_return_status := 'E';
1571: END;
1572: DELETE FROM igs_ss_appl_perstat
1573: WHERE ss_perstat_id = c_ss_appl_perstat_rec.SS_PERSTAT_ID;
1574: END IF;
1575:
1576: IF x_return_status <> 'E' OR x_return_status IS NULL THEN

Line 3885: FROM IGS_SS_APPL_PERSTAT stg,

3881: DECODE(NVL(mandatory,'N'),'N','No','Yes') required,
3882: group_number,
3883: stg.SS_PERSTAT_ID SS_PERSTAT_ID,
3884: stg.attach_exists
3885: FROM IGS_SS_APPL_PERSTAT stg,
3886: IGS_AD_APTYP_PESTAT aptypperstat
3887: WHERE stg.persl_Stat_type = aptypperstat.persl_Stat_type
3888: AND stg.admission_application_type = aptypperstat.admission_application_type
3889: AND stg.ss_Adm_appl_id = cp_adm_appl_number

Line 3905: (SELECT distinct group_number FROM IGS_SS_APPL_PERSTAT stg, IGS_AD_APTYP_PESTAT setup

3901: null attach_exists,
3902: group_min
3903: FROM IGS_AD_PESTAT_GROUP
3904: WHERE group_number IN
3905: (SELECT distinct group_number FROM IGS_SS_APPL_PERSTAT stg, IGS_AD_APTYP_PESTAT setup
3906: WHERE setup.persl_Stat_type = stg.persl_Stat_type
3907: AND setup.admission_application_type = stg.admission_application_type
3908: AND stg.ss_Adm_appl_id = cp_adm_appl_number AND stg.PERSON_ID = cp_person_id )
3909: AND admission_application_type = cp_ApplType

Line 3919: FROM IGS_SS_APPL_PERSTAT stg,

3915: -1 group_number,
3916: stg.SS_PERSTAT_ID SS_PERSTAT_ID,
3917: stg.attach_exists,
3918: 0 group_min
3919: FROM IGS_SS_APPL_PERSTAT stg,
3920: IGS_AD_APTYP_PESTAT aptypperstat
3921: WHERE stg.persl_Stat_type = aptypperstat.persl_Stat_type
3922: AND stg.admission_application_type = aptypperstat.admission_application_type
3923: AND group_number IS NULL

Line 5383: Update IGS_SS_APPL_PERSTAT SET attach_exists ='N' WHERE SS_PERSTAT_ID = p_ss_perstat_id;

5379: x_document_id => p_document_id,
5380: x_datatype_id => 6,
5381: delete_ref_Flag => 'Y'
5382: );
5383: Update IGS_SS_APPL_PERSTAT SET attach_exists ='N' WHERE SS_PERSTAT_ID = p_ss_perstat_id;
5384: EXCEPTION
5385: WHEN OTHERS THEN
5386: x_return_status := 'E';
5387:

Line 5455: entity_name => 'IGS_SS_APPL_PERSTAT',

5451: text => NULL,
5452: file_name => p_file_name,
5453: url => NULL,
5454: function_name => NULL,
5455: entity_name => 'IGS_SS_APPL_PERSTAT',
5456: pk1_value => P_SS_PERSTAT_ID,
5457: pk2_value => NULL,
5458: pk3_value => NULL,
5459: pk4_value => NULL,

Line 5465: Update IGS_SS_APPL_PERSTAT SET attach_exists ='Y' WHERE SS_PERSTAT_ID = P_SS_PERSTAT_ID;

5461: media_id => l_fileid,
5462: user_id => FND_GLOBAL.USER_ID
5463: );
5464:
5465: Update IGS_SS_APPL_PERSTAT SET attach_exists ='Y' WHERE SS_PERSTAT_ID = P_SS_PERSTAT_ID;
5466:
5467: EXCEPTION
5468: WHEN OTHERS THEN
5469: x_return_status := 'E';