APPS.ENG_ECN_APPROVERS_PKG dependencies on ENG_ECN_APPROVERS

Line 1: PACKAGE BODY ENG_ECN_APPROVERS_PKG as

1: PACKAGE BODY ENG_ECN_APPROVERS_PKG as
2: /* $Header: ENGAPPRB.pls 120.1 2006/03/27 06:53:58 sdarbha noship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 34: CURSOR C IS SELECT rowid FROM eng_ecn_approvers

30: X_Last_Update_Login NUMBER DEFAULT NULL,
31: X_Last_Update_Date DATE,
32: X_Last_Updated_By NUMBER
33: ) IS
34: CURSOR C IS SELECT rowid FROM eng_ecn_approvers
35: WHERE approval_list_id = X_Approval_List_Id;
36: BEGIN
37: INSERT INTO eng_ecn_approvers
38: (

Line 37: INSERT INTO eng_ecn_approvers

33: ) IS
34: CURSOR C IS SELECT rowid FROM eng_ecn_approvers
35: WHERE approval_list_id = X_Approval_List_Id;
36: BEGIN
37: INSERT INTO eng_ecn_approvers
38: (
39: approval_list_id,
40: employee_id,
41: sequence1,

Line 143: FROM eng_ecn_approvers

139:
140: ) IS
141: CURSOR C IS
142: SELECT *
143: FROM eng_ecn_approvers
144: WHERE rowid = X_Rowid
145: FOR UPDATE of Approval_List_Id NOWAIT;
146: Recinfo C%ROWTYPE;
147: BEGIN

Line 265: FROM eng_ecn_approvers

261: -- Bug 3817690
262: -- Fetch the employee id for the row to be updated
263: SELECT Employee_Id
264: INTO l_old_employee_id
265: FROM eng_ecn_approvers
266: WHERE rowid = X_rowid;
267:
268: UPDATE eng_ecn_approvers
269: SET

Line 268: UPDATE eng_ecn_approvers

264: INTO l_old_employee_id
265: FROM eng_ecn_approvers
266: WHERE rowid = X_rowid;
267:
268: UPDATE eng_ecn_approvers
269: SET
270: approval_list_id = X_Approval_List_Id,
271: employee_id = X_Employee_Id,
272: sequence1 = X_Sequence1,

Line 336: from eng_ecn_approvers

332: BEGIN
333:
334: select employee_id, approval_list_id
335: into l_employee_id, l_approval_list_id
336: from eng_ecn_approvers
337: where rowid = X_Rowid ;
338:
339: DELETE FROM eng_ecn_approvers
340: WHERE rowid = X_Rowid;

Line 339: DELETE FROM eng_ecn_approvers

335: into l_employee_id, l_approval_list_id
336: from eng_ecn_approvers
337: where rowid = X_Rowid ;
338:
339: DELETE FROM eng_ecn_approvers
340: WHERE rowid = X_Rowid;
341: if (SQL%NOTFOUND) then
342: RAISE NO_DATA_FOUND;
343: end if;

Line 394: (SELECT 1 FROM ENG_ECN_APPROVERS

390: X_Sequence1 NUMBER) IS
391: DUMMY NUMBER;
392: BEGIN
393: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
394: (SELECT 1 FROM ENG_ECN_APPROVERS
395: WHERE
396: (Approval_List_Id = X_Approval_List_Id)
397: AND (Sequence1 = X_Sequence1)
398: AND ((X_Rowid is NULL) or (ROWID <> X_Rowid))

Line 406: END ENG_ECN_APPROVERS_PKG ;

402: FND_MESSAGE.SET_NAME('ENG', 'ENG_SEQUENCE_ENTER');
403: APP_EXCEPTION.RAISE_EXCEPTION;
404: END Check_Unique;
405:
406: END ENG_ECN_APPROVERS_PKG ;