DBA Data[Home] [Help]

APPS.ENG_ECN_APPROVAL_LISTS_PKG dependencies on WF_PARAMETER_LIST_T

Line 36: myList wf_parameter_list_t;

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
39: if (X_Approval_List_Id is NULL) then
40: OPEN C2;

Line 259: myList wf_parameter_list_t;

255: USER_ORIG_SYSTEM,USER_ORIG_SYSTEM_ID
256: from WF_LOCAL_USER_ROLES
257: where role_orig_system= 'ENG_LIST' and
258: role_orig_system_id = X_Approval_List_Id;
259: myList wf_parameter_list_t;
260: l_username varchar2(320);
261: lemail WF_LOCAL_ROLES.EMAIL_ADDRESS%type;
262: lfax WF_LOCAL_ROLES.FAX%type;
263: BEGIN

Line 345: myList wf_parameter_list_t;

341: END Update_Row;
342:
343: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
344: x_approval_list_id number;
345: myList wf_parameter_list_t;
346:
347: BEGIN
348:
349: select approval_list_id into x_approval_list_id