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.JTA_SYNC_TASK_COMMON dependencies on JTA_SYNC_TASK

Line 1: PACKAGE BODY jta_sync_task_common AS

1: PACKAGE BODY jta_sync_task_common AS
2: /* $Header: jtavstcb.pls 120.2 2005/12/28 22:19:48 deeprao ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 287: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,

283: END IF;
284: END convert_recur_date_to_gmt;
285:
286: PROCEDURE process_exclusions (
287: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,
288: p_rec_rule_id IN NUMBER,
289: p_repeating_task_id IN NUMBER,
290: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
291: )

Line 290: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec

286: PROCEDURE process_exclusions (
287: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,
288: p_rec_rule_id IN NUMBER,
289: p_repeating_task_id IN NUMBER,
290: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
291: )
292: IS
293: i NUMBER := 0;
294: l_exclude_task_id NUMBER ;

Line 330: FROM jta_sync_task_mapping

326: IS
327: CURSOR c_synctask
328: IS
329: SELECT task_id
330: FROM jta_sync_task_mapping
331: WHERE task_sync_id = p_sync_id;
332:
333: l_task_id NUMBER;
334: BEGIN

Line 342: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.IS_THIS_NEW_TASK');

338: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
339: fnd_msg_pub.add;
340:
341: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
342: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.IS_THIS_NEW_TASK');
343: fnd_msg_pub.add;
344:
345: raise_application_error (-20100,jta_sync_common.get_messages);
346: END IF;

Line 388: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,

384: END count_excluded_tasks;
385:
386: FUNCTION check_for_exclusion (
387: p_sync_id IN NUMBER,
388: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,
389: p_calendar_start_date IN DATE,
390: p_client_time_zone_id IN NUMBER
391: )
392: RETURN BOOLEAN

Line 424: p_exclusion_rec IN jta_sync_task.exclusion_rec

420:
421: FUNCTION get_excluding_taskid (
422: p_sync_id IN NUMBER,
423: p_recurrence_rule_id IN NUMBER,
424: p_exclusion_rec IN jta_sync_task.exclusion_rec
425: )
426: RETURN NUMBER
427: IS
428: CURSOR c_recur_tasks (b_recurrence_rule_id NUMBER,

Line 515: FROM jta_sync_task_mapping

511: IS
512: CURSOR c_task_sync
513: IS
514: SELECT task_id
515: FROM jta_sync_task_mapping
516: WHERE task_sync_id = p_sync_id;
517:
518: l_task_id NUMBER;
519: BEGIN

Line 527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

523: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
524: fnd_msg_pub.add;
525:
526: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
528: fnd_msg_pub.add;
529:
530: raise_application_error (-20100,jta_sync_common.get_messages);
531:

Line 545: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

541: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
542: fnd_msg_pub.add;
543:
544: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
545: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
546: fnd_msg_pub.add;
547:
548: raise_application_error (-20100,jta_sync_common.get_messages);
549: ELSIF l_task_id IS NULL

Line 557: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

553: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
554: fnd_msg_pub.add;
555:
556: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_TASKID');
557: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
558: fnd_msg_pub.add;
559:
560: raise_application_error (-20100,jta_sync_common.get_messages);
561: END IF;

Line 589: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

585: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
586: fnd_msg_pub.add;
587:
588: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
589: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
590: fnd_msg_pub.add;
591:
592: raise_application_error (-20100,jta_sync_common.get_messages);
593: END IF;

Line 621: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_TIMEZONE_ID');

617: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
618: fnd_msg_pub.add;
619:
620: fnd_message.set_name('JTF', 'JTA_SYNC_TIMEZONEID_NOTFOUND');
621: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_TIMEZONE_ID');
622: fnd_msg_pub.add;
623:
624: raise_application_error (-20100,jta_sync_common.get_messages);
625:

Line 660: fnd_message.set_name('JTF', 'JTA_SYNC_TASK_OVN_NOTFOUND');

656:
657: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
658: fnd_msg_pub.add;
659:
660: fnd_message.set_name('JTF', 'JTA_SYNC_TASK_OVN_NOTFOUND');
661: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
662: fnd_msg_pub.add;
663:
664: raise_application_error (-20100,jta_sync_common.get_messages);

Line 661: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');

657: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
658: fnd_msg_pub.add;
659:
660: fnd_message.set_name('JTF', 'JTA_SYNC_TASK_OVN_NOTFOUND');
661: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
662: fnd_msg_pub.add;
663:
664: raise_application_error (-20100,jta_sync_common.get_messages);
665: END IF;

Line 693: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');

689: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
690: fnd_msg_pub.add;
691:
692: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMT_OVN_NOTFOUND');
693: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
694: fnd_msg_pub.add;
695:
696: raise_application_error (-20100,jta_sync_common.get_messages);
697: END IF;

Line 725: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_RESOURCE_DETAILS');

721: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
722: fnd_msg_pub.add;
723:
724: fnd_message.set_name('JTF', 'JTA_SYNC_RESOURCE_NOTFOUND');
725: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_RESOURCE_DETAILS');
726: fnd_msg_pub.add;
727:
728: raise_application_error (-20100,jta_sync_common.get_messages);
729: END IF;

Line 745: SELECT jta_sync_task_mapping_s.nextval

741: IF (p_operation = g_new)
742: THEN
743: IF x_task_sync_id IS NULL
744: THEN
745: SELECT jta_sync_task_mapping_s.nextval
746: INTO x_task_sync_id
747: FROM dual;
748: END IF;
749:

Line 750: jta_sync_task_map_pkg.insert_row (

746: INTO x_task_sync_id
747: FROM dual;
748: END IF;
749:
750: jta_sync_task_map_pkg.insert_row (
751: p_task_sync_id => x_task_sync_id,
752: p_task_id => p_task_id,
753: p_resource_id => jta_sync_task.g_login_resource_id
754: );

Line 753: p_resource_id => jta_sync_task.g_login_resource_id

749:
750: jta_sync_task_map_pkg.insert_row (
751: p_task_sync_id => x_task_sync_id,
752: p_task_id => p_task_id,
753: p_resource_id => jta_sync_task.g_login_resource_id
754: );
755: ELSIF p_operation = g_modify
756: THEN
757: jta_sync_task_map_pkg.update_row (

Line 757: jta_sync_task_map_pkg.update_row (

753: p_resource_id => jta_sync_task.g_login_resource_id
754: );
755: ELSIF p_operation = g_modify
756: THEN
757: jta_sync_task_map_pkg.update_row (
758: p_task_sync_id => x_task_sync_id,
759: p_task_id => p_task_id,
760: p_resource_id => jta_sync_task.g_login_resource_id
761: );

Line 760: p_resource_id => jta_sync_task.g_login_resource_id

756: THEN
757: jta_sync_task_map_pkg.update_row (
758: p_task_sync_id => x_task_sync_id,
759: p_task_id => p_task_id,
760: p_resource_id => jta_sync_task.g_login_resource_id
761: );
762: /* ELSIF p_operation = G_DELETE
763: THEN
764: jta_sync_task_map_pkg.delete_row (

Line 764: jta_sync_task_map_pkg.delete_row (

760: p_resource_id => jta_sync_task.g_login_resource_id
761: );
762: /* ELSIF p_operation = G_DELETE
763: THEN
764: jta_sync_task_map_pkg.delete_row (
765: p_task_sync_id => x_task_sync_id
766: );*/
767:
768: END IF;

