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_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_SV_ADDRESSES

Line 63: TYPE g_address_rec_type IS TABLE OF IGS_SV_ADDRESSES%ROWTYPE INDEX BY BINARY_INTEGER;

59: l_label VARCHAR2(4000);
60: l_debug_str VARCHAR2(32000);
61: g_person_status VARCHAR2(6) := 'NEW';
62: g_nonimg_form_id NUMBER(15);
63: TYPE g_address_rec_type IS TABLE OF IGS_SV_ADDRESSES%ROWTYPE INDEX BY BINARY_INTEGER;
64: TYPE g_edu_rec_type IS TABLE OF IGS_SV_PRGMS_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
65: TYPE g_dependent_rec_type IS TABLE OF IGS_SV_DEPDNT_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
66: TYPE g_convictions_rec_type IS TABLE OF IGS_SV_CONVICTIONS%ROWTYPE INDEX BY BINARY_INTEGER;
67: TYPE g_empl_rec_type IS TABLE OF IGS_SV_EMPL_INFO%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1836: (IGS_SV_ADDRESSES).

1832: Date Created By : Oct 14, 2002
1833:
1834: Purpose : Validate data pertaining to the Foreign
1835: address information on the student.
1836: (IGS_SV_ADDRESSES).
1837:
1838: Remarks : Return result:
1839: 'S' - record found and validated
1840: 'E' - validation error

Line 2008: on the student. (IGS_SV_ADDRESSES)

2004:
2005: Date Created By : Oct 14, 2002
2006:
2007: Purpose : Validate the US Address block information
2008: on the student. (IGS_SV_ADDRESSES)
2009:
2010: Remarks : Return result:
2011: 'S' - record found and validated
2012: 'E' - validation error

Line 2181: (IGS_SV_ADDRESSES).

2177: Date Created By : Oct 14, 2002
2178:
2179: Purpose : Validate the information pertaining to the
2180: Activity Site Address for the student.
2181: (IGS_SV_ADDRESSES).
2182:
2183: Remarks : Return result:
2184: 'S' - record found and validated
2185: 'E' - validation error

Line 5117: (IGS_SV_ADDRESSES).

5113:
5114: Date Created By : Oct 14, 2002
5115:
5116: Purpose : Get Site of activity information on the student
5117: (IGS_SV_ADDRESSES).
5118:
5119: Remarks :
5120:
5121: Change History

Line 5127: p_data_rec IN OUT NOCOPY IGS_SV_ADDRESSES%ROWTYPE -- Data record

5123: ------------------------------------------------------------------------
5124:
5125: ******************************************************************/
5126: FUNCTION Get_Address_Info (
5127: p_data_rec IN OUT NOCOPY IGS_SV_ADDRESSES%ROWTYPE -- Data record
5128: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
5129: IS
5130:
5131: l_api_name CONSTANT VARCHAR2(25) := 'Get_Address_Info';

Line 5147: FROM igs_sv_addresses cr

5143: province ,
5144: stdnt_valid_flag ,
5145: primary_flag ,
5146: activity_site_cd
5147: FROM igs_sv_addresses cr
5148: WHERE cr.person_id = p_data_rec.person_id
5149: AND cr.party_site_id = p_data_rec.party_site_id
5150: AND cr.batch_id IN
5151: ( SELECT max(prs.batch_id)

Line 5152: FROM igs_sv_addresses prs,

5148: WHERE cr.person_id = p_data_rec.person_id
5149: AND cr.party_site_id = p_data_rec.party_site_id
5150: AND cr.batch_id IN
5151: ( SELECT max(prs.batch_id)
5152: FROM igs_sv_addresses prs,
5153: igs_sv_persons pr
5154: WHERE prs.person_id = pr.person_id
5155: AND prs.batch_id = pr.batch_id
5156: AND pr.record_status <> 'E'

Line 6081: (IGS_SV_ADDRESSES).

6077:
6078: Date Created By : Oct 14, 2002
6079:
6080: Purpose : Insert site of activity information.
6081: (IGS_SV_ADDRESSES).
6082:
6083: Remarks :
6084:
6085: Change History

Line 6133: 'IGS_SV_ADDRESSES',

6129: p_data_rec(l_count).person_id,
6130: l_action,
6131: 'SV_SOA',
6132: 'SEND',
6133: 'IGS_SV_ADDRESSES',
6134: p_data_rec(l_count).party_site_id);
6135: ELSE
6136: l_remarks := null;
6137: l_btch_id := p_data_rec(l_count).batch_id;

Line 6144: 'IGS_SV_ADDRESSES',

6140: p_data_rec(l_count).person_id,
6141: g_person_status,
6142: 'SV_US_ADDR',
6143: 'SEND',
6144: 'IGS_SV_ADDRESSES',
6145: p_data_rec(l_count).party_site_id);
6146: ELSE
6147: Insert_Summary_Info(l_btch_id,
6148: p_data_rec(l_count).person_id,

Line 6152: 'IGS_SV_ADDRESSES',

6148: p_data_rec(l_count).person_id,
6149: g_person_status,
6150: 'SV_F_ADDR',
6151: 'SEND',
6152: 'IGS_SV_ADDRESSES',
6153: p_data_rec(l_count).party_site_id);
6154: END IF;
6155: END IF;
6156:

Line 6157: INSERT INTO igs_sv_addresses (

6153: p_data_rec(l_count).party_site_id);
6154: END IF;
6155: END IF;
6156:
6157: INSERT INTO igs_sv_addresses (
6158: batch_id ,
6159: person_id ,
6160: party_site_id ,
6161: print_form ,

Line 7685: l_prev_us_addr_rec IGS_SV_ADDRESSES%ROWTYPE;

7681: l_us_addr_rec g_address_rec_type;
7682: l_count NUMBER(10);
7683: l_cur NUMBER(10);
7684: l_changes_found VARCHAR2(1) := 'N'; --No changes by default
7685: l_prev_us_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
7686:
7687: l_site_addr_rec g_address_rec_type;
7688: l_prev_site_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
7689:

Line 7688: l_prev_site_addr_rec IGS_SV_ADDRESSES%ROWTYPE;

7684: l_changes_found VARCHAR2(1) := 'N'; --No changes by default
7685: l_prev_us_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
7686:
7687: l_site_addr_rec g_address_rec_type;
7688: l_prev_site_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
7689:
7690:
7691:
7692: BEGIN

Line 8047: l_prev_f_addr_rec IGS_SV_ADDRESSES%ROWTYPE;

8043: l_status VARCHAR2(1);
8044:
8045: l_prev_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
8046: l_prev_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
8047: l_prev_f_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
8048: l_prev_us_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
8049:
8050:
8051: BEGIN

Line 8048: l_prev_us_addr_rec IGS_SV_ADDRESSES%ROWTYPE;

8044:
8045: l_prev_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
8046: l_prev_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
8047: l_prev_f_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
8048: l_prev_us_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
8049:
8050:
8051: BEGIN
8052: /* Debug */

Line 10137: DELETE FROM igs_sv_addresses WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );

10133: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10134: END IF;
10135: -- Delete from all related tables
10136:
10137: DELETE FROM igs_sv_addresses WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10138:
10139: DELETE FROM igs_sv_addresses WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10140:
10141: DELETE FROM igs_sv_bio_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;

Line 10139: DELETE FROM igs_sv_addresses WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );

10135: -- Delete from all related tables
10136:
10137: DELETE FROM igs_sv_addresses WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10138:
10139: DELETE FROM igs_sv_addresses WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10140:
10141: DELETE FROM igs_sv_bio_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10142:
10143: DELETE FROM igs_sv_convictions WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;