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_RECURRENCES_PVT

Line 1: PACKAGE BODY jtf_task_recurrences_pvt AS

1: PACKAGE BODY jtf_task_recurrences_pvt AS
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,

Line 685: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,

681: p_occurs_every NUMBER DEFAULT NULL,
682: p_occurs_number NUMBER DEFAULT 0,
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,

Line 705: p_required_date_tbl jtf_task_recurrences_pvt.output_dates_rec;

701: generated BOOLEAN := TRUE;
702: valid_date BOOLEAN := FALSE;
703: i INTEGER := 1;
704: j INTEGER := 1;
705: p_required_date_tbl jtf_task_recurrences_pvt.output_dates_rec;
706: l_day_of_week VARCHAR2(15);
707: l_month VARCHAR2(2);
708:
709: /******* Start of addition by SBARAT on 12/04/2006 for bug# 5119803 ******/

Line 742: jtf_task_recurrences_pvt.get_week_day (

738: END IF;
739:
740: IF p_occurs_uom = 'WEK'
741: THEN
742: jtf_task_recurrences_pvt.get_week_day (
743: p_sunday => p_sunday,
744: p_monday => p_monday,
745: p_tuesday => p_tuesday,
746: p_wednesday => p_wednesday,

Line 769: jtf_task_recurrences_pvt.get_occurs_which (

765: IF p_occurs_uom = 'MTH'
766: THEN
767: IF p_date_of_month IS NULL
768: THEN
769: jtf_task_recurrences_pvt.get_occurs_which (
770: p_occurs_which,
771: p_day_of_week,
772: TO_CHAR (p_required_date, 'MON', 'NLS_DATE_LANGUAGE=AMERICAN'), -- Fix Bug 2398568
773: TO_CHAR (p_required_date, 'YYYY'),

Line 779: jtf_task_recurrences_pvt.occurs_date_of_month (

775: );
776:
777:
778: ELSE
779: jtf_task_recurrences_pvt.occurs_date_of_month (
780: p_date_of_month,
781: TO_CHAR (p_required_date, 'MON', 'NLS_DATE_LANGUAGE=AMERICAN'), -- Fix Bug 2398568
782: TO_CHAR (p_required_date, 'YYYY'),
783: p_required_date

Line 794: jtf_task_recurrences_pvt.get_mth_day (

790: THEN
791: IF p_date_of_month IS NULL
792: THEN
793:
794: jtf_task_recurrences_pvt.get_mth_day (
795: p_occurs_which => p_occurs_which,
796: p_sunday => p_sunday,
797: p_monday => p_monday,
798: p_tuesday => p_tuesday,

Line 811: jtf_task_recurrences_pvt.occurs_date_of_month (

807:
808:
809: ELSE
810: -- when date of month is selected
811: jtf_task_recurrences_pvt.occurs_date_of_month (
812: p_date_of_month,
813: TO_CHAR (p_required_date, 'MON', 'NLS_DATE_LANGUAGE=AMERICAN'), -- Fix Bug 2398568
814: TO_CHAR (p_required_date, 'YYYY'),
815: p_required_date

Line 860: jtf_task_recurrences_pvt.get_occurs_which (

856: END IF;
857: ELSE
858: IF TO_NUMBER (TO_CHAR (p_required_date, 'MM')) = p_occurs_month
859: THEN
860: jtf_task_recurrences_pvt.get_occurs_which (
861: p_occurs_which,
862: p_day_of_week,
863: TO_CHAR (p_required_date, 'MON', 'NLS_DATE_LANGUAGE=AMERICAN'), -- Fix Bug 2398568
864: TO_CHAR (p_required_date, 'YYYY'),

Line 1057: jtf_task_recurrences_pvt.get_occurs_which (

1053: l_day_of_week := 'FRIDAY';
1054: ELSIF p_saturday = 'Y' THEN
1055: l_day_of_week := 'SATURDAY';
1056: END IF;
1057: jtf_task_recurrences_pvt.get_occurs_which (
1058: p_occurs_which,
1059: l_day_of_week,
1060: TO_CHAR (p_required_date, 'MON', 'NLS_DATE_LANGUAGE=AMERICAN'), -- Fix Bug 2398568
1061: TO_CHAR (p_required_date, 'YYYY'),

Line 1493: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,

1489: p_occurs_every NUMBER DEFAULT NULL,
1490: p_occurs_number NUMBER DEFAULT 0,
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,

Line 1540: jtf_task_recurrences_pvt.recur_main (

1536: 9, 'WEEKEND'
1537: )
1538: INTO l_day_of_week
1539: FROM dual;
1540: jtf_task_recurrences_pvt.recur_main (
1541: p_occurs_which => l_occurs_which,
1542: p_date_of_month => p_date_of_month,
1543: p_day_of_week => l_day_of_week,
1544: p_occurs_month => p_occurs_month,

Line 1587: FUNCTION original_date_meets_criteria (p_output_dates_tbl IN jtf_task_recurrences_pvt.output_dates_rec,

1583: CLOSE c_tasks_ovn;
1584: RETURN l_object_version_number;
1585: END get_ovn;
1586:
1587: FUNCTION original_date_meets_criteria (p_output_dates_tbl IN jtf_task_recurrences_pvt.output_dates_rec,
1588: p_start_date_active IN DATE)
1589: RETURN BOOLEAN
1590: IS
1591: BEGIN

Line 2237: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;

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;
2239: l_api_version CONSTANT NUMBER := 1.0;
2240: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_RECURRENCE';
2241: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;

Line 2368: jtf_task_recurrences_pvt.validate_task_recurrence (

2364: RAISE fnd_api.g_exc_unexpected_error;
2365: END IF;
2366: END IF;
2367:
2368: jtf_task_recurrences_pvt.validate_task_recurrence (
2369: p_occurs_which => p_occurs_which,
2370: p_day_of_week => p_day_of_week,
2371: p_date_of_month => p_date_of_month,
2372: p_occurs_month => p_occurs_month,

Line 2399: jtf_task_recurrences_pvt.generate_dates (

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,
2402: p_date_of_month => p_date_of_month,
2403: p_occurs_month => p_occurs_month,

Line 3150: /*jtf_task_recurrences_pvt.get_repeat_end_date(

3146: THEN
3147: l_last := l_output_dates_tbl.LAST; -- Fix bug 2376554
3148:
3149: -- Commented out by SBARAT on 28/07/2005 for bug# 4365923
3150: /*jtf_task_recurrences_pvt.get_repeat_end_date(
3151: p_recurrence_rule_id => l_recur_id
3152: ,x_repeat_end_date => l_repeat_end_date
3153: );*/
3154: