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:

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:
74: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;

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:
74: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
75:

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:
74: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
75:
76: PROCEDURE Create_Address ( p_address_rec IN ADDRESS_REC_TYPE,