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.CSC_ROUTING_UTL dependencies on CCT_COLLECTION_UTIL_PUB

Line 1241: l_done_it := cct_collection_util_pub.get(p_media_data, 'DONE_IT',x_exist_flag);

1237:
1238: l_done_it varchar2(10);
1239: BEGIN
1240: /*--New Flag to prevent this new lookup to be called again
1241: l_done_it := cct_collection_util_pub.get(p_media_data, 'DONE_IT',x_exist_flag);
1242:
1243: IF nvl(l_done_it,'NO') = 'DONE' AND x_exist_flag = 'Y' THEN
1244: --Went thru the parsing already, no need to go again.
1245: RETURN;

Line 1249: l_xfer_action_id := cct_collection_util_pub.get(p_media_data, 'ActionID',x_exist_flag);

1245: RETURN;
1246: END IF;
1247: */
1248:
1249: l_xfer_action_id := cct_collection_util_pub.get(p_media_data, 'ActionID',x_exist_flag);
1250: IF l_xfer_action_id is not null AND x_exist_flag = 'Y' THEN
1251: l_trans_conf_flag := 'Y';
1252: END IF;
1253: l_xfer_interaction_id := cct_collection_util_pub.get(p_media_data, 'INTERACTION_ID',x_exist_flag);

Line 1253: l_xfer_interaction_id := cct_collection_util_pub.get(p_media_data, 'INTERACTION_ID',x_exist_flag);

1249: l_xfer_action_id := cct_collection_util_pub.get(p_media_data, 'ActionID',x_exist_flag);
1250: IF l_xfer_action_id is not null AND x_exist_flag = 'Y' THEN
1251: l_trans_conf_flag := 'Y';
1252: END IF;
1253: l_xfer_interaction_id := cct_collection_util_pub.get(p_media_data, 'INTERACTION_ID',x_exist_flag);
1254: l_xfer_service_key_name := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_NAME',x_exist_flag);
1255: l_xfer_service_key_value := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_VALUE',x_exist_flag);
1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);
1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);

Line 1254: l_xfer_service_key_name := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_NAME',x_exist_flag);

1250: IF l_xfer_action_id is not null AND x_exist_flag = 'Y' THEN
1251: l_trans_conf_flag := 'Y';
1252: END IF;
1253: l_xfer_interaction_id := cct_collection_util_pub.get(p_media_data, 'INTERACTION_ID',x_exist_flag);
1254: l_xfer_service_key_name := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_NAME',x_exist_flag);
1255: l_xfer_service_key_value := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_VALUE',x_exist_flag);
1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);
1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);
1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);

Line 1255: l_xfer_service_key_value := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_VALUE',x_exist_flag);

1251: l_trans_conf_flag := 'Y';
1252: END IF;
1253: l_xfer_interaction_id := cct_collection_util_pub.get(p_media_data, 'INTERACTION_ID',x_exist_flag);
1254: l_xfer_service_key_name := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_NAME',x_exist_flag);
1255: l_xfer_service_key_value := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_VALUE',x_exist_flag);
1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);
1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);
1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);
1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);

Line 1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);

1252: END IF;
1253: l_xfer_interaction_id := cct_collection_util_pub.get(p_media_data, 'INTERACTION_ID',x_exist_flag);
1254: l_xfer_service_key_name := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_NAME',x_exist_flag);
1255: l_xfer_service_key_value := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_VALUE',x_exist_flag);
1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);
1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);
1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);
1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);
1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);

Line 1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);

1253: l_xfer_interaction_id := cct_collection_util_pub.get(p_media_data, 'INTERACTION_ID',x_exist_flag);
1254: l_xfer_service_key_name := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_NAME',x_exist_flag);
1255: l_xfer_service_key_value := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_VALUE',x_exist_flag);
1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);
1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);
1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);
1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);
1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);
1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);

Line 1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);

1254: l_xfer_service_key_name := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_NAME',x_exist_flag);
1255: l_xfer_service_key_value := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_VALUE',x_exist_flag);
1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);
1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);
1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);
1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);
1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);
1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);
1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);

Line 1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);

1255: l_xfer_service_key_value := cct_collection_util_pub.get(p_media_data, 'SERVICE_KEY_VALUE',x_exist_flag);
1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);
1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);
1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);
1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);
1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);
1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);
1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);
1263: l_xfer_rel_email_id := cct_collection_util_pub.get(p_media_data, 'REL_EMAIL_ID',x_exist_flag);

Line 1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);

1256: l_xfer_call_reason := cct_collection_util_pub.get(p_media_data, 'CALL_REASON',x_exist_flag);
1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);
1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);
1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);
1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);
1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);
1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);
1263: l_xfer_rel_email_id := cct_collection_util_pub.get(p_media_data, 'REL_EMAIL_ID',x_exist_flag);
1264: l_xfer_cust_account_id := cct_collection_util_pub.get(p_media_data, 'CUST_ACCOUNT_ID',x_exist_flag);

Line 1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);

1257: l_xfer_cust_party_id := cct_collection_util_pub.get(p_media_data, 'CUST_PARTY_ID',x_exist_flag);
1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);
1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);
1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);
1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);
1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);
1263: l_xfer_rel_email_id := cct_collection_util_pub.get(p_media_data, 'REL_EMAIL_ID',x_exist_flag);
1264: l_xfer_cust_account_id := cct_collection_util_pub.get(p_media_data, 'CUST_ACCOUNT_ID',x_exist_flag);
1265: l_party_id := cct_collection_util_pub.get(p_media_data, 'PARTY_ID',x_exist_flag);

Line 1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);

1258: l_xfer_rel_party_id := cct_collection_util_pub.get(p_media_data, 'REL_PARTY_ID',x_exist_flag);
1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);
1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);
1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);
1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);
1263: l_xfer_rel_email_id := cct_collection_util_pub.get(p_media_data, 'REL_EMAIL_ID',x_exist_flag);
1264: l_xfer_cust_account_id := cct_collection_util_pub.get(p_media_data, 'CUST_ACCOUNT_ID',x_exist_flag);
1265: l_party_id := cct_collection_util_pub.get(p_media_data, 'PARTY_ID',x_exist_flag);
1266: IF l_party_id is not null AND x_exist_flag = 'Y' THEN

Line 1263: l_xfer_rel_email_id := cct_collection_util_pub.get(p_media_data, 'REL_EMAIL_ID',x_exist_flag);

1259: l_xfer_per_party_id := cct_collection_util_pub.get(p_media_data, 'PER_PARTY_ID',x_exist_flag);
1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);
1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);
1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);
1263: l_xfer_rel_email_id := cct_collection_util_pub.get(p_media_data, 'REL_EMAIL_ID',x_exist_flag);
1264: l_xfer_cust_account_id := cct_collection_util_pub.get(p_media_data, 'CUST_ACCOUNT_ID',x_exist_flag);
1265: l_party_id := cct_collection_util_pub.get(p_media_data, 'PARTY_ID',x_exist_flag);
1266: IF l_party_id is not null AND x_exist_flag = 'Y' THEN
1267: l_customer_id := l_party_id;

Line 1264: l_xfer_cust_account_id := cct_collection_util_pub.get(p_media_data, 'CUST_ACCOUNT_ID',x_exist_flag);

1260: l_xfer_cust_phone_id := cct_collection_util_pub.get(p_media_data, 'CUST_PHONE_ID',x_exist_flag);
1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);
1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);
1263: l_xfer_rel_email_id := cct_collection_util_pub.get(p_media_data, 'REL_EMAIL_ID',x_exist_flag);
1264: l_xfer_cust_account_id := cct_collection_util_pub.get(p_media_data, 'CUST_ACCOUNT_ID',x_exist_flag);
1265: l_party_id := cct_collection_util_pub.get(p_media_data, 'PARTY_ID',x_exist_flag);
1266: IF l_party_id is not null AND x_exist_flag = 'Y' THEN
1267: l_customer_id := l_party_id;
1268: END IF;

Line 1265: l_party_id := cct_collection_util_pub.get(p_media_data, 'PARTY_ID',x_exist_flag);

1261: l_xfer_cust_email_id := cct_collection_util_pub.get(p_media_data, 'CUST_EMAIL_ID',x_exist_flag);
1262: l_xfer_rel_phone_id := cct_collection_util_pub.get(p_media_data, 'REL_PHONE_ID',x_exist_flag);
1263: l_xfer_rel_email_id := cct_collection_util_pub.get(p_media_data, 'REL_EMAIL_ID',x_exist_flag);
1264: l_xfer_cust_account_id := cct_collection_util_pub.get(p_media_data, 'CUST_ACCOUNT_ID',x_exist_flag);
1265: l_party_id := cct_collection_util_pub.get(p_media_data, 'PARTY_ID',x_exist_flag);
1266: IF l_party_id is not null AND x_exist_flag = 'Y' THEN
1267: l_customer_id := l_party_id;
1268: END IF;
1269:

Line 1270: l_customer_num := cct_collection_util_pub.get(p_media_data, 'CustomerNum',x_exist_flag);

1266: IF l_party_id is not null AND x_exist_flag = 'Y' THEN
1267: l_customer_id := l_party_id;
1268: END IF;
1269:
1270: l_customer_num := cct_collection_util_pub.get(p_media_data, 'CustomerNum',x_exist_flag);
1271: l_contact_num := cct_collection_util_pub.get(p_media_data, 'ContactNum', x_exist_flag);
1272: l_account_code := cct_collection_util_pub.get(p_media_data, 'AccountCode', x_exist_flag);
1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);
1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);

Line 1271: l_contact_num := cct_collection_util_pub.get(p_media_data, 'ContactNum', x_exist_flag);

