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_PE_VISAPASS_PUB dependencies on IGS_PE_VISA

Line 1: PACKAGE IGS_PE_VISAPASS_PUB AS

1: PACKAGE IGS_PE_VISAPASS_PUB AS
2: /* $Header: IGSPE16S.pls 120.1 2005/09/30 04:25:50 appldev noship $ */
3:
4: /******************************************************************************
5: || Created By : ssaleem

Line 21: visa_id igs_pe_visa.visa_id%TYPE,

17: -- declaration of record type
18: --------------------------------------
19:
20: TYPE visa_rec_type IS RECORD(
21: visa_id igs_pe_visa.visa_id%TYPE,
22: person_id igs_pe_visa.person_id%TYPE,
23: visa_type igs_pe_visa.visa_type%TYPE,
24: visa_number igs_pe_visa.visa_number%TYPE,
25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,

Line 22: person_id igs_pe_visa.person_id%TYPE,

18: --------------------------------------
19:
20: TYPE visa_rec_type IS RECORD(
21: visa_id igs_pe_visa.visa_id%TYPE,
22: person_id igs_pe_visa.person_id%TYPE,
23: visa_type igs_pe_visa.visa_type%TYPE,
24: visa_number igs_pe_visa.visa_number%TYPE,
25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,

Line 23: visa_type igs_pe_visa.visa_type%TYPE,

19:
20: TYPE visa_rec_type IS RECORD(
21: visa_id igs_pe_visa.visa_id%TYPE,
22: person_id igs_pe_visa.person_id%TYPE,
23: visa_type igs_pe_visa.visa_type%TYPE,
24: visa_number igs_pe_visa.visa_number%TYPE,
25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,

Line 24: visa_number igs_pe_visa.visa_number%TYPE,

20: TYPE visa_rec_type IS RECORD(
21: visa_id igs_pe_visa.visa_id%TYPE,
22: person_id igs_pe_visa.person_id%TYPE,
23: visa_type igs_pe_visa.visa_type%TYPE,
24: visa_number igs_pe_visa.visa_number%TYPE,
25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28: passport_id igs_pe_visa.passport_id%TYPE,

Line 25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,

21: visa_id igs_pe_visa.visa_id%TYPE,
22: person_id igs_pe_visa.person_id%TYPE,
23: visa_type igs_pe_visa.visa_type%TYPE,
24: visa_number igs_pe_visa.visa_number%TYPE,
25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28: passport_id igs_pe_visa.passport_id%TYPE,
29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,

Line 26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,

22: person_id igs_pe_visa.person_id%TYPE,
23: visa_type igs_pe_visa.visa_type%TYPE,
24: visa_number igs_pe_visa.visa_number%TYPE,
25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28: passport_id igs_pe_visa.passport_id%TYPE,
29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30: agent_person_id igs_pe_visa.agent_person_id%TYPE,

Line 27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,

23: visa_type igs_pe_visa.visa_type%TYPE,
24: visa_number igs_pe_visa.visa_number%TYPE,
25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28: passport_id igs_pe_visa.passport_id%TYPE,
29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30: agent_person_id igs_pe_visa.agent_person_id%TYPE,
31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,

Line 28: passport_id igs_pe_visa.passport_id%TYPE,

24: visa_number igs_pe_visa.visa_number%TYPE,
25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28: passport_id igs_pe_visa.passport_id%TYPE,
29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30: agent_person_id igs_pe_visa.agent_person_id%TYPE,
31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32: attribute_category igs_pe_visa.attribute_category%TYPE,

Line 29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,

25: visa_issue_date igs_pe_visa.visa_issue_date%TYPE,
26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28: passport_id igs_pe_visa.passport_id%TYPE,
29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30: agent_person_id igs_pe_visa.agent_person_id%TYPE,
31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32: attribute_category igs_pe_visa.attribute_category%TYPE,
33: attribute1 igs_pe_visa.attribute1%TYPE,

Line 30: agent_person_id igs_pe_visa.agent_person_id%TYPE,

26: visa_expiry_date igs_pe_visa.visa_expiry_date%TYPE,
27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28: passport_id igs_pe_visa.passport_id%TYPE,
29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30: agent_person_id igs_pe_visa.agent_person_id%TYPE,
31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32: attribute_category igs_pe_visa.attribute_category%TYPE,
33: attribute1 igs_pe_visa.attribute1%TYPE,
34: attribute2 igs_pe_visa.attribute2%TYPE,

Line 31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,

27: visa_issuing_post igs_pe_visa.visa_issuing_post%TYPE,
28: passport_id igs_pe_visa.passport_id%TYPE,
29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30: agent_person_id igs_pe_visa.agent_person_id%TYPE,
31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32: attribute_category igs_pe_visa.attribute_category%TYPE,
33: attribute1 igs_pe_visa.attribute1%TYPE,
34: attribute2 igs_pe_visa.attribute2%TYPE,
35: attribute3 igs_pe_visa.attribute3%TYPE,

Line 32: attribute_category igs_pe_visa.attribute_category%TYPE,

28: passport_id igs_pe_visa.passport_id%TYPE,
29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30: agent_person_id igs_pe_visa.agent_person_id%TYPE,
31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32: attribute_category igs_pe_visa.attribute_category%TYPE,
33: attribute1 igs_pe_visa.attribute1%TYPE,
34: attribute2 igs_pe_visa.attribute2%TYPE,
35: attribute3 igs_pe_visa.attribute3%TYPE,
36: attribute4 igs_pe_visa.attribute4%TYPE,

Line 33: attribute1 igs_pe_visa.attribute1%TYPE,

29: agent_org_unit_cd igs_pe_visa.agent_org_unit_cd%TYPE,
30: agent_person_id igs_pe_visa.agent_person_id%TYPE,
31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32: attribute_category igs_pe_visa.attribute_category%TYPE,
33: attribute1 igs_pe_visa.attribute1%TYPE,
34: attribute2 igs_pe_visa.attribute2%TYPE,
35: attribute3 igs_pe_visa.attribute3%TYPE,
36: attribute4 igs_pe_visa.attribute4%TYPE,
37: attribute5 igs_pe_visa.attribute5%TYPE,

Line 34: attribute2 igs_pe_visa.attribute2%TYPE,

30: agent_person_id igs_pe_visa.agent_person_id%TYPE,
31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32: attribute_category igs_pe_visa.attribute_category%TYPE,
33: attribute1 igs_pe_visa.attribute1%TYPE,
34: attribute2 igs_pe_visa.attribute2%TYPE,
35: attribute3 igs_pe_visa.attribute3%TYPE,
36: attribute4 igs_pe_visa.attribute4%TYPE,
37: attribute5 igs_pe_visa.attribute5%TYPE,
38: attribute6 igs_pe_visa.attribute6%TYPE,

Line 35: attribute3 igs_pe_visa.attribute3%TYPE,

31: agent_contact_name igs_pe_visa.agent_contact_name%TYPE,
32: attribute_category igs_pe_visa.attribute_category%TYPE,
33: attribute1 igs_pe_visa.attribute1%TYPE,
34: attribute2 igs_pe_visa.attribute2%TYPE,
35: attribute3 igs_pe_visa.attribute3%TYPE,
36: attribute4 igs_pe_visa.attribute4%TYPE,
37: attribute5 igs_pe_visa.attribute5%TYPE,
38: attribute6 igs_pe_visa.attribute6%TYPE,
39: attribute7 igs_pe_visa.attribute7%TYPE,

Line 36: attribute4 igs_pe_visa.attribute4%TYPE,

32: attribute_category igs_pe_visa.attribute_category%TYPE,
33: attribute1 igs_pe_visa.attribute1%TYPE,
34: attribute2 igs_pe_visa.attribute2%TYPE,
35: attribute3 igs_pe_visa.attribute3%TYPE,
36: attribute4 igs_pe_visa.attribute4%TYPE,
37: attribute5 igs_pe_visa.attribute5%TYPE,
38: attribute6 igs_pe_visa.attribute6%TYPE,
39: attribute7 igs_pe_visa.attribute7%TYPE,
40: attribute8 igs_pe_visa.attribute8%TYPE,

Line 37: attribute5 igs_pe_visa.attribute5%TYPE,

33: attribute1 igs_pe_visa.attribute1%TYPE,
34: attribute2 igs_pe_visa.attribute2%TYPE,
35: attribute3 igs_pe_visa.attribute3%TYPE,
36: attribute4 igs_pe_visa.attribute4%TYPE,
37: attribute5 igs_pe_visa.attribute5%TYPE,
38: attribute6 igs_pe_visa.attribute6%TYPE,
39: attribute7 igs_pe_visa.attribute7%TYPE,
40: attribute8 igs_pe_visa.attribute8%TYPE,
41: attribute9 igs_pe_visa.attribute9%TYPE,

Line 38: attribute6 igs_pe_visa.attribute6%TYPE,

34: attribute2 igs_pe_visa.attribute2%TYPE,
35: attribute3 igs_pe_visa.attribute3%TYPE,
36: attribute4 igs_pe_visa.attribute4%TYPE,
37: attribute5 igs_pe_visa.attribute5%TYPE,
38: attribute6 igs_pe_visa.attribute6%TYPE,
39: attribute7 igs_pe_visa.attribute7%TYPE,
40: attribute8 igs_pe_visa.attribute8%TYPE,
41: attribute9 igs_pe_visa.attribute9%TYPE,
42: attribute10 igs_pe_visa.attribute10%TYPE,

Line 39: attribute7 igs_pe_visa.attribute7%TYPE,

35: attribute3 igs_pe_visa.attribute3%TYPE,
36: attribute4 igs_pe_visa.attribute4%TYPE,
37: attribute5 igs_pe_visa.attribute5%TYPE,
38: attribute6 igs_pe_visa.attribute6%TYPE,
39: attribute7 igs_pe_visa.attribute7%TYPE,
40: attribute8 igs_pe_visa.attribute8%TYPE,
41: attribute9 igs_pe_visa.attribute9%TYPE,
42: attribute10 igs_pe_visa.attribute10%TYPE,
43: attribute11 igs_pe_visa.attribute11%TYPE,

Line 40: attribute8 igs_pe_visa.attribute8%TYPE,

36: attribute4 igs_pe_visa.attribute4%TYPE,
37: attribute5 igs_pe_visa.attribute5%TYPE,
38: attribute6 igs_pe_visa.attribute6%TYPE,
39: attribute7 igs_pe_visa.attribute7%TYPE,
40: attribute8 igs_pe_visa.attribute8%TYPE,
41: attribute9 igs_pe_visa.attribute9%TYPE,
42: attribute10 igs_pe_visa.attribute10%TYPE,
43: attribute11 igs_pe_visa.attribute11%TYPE,
44: attribute12 igs_pe_visa.attribute12%TYPE,

Line 41: attribute9 igs_pe_visa.attribute9%TYPE,

37: attribute5 igs_pe_visa.attribute5%TYPE,
38: attribute6 igs_pe_visa.attribute6%TYPE,
39: attribute7 igs_pe_visa.attribute7%TYPE,
40: attribute8 igs_pe_visa.attribute8%TYPE,
41: attribute9 igs_pe_visa.attribute9%TYPE,
42: attribute10 igs_pe_visa.attribute10%TYPE,
43: attribute11 igs_pe_visa.attribute11%TYPE,
44: attribute12 igs_pe_visa.attribute12%TYPE,
45: attribute13 igs_pe_visa.attribute13%TYPE,

Line 42: attribute10 igs_pe_visa.attribute10%TYPE,

38: attribute6 igs_pe_visa.attribute6%TYPE,
39: attribute7 igs_pe_visa.attribute7%TYPE,
40: attribute8 igs_pe_visa.attribute8%TYPE,
41: attribute9 igs_pe_visa.attribute9%TYPE,
42: attribute10 igs_pe_visa.attribute10%TYPE,
43: attribute11 igs_pe_visa.attribute11%TYPE,
44: attribute12 igs_pe_visa.attribute12%TYPE,
45: attribute13 igs_pe_visa.attribute13%TYPE,
46: attribute14 igs_pe_visa.attribute14%TYPE,

Line 43: attribute11 igs_pe_visa.attribute11%TYPE,

39: attribute7 igs_pe_visa.attribute7%TYPE,
40: attribute8 igs_pe_visa.attribute8%TYPE,
41: attribute9 igs_pe_visa.attribute9%TYPE,
42: attribute10 igs_pe_visa.attribute10%TYPE,
43: attribute11 igs_pe_visa.attribute11%TYPE,
44: attribute12 igs_pe_visa.attribute12%TYPE,
45: attribute13 igs_pe_visa.attribute13%TYPE,
46: attribute14 igs_pe_visa.attribute14%TYPE,
47: attribute15 igs_pe_visa.attribute15%TYPE,

Line 44: attribute12 igs_pe_visa.attribute12%TYPE,

40: attribute8 igs_pe_visa.attribute8%TYPE,
41: attribute9 igs_pe_visa.attribute9%TYPE,
42: attribute10 igs_pe_visa.attribute10%TYPE,
43: attribute11 igs_pe_visa.attribute11%TYPE,
44: attribute12 igs_pe_visa.attribute12%TYPE,
45: attribute13 igs_pe_visa.attribute13%TYPE,
46: attribute14 igs_pe_visa.attribute14%TYPE,
47: attribute15 igs_pe_visa.attribute15%TYPE,
48: attribute16 igs_pe_visa.attribute16%TYPE,

Line 45: attribute13 igs_pe_visa.attribute13%TYPE,

41: attribute9 igs_pe_visa.attribute9%TYPE,
42: attribute10 igs_pe_visa.attribute10%TYPE,
43: attribute11 igs_pe_visa.attribute11%TYPE,
44: attribute12 igs_pe_visa.attribute12%TYPE,
45: attribute13 igs_pe_visa.attribute13%TYPE,
46: attribute14 igs_pe_visa.attribute14%TYPE,
47: attribute15 igs_pe_visa.attribute15%TYPE,
48: attribute16 igs_pe_visa.attribute16%TYPE,
49: attribute17 igs_pe_visa.attribute17%TYPE,

Line 46: attribute14 igs_pe_visa.attribute14%TYPE,

42: attribute10 igs_pe_visa.attribute10%TYPE,
43: attribute11 igs_pe_visa.attribute11%TYPE,
44: attribute12 igs_pe_visa.attribute12%TYPE,
45: attribute13 igs_pe_visa.attribute13%TYPE,
46: attribute14 igs_pe_visa.attribute14%TYPE,
47: attribute15 igs_pe_visa.attribute15%TYPE,
48: attribute16 igs_pe_visa.attribute16%TYPE,
49: attribute17 igs_pe_visa.attribute17%TYPE,
50: attribute18 igs_pe_visa.attribute18%TYPE,

Line 47: attribute15 igs_pe_visa.attribute15%TYPE,

43: attribute11 igs_pe_visa.attribute11%TYPE,
44: attribute12 igs_pe_visa.attribute12%TYPE,
45: attribute13 igs_pe_visa.attribute13%TYPE,
46: attribute14 igs_pe_visa.attribute14%TYPE,
47: attribute15 igs_pe_visa.attribute15%TYPE,
48: attribute16 igs_pe_visa.attribute16%TYPE,
49: attribute17 igs_pe_visa.attribute17%TYPE,
50: attribute18 igs_pe_visa.attribute18%TYPE,
51: attribute19 igs_pe_visa.attribute19%TYPE,

Line 48: attribute16 igs_pe_visa.attribute16%TYPE,

44: attribute12 igs_pe_visa.attribute12%TYPE,
45: attribute13 igs_pe_visa.attribute13%TYPE,
46: attribute14 igs_pe_visa.attribute14%TYPE,
47: attribute15 igs_pe_visa.attribute15%TYPE,
48: attribute16 igs_pe_visa.attribute16%TYPE,
49: attribute17 igs_pe_visa.attribute17%TYPE,
50: attribute18 igs_pe_visa.attribute18%TYPE,
51: attribute19 igs_pe_visa.attribute19%TYPE,
52: attribute20 igs_pe_visa.attribute20%TYPE,

Line 49: attribute17 igs_pe_visa.attribute17%TYPE,

45: attribute13 igs_pe_visa.attribute13%TYPE,
46: attribute14 igs_pe_visa.attribute14%TYPE,
47: attribute15 igs_pe_visa.attribute15%TYPE,
48: attribute16 igs_pe_visa.attribute16%TYPE,
49: attribute17 igs_pe_visa.attribute17%TYPE,
50: attribute18 igs_pe_visa.attribute18%TYPE,
51: attribute19 igs_pe_visa.attribute19%TYPE,
52: attribute20 igs_pe_visa.attribute20%TYPE,
53: visa_issuing_country igs_pe_visa.visa_issuing_country%TYPE

Line 50: attribute18 igs_pe_visa.attribute18%TYPE,

46: attribute14 igs_pe_visa.attribute14%TYPE,
47: attribute15 igs_pe_visa.attribute15%TYPE,
48: attribute16 igs_pe_visa.attribute16%TYPE,
49: attribute17 igs_pe_visa.attribute17%TYPE,
50: attribute18 igs_pe_visa.attribute18%TYPE,
51: attribute19 igs_pe_visa.attribute19%TYPE,
52: attribute20 igs_pe_visa.attribute20%TYPE,
53: visa_issuing_country igs_pe_visa.visa_issuing_country%TYPE
54: );

Line 51: attribute19 igs_pe_visa.attribute19%TYPE,

47: attribute15 igs_pe_visa.attribute15%TYPE,
48: attribute16 igs_pe_visa.attribute16%TYPE,
49: attribute17 igs_pe_visa.attribute17%TYPE,
50: attribute18 igs_pe_visa.attribute18%TYPE,
51: attribute19 igs_pe_visa.attribute19%TYPE,
52: attribute20 igs_pe_visa.attribute20%TYPE,
53: visa_issuing_country igs_pe_visa.visa_issuing_country%TYPE
54: );
55:

Line 52: attribute20 igs_pe_visa.attribute20%TYPE,

48: attribute16 igs_pe_visa.attribute16%TYPE,
49: attribute17 igs_pe_visa.attribute17%TYPE,
50: attribute18 igs_pe_visa.attribute18%TYPE,
51: attribute19 igs_pe_visa.attribute19%TYPE,
52: attribute20 igs_pe_visa.attribute20%TYPE,
53: visa_issuing_country igs_pe_visa.visa_issuing_country%TYPE
54: );
55:
56: TYPE visit_hstry_rec_type IS RECORD(

Line 53: visa_issuing_country igs_pe_visa.visa_issuing_country%TYPE

49: attribute17 igs_pe_visa.attribute17%TYPE,
50: attribute18 igs_pe_visa.attribute18%TYPE,
51: attribute19 igs_pe_visa.attribute19%TYPE,
52: attribute20 igs_pe_visa.attribute20%TYPE,
53: visa_issuing_country igs_pe_visa.visa_issuing_country%TYPE
54: );
55:
56: TYPE visit_hstry_rec_type IS RECORD(
57: port_of_entry igs_pe_visit_histry.port_of_entry%TYPE,

Line 344: END IGS_PE_VISAPASS_PUB;

340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_passport_rec IN passport_rec_type
342: );
343:
344: END IGS_PE_VISAPASS_PUB;