APPS.PER_SECONDARY_ASS_STATUSES_PKG dependencies on PER_SECONDARY_ASS_STATUSES

Line 1: PACKAGE BODY PER_SECONDARY_ASS_STATUSES_PKG as

1: PACKAGE BODY PER_SECONDARY_ASS_STATUSES_PKG as
2: /* $Header: pesas01t.pkb 115.2 2003/02/10 17:09:39 eumenyio ship $ */
3: /*===========================================================================+
4: | Copyright (c) 1993 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 70: CURSOR C IS SELECT rowid FROM PER_SECONDARY_ASS_STATUSES

66: X_Attribute18 VARCHAR2,
67: X_Attribute19 VARCHAR2,
68: X_Attribute20 VARCHAR2
69: ) IS
70: CURSOR C IS SELECT rowid FROM PER_SECONDARY_ASS_STATUSES
71: WHERE secondary_ass_status_id = X_Secondary_Ass_Status_Id;
72:
73: CURSOR C2 IS SELECT per_secondary_ass_statuses_s.nextval FROM sys.dual;
74: BEGIN

Line 73: CURSOR C2 IS SELECT per_secondary_ass_statuses_s.nextval FROM sys.dual;

69: ) IS
70: CURSOR C IS SELECT rowid FROM PER_SECONDARY_ASS_STATUSES
71: WHERE secondary_ass_status_id = X_Secondary_Ass_Status_Id;
72:
73: CURSOR C2 IS SELECT per_secondary_ass_statuses_s.nextval FROM sys.dual;
74: BEGIN
75: --
76: check_unique_row(X_Assignment_Id
77: ,X_Assignment_Status_Type_Id

Line 102: INSERT INTO PER_SECONDARY_ASS_STATUSES(

98: OPEN C2;
99: FETCH C2 INTO X_Secondary_Ass_Status_Id;
100: CLOSE C2;
101: end if;
102: INSERT INTO PER_SECONDARY_ASS_STATUSES(
103: secondary_ass_status_id,
104: business_group_id,
105: assignment_id,
106: assignment_status_type_id,

Line 206: FROM PER_SECONDARY_ASS_STATUSES

202: X_Attribute20 VARCHAR2
203: ) IS
204: CURSOR C IS
205: SELECT *
206: FROM PER_SECONDARY_ASS_STATUSES
207: WHERE rowid = X_Rowid
208: FOR UPDATE of Secondary_Ass_Status_Id NOWAIT;
209: Recinfo C%ROWTYPE;
210: BEGIN

Line 392: UPDATE PER_SECONDARY_ASS_STATUSES

388: end if;
389: --
390: X_End_Date := set_end_date(X_Assignment_Id,X_End_Date);
391: --
392: UPDATE PER_SECONDARY_ASS_STATUSES
393: SET
394: secondary_ass_status_id = X_Secondary_Ass_Status_Id,
395: business_group_id = X_Business_Group_Id,
396: assignment_id = X_Assignment_Id,

Line 433: DELETE FROM PER_SECONDARY_ASS_STATUSES

429: END Update_Row;
430:
431: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
432: BEGIN
433: DELETE FROM PER_SECONDARY_ASS_STATUSES
434: WHERE rowid = X_Rowid;
435:
436: if (SQL%NOTFOUND) then
437: RAISE NO_DATA_FOUND;

Line 448: from per_secondary_ass_statuses

444: ,p_start_date date
445: ,p_rowid varchar2) is
446: cursor c is
447: select 'x'
448: from per_secondary_ass_statuses
449: where assignment_id = p_assignment_id
450: and assignment_status_type_id = p_assignment_status_type_id
451: and start_date = p_start_date
452: AND ((p_rowid IS NULL)

Line 537: END PER_SECONDARY_ASS_STATUSES_PKG;

533: end if;
534: end set_end_date;
535: --
536: --
537: END PER_SECONDARY_ASS_STATUSES_PKG;