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.JTF_LOC_POSTAL_CODES_PVT dependencies on FND_API

Line 31: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

27: -- create rows in JTF_LOC_POSTAL_CODES
28: -- Parameters
29: -- IN:
30: -- p_api_version IN NUMBER
31: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: -- p_commit IN VARCHAR2 := FND_API.g_false
33: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
34: --
35: -- p_postal_code_rec IN postal_code_rec_type

Line 32: -- p_commit IN VARCHAR2 := FND_API.g_false

28: -- Parameters
29: -- IN:
30: -- p_api_version IN NUMBER
31: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: -- p_commit IN VARCHAR2 := FND_API.g_false
33: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
34: --
35: -- p_postal_code_rec IN postal_code_rec_type
36: --

Line 33: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full

29: -- IN:
30: -- p_api_version IN NUMBER
31: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: -- p_commit IN VARCHAR2 := FND_API.g_false
33: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
34: --
35: -- p_postal_code_rec IN postal_code_rec_type
36: --
37: -- OUT:

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

43: ------------------------------------------------------------------------------
44: PROCEDURE create_postal_code
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

44: PROCEDURE create_postal_code
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
52: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
52: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
53: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 67: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

63: -- update rows in JTF_LOC_POSTAL_CODES
64: -- Parameters
65: -- IN:
66: -- p_api_version IN NUMBER
67: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
68: -- p_commit IN VARCHAR2 := FND_API.g_false
69: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
70: -- p_remove_flag IN VARCHAR2 := 'N'
71: -- p_postal_code_rec IN postal_code_rec_type

Line 68: -- p_commit IN VARCHAR2 := FND_API.g_false

64: -- Parameters
65: -- IN:
66: -- p_api_version IN NUMBER
67: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
68: -- p_commit IN VARCHAR2 := FND_API.g_false
69: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
70: -- p_remove_flag IN VARCHAR2 := 'N'
71: -- p_postal_code_rec IN postal_code_rec_type
72: --

Line 69: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full

65: -- IN:
66: -- p_api_version IN NUMBER
67: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
68: -- p_commit IN VARCHAR2 := FND_API.g_false
69: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
70: -- p_remove_flag IN VARCHAR2 := 'N'
71: -- p_postal_code_rec IN postal_code_rec_type
72: --
73: -- OUT:

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

77: ------------------------------------------------------------------------------
78: PROCEDURE update_postal_code
79: (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84:
85: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

78: PROCEDURE update_postal_code
79: (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84:
85: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
86: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

79: (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84:
85: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
86: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
87: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 101: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

97: -- delete rows in JTF_LOC_POSTAL_CODES
98: -- Parameters
99: -- IN:
100: -- p_api_version IN NUMBER
101: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
102: -- p_commit IN VARCHAR2 := FND_API.g_false
103: --
104: -- p_postal_code_id IN NUMBER
105: -- p_object_version IN NUMBER

Line 102: -- p_commit IN VARCHAR2 := FND_API.g_false

98: -- Parameters
99: -- IN:
100: -- p_api_version IN NUMBER
101: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
102: -- p_commit IN VARCHAR2 := FND_API.g_false
103: --
104: -- p_postal_code_id IN NUMBER
105: -- p_object_version IN NUMBER
106: --

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

111: ------------------------------------------------------------------------------
112: PROCEDURE delete_postal_code
113: (
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
116: p_commit IN VARCHAR2 := FND_API.g_false,
117:
118: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
119: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

112: PROCEDURE delete_postal_code
113: (
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
116: p_commit IN VARCHAR2 := FND_API.g_false,
117:
118: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
119: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
120: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 134: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

130: -- lock rows in JTF_LOC_POSTAL_CODES
131: -- Parameters
132: -- IN:
133: -- p_api_version IN NUMBER
134: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
135: --
136: -- p_postal_code_id IN NUMBER
137: -- p_object_version IN NUMBER
138: --

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

143: ------------------------------------------------------------------------------
144: PROCEDURE lock_postal_code
145: (
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
148:
149: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
150: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
151: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 165: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false

161: -- validate the record
162: -- Parameters
163: -- IN:
164: -- p_api_version IN NUMBER
165: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
166: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
167: --
168: -- p_postal_code_rec IN postal_code_rec_type
169: --

Line 166: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full

162: -- Parameters
163: -- IN:
164: -- p_api_version IN NUMBER
165: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
166: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
167: --
168: -- p_postal_code_rec IN postal_code_rec_type
169: --
170: -- OUT:

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

174: ------------------------------------------------------------------------------
175: PROCEDURE validate_postal_code
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
180: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
181: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
182: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

175: PROCEDURE validate_postal_code
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
180: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
181: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
182: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
183: