APPS.EDR_ERES_EVENT_PVT dependencies on FND_TABLE_OF_VARCHAR2_255

Line 567: x_approvers_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,

563: x_msg_data OUT NOCOPY VARCHAR2 ,
564: p_event_name IN VARCHAR2 ,
565: p_event_key IN VARCHAR2 ,
566: x_approver_count OUT NOCOPY NUMBER ,
567: x_approvers_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
568: x_approvers_role_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
569: x_overriding_details OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
570: x_approvers_sequence OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
571: )

Line 568: x_approvers_role_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,

564: p_event_name IN VARCHAR2 ,
565: p_event_key IN VARCHAR2 ,
566: x_approver_count OUT NOCOPY NUMBER ,
567: x_approvers_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
568: x_approvers_role_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
569: x_overriding_details OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
570: x_approvers_sequence OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
571: )
572: AS

Line 569: x_overriding_details OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,

565: p_event_key IN VARCHAR2 ,
566: x_approver_count OUT NOCOPY NUMBER ,
567: x_approvers_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
568: x_approvers_role_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
569: x_overriding_details OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
570: x_approvers_sequence OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
571: )
572: AS
573: l_api_name CONSTANT VARCHAR2(30) := 'GET_EVENT_APPROVERS';

Line 570: x_approvers_sequence OUT NOCOPY FND_TABLE_OF_VARCHAR2_255

566: x_approver_count OUT NOCOPY NUMBER ,
567: x_approvers_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
568: x_approvers_role_name OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
569: x_overriding_details OUT NOCOPY FND_TABLE_OF_VARCHAR2_255 ,
570: x_approvers_sequence OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
571: )
572: AS
573: l_api_name CONSTANT VARCHAR2(30) := 'GET_EVENT_APPROVERS';
574: l_api_version CONSTANT NUMBER := 1.0;

Line 707: x_approvers_name := fnd_table_of_varchar2_255('');

703: --Bug 2674799: end
704:
705:
706: --initialize the return tables
707: x_approvers_name := fnd_table_of_varchar2_255('');
708: x_approvers_role_name := fnd_table_of_varchar2_255('');
709: x_overriding_details := fnd_table_of_varchar2_255('');
710: x_approvers_sequence := fnd_table_of_varchar2_255('');
711:

Line 708: x_approvers_role_name := fnd_table_of_varchar2_255('');

704:
705:
706: --initialize the return tables
707: x_approvers_name := fnd_table_of_varchar2_255('');
708: x_approvers_role_name := fnd_table_of_varchar2_255('');
709: x_overriding_details := fnd_table_of_varchar2_255('');
710: x_approvers_sequence := fnd_table_of_varchar2_255('');
711:
712: --for each user id returned by ame get the user_name from fnd schema

Line 709: x_overriding_details := fnd_table_of_varchar2_255('');

705:
706: --initialize the return tables
707: x_approvers_name := fnd_table_of_varchar2_255('');
708: x_approvers_role_name := fnd_table_of_varchar2_255('');
709: x_overriding_details := fnd_table_of_varchar2_255('');
710: x_approvers_sequence := fnd_table_of_varchar2_255('');
711:
712: --for each user id returned by ame get the user_name from fnd schema
713: --and the role name from the wf directory services

Line 710: x_approvers_sequence := fnd_table_of_varchar2_255('');

706: --initialize the return tables
707: x_approvers_name := fnd_table_of_varchar2_255('');
708: x_approvers_role_name := fnd_table_of_varchar2_255('');
709: x_overriding_details := fnd_table_of_varchar2_255('');
710: x_approvers_sequence := fnd_table_of_varchar2_255('');
711:
712: --for each user id returned by ame get the user_name from fnd schema
713: --and the role name from the wf directory services
714: while (i <= l_approver_list.count) loop