1267: l_customer_id := l_party_id;
1268: END IF;
1269:
1270: l_customer_num := cct_collection_util_pub.get(p_media_data, 'CustomerNum',x_exist_flag);
1271: l_contact_num := cct_collection_util_pub.get(p_media_data, 'ContactNum', x_exist_flag);
1272: l_account_code := cct_collection_util_pub.get(p_media_data, 'AccountCode', x_exist_flag);
1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);
1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);
1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);

Line 1272: l_account_code := cct_collection_util_pub.get(p_media_data, 'AccountCode', x_exist_flag);

1268: END IF;
1269:
1270: l_customer_num := cct_collection_util_pub.get(p_media_data, 'CustomerNum',x_exist_flag);
1271: l_contact_num := cct_collection_util_pub.get(p_media_data, 'ContactNum', x_exist_flag);
1272: l_account_code := cct_collection_util_pub.get(p_media_data, 'AccountCode', x_exist_flag);
1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);
1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);
1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);
1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);

Line 1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);

1269:
1270: l_customer_num := cct_collection_util_pub.get(p_media_data, 'CustomerNum',x_exist_flag);
1271: l_contact_num := cct_collection_util_pub.get(p_media_data, 'ContactNum', x_exist_flag);
1272: l_account_code := cct_collection_util_pub.get(p_media_data, 'AccountCode', x_exist_flag);
1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);
1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);
1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);
1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);
1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);

Line 1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);

1270: l_customer_num := cct_collection_util_pub.get(p_media_data, 'CustomerNum',x_exist_flag);
1271: l_contact_num := cct_collection_util_pub.get(p_media_data, 'ContactNum', x_exist_flag);
1272: l_account_code := cct_collection_util_pub.get(p_media_data, 'AccountCode', x_exist_flag);
1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);
1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);
1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);
1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);
1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);
1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);

Line 1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);

1271: l_contact_num := cct_collection_util_pub.get(p_media_data, 'ContactNum', x_exist_flag);
1272: l_account_code := cct_collection_util_pub.get(p_media_data, 'AccountCode', x_exist_flag);
1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);
1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);
1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);
1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);
1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);
1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);
1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);

Line 1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);

1272: l_account_code := cct_collection_util_pub.get(p_media_data, 'AccountCode', x_exist_flag);
1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);
1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);
1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);
1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);
1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);
1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);
1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);
1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);

Line 1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);

1273: l_contract_num := cct_collection_util_pub.get(p_media_data, 'ContractNum', x_exist_flag);
1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);
1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);
1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);
1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);
1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);
1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);
1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);
1281: l_instance_num := cct_collection_util_pub.get(p_media_data, 'InstanceNum', x_exist_flag);

Line 1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);

1274: l_invoice_num := cct_collection_util_pub.get(p_media_data, 'InvoiceNum', x_exist_flag);
1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);
1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);
1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);
1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);
1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);
1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);
1281: l_instance_num := cct_collection_util_pub.get(p_media_data, 'InstanceNum', x_exist_flag);
1282: l_tag_num := cct_collection_util_pub.get(p_media_data, 'TagNumber', x_exist_flag);

Line 1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);

1275: l_order_num := cct_collection_util_pub.get(p_media_data, 'OrderNum', x_exist_flag);
1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);
1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);
1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);
1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);
1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);
1281: l_instance_num := cct_collection_util_pub.get(p_media_data, 'InstanceNum', x_exist_flag);
1282: l_tag_num := cct_collection_util_pub.get(p_media_data, 'TagNumber', x_exist_flag);
1283: l_system_name := cct_collection_util_pub.get(p_media_data, 'SystemName', x_exist_flag);

Line 1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);

1276: l_ssn := cct_collection_util_pub.get(p_media_data, 'SocialSecurityNumber', x_exist_flag);
1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);
1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);
1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);
1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);
1281: l_instance_num := cct_collection_util_pub.get(p_media_data, 'InstanceNum', x_exist_flag);
1282: l_tag_num := cct_collection_util_pub.get(p_media_data, 'TagNumber', x_exist_flag);
1283: l_system_name := cct_collection_util_pub.get(p_media_data, 'SystemName', x_exist_flag);
1284:

Line 1281: l_instance_num := cct_collection_util_pub.get(p_media_data, 'InstanceNum', x_exist_flag);

1277: l_rma_num := cct_collection_util_pub.get(p_media_data, 'RMANum', x_exist_flag);
1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);
1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);
1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);
1281: l_instance_num := cct_collection_util_pub.get(p_media_data, 'InstanceNum', x_exist_flag);
1282: l_tag_num := cct_collection_util_pub.get(p_media_data, 'TagNumber', x_exist_flag);
1283: l_system_name := cct_collection_util_pub.get(p_media_data, 'SystemName', x_exist_flag);
1284:
1285:

Line 1282: l_tag_num := cct_collection_util_pub.get(p_media_data, 'TagNumber', x_exist_flag);

1278: l_serial_num := cct_collection_util_pub.get(p_media_data, 'SerialNum', x_exist_flag);
1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);
1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);
1281: l_instance_num := cct_collection_util_pub.get(p_media_data, 'InstanceNum', x_exist_flag);
1282: l_tag_num := cct_collection_util_pub.get(p_media_data, 'TagNumber', x_exist_flag);
1283: l_system_name := cct_collection_util_pub.get(p_media_data, 'SystemName', x_exist_flag);
1284:
1285:
1286: --Set service key name and value based on the hierarchy specified in SRD

Line 1283: l_system_name := cct_collection_util_pub.get(p_media_data, 'SystemName', x_exist_flag);

1279: l_sr_num := cct_collection_util_pub.get(p_media_data, 'ServiceRequestNum', x_exist_flag);
1280: l_instance_name := cct_collection_util_pub.get(p_media_data, 'InstanceName', x_exist_flag);
1281: l_instance_num := cct_collection_util_pub.get(p_media_data, 'InstanceNum', x_exist_flag);
1282: l_tag_num := cct_collection_util_pub.get(p_media_data, 'TagNumber', x_exist_flag);
1283: l_system_name := cct_collection_util_pub.get(p_media_data, 'SystemName', x_exist_flag);
1284:
1285:
1286: --Set service key name and value based on the hierarchy specified in SRD
1287: if l_customer_id is not null then

Line 1289: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);

1285:
1286: --Set service key name and value based on the hierarchy specified in SRD
1287: if l_customer_id is not null then
1288: --p_action_param := p_action_param||'uwq_party_id="'||l_customer_id||'"';
1289: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1290: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1291: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
1292: --this fix is for user who uses default or custom lookup, even when l_customer_id is not null
1293: --it will still check for service key value pairs

Line 1290: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

1286: --Set service key name and value based on the hierarchy specified in SRD
1287: if l_customer_id is not null then
1288: --p_action_param := p_action_param||'uwq_party_id="'||l_customer_id||'"';
1289: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1290: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1291: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
1292: --this fix is for user who uses default or custom lookup, even when l_customer_id is not null
1293: --it will still check for service key value pairs
1294: if (l_sr_num is null) AND

Line 1291: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');

1287: if l_customer_id is not null then
1288: --p_action_param := p_action_param||'uwq_party_id="'||l_customer_id||'"';
1289: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1290: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1291: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
1292: --this fix is for user who uses default or custom lookup, even when l_customer_id is not null
1293: --it will still check for service key value pairs
1294: if (l_sr_num is null) AND
1295: (l_instance_name is null) AND

Line 1306: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1302: (l_ssn is null) AND
1303: (l_contract_num is null) AND
1304: (l_invoice_num is null) THEN
1305: l_match := 1;
1306: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1307: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1308: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1309:
1310: --Resolve party_name from party_id

Line 1307: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1303: (l_contract_num is null) AND
1304: (l_invoice_num is null) THEN
1305: l_match := 1;
1306: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1307: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1308: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1309:
1310: --Resolve party_name from party_id
1311: l_customer_name := get_party_name_from_party_id(l_customer_id);

Line 1308: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1304: (l_invoice_num is null) THEN
1305: l_match := 1;
1306: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1307: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1308: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1309:
1310: --Resolve party_name from party_id
1311: l_customer_name := get_party_name_from_party_id(l_customer_id);
1312: IF l_customer_name <> 'NOTFOUND' THEN

Line 1313: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1309:
1310: --Resolve party_name from party_id
1311: l_customer_name := get_party_name_from_party_id(l_customer_id);
1312: IF l_customer_name <> 'NOTFOUND' THEN
1313: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1314: END IF;
1315: RETURN;
1316: end if;
1317: end if;

Line 1319: l_country_code := cct_collection_util_pub.get(p_media_data, 'CountryCode', x_exist_flag);

1315: RETURN;
1316: end if;
1317: end if;
1318:
1319: l_country_code := cct_collection_util_pub.get(p_media_data, 'CountryCode', x_exist_flag);
1320: if x_exist_flag = 'Y' then
1321: l_phone_passed_flag := 'Y';
1322: end if;
1323: l_area_code := cct_collection_util_pub.get(p_media_data, 'AreaCode', x_exist_flag);

Line 1323: l_area_code := cct_collection_util_pub.get(p_media_data, 'AreaCode', x_exist_flag);

1319: l_country_code := cct_collection_util_pub.get(p_media_data, 'CountryCode', x_exist_flag);
1320: if x_exist_flag = 'Y' then
1321: l_phone_passed_flag := 'Y';
1322: end if;
1323: l_area_code := cct_collection_util_pub.get(p_media_data, 'AreaCode', x_exist_flag);
1324: if x_exist_flag = 'Y' then
1325: l_phone_passed_flag := 'Y';
1326: end if;
1327: l_phone_num := cct_collection_util_pub.get(p_media_data, 'PhoneNumber', x_exist_flag);

Line 1327: l_phone_num := cct_collection_util_pub.get(p_media_data, 'PhoneNumber', x_exist_flag);

1323: l_area_code := cct_collection_util_pub.get(p_media_data, 'AreaCode', x_exist_flag);
1324: if x_exist_flag = 'Y' then
1325: l_phone_passed_flag := 'Y';
1326: end if;
1327: l_phone_num := cct_collection_util_pub.get(p_media_data, 'PhoneNumber', x_exist_flag);
1328: if x_exist_flag = 'Y' then
1329: l_phone_passed_flag := 'Y';
1330: end if;
1331: l_screen_pop_action := cct_collection_util_pub.get(p_media_data, 'occtScreenPopAction', x_exist_flag);

Line 1331: l_screen_pop_action := cct_collection_util_pub.get(p_media_data, 'occtScreenPopAction', x_exist_flag);

1327: l_phone_num := cct_collection_util_pub.get(p_media_data, 'PhoneNumber', x_exist_flag);
1328: if x_exist_flag = 'Y' then
1329: l_phone_passed_flag := 'Y';
1330: end if;
1331: l_screen_pop_action := cct_collection_util_pub.get(p_media_data, 'occtScreenPopAction', x_exist_flag);
1332: l_ani := cct_collection_util_pub.get(p_media_data, 'occtANI', x_exist_flag);
1333: l_media_item_id := cct_collection_util_pub.get(p_media_data, 'occtMediaItemID', x_exist_flag);
1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);
1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);

Line 1332: l_ani := cct_collection_util_pub.get(p_media_data, 'occtANI', x_exist_flag);

1328: if x_exist_flag = 'Y' then
1329: l_phone_passed_flag := 'Y';
1330: end if;
1331: l_screen_pop_action := cct_collection_util_pub.get(p_media_data, 'occtScreenPopAction', x_exist_flag);
1332: l_ani := cct_collection_util_pub.get(p_media_data, 'occtANI', x_exist_flag);
1333: l_media_item_id := cct_collection_util_pub.get(p_media_data, 'occtMediaItemID', x_exist_flag);
1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);
1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);
1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);

Line 1333: l_media_item_id := cct_collection_util_pub.get(p_media_data, 'occtMediaItemID', x_exist_flag);

1329: l_phone_passed_flag := 'Y';
1330: end if;
1331: l_screen_pop_action := cct_collection_util_pub.get(p_media_data, 'occtScreenPopAction', x_exist_flag);
1332: l_ani := cct_collection_util_pub.get(p_media_data, 'occtANI', x_exist_flag);
1333: l_media_item_id := cct_collection_util_pub.get(p_media_data, 'occtMediaItemID', x_exist_flag);
1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);
1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);
1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);
1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);

Line 1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);

1330: end if;
1331: l_screen_pop_action := cct_collection_util_pub.get(p_media_data, 'occtScreenPopAction', x_exist_flag);
1332: l_ani := cct_collection_util_pub.get(p_media_data, 'occtANI', x_exist_flag);
1333: l_media_item_id := cct_collection_util_pub.get(p_media_data, 'occtMediaItemID', x_exist_flag);
1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);
1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);
1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);
1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);
1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);

Line 1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);

1331: l_screen_pop_action := cct_collection_util_pub.get(p_media_data, 'occtScreenPopAction', x_exist_flag);
1332: l_ani := cct_collection_util_pub.get(p_media_data, 'occtANI', x_exist_flag);
1333: l_media_item_id := cct_collection_util_pub.get(p_media_data, 'occtMediaItemID', x_exist_flag);
1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);
1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);
1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);
1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);
1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);
1339: l_callID := cct_collection_util_pub.get(p_media_data, 'occtCallID', x_exist_flag);

Line 1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);

1332: l_ani := cct_collection_util_pub.get(p_media_data, 'occtANI', x_exist_flag);
1333: l_media_item_id := cct_collection_util_pub.get(p_media_data, 'occtMediaItemID', x_exist_flag);
1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);
1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);
1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);
1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);
1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);
1339: l_callID := cct_collection_util_pub.get(p_media_data, 'occtCallID', x_exist_flag);
1340: l_sender_name := cct_collection_util_pub.get(p_media_data, 'oiemSenderName', x_exist_flag);

Line 1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);

1333: l_media_item_id := cct_collection_util_pub.get(p_media_data, 'occtMediaItemID', x_exist_flag);
1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);
1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);
1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);
1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);
1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);
1339: l_callID := cct_collection_util_pub.get(p_media_data, 'occtCallID', x_exist_flag);
1340: l_sender_name := cct_collection_util_pub.get(p_media_data, 'oiemSenderName', x_exist_flag);
1341: if x_exist_flag = 'Y' and l_sender_name is not null then

Line 1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);

1334: l_event_name := cct_collection_util_pub.get(p_media_data, 'occtEventName', x_exist_flag);
1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);
1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);
1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);
1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);
1339: l_callID := cct_collection_util_pub.get(p_media_data, 'occtCallID', x_exist_flag);
1340: l_sender_name := cct_collection_util_pub.get(p_media_data, 'oiemSenderName', x_exist_flag);
1341: if x_exist_flag = 'Y' and l_sender_name is not null then
1342: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_sender_name);

Line 1339: l_callID := cct_collection_util_pub.get(p_media_data, 'occtCallID', x_exist_flag);

1335: l_agent := cct_collection_util_pub.get(p_media_data, 'occtAgentID', x_exist_flag);
1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);
1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);
1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);
1339: l_callID := cct_collection_util_pub.get(p_media_data, 'occtCallID', x_exist_flag);
1340: l_sender_name := cct_collection_util_pub.get(p_media_data, 'oiemSenderName', x_exist_flag);
1341: if x_exist_flag = 'Y' and l_sender_name is not null then
1342: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_sender_name);
1343: end if;

Line 1340: l_sender_name := cct_collection_util_pub.get(p_media_data, 'oiemSenderName', x_exist_flag);

1336: l_dnis := cct_collection_util_pub.get(p_media_data, 'occtDNIS', x_exist_flag);
1337: l_workitemID := cct_collection_util_pub.get(p_media_data, 'workItemID', x_exist_flag);
1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);
1339: l_callID := cct_collection_util_pub.get(p_media_data, 'occtCallID', x_exist_flag);
1340: l_sender_name := cct_collection_util_pub.get(p_media_data, 'oiemSenderName', x_exist_flag);
1341: if x_exist_flag = 'Y' and l_sender_name is not null then
1342: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_sender_name);
1343: end if;
1344: l_cust_prod_id := cct_collection_util_pub.get(p_media_data, 'CustomerProductID', x_exist_flag);

Line 1344: l_cust_prod_id := cct_collection_util_pub.get(p_media_data, 'CustomerProductID', x_exist_flag);

1340: l_sender_name := cct_collection_util_pub.get(p_media_data, 'oiemSenderName', x_exist_flag);
1341: if x_exist_flag = 'Y' and l_sender_name is not null then
1342: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_sender_name);
1343: end if;
1344: l_cust_prod_id := cct_collection_util_pub.get(p_media_data, 'CustomerProductID', x_exist_flag);
1345: l_inv_item_id := cct_collection_util_pub.get(p_media_data, 'InventoryItemID', x_exist_flag);
1346: l_emp_id := cct_collection_util_pub.get(p_media_data, 'employeeID', x_exist_flag);
1347: l_lot_num := cct_collection_util_pub.get(p_media_data, 'LotNum', x_exist_flag);
1348: l_po_num := cct_collection_util_pub.get(p_media_data, 'PurchaseOrderNum', x_exist_flag);

Line 1345: l_inv_item_id := cct_collection_util_pub.get(p_media_data, 'InventoryItemID', x_exist_flag);

1341: if x_exist_flag = 'Y' and l_sender_name is not null then
1342: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_sender_name);
1343: end if;
1344: l_cust_prod_id := cct_collection_util_pub.get(p_media_data, 'CustomerProductID', x_exist_flag);
1345: l_inv_item_id := cct_collection_util_pub.get(p_media_data, 'InventoryItemID', x_exist_flag);
1346: l_emp_id := cct_collection_util_pub.get(p_media_data, 'employeeID', x_exist_flag);
1347: l_lot_num := cct_collection_util_pub.get(p_media_data, 'LotNum', x_exist_flag);
1348: l_po_num := cct_collection_util_pub.get(p_media_data, 'PurchaseOrderNum', x_exist_flag);
1349: l_quote_num := cct_collection_util_pub.get(p_media_data, 'QuoteNum', x_exist_flag);

Line 1346: l_emp_id := cct_collection_util_pub.get(p_media_data, 'employeeID', x_exist_flag);

1342: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_sender_name);
1343: end if;
1344: l_cust_prod_id := cct_collection_util_pub.get(p_media_data, 'CustomerProductID', x_exist_flag);
1345: l_inv_item_id := cct_collection_util_pub.get(p_media_data, 'InventoryItemID', x_exist_flag);
1346: l_emp_id := cct_collection_util_pub.get(p_media_data, 'employeeID', x_exist_flag);
1347: l_lot_num := cct_collection_util_pub.get(p_media_data, 'LotNum', x_exist_flag);
1348: l_po_num := cct_collection_util_pub.get(p_media_data, 'PurchaseOrderNum', x_exist_flag);
1349: l_quote_num := cct_collection_util_pub.get(p_media_data, 'QuoteNum', x_exist_flag);
1350:

Line 1347: l_lot_num := cct_collection_util_pub.get(p_media_data, 'LotNum', x_exist_flag);

1343: end if;
1344: l_cust_prod_id := cct_collection_util_pub.get(p_media_data, 'CustomerProductID', x_exist_flag);
1345: l_inv_item_id := cct_collection_util_pub.get(p_media_data, 'InventoryItemID', x_exist_flag);
1346: l_emp_id := cct_collection_util_pub.get(p_media_data, 'employeeID', x_exist_flag);
1347: l_lot_num := cct_collection_util_pub.get(p_media_data, 'LotNum', x_exist_flag);
1348: l_po_num := cct_collection_util_pub.get(p_media_data, 'PurchaseOrderNum', x_exist_flag);
1349: l_quote_num := cct_collection_util_pub.get(p_media_data, 'QuoteNum', x_exist_flag);
1350:
1351:

Line 1348: l_po_num := cct_collection_util_pub.get(p_media_data, 'PurchaseOrderNum', x_exist_flag);

1344: l_cust_prod_id := cct_collection_util_pub.get(p_media_data, 'CustomerProductID', x_exist_flag);
1345: l_inv_item_id := cct_collection_util_pub.get(p_media_data, 'InventoryItemID', x_exist_flag);
1346: l_emp_id := cct_collection_util_pub.get(p_media_data, 'employeeID', x_exist_flag);
1347: l_lot_num := cct_collection_util_pub.get(p_media_data, 'LotNum', x_exist_flag);
1348: l_po_num := cct_collection_util_pub.get(p_media_data, 'PurchaseOrderNum', x_exist_flag);
1349: l_quote_num := cct_collection_util_pub.get(p_media_data, 'QuoteNum', x_exist_flag);
1350:
1351:
1352: /*

Line 1349: l_quote_num := cct_collection_util_pub.get(p_media_data, 'QuoteNum', x_exist_flag);

1345: l_inv_item_id := cct_collection_util_pub.get(p_media_data, 'InventoryItemID', x_exist_flag);
1346: l_emp_id := cct_collection_util_pub.get(p_media_data, 'employeeID', x_exist_flag);
1347: l_lot_num := cct_collection_util_pub.get(p_media_data, 'LotNum', x_exist_flag);
1348: l_po_num := cct_collection_util_pub.get(p_media_data, 'PurchaseOrderNum', x_exist_flag);
1349: l_quote_num := cct_collection_util_pub.get(p_media_data, 'QuoteNum', x_exist_flag);
1350:
1351:
1352: /*
1353: --First preference is given to user hook.

Line 1404: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'FromEBC','Y');

1400: l_ssn := null;
1401: l_contract_num := null;
1402: l_invoice_num := null;
1403:
1404: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'FromEBC','Y');
1405: --foo needs to clear out uwq_service_key_name and value
1406: ELSE
1407: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'FromEBC','N');
1408: --foo needs to append all the xfr params to p_action_param

Line 1407: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'FromEBC','N');

1403:
1404: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'FromEBC','Y');
1405: --foo needs to clear out uwq_service_key_name and value
1406: ELSE
1407: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'FromEBC','N');
1408: --foo needs to append all the xfr params to p_action_param
1409: END IF;
1410: END IF;
1411:

Line 1416: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SR');

1412: */
1413:
1414: --Service Key gets priority
1415: if l_sr_num is not null then
1416: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SR');
1417:
1418: --call anand lookup to search for sr num
1419: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SERVICE_REQUEST_NUMBER',
1420: p_skey_value => l_sr_num,

Line 1426: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1422: IF (l_hdr_info_tbl.count = 0) THEN
1423: l_match := '0';
1424: ELSIF (l_hdr_info_tbl.count = 1) THEN
1425: l_match := '1';
1426: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1427:
1428: IF l_hdr_info_tbl(1).rel_party_id is not null THEN
1429: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_party_id',l_hdr_info_tbl(1).rel_party_id);
1430:

Line 1429: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_party_id',l_hdr_info_tbl(1).rel_party_id);

1425: l_match := '1';
1426: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1427:
1428: IF l_hdr_info_tbl(1).rel_party_id is not null THEN
1429: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_party_id',l_hdr_info_tbl(1).rel_party_id);
1430:
1431: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).rel_party_id);
1432: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1433: END IF;

Line 1432: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1428: IF l_hdr_info_tbl(1).rel_party_id is not null THEN
1429: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_party_id',l_hdr_info_tbl(1).rel_party_id);
1430:
1431: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).rel_party_id);
1432: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1433: END IF;
1434:
1435: IF l_hdr_info_tbl(1).cust_party_id is not null THEN
1436: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

Line 1436: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1432: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1433: END IF;
1434:
1435: IF l_hdr_info_tbl(1).cust_party_id is not null THEN
1436: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1437:
1438: IF l_customer_name IS NULL THEN
1439: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1440: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

Line 1440: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1436: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1437:
1438: IF l_customer_name IS NULL THEN
1439: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1440: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1441: END IF;
1442: END IF;
1443:
1444: IF l_hdr_info_tbl(1).employee_id is not null THEN

Line 1445: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_hdr_info_tbl(1).employee_id);

1441: END IF;
1442: END IF;
1443:
1444: IF l_hdr_info_tbl(1).employee_id is not null THEN
1445: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_hdr_info_tbl(1).employee_id);
1446: END IF;
1447:
1448: IF l_hdr_info_tbl(1).cust_phone_id is not null THEN
1449: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_cust_phone_id',l_hdr_info_tbl(1).cust_phone_id);

Line 1449: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_cust_phone_id',l_hdr_info_tbl(1).cust_phone_id);

1445: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_hdr_info_tbl(1).employee_id);
1446: END IF;
1447:
1448: IF l_hdr_info_tbl(1).cust_phone_id is not null THEN
1449: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_cust_phone_id',l_hdr_info_tbl(1).cust_phone_id);
1450: END IF;
1451:
1452: IF l_hdr_info_tbl(1).account_id is not null THEN
1453: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1453: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1449: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_cust_phone_id',l_hdr_info_tbl(1).cust_phone_id);
1450: END IF;
1451:
1452: IF l_hdr_info_tbl(1).account_id is not null THEN
1453: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1454: END IF;
1455:
1456: IF l_hdr_info_tbl(1).rel_phone_id is not null THEN
1457: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_phone_id',l_hdr_info_tbl(1).rel_phone_id);

Line 1457: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_phone_id',l_hdr_info_tbl(1).rel_phone_id);

1453: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1454: END IF;
1455:
1456: IF l_hdr_info_tbl(1).rel_phone_id is not null THEN
1457: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_phone_id',l_hdr_info_tbl(1).rel_phone_id);
1458: END IF;
1459:
1460: IF l_hdr_info_tbl(1).per_party_id is not null THEN
1461: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_per_party_id',l_hdr_info_tbl(1).per_party_id);

Line 1461: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_per_party_id',l_hdr_info_tbl(1).per_party_id);

1457: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_phone_id',l_hdr_info_tbl(1).rel_phone_id);
1458: END IF;
1459:
1460: IF l_hdr_info_tbl(1).per_party_id is not null THEN
1461: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_per_party_id',l_hdr_info_tbl(1).per_party_id);
1462: END IF;
1463:
1464: IF l_hdr_info_tbl(1).rel_email_id is not null THEN
1465: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_email_id',l_hdr_info_tbl(1).rel_email_id);

Line 1465: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_email_id',l_hdr_info_tbl(1).rel_email_id);

1461: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_per_party_id',l_hdr_info_tbl(1).per_party_id);
1462: END IF;
1463:
1464: IF l_hdr_info_tbl(1).rel_email_id is not null THEN
1465: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_email_id',l_hdr_info_tbl(1).rel_email_id);
1466: END IF;
1467:
1468: IF l_hdr_info_tbl(1).cust_email_id is not null THEN
1469: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_cust_email_id',l_hdr_info_tbl(1).cust_email_id);

Line 1469: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_cust_email_id',l_hdr_info_tbl(1).cust_email_id);

1465: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_rel_email_id',l_hdr_info_tbl(1).rel_email_id);
1466: END IF;
1467:
1468: IF l_hdr_info_tbl(1).cust_email_id is not null THEN
1469: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_cust_email_id',l_hdr_info_tbl(1).cust_email_id);
1470: END IF;
1471:
1472: --bug 5640146
1473: --passing service_key_id

Line 1475: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1471:
1472: --bug 5640146
1473: --passing service_key_id
1474: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1475: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1476: END IF;
1477:
1478: --passing org_id
1479: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1480: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1476: END IF;
1477:
1478: --passing org_id
1479: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1480: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1481: END IF;
1482: --end of bug 5640146
1483:
1484: ELSE --(l_hdr_info_tbl.count > 1) THEN

Line 1488: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1484: ELSE --(l_hdr_info_tbl.count > 1) THEN
1485: l_match := 'M';
1486: --remember to append the SR # to the p_action_str in foo
1487: END IF;
1488: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1489: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1490: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1491: RETURN;
1492: elsif l_emp_id is not null then

Line 1489: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1485: l_match := 'M';
1486: --remember to append the SR # to the p_action_str in foo
1487: END IF;
1488: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1489: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1490: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1491: RETURN;
1492: elsif l_emp_id is not null then
1493: l_match := '0';

Line 1490: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1486: --remember to append the SR # to the p_action_str in foo
1487: END IF;
1488: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1489: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1490: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1491: RETURN;
1492: elsif l_emp_id is not null then
1493: l_match := '0';
1494: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','Employee');

Line 1494: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','Employee');

1490: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1491: RETURN;
1492: elsif l_emp_id is not null then
1493: l_match := '0';
1494: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','Employee');
1495: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_emp_id);
1496: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1497: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1498: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

Line 1495: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_emp_id);

1491: RETURN;
1492: elsif l_emp_id is not null then
1493: l_match := '0';
1494: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','Employee');
1495: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_emp_id);
1496: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1497: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1498: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1499: RETURN;

Line 1496: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1492: elsif l_emp_id is not null then
1493: l_match := '0';
1494: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','Employee');
1495: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_emp_id);
1496: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1497: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1498: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1499: RETURN;
1500: elsif l_instance_name is not null then

Line 1497: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1493: l_match := '0';
1494: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','Employee');
1495: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_emp_id);
1496: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1497: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1498: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1499: RETURN;
1500: elsif l_instance_name is not null then
1501: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceName');

Line 1498: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1494: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','Employee');
1495: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'employeeID',l_emp_id);
1496: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1497: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1498: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1499: RETURN;
1500: elsif l_instance_name is not null then
1501: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceName');
1502:

Line 1501: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceName');

1497: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1498: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1499: RETURN;
1500: elsif l_instance_name is not null then
1501: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceName');
1502:
1503: --call anand lookup to search for instance name
1504: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INSTANCE_NAME',
1505: p_skey_value => l_instance_name,

Line 1511: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1507: IF (l_hdr_info_tbl.count = 0) THEN
1508: l_match := '0';
1509: ELSIF (l_hdr_info_tbl.count = 1) THEN
1510: l_match := '1';
1511: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1512: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1513:
1514: --must check if account_id is null before setting.
1515: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN

Line 1512: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1508: l_match := '0';
1509: ELSIF (l_hdr_info_tbl.count = 1) THEN
1510: l_match := '1';
1511: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1512: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1513:
1514: --must check if account_id is null before setting.
1515: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1516: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1516: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1512: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1513:
1514: --must check if account_id is null before setting.
1515: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1516: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1517: END IF;
1518:
1519: --bug 5640146
1520: --passing service_key_id

Line 1522: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1518:
1519: --bug 5640146
1520: --passing service_key_id
1521: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1522: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1523: END IF;
1524:
1525: --passing org_id
1526: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1527: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1523: END IF;
1524:
1525: --passing org_id
1526: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1527: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1528: END IF;
1529: --end of bug 5640146
1530:
1531: --Resolve party_name from party_id

Line 1533: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1529: --end of bug 5640146
1530:
1531: --Resolve party_name from party_id
1532: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1533: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1534: ELSE --(l_hdr_info_tbl.count > 1) THEN
1535: l_match := 'M';
1536: --remember to append the instance name to the p_action_str in foo
1537: END IF;

Line 1538: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1534: ELSE --(l_hdr_info_tbl.count > 1) THEN
1535: l_match := 'M';
1536: --remember to append the instance name to the p_action_str in foo
1537: END IF;
1538: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1539: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1540: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1541: RETURN;
1542: elsif l_instance_num is not null then

Line 1539: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1535: l_match := 'M';
1536: --remember to append the instance name to the p_action_str in foo
1537: END IF;
1538: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1539: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1540: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1541: RETURN;
1542: elsif l_instance_num is not null then
1543: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceNum');

Line 1540: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1536: --remember to append the instance name to the p_action_str in foo
1537: END IF;
1538: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1539: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1540: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1541: RETURN;
1542: elsif l_instance_num is not null then
1543: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceNum');
1544:

Line 1543: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceNum');

1539: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1540: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1541: RETURN;
1542: elsif l_instance_num is not null then
1543: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InstanceNum');
1544:
1545: --call anand lookup to search for instance num
1546: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INSTANCE_NUMBER',
1547: p_skey_value => l_instance_num,

Line 1553: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1549: IF (l_hdr_info_tbl.count = 0) THEN
1550: l_match := '0';
1551: ELSIF (l_hdr_info_tbl.count = 1) THEN
1552: l_match := '1';
1553: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1554: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1555:
1556: --must check if account_id is null before setting.
1557: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN

Line 1554: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1550: l_match := '0';
1551: ELSIF (l_hdr_info_tbl.count = 1) THEN
1552: l_match := '1';
1553: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1554: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1555:
1556: --must check if account_id is null before setting.
1557: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1558: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1558: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1554: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1555:
1556: --must check if account_id is null before setting.
1557: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1558: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1559: END IF;
1560:
1561: --bug 5640146
1562: --passing service_key_id

Line 1564: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1560:
1561: --bug 5640146
1562: --passing service_key_id
1563: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1564: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1565: END IF;
1566:
1567: --passing org_id
1568: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1569: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1565: END IF;
1566:
1567: --passing org_id
1568: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1569: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1570: END IF;
1571: --end of bug 5640146
1572:
1573: --Resolve party_name from party_id

Line 1575: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1571: --end of bug 5640146
1572:
1573: --Resolve party_name from party_id
1574: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1575: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1576: ELSE --(l_hdr_info_tbl.count > 1) THEN
1577: l_match := 'M';
1578: END IF;
1579: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

Line 1579: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1575: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1576: ELSE --(l_hdr_info_tbl.count > 1) THEN
1577: l_match := 'M';
1578: END IF;
1579: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1580: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1581: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1582: RETURN;
1583: elsif l_serial_num is not null then

Line 1580: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1576: ELSE --(l_hdr_info_tbl.count > 1) THEN
1577: l_match := 'M';
1578: END IF;
1579: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1580: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1581: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1582: RETURN;
1583: elsif l_serial_num is not null then
1584: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SerialNum');

Line 1581: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1577: l_match := 'M';
1578: END IF;
1579: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1580: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1581: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1582: RETURN;
1583: elsif l_serial_num is not null then
1584: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SerialNum');
1585:

Line 1584: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SerialNum');

1580: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1581: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1582: RETURN;
1583: elsif l_serial_num is not null then
1584: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SerialNum');
1585:
1586: --call anand lookup to search for serial num
1587: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SERIAL_NUMBER',
1588: p_skey_value => l_serial_num,

Line 1594: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1590: IF (l_hdr_info_tbl.count = 0) THEN
1591: l_match := '0';
1592: ELSIF (l_hdr_info_tbl.count = 1) THEN
1593: l_match := '1';
1594: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1595: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1596:
1597: --must check if account_id is null before setting.
1598: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN

Line 1595: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1591: l_match := '0';
1592: ELSIF (l_hdr_info_tbl.count = 1) THEN
1593: l_match := '1';
1594: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1595: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1596:
1597: --must check if account_id is null before setting.
1598: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1599: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1599: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1595: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1596:
1597: --must check if account_id is null before setting.
1598: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1599: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1600: END IF;
1601:
1602: --bug 5640146
1603: --passing service_key_id

Line 1605: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1601:
1602: --bug 5640146
1603: --passing service_key_id
1604: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1605: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1606: END IF;
1607:
1608: --passing org_id
1609: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1610: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1606: END IF;
1607:
1608: --passing org_id
1609: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1610: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1611: END IF;
1612: --end of bug 5640146
1613:
1614: --Resolve party_name from party_id

Line 1616: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1612: --end of bug 5640146
1613:
1614: --Resolve party_name from party_id
1615: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1616: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1617: ELSE --(l_hdr_info_tbl.count > 1) THEN
1618: l_match := 'M';
1619: --remember to append the serial # to the p_action_str in foo
1620: END IF;

Line 1621: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1617: ELSE --(l_hdr_info_tbl.count > 1) THEN
1618: l_match := 'M';
1619: --remember to append the serial # to the p_action_str in foo
1620: END IF;
1621: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1622: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1623: --l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1624: RETURN;
1625: elsif l_tag_num is not null then

Line 1622: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1618: l_match := 'M';
1619: --remember to append the serial # to the p_action_str in foo
1620: END IF;
1621: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1622: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1623: --l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1624: RETURN;
1625: elsif l_tag_num is not null then
1626: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','TagNum');

Line 1623: --l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1619: --remember to append the serial # to the p_action_str in foo
1620: END IF;
1621: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1622: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1623: --l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1624: RETURN;
1625: elsif l_tag_num is not null then
1626: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','TagNum');
1627:

Line 1626: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','TagNum');

1622: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1623: --l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1624: RETURN;
1625: elsif l_tag_num is not null then
1626: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','TagNum');
1627:
1628: --call anand lookup to search for tag num
1629: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'EXTERNAL_REFERENCE',
1630: p_skey_value => l_tag_num,

Line 1636: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1632: IF (l_hdr_info_tbl.count = 0) THEN
1633: l_match := '0';
1634: ELSIF (l_hdr_info_tbl.count = 1) THEN
1635: l_match := '1';
1636: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1637: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1638:
1639: --must check if account_id is null before setting.
1640: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN

Line 1637: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1633: l_match := '0';
1634: ELSIF (l_hdr_info_tbl.count = 1) THEN
1635: l_match := '1';
1636: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1637: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1638:
1639: --must check if account_id is null before setting.
1640: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1641: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1641: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1637: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1638:
1639: --must check if account_id is null before setting.
1640: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1641: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1642: END IF;
1643:
1644: --bug 5640146
1645: --passing service_key_id

Line 1647: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1643:
1644: --bug 5640146
1645: --passing service_key_id
1646: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1647: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1648: END IF;
1649:
1650: --passing org_id
1651: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1652: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1648: END IF;
1649:
1650: --passing org_id
1651: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1652: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1653: END IF;
1654: --end of bug 5640146
1655:
1656: --Resolve party_name from party_id

Line 1658: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1654: --end of bug 5640146
1655:
1656: --Resolve party_name from party_id
1657: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1658: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1659: ELSE --(l_hdr_info_tbl.count > 1) THEN
1660: l_match := 'M';
1661: --remember to append the tag # to the p_action_str in foo
1662: END IF;