Line 921: p_task_rec IN jta_sync_task.task_rec,

917: x_resources (res_index).resource_type := p_resource_type;
918: END get_group_resource;
919:
920: PROCEDURE get_alarm_mins (
921: p_task_rec IN jta_sync_task.task_rec,
922: x_alarm_mins OUT NOCOPY NUMBER
923: )
924: IS
925: l_alarm_days NUMBER;

Line 1022: p_task_rec IN jta_sync_task.task_rec,

1018: RETURN l_date;
1019: END convert_gmt_to_server;
1020:
1021: PROCEDURE convert_dates (
1022: p_task_rec IN jta_sync_task.task_rec,
1023: p_operation IN VARCHAR2, --CREATE OR UPDATE
1024: x_planned_start OUT NOCOPY DATE,
1025: x_planned_end OUT NOCOPY DATE,
1026: x_scheduled_start OUT NOCOPY DATE,

Line 1085: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec

1081: p_scheduled_end_date IN DATE,
1082: p_actual_start_date IN DATE,
1083: p_actual_end_date IN DATE,
1084: p_item_display_type IN NUMBER,
1085: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec
1086: )
1087: IS
1088: BEGIN
1089:

Line 1131: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');

1127: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1128: fnd_msg_pub.add;
1129:
1130: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_RECUR_RULE_ID');
1131: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1132: fnd_msg_pub.add;
1133:
1134: raise_application_error (-20100,jta_sync_common.get_messages);
1135: END IF;

