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,
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,
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,
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,
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
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;
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:
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