APPS.OKL_UWQ_SEL_PKG dependencies on IEU_UWQ_MEDIA_DATA_NST

Line 72: PROCEDURE getCallData(p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST) IS

68: l_messageID := '';
69: l_MoreAniMatch := 'N';
70: END setDefaults;
71: -- private package to return the param type value
72: PROCEDURE getCallData(p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST) IS
73: BEGIN
74: FOR i IN 1 .. p_mediaTable.COUNT LOOP
75: IF ( UPPER(p_mediaTable(i).param_name) = 'OCCTEVENTNAME' ) THEN
76: l_eventname := p_mediaTable(i).param_value;

Line 441: PROCEDURE handleOTSInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,

437: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'GetDtlsFromPhoneNum Exception Occurred');
438: END IF;
439: RETURN;
440: END GetDtlsFromPhoneNum;
441: PROCEDURE handleOTSInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
442: p_action_type OUT NOCOPY NUMBER,
443: p_action_name OUT NOCOPY VARCHAR2,
444: p_action_param OUT NOCOPY VARCHAR2) IS
445: foo_action_param VARCHAR2(3000);

Line 516: PROCEDURE handleEmail (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,

512: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
513: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Existing OTS Inbound Foo Function');
514: END IF;
515: END handleOTSInbound;
516: PROCEDURE handleEmail (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
517: p_action_type OUT NOCOPY NUMBER,
518: p_action_name OUT NOCOPY VARCHAR2,
519: p_action_param OUT NOCOPY VARCHAR2) IS
520: BEGIN

Line 523: PROCEDURE handleOTSOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,

519: p_action_param OUT NOCOPY VARCHAR2) IS
520: BEGIN
521: handleOTSInbound(p_mediaTable, p_action_type, p_action_name, p_action_param);
522: END;
523: PROCEDURE handleOTSOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
524: p_action_type OUT NOCOPY NUMBER,
525: p_action_name OUT NOCOPY VARCHAR2,
526: p_action_param OUT NOCOPY VARCHAR2) IS
527: BEGIN

Line 544: PROCEDURE handleOCInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,

540: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
541: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Exiting OTS Outbound Foo function');
542: END IF;
543: END handleOTSOutbound ;
544: PROCEDURE handleOCInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
545: p_action_type OUT NOCOPY NUMBER,
546: p_action_name OUT NOCOPY VARCHAR2,
547: p_action_param OUT NOCOPY VARCHAR2) IS
548: BEGIN

Line 553: PROCEDURE handleOCOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,

549: handleOTSInbound(p_mediaTable, p_action_type, p_action_name, p_action_param);
550: p_action_name := 'IEXRCALL';
551: p_action_type := 1;
552: END;
553: PROCEDURE handleOCOutbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
554: p_action_type OUT NOCOPY NUMBER,
555: p_action_name OUT NOCOPY VARCHAR2,
556: p_action_param OUT NOCOPY VARCHAR2) IS
557: BEGIN