Line 1663: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1659: ELSE --(l_hdr_info_tbl.count > 1) THEN
1660: l_match := 'M';
1661: --remember to append the tag # to the p_action_str in foo
1662: END IF;
1663: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1664: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1665: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1666: RETURN;
1667: elsif l_system_name is not null then

Line 1664: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1660: l_match := 'M';
1661: --remember to append the tag # to the p_action_str in foo
1662: END IF;
1663: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1664: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1665: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1666: RETURN;
1667: elsif l_system_name is not null then
1668: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SystemName');

Line 1665: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1661: --remember to append the tag # to the p_action_str in foo
1662: END IF;
1663: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1664: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1665: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1666: RETURN;
1667: elsif l_system_name is not null then
1668: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SystemName');
1669:

Line 1668: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SystemName');

1664: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1665: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1666: RETURN;
1667: elsif l_system_name is not null then
1668: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SystemName');
1669:
1670: --call anand lookup to search for system name
1671: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SYSTEM_NUMBER',
1672: p_skey_value => l_system_name,

Line 1678: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1674: IF (l_hdr_info_tbl.count = 0) THEN
1675: l_match := '0';
1676: ELSIF (l_hdr_info_tbl.count = 1) THEN
1677: l_match := '1';
1678: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1679: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1680:
1681: --must check if account_id is null before setting.
1682: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN

Line 1679: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1675: l_match := '0';
1676: ELSIF (l_hdr_info_tbl.count = 1) THEN
1677: l_match := '1';
1678: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1679: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1680:
1681: --must check if account_id is null before setting.
1682: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1683: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1683: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1679: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1680:
1681: --must check if account_id is null before setting.
1682: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1683: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1684: END IF;
1685:
1686: --bug 5640146
1687: --passing service_key_id

Line 1689: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1685:
1686: --bug 5640146
1687: --passing service_key_id
1688: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1689: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1690: END IF;
1691:
1692: --passing org_id
1693: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1694: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1690: END IF;
1691:
1692: --passing org_id
1693: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1694: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1695: END IF;
1696: --end of bug 5640146
1697:
1698: --Resolve party_name from party_id

Line 1700: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1696: --end of bug 5640146
1697:
1698: --Resolve party_name from party_id
1699: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1700: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1701: ELSE --(l_hdr_info_tbl.count > 1) THEN
1702: l_match := 'M';
1703: --remember to append the system # to the p_action_str in foo
1704: END IF;

Line 1705: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1701: ELSE --(l_hdr_info_tbl.count > 1) THEN
1702: l_match := 'M';
1703: --remember to append the system # to the p_action_str in foo
1704: END IF;
1705: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1706: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1707: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1708: RETURN;
1709: elsif l_rma_num is not null then

Line 1706: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1702: l_match := 'M';
1703: --remember to append the system # to the p_action_str in foo
1704: END IF;
1705: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1706: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1707: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1708: RETURN;
1709: elsif l_rma_num is not null then
1710: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','RMANum');

Line 1707: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1703: --remember to append the system # to the p_action_str in foo
1704: END IF;
1705: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1706: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1707: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1708: RETURN;
1709: elsif l_rma_num is not null then
1710: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','RMANum');
1711:

Line 1710: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','RMANum');

1706: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1707: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1708: RETURN;
1709: elsif l_rma_num is not null then
1710: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','RMANum');
1711:
1712: --call anand lookup to search for rma num
1713: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'RMA_NUMBER',
1714: p_skey_value => l_rma_num,

Line 1720: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1716: IF (l_hdr_info_tbl.count = 0) THEN
1717: l_match := '0';
1718: ELSIF (l_hdr_info_tbl.count = 1) THEN
1719: l_match := '1';
1720: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1721: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1722:
1723: --must check if account_id is null before setting.
1724: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN

Line 1721: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1717: l_match := '0';
1718: ELSIF (l_hdr_info_tbl.count = 1) THEN
1719: l_match := '1';
1720: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1721: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1722:
1723: --must check if account_id is null before setting.
1724: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1725: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1725: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1721: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1722:
1723: --must check if account_id is null before setting.
1724: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1725: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1726: END IF;
1727:
1728: --bug 5640146
1729: --passing service_key_id

Line 1731: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1727:
1728: --bug 5640146
1729: --passing service_key_id
1730: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1731: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1732: END IF;
1733:
1734: --passing org_id
1735: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1736: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1732: END IF;
1733:
1734: --passing org_id
1735: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1736: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1737: END IF;
1738: --end of bug 5640146
1739:
1740: --Resolve party_name from party_id

Line 1742: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1738: --end of bug 5640146
1739:
1740: --Resolve party_name from party_id
1741: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1742: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1743: ELSE --(l_hdr_info_tbl.count > 1) THEN
1744: l_match := 'M';
1745: --remember to append the rma # to the p_action_str in foo
1746: END IF;

Line 1747: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1743: ELSE --(l_hdr_info_tbl.count > 1) THEN
1744: l_match := 'M';
1745: --remember to append the rma # to the p_action_str in foo
1746: END IF;
1747: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1748: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1749: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1750: RETURN;
1751: elsif l_order_num is not null then

Line 1748: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1744: l_match := 'M';
1745: --remember to append the rma # to the p_action_str in foo
1746: END IF;
1747: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1748: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1749: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1750: RETURN;
1751: elsif l_order_num is not null then
1752: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','OrderNum');

Line 1749: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1745: --remember to append the rma # to the p_action_str in foo
1746: END IF;
1747: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1748: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1749: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1750: RETURN;
1751: elsif l_order_num is not null then
1752: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','OrderNum');
1753:

Line 1752: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','OrderNum');

1748: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1749: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1750: RETURN;
1751: elsif l_order_num is not null then
1752: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','OrderNum');
1753:
1754: --call anand lookup to search for order num
1755: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'ORDER_NUMBER',
1756: p_skey_value => l_order_num,

Line 1762: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1758: IF (l_hdr_info_tbl.count = 0) THEN
1759: l_match := '0';
1760: ELSIF (l_hdr_info_tbl.count = 1) THEN
1761: l_match := '1';
1762: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1763: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1764:
1765: --must check if account_id is null before setting.
1766: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN

Line 1763: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1759: l_match := '0';
1760: ELSIF (l_hdr_info_tbl.count = 1) THEN
1761: l_match := '1';
1762: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1763: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1764:
1765: --must check if account_id is null before setting.
1766: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1767: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1767: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1763: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1764:
1765: --must check if account_id is null before setting.
1766: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1767: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1768: END IF;
1769:
1770: --bug 5640146
1771: --passing service_key_id

Line 1773: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1769:
1770: --bug 5640146
1771: --passing service_key_id
1772: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1773: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1774: END IF;
1775:
1776: --passing org_id
1777: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1778: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1774: END IF;
1775:
1776: --passing org_id
1777: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1778: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1779: END IF;
1780: --end of bug 5640146
1781:
1782: --Resolve party_name from party_id

Line 1784: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1780: --end of bug 5640146
1781:
1782: --Resolve party_name from party_id
1783: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1784: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1785: ELSE --(l_hdr_info_tbl.count > 1) THEN
1786: l_match := 'M';
1787: --remember to append the order # to the p_action_str in foo
1788: END IF;

Line 1789: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1785: ELSE --(l_hdr_info_tbl.count > 1) THEN
1786: l_match := 'M';
1787: --remember to append the order # to the p_action_str in foo
1788: END IF;
1789: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1790: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1791: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1792: RETURN;
1793: elsif l_ssn is not null then

Line 1790: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1786: l_match := 'M';
1787: --remember to append the order # to the p_action_str in foo
1788: END IF;
1789: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1790: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1791: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1792: RETURN;
1793: elsif l_ssn is not null then
1794: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SSN');

Line 1791: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1787: --remember to append the order # to the p_action_str in foo
1788: END IF;
1789: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1790: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1791: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1792: RETURN;
1793: elsif l_ssn is not null then
1794: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SSN');
1795:

Line 1794: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SSN');

1790: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1791: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1792: RETURN;
1793: elsif l_ssn is not null then
1794: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','SSN');
1795:
1796: --call anand lookup to search for ssn
1797: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'SSN',
1798: p_skey_value => l_ssn,

Line 1804: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1800: IF (l_hdr_info_tbl.count = 0) THEN
1801: l_match := '0';
1802: ELSIF (l_hdr_info_tbl.count = 1) THEN
1803: l_match := '1';
1804: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1805: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1806:
1807: --bug 5640146
1808: --passing service_key_id

Line 1805: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1801: l_match := '0';
1802: ELSIF (l_hdr_info_tbl.count = 1) THEN
1803: l_match := '1';
1804: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1805: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1806:
1807: --bug 5640146
1808: --passing service_key_id
1809: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN

Line 1810: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1806:
1807: --bug 5640146
1808: --passing service_key_id
1809: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1810: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1811: END IF;
1812:
1813: --passing org_id
1814: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1815: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1811: END IF;
1812:
1813: --passing org_id
1814: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1815: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1816: END IF;
1817: --end of bug 5640146
1818:
1819: --Resolve party_name from party_id

Line 1821: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1817: --end of bug 5640146
1818:
1819: --Resolve party_name from party_id
1820: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1821: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1822: ELSE --(l_hdr_info_tbl.count > 1) THEN
1823: l_match := 'M';
1824: --remember to append the ssn to the p_action_str in foo
1825: END IF;

Line 1826: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1822: ELSE --(l_hdr_info_tbl.count > 1) THEN
1823: l_match := 'M';
1824: --remember to append the ssn to the p_action_str in foo
1825: END IF;
1826: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1827: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1828: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1829: RETURN;
1830: elsif l_contract_num is not null then

