APPS.JTF_CAL_SHIFT_ASSIGN_PKG dependencies on JTF_CAL_SHIFT_ASSIGN_S

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 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 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 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,