APPS.PER_SPINAL_PT_PLCMT_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 41: from per_spinal_point_placements_f

37: l_exists VARCHAR2(1);
38:
39: cursor c1 is
40: select 'x'
41: from per_spinal_point_placements_f
42: where assignment_id = p_ass_id
43: and placement_id <> p_pmt_id
44: and effective_start_date > p_eed;
45: --

Line 130: from per_spinal_point_placements_f

126: l_exists VARCHAR2(1);
127:
128: cursor c3 is
129: select 'x'
130: from per_spinal_point_placements_f
131: where assignment_id = p_ass_id
132: and effective_end_date >= p_sess;
133: --
134: begin

Line 195: CURSOR C IS SELECT rowid FROM per_spinal_point_placements_f

191: X_Information29 VARCHAR2,
192: X_Information30 VARCHAR2,
193: X_Information_category VARCHAR2
194: ) IS
195: CURSOR C IS SELECT rowid FROM per_spinal_point_placements_f
196: WHERE placement_id = x_placement_id;
197:
198: CURSOR C2 IS SELECT per_spinal_point_placements_s.nextval FROM sys.dual;
199: BEGIN

Line 205: INSERT INTO per_spinal_point_placements_f(

201: OPEN C2;
202: FETCH C2 INTO X_placement_id;
203: CLOSE C2;
204: end if;
205: INSERT INTO per_spinal_point_placements_f(
206: placement_id,
207: effective_start_date,
208: effective_end_date,
209: business_group_id,

Line 344: FROM per_spinal_point_placements_f

340: X_Information_category VARCHAR2
341: ) IS
342: CURSOR C IS
343: SELECT *
344: FROM per_spinal_point_placements_f
345: WHERE rowid = chartorowid(X_Rowid)
346: FOR UPDATE of placement_id NOWAIT;
347: Recinfo C%ROWTYPE;
348: BEGIN

Line 441: UPDATE per_spinal_point_placements_f

437: X_Information30 VARCHAR2,
438: X_Information_category VARCHAR2
439: ) IS
440: BEGIN
441: UPDATE per_spinal_point_placements_f
442: SET
443: placement_id = X_Placement_Id,
444: effective_start_date = X_Effective_Start_Date,
445: effective_end_date = X_Effective_End_Date,

Line 495: DELETE FROM per_spinal_point_placements_f

491:
492:
493: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
494: BEGIN
495: DELETE FROM per_spinal_point_placements_f
496: WHERE rowid = chartorowid(X_rowid);
497:
498: if (SQL%NOTFOUND) then
499: RAISE NO_DATA_FOUND;