659: p_action_name OUT NOCOPY varchar2,
660: p_action_param OUT NOCOPY varchar2)
661: is
662: BEGIN
663: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :Begin ++');
664: l_task_id := '';
665: l_source_code := '';
666: l_source_code_id := '';
667: l_source_campaign_id := 0;
666: l_source_code_id := '';
667: l_source_campaign_id := 0;
668: l_nm_party_id := 0;
669:
670: iex_debug_pub.LogMessage('Calling getFooData ++');
671: getFooData(p_mediaTable);
672: iex_debug_pub.LogMessage('Returned from getFooData --');
673: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_nm_PARTY_ID' || l_nm_PARTY_ID);
674: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_Task_ID' || l_Task_ID);
668: l_nm_party_id := 0;
669:
670: iex_debug_pub.LogMessage('Calling getFooData ++');
671: getFooData(p_mediaTable);
672: iex_debug_pub.LogMessage('Returned from getFooData --');
673: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_nm_PARTY_ID' || l_nm_PARTY_ID);
674: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_Task_ID' || l_Task_ID);
675: /*
676: If l_nm_party_id <> 0 then
669:
670: iex_debug_pub.LogMessage('Calling getFooData ++');
671: getFooData(p_mediaTable);
672: iex_debug_pub.LogMessage('Returned from getFooData --');
673: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_nm_PARTY_ID' || l_nm_PARTY_ID);
674: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_Task_ID' || l_Task_ID);
675: /*
676: If l_nm_party_id <> 0 then
677: p_action_name := 'IEXRCALL';
670: iex_debug_pub.LogMessage('Calling getFooData ++');
671: getFooData(p_mediaTable);
672: iex_debug_pub.LogMessage('Returned from getFooData --');
673: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_nm_PARTY_ID' || l_nm_PARTY_ID);
674: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :l_Task_ID' || l_Task_ID);
675: /*
676: If l_nm_party_id <> 0 then
677: p_action_name := 'IEXRCALL';
678:
712: INTO l_nm_PARTY_ID
713: from jtf_tasks_b
714: WHERE task_id=l_Task_ID;
715: END if;
716: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :final l_nm_PARTY_ID' || l_nm_PARTY_ID);
717: If l_nm_PARTY_ID IS NULL OR l_nm_PARTY_ID=0 then
718: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :Party_id is NULL, So opening the Task manager screen instead of IEXRCALL');
719: p_action_name := 'JTFTKMAN' ;
720: p_action_param := 'TASK_ID=' || l_Task_ID;
714: WHERE task_id=l_Task_ID;
715: END if;
716: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :final l_nm_PARTY_ID' || l_nm_PARTY_ID);
717: If l_nm_PARTY_ID IS NULL OR l_nm_PARTY_ID=0 then
718: iex_debug_pub.LogMessage('IEX_UWQ_SEL_PKG.handleFooTask :Party_id is NULL, So opening the Task manager screen instead of IEXRCALL');
719: p_action_name := 'JTFTKMAN' ;
720: p_action_param := 'TASK_ID=' || l_Task_ID;
721: p_action_type := 2;
722: ELSE