APPS.EDR_UTILITIES dependencies on FND_TABLE_OF_VARCHAR2_255

Line 53: p_param_list IN OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

49:
50: PROCEDURE EDR_RAISE3( p_event_name IN varchar2,
51: p_event_key IN varchar2,
52: p_event_data IN clob default NULL,
53: p_param_list IN OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
54: p_send_date IN date default NULL,
55: p_param_value IN OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
56: );
57:

Line 55: p_param_value IN OUT NOCOPY FND_TABLE_OF_VARCHAR2_255

51: p_event_key IN varchar2,
52: p_event_data IN clob default NULL,
53: p_param_list IN OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
54: p_send_date IN date default NULL,
55: p_param_value IN OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
56: );
57:
58:
59: PROCEDURE EDR_NTF_HISTORY( document_id in varchar2,

Line 149: -- OUT : x_userid out FND_TABLE_OF_VARCHAR2_255

145: -- groupname
146: -- Pre-reqs : None.
147: -- Parameters :
148: -- IN : p_groupname in varchar2
149: -- OUT : x_userid out FND_TABLE_OF_VARCHAR2_255
150: -- x_usergroupname out FND_TABLE_OF_VARCHAR2_255
151: --
152: -- End of comments
153:

Line 150: -- x_usergroupname out FND_TABLE_OF_VARCHAR2_255

146: -- Pre-reqs : None.
147: -- Parameters :
148: -- IN : p_groupname in varchar2
149: -- OUT : x_userid out FND_TABLE_OF_VARCHAR2_255
150: -- x_usergroupname out FND_TABLE_OF_VARCHAR2_255
151: --
152: -- End of comments
153:
154: --Bug 3589701 : start

Line 159: x_userid out NOCOPY FND_TABLE_OF_VARCHAR2_255,

155: --Unsupport the functionality to search by group as ame has not released it.
156: --Whenever ame supports it, we will uncomment this.
157: /*
158: PROCEDURE getUseridFromAme(p_groupname in varchar2,
159: x_userid out NOCOPY FND_TABLE_OF_VARCHAR2_255,
160: x_usergroupname out NOCOPY FND_TABLE_OF_VARCHAR2_255);
161: */
162: --Bug 3589701 : end
163: --Bug 3164491 : end

Line 160: x_usergroupname out NOCOPY FND_TABLE_OF_VARCHAR2_255);

156: --Whenever ame supports it, we will uncomment this.
157: /*
158: PROCEDURE getUseridFromAme(p_groupname in varchar2,
159: x_userid out NOCOPY FND_TABLE_OF_VARCHAR2_255,
160: x_usergroupname out NOCOPY FND_TABLE_OF_VARCHAR2_255);
161: */
162: --Bug 3589701 : end
163: --Bug 3164491 : end
164:

Line 539: -- : X_AME_RULE_IDS FND_TABLE_OF_VARCHAR2_255: The AME rule ids.

535: -- : P_EVENT_NAME IN VARCHAR2: The event name representing the transaction.
536: -- : P_EVENT_KEY IN VARCHAR2: The event key identifying the transaction.
537: --
538: -- OUT
539: -- : X_AME_RULE_IDS FND_TABLE_OF_VARCHAR2_255: The AME rule ids.
540: -- : X_AME_RULE_DESCRIPTIONS FND_TABLE_OF_VARCHAR2_255: The AME rule descriptions.
541: -- : X_VARIABLE_NAMES FND_TABLE_OF_VARCHAR2_255: The rule variable names.
542: -- : X_VARIABLE_VALUES FND_TABLE_OF_VARCHAR2_255: The rule variable values.
543: --

Line 540: -- : X_AME_RULE_DESCRIPTIONS FND_TABLE_OF_VARCHAR2_255: The AME rule descriptions.

536: -- : P_EVENT_KEY IN VARCHAR2: The event key identifying the transaction.
537: --
538: -- OUT
539: -- : X_AME_RULE_IDS FND_TABLE_OF_VARCHAR2_255: The AME rule ids.
540: -- : X_AME_RULE_DESCRIPTIONS FND_TABLE_OF_VARCHAR2_255: The AME rule descriptions.
541: -- : X_VARIABLE_NAMES FND_TABLE_OF_VARCHAR2_255: The rule variable names.
542: -- : X_VARIABLE_VALUES FND_TABLE_OF_VARCHAR2_255: The rule variable values.
543: --
544:

Line 541: -- : X_VARIABLE_NAMES FND_TABLE_OF_VARCHAR2_255: The rule variable names.

537: --
538: -- OUT
539: -- : X_AME_RULE_IDS FND_TABLE_OF_VARCHAR2_255: The AME rule ids.
540: -- : X_AME_RULE_DESCRIPTIONS FND_TABLE_OF_VARCHAR2_255: The AME rule descriptions.
541: -- : X_VARIABLE_NAMES FND_TABLE_OF_VARCHAR2_255: The rule variable names.
542: -- : X_VARIABLE_VALUES FND_TABLE_OF_VARCHAR2_255: The rule variable values.
543: --
544:
545: PROCEDURE GET_RULES_AND_VARIABLES

Line 542: -- : X_VARIABLE_VALUES FND_TABLE_OF_VARCHAR2_255: The rule variable values.

538: -- OUT
539: -- : X_AME_RULE_IDS FND_TABLE_OF_VARCHAR2_255: The AME rule ids.
540: -- : X_AME_RULE_DESCRIPTIONS FND_TABLE_OF_VARCHAR2_255: The AME rule descriptions.
541: -- : X_VARIABLE_NAMES FND_TABLE_OF_VARCHAR2_255: The rule variable names.
542: -- : X_VARIABLE_VALUES FND_TABLE_OF_VARCHAR2_255: The rule variable values.
543: --
544:
545: PROCEDURE GET_RULES_AND_VARIABLES
546: (

Line 549: X_AME_RULE_IDS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

545: PROCEDURE GET_RULES_AND_VARIABLES
546: (
547: P_EVENT_NAME IN VARCHAR2,
548: P_EVENT_KEY IN VARCHAR2 DEFAULT NULL,
549: X_AME_RULE_IDS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
550: X_AME_RULE_DESCRIPTIONS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
551: X_VARIABLE_NAMES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
552: X_VARIABLE_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
553: );

Line 550: X_AME_RULE_DESCRIPTIONS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

546: (
547: P_EVENT_NAME IN VARCHAR2,
548: P_EVENT_KEY IN VARCHAR2 DEFAULT NULL,
549: X_AME_RULE_IDS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
550: X_AME_RULE_DESCRIPTIONS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
551: X_VARIABLE_NAMES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
552: X_VARIABLE_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
553: );
554:

Line 551: X_VARIABLE_NAMES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

547: P_EVENT_NAME IN VARCHAR2,
548: P_EVENT_KEY IN VARCHAR2 DEFAULT NULL,
549: X_AME_RULE_IDS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
550: X_AME_RULE_DESCRIPTIONS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
551: X_VARIABLE_NAMES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
552: X_VARIABLE_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
553: );
554:
555: --Bug 3621309 : End

Line 552: X_VARIABLE_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255

548: P_EVENT_KEY IN VARCHAR2 DEFAULT NULL,
549: X_AME_RULE_IDS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
550: X_AME_RULE_DESCRIPTIONS OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
551: X_VARIABLE_NAMES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
552: X_VARIABLE_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
553: );
554:
555: --Bug 3621309 : End
556: