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_STANDARD_PUB dependencies on STANDARD

Line 1: PACKAGE edr_Standard_pub AS

1: PACKAGE edr_Standard_pub AS
2: /* $Header: EDRPSTDS.pls 120.0.12000000.1 2007/01/18 05:54:52 appldev ship $ */
3: /*#
4: * This package contains all general Oracle E-Records utilities.
5: * @rep:scope public

Line 15: TYPE EventDetail_tbl_type IS TABLE of edr_standard.eventDetails INDEX by binary_integer;

11: */
12:
13: -- Public Record Type Decleration
14:
15: TYPE EventDetail_tbl_type IS TABLE of edr_standard.eventDetails INDEX by binary_integer;
16:
17: TYPE InputVar_Values_tbl_type IS TABLE of edr_standard.RuleInputValues index by binary_integer;
18:
19: -- Global Variables

Line 17: TYPE InputVar_Values_tbl_type IS TABLE of edr_standard.RuleInputValues index by binary_integer;

13: -- Public Record Type Decleration
14:
15: TYPE EventDetail_tbl_type IS TABLE of edr_standard.eventDetails INDEX by binary_integer;
16:
17: TYPE InputVar_Values_tbl_type IS TABLE of edr_standard.RuleInputValues index by binary_integer;
18:
19: -- Global Variables
20:
21: G_SIGNATURE_STATUS varchar2(80) := NULL; -- hold the status of workflow ('APPROVED','REJECTED')

Line 100: -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Status

96: -- Parameters
97: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
98: -- p_event_key VARCHAR2 event key, eg ItemNo3125
99: -- OUT : x_psig_status VARCHAR2 event psig status
100: -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Status
101: -- ---------------------------------------
102: /*#
103: * This API obtains current e-signature status for an event.
104: * @rep:scope public

Line 129: -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_REQUIRED

125: -- Parameters
126: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
127: -- p_event_key VARCHAR2 event key, eg ItemNo3125
128: -- OUT : x_psig_required VARCHAR2 event psig status
129: -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_REQUIRED
130: -- ---------------------------------------
131: /*#
132: * This API checks if a signature is required for an event.
133: * @rep:scope public

Line 158: -- Versions : 1.0 17-Jul-03 created from edr_standard.EREC_REQUIRED

154: -- Parameters
155: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
156: -- p_event_key VARCHAR2 event key, eg ItemNo3125
157: -- OUT : x_erec_required VARCHAR2 event psig status
158: -- Versions : 1.0 17-Jul-03 created from edr_standard.EREC_REQUIRED
159: -- ---------------------------------------
160: /*#
161: * This API checks if an e-record is required for an event.
162: * @rep:scope public

Line 187: -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_QUERY

183: -- Parameters
184: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
185: -- p_event_key VARCHAR2 event key, eg ItemNo3125
186: -- OUT : x_psig_status VARCHAR2 event psig status
187: -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_QUERY
188: -- ---------------------------------------
189: /*#
190: * This API obtains a query ID for a list of events passed to the API as p_eventQuery_recTbl.
191: * This API is used in the context of querying the e-record repository.

Line 221: -- Versions : 1.0 17-Jul-03 created from edr_standard.DISPLAY_DATE

217: -- OUT : x_return_status VARCHAR2
218: -- x_msg_count NUMBER
219: -- x_msg_data VARCHAR2
220: -- x_date_out VARCHAR2 converted date
221: -- Versions : 1.0 17-Jul-03 created from edr_standard.DISPLAY_DATE
222: -- ---------------------------------------
223:
224: PROCEDURE DISPLAY_DATE (
225: p_api_version IN NUMBER,

Line 246: -- Versions : 1.0 7-Nov-03 created from edr_standard.DISPLAY_DATE_ONLY

242: -- OUT : x_return_status VARCHAR2
243: -- x_msg_count NUMBER
244: -- x_msg_data VARCHAR2
245: -- x_date_out VARCHAR2 converted date
246: -- Versions : 1.0 7-Nov-03 created from edr_standard.DISPLAY_DATE_ONLY
247: -- ---------------------------------------
248:
249: PROCEDURE DISPLAY_DATE_ONLY (
250: p_api_version IN NUMBER,

Line 270: -- Versions : 1.0 12-Nov-03 created from edr_standard.DISPLAY_TIME_ONLY

266: -- OUT : x_return_status VARCHAR2
267: -- x_msg_count NUMBER
268: -- x_msg_data VARCHAR2
269: -- x_date_out VARCHAR2 converted time
270: -- Versions : 1.0 12-Nov-03 created from edr_standard.DISPLAY_TIME_ONLY
271: -- ---------------------------------------
272:
273: PROCEDURE DISPLAY_TIME_ONLY (
274: p_api_version IN NUMBER,

Line 295: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_AMERULE_INPUT_VALUES

291: -- IN : p_transaction_name VARCHAR2 transaction name, eg GMI ERES Item Creation
292: -- p_ameRule_id NUMBER AME rule id, eg 11400
293: -- p_ameRule_name VARCHAR2 AME rule name, eg Item Creation Rule
294: -- OUT : x_inputVar_values_tbl inputvar_values_tbl_type table of inputVar values
295: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_AMERULE_INPUT_VALUES
296: -- ---------------------------------------
297:
298:
299: /*#

Line 331: -- Versions : 1.0 19-Feb-05 created from edr_standard.GET_AMERULE_INPUT_VALUES

327: -- IN : p_transaction_id VARCHAR2 transaction id, eg oracle.apps.gme.batch.create
328: -- p_ameRule_id NUMBER AME rule id, eg 11400
329: -- p_ameRule_name VARCHAR2 AME rule name, eg Item Creation Rule
330: -- OUT : x_inputVar_values_tbl inputvar_values_tbl_type table of inputVar values
331: -- Versions : 1.0 19-Feb-05 created from edr_standard.GET_AMERULE_INPUT_VALUES
332: -- ---------------------------------------
333:
334: /*#
335: * This API returns the table of configuration variables for an AME Transaction and Rule.

Line 365: -- Versions : 1.0 17-Jul-03 created from edr_standard.COMPARE_AUDITVALUES

361: -- p_column_name VARCHAR2 column to be checked, eg ItemNo3125
362: -- p_primKey_name VARCHAR2 name of primary key, eg ItemNo3125
363: -- p_primKey_value VARCHAR2 value of primary key, eg ItemNo3125
364: -- OUT : x_auditValue_old VARCHAR2 indicate if the audited value is updated
365: -- Versions : 1.0 17-Jul-03 created from edr_standard.COMPARE_AUDITVALUES
366: -- ---------------------------------------
367:
368: Procedure Is_AuditValue_Old (
369: p_api_version IN NUMBER,

Line 392: -- Versions : 1.0 17-Jul-03 created from edr_standard.FIND_WF_NTF_RECIPIENT

388: -- p_message_type VARCHAR2 message type
389: -- p_message_name VARCHAR2 message name
390: -- OUT : x_final_recipient VARCHAR2 final recipient
391: -- x_allrout_comments VARCHAR2 all routing comments
392: -- Versions : 1.0 17-Jul-03 created from edr_standard.FIND_WF_NTF_RECIPIENT
393: -- ---------------------------------------
394:
395: PROCEDURE Get_Notif_Routing_Info (
396: p_api_version IN NUMBER,

Line 422: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_SINGLE_PROMPT

418: -- p_column_name VARCHAR2 name of the column corresponding to a flex segment
419: -- p_prompt_type VARCHAR2 indicate the field from which to return values
420: -- 'LEFT' --> FORM_LEFT_PROMPT; 'ABOVE' --> FORM_ABOVE_PROMPT
421: -- OUT : x_column_prompt VARCHAR2 the prompt values for the columns
422: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_SINGLE_PROMPT
423: -- ---------------------------------------
424:
425: PROCEDURE Get_DescFlex_OnePrompt (
426: p_api_version IN NUMBER,

Line 455: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_ALL_PROMPTS

451: -- p_prompt_type VARCHAR2 indicate the field from which to return values
452: -- 'LEFT': FORM_LEFT_PROMPT; 'ABOVE': FORM_ABOVE_PROMPT
453: -- OUT : x_colnPrompts_rec Flex_ColnPrompt_Rec_Type
454: -- the prompt values for the columns
455: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_ALL_PROMPTS
456: -- ---------------------------------------
457:
458:
459: PROCEDURE Get_DescFlex_AllPrompts (

Line 468: p_colnNames_rec IN edr_standard_pub.Flex_ColnName_Rec_Type,

464: x_msg_data OUT NOCOPY VARCHAR2,
465: p_application_id IN NUMBER,
466: p_descFlex_defName IN VARCHAR2,
467: p_descFlex_context IN VARCHAR2,
468: p_colnNames_rec IN edr_standard_pub.Flex_ColnName_Rec_Type,
469: p_prompt_type IN VARCHAR2 DEFAULT NULL,
470: x_colnPrompts_rec OUT NOCOPY edr_standard_pub.Flex_ColnPrompt_Rec_Type );
471:
472:

Line 470: x_colnPrompts_rec OUT NOCOPY edr_standard_pub.Flex_ColnPrompt_Rec_Type );

466: p_descFlex_defName IN VARCHAR2,
467: p_descFlex_context IN VARCHAR2,
468: p_colnNames_rec IN edr_standard_pub.Flex_ColnName_Rec_Type,
469: p_prompt_type IN VARCHAR2 DEFAULT NULL,
470: x_colnPrompts_rec OUT NOCOPY edr_standard_pub.Flex_ColnPrompt_Rec_Type );
471:
472:
473:
474: -- --------------------------------------

Line 483: -- Versions : 1.0 17-Jul-03 created from edr_standard.Get_Meaning

479: -- Parameters
480: -- IN : p_lookup_type VARCHAR2 event name, eg oracle.apps.gmi.item.create
481: -- p_lookup_code VARCHAR2 event key, eg ItemNo3125
482: -- OUT : x_psig_status VARCHAR2 event psig status
483: -- Versions : 1.0 17-Jul-03 created from edr_standard.Get_Meaning
484: -- ---------------------------------------
485:
486: PROCEDURE Get_Lookup_Meaning (
487: p_api_version IN NUMBER,

Line 506: -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Status

502: -- Parameters
503: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
504: -- p_event_key VARCHAR2 event key, eg ItemNo3125
505: -- OUT : x_query_id NUMBER one query id for all events details
506: -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Status
507: -- ---------------------------------------
508:
509: PROCEDURE Get_QueryId_OnParams (
510: p_api_version IN NUMBER,

Line 613: END EDR_STANDARD_PUB;

609: -- Bug 3848049 : End
610:
611:
612:
613: END EDR_STANDARD_PUB;