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.

[Home] [Help]

APPS.AMS_REGISTRANTS_PVT dependencies on FND_API

Line 15: PERSON_FIRST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,

11: -- 05-APR-2002 dcastlem Rewrote party_detail_rec_type to include all fields
12:
13: /*
14: TYPE party_detail_rec_type IS RECORD(
15: PERSON_FIRST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
16: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
18: PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 16: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,

12:
13: /*
14: TYPE party_detail_rec_type IS RECORD(
15: PERSON_FIRST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
16: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
18: PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 17: PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,

13: /*
14: TYPE party_detail_rec_type IS RECORD(
15: PERSON_FIRST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
16: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
18: PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 18: PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,

14: TYPE party_detail_rec_type IS RECORD(
15: PERSON_FIRST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
16: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
18: PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,
22:

Line 19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,

15: PERSON_FIRST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
16: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
18: PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,
22:
23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,

Line 20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,

16: PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
17: PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
18: PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,
22:
23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,
24: DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,

17: PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
18: PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,
22:
23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,
24: DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,

19: PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,
22:
23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,
24: DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,

Line 24: DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

20: PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,
22:
23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,
24: DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,
28:

Line 25: DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,

21: SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,
22:
23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,
24: DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,
28:
29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,

Line 26: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,

22:
23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,
24: DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,
28:
29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,
30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,

Line 27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,

23: JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,
24: DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,
28:
29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,
30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,
31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,

25: DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,
28:
29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,
30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,
31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,

26: PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,
28:
29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,
30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,
31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,

27: ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,
28:
29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,
30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,
31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

28:
29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,
30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,
31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

29: BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,
30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,
31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,

30: BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,
31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,

Line 35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,

31: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,

32: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,

33: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,

34: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,

Line 39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,

35: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,

Line 40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

36: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

37: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,

38: POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,

Line 43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,

39: TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,

40: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,

41: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,

42: ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,

43: APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,

Line 48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,

44: PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,

Line 49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,

45: HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,

46: STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,

47: SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,

48: STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,

Line 53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,

49: RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

50: RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

51: STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: PHONE_NUMBER VARCHAR2(40):= FND_API.G_MISS_CHAR,

Line 56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,

52: FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: PHONE_NUMBER VARCHAR2(40):= FND_API.G_MISS_CHAR,
60: PHONE_EXTENTION VARCHAR2(20) := FND_API.G_MISS_CHAR

Line 57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

53: SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: PHONE_NUMBER VARCHAR2(40):= FND_API.G_MISS_CHAR,
60: PHONE_EXTENTION VARCHAR2(20) := FND_API.G_MISS_CHAR
61: );

Line 58: PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

54: POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: PHONE_NUMBER VARCHAR2(40):= FND_API.G_MISS_CHAR,
60: PHONE_EXTENTION VARCHAR2(20) := FND_API.G_MISS_CHAR
61: );
62: */

Line 59: PHONE_NUMBER VARCHAR2(40):= FND_API.G_MISS_CHAR,

55: OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: PHONE_NUMBER VARCHAR2(40):= FND_API.G_MISS_CHAR,
60: PHONE_EXTENTION VARCHAR2(20) := FND_API.G_MISS_CHAR
61: );
62: */
63: TYPE party_detail_rec_type IS RECORD(

Line 60: PHONE_EXTENTION VARCHAR2(20) := FND_API.G_MISS_CHAR

56: EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57: PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58: PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: PHONE_NUMBER VARCHAR2(40):= FND_API.G_MISS_CHAR,
60: PHONE_EXTENTION VARCHAR2(20) := FND_API.G_MISS_CHAR
61: );
62: */
63: TYPE party_detail_rec_type IS RECORD(
64: party_id NUMBER,

Line 206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

202: ---------------------------------------------------------------------
203:
204: PROCEDURE find_a_party(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_rec IN party_detail_rec_type,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,

Line 231: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

227: ---------------------------------------------------------------------
228:
229: PROCEDURE create_registrant_party(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
232: p_commit IN VARCHAR2 := FND_API.g_false,
233: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
234: p_rec IN party_detail_rec_type,
235:

Line 232: p_commit IN VARCHAR2 := FND_API.g_false,

228:
229: PROCEDURE create_registrant_party(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
232: p_commit IN VARCHAR2 := FND_API.g_false,
233: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
234: p_rec IN party_detail_rec_type,
235:
236: x_return_status OUT NOCOPY VARCHAR2,

Line 233: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

229: PROCEDURE create_registrant_party(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
232: p_commit IN VARCHAR2 := FND_API.g_false,
233: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
234: p_rec IN party_detail_rec_type,
235:
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,

Line 261: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

257: ---------------------------------------------------------------------
258:
259: PROCEDURE get_party_id(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
262: p_commit IN VARCHAR2 := FND_API.g_false,
263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
264: p_rec IN party_detail_rec_type,
265:

Line 262: p_commit IN VARCHAR2 := FND_API.g_false,

258:
259: PROCEDURE get_party_id(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
262: p_commit IN VARCHAR2 := FND_API.g_false,
263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
264: p_rec IN party_detail_rec_type,
265:
266: x_return_status OUT NOCOPY VARCHAR2,

Line 263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

259: PROCEDURE get_party_id(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
262: p_commit IN VARCHAR2 := FND_API.g_false,
263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
264: p_rec IN party_detail_rec_type,
265:
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,