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_TASK_UTL dependencies on JTF_TASKS_B

Line 28: FROM jtf_tasks_b esc

24: BEGIN
25: SELECT jtf_task_utl.get_owner (esc.owner_type_code, esc.owner_id)
26: INTO
27: l_owner
28: FROM jtf_tasks_b esc
29: WHERE task_id IN (SELECT task_id
30: FROM jtf_task_references_b
31: WHERE object_id = p_task_id
32: AND object_type_code = 'TASK'

Line 49: FROM jtf_tasks_b, fnd_lookups lookups

45: l_meaning VARCHAR2(30);
46: BEGIN
47: SELECT lookups.meaning
48: INTO l_meaning
49: FROM jtf_tasks_b, fnd_lookups lookups
50: WHERE task_id IN (SELECT task_id
51: FROM jtf_task_references_b
52: WHERE object_id = p_task_id
53: AND object_type_code = 'TASK'

Line 57: AND lookups.lookup_code = jtf_tasks_b.escalation_level;

53: AND object_type_code = 'TASK'
54: AND reference_code = 'ESC')
55: AND task_type_id = 22
56: AND lookups.lookup_type = 'JTF_TASK_ESC_LEVEL'
57: AND lookups.lookup_code = jtf_tasks_b.escalation_level;
58: RETURN l_meaning;
59: EXCEPTION
60: WHEN OTHERS
61: THEN

Line 333: IF p_owner_table_name = 'JTF_TASKS_B'

329: FROM jtf_task_contacts
330: WHERE task_contact_id = p_contact_id;
331: END IF;
332:
333: IF p_owner_table_name = 'JTF_TASKS_B'
334: THEN
335: l_contact_type_code := 'CUST';
336: END IF;
337:

Line 370: FROM jtf_tasks_b

366: SELECT 1
367: INTO x
368: FROM jtf_party_cont_points_v
369: WHERE party_id = (SELECT customer_id
370: FROM jtf_tasks_b
371: WHERE task_id = p_contact_id)
372: AND contact_point_id = p_phone_id
373: AND status = 'A'
374: AND ROWNUM < 2;

Line 420: l_object_code jtf_tasks_b.source_object_type_code%TYPE

416: l_id_column jtf_objects_b.select_id%TYPE;
417: l_name_column jtf_objects_b.select_name%TYPE;
418: l_from_clause jtf_objects_b.from_table%TYPE;
419: l_where_clause jtf_objects_b.where_clause%TYPE;
420: l_object_code jtf_tasks_b.source_object_type_code%TYPE
421: := p_object_type_code;
422: l_object_name VARCHAR2(2000);
423: l_object_id jtf_tasks_b.source_object_id%TYPE
424: := p_object_id;

Line 423: l_object_id jtf_tasks_b.source_object_id%TYPE

419: l_where_clause jtf_objects_b.where_clause%TYPE;
420: l_object_code jtf_tasks_b.source_object_type_code%TYPE
421: := p_object_type_code;
422: l_object_name VARCHAR2(2000);
423: l_object_id jtf_tasks_b.source_object_id%TYPE
424: := p_object_id;
425: is_null BOOLEAN := FALSE;
426: is_not_null BOOLEAN := FALSE;
427: sql_stmt VARCHAR2(2000);

Line 493: FROM jtf_tasks_b

489: SELECT 1
490: INTO x
491: FROM jtf_party_all_contacts_v contacts
492: WHERE contacts.object_party_id = (SELECT customer_id
493: FROM jtf_tasks_b
494: WHERE task_id = p_task_id)
495: AND p_contact_id in (contacts.subject_party_id, contacts.party_id)
496: AND ROWNUM < 2;
497: END;

Line 1034: FROM jtf_tasks_b

1030: IS
1031: CURSOR c_task_object_details
1032: IS
1033: SELECT source_object_type_code
1034: FROM jtf_tasks_b
1035: WHERE task_id = p_task_id;
1036:
1037: CURSOR c_template_object_details
1038: IS

Line 1347: l_object_code jtf_tasks_b.source_object_type_code%TYPE

1343: l_id_column jtf_objects_b.select_id%TYPE;
1344: l_name_column jtf_objects_b.select_name%TYPE;
1345: l_from_clause jtf_objects_b.from_table%TYPE;
1346: l_where_clause jtf_objects_b.where_clause%TYPE;
1347: l_object_code jtf_tasks_b.source_object_type_code%TYPE
1348: := p_object_code;
1349: --Fix bug 2430516, when EXECUTE IMMEDIATE sql_stmt below, the length of
1350: --l_object_name could exceed 80 chars
1351: --l_object_name jtf_tasks_b.source_object_name%TYPE

Line 1351: --l_object_name jtf_tasks_b.source_object_name%TYPE

1347: l_object_code jtf_tasks_b.source_object_type_code%TYPE
1348: := p_object_code;
1349: --Fix bug 2430516, when EXECUTE IMMEDIATE sql_stmt below, the length of
1350: --l_object_name could exceed 80 chars
1351: --l_object_name jtf_tasks_b.source_object_name%TYPE
1352: l_object_name VARCHAR2(2000)
1353: := p_object_name;
1354: l_object_id jtf_tasks_b.source_object_id%TYPE
1355: := p_object_id;

Line 1354: l_object_id jtf_tasks_b.source_object_id%TYPE

1350: --l_object_name could exceed 80 chars
1351: --l_object_name jtf_tasks_b.source_object_name%TYPE
1352: l_object_name VARCHAR2(2000)
1353: := p_object_name;
1354: l_object_id jtf_tasks_b.source_object_id%TYPE
1355: := p_object_id;
1356: /************* Comment out (Bug 2118130) *****************************
1357: --is_null BOOLEAN := FALSE;
1358: --is_not_null BOOLEAN := FALSE;

Line 1517: FROM jtf_tasks_b

1513: IS
1514: CURSOR c_task_id
1515: IS
1516: SELECT task_id
1517: FROM jtf_tasks_b
1518: WHERE task_id = p_task_id;
1519:
1520: CURSOR c_task_number
1521: IS

Line 1523: FROM jtf_tasks_b

1519:
1520: CURSOR c_task_number
1521: IS
1522: SELECT task_id
1523: FROM jtf_tasks_b
1524: WHERE task_number = p_task_number;
1525:
1526: l_task_id jtf_tasks_b.task_id%TYPE;
1527: l_task_number jtf_tasks_b.task_number%TYPE;

Line 1526: l_task_id jtf_tasks_b.task_id%TYPE;

1522: SELECT task_id
1523: FROM jtf_tasks_b
1524: WHERE task_number = p_task_number;
1525:
1526: l_task_id jtf_tasks_b.task_id%TYPE;
1527: l_task_number jtf_tasks_b.task_number%TYPE;
1528: l_task_name jtf_tasks_vl.task_name%TYPE;
1529: done BOOLEAN := FALSE;
1530: BEGIN

Line 1527: l_task_number jtf_tasks_b.task_number%TYPE;

1523: FROM jtf_tasks_b
1524: WHERE task_number = p_task_number;
1525:
1526: l_task_id jtf_tasks_b.task_id%TYPE;
1527: l_task_number jtf_tasks_b.task_number%TYPE;
1528: l_task_name jtf_tasks_vl.task_name%TYPE;
1529: done BOOLEAN := FALSE;
1530: BEGIN
1531: x_return_status := fnd_api.g_ret_sts_success;

Line 1583: l_task_id jtf_tasks_b.task_id%TYPE;

1579: SELECT task_template_id task_id
1580: FROM jtf_task_templates_b
1581: WHERE task_number = p_task_number;
1582:
1583: l_task_id jtf_tasks_b.task_id%TYPE;
1584: l_task_number jtf_tasks_b.task_number%TYPE;
1585: l_task_name jtf_tasks_vl.task_name%TYPE;
1586: done BOOLEAN := FALSE;
1587: BEGIN

Line 1584: l_task_number jtf_tasks_b.task_number%TYPE;

1580: FROM jtf_task_templates_b
1581: WHERE task_number = p_task_number;
1582:
1583: l_task_id jtf_tasks_b.task_id%TYPE;
1584: l_task_number jtf_tasks_b.task_number%TYPE;
1585: l_task_name jtf_tasks_vl.task_name%TYPE;
1586: done BOOLEAN := FALSE;
1587: BEGIN
1588: x_return_status := fnd_api.g_ret_sts_success;

Line 2253: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;

2249: l_id_column jtf_objects_b.select_id%TYPE;
2250: l_from_clause jtf_objects_b.from_table%TYPE;
2251: l_where_clause jtf_objects_b.where_clause%TYPE;
2252: sql_stmt VARCHAR2(4000);
2253: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
2254:
2255: CURSOR c_owner_type
2256: IS
2257:

Line 2429: l_p_source_object_code jtf_tasks_b.source_object_type_code%TYPE;

2425: p_source_object_id IN NUMBER,
2426: x_return_status OUT NOCOPY VARCHAR2
2427: )
2428: IS
2429: l_p_source_object_code jtf_tasks_b.source_object_type_code%TYPE;
2430: l_source_object_code jtf_tasks_b.source_object_type_code%TYPE
2431: := p_source_object_code;
2432: l_parent_task_id jtf_tasks_b.task_id%TYPE
2433: := p_parent_task_id;

Line 2430: l_source_object_code jtf_tasks_b.source_object_type_code%TYPE

2426: x_return_status OUT NOCOPY VARCHAR2
2427: )
2428: IS
2429: l_p_source_object_code jtf_tasks_b.source_object_type_code%TYPE;
2430: l_source_object_code jtf_tasks_b.source_object_type_code%TYPE
2431: := p_source_object_code;
2432: l_parent_task_id jtf_tasks_b.task_id%TYPE
2433: := p_parent_task_id;
2434: l_source_object_id jtf_tasks_b.source_object_id%TYPE

Line 2432: l_parent_task_id jtf_tasks_b.task_id%TYPE

2428: IS
2429: l_p_source_object_code jtf_tasks_b.source_object_type_code%TYPE;
2430: l_source_object_code jtf_tasks_b.source_object_type_code%TYPE
2431: := p_source_object_code;
2432: l_parent_task_id jtf_tasks_b.task_id%TYPE
2433: := p_parent_task_id;
2434: l_source_object_id jtf_tasks_b.source_object_id%TYPE
2435: := p_source_object_id;
2436: l_p_source_object_id jtf_tasks_b.source_object_id%TYPE;

Line 2434: l_source_object_id jtf_tasks_b.source_object_id%TYPE

2430: l_source_object_code jtf_tasks_b.source_object_type_code%TYPE
2431: := p_source_object_code;
2432: l_parent_task_id jtf_tasks_b.task_id%TYPE
2433: := p_parent_task_id;
2434: l_source_object_id jtf_tasks_b.source_object_id%TYPE
2435: := p_source_object_id;
2436: l_p_source_object_id jtf_tasks_b.source_object_id%TYPE;
2437: BEGIN
2438: x_return_status := fnd_api.g_ret_sts_success;

Line 2436: l_p_source_object_id jtf_tasks_b.source_object_id%TYPE;

2432: l_parent_task_id jtf_tasks_b.task_id%TYPE
2433: := p_parent_task_id;
2434: l_source_object_id jtf_tasks_b.source_object_id%TYPE
2435: := p_source_object_id;
2436: l_p_source_object_id jtf_tasks_b.source_object_id%TYPE;
2437: BEGIN
2438: x_return_status := fnd_api.g_ret_sts_success;
2439: SELECT source_object_type_code, source_object_id
2440: INTO l_p_source_object_code, l_p_source_object_id

Line 2441: FROM jtf_tasks_b

2437: BEGIN
2438: x_return_status := fnd_api.g_ret_sts_success;
2439: SELECT source_object_type_code, source_object_id
2440: INTO l_p_source_object_code, l_p_source_object_id
2441: FROM jtf_tasks_b
2442: WHERE task_id = p_parent_task_id;
2443:
2444: IF ( l_p_source_object_code IS NOT NULL
2445: AND l_source_object_code IS NULL)

Line 2467: FROM jtf_tasks_b

2463: END IF;
2464:
2465: SELECT source_object_id
2466: INTO l_p_source_object_id
2467: FROM jtf_tasks_b
2468: WHERE task_id = p_parent_task_id;
2469:
2470: IF ( l_p_source_object_id IS NOT NULL
2471: AND l_source_object_id IS NULL)

Line 2508: l_notification_flag jtf_tasks_b.notification_flag%TYPE

2504: p_notification_period_uom IN VARCHAR2,
2505: x_return_status OUT NOCOPY VARCHAR2
2506: )
2507: IS
2508: l_notification_flag jtf_tasks_b.notification_flag%TYPE
2509: := p_notification_flag;
2510: l_period jtf_tasks_b.notification_period%TYPE
2511: := p_notification_period;
2512: l_period_uom jtf_tasks_b.notification_period_uom%TYPE

Line 2510: l_period jtf_tasks_b.notification_period%TYPE

2506: )
2507: IS
2508: l_notification_flag jtf_tasks_b.notification_flag%TYPE
2509: := p_notification_flag;
2510: l_period jtf_tasks_b.notification_period%TYPE
2511: := p_notification_period;
2512: l_period_uom jtf_tasks_b.notification_period_uom%TYPE
2513: := p_notification_period_uom;
2514: BEGIN

Line 2512: l_period_uom jtf_tasks_b.notification_period_uom%TYPE

2508: l_notification_flag jtf_tasks_b.notification_flag%TYPE
2509: := p_notification_flag;
2510: l_period jtf_tasks_b.notification_period%TYPE
2511: := p_notification_period;
2512: l_period_uom jtf_tasks_b.notification_period_uom%TYPE
2513: := p_notification_period_uom;
2514: BEGIN
2515: x_return_status := fnd_api.g_ret_sts_success;
2516: jtf_task_utl.validate_flag (

Line 2589: l_alarm_start jtf_tasks_b.alarm_start%TYPE

2585: )
2586: IS
2587: is_null BOOLEAN := FALSE;
2588: is_not_null BOOLEAN := FALSE;
2589: l_alarm_start jtf_tasks_b.alarm_start%TYPE
2590: := p_alarm_start;
2591: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE
2592: := p_alarm_start_uom;
2593: l_alarm_on jtf_tasks_b.alarm_on%TYPE

Line 2591: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE

2587: is_null BOOLEAN := FALSE;
2588: is_not_null BOOLEAN := FALSE;
2589: l_alarm_start jtf_tasks_b.alarm_start%TYPE
2590: := p_alarm_start;
2591: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE
2592: := p_alarm_start_uom;
2593: l_alarm_on jtf_tasks_b.alarm_on%TYPE
2594: := p_alarm_on;
2595: l_alarm_count jtf_tasks_b.alarm_count%TYPE

Line 2593: l_alarm_on jtf_tasks_b.alarm_on%TYPE

2589: l_alarm_start jtf_tasks_b.alarm_start%TYPE
2590: := p_alarm_start;
2591: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE
2592: := p_alarm_start_uom;
2593: l_alarm_on jtf_tasks_b.alarm_on%TYPE
2594: := p_alarm_on;
2595: l_alarm_count jtf_tasks_b.alarm_count%TYPE
2596: := p_alarm_count;
2597: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE

Line 2595: l_alarm_count jtf_tasks_b.alarm_count%TYPE

2591: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE
2592: := p_alarm_start_uom;
2593: l_alarm_on jtf_tasks_b.alarm_on%TYPE
2594: := p_alarm_on;
2595: l_alarm_count jtf_tasks_b.alarm_count%TYPE
2596: := p_alarm_count;
2597: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE
2598: := p_alarm_interval;
2599: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE

Line 2597: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE

2593: l_alarm_on jtf_tasks_b.alarm_on%TYPE
2594: := p_alarm_on;
2595: l_alarm_count jtf_tasks_b.alarm_count%TYPE
2596: := p_alarm_count;
2597: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE
2598: := p_alarm_interval;
2599: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE
2600: := p_alarm_interval_uom;
2601: ----

Line 2599: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE

2595: l_alarm_count jtf_tasks_b.alarm_count%TYPE
2596: := p_alarm_count;
2597: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE
2598: := p_alarm_interval;
2599: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE
2600: := p_alarm_interval_uom;
2601: ----
2602: ---- This api validates the alarm parameters for the task.
2603: ----

Line 3067: FROM jtf_tasks_b task

3063: IF p_task_id IS NOT NULL
3064: THEN
3065: SELECT task_number
3066: INTO l_task_number
3067: FROM jtf_tasks_b task
3068: WHERE task_id = p_task_id ;
3069: END IF;
3070:
3071: RETURN l_task_number;

Line 3114: IF p_owner_table_name NOT IN ('JTF_TASKS_B', 'JTF_TASK_CONTACTS')

3110: x_return_status := fnd_api.g_ret_sts_success;
3111:
3112: IF p_owner_table_name IS NOT NULL
3113: THEN
3114: IF p_owner_table_name NOT IN ('JTF_TASKS_B', 'JTF_TASK_CONTACTS')
3115: THEN
3116: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE_TABLE');
3117: fnd_msg_pub.add;
3118: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3177: l_private_flag jtf_tasks_b.private_flag%TYPE default null;

3173: l_resource_type_code varchar2(30);
3174: l_owner_id number;
3175: l_owner_type_code varchar2(30);
3176: l_privilege varchar2(30) default null;
3177: l_private_flag jtf_tasks_b.private_flag%TYPE default null;
3178:
3179:
3180: BEGIN
3181:

Line 3189: FROM jtf_tasks_b

3185:
3186: -- select the owner info from task table for this task id
3187: SELECT owner_id, owner_type_code, private_flag
3188: INTO l_owner_id, l_owner_type_code, l_private_flag
3189: FROM jtf_tasks_b
3190: WHERE task_id = p_task_id;
3191:
3192:
3193: -- user's id and type

Line 3290: FROM jtf_tasks_b

3286:
3287: -- select the owner info from task table for this task id
3288: CURSOR c_task_owner IS
3289: SELECT owner_id, owner_type_code, private_flag
3290: FROM jtf_tasks_b
3291: WHERE task_id = p_task_id;
3292:
3293: rec_task_owner c_task_owner%ROWTYPE;
3294:

Line 3824: FUNCTION check_duplicate_reference (p_task_id jtf_tasks_b.task_id%type,

3820: end;
3821: -------------
3822: -------------
3823: -- Function added for Enhancement # 2102281
3824: FUNCTION check_duplicate_reference (p_task_id jtf_tasks_b.task_id%type,
3825: p_object_id hz_relationships.object_id%type,
3826: p_object_type_code jtf_task_references_b.object_type_code%type)
3827: return boolean
3828: is

Line 3855: FUNCTION check_reference_delete (p_task_id jtf_tasks_b.task_id%type,

3851:
3852: -------------
3853: -------------
3854: -- Function added for Enhancement # 2102281
3855: FUNCTION check_reference_delete (p_task_id jtf_tasks_b.task_id%type,
3856: p_object_id hz_relationships.object_id%type)
3857: return boolean
3858: is
3859:

Line 3879: from jtf_tasks_b

3875: begin
3876:
3877: select 'Exists' into l_dummy from hz_relationships
3878: where party_id in (select customer_id id
3879: from jtf_tasks_b
3880: where task_id = p_task_id)
3881: and subject_id = p_object_id;
3882:
3883: l_delete_status := false;

Line 3968: from jtf_tasks_b

3964: */
3965:
3966: select 'Exists' into l_dummy from hz_relationships
3967: where party_id in (select source_object_id
3968: from jtf_tasks_b
3969: where task_id = p_task_id)
3970: and subject_id = p_object_id;
3971:
3972: l_delete_status := false;

Line 4029: from jtf_tasks_b

4025: */
4026:
4027: select 'Party exists' into l_dummy from hz_parties
4028: where party_id in (select source_object_id
4029: from jtf_tasks_b
4030: where task_id = p_task_id
4031: and source_object_id = p_object_id);
4032:
4033: l_delete_status := false;

Line 4053: from jtf_tasks_b

4049: begin
4050:
4051: select 'party exists' into l_dummy from hz_parties
4052: where party_id = (select customer_id
4053: from jtf_tasks_b
4054: where task_id = p_task_id
4055: and customer_id = p_object_id);
4056:
4057:

Line 4128: l_task_type jtf_tasks_b.task_type_id%type;

4124: l_object_id hz_parties.party_id%type;
4125: l_subject_id hz_parties.party_id%type;
4126: l_party_name hz_parties.party_name%type;
4127: l_party_type hz_parties.party_type%type;
4128: l_task_type jtf_tasks_b.task_type_id%type;
4129: l_api_version CONSTANT NUMBER := 1.0;
4130:
4131: cursor c_type (b_task_id jtf_tasks_b.task_id%type) is
4132: select task_type_id

Line 4131: cursor c_type (b_task_id jtf_tasks_b.task_id%type) is

4127: l_party_type hz_parties.party_type%type;
4128: l_task_type jtf_tasks_b.task_type_id%type;
4129: l_api_version CONSTANT NUMBER := 1.0;
4130:
4131: cursor c_type (b_task_id jtf_tasks_b.task_id%type) is
4132: select task_type_id
4133: from jtf_tasks_b
4134: where task_id = b_task_id;
4135:

Line 4133: from jtf_tasks_b

4129: l_api_version CONSTANT NUMBER := 1.0;
4130:
4131: cursor c_type (b_task_id jtf_tasks_b.task_id%type) is
4132: select task_type_id
4133: from jtf_tasks_b
4134: where task_id = b_task_id;
4135:
4136: cursor c_party (b_party_id hz_parties.party_id%type) is
4137: select party_name,

Line 4343: l_task_type jtf_tasks_b.task_type_id%type;

4339: l_object_version jtf_task_references_b.object_version_number%type;
4340: l_object_id hz_parties.party_id%type;
4341: l_subject_id hz_parties.party_id%type;
4342: l_party_type hz_parties.party_type%type;
4343: l_task_type jtf_tasks_b.task_type_id%type;
4344: l_api_version CONSTANT NUMBER := 1.0;
4345:
4346: cursor c_type (b_task_id jtf_tasks_b.task_id%type) is
4347: select task_type_id

Line 4346: cursor c_type (b_task_id jtf_tasks_b.task_id%type) is

4342: l_party_type hz_parties.party_type%type;
4343: l_task_type jtf_tasks_b.task_type_id%type;
4344: l_api_version CONSTANT NUMBER := 1.0;
4345:
4346: cursor c_type (b_task_id jtf_tasks_b.task_id%type) is
4347: select task_type_id
4348: from jtf_tasks_b
4349: where task_id = b_task_id;
4350:

Line 4348: from jtf_tasks_b

4344: l_api_version CONSTANT NUMBER := 1.0;
4345:
4346: cursor c_type (b_task_id jtf_tasks_b.task_id%type) is
4347: select task_type_id
4348: from jtf_tasks_b
4349: where task_id = b_task_id;
4350:
4351: cursor c_party (b_party_id hz_parties.party_id%type) is
4352: select party_type

Line 4363: cursor c_reference (b_task_id jtf_tasks_b.task_id%type,

4359: from hz_relationships
4360: where party_id = b_relation_id
4361: and directional_flag = 'F' ;
4362:
4363: cursor c_reference (b_task_id jtf_tasks_b.task_id%type,
4364: b_party_id hz_parties.party_id%type) is
4365: select task_reference_id,
4366: object_version_number
4367: from jtf_task_references_b

Line 4633: l_object_code jtf_tasks_b.source_object_type_code%TYPE

4629: l_id_column jtf_objects_b.select_id%TYPE;
4630: l_details_column jtf_objects_b.select_details%TYPE;
4631: l_from_clause jtf_objects_b.from_table%TYPE;
4632: l_where_clause jtf_objects_b.where_clause%TYPE;
4633: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4634: := p_object_type_code;
4635: l_object_details VARCHAR2(2000);
4636: is_null BOOLEAN := FALSE;
4637: is_not_null BOOLEAN := FALSE;