eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_ADHOC_USER_PVT dependencies on FND_TABLE_OF_VARCHAR2_255

Line 14: p_originalrecipient IN FND_TABLE_OF_VARCHAR2_255,

10: procedure UPDATE_SIGNERLIST (
11: p_event_id IN number,
12: p_event_name IN VARCHAR2 ,
13: p_document_id IN number,
14: p_originalrecipient IN FND_TABLE_OF_VARCHAR2_255,
15: p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255,
16: p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,
17: p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,
18: p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,

Line 15: p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255,

11: p_event_id IN number,
12: p_event_name IN VARCHAR2 ,
13: p_document_id IN number,
14: p_originalrecipient IN FND_TABLE_OF_VARCHAR2_255,
15: p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255,
16: p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,
17: p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,
18: p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
19: p_originating_system IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,

Line 16: p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,

12: p_event_name IN VARCHAR2 ,
13: p_document_id IN number,
14: p_originalrecipient IN FND_TABLE_OF_VARCHAR2_255,
15: p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255,
16: p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,
17: p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,
18: p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
19: p_originating_system IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
20: p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,

Line 17: p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,

13: p_document_id IN number,
14: p_originalrecipient IN FND_TABLE_OF_VARCHAR2_255,
15: p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255,
16: p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,
17: p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,
18: p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
19: p_originating_system IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
20: p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
21: x_error OUT NOCOPY NUMBER,

Line 18: p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,

14: p_originalrecipient IN FND_TABLE_OF_VARCHAR2_255,
15: p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255,
16: p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,
17: p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,
18: p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
19: p_originating_system IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
20: p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
21: x_error OUT NOCOPY NUMBER,
22: x_error_msg OUT NOCOPY VARCHAR2

Line 19: p_originating_system IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,

15: p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255,
16: p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,
17: p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,
18: p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
19: p_originating_system IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
20: p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
21: x_error OUT NOCOPY NUMBER,
22: x_error_msg OUT NOCOPY VARCHAR2
23: ) IS PRAGMA AUTONOMOUS_TRANSACTION;

Line 20: p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,

16: p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,
17: p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,
18: p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
19: p_originating_system IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
20: p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
21: x_error OUT NOCOPY NUMBER,
22: x_error_msg OUT NOCOPY VARCHAR2
23: ) IS PRAGMA AUTONOMOUS_TRANSACTION;
24:

Line 39: l_updatestatus FND_TABLE_OF_VARCHAR2_255 := FND_TABLE_OF_VARCHAR2_255();

35: l_error number;
36: l_error_msg varchar2(4000);
37: l_status varchar2(1);
38: l_adhoc_status varchar2(32);
39: l_updatestatus FND_TABLE_OF_VARCHAR2_255 := FND_TABLE_OF_VARCHAR2_255();
40: cursor GET_SIGNERS_FOR_EVENT is
41: --Bug 4272262: Start
42: select user_name, original_recipient, to_number(signature_sequence,'999999999999.999999')
43: --Bug 4272262: End