Line 1827: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1823: l_match := 'M';
1824: --remember to append the ssn to the p_action_str in foo
1825: END IF;
1826: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1827: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1828: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1829: RETURN;
1830: elsif l_contract_num is not null then
1831: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ContractNum');

Line 1828: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1824: --remember to append the ssn to the p_action_str in foo
1825: END IF;
1826: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1827: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1828: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1829: RETURN;
1830: elsif l_contract_num is not null then
1831: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ContractNum');
1832:

Line 1831: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ContractNum');

1827: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1828: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1829: RETURN;
1830: elsif l_contract_num is not null then
1831: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ContractNum');
1832:
1833: --call anand lookup to search for contract num
1834: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'CONTRACT_NUMBER',
1835: p_skey_value => l_contract_num,

Line 1842: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1838: l_match := '0';
1839: ELSIF (l_hdr_info_tbl.count = 1) THEN
1840: l_match := '1';
1841:
1842: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1843: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1844:
1845: --bug 5640146
1846: --passing service_key_id

Line 1843: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1839: ELSIF (l_hdr_info_tbl.count = 1) THEN
1840: l_match := '1';
1841:
1842: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1843: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1844:
1845: --bug 5640146
1846: --passing service_key_id
1847: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN

Line 1848: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1844:
1845: --bug 5640146
1846: --passing service_key_id
1847: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1848: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1849: END IF;
1850:
1851: --passing org_id
1852: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1853: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1849: END IF;
1850:
1851: --passing org_id
1852: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1853: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1854: END IF;
1855: --end of bug 5640146
1856:
1857: --Resolve party_name from party_id

Line 1859: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1855: --end of bug 5640146
1856:
1857: --Resolve party_name from party_id
1858: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1859: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1860: ELSE --(l_hdr_info_tbl.count > 1) THEN
1861: l_match := 'M';
1862: --remember to append the contract # to the p_action_str in foo
1863: END IF;

Line 1864: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1860: ELSE --(l_hdr_info_tbl.count > 1) THEN
1861: l_match := 'M';
1862: --remember to append the contract # to the p_action_str in foo
1863: END IF;
1864: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1865: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1866: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1867: RETURN;
1868: elsif l_invoice_num is not null then

Line 1865: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1861: l_match := 'M';
1862: --remember to append the contract # to the p_action_str in foo
1863: END IF;
1864: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1865: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1866: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1867: RETURN;
1868: elsif l_invoice_num is not null then
1869: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InvoiceNum');

Line 1866: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1862: --remember to append the contract # to the p_action_str in foo
1863: END IF;
1864: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1865: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1866: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1867: RETURN;
1868: elsif l_invoice_num is not null then
1869: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InvoiceNum');
1870:

Line 1869: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InvoiceNum');

1865: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1866: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1867: RETURN;
1868: elsif l_invoice_num is not null then
1869: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','InvoiceNum');
1870:
1871: --call anand lookup to search for invoice num
1872: CSC_SERVICE_KEY_PVT.service_key_search(p_skey_name => 'INVOICE_NUMBER',
1873: p_skey_value => l_invoice_num,

Line 1879: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);

1875: IF (l_hdr_info_tbl.count = 0) THEN
1876: l_match := '0';
1877: ELSIF (l_hdr_info_tbl.count = 1) THEN
1878: l_match := '1';
1879: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1880: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1881:
1882: --must check if account_id is null before setting.
1883: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN

Line 1880: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);

1876: l_match := '0';
1877: ELSIF (l_hdr_info_tbl.count = 1) THEN
1878: l_match := '1';
1879: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_hdr_info_tbl(1).cust_party_id);
1880: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1881:
1882: --must check if account_id is null before setting.
1883: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1884: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

Line 1884: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);

1880: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_hdr_info_tbl(1).cust_party_id);
1881:
1882: --must check if account_id is null before setting.
1883: IF l_hdr_info_tbl(1).account_id IS NOT NULL THEN
1884: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'SKEY_account_id',l_hdr_info_tbl(1).account_id);
1885: END IF;
1886:
1887: --bug 5640146
1888: --passing service_key_id

Line 1890: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);

1886:
1887: --bug 5640146
1888: --passing service_key_id
1889: IF l_hdr_info_tbl(1).service_key_id IS NOT NULL THEN
1890: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'service_key_id',l_hdr_info_tbl(1).service_key_id);
1891: END IF;
1892:
1893: --passing org_id
1894: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN

Line 1895: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);

1891: END IF;
1892:
1893: --passing org_id
1894: IF l_hdr_info_tbl(1).org_id IS NOT NULL THEN
1895: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_skey_org_id',l_hdr_info_tbl(1).org_id);
1896: END IF;
1897: --end of bug 5640146
1898:
1899: --Resolve party_name from party_id

Line 1901: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1897: --end of bug 5640146
1898:
1899: --Resolve party_name from party_id
1900: l_customer_name := get_party_name_from_party_id(l_hdr_info_tbl(1).cust_party_id);
1901: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1902: ELSE --(l_hdr_info_tbl.count > 1) THEN
1903: l_match := 'M';
1904: --remember to append the invoice # to the p_action_str in foo
1905: END IF;

Line 1906: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1902: ELSE --(l_hdr_info_tbl.count > 1) THEN
1903: l_match := 'M';
1904: --remember to append the invoice # to the p_action_str in foo
1905: END IF;
1906: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1907: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1908: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1909: RETURN;
1910: end if;

Line 1907: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1903: l_match := 'M';
1904: --remember to append the invoice # to the p_action_str in foo
1905: END IF;
1906: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1907: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1908: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1909: RETURN;
1910: end if;
1911:

Line 1908: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1904: --remember to append the invoice # to the p_action_str in foo
1905: END IF;
1906: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1907: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1908: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1909: RETURN;
1910: end if;
1911:
1912: --Customer Num LookUp

Line 1918: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');

1914: l_customer_id := null;
1915: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum(p_party_number => l_customer_num);
1916: IF l_customer_id IS NOT NULL THEN
1917: l_match := '1';
1918: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
1919:
1920: --bug 5615536
1921: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1922: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

Line 1921: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);

1917: l_match := '1';
1918: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
1919:
1920: --bug 5615536
1921: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1922: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1923: --end of bug 5615536
1924:
1925: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

Line 1922: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

1918: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
1919:
1920: --bug 5615536
1921: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1922: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1923: --end of bug 5615536
1924:
1925: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1926: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

Line 1925: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1921: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1922: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1923: --end of bug 5615536
1924:
1925: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1926: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1927:
1928: --Resolve party_name from party_id
1929: l_customer_name := get_party_name_from_party_id(l_customer_id);

Line 1926: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1922: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1923: --end of bug 5615536
1924:
1925: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1926: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1927:
1928: --Resolve party_name from party_id
1929: l_customer_name := get_party_name_from_party_id(l_customer_id);
1930: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

Line 1930: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1926: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1927:
1928: --Resolve party_name from party_id
1929: l_customer_name := get_party_name_from_party_id(l_customer_id);
1930: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1931: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1932: RETURN;
1933: END IF;
1934: END IF;

Line 1931: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1927:
1928: --Resolve party_name from party_id
1929: l_customer_name := get_party_name_from_party_id(l_customer_id);
1930: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1931: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1932: RETURN;
1933: END IF;
1934: END IF;
1935:

Line 1945: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','AccountCode');

1941: x_cust_account_id => l_cust_account_id,
1942: x_last_update_date => l_acct_last_update_date);
1943: IF l_customer_id IS NOT NULL THEN
1944: l_match := '1';
1945: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','AccountCode');
1946: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1947: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1948:
1949: --must check if account_id is null before setting.

Line 1946: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);

1942: x_last_update_date => l_acct_last_update_date);
1943: IF l_customer_id IS NOT NULL THEN
1944: l_match := '1';
1945: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','AccountCode');
1946: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1947: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1948:
1949: --must check if account_id is null before setting.
1950: IF l_cust_account_id IS NOT NULL THEN

Line 1947: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

1943: IF l_customer_id IS NOT NULL THEN
1944: l_match := '1';
1945: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','AccountCode');
1946: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1947: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1948:
1949: --must check if account_id is null before setting.
1950: IF l_cust_account_id IS NOT NULL THEN
1951: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_cust_account_id',l_cust_account_id);

Line 1951: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_cust_account_id',l_cust_account_id);

1947: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1948:
1949: --must check if account_id is null before setting.
1950: IF l_cust_account_id IS NOT NULL THEN
1951: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_cust_account_id',l_cust_account_id);
1952: END IF;
1953:
1954: IF l_acct_last_update_date IS NOT NULL THEN
1955: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_last_update_date',l_acct_last_update_date);

Line 1955: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_last_update_date',l_acct_last_update_date);

1951: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_cust_account_id',l_cust_account_id);
1952: END IF;
1953:
1954: IF l_acct_last_update_date IS NOT NULL THEN
1955: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_last_update_date',l_acct_last_update_date);
1956: END IF;
1957:
1958: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1959: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

Line 1958: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

1954: IF l_acct_last_update_date IS NOT NULL THEN
1955: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_last_update_date',l_acct_last_update_date);
1956: END IF;
1957:
1958: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1959: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1960:
1961: --Resolve party_name from party_id
1962: l_customer_name := get_party_name_from_party_id(l_customer_id);

Line 1959: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

1955: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_last_update_date',l_acct_last_update_date);
1956: END IF;
1957:
1958: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
1959: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1960:
1961: --Resolve party_name from party_id
1962: l_customer_name := get_party_name_from_party_id(l_customer_id);
1963: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

