APPS.ENG_ECN_APPROVAL_LISTS_PKG dependencies on ENG_ECN_APPROVAL_LISTS

Line 1: PACKAGE BODY ENG_ECN_APPROVAL_LISTS_PKG as

1: PACKAGE BODY ENG_ECN_APPROVAL_LISTS_PKG as
2: /*$Header: ENGAPPLB.pls 115.7 2004/05/11 13:26:01 amalviya ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 32: CURSOR C IS SELECT rowid FROM eng_ecn_approval_lists

28: X_Last_Update_Login NUMBER DEFAULT NULL,
29: X_Last_Update_Date DATE,
30: X_Last_Updated_By NUMBER
31: ) IS
32: CURSOR C IS SELECT rowid FROM eng_ecn_approval_lists
33: WHERE approval_list_id = X_Approval_List_Id;
34: CURSOR C2 IS SELECT eng_ecn_approval_lists_s.nextval FROM dual;
35:
36: myList wf_parameter_list_t;

Line 34: CURSOR C2 IS SELECT eng_ecn_approval_lists_s.nextval FROM dual;

30: X_Last_Updated_By NUMBER
31: ) IS
32: CURSOR C IS SELECT rowid FROM eng_ecn_approval_lists
33: WHERE approval_list_id = X_Approval_List_Id;
34: CURSOR C2 IS SELECT eng_ecn_approval_lists_s.nextval FROM dual;
35:
36: myList wf_parameter_list_t;
37: l_username varchar2(320);
38: BEGIN

Line 44: INSERT INTO eng_ecn_approval_lists(

40: OPEN C2;
41: FETCH C2 INTO X_Approval_List_Id;
42: CLOSE C2;
43: end if;
44: INSERT INTO eng_ecn_approval_lists(
45: approval_list_id,
46: approval_list_name,
47: disable_date,
48: description,

Line 145: FROM eng_ecn_approval_lists

141: X_Attribute15 VARCHAR2 DEFAULT NULL
142: ) IS
143: CURSOR C IS
144: SELECT *
145: FROM eng_ecn_approval_lists
146: WHERE rowid = X_Rowid
147: FOR UPDATE of Approval_List_Id NOWAIT;
148: Recinfo C%ROWTYPE;
149: BEGIN

Line 264: UPDATE eng_ecn_approval_lists

260: l_username varchar2(320);
261: lemail WF_LOCAL_ROLES.EMAIL_ADDRESS%type;
262: lfax WF_LOCAL_ROLES.FAX%type;
263: BEGIN
264: UPDATE eng_ecn_approval_lists
265: SET
266: approval_list_id = X_Approval_List_Id,
267: approval_list_name = X_Approval_List_Name,
268: disable_date = X_Disable_Date,

Line 350: from eng_ecn_approval_lists

346:
347: BEGIN
348:
349: select approval_list_id into x_approval_list_id
350: from eng_ecn_approval_lists
351: where rowid = X_Rowid;
352:
353: DELETE FROM eng_ecn_approval_lists
354: WHERE rowid = X_Rowid;

Line 353: DELETE FROM eng_ecn_approval_lists

349: select approval_list_id into x_approval_list_id
350: from eng_ecn_approval_lists
351: where rowid = X_Rowid;
352:
353: DELETE FROM eng_ecn_approval_lists
354: WHERE rowid = X_Rowid;
355: if (SQL%NOTFOUND) then
356: RAISE NO_DATA_FOUND;
357: end if;

Line 390: (SELECT 1 FROM ENG_ECN_APPROVAL_LISTS

386: X_Approval_List_Name VARCHAR2) IS
387: DUMMY NUMBER;
388: BEGIN
389: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
390: (SELECT 1 FROM ENG_ECN_APPROVAL_LISTS
391: WHERE (Approval_List_Name = X_Approval_List_Name)
392: AND ((X_Rowid is NULL) or (ROWID <> X_Rowid))
393: );
394: EXCEPTION

Line 400: END ENG_ECN_APPROVAL_LISTS_PKG ;

396: -- FND_MESSAGE.SET_NAME('ENG', 'Approval List Name Already Used');
397: APP_EXCEPTION.RAISE_EXCEPTION;
398: END Check_Unique;
399:
400: END ENG_ECN_APPROVAL_LISTS_PKG ;