DBA Data[Home] [Help]

APPS.JTF_TASKS_PVT dependencies on JTF_TASKS_PUB

Line 1140: , p_task_table IN jtf_tasks_pub.task_table_type

1136:
1137: PROCEDURE export_file(
1138: p_path IN VARCHAR2
1139: , p_file_name IN VARCHAR2
1140: , p_task_table IN jtf_tasks_pub.task_table_type
1141: , x_return_status OUT NOCOPY VARCHAR2
1142: , x_msg_count OUT NOCOPY NUMBER
1143: , x_msg_data OUT NOCOPY VARCHAR2
1144: );

Line 1184: , p_sort_data IN jtf_tasks_pub.sort_data

1180: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1181: , p_ref_object_id IN NUMBER
1182: , p_ref_object_type_code IN VARCHAR2
1183: , p_task_name IN jtf_tasks_v.task_name%TYPE
1184: , p_sort_data IN jtf_tasks_pub.sort_data
1185: , p_start_pointer IN NUMBER
1186: , p_rec_wanted IN NUMBER
1187: , p_show_all IN VARCHAR2
1188: , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'

Line 1189: , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type

1185: , p_start_pointer IN NUMBER
1186: , p_rec_wanted IN NUMBER
1187: , p_show_all IN VARCHAR2
1188: , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
1189: , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type
1190: , x_total_retrieved OUT NOCOPY NUMBER
1191: , x_total_returned OUT NOCOPY NUMBER
1192: , x_return_status OUT NOCOPY VARCHAR2
1193: , x_msg_count OUT NOCOPY NUMBER

Line 1236: , p_sort_data IN jtf_tasks_pub.sort_data

1232: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1233: , p_ref_object_id IN NUMBER
1234: , p_ref_object_type_code IN VARCHAR2
1235: , p_task_name IN jtf_tasks_v.task_name%TYPE
1236: , p_sort_data IN jtf_tasks_pub.sort_data
1237: , p_start_pointer IN NUMBER
1238: , p_rec_wanted IN NUMBER
1239: , p_show_all IN VARCHAR2
1240: , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'

Line 1241: , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type

1237: , p_start_pointer IN NUMBER
1238: , p_rec_wanted IN NUMBER
1239: , p_show_all IN VARCHAR2
1240: , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
1241: , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type
1242: , x_total_retrieved OUT NOCOPY NUMBER
1243: , x_total_returned OUT NOCOPY NUMBER
1244: , x_return_status OUT NOCOPY VARCHAR2
1245: , x_msg_count OUT NOCOPY NUMBER

Line 1260: , p_sort_data IN jtf_tasks_pub.sort_data

1256: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
1257: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1258: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1259: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1260: , p_sort_data IN jtf_tasks_pub.sort_data
1261: , p_start_pointer IN NUMBER
1262: , p_rec_wanted IN NUMBER
1263: , p_show_all IN VARCHAR2 DEFAULT 'Y'
1264: , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'

Line 1265: , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type

1261: , p_start_pointer IN NUMBER
1262: , p_rec_wanted IN NUMBER
1263: , p_show_all IN VARCHAR2 DEFAULT 'Y'
1264: , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
1265: , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type
1266: , x_total_retrieved OUT NOCOPY NUMBER
1267: , x_total_returned OUT NOCOPY NUMBER
1268: , x_return_status OUT NOCOPY VARCHAR2
1269: , x_msg_count OUT NOCOPY NUMBER