Line 1145: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');

1141: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1142: fnd_msg_pub.add;
1143:
1144: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_CALENDAR_ENDDATE');
1145: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1146: fnd_msg_pub.add;
1147:
1148: raise_application_error (-20100,jta_sync_common.get_messages);
1149: END IF;

Line 1154: procedure get_exclusion_data (p_recurrence_rule_id IN NUMBER, p_exclusion_data in out NOCOPY jta_sync_task.exclusion_tbl,

1150:
1151: RETURN l_date;
1152: END get_max_enddate;
1153:
1154: procedure get_exclusion_data (p_recurrence_rule_id IN NUMBER, p_exclusion_data in out NOCOPY jta_sync_task.exclusion_tbl,
1155:
1156: p_task_sync_id in number )
1157: --- RETURN jta_sync_task.exclusion_tbl
1158: IS

Line 1157: --- RETURN jta_sync_task.exclusion_tbl

1153:
1154: procedure get_exclusion_data (p_recurrence_rule_id IN NUMBER, p_exclusion_data in out NOCOPY jta_sync_task.exclusion_tbl,
1155:
1156: p_task_sync_id in number )
1157: --- RETURN jta_sync_task.exclusion_tbl
1158: IS
1159: CURSOR c_exclusion
1160: IS
1161: SELECT DISTINCT exclusion_date ex_date

Line 1166: --- l_exclusion_data jta_sync_task.exclusion_tbl;

1162: FROM jta_task_exclusions
1163: WHERE recurrence_rule_id = p_recurrence_rule_id;
1164:
1165: l_date DATE;
1166: --- l_exclusion_data jta_sync_task.exclusion_tbl;
1167: l_exclusion c_exclusion%ROWTYPE;
1168: i BINARY_INTEGER := nvl(p_exclusion_data.last,0) ;
1169: BEGIN
1170: FOR l_exclusion IN c_exclusion

Line 1182: ,p_task_tbl IN jta_sync_task.task_tbl)

1178: END get_exclusion_data;
1179:
1180: FUNCTION already_selected(p_task_id IN NUMBER
1181: ,p_sync_id IN NUMBER
1182: ,p_task_tbl IN jta_sync_task.task_tbl)
1183: RETURN BOOLEAN
1184: IS
1185: l_selected BOOLEAN := FALSE;
1186: BEGIN

Line 1258: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec

1254: p_saturday IN VARCHAR2,
1255: p_date_of_month IN VARCHAR2,
1256: p_occurs_which IN VARCHAR2,
1257: --p_get_data IN BOOLEAN,
1258: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec
1259: )
1260: IS
1261: l_category_name VARCHAR2(240); -- Fix bug 2540722
1262: l_status BOOLEAN;

Line 1328: p_resource_id => jta_sync_task.g_login_resource_id,

1324: make_prefix (
1325: p_assignment_status_id => get_assignment_status_id (p_task_id, p_resource_id),
1326: p_source_object_type_code => x_task_rec.objectcode,
1327: p_resource_type => p_owner_type_code,
1328: p_resource_id => jta_sync_task.g_login_resource_id,
1329: p_group_id => p_resource_id,
1330: x_subject => x_task_rec.subject
1331: );
1332: END IF;

Line 1527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_ID');

1523: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1524: fnd_msg_pub.add;
1525:
1526: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_ID');
1528: fnd_msg_pub.add;
1529:
1530: raise_application_error (-20100,jta_sync_common.get_messages);
1531: END IF;

