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_ASSIGN_PKG dependencies on JTF_CAL_SHIFT_ASSIGN

Line 1: package body JTF_CAL_SHIFT_ASSIGN_PKG as

1: package body JTF_CAL_SHIFT_ASSIGN_PKG as
2: /* $Header: jtfclsab.pls 115.19 2002/11/15 14:37:04 sukulkar ship $ */
3: procedure INSERT_ROW (
4: X_ERROR out NOCOPY VARCHAR2,
5: X_ROWID in out NOCOPY VARCHAR2,

Line 36: -- cursor C is select ROWID from JTF_CAL_SHIFT_ASSIGN

32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: count_cal number;
35: temp_count number;
36: -- cursor C is select ROWID from JTF_CAL_SHIFT_ASSIGN
37: -- where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID;
38:
39: v_error CHAR := 'N';
40: v_jtf_cal_shift_assign_s NUMBER;

Line 40: v_jtf_cal_shift_assign_s NUMBER;

36: -- cursor C is select ROWID from JTF_CAL_SHIFT_ASSIGN
37: -- where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID;
38:
39: v_error CHAR := 'N';
40: v_jtf_cal_shift_assign_s NUMBER;
41: begin
42: fnd_msg_pub.initialize;
43: select count(*) into count_cal
44: from jtf_cal_shift_assign

Line 44: from jtf_cal_shift_assign

40: v_jtf_cal_shift_assign_s NUMBER;
41: begin
42: fnd_msg_pub.initialize;
43: select count(*) into count_cal
44: from jtf_cal_shift_assign
45: where calendar_id = X_CALENDAR_ID;
46:
47: IF count_cal > 0 THEN
48: select count(*) into temp_count

Line 49: from jtf_cal_shift_assign

45: where calendar_id = X_CALENDAR_ID;
46:
47: IF count_cal > 0 THEN
48: select count(*) into temp_count
49: from jtf_cal_shift_assign
50: where calendar_id = X_CALENDAR_ID
51: and shift_id = X_SHIFT_ID
52: and shift_start_date = TRUNC(X_SHIFT_START_DATE)
53: and shift_end_date = TRUNC(X_SHIFT_END_DATE);

Line 64: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)

60:
61: v_error := 'Y';
62: END IF;
63:
64: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)
65: = FALSE THEN
66: --fnd_message.set_name('JTF', 'DUPLICATE RECORD ENTERED');
67: --app_exception.raise_exception;
68: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE_ASSIGNMENT');

Line 76: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN

72: v_error := 'Y';
73:
74: END IF;
75:
76: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN
77: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
78: fnd_message.set_token('P_Shift_Seq_Num', X_SHIFT_SEQUENCE_NUMBER);
79: fnd_msg_pub.add;
80: v_error := 'Y';

Line 85: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_ID) = FALSE THEN

81: END IF;
82: */
83: END IF;
84:
85: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_ID) = FALSE THEN
86: --fnd_message.set_name('JTF', 'SHIFT_ID CANNOT BE NULL');
87: --app_exception.raise_exception;
88: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_NAME');
89: --fnd_message.set_token('P_Name', 'SHIFT');

Line 95: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN

91:
92: v_error := 'Y';
93: END IF;
94:
95: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN
96: --fnd_message.set_name('JTF', 'SHIFT_START_DATE CANNOT BE NULL');
97: --app_exception.raise_exception;
98: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
99: fnd_msg_pub.add;

Line 103: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN

99: fnd_msg_pub.add;
100: v_error := 'Y';
101: END IF;
102:
103: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN
104: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
105: --app_exception.raise_exception;
106: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
107: fnd_message.set_token('P_Start_Date', X_SHIFT_START_DATE);

Line 114: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN

110: v_error := 'Y';
111: END IF;
112:
113: /*
114: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN
115: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
116: fnd_message.set_token('P_Shift_Seq_Num', X_SHIFT_SEQUENCE_NUMBER);
117: fnd_msg_pub.add;
118: v_error := 'Y';

Line 127: SELECT jtf_cal_shift_assign_s.nextval

123: X_ERROR := 'Y';
124: return;
125: ELSE
126:
127: SELECT jtf_cal_shift_assign_s.nextval
128: INTO v_jtf_cal_shift_assign_s
129: FROM dual;
130:
131: X_CAL_SHIFT_ASSIGN_ID := v_jtf_cal_shift_assign_s;

Line 128: INTO v_jtf_cal_shift_assign_s

124: return;
125: ELSE
126:
127: SELECT jtf_cal_shift_assign_s.nextval
128: INTO v_jtf_cal_shift_assign_s
129: FROM dual;
130:
131: X_CAL_SHIFT_ASSIGN_ID := v_jtf_cal_shift_assign_s;
132:

Line 131: X_CAL_SHIFT_ASSIGN_ID := v_jtf_cal_shift_assign_s;

127: SELECT jtf_cal_shift_assign_s.nextval
128: INTO v_jtf_cal_shift_assign_s
129: FROM dual;
130:
131: X_CAL_SHIFT_ASSIGN_ID := v_jtf_cal_shift_assign_s;
132:
133: insert into JTF_CAL_SHIFT_ASSIGN (
134: OBJECT_VERSION_NUMBER,
135: SHIFT_START_DATE,

Line 133: insert into JTF_CAL_SHIFT_ASSIGN (

129: FROM dual;
130:
131: X_CAL_SHIFT_ASSIGN_ID := v_jtf_cal_shift_assign_s;
132:
133: insert into JTF_CAL_SHIFT_ASSIGN (
134: OBJECT_VERSION_NUMBER,
135: SHIFT_START_DATE,
136: SHIFT_END_DATE,
137: CAL_SHIFT_ASSIGN_ID,

Line 166: v_jtf_cal_shift_assign_s,

162: ) values
163: ( 1,
164: X_SHIFT_START_DATE,
165: X_SHIFT_END_DATE,
166: v_jtf_cal_shift_assign_s,
167: X_CALENDAR_ID,
168: X_SHIFT_SEQUENCE_NUMBER,
169: X_SHIFT_ID,
170: FND_GLOBAL.USER_ID,

Line 249: from JTF_CAL_SHIFT_ASSIGN

245: ATTRIBUTE14,
246: ATTRIBUTE15,
247: ATTRIBUTE_CATEGORY,
248: CAL_SHIFT_ASSIGN_ID
249: from JTF_CAL_SHIFT_ASSIGN
250: where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID
251: for update of CAL_SHIFT_ASSIGN_ID nowait;
252: begin
253: for tlinfo in c1 loop

Line 339: from jtf_cal_shift_assign

335: begin
336: fnd_msg_pub.initialize;
337:
338: select count(*) into temp_count
339: from jtf_cal_shift_assign
340: where calendar_id = X_CALENDAR_ID
341: and shift_id = X_SHIFT_ID
342: and shift_start_date = TRUNC(X_SHIFT_START_DATE)
343: and shift_end_date = TRUNC(X_SHIFT_END_DATE);

Line 353: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)

349: fnd_msg_pub.add;
350: v_error := 'Y';
351: END IF;
352:
353: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)
354: = FALSE THEN
355: --fnd_message.set_name('JTF', 'DUPLICATE RECORD ENTERED');
356: --app_exception.raise_exception;
357: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE_ASSIGNMENT');

Line 365: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_ID) = FALSE THEN

361: v_error := 'Y';
362:
363: END IF;
364: */
365: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_ID) = FALSE THEN
366: --fnd_message.set_name('JTF', 'SHIFT_ID CANNOT BE NULL');
367: --app_exception.raise_exception;
368: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_NAME');
369: --fnd_message.set_token('P_Name', 'SHIFT');

Line 375: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN

371:
372: v_error := 'Y';
373: END IF;
374:
375: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN
376: --fnd_message.set_name('JTF', 'SHIFT_START_DATE CANNOT BE NULL');
377: --app_exception.raise_exception;
378: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
379: fnd_msg_pub.add;

Line 383: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN

379: fnd_msg_pub.add;
380: v_error := 'Y';
381: END IF;
382:
383: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN
384: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
385: --app_exception.raise_exception;
386: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
387: fnd_message.set_token('P_Start_Date', X_SHIFT_START_DATE);

Line 398: update JTF_CAL_SHIFT_ASSIGN set

394: X_ERROR := 'Y';
395: return;
396: ELSE
397:
398: update JTF_CAL_SHIFT_ASSIGN set
399: object_version_number = object_version_number + 1,
400: SHIFT_START_DATE = X_SHIFT_START_DATE,
401: SHIFT_END_DATE = X_SHIFT_END_DATE,
402: CALENDAR_ID = X_CALENDAR_ID,

Line 437: delete from JTF_CAL_SHIFT_ASSIGN

433: procedure DELETE_ROW (
434: X_CAL_SHIFT_ASSIGN_ID in NUMBER
435: ) is
436: begin
437: delete from JTF_CAL_SHIFT_ASSIGN
438: where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID;
439:
440: if (sql%notfound) then
441: raise no_data_found;

Line 469: from jtf_cal_shift_assign

465:
466: X_FOUND CHAR := 'N';
467: cursor dup is
468: select 'x'
469: from jtf_cal_shift_assign
470: where shift_id = X_SHIFT_ID
471: and shift_start_date = TRUNC(X_SHIFT_START_DATE)
472: AND shift_end_date = TRUNC(X_SHIFT_END_DATE)
473: AND rownum < 2;

Line 496: from jtf_cal_shift_assign

492:
493: X_FOUND CHAR := 'N';
494: cursor dup is
495: select 'x'
496: from jtf_cal_shift_assign
497: where shift_id = X_SHIFT_ID
498: and shift_sequence_number = X_SHIFT_SEQUENCE_NUMBER
499: AND rownum < 2;
500:

Line 515: end JTF_CAL_SHIFT_ASSIGN_PKG;

511: close dup;
512: END;
513:
514:
515: end JTF_CAL_SHIFT_ASSIGN_PKG;