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_CAL_SHIFT_CONSTRUCTS_PKG dependencies on JTF_CAL_SHIFT_CONSTRUCTS

Line 1: PACKAGE BODY jtf_cal_shift_constructs_pkg AS

1: PACKAGE BODY jtf_cal_shift_constructs_pkg AS
2: /* $Header: jtfclscb.pls 120.2.12000000.2 2007/10/12 13:32:48 venjayar ship $ */
3: PROCEDURE insert_row(
4: x_error OUT NOCOPY VARCHAR2
5: , x_rowid IN OUT NOCOPY VARCHAR2

Line 37: cursor C is select ROWID from JTF_CAL_SHIFT_CONSTRUCTS

33: , x_last_updated_by IN NUMBER
34: , x_last_update_login IN NUMBER
35: ) IS
36: /* -- Commented By Sarvi B'cos was not used else where and also was raising an exception.
37: cursor C is select ROWID from JTF_CAL_SHIFT_CONSTRUCTS
38: where SHIFT_CONSTRUCT_ID = X_SHIFT_CONSTRUCT_ID;
39: */
40: v_error CHAR := 'N';
41: x_object_version_number NUMBER;

Line 51: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN

47: BEGIN
48: fnd_msg_pub.initialize;
49: x_object_version_number := 1;
50:
51: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
52: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');
53: fnd_msg_pub.ADD;
54: v_error := 'Y';
55: END IF;

Line 57: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN

53: fnd_msg_pub.ADD;
54: v_error := 'Y';
55: END IF;
56:
57: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN
58: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');
59: fnd_msg_pub.ADD;
60: v_error := 'Y';
61: END IF;

Line 63: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN

59: fnd_msg_pub.ADD;
60: v_error := 'Y';
61: END IF;
62:
63: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN
64: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
65: fnd_msg_pub.ADD;
66: v_error := 'Y';
67: END IF;

Line 69: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN

65: fnd_msg_pub.ADD;
66: v_error := 'Y';
67: END IF;
68:
69: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
70: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
71: fnd_message.set_token('P_Start_Date', x_start_date_active);
72: fnd_message.set_token('P_End_Date', x_end_date_active);
73: fnd_msg_pub.ADD;

Line 78: IF jtf_cal_shift_constructs_pkg.not_null_char(x_availability_type_code) = FALSE THEN

74: v_error := 'Y';
75: END IF;
76:
77:
78: IF jtf_cal_shift_constructs_pkg.not_null_char(x_availability_type_code) = FALSE THEN
79: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');
80: fnd_msg_pub.ADD;
81: v_error := 'Y';
82: END IF;

Line 100: SELECT jtf_cal_shift_constructs_s.NEXTVAL

96: IF v_error = 'Y' THEN
97: x_error := 'Y';
98: RETURN;
99: ELSE
100: SELECT jtf_cal_shift_constructs_s.NEXTVAL
101: INTO v_shift_construct_id
102: FROM DUAL;
103:
104: -- Code Added by Venkat Putcha for duplicate sequence checking

Line 107: FROM jtf_cal_shift_constructs

103:
104: -- Code Added by Venkat Putcha for duplicate sequence checking
105: SELECT COUNT(*)
106: INTO chk_shift
107: FROM jtf_cal_shift_constructs
108: WHERE shift_construct_id = v_shift_construct_id;
109:
110: IF chk_shift > 0 THEN
111: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');

Line 126: 'JTF_CAL_SHIFT_CONSTRUCTS_PKG',

