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

Line 6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

2: /* $Header: PACITUVB.pls 120.1 2005/08/19 16:19:02 mwasowic noship $ */
3:
4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type_id IN NUMBER,

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

3:
4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type_id IN NUMBER,
11: p_ci_type_id IN NUMBER,

Line 8: p_validate_only IN VARCHAR2 := FND_API.g_true,

4: PROCEDURE create_ci_type_usage (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type_id IN NUMBER,
11: p_ci_type_id IN NUMBER,
12: p_created_by IN NUMBER DEFAULT fnd_global.user_id,

Line 9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_project_type_id IN NUMBER,
11: p_ci_type_id IN NUMBER,
12: p_created_by IN NUMBER DEFAULT fnd_global.user_id,
13: p_creation_date IN DATE DEFAULT SYSDATE,

Line 25: IF p_commit = FND_API.G_TRUE THEN

21: l_rowid VARCHAR2(30);
22: BEGIN
23: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.CREATE_CI_TYPE_USAGE');
24:
25: IF p_commit = FND_API.G_TRUE THEN
26: SAVEPOINT create_ci_type_usage;
27: END IF;
28:
29: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 29: IF p_init_msg_list = FND_API.G_TRUE THEN

25: IF p_commit = FND_API.G_TRUE THEN
26: SAVEPOINT create_ci_type_usage;
27: END IF;
28:
29: IF p_init_msg_list = FND_API.G_TRUE THEN
30: fnd_msg_pub.initialize;
31: END IF;
32:
33: x_return_status := 'S';

Line 37: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

33: x_return_status := 'S';
34: x_msg_count := 0;
35: x_msg_data := '';
36:
37: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
38: pa_ci_type_usage_pkg.insert_row(
39: x_rowid => l_rowid,
40: x_ci_type_usage_id => x_ci_type_usage_id,
41: x_project_type_id => p_project_type_id,

Line 50: IF p_commit = fnd_api.g_true THEN

46: x_last_updated_by => p_created_by,
47: x_last_update_login => p_last_update_login);
48: END IF;
49:
50: IF p_commit = fnd_api.g_true THEN
51: IF x_return_status = 'S' THEN
52: COMMIT;
53: ELSE
54: ROLLBACK TO create_ci_type_usage;

Line 65: IF p_commit = fnd_api.g_true THEN

61: pa_debug.reset_err_stack;
62:
63: EXCEPTION
64: WHEN OTHERS THEN
65: IF p_commit = fnd_api.g_true THEN
66: ROLLBACK TO create_ci_type_usage;
67: END IF;
68:
69: x_return_status := 'U';

Line 80: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

76: END create_ci_type_usage;
77:
78: PROCEDURE update_ci_type_usage (
79: p_api_version IN NUMBER := 1.0,
80: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
81: p_commit IN VARCHAR2 := FND_API.g_false,
82: p_validate_only IN VARCHAR2 := FND_API.g_true,
83: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
84: p_ci_type_usage_id IN NUMBER,

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

77:
78: PROCEDURE update_ci_type_usage (
79: p_api_version IN NUMBER := 1.0,
80: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
81: p_commit IN VARCHAR2 := FND_API.g_false,
82: p_validate_only IN VARCHAR2 := FND_API.g_true,
83: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
84: p_ci_type_usage_id IN NUMBER,
85: p_project_type_id IN NUMBER,

Line 82: p_validate_only IN VARCHAR2 := FND_API.g_true,

78: PROCEDURE update_ci_type_usage (
79: p_api_version IN NUMBER := 1.0,
80: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
81: p_commit IN VARCHAR2 := FND_API.g_false,
82: p_validate_only IN VARCHAR2 := FND_API.g_true,
83: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
84: p_ci_type_usage_id IN NUMBER,
85: p_project_type_id IN NUMBER,
86: p_ci_type_id IN NUMBER,

Line 83: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

79: p_api_version IN NUMBER := 1.0,
80: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
81: p_commit IN VARCHAR2 := FND_API.g_false,
82: p_validate_only IN VARCHAR2 := FND_API.g_true,
83: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
84: p_ci_type_usage_id IN NUMBER,
85: p_project_type_id IN NUMBER,
86: p_ci_type_id IN NUMBER,
87: p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id,

Line 98: IF p_commit = FND_API.G_TRUE THEN

94: IS
95: BEGIN
96: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.UPDATE_CI_TYPE_USAGE');
97:
98: IF p_commit = FND_API.G_TRUE THEN
99: SAVEPOINT update_ci_type_usage;
100: END IF;
101:
102: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 102: IF p_init_msg_list = FND_API.G_TRUE THEN

98: IF p_commit = FND_API.G_TRUE THEN
99: SAVEPOINT update_ci_type_usage;
100: END IF;
101:
102: IF p_init_msg_list = FND_API.G_TRUE THEN
103: fnd_msg_pub.initialize;
104: END IF;
105:
106: x_return_status := 'S';

Line 110: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

106: x_return_status := 'S';
107: x_msg_count := 0;
108: x_msg_data := '';
109:
110: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
111: pa_ci_type_usage_pkg.update_row(
112: x_ci_type_usage_id => p_ci_type_usage_id,
113: x_project_type_id => p_project_type_id,
114: x_ci_type_id => p_ci_type_id,

Line 120: IF p_commit = fnd_api.g_true THEN

116: x_last_updated_by => p_last_updated_by,
117: x_last_update_login => p_last_update_login);
118: END IF;
119:
120: IF p_commit = fnd_api.g_true THEN
121: IF x_return_status = 'S' THEN
122: COMMIT;
123: ELSE
124: ROLLBACK TO update_ci_type_usage;

Line 135: IF p_commit = fnd_api.g_true THEN

131: pa_debug.reset_err_stack;
132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: IF p_commit = fnd_api.g_true THEN
136: ROLLBACK TO update_ci_type_usage;
137: END IF;
138:
139: x_return_status := 'U';

Line 150: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

146: END update_ci_type_usage;
147:
148: PROCEDURE delete_ci_type_usage (
149: p_api_version IN NUMBER := 1.0,
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
151: p_commit IN VARCHAR2 := FND_API.g_false,
152: p_validate_only IN VARCHAR2 := FND_API.g_true,
153: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
154: p_ci_type_usage_id IN NUMBER,

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

147:
148: PROCEDURE delete_ci_type_usage (
149: p_api_version IN NUMBER := 1.0,
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
151: p_commit IN VARCHAR2 := FND_API.g_false,
152: p_validate_only IN VARCHAR2 := FND_API.g_true,
153: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
154: p_ci_type_usage_id IN NUMBER,
155: p_project_type_id IN NUMBER,

Line 152: p_validate_only IN VARCHAR2 := FND_API.g_true,

148: PROCEDURE delete_ci_type_usage (
149: p_api_version IN NUMBER := 1.0,
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
151: p_commit IN VARCHAR2 := FND_API.g_false,
152: p_validate_only IN VARCHAR2 := FND_API.g_true,
153: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
154: p_ci_type_usage_id IN NUMBER,
155: p_project_type_id IN NUMBER,
156: p_ci_type_id IN NUMBER,

Line 153: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

149: p_api_version IN NUMBER := 1.0,
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
151: p_commit IN VARCHAR2 := FND_API.g_false,
152: p_validate_only IN VARCHAR2 := FND_API.g_true,
153: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
154: p_ci_type_usage_id IN NUMBER,
155: p_project_type_id IN NUMBER,
156: p_ci_type_id IN NUMBER,
157: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 166: IF p_commit = FND_API.G_TRUE THEN

162: l_temp VARCHAR2(1);
163: BEGIN
164: pa_debug.set_err_stack ('PA_CI_TYPE_USAGE_PVT.DELETE_CI_TYPE_USAGE');
165:
166: IF p_commit = FND_API.G_TRUE THEN
167: SAVEPOINT delete_ci_type_usage;
168: END IF;
169:
170: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 170: IF p_init_msg_list = FND_API.G_TRUE THEN

166: IF p_commit = FND_API.G_TRUE THEN
167: SAVEPOINT delete_ci_type_usage;
168: END IF;
169:
170: IF p_init_msg_list = FND_API.G_TRUE THEN
171: fnd_msg_pub.initialize;
172: END IF;
173:
174: x_return_status := 'S';

Line 184: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

180: x_ci_type_usage_id => p_ci_type_usage_id,
181: x_project_type_id => p_project_type_id,
182: x_ci_type_id => p_ci_type_id);
183:
184: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
185: pa_ci_type_usage_pkg.delete_row(
186: x_ci_type_usage_id => p_ci_type_usage_id);
187: END IF;
188:

Line 189: IF p_commit = fnd_api.g_true THEN

185: pa_ci_type_usage_pkg.delete_row(
186: x_ci_type_usage_id => p_ci_type_usage_id);
187: END IF;
188:
189: IF p_commit = fnd_api.g_true THEN
190: IF x_return_status = 'S' THEN
191: COMMIT;
192: ELSE
193: ROLLBACK TO delete_ci_type_usage;

Line 204: IF p_commit = fnd_api.g_true THEN

200: pa_debug.reset_err_stack;
201:
202: EXCEPTION
203: WHEN OTHERS THEN
204: IF p_commit = fnd_api.g_true THEN
205: ROLLBACK TO delete_ci_type_usage;
206: END IF;
207:
208: x_return_status := 'U';