Line 1963: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1959: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
1960:
1961: --Resolve party_name from party_id
1962: l_customer_name := get_party_name_from_party_id(l_customer_id);
1963: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1964: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1965: RETURN;
1966: END IF;
1967: END IF;

Line 1964: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

1960:
1961: --Resolve party_name from party_id
1962: l_customer_name := get_party_name_from_party_id(l_customer_id);
1963: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1964: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
1965: RETURN;
1966: END IF;
1967: END IF;
1968:

Line 1978: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','CompletePhone');

1974: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_complete_phone_num);
1975: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,
1976: l_uwq_multi_record_match,
1977: l_phone_id);
1978: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','CompletePhone');
1979:
1980: IF l_customer_id IS NOT NULL THEN
1981: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1982: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

Line 1981: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);

1977: l_phone_id);
1978: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','CompletePhone');
1979:
1980: IF l_customer_id IS NOT NULL THEN
1981: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1982: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1983:
1984: IF l_phone_id IS NOT NULL THEN
1985: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_phone_id',l_phone_id);

Line 1982: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

1978: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','CompletePhone');
1979:
1980: IF l_customer_id IS NOT NULL THEN
1981: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1982: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1983:
1984: IF l_phone_id IS NOT NULL THEN
1985: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_phone_id',l_phone_id);
1986: END IF;

Line 1985: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_phone_id',l_phone_id);

1981: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
1982: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
1983:
1984: IF l_phone_id IS NOT NULL THEN
1985: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_phone_id',l_phone_id);
1986: END IF;
1987:
1988: --Resolve party_name from party_id
1989: l_customer_name := get_party_name_from_party_id(l_customer_id);

Line 1990: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

1986: END IF;
1987:
1988: --Resolve party_name from party_id
1989: l_customer_name := get_party_name_from_party_id(l_customer_id);
1990: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
1991:
1992: l_match := '1';
1993: ELSE
1994: IF l_uwq_multi_record_match is not null THEN

Line 2000: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_stripped_reverse_ani',l_stripped_rANI);

1996: l_uwq_multi_record_match := 'MULTIPLE_PHONE_NUMBERS';
1997: fnd_profile.get('CSC_CUSTOMER_FROM_EXACT_ANI',n_use_exact_ani);
1998: IF NVL(n_use_exact_ani,'Y') = 'N' THEN
1999: l_stripped_rANI := SUBSTR(l_rphone,1, LENGTH(l_rphone)-1);
2000: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_stripped_reverse_ani',l_stripped_rANI);
2001: END IF;
2002: ELSE
2003: l_match := '1';
2004: END IF;

Line 2008: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_multi_record_match',l_uwq_multi_record_match);

2004: END IF;
2005: END IF;
2006:
2007: IF l_uwq_multi_record_match IS NOT NULL THEN
2008: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_multi_record_match',l_uwq_multi_record_match);
2009: END IF;
2010:
2011: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2012:

Line 2011: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

2007: IF l_uwq_multi_record_match IS NOT NULL THEN
2008: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_multi_record_match',l_uwq_multi_record_match);
2009: END IF;
2010:
2011: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2012:
2013: IF l_rphone IS NOT NULL THEN
2014: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);
2015: END IF;

Line 2014: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);

2010:
2011: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2012:
2013: IF l_rphone IS NOT NULL THEN
2014: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);
2015: END IF;
2016:
2017: IF l_complete_phone_num IS NOT NULL THEN
2018: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_complete_phone_num',l_complete_phone_num);

Line 2018: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_complete_phone_num',l_complete_phone_num);

2014: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);
2015: END IF;
2016:
2017: IF l_complete_phone_num IS NOT NULL THEN
2018: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_complete_phone_num',l_complete_phone_num);
2019: END IF;
2020:
2021: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2022: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

Line 2021: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

2017: IF l_complete_phone_num IS NOT NULL THEN
2018: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_complete_phone_num',l_complete_phone_num);
2019: END IF;
2020:
2021: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2022: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2023: RETURN;
2024: END IF;
2025: END IF;

Line 2022: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

2018: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_complete_phone_num',l_complete_phone_num);
2019: END IF;
2020:
2021: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2022: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2023: RETURN;
2024: END IF;
2025: END IF;
2026:

Line 2033: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');

2029: l_customer_id := null;
2030: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum( p_party_number => l_contact_num);
2031: IF l_customer_id IS NOT NULL THEN
2032: l_match := '1';
2033: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
2034: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2035: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2036: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2037: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

Line 2034: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);

2030: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum( p_party_number => l_contact_num);
2031: IF l_customer_id IS NOT NULL THEN
2032: l_match := '1';
2033: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
2034: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2035: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2036: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2037: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2038:

Line 2035: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

2031: IF l_customer_id IS NOT NULL THEN
2032: l_match := '1';
2033: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
2034: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2035: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2036: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2037: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2038:
2039: --Resolve party_name from party_id

Line 2036: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

2032: l_match := '1';
2033: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
2034: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2035: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2036: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2037: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2038:
2039: --Resolve party_name from party_id
2040: l_customer_name := get_party_name_from_party_id(l_customer_id);

Line 2037: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

2033: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
2034: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2035: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2036: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2037: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2038:
2039: --Resolve party_name from party_id
2040: l_customer_name := get_party_name_from_party_id(l_customer_id);
2041: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

Line 2041: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

2037: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2038:
2039: --Resolve party_name from party_id
2040: l_customer_name := get_party_name_from_party_id(l_customer_id);
2041: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
2042: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2043:
2044: RETURN;
2045: END IF;

Line 2042: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

2038:
2039: --Resolve party_name from party_id
2040: l_customer_name := get_party_name_from_party_id(l_customer_id);
2041: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
2042: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2043:
2044: RETURN;
2045: END IF;
2046: END IF;

Line 2058: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ANI');

2054: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_ani);
2055: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,
2056: l_uwq_multi_record_match,
2057: l_phone_id);
2058: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ANI');
2059:
2060: IF l_customer_id is not null THEN --Exact Match
2061: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2062: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

Line 2061: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);

2057: l_phone_id);
2058: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ANI');
2059:
2060: IF l_customer_id is not null THEN --Exact Match
2061: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2062: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2063:
2064: IF l_phone_id IS NOT NULL THEN
2065: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_phone_id',l_phone_id);

Line 2062: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

2058: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ANI');
2059:
2060: IF l_customer_id is not null THEN --Exact Match
2061: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2062: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2063:
2064: IF l_phone_id IS NOT NULL THEN
2065: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_phone_id',l_phone_id);
2066: END IF;

Line 2065: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_phone_id',l_phone_id);

2061: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2062: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2063:
2064: IF l_phone_id IS NOT NULL THEN
2065: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_phone_id',l_phone_id);
2066: END IF;
2067:
2068: --Resolve party_name from party_id
2069: l_customer_name := get_party_name_from_party_id(l_customer_id);

Line 2070: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);

2066: END IF;
2067:
2068: --Resolve party_name from party_id
2069: l_customer_name := get_party_name_from_party_id(l_customer_id);
2070: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerName',l_customer_name);
2071: l_match := '1';
2072: ELSE
2073: IF l_uwq_multi_record_match is not null THEN
2074: l_match := 'M';

Line 2080: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_stripped_reverse_ani',l_stripped_rANI);

2076: fnd_profile.get('CSC_CUSTOMER_FROM_EXACT_ANI',n_use_exact_ani);
2077:
2078: IF NVL(n_use_exact_ani,'Y') = 'N' THEN
2079: l_stripped_rANI := SUBSTR(l_rphone,1, LENGTH(l_rphone)-1);
2080: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_stripped_reverse_ani',l_stripped_rANI);
2081: END IF;
2082: ELSE
2083: l_match := '0';
2084: END IF;

Line 2088: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_multi_record_match',l_uwq_multi_record_match);

2084: END IF;
2085: END IF;
2086:
2087: IF l_uwq_multi_record_match IS NOT NULL THEN
2088: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_multi_record_match',l_uwq_multi_record_match);
2089: END IF;
2090:
2091: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2092: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);

Line 2091: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

2087: IF l_uwq_multi_record_match IS NOT NULL THEN
2088: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_multi_record_match',l_uwq_multi_record_match);
2089: END IF;
2090:
2091: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2092: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);
2093: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2094: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2095: RETURN;

Line 2092: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);

2088: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_multi_record_match',l_uwq_multi_record_match);
2089: END IF;
2090:
2091: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2092: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);
2093: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2094: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2095: RETURN;
2096:

Line 2093: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

2089: END IF;
2090:
2091: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2092: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);
2093: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2094: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2095: RETURN;
2096:
2097: END IF;

Line 2094: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

2090:
2091: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2092: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_reverse_ani',l_rphone);
2093: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2094: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2095: RETURN;
2096:
2097: END IF;
2098: EXCEPTION

Line 2101: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);

2097: END IF;
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: l_customer_id := null;
2101: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2102: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2103: l_match := '0';
2104: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2105: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

Line 2102: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);

2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: l_customer_id := null;
2101: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2102: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2103: l_match := '0';
2104: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2105: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2106: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

Line 2104: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);

2100: l_customer_id := null;
2101: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2102: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2103: l_match := '0';
2104: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2105: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2106: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2107:
2108: END CSC_Customer_Lookup;

Line 2105: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);

2101: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
2102: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2103: l_match := '0';
2104: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2105: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2106: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2107:
2108: END CSC_Customer_Lookup;
2109:

Line 2106: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');

2102: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'PARTY_ID',l_customer_id);
2103: l_match := '0';
2104: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'MatchFlag',l_match);
2105: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'ProcessedFlag',l_processed_flag);
2106: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2107:
2108: END CSC_Customer_Lookup;
2109:
2110: END CSC_Routing_UTL;