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_RECURRENCES_PVT dependencies on JTF_TASK_UTL

Line 6: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

2: /* $Header: jtfvtkub.pls 120.15 2010/06/08 09:36:08 anangupt ship $ */
3:
4: PROCEDURE get_mth_day(
5: p_occurs_which VARCHAR2,
6: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
7: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
8: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
9: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
10: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 7: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3:
4: PROCEDURE get_mth_day(
5: p_occurs_which VARCHAR2,
6: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
7: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
8: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
9: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
10: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
11: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 8: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

4: PROCEDURE get_mth_day(
5: p_occurs_which VARCHAR2,
6: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
7: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
8: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
9: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
10: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
11: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
12: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 9: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

5: p_occurs_which VARCHAR2,
6: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
7: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
8: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
9: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
10: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
11: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
12: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
13: p_month VARCHAR2,

Line 10: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

6: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
7: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
8: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
9: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
10: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
11: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
12: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
13: p_month VARCHAR2,
14: p_year NUMBER,

Line 11: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

7: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
8: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
9: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
10: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
11: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
12: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
13: p_month VARCHAR2,
14: p_year NUMBER,
15: x_required_date OUT NOCOPY DATE

Line 12: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

8: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
9: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
10: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
11: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
12: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
13: p_month VARCHAR2,
14: p_year NUMBER,
15: x_required_date OUT NOCOPY DATE
16: )

Line 391: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

387:
388: END;
389:
390: PROCEDURE get_week_day(
391: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
392: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
393: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
394: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
395: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 392: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

388: END;
389:
390: PROCEDURE get_week_day(
391: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
392: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
393: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
394: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
395: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
396: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 393: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

389:
390: PROCEDURE get_week_day(
391: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
392: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
393: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
394: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
395: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
396: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
397: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 394: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

390: PROCEDURE get_week_day(
391: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
392: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
393: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
394: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
395: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
396: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
397: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
398: p_required_date DATE,

Line 395: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

391: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
392: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
393: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
394: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
395: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
396: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
397: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
398: p_required_date DATE,
399: x_required_date IN OUT NOCOPY DATE

Line 396: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

392: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
393: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
394: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
395: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
396: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
397: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
398: p_required_date DATE,
399: x_required_date IN OUT NOCOPY DATE
400: )

Line 397: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

393: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
394: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
395: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
396: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
397: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
398: p_required_date DATE,
399: x_required_date IN OUT NOCOPY DATE
400: )
401: AS

Line 687: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

683: p_start_date DATE DEFAULT NULL,
684: p_end_date DATE DEFAULT NULL,
685: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
686: x_output_dates_counter OUT NOCOPY INTEGER,
687: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
688: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
689: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
690: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
691: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 688: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

684: p_end_date DATE DEFAULT NULL,
685: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
686: x_output_dates_counter OUT NOCOPY INTEGER,
687: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
688: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
689: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
690: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
691: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
692: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 689: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

685: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
686: x_output_dates_counter OUT NOCOPY INTEGER,
687: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
688: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
689: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
690: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
691: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
692: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
693: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 690: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

686: x_output_dates_counter OUT NOCOPY INTEGER,
687: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
688: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
689: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
690: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
691: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
692: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
693: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
694: p_task_id NUMBER DEFAULT NULL

Line 691: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

687: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
688: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
689: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
690: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
691: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
692: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
693: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
694: p_task_id NUMBER DEFAULT NULL
695: )

Line 692: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

688: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
689: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
690: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
691: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
692: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
693: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
694: p_task_id NUMBER DEFAULT NULL
695: )
696: IS

Line 693: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

689: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
690: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
691: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
692: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
693: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
694: p_task_id NUMBER DEFAULT NULL
695: )
696: IS
697: p_required_date DATE := p_start_date;

Line 1495: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1491: p_start_date DATE DEFAULT NULL,
1492: p_end_date DATE DEFAULT SYSDATE,
1493: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
1494: x_output_dates_counter OUT NOCOPY INTEGER,
1495: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1496: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1497: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1498: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1499: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 1496: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1492: p_end_date DATE DEFAULT SYSDATE,
1493: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
1494: x_output_dates_counter OUT NOCOPY INTEGER,
1495: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1496: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1497: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1498: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1499: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1500: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 1497: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1493: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
1494: x_output_dates_counter OUT NOCOPY INTEGER,
1495: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1496: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1497: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1498: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1499: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1500: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1501: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 1498: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1494: x_output_dates_counter OUT NOCOPY INTEGER,
1495: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1496: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1497: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1498: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1499: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1500: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1501: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1502: p_task_id NUMBER DEFAULT NULL

Line 1499: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1495: p_sunday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1496: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1497: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1498: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1499: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1500: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1501: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1502: p_task_id NUMBER DEFAULT NULL
1503: )

Line 1500: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1496: p_monday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1497: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1498: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1499: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1500: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1501: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1502: p_task_id NUMBER DEFAULT NULL
1503: )
1504: IS

Line 1501: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1497: p_tuesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1498: p_wednesday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1499: p_thursday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1500: p_friday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1501: p_saturday VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1502: p_task_id NUMBER DEFAULT NULL
1503: )
1504: IS
1505: l_occurs_which VARCHAR2(20);

Line 1612: (p_sunday = jtf_task_utl.g_no_char and

1608: p_saturday = 'N') OR
1609: (p_sunday is null and p_monday is null and p_tuesday is null and
1610: p_wednesday is null and p_thursday is null and p_friday is null
1611: and p_saturday is null) OR
1612: (p_sunday = jtf_task_utl.g_no_char and
1613: p_monday = jtf_task_utl.g_no_char and
1614: p_tuesday = jtf_task_utl.g_no_char and
1615: p_wednesday = jtf_task_utl.g_no_char and
1616: p_thursday = jtf_task_utl.g_no_char and

Line 1613: p_monday = jtf_task_utl.g_no_char and

1609: (p_sunday is null and p_monday is null and p_tuesday is null and
1610: p_wednesday is null and p_thursday is null and p_friday is null
1611: and p_saturday is null) OR
1612: (p_sunday = jtf_task_utl.g_no_char and
1613: p_monday = jtf_task_utl.g_no_char and
1614: p_tuesday = jtf_task_utl.g_no_char and
1615: p_wednesday = jtf_task_utl.g_no_char and
1616: p_thursday = jtf_task_utl.g_no_char and
1617: p_friday = jtf_task_utl.g_no_char and

Line 1614: p_tuesday = jtf_task_utl.g_no_char and

1610: p_wednesday is null and p_thursday is null and p_friday is null
1611: and p_saturday is null) OR
1612: (p_sunday = jtf_task_utl.g_no_char and
1613: p_monday = jtf_task_utl.g_no_char and
1614: p_tuesday = jtf_task_utl.g_no_char and
1615: p_wednesday = jtf_task_utl.g_no_char and
1616: p_thursday = jtf_task_utl.g_no_char and
1617: p_friday = jtf_task_utl.g_no_char and
1618: p_saturday = jtf_task_utl.g_no_char)) THEN

Line 1615: p_wednesday = jtf_task_utl.g_no_char and

1611: and p_saturday is null) OR
1612: (p_sunday = jtf_task_utl.g_no_char and
1613: p_monday = jtf_task_utl.g_no_char and
1614: p_tuesday = jtf_task_utl.g_no_char and
1615: p_wednesday = jtf_task_utl.g_no_char and
1616: p_thursday = jtf_task_utl.g_no_char and
1617: p_friday = jtf_task_utl.g_no_char and
1618: p_saturday = jtf_task_utl.g_no_char)) THEN
1619: RETURN TRUE;

Line 1616: p_thursday = jtf_task_utl.g_no_char and

