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.8.12010000.2 2008/10/23 09:54:37 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 2337: IF jtf_task_utl.to_boolean (p_template_flag)

2333: END IF;
2334:
2335: --- check if the given task id has already the recur
2336: --- checking if the task already has a recurrence
2337: IF jtf_task_utl.to_boolean (p_template_flag)
2338: THEN
2339:
2340:
2341: SELECT recurrence_rule_id

Line 2397: IF not jtf_task_utl.to_boolean (p_template_flag)

2393: x_return_status := fnd_api.g_ret_sts_unexp_error;
2394: RAISE fnd_api.g_exc_unexpected_error;
2395: END IF;
2396: --- Call the procedure to generate the dates
2397: IF not jtf_task_utl.to_boolean (p_template_flag)
2398: THEN
2399: jtf_task_recurrences_pvt.generate_dates (
2400: p_occurs_which => p_occurs_which,
2401: p_day_of_week => p_day_of_week,

Line 2472: x_created_by => jtf_task_utl.created_by,

2468: x_attribute14 => p_attribute14 ,
2469: x_attribute15 => p_attribute15,
2470: x_attribute_category => p_attribute_category ,
2471: x_creation_date => SYSDATE,
2472: x_created_by => jtf_task_utl.created_by,
2473: x_last_update_date => SYSDATE,
2474: x_last_updated_by => jtf_task_utl.updated_by,
2475: x_last_update_login => fnd_global.login_id,
2476: x_sunday => p_sunday,

Line 2474: x_last_updated_by => jtf_task_utl.updated_by,

2470: x_attribute_category => p_attribute_category ,
2471: x_creation_date => SYSDATE,
2472: x_created_by => jtf_task_utl.created_by,
2473: x_last_update_date => SYSDATE,
2474: x_last_updated_by => jtf_task_utl.updated_by,
2475: x_last_update_login => fnd_global.login_id,
2476: x_sunday => p_sunday,
2477: x_monday => p_monday,
2478: x_tuesday => p_tuesday,

Line 2498: IF jtf_task_utl.to_boolean(p_template_flag)

2494: RAISE fnd_api.g_exc_unexpected_error;
2495: ELSE
2496: x_recurrence_rule_id := l_recur_id;
2497:
2498: IF jtf_task_utl.to_boolean(p_template_flag)
2499: THEN
2500: UPDATE jtf_task_templates_b
2501: SET recurrence_rule_id = l_recur_id
2502: WHERE task_template_id = l_task_id;

Line 2534: IF NOT jtf_task_utl.to_boolean (p_template_flag)

2530: --- if it a template do nothing
2531: --- else call copy tasks to create the tasks.
2532: ---
2533:
2534: IF NOT jtf_task_utl.to_boolean (p_template_flag)
2535: THEN
2536: i := 1;
2537: WHILE i <= x_output_dates_counter
2538: LOOP

Line 2996: jtf_task_utl_ext.set_start_n_due_date (

2992: l_valid := TRUE; -- Fix bug 2376554
2993: end if;
2994: ELSIF l_date_selected = 'D'
2995: THEN
2996: jtf_task_utl_ext.set_start_n_due_date (
2997: p_task_status_id => l_task_details.task_status_id
2998: , p_planned_start_date => l_planned_start_date
2999: , p_planned_end_date => l_planned_end_date
3000: , p_scheduled_start_date => l_scheduled_start_date

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

3113: END LOOP;
3114: END IF;
3115: close c_task_details;
3116: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3117: IF not jtf_task_utl.to_boolean (p_template_flag) AND -- Fix bug 2395216
3118: NOT original_date_meets_criteria(p_output_dates_tbl => l_output_dates_tbl ,
3119: p_start_date_active => p_start_date_active) and
3120: p_occurs_uom <> 'DAY'
3121: THEN

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

3140: SET start_date_active = TRUNC(NVL(l_repeat_start_date, l_output_dates_tbl(1))) -- Fix bug 2376554, bug 2385202
3141: WHERE recurrence_rule_id = l_recur_id;
3142: END IF;
3143:
3144: IF not jtf_task_utl.to_boolean (p_template_flag) AND -- Fix bug 2395216
3145: p_end_date_active IS NULL
3146: THEN
3147: l_last := l_output_dates_tbl.LAST; -- Fix bug 2376554
3148:

Line 3225: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3221: p_occurs_every IN INTEGER DEFAULT NULL,
3222: p_occurs_number IN INTEGER DEFAULT NULL,
3223: p_start_date_active IN DATE DEFAULT NULL,
3224: p_end_date_active IN DATE DEFAULT NULL,
3225: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3226: p_attribute1 IN VARCHAR2 DEFAULT NULL ,
3227: p_attribute2 IN VARCHAR2 DEFAULT NULL ,
3228: p_attribute3 IN VARCHAR2 DEFAULT NULL ,
3229: p_attribute4 IN VARCHAR2 DEFAULT NULL ,

Line 3242: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3238: p_attribute13 IN VARCHAR2 DEFAULT NULL ,
3239: p_attribute14 IN VARCHAR2 DEFAULT NULL ,
3240: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
3241: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
3242: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3243: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3244: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3245: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3246: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 3243: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3239: p_attribute14 IN VARCHAR2 DEFAULT NULL ,
3240: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
3241: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
3242: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3243: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3244: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3245: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3246: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3247: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 3244: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3240: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
3241: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
3242: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3243: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3244: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3245: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3246: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3247: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3248: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 3245: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3241: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
3242: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3243: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3244: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3245: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3246: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3247: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3248: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3249: x_new_recurrence_rule_id OUT NOCOPY NUMBER,

Line 3246: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3242: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3243: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3244: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3245: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3246: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3247: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3248: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3249: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
3250: x_return_status OUT NOCOPY VARCHAR2,

Line 3247: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3243: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3244: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3245: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3246: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3247: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3248: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3249: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
3250: x_return_status OUT NOCOPY VARCHAR2,
3251: x_msg_count OUT NOCOPY NUMBER,

Line 3248: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

3244: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3245: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3246: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3247: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3248: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
3249: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
3250: x_return_status OUT NOCOPY VARCHAR2,
3251: x_msg_count OUT NOCOPY NUMBER,
3252: x_msg_data OUT NOCOPY VARCHAR2