APPS.JTF_TASK_DATES_PVT dependencies on JTF_TASK_DATES

Line 1: PACKAGE BODY jtf_task_dates_pvt AS

1: PACKAGE BODY jtf_task_dates_pvt AS
2: /* $Header: jtfvtkdb.pls 115.19 2002/12/04 23:59:04 cjang ship $ */
3: g_pkg_name constant VARCHAR2(30) := 'CREATE_DATES_PVT';
4:
5: PROCEDURE create_task_dates (

Line 37: l_task_date_id jtf_task_dates.task_date_id%TYPE;

33: IS
34: l_api_version CONSTANT NUMBER := 1.0;
35: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_DATES';
36:
37: l_task_date_id jtf_task_dates.task_date_id%TYPE;
38: l_rowid ROWID;
39:
40: CURSOR c_jtf_task_dates (
41: l_rowid IN ROWID

Line 40: CURSOR c_jtf_task_dates (

36:
37: l_task_date_id jtf_task_dates.task_date_id%TYPE;
38: l_rowid ROWID;
39:
40: CURSOR c_jtf_task_dates (
41: l_rowid IN ROWID
42: )
43: IS
44: SELECT 1

Line 45: FROM jtf_task_dates

41: l_rowid IN ROWID
42: )
43: IS
44: SELECT 1
45: FROM jtf_task_dates
46: WHERE ROWID = l_rowid;
47:
48: x CHAR;
49: BEGIN

Line 67: SELECT jtf_task_dates_s.nextval

63: END IF;
64:
65: x_return_status := fnd_api.g_ret_sts_success;
66:
67: SELECT jtf_task_dates_s.nextval
68: INTO l_task_date_id
69: FROM dual;
70:
71:

Line 72: jtf_task_dates_pkg.insert_row (

68: INTO l_task_date_id
69: FROM dual;
70:
71:
72: jtf_task_dates_pkg.insert_row (
73: x_rowid => l_rowid,
74: x_task_date_id => l_task_date_id,
75: x_task_id => p_task_id,
76: x_date_type_id => p_date_type_id,

Line 101: OPEN c_jtf_task_dates (l_rowid);

97: x_last_updated_by => jtf_task_utl.updated_by,
98: x_last_update_login => jtf_task_utl.login_id
99: );
100:
101: OPEN c_jtf_task_dates (l_rowid);
102: FETCH c_jtf_task_dates INTO x;
103:
104: IF c_jtf_task_dates%NOTFOUND
105: THEN

Line 102: FETCH c_jtf_task_dates INTO x;

98: x_last_update_login => jtf_task_utl.login_id
99: );
100:
101: OPEN c_jtf_task_dates (l_rowid);
102: FETCH c_jtf_task_dates INTO x;
103:
104: IF c_jtf_task_dates%NOTFOUND
105: THEN
106: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 104: IF c_jtf_task_dates%NOTFOUND

100:
101: OPEN c_jtf_task_dates (l_rowid);
102: FETCH c_jtf_task_dates INTO x;
103:
104: IF c_jtf_task_dates%NOTFOUND
105: THEN
106: x_return_status := fnd_api.g_ret_sts_unexp_error;
107: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_DATE');
108: fnd_msg_pub.add;

Line 170: l_date_value jtf_task_dates.date_value%TYPE := p_date_value;

166: l_api_version CONSTANT NUMBER := 1.0;
167: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DATES';
168: l_task_id jtf_tasks_b.task_id%TYPE ;
169: l_date_type_id jtf_task_date_types_b.date_type_id%TYPE := p_date_type_id;
170: l_date_value jtf_task_dates.date_value%TYPE := p_date_value;
171: l_task_date_id jtf_task_dates.task_date_id%TYPE := p_task_date_id;
172:
173: CURSOR c_update_task_dates
174: IS

Line 171: l_task_date_id jtf_task_dates.task_date_id%TYPE := p_task_date_id;

167: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DATES';
168: l_task_id jtf_tasks_b.task_id%TYPE ;
169: l_date_type_id jtf_task_date_types_b.date_type_id%TYPE := p_date_type_id;
170: l_date_value jtf_task_dates.date_value%TYPE := p_date_value;
171: l_task_date_id jtf_task_dates.task_date_id%TYPE := p_task_date_id;
172:
173: CURSOR c_update_task_dates
174: IS
175: SELECT task_id,

Line 194: FROM jtf_task_dates

190: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
191: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
192: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
193: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
194: FROM jtf_task_dates
195: WHERE task_date_id = p_task_date_id;
196:
197: task_dates c_update_task_dates%ROWTYPE;
198: BEGIN

Line 244: jtf_task_dates_pub.lock_task_dates

240: END IF;
241:
242: l_task_id := task_dates.task_id;
243:
244: jtf_task_dates_pub.lock_task_dates
245: ( P_API_VERSION => 1.0 ,
246: P_INIT_MSG_LIST => fnd_api.g_false ,
247: P_COMMIT => fnd_api.g_false ,
248: P_TASK_date_ID => l_task_date_id ,

Line 263: jtf_task_dates_pkg.update_row (

259: RAISE fnd_api.g_exc_unexpected_error;
260: END IF;
261:
262:
263: jtf_task_dates_pkg.update_row (
264: x_task_date_id => l_task_date_id,
265: x_object_version_number => p_object_version_number + 1,
266: x_task_id => l_task_id,
267: x_date_type_id => l_date_type_id,

Line 356: jtf_task_dates_pub.lock_task_dates

352:
353:
354: x_return_status := fnd_api.g_ret_sts_success;
355:
356: jtf_task_dates_pub.lock_task_dates
357: ( P_API_VERSION => 1.0 ,
358: P_INIT_MSG_LIST => fnd_api.g_false ,
359: P_COMMIT => fnd_api.g_false ,
360: P_TASK_date_ID => p_task_date_id ,

Line 374: jtf_task_dates_pkg.delete_row (x_task_date_id => p_task_date_id);

370: END IF;
371:
372:
373:
374: jtf_task_dates_pkg.delete_row (x_task_date_id => p_task_date_id);
375:
376: IF fnd_api.to_boolean (p_commit)
377: THEN
378: COMMIT WORK;