DBA Data[Home] [Help]

APPS.CSC_RESPONSE_CENTER_PKG_V2 dependencies on FND_API

Line 37: location_id NUMBER := FND_API.G_MISS_NUM,

33:
34: FUNCTION get_csc_application_id RETURN NUMBER;
35:
36: TYPE address_rec_type IS RECORD(
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

34: FUNCTION get_csc_application_id RETURN NUMBER;
35:
36: TYPE address_rec_type IS RECORD(
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

35:
36: TYPE address_rec_type IS RECORD(
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,

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

36: TYPE address_rec_type IS RECORD(
37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

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

37: location_id NUMBER := FND_API.G_MISS_NUM,
38: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

38: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,

39: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

40: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,

Line 45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,

41: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,

42: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,

Line 47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,

43: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,

44: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,

45: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,

46: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,

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

47: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

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

48: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,

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

49: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,

50: address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

51: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,

52: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,

Line 57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,

53: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,

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

54: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,

Line 59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,

55: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,

56: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,

Line 61: address_effective_date DATE := FND_API.G_MISS_DATE,

57: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 62: address_expiration_date DATE := FND_API.G_MISS_DATE,

58: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,

59: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,

60: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,

61: address_effective_date DATE := FND_API.G_MISS_DATE,
62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,

62: address_expiration_date DATE := FND_API.G_MISS_DATE,
63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,

Line 67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,

63: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,

Line 68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,

64: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,

65: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 70: application_id NUMBER := FND_API.G_MISS_NUM,

66: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 71: timezone_id NUMBER := FND_API.G_MISS_NUM,

67: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR

68: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

69: created_by_module VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

70: application_id NUMBER := FND_API.G_MISS_NUM,
71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

71: timezone_id NUMBER := FND_API.G_MISS_NUM,
72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

72: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR
73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

73: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

74: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

75: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

76: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

77: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

78: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

79: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

80: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

81: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

82: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

83: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,

84: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,

85: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );

Line 90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,

86: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:

Line 91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,

87: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:
95: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;

Line 92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR

88: attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:
95: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
96: