APPS.CSP_LOCATION_PKG dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

3: --p_location_rec hz_location_pub.location_rec_type;
4: p_location_rec hz_location_v2pub.location_rec_type;
5: procedure csp_create_location (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
8: p_commit IN VARCHAR2:= FND_API.G_FALSE,
9: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,

Line 8: p_commit IN VARCHAR2:= FND_API.G_FALSE,

4: p_location_rec hz_location_v2pub.location_rec_type;
5: procedure csp_create_location (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
8: p_commit IN VARCHAR2:= FND_API.G_FALSE,
9: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,

Line 9: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,

5: procedure csp_create_location (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
8: p_commit IN VARCHAR2:= FND_API.G_FALSE,
9: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
13: x_CITY VARCHAR2:= FND_API.G_FALSE,

Line 10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,

6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
8: p_commit IN VARCHAR2:= FND_API.G_FALSE,
9: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
13: x_CITY VARCHAR2:= FND_API.G_FALSE,
14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,

Line 11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,

7: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
8: p_commit IN VARCHAR2:= FND_API.G_FALSE,
9: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
13: x_CITY VARCHAR2:= FND_API.G_FALSE,
14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
15: x_STATE VARCHAR2:= FND_API.G_FALSE,

Line 12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,

8: p_commit IN VARCHAR2:= FND_API.G_FALSE,
9: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
13: x_CITY VARCHAR2:= FND_API.G_FALSE,
14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
15: x_STATE VARCHAR2:= FND_API.G_FALSE,
16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,

Line 13: x_CITY VARCHAR2:= FND_API.G_FALSE,

9: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
13: x_CITY VARCHAR2:= FND_API.G_FALSE,
14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
15: x_STATE VARCHAR2:= FND_API.G_FALSE,
16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,

Line 14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,

10: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
13: x_CITY VARCHAR2:= FND_API.G_FALSE,
14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
15: x_STATE VARCHAR2:= FND_API.G_FALSE,
16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,

Line 15: x_STATE VARCHAR2:= FND_API.G_FALSE,

11: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
13: x_CITY VARCHAR2:= FND_API.G_FALSE,
14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
15: x_STATE VARCHAR2:= FND_API.G_FALSE,
16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
19: x_COUNTY VARCHAR2:= FND_API.G_FALSE,

Line 16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,

12: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
13: x_CITY VARCHAR2:= FND_API.G_FALSE,
14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
15: x_STATE VARCHAR2:= FND_API.G_FALSE,
16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
19: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
20: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,

Line 17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,

13: x_CITY VARCHAR2:= FND_API.G_FALSE,
14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
15: x_STATE VARCHAR2:= FND_API.G_FALSE,
16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
19: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
20: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
21: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,

Line 18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,

14: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
15: x_STATE VARCHAR2:= FND_API.G_FALSE,
16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
19: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
20: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
21: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
22: x_return_status OUT NOCOPY VARCHAR2,

Line 19: x_COUNTY VARCHAR2:= FND_API.G_FALSE,

15: x_STATE VARCHAR2:= FND_API.G_FALSE,
16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
19: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
20: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
21: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,

Line 20: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,

16: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
19: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
20: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
21: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,

Line 21: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,

17: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
18: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
19: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
20: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
21: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_location_id OUT NOCOPY NUMBER,

Line 26: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_location_id OUT NOCOPY NUMBER,
26: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
27: ) Is
28: l_return_status VARCHAR2(1):='S';
29: l_msg_count NUMBER;
30: l_msg_data VARCHAR2(240);

Line 78: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

74: End;
75:
76: procedure csp_update_location (
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
79: p_commit IN VARCHAR2:= FND_API.G_FALSE,
80: x_location_id NUMBER,
81: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,

Line 79: p_commit IN VARCHAR2:= FND_API.G_FALSE,

75:
76: procedure csp_update_location (
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
79: p_commit IN VARCHAR2:= FND_API.G_FALSE,
80: x_location_id NUMBER,
81: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,

Line 81: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,

77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
79: p_commit IN VARCHAR2:= FND_API.G_FALSE,
80: x_location_id NUMBER,
81: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
85: x_CITY VARCHAR2:= FND_API.G_FALSE,

Line 82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,

78: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
79: p_commit IN VARCHAR2:= FND_API.G_FALSE,
80: x_location_id NUMBER,
81: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
85: x_CITY VARCHAR2:= FND_API.G_FALSE,
86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,

Line 83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,

79: p_commit IN VARCHAR2:= FND_API.G_FALSE,
80: x_location_id NUMBER,
81: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
85: x_CITY VARCHAR2:= FND_API.G_FALSE,
86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
87: x_STATE VARCHAR2:= FND_API.G_FALSE,

Line 84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,

80: x_location_id NUMBER,
81: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
85: x_CITY VARCHAR2:= FND_API.G_FALSE,
86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
87: x_STATE VARCHAR2:= FND_API.G_FALSE,
88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,

Line 85: x_CITY VARCHAR2:= FND_API.G_FALSE,

81: x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
85: x_CITY VARCHAR2:= FND_API.G_FALSE,
86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
87: x_STATE VARCHAR2:= FND_API.G_FALSE,
88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,

Line 86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,

82: x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
85: x_CITY VARCHAR2:= FND_API.G_FALSE,
86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
87: x_STATE VARCHAR2:= FND_API.G_FALSE,
88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,

Line 87: x_STATE VARCHAR2:= FND_API.G_FALSE,

83: x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
85: x_CITY VARCHAR2:= FND_API.G_FALSE,
86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
87: x_STATE VARCHAR2:= FND_API.G_FALSE,
88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
91: x_COUNTY VARCHAR2:= FND_API.G_FALSE,

Line 88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,

84: x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
85: x_CITY VARCHAR2:= FND_API.G_FALSE,
86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
87: x_STATE VARCHAR2:= FND_API.G_FALSE,
88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
91: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
92: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,

Line 89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,

85: x_CITY VARCHAR2:= FND_API.G_FALSE,
86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
87: x_STATE VARCHAR2:= FND_API.G_FALSE,
88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
91: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
92: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
93: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,

Line 90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,

86: x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
87: x_STATE VARCHAR2:= FND_API.G_FALSE,
88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
91: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
92: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
93: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,

Line 91: x_COUNTY VARCHAR2:= FND_API.G_FALSE,

87: x_STATE VARCHAR2:= FND_API.G_FALSE,
88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
91: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
92: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
93: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,

Line 92: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,

88: x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
91: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
92: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
93: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2,

Line 93: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,

89: x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
90: x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
91: x_COUNTY VARCHAR2:= FND_API.G_FALSE,
92: x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
93: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2,
97: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

Line 97: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

93: x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2,
97: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
98: ) Is
99: l_return_status VARCHAR2(1):='S';
100: l_msg_count NUMBER;
101: l_msg_data VARCHAR2(240);