Line 1563: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_STATUS_ID');

1559: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1560: fnd_msg_pub.add;
1561:
1562: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGN_STSID_NOTFOUND');
1563: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_STATUS_ID');
1564: fnd_msg_pub.add;
1565:
1566: raise_application_error (-20100,jta_sync_common.get_messages);
1567: END IF;

Line 1599: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OWNER_INFO');

1595: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1596: fnd_msg_pub.add;
1597:
1598: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1599: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OWNER_INFO');
1600: fnd_msg_pub.add;
1601:
1602: raise_application_error (-20100,jta_sync_common.get_messages);
1603: END IF;

Line 1663: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_INFO');

1659: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1660: fnd_msg_pub.add;
1661:
1662: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1663: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_INFO');
1664: fnd_msg_pub.add;
1665:
1666: raise_application_error (-20100,jta_sync_common.get_messages);
1667: END IF;

Line 1717: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ACCESS');

1713: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1714: fnd_msg_pub.add;
1715:
1716: fnd_message.set_name('JTF', 'JTA_SYNC_ACCESS_PRIV_NOTFOUND');
1717: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ACCESS');
1718: fnd_msg_pub.add;
1719:
1720: raise_application_error (-20100,jta_sync_common.get_messages);
1721: END IF;

Line 1749: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SOURCE_OBJECT_TYPE');

1745: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1746: fnd_msg_pub.add;
1747:
1748: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1749: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SOURCE_OBJECT_TYPE');
1750: fnd_msg_pub.add;
1751:
1752: raise_application_error (-20100,jta_sync_common.get_messages);
1753: END IF;

Line 1829: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SYNC_TYPE');

1825: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
1826: fnd_msg_pub.add;
1827:
1828: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1829: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SYNC_TYPE');
1830: fnd_msg_pub.add;
1831:
1832: raise_application_error (-20100,jta_sync_common.get_messages);
1833: END IF;

Line 1979: x_data IN OUT NOCOPY jta_sync_task.task_tbl

1975: p_get_data IN BOOLEAN,
1976: x_totalnew IN OUT NOCOPY NUMBER,
1977: x_totalmodified IN OUT NOCOPY NUMBER,
1978: -- x_totaldeleted IN OUT NOCOPY NUMBER,
1979: x_data IN OUT NOCOPY jta_sync_task.task_tbl
1980: --p_new_syncanchor IN DATE
1981: )
1982: IS
1983: x_task_rec jta_sync_task.task_rec;

Line 1983: x_task_rec jta_sync_task.task_rec;

