APPS.JTF_TASK_DATES_PUB dependencies on JTF_TASK_DATES

Line 1: PACKAGE BODY jtf_task_dates_pub AS

1: PACKAGE BODY jtf_task_dates_pub AS
2: /* $Header: jtfptkdb.pls 115.20 2002/12/06 01:21:45 sachoudh ship $ */
3: g_pkg_name VARCHAR2(30) := 'CREATE_DATES_PUB';
4:
5: PROCEDURE create_task_dates (

Line 42: l_task_date_id jtf_task_dates.task_date_id%TYPE;

38: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
39: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
40: l_date_type_id jtf_task_date_types_b.date_type_id%TYPE := p_date_type_id;
41: l_date_type_name jtf_task_date_types_tl.date_type%TYPE := p_date_type_name;
42: l_task_date_id jtf_task_dates.task_date_id%TYPE;
43: l_rowid ROWID;
44:
45: CURSOR c_jtf_task_dates (
46: l_rowid IN ROWID

Line 45: CURSOR c_jtf_task_dates (

41: l_date_type_name jtf_task_date_types_tl.date_type%TYPE := p_date_type_name;
42: l_task_date_id jtf_task_dates.task_date_id%TYPE;
43: l_rowid ROWID;
44:
45: CURSOR c_jtf_task_dates (
46: l_rowid IN ROWID
47: )
48: IS
49: SELECT 1

Line 50: FROM jtf_task_dates

46: l_rowid IN ROWID
47: )
48: IS
49: SELECT 1
50: FROM jtf_task_dates
51: WHERE ROWID = l_rowid;
52:
53: x CHAR;
54: BEGIN

Line 119: jtf_task_dates_pvt.create_task_dates (

115: fnd_msg_pub.add;
116: RAISE fnd_api.g_exc_unexpected_error;
117: END IF;
118:
119: jtf_task_dates_pvt.create_task_dates (
120: p_api_version => 1.0,
121: p_init_msg_list => fnd_api.g_false,
122: p_commit => fnd_api.g_false,
123: p_task_id => l_task_id,

Line 204: jtf_task_dates_pkg.lock_row(

200: END IF;
201:
202: x_return_status := fnd_api.g_ret_sts_success;
203:
204: jtf_task_dates_pkg.lock_row(
205: x_task_date_id => p_task_date_id ,
206: x_object_version_number => p_object_version_number );
207:
208:

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

264: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DATES';
265: l_task_id jtf_tasks_b.task_id%TYPE ;
266: l_date_type_id jtf_task_date_types_b.date_type_id%TYPE := p_date_type_id;
267: l_date_type_name jtf_task_date_types_tl.date_type%TYPE := p_date_type_name;
268: l_date_value jtf_task_dates.date_value%TYPE := p_date_value;
269: l_task_date_id jtf_task_dates.task_date_id%TYPE := p_task_date_id;
270:
271: CURSOR c_update_task_dates
272: IS

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

265: l_task_id jtf_tasks_b.task_id%TYPE ;
266: l_date_type_id jtf_task_date_types_b.date_type_id%TYPE := p_date_type_id;
267: l_date_type_name jtf_task_date_types_tl.date_type%TYPE := p_date_type_name;
268: l_date_value jtf_task_dates.date_value%TYPE := p_date_value;
269: l_task_date_id jtf_task_dates.task_date_id%TYPE := p_task_date_id;
270:
271: CURSOR c_update_task_dates
272: IS
273: SELECT task_id,

Line 292: FROM jtf_task_dates

288: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
289: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
290: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
291: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
292: FROM jtf_task_dates
293: WHERE task_date_id = p_task_date_id;
294:
295: task_dates c_update_task_dates%ROWTYPE;
296: BEGIN

Line 382: jtf_task_dates_pub.lock_task_dates

378:
379: l_task_id := task_dates.task_id ;
380:
381:
382: jtf_task_dates_pub.lock_task_dates
383: ( P_API_VERSION => 1.0 ,
384: P_INIT_MSG_LIST => fnd_api.g_false ,
385: P_COMMIT => fnd_api.g_false ,
386: P_TASK_date_ID => l_task_date_id ,

Line 398: jtf_task_dates_pvt.update_task_dates (

394: x_return_status := fnd_api.g_ret_sts_unexp_error;
395: RAISE fnd_api.g_exc_unexpected_error;
396: END IF;
397:
398: jtf_task_dates_pvt.update_task_dates (
399: p_api_version => 1.0,
400: p_init_msg_list => fnd_api.g_false,
401: p_commit => fnd_api.g_false,
402: p_object_version_number => p_object_version_number ,

Line 482: jtf_task_dates_pub.lock_task_dates

478: THEN
479: fnd_msg_pub.initialize;
480: END IF;
481:
482: jtf_task_dates_pub.lock_task_dates
483: ( P_API_VERSION => 1.0 ,
484: P_INIT_MSG_LIST => fnd_api.g_false ,
485: P_COMMIT => fnd_api.g_false ,
486: P_TASK_date_ID => p_task_date_id ,

Line 498: jtf_task_dates_pvt.delete_task_dates (

494: x_return_status := fnd_api.g_ret_sts_unexp_error;
495: RAISE fnd_api.g_exc_unexpected_error;
496: END IF;
497:
498: jtf_task_dates_pvt.delete_task_dates (
499: p_api_version => 1.0,
500: p_init_msg_list => fnd_api.g_false,
501: p_commit => fnd_api.g_false,
502: p_object_version_number => p_object_version_number,