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.AST_UWQ_SEL_PKG dependencies on CCT_INTERACTIONKEYS_PUB

Line 157: elsif (p_mediaTable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID) THEN

153:
154: l_customerNumber := p_mediaTable(i).param_value;
155:
156: --elsif ( upper(p_mediaTable(i).param_name) = 'CUSTOMERID' ) THEN
157: elsif (p_mediaTable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID) THEN
158:
159: l_customerID := to_number(p_mediaTable(i).param_value);
160:
161: --elsif ( upper(p_mediaTable(i).param_name) = 'CUSTOMERNUM' ) then

Line 162: elsif (p_mediaTable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER) then

158:
159: l_customerID := to_number(p_mediaTable(i).param_value);
160:
161: --elsif ( upper(p_mediaTable(i).param_name) = 'CUSTOMERNUM' ) then
162: elsif (p_mediaTable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER) then
163:
164: l_customerNumber := p_mediaTable(i).param_value;
165:
166: elsif ( upper(p_mediaTable(i).param_name) = 'CONTACTNUM' ) then

Line 183: elsif (p_mediaTable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_DNIS) then

179:
180: l_campaignCode := p_mediaTable(i).param_value;
181:
182: --elsif ( upper(p_mediaTable(i).param_name) = 'OCCTDNIS' ) then
183: elsif (p_mediaTable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_DNIS) then
184:
185: l_dnis := p_mediaTable(i).param_value;
186:
187: elsif ( upper(p_mediaTable(i).param_name) = 'OCCTCALLID' ) then

Line 192: elsif (p_mediaTable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ANI) then

188:
189: l_callId := p_mediaTable(i).param_value;
190:
191: --elsif ( upper(p_mediaTable(i).param_name) = 'OCCTANI' ) then
192: elsif (p_mediaTable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ANI) then
193:
194: l_ani := p_mediaTable(i).param_value;
195:
196: elsif ( upper(p_mediaTable(i).param_name) = 'ACCOUNTCODE' ) then

Line 239: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER) THEN

235: l_usage := 'QUERY_TRANSFER';
236: elsif (upper(p_mediaTable(i).param_name) = 'XFR_SOURCE_CODE_ID') THEN
237: l_xfr_sourcecodeID := p_mediaTable(i).param_value;
238:
239: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER) THEN
240: l_quoteNum := to_number(p_mediaTable(i).param_value);
241: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER) THEN
242: l_orderNum := to_number(p_mediaTable(i).param_value);
243: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER) THEN

Line 241: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER) THEN

237: l_xfr_sourcecodeID := p_mediaTable(i).param_value;
238:
239: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER) THEN
240: l_quoteNum := to_number(p_mediaTable(i).param_value);
241: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER) THEN
242: l_orderNum := to_number(p_mediaTable(i).param_value);
243: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER) THEN
244: l_collateralReqNum := p_mediaTable(i).param_value;
245: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER) THEN

Line 243: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER) THEN

239: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER) THEN
240: l_quoteNum := to_number(p_mediaTable(i).param_value);
241: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER) THEN
242: l_orderNum := to_number(p_mediaTable(i).param_value);
243: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER) THEN
244: l_collateralReqNum := p_mediaTable(i).param_value;
245: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER) THEN
246: l_accountCode := p_mediaTable(i).param_value;
247: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE) THEN

Line 245: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER) THEN

241: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER) THEN
242: l_orderNum := to_number(p_mediaTable(i).param_value);
243: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER) THEN
244: l_collateralReqNum := p_mediaTable(i).param_value;
245: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER) THEN
246: l_accountCode := p_mediaTable(i).param_value;
247: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE) THEN
248: l_eventConfCode := p_mediaTable(i).param_value;
249: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN) THEN

Line 247: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE) THEN

243: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER) THEN
244: l_collateralReqNum := p_mediaTable(i).param_value;
245: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER) THEN
246: l_accountCode := p_mediaTable(i).param_value;
247: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE) THEN
248: l_eventConfCode := p_mediaTable(i).param_value;
249: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN) THEN
250: l_marketingPin := p_mediaTable(i).param_value;
251: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER) THEN

Line 249: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN) THEN

245: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER) THEN
246: l_accountCode := p_mediaTable(i).param_value;
247: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE) THEN
248: l_eventConfCode := p_mediaTable(i).param_value;
249: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN) THEN
250: l_marketingPin := p_mediaTable(i).param_value;
251: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER) THEN
252: l_ContractNum := p_mediaTable(i).param_value;
253: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER) THEN

Line 251: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER) THEN

247: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE) THEN
248: l_eventConfCode := p_mediaTable(i).param_value;
249: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN) THEN
250: l_marketingPin := p_mediaTable(i).param_value;
251: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER) THEN
252: l_ContractNum := p_mediaTable(i).param_value;
253: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER) THEN
254: l_ContractNumMod := p_mediaTable(i).param_value;
255: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY) THEN

Line 253: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER) THEN

249: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN) THEN
250: l_marketingPin := p_mediaTable(i).param_value;
251: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER) THEN
252: l_ContractNum := p_mediaTable(i).param_value;
253: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER) THEN
254: l_ContractNumMod := p_mediaTable(i).param_value;
255: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY) THEN
256: l_ServiceKey := p_mediaTable(i).param_value;
257: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER) THEN

Line 255: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY) THEN

251: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER) THEN
252: l_ContractNum := p_mediaTable(i).param_value;
253: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER) THEN
254: l_ContractNumMod := p_mediaTable(i).param_value;
255: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY) THEN
256: l_ServiceKey := p_mediaTable(i).param_value;
257: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER) THEN
258: l_SRNum := p_mediaTable(i).param_value;
259:

Line 257: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER) THEN

253: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER) THEN
254: l_ContractNumMod := p_mediaTable(i).param_value;
255: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY) THEN
256: l_ServiceKey := p_mediaTable(i).param_value;
257: ELSIF (p_mediatable(i).param_name = CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER) THEN
258: l_SRNum := p_mediaTable(i).param_value;
259:
260: -- added to check if the agent is already on a call (prereq: UWQ bug 2495619)
261: elsif (p_mediaTable(i).param_name = 'UWQ_BLOCK_MODE') THEN