1979: x_data IN OUT NOCOPY jta_sync_task.task_tbl
1980: --p_new_syncanchor IN DATE
1981: )
1982: IS
1983: x_task_rec jta_sync_task.task_rec;
1984: i INTEGER := p_recordindex;
1985: l_invalid BOOLEAN;
1986: BEGIN
1987: FOR rec_modify_nonrepeat IN jta_sync_task_cursors.c_modify_non_repeat_task (

Line 1987: FOR rec_modify_nonrepeat IN jta_sync_task_cursors.c_modify_non_repeat_task (

1983: x_task_rec jta_sync_task.task_rec;
1984: i INTEGER := p_recordindex;
1985: l_invalid BOOLEAN;
1986: BEGIN
1987: FOR rec_modify_nonrepeat IN jta_sync_task_cursors.c_modify_non_repeat_task (
1988: p_syncanchor,
1989: p_resource_id,
1990: p_resource_type,
1991: p_source_object_type

Line 2062: FOR rec_new_nonrepeat IN jta_sync_task_cursors.c_new_non_repeat_task (

2058: END IF; -- l_invalid
2059:
2060: END LOOP;
2061:
2062: FOR rec_new_nonrepeat IN jta_sync_task_cursors.c_new_non_repeat_task (
2063: p_syncanchor,
2064: p_resource_id,
2065: p_resource_type,
2066: p_source_object_type

Line 2149: x_data IN OUT NOCOPY jta_sync_task.task_tbl

2145: p_resource_type IN VARCHAR2,
2146: p_source_object_type IN VARCHAR2,
2147: p_get_data IN BOOLEAN,
2148: x_totaldeleted IN OUT NOCOPY NUMBER,
2149: x_data IN OUT NOCOPY jta_sync_task.task_tbl
2150: )
2151: IS
2152: i INTEGER := nvl(x_data.last,0);
2153: BEGIN

Line 2154: FOR rec_delete IN jta_sync_task_cursors.c_delete_task (

2150: )
2151: IS
2152: i INTEGER := nvl(x_data.last,0);
2153: BEGIN
2154: FOR rec_delete IN jta_sync_task_cursors.c_delete_task (
2155: p_syncanchor,
2156: p_resource_id,
2157: p_resource_type,
2158: p_source_object_type

Line 2171: jta_sync_task_map_pkg.delete_row (

2167: x_data(i).recordindex:= i;
2168: x_data(i).eventtype := g_delete;
2169: x_data(i).resultid := 0;
2170:
2171: jta_sync_task_map_pkg.delete_row (
2172: p_task_sync_id => rec_delete.task_sync_id
2173: );
2174:
2175: x_data(i).syncanchor := convert_server_to_gmt (SYSDATE);

Line 2185: FOR rec_delete IN jta_sync_task_cursors.c_delete_assignee_reject (

2181: x_totaldeleted := x_totaldeleted + 1;
2182: END IF;
2183: END LOOP;
2184:
2185: FOR rec_delete IN jta_sync_task_cursors.c_delete_assignee_reject (
2186: p_syncanchor,
2187: p_resource_id,
2188: p_resource_type,
2189: p_source_object_type

Line 2202: jta_sync_task_map_pkg.delete_row (

2198: x_data(i).recordindex:= i;
2199: x_data(i).eventtype := g_delete;
2200: x_data(i).resultid := 0;
2201:
2202: jta_sync_task_map_pkg.delete_row (
2203: p_task_sync_id => rec_delete.task_sync_id
2204: );
2205:
2206: x_data(i).syncanchor := convert_server_to_gmt (SYSDATE);

Line 2216: FOR rec_delete IN jta_sync_task_cursors.c_delete_assignment (

2212: x_totaldeleted := x_totaldeleted + 1;
2213: END IF;
2214: END LOOP;
2215:
2216: FOR rec_delete IN jta_sync_task_cursors.c_delete_assignment (
2217: p_syncanchor,
2218: p_resource_id,
2219: p_resource_type,
2220: p_source_object_type

Line 2233: jta_sync_task_map_pkg.delete_row (

2229: x_data(i).syncid := rec_delete.task_sync_id;
2230: x_data(i).recordindex:= i;
2231: x_data(i).resultid := 0;
2232:
2233: jta_sync_task_map_pkg.delete_row (
2234: p_task_sync_id => rec_delete.task_sync_id
2235: );
2236:
2237: x_data(i).syncanchor := convert_server_to_gmt (SYSDATE);

Line 2247: FOR rec_delete IN jta_sync_task_cursors.c_delete_rejected_tasks (

2243: x_totaldeleted := x_totaldeleted + 1;
2244: END IF;
2245: END LOOP;
2246:
2247: FOR rec_delete IN jta_sync_task_cursors.c_delete_rejected_tasks (
2248: p_syncanchor,
2249: p_resource_id,
2250: p_resource_type,
2251: p_source_object_type

Line 2264: jta_sync_task_map_pkg.delete_row (

2260: x_data(i).recordindex := i;
2261: x_data (i).eventtype := g_delete;
2262: x_data (i).resultid := 0;
2263:
2264: jta_sync_task_map_pkg.delete_row (
2265: p_task_sync_id => rec_delete.task_sync_id
2266: );
2267:
2268: x_data (i).syncanchor := convert_server_to_gmt (SYSDATE);

Line 2278: FOR rec_delete IN jta_sync_task_cursors.c_delete_unsubscribed(

2274: x_totaldeleted := x_totaldeleted + 1;
2275: END IF;
2276: END LOOP;
2277:
2278: FOR rec_delete IN jta_sync_task_cursors.c_delete_unsubscribed(
2279: p_resource_id,
2280: p_resource_type,
2281: p_source_object_type
2282: )

Line 2294: jta_sync_task_map_pkg.delete_row (

2290: x_data(i).recordindex := i;
2291: x_data (i).eventtype := g_delete;
2292: x_data (i).resultid := 0;
2293:
2294: jta_sync_task_map_pkg.delete_row (
2295: p_task_sync_id => rec_delete.task_sync_id
2296: );
2297:
2298: x_data (i).syncanchor := convert_server_to_gmt (SYSDATE);

Line 2322: x_data IN OUT NOCOPY jta_sync_task.task_tbl,

2318: p_get_data IN BOOLEAN,
2319: x_totalnew IN OUT NOCOPY NUMBER,
2320: x_totalmodified IN OUT NOCOPY NUMBER,
2321: -- x_totaldeleted IN OUT NOCOPY NUMBER,
2322: x_data IN OUT NOCOPY jta_sync_task.task_tbl,
2323: x_exclusion_data IN OUT NOCOPY jta_sync_task.exclusion_tbl
2324: --p_new_syncanchor IN DATE
2325: )
2326: IS

Line 2323: x_exclusion_data IN OUT NOCOPY jta_sync_task.exclusion_tbl

2319: x_totalnew IN OUT NOCOPY NUMBER,
2320: x_totalmodified IN OUT NOCOPY NUMBER,
2321: -- x_totaldeleted IN OUT NOCOPY NUMBER,
2322: x_data IN OUT NOCOPY jta_sync_task.task_tbl,
2323: x_exclusion_data IN OUT NOCOPY jta_sync_task.exclusion_tbl
2324: --p_new_syncanchor IN DATE
2325: )
2326: IS
2327: i INTEGER := nvl(x_data.last,0);

Line 2328: x_task_rec jta_sync_task.task_rec;

2324: --p_new_syncanchor IN DATE
2325: )
2326: IS
2327: i INTEGER := nvl(x_data.last,0);
2328: x_task_rec jta_sync_task.task_rec;
2329: l_invalid BOOLEAN;
2330: BEGIN
2331:
2332: FOR rec_modify_repeat IN jta_sync_task_cursors.c_modify_repeating_task (

Line 2332: FOR rec_modify_repeat IN jta_sync_task_cursors.c_modify_repeating_task (

2328: x_task_rec jta_sync_task.task_rec;
2329: l_invalid BOOLEAN;
2330: BEGIN
2331:
2332: FOR rec_modify_repeat IN jta_sync_task_cursors.c_modify_repeating_task (
2333: p_syncanchor,
2334: p_resource_id,
2335: p_resource_type,
2336: p_source_object_type

Line 2415: FOR rec_new_repeat IN jta_sync_task_cursors.c_new_repeating_task (

2411: END IF; -- l_invalid
2412:
2413: END LOOP;
2414:
2415: FOR rec_new_repeat IN jta_sync_task_cursors.c_new_repeating_task (
2416: p_syncanchor,
2417: p_resource_id,
2418: p_resource_type,
2419: p_source_object_type

Line 2501: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,

2497:
2498: END get_all_repeat_tasks;
2499:
2500: PROCEDURE create_new_data (
2501: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,
2502: p_mapping_type IN VARCHAR2,
2503: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,
2504: p_resource_id IN NUMBER,
2505: p_resource_type IN VARCHAR2

Line 2503: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,

2499:
2500: PROCEDURE create_new_data (
2501: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,
2502: p_mapping_type IN VARCHAR2,
2503: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,
2504: p_resource_id IN NUMBER,
2505: p_resource_type IN VARCHAR2
2506: )
2507: IS

Line 2557: l_category_id := jta_sync_task_category.get_category_id (

2553: x_date_selected => l_date_selected,
2554: x_show_on_calendar => l_show_on_calendar
2555: );
2556:
2557: l_category_id := jta_sync_task_category.get_category_id (
2558: p_category_name => p_task_rec.category,
2559: p_profile_id => jta_sync_task_category.get_profile_id (p_resource_id)
2560: );
2561: /*l_status_id :=

Line 2559: p_profile_id => jta_sync_task_category.get_profile_id (p_resource_id)

2555: );
2556:
2557: l_category_id := jta_sync_task_category.get_category_id (
2558: p_category_name => p_task_rec.category,
2559: p_profile_id => jta_sync_task_category.get_profile_id (p_resource_id)
2560: );
2561: /*l_status_id :=
2562: getchangedstatusid (
2563: p_task_status_id => p_task_rec.statusid,

Line 2747: p_user_message => 'JTA_SYNC_TASK_CREATION_FAILED'

2743:
2744: jta_sync_common.put_messages_to_result (
2745: p_task_rec,
2746: p_status => 2,
2747: p_user_message => 'JTA_SYNC_TASK_CREATION_FAILED'
2748: );
2749: END IF; -- end-check if task creation is successed or not
2750:
2751: /*insert_or_update_mapping (

Line 2762: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,

2758:
2759: END create_new_data;
2760:
2761: PROCEDURE update_existing_data (
2762: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,
2763: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,
2764: p_resource_id IN NUMBER,
2765: p_resource_type IN VARCHAR2
2766: )

Line 2763: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,

2759: END create_new_data;
2760:
2761: PROCEDURE update_existing_data (
2762: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,
2763: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,
2764: p_resource_id IN NUMBER,
2765: p_resource_type IN VARCHAR2
2766: )
2767: IS

Line 2849: l_category_id := jta_sync_task_category.get_category_id (

2845: p_task_status_id => p_task_rec.statusid,
2846: p_source_object_type_code => p_task_rec.objectcode
2847: );
2848:
2849: l_category_id := jta_sync_task_category.get_category_id (
2850: p_category_name => p_task_rec.category,
2851: p_profile_id => jta_sync_task_category.get_profile_id(p_resource_id)
2852: );
2853:

Line 2851: p_profile_id => jta_sync_task_category.get_profile_id(p_resource_id)

2847: );
2848:
2849: l_category_id := jta_sync_task_category.get_category_id (
2850: p_category_name => p_task_rec.category,
2851: p_profile_id => jta_sync_task_category.get_profile_id(p_resource_id)
2852: );
2853:
2854: l_update_type := get_update_type (
2855: p_task_id => l_task_id,

Line 2877: l_changed_rule := jta_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);

2873: p_repeating_task_id => l_task_id,
2874: p_task_rec => p_task_rec
2875: );
2876: ELSE -- p_exclusion_tbl.COUNT = 0 and check change rule
2877: l_changed_rule := jta_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);
2878:
2879: IF l_changed_rule AND
2880: l_update_type = jta_sync_task_common.g_update_all
2881: THEN -- Changed Repeating Rule

Line 2880: l_update_type = jta_sync_task_common.g_update_all

2876: ELSE -- p_exclusion_tbl.COUNT = 0 and check change rule
2877: l_changed_rule := jta_sync_task_common.changed_repeat_rule(p_task_rec => p_task_rec);
2878:
2879: IF l_changed_rule AND
2880: l_update_type = jta_sync_task_common.g_update_all
2881: THEN -- Changed Repeating Rule
2882: IF p_task_rec.unit_of_measure = 'YER' THEN
2883: l_occurs_month := to_number(to_char(p_task_rec.start_date, 'MM'));
2884: END IF;

Line 3064: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec

3060: END update_existing_data;
3061:
3062: PROCEDURE delete_exclusion_task (
3063: p_repeating_task_id IN NUMBER,
3064: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec
3065: )
3066: IS
3067: l_ovn NUMBER;
3068: l_return_status VARCHAR2(1);

Line 3118: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,

3114: END IF;
3115: END delete_exclusion_task;
3116:
3117: PROCEDURE delete_task_data (
3118: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,
3119: p_delete_map_flag IN BOOLEAN
3120: )
3121: IS
3122: l_task_id NUMBER;

Line 3160: jta_sync_task_map_pkg.delete_row (

3156: p_task_rec.syncanchor := convert_server_to_gmt (SYSDATE + 1 / (24 * 60 * 60));
3157:
3158: IF p_delete_map_flag
3159: THEN
3160: jta_sync_task_map_pkg.delete_row (
3161: p_task_sync_id => p_task_rec.syncid
3162: );
3163: END IF;
3164:

Line 3179: PROCEDURE reject_task_data (p_task_rec IN OUT NOCOPY jta_sync_task.task_rec)

3175: );
3176: END IF;
3177: END delete_task_data;
3178:
3179: PROCEDURE reject_task_data (p_task_rec IN OUT NOCOPY jta_sync_task.task_rec)
3180: IS
3181: l_task_id NUMBER;
3182: l_rec_rule_id NUMBER;
3183: l_task_assignment_id NUMBER;

Line 3247: jta_sync_task_map_pkg.delete_row(p_task_sync_id => p_task_rec.syncid);

3243: p_status => g_sync_success,
3244: p_user_message => 'JTA_SYNC_SUCCESS'
3245: );
3246:
3247: jta_sync_task_map_pkg.delete_row(p_task_sync_id => p_task_rec.syncid);
3248: ELSE
3249: jta_sync_common.put_messages_to_result (
3250: p_task_rec,
3251: p_status => 2,

Line 3257: FUNCTION changed_repeat_rule (p_task_rec IN jta_sync_task.task_rec)

3253: );
3254: END IF;
3255: END reject_task_data;
3256:
3257: FUNCTION changed_repeat_rule (p_task_rec IN jta_sync_task.task_rec)
3258: RETURN BOOLEAN
3259: IS
3260: CURSOR c_task_recur (b_task_id NUMBER)
3261: IS

Line 3368: x_operation := jta_sync_task_common.g_delete;

3364: IF (p_task_status_id = 8)
3365: OR (p_task_status_id = 4)
3366: OR (p_task_status_id = 7)
3367: THEN
3368: x_operation := jta_sync_task_common.g_delete;
3369: END IF;
3370:
3371: IF (p_task_status_id = 12)
3372: OR (p_task_status_id = 15)

Line 3388: x_operation := jta_sync_task_common.g_delete;

3384: OR (NVL (l_rejected_flag, 'N') = 'Y')
3385: OR (NVL (l_completed_flag, 'N') = 'Y')
3386: OR (NVL (l_cancelled_flag, 'N') = 'Y')
3387: THEN
3388: x_operation := jta_sync_task_common.g_delete;
3389: END IF;
3390: CLOSE c_task_status;
3391: END IF;
3392:

Line 3406: x_operation := jta_sync_task_common.g_delete;

3402: OR (NVL (l_rejected_flag, 'N') = 'Y')
3403: OR (NVL (l_completed_flag, 'N') = 'Y')
3404: OR (NVL (l_cancelled_flag, 'N') = 'Y')
3405: THEN
3406: x_operation := jta_sync_task_common.g_delete;
3407: ELSIF (NVL (l_assigned_flag, 'N') = 'Y')
3408: THEN p_task_status_id := 12;
3409: ELSIF (NVL (l_working_flag, 'N') = 'Y')
3410: THEN p_task_status_id := 15;

Line 3420: x_operation := jta_sync_task_common.g_modify;

3416: THEN p_task_status_id := 16;
3417: ELSIF (NVL (l_approved_flag, 'N') = 'Y')
3418: THEN p_task_status_id := 15;
3419: END IF;
3420: x_operation := jta_sync_task_common.g_modify;
3421:
3422: CLOSE c_task_status;
3423:
3424: END IF;

Line 3488: FROM jta_sync_task_mapping

3484: RETURN BOOLEAN
3485: IS
3486: CURSOR c_mapping (b_syncid NUMBER) IS
3487: SELECT 1
3488: FROM jta_sync_task_mapping
3489: WHERE task_sync_id = b_syncid;
3490:
3491: l_dummy NUMBER;
3492: l_valid BOOLEAN := TRUE;

Line 3503: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');

3499: fnd_message.set_name('JTF', 'JTA_SYNC_APPL_ERROR');
3500: fnd_msg_pub.add;
3501:
3502: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
3503: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
3504: fnd_msg_pub.add;
3505:
3506: raise_application_error (-20100,jta_sync_common.get_messages);
3507: END IF;

Line 3521: END jta_sync_task_common;

3517:
3518: RETURN l_valid;
3519: END validate_syncid;
3520:
3521: END jta_sync_task_common;