122: /* Add User Hook Check for INSERT by Jane Wang on 01/25/02 */
123: /* Comment the User Hook Check out by Jane Wang on 03/12/02 */
124: /*
125: IF jtf_usr_hks.ok_to_execute(
126: 'JTF_CAL_SHIFT_CONSTRUCTS_PKG',
127: 'INSERT_ROW',
128: 'B',
129: 'C')
130: THEN

Line 168: INSERT INTO jtf_cal_shift_constructs

164:
165: END IF; -- End of User Hook Check for INSERT
166: */
167: BEGIN
168: INSERT INTO jtf_cal_shift_constructs
169: (
170: shift_construct_id
171: , shift_id
172: , unit_of_time_value

Line 305: FROM jtf_cal_shift_constructs

301: , attribute14
302: , attribute15
303: , attribute_category
304: , shift_construct_id
305: FROM jtf_cal_shift_constructs
306: WHERE shift_construct_id = x_shift_construct_id
307: FOR UPDATE OF shift_construct_id NOWAIT;
308:
309: v_error CHAR := 'N';

Line 413: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN

409: l_object_version_number NUMBER;
410: BEGIN
411: fnd_msg_pub.initialize;
412:
413: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
414: --fnd_message.set_name('JTF', 'BEGIN_TIME CANNOT BE NULL');
415: --app_exception.raise_exception;
416: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');
417: --fnd_message.set_token('P_Name', 'BEGIN_TIME');

Line 422: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN

418: fnd_msg_pub.ADD;
419: v_error := 'Y';
420: END IF;
421:
422: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN
423: --fnd_message.set_name('JTF', 'END_TIME CANNOT BE NULL');
424: --app_exception.raise_exception;
425: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');
426: --fnd_message.set_token('P_Name', 'END_TIME');

Line 431: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN

427: fnd_msg_pub.ADD;
428: v_error := 'Y';
429: END IF;
430:
431: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN
432: --fnd_message.set_name('JTF', 'START_TIME IS GREATER THAN END_TIME');
433: --app_exception.raise_exception;
434: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
435: --fnd_message.set_token('P_Start_Date', X_BEGIN_TIME);

Line 441: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN

437: fnd_msg_pub.ADD;
438: v_error := 'Y';
439: END IF;
440:
441: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
442: --fnd_message.set_name('JTF', 'START_DATE IS GREATER THAN END DATE');
443: --app_exception.raise_exception;
444: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
445: fnd_message.set_token('P_Start_Date', x_start_date_active);

Line 452: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.NOT_NULL(X_AVAILABILITY_TYPE_CODE) = FALSE THEN

448: v_error := 'Y';
449: END IF;
450:
451: /*
452: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.NOT_NULL(X_AVAILABILITY_TYPE_CODE) = FALSE THEN
453: --fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE CANNOT BE NULL');
454: --app_exception.raise_exception;
455: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');
456: --fnd_message.set_token('P_Name', 'AVAILABILITY_TYPE_CODE');

Line 461: --IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.VALIDATE_FND_LOOKUPS(X_AVAILABILITY_TYPE_CODE, 'AVAILABILITY TYPE')

457: fnd_msg_pub.add;
458: v_error := 'Y';
459: END IF;
460:
461: --IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.VALIDATE_FND_LOOKUPS(X_AVAILABILITY_TYPE_CODE, 'AVAILABILITY TYPE')
462: -- = FALSE THEN
463: -- fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE DOES NOT EXIST IN FND_LOOKUPS');
464: -- app_exception.raise_exception;
465: -- v_error := 'Y';

Line 468: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.DUPLICATION_SHIFT(X_SHIFT_ID, X_UNIT_OF_TIME_VALUE,

464: -- app_exception.raise_exception;
465: -- v_error := 'Y';
466: --END IF;
467:
468: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.DUPLICATION_SHIFT(X_SHIFT_ID, X_UNIT_OF_TIME_VALUE,
469: X_BEGIN_TIME, X_END_TIME,
470: X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
471: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');
472: --app_exception.raise_exception;

Line 479: IF jtf_cal_shift_constructs_pkg.not_null(x_start_date_active) = FALSE THEN

475: fnd_msg_pub.add;
476: v_error := 'Y';
477: END IF;
478: */
479: IF jtf_cal_shift_constructs_pkg.not_null(x_start_date_active) = FALSE THEN
480: --fnd_message.set_name('JTF', 'START_DATE_ACTIVE CANNOT BE NULL');
481: --app_exception.raise_exception;
482: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
483: fnd_msg_pub.ADD;

Line 490: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.OVERLAP_SHIFT(X_SHIFT_ID, X_UNIT_OF_TIME_VALUE,

486:
487: -- Comment out by Jane Wang on 03/12/2002
488: -- To allow a user to define two shift patterns for the same day
489: /*
490: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.OVERLAP_SHIFT(X_SHIFT_ID, X_UNIT_OF_TIME_VALUE,
491: X_BEGIN_TIME, X_END_TIME,
492: X_START_DATE_ACTIVE, X_END_DATE_ACTIVE,
493: X_SHIFT_CONSTRUCT_ID) = FALSE THEN
494: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');

Line 510: 'JTF_CAL_SHIFT_CONSTRUCTS_PKG',

506: /* Comment the User Hook Check by Jane Wang on 03/12/02 */
507:
508: /*
509: IF jtf_usr_hks.ok_to_execute(
510: 'JTF_CAL_SHIFT_CONSTRUCTS_PKG',
511: 'UPDATE_ROW',
512: 'B',
513: 'C')
514: THEN

Line 544: UPDATE jtf_cal_shift_constructs

540: );
541: END IF; -- End of User Hook Check for UPDATE
542: */
543: BEGIN
544: UPDATE jtf_cal_shift_constructs
545: SET
546: -- SHIFT_ID = X_SHIFT_ID,
547: unit_of_time_value = x_unit_of_time_value
548: , begin_time = x_begin_time

Line 614: DELETE FROM jtf_cal_shift_constructs

610: IF v_error = 'Y' THEN
611: x_error := 'Y';
612: RETURN;
613: ELSE
614: DELETE FROM jtf_cal_shift_constructs
615: WHERE shift_construct_id = x_shift_construct_id;
616: END IF;
617: END delete_row;
618:

Line 669: FROM jtf_cal_shift_constructs

665: , begin_time
666: , end_time
667: , start_date_active
668: , end_date_active
669: FROM jtf_cal_shift_constructs
670: WHERE shift_id = x_shift_id;
671: BEGIN
672: -- Shift is unique
673: FOR dup_rec IN dup LOOP

Line 706: FROM jtf_cal_shift_constructs

702: , unit_of_time_value
703: , begin_time
704: , end_time
705: , shift_construct_id
706: FROM jtf_cal_shift_constructs
707: WHERE shift_id = x_shift_id;
708:
709: l_error NUMBER := 1;
710:

Line 713: FROM jtf_cal_shift_constructs

709: l_error NUMBER := 1;
710:
711: CURSOR c_check_1(l_shift_id NUMBER, l_day DATE) IS
712: SELECT shift_construct_id
713: FROM jtf_cal_shift_constructs
714: WHERE shift_id = l_shift_id AND begin_time <= l_day;
715:
716: r_check_1 c_check_1%ROWTYPE;
717:

Line 722: FROM jtf_cal_shift_constructs

718: CURSOR c_check_2(l_shift_id NUMBER, l_day DATE) IS
719: SELECT begin_time
720: , end_time
721: , shift_construct_id
722: FROM jtf_cal_shift_constructs
723: WHERE shift_id = l_shift_id AND TRUNC(end_time) > TO_DATE('07/01/1995', 'DD/MM/YYYY');
724:
725: r_check_2 c_check_2%ROWTYPE;
726: l_start_date DATE;

Line 864: from jtf_cal_shift_constructs

860: X_BEGIN_TIME IN DATE, X_END_TIME IN DATE,
861: X_START_DATE_ACTIVE IN DATE, X_END_DATE_ACTIVE IN DATE) RETURN boolean IS
862: cursor dup is
863: select shift_id, unit_of_time_value, begin_time, end_time, start_date_active, end_date_active
864: from jtf_cal_shift_constructs
865: where shift_id = X_SHIFT_ID;
866:
867: BEGIN
868: -- Shift is unique

Line 883: END jtf_cal_shift_constructs_pkg;

879: END IF;
880: end loop;
881: END overlap_shift;
882: */
883: END jtf_cal_shift_constructs_pkg;