1612: (p_sunday = jtf_task_utl.g_no_char and
1613: p_monday = jtf_task_utl.g_no_char and
1614: p_tuesday = jtf_task_utl.g_no_char and
1615: p_wednesday = jtf_task_utl.g_no_char and
1616: p_thursday = jtf_task_utl.g_no_char and
1617: p_friday = jtf_task_utl.g_no_char and
1618: p_saturday = jtf_task_utl.g_no_char)) THEN
1619: RETURN TRUE;
1620: ELSE

Line 1617: p_friday = jtf_task_utl.g_no_char and

1613: p_monday = jtf_task_utl.g_no_char and
1614: p_tuesday = jtf_task_utl.g_no_char and
1615: p_wednesday = jtf_task_utl.g_no_char and
1616: p_thursday = jtf_task_utl.g_no_char and
1617: p_friday = jtf_task_utl.g_no_char and
1618: p_saturday = jtf_task_utl.g_no_char)) THEN
1619: RETURN TRUE;
1620: ELSE
1621: RETURN FALSE;

Line 1618: p_saturday = jtf_task_utl.g_no_char)) THEN

1614: p_tuesday = jtf_task_utl.g_no_char and
1615: p_wednesday = jtf_task_utl.g_no_char and
1616: p_thursday = jtf_task_utl.g_no_char and
1617: p_friday = jtf_task_utl.g_no_char and
1618: p_saturday = jtf_task_utl.g_no_char)) THEN
1619: RETURN TRUE;
1620: ELSE
1621: RETURN FALSE;
1622: END IF;

Line 1721: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1717: p_end_date_active IN DATE DEFAULT NULL,
1718: x_msg_count OUT NOCOPY NUMBER,
1719: x_msg_data OUT NOCOPY VARCHAR2,
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1722: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1723: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1724: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1725: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 1722: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1718: x_msg_count OUT NOCOPY NUMBER,
1719: x_msg_data OUT NOCOPY VARCHAR2,
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1722: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1723: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1724: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1725: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1726: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 1723: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1719: x_msg_data OUT NOCOPY VARCHAR2,
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1722: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1723: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1724: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1725: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1726: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1727: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char

Line 1724: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1720: x_return_status OUT NOCOPY VARCHAR2,
1721: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1722: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1723: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1724: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1725: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1726: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1727: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
1728: )

Line 1725: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1721: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1722: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1723: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1724: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1725: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1726: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1727: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
1728: )
1729: IS

Line 1726: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

1722: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1723: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1724: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1725: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1726: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1727: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
1728: )
1729: IS
1730: BEGIN

Line 1727: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char

1723: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1724: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1725: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1726: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
1727: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
1728: )
1729: IS
1730: BEGIN
1731: x_return_status := fnd_api.g_ret_sts_success;

Line 2205: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

2201: p_occurs_every IN INTEGER DEFAULT NULL,
2202: p_occurs_number IN INTEGER DEFAULT NULL,
2203: p_start_date_active IN DATE DEFAULT NULL,
2204: p_end_date_active IN DATE DEFAULT NULL,
2205: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2206: x_return_status OUT NOCOPY VARCHAR2,
2207: x_msg_count OUT NOCOPY NUMBER,
2208: x_msg_data OUT NOCOPY VARCHAR2,
2209: x_recurrence_rule_id OUT NOCOPY NUMBER,

Line 2228: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

2224: p_attribute13 IN VARCHAR2 DEFAULT null ,
2225: p_attribute14 IN VARCHAR2 DEFAULT null ,
2226: p_attribute15 IN VARCHAR2 DEFAULT null ,
2227: p_attribute_category IN VARCHAR2 DEFAULT null ,
2228: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2229: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2230: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2231: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2232: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 2229: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

2225: p_attribute14 IN VARCHAR2 DEFAULT null ,
2226: p_attribute15 IN VARCHAR2 DEFAULT null ,
2227: p_attribute_category IN VARCHAR2 DEFAULT null ,
2228: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2229: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2230: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2231: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2232: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2233: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 2230: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

2226: p_attribute15 IN VARCHAR2 DEFAULT null ,
2227: p_attribute_category IN VARCHAR2 DEFAULT null ,
2228: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2229: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2230: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2231: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2232: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2233: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2234: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char

Line 2231: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

2227: p_attribute_category IN VARCHAR2 DEFAULT null ,
2228: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2229: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2230: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2231: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2232: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2233: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2234: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
2235: )

Line 2232: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

2228: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2229: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2230: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2231: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2232: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2233: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2234: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
2235: )
2236: IS

Line 2233: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

2229: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2230: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2231: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2232: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2233: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2234: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
2235: )
2236: IS
2237: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;

Line 2234: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char

2230: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2231: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2232: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2233: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
2234: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
2235: )
2236: IS
2237: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;
2238: l_recur_task_id NUMBER;

Line 2343: IF jtf_task_utl.to_boolean (p_template_flag)

2339: END IF;
2340:
2341: --- check if the given task id has already the recur
2342: --- checking if the task already has a recurrence
2343: IF jtf_task_utl.to_boolean (p_template_flag)
2344: THEN
2345:
2346:
2347: SELECT recurrence_rule_id

Line 2403: IF not jtf_task_utl.to_boolean (p_template_flag)

2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: RAISE fnd_api.g_exc_unexpected_error;
2401: END IF;
2402: --- Call the procedure to generate the dates
2403: IF not jtf_task_utl.to_boolean (p_template_flag)
2404: THEN
2405: jtf_task_recurrences_pvt.generate_dates (
2406: p_occurs_which => p_occurs_which,
2407: p_day_of_week => p_day_of_week,

Line 2478: x_created_by => jtf_task_utl.created_by,

2474: x_attribute14 => p_attribute14 ,
2475: x_attribute15 => p_attribute15,
2476: x_attribute_category => p_attribute_category ,
2477: x_creation_date => SYSDATE,
2478: x_created_by => jtf_task_utl.created_by,
2479: x_last_update_date => SYSDATE,
2480: x_last_updated_by => jtf_task_utl.updated_by,
2481: x_last_update_login => fnd_global.login_id,
2482: x_sunday => p_sunday,

Line 2480: x_last_updated_by => jtf_task_utl.updated_by,

2476: x_attribute_category => p_attribute_category ,
2477: x_creation_date => SYSDATE,
2478: x_created_by => jtf_task_utl.created_by,
2479: x_last_update_date => SYSDATE,
2480: x_last_updated_by => jtf_task_utl.updated_by,
2481: x_last_update_login => fnd_global.login_id,
2482: x_sunday => p_sunday,
2483: x_monday => p_monday,
2484: x_tuesday => p_tuesday,

Line 2504: IF jtf_task_utl.to_boolean(p_template_flag)

2500: RAISE fnd_api.g_exc_unexpected_error;
2501: ELSE
2502: x_recurrence_rule_id := l_recur_id;
2503:
2504: IF jtf_task_utl.to_boolean(p_template_flag)
2505: THEN
2506: UPDATE jtf_task_templates_b
2507: SET recurrence_rule_id = l_recur_id
2508: WHERE task_template_id = l_task_id;

Line 2540: IF NOT jtf_task_utl.to_boolean (p_template_flag)

2536: --- if it a template do nothing
2537: --- else call copy tasks to create the tasks.
2538: ---
2539:
2540: IF NOT jtf_task_utl.to_boolean (p_template_flag)
2541: THEN
2542: i := 1;
2543: WHILE i <= x_output_dates_counter
2544: LOOP

Line 3002: jtf_task_utl_ext.set_start_n_due_date (

2998: l_valid := TRUE; -- Fix bug 2376554
2999: end if;
3000: ELSIF l_date_selected = 'D'
3001: THEN
3002: jtf_task_utl_ext.set_start_n_due_date (
3003: p_task_status_id => l_task_details.task_status_id
3004: , p_planned_start_date => l_planned_start_date
3005: , p_planned_end_date => l_planned_end_date
3006: , p_scheduled_start_date => l_scheduled_start_date

Line 3135: l_name := JTF_TASK_UTL.get_owner(i.resource_type_code, i.resource_id);

3131:
3132: if l_availability = 'F' then
3133:
3134: l_name := null;
3135: l_name := JTF_TASK_UTL.get_owner(i.resource_type_code, i.resource_id);
3136: l_date := l_booking_start_date;
3137: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
3138: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
3139: fnd_profile.value('CLIENT_TIMEZONE_ID'),

Line 3171: IF not jtf_task_utl.to_boolean (p_template_flag) AND -- Fix bug 2395216

3167: END LOOP;
3168: END IF;
3169: close c_task_details;
3170: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3171: IF not jtf_task_utl.to_boolean (p_template_flag) AND -- Fix bug 2395216
3172: NOT original_date_meets_criteria(p_output_dates_tbl => l_output_dates_tbl ,
3173: p_start_date_active => p_start_date_active) and
3174: p_occurs_uom <> 'DAY'
3175: THEN

Line 3198: IF not jtf_task_utl.to_boolean (p_template_flag) AND -- Fix bug 2395216

3194: SET start_date_active = TRUNC(NVL(l_repeat_start_date, l_output_dates_tbl(1))) -- Fix bug 2376554, bug 2385202
3195: WHERE recurrence_rule_id = l_recur_id;
3196: END IF;
3197:
3198: IF not jtf_task_utl.to_boolean (p_template_flag) AND -- Fix bug 2395216
3199: p_end_date_active IS NULL
3200: THEN
3201: l_last := l_output_dates_tbl.LAST; -- Fix bug 2376554
3202:

Line 3279: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3275: p_occurs_every IN INTEGER DEFAULT NULL,
3276: p_occurs_number IN INTEGER DEFAULT NULL,
3277: p_start_date_active IN DATE DEFAULT NULL,
3278: p_end_date_active IN DATE DEFAULT NULL,
3279: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3280: p_attribute1 IN VARCHAR2 DEFAULT NULL ,
3281: p_attribute2 IN VARCHAR2 DEFAULT NULL ,
3282: p_attribute3 IN VARCHAR2 DEFAULT NULL ,
3283: p_attribute4 IN VARCHAR2 DEFAULT NULL ,

Line 3296: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3292: p_attribute13 IN VARCHAR2 DEFAULT NULL ,
3293: p_attribute14 IN VARCHAR2 DEFAULT NULL ,
3294: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
3295: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
3296: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3297: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3298: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3299: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3300: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 3297: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3293: p_attribute14 IN VARCHAR2 DEFAULT NULL ,
3294: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
3295: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
3296: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3297: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3298: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3299: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3300: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3301: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 3298: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3294: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
3295: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
3296: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3297: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3298: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3299: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3300: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3301: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3302: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 3299: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3295: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
3296: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3297: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3298: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3299: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3300: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3301: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3302: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3303: x_new_recurrence_rule_id OUT NOCOPY NUMBER,

Line 3300: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3296: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3297: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3298: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3299: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3300: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3301: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3302: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3303: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
3304: x_return_status OUT NOCOPY VARCHAR2,

Line 3301: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3297: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3298: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3299: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3300: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3301: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3302: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3303: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
3304: x_return_status OUT NOCOPY VARCHAR2,
3305: x_msg_count OUT NOCOPY NUMBER,

Line 3302: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3298: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3299: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3300: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3301: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3302: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3303: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
3304: x_return_status OUT NOCOPY VARCHAR2,
3305: x_msg_count OUT NOCOPY NUMBER,
3306: x_msg_data OUT NOCOPY VARCHAR2