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.JTF_TASK_PARTY_MERGE_PKG dependencies on JTF_PERZ_QUERY_PARAM

Line 1321: -- Procedure: SEARCH_MERGE_NUMBER_PARTY_ID - Performs party ids merge in JTF_PERZ_QUERY_PARAM table for Customer Number saved searches.

1317: END TASK_MERGE_CONTACT_POINTS;
1318:
1319:
1320: ------------------------------------------------------------------------------------------
1321: -- Procedure: SEARCH_MERGE_NUMBER_PARTY_ID - Performs party ids merge in JTF_PERZ_QUERY_PARAM table for Customer Number saved searches.
1322: -- Columns: Updates PARAMETER_VALUE where PARAMETER_NAME='CUSTOMER_ID'
1323: -- Parameters: p_from_id = jtf_perz_query_param.query_param_id
1324: ------------------------------------------------------------------------------------------
1325:

Line 1323: -- Parameters: p_from_id = jtf_perz_query_param.query_param_id

1319:
1320: ------------------------------------------------------------------------------------------
1321: -- Procedure: SEARCH_MERGE_NUMBER_PARTY_ID - Performs party ids merge in JTF_PERZ_QUERY_PARAM table for Customer Number saved searches.
1322: -- Columns: Updates PARAMETER_VALUE where PARAMETER_NAME='CUSTOMER_ID'
1323: -- Parameters: p_from_id = jtf_perz_query_param.query_param_id
1324: ------------------------------------------------------------------------------------------
1325:
1326: PROCEDURE SEARCH_MERGE_NUMBER_PARTY_ID(
1327: p_entity_name IN VARCHAR2,

Line 1350: --FROM jtf_perz_query_param p1,

1346: -- get CUSTOMER_NAME's query_param_id
1347:
1348: --cursor get_query_customer_name(p_from_id NUMBER) Is
1349: --SELECT p2.query_param_id
1350: --FROM jtf_perz_query_param p1,
1351: -- jtf_perz_query_param p2
1352: --WHERE p1.query_param_id = p_from_id
1353: --AND p1.query_id = p2.query_id
1354: --AND p2.parameter_name = 'CUSTOMER_NAME';

Line 1351: -- jtf_perz_query_param p2

1347:
1348: --cursor get_query_customer_name(p_from_id NUMBER) Is
1349: --SELECT p2.query_param_id
1350: --FROM jtf_perz_query_param p1,
1351: -- jtf_perz_query_param p2
1352: --WHERE p1.query_param_id = p_from_id
1353: --AND p1.query_id = p2.query_id
1354: --AND p2.parameter_name = 'CUSTOMER_NAME';
1355:

Line 1363: --l_query_customer_name_id jtf_perz_query_param.query_param_id%TYPE;

1359: SELECT party_number
1360: FROM hz_parties
1361: WHERE party_id = p_to_fk_id;
1362:
1363: --l_query_customer_name_id jtf_perz_query_param.query_param_id%TYPE;
1364: l_customer_new_number hz_parties.party_number%TYPE;
1365:
1366: BEGIN
1367:

Line 1417: UPDATE jtf_perz_query_param

1413: (l_customer_new_number is not NULL)
1414: --and (l_query_customer_name_id is not NULL)
1415: then
1416:
1417: UPDATE jtf_perz_query_param
1418: -- Fix bug 3738509
1419: SET parameter_value = l_customer_new_number,
1420: last_update_date = hz_utility_pub.last_update_date,
1421: last_updated_by = hz_utility_pub.user_id,

Line 1425: FROM jtf_perz_query_param param

1421: last_updated_by = hz_utility_pub.user_id,
1422: last_update_login = hz_utility_pub.last_update_login
1423: WHERE --query_param_id = l_query_customer_name_id
1424: query_param_id IN (SELECT param.query_param_id
1425: FROM jtf_perz_query_param param
1426: , (SELECT q.query_id
1427: FROM jtf_perz_query q
1428: , jtf_perz_query_param p
1429: WHERE q.query_type = 'JTF_TASK'

Line 1428: , jtf_perz_query_param p

1424: query_param_id IN (SELECT param.query_param_id
1425: FROM jtf_perz_query_param param
1426: , (SELECT q.query_id
1427: FROM jtf_perz_query q
1428: , jtf_perz_query_param p
1429: WHERE q.query_type = 'JTF_TASK'
1430: AND q.application_id = 690
1431: AND p.query_id = q.query_id
1432: AND p.parameter_name = 'CUSTOMER'

Line 1437: FROM jtf_perz_query_param pm

1433: AND p.parameter_value = 'NUMBER') query
1434: WHERE param.query_id = query.query_id
1435: AND param.parameter_name = 'CUSTOMER_NAME'
1436: AND EXISTS (SELECT 1
1437: FROM jtf_perz_query_param pm
1438: WHERE pm.query_id = param.query_id
1439: AND pm.parameter_name = 'CUSTOMER_ID'
1440: AND pm.parameter_value = to_char(p_from_fk_id))
1441: );

Line 1445: UPDATE jtf_perz_query_param p

1441: );
1442:
1443: end if;
1444:
1445: UPDATE jtf_perz_query_param p
1446: SET parameter_value = to_char(p_to_fk_id),
1447: last_update_date = hz_utility_pub.last_update_date,
1448: last_updated_by = hz_utility_pub.user_id,
1449: last_update_login = hz_utility_pub.last_update_login

Line 1452: FROM jtf_perz_query_param param

1448: last_updated_by = hz_utility_pub.user_id,
1449: last_update_login = hz_utility_pub.last_update_login
1450: WHERE --query_param_id = p_from_id
1451: query_param_id IN (SELECT param.query_param_id
1452: FROM jtf_perz_query_param param
1453: , (SELECT q.query_id
1454: FROM jtf_perz_query q
1455: , jtf_perz_query_param p
1456: WHERE q.query_type = 'JTF_TASK'

Line 1455: , jtf_perz_query_param p

1451: query_param_id IN (SELECT param.query_param_id
1452: FROM jtf_perz_query_param param
1453: , (SELECT q.query_id
1454: FROM jtf_perz_query q
1455: , jtf_perz_query_param p
1456: WHERE q.query_type = 'JTF_TASK'
1457: AND q.application_id = 690
1458: AND p.query_id = q.query_id
1459: AND p.parameter_name = 'CUSTOMER'

Line 1481: -- Procedure: SEARCH_MERGE_NAME_PARTY_ID - Performs party ids merge in JTF_PERZ_QUERY_PARAM table for Customer Name saved searches.

1477: END SEARCH_MERGE_NUMBER_PARTY_ID;
1478:
1479:
1480: ------------------------------------------------------------------------------------------
1481: -- Procedure: SEARCH_MERGE_NAME_PARTY_ID - Performs party ids merge in JTF_PERZ_QUERY_PARAM table for Customer Name saved searches.
1482: -- Columns: Updates PARAMETER_VALUE where PARAMETER_NAME='CUSTOMER_ID'
1483: -- Parameters: p_from_id = jtf_perz_query_param.query_param_id
1484: ------------------------------------------------------------------------------------------
1485:

Line 1483: -- Parameters: p_from_id = jtf_perz_query_param.query_param_id

1479:
1480: ------------------------------------------------------------------------------------------
1481: -- Procedure: SEARCH_MERGE_NAME_PARTY_ID - Performs party ids merge in JTF_PERZ_QUERY_PARAM table for Customer Name saved searches.
1482: -- Columns: Updates PARAMETER_VALUE where PARAMETER_NAME='CUSTOMER_ID'
1483: -- Parameters: p_from_id = jtf_perz_query_param.query_param_id
1484: ------------------------------------------------------------------------------------------
1485:
1486: PROCEDURE SEARCH_MERGE_NAME_PARTY_ID(
1487: p_entity_name IN VARCHAR2,

Line 1510: --FROM jtf_perz_query_param p1,

1506: -- get CUSTOMER_NAME's query_param_id
1507:
1508: --cursor get_query_customer_name(p_from_id NUMBER) Is
1509: --SELECT p2.query_param_id
1510: --FROM jtf_perz_query_param p1,
1511: -- jtf_perz_query_param p2
1512: --WHERE p1.query_param_id = p_from_id
1513: --AND p1.query_id = p2.query_id
1514: --AND p2.parameter_name = 'CUSTOMER_NAME';

Line 1511: -- jtf_perz_query_param p2

1507:
1508: --cursor get_query_customer_name(p_from_id NUMBER) Is
1509: --SELECT p2.query_param_id
1510: --FROM jtf_perz_query_param p1,
1511: -- jtf_perz_query_param p2
1512: --WHERE p1.query_param_id = p_from_id
1513: --AND p1.query_id = p2.query_id
1514: --AND p2.parameter_name = 'CUSTOMER_NAME';
1515:

Line 1523: --l_query_customer_name_id jtf_perz_query_param.query_param_id%TYPE;

1519: SELECT party_name
1520: FROM hz_parties
1521: WHERE party_id = p_to_fk_id;
1522:
1523: --l_query_customer_name_id jtf_perz_query_param.query_param_id%TYPE;
1524: l_customer_new_name hz_parties.party_name%TYPE;
1525:
1526: BEGIN
1527:

Line 1571: -- UPDATE jtf_perz_query_param

1567: open get_new_customer_name(p_to_fk_id);
1568: fetch get_new_customer_name into l_customer_new_name;
1569: close get_new_customer_name;
1570:
1571: -- UPDATE jtf_perz_query_param
1572: -- SET parameter_value = to_char(p_to_fk_id),
1573: -- last_update_date = hz_utility_pub.last_update_date,
1574: -- last_updated_by = hz_utility_pub.user_id,
1575: -- last_update_login = hz_utility_pub.last_update_login

Line 1586: -- UPDATE jtf_perz_query_param

1582: (l_customer_new_name is not NULL)
1583: -- and (l_query_customer_name_id is not NULL)
1584: then
1585:
1586: -- UPDATE jtf_perz_query_param
1587: -- SET parameter_value = l_customer_new_name,
1588: -- last_update_date = hz_utility_pub.last_update_date,
1589: -- last_updated_by = hz_utility_pub.user_id,
1590: -- last_update_login = hz_utility_pub.last_update_login

Line 1595: UPDATE jtf_perz_query_param

1591: -- WHERE query_param_id = l_query_customer_name_id;
1592:
1593: -- end if;
1594:
1595: UPDATE jtf_perz_query_param
1596: SET parameter_value = l_customer_new_name,
1597: last_update_date = hz_utility_pub.last_update_date,
1598: last_updated_by = hz_utility_pub.user_id,
1599: last_update_login = hz_utility_pub.last_update_login

Line 1602: FROM jtf_perz_query_param param

1598: last_updated_by = hz_utility_pub.user_id,
1599: last_update_login = hz_utility_pub.last_update_login
1600: WHERE --query_param_id = l_query_customer_name_id
1601: query_param_id IN (SELECT param.query_param_id
1602: FROM jtf_perz_query_param param
1603: , (SELECT q.query_id
1604: FROM jtf_perz_query q
1605: , jtf_perz_query_param p
1606: WHERE q.query_type = 'JTF_TASK'

Line 1605: , jtf_perz_query_param p

1601: query_param_id IN (SELECT param.query_param_id
1602: FROM jtf_perz_query_param param
1603: , (SELECT q.query_id
1604: FROM jtf_perz_query q
1605: , jtf_perz_query_param p
1606: WHERE q.query_type = 'JTF_TASK'
1607: AND q.application_id = 690
1608: AND p.query_id = q.query_id
1609: AND p.parameter_name = 'CUSTOMER'

Line 1614: FROM jtf_perz_query_param pm

1610: AND p.parameter_value = 'NAME') query
1611: WHERE param.query_id = query.query_id
1612: AND param.parameter_name = 'CUSTOMER_NAME'
1613: AND EXISTS (SELECT 1
1614: FROM jtf_perz_query_param pm
1615: WHERE pm.query_id = param.query_id
1616: AND pm.parameter_name = 'CUSTOMER_ID'
1617: AND pm.parameter_value = to_char(p_from_fk_id))
1618: );

Line 1622: UPDATE jtf_perz_query_param p

1618: );
1619:
1620: end if;
1621:
1622: UPDATE jtf_perz_query_param p
1623: SET parameter_value = to_char(p_to_fk_id),
1624: last_update_date = hz_utility_pub.last_update_date,
1625: last_updated_by = hz_utility_pub.user_id,
1626: last_update_login = hz_utility_pub.last_update_login

Line 1629: FROM jtf_perz_query_param param

1625: last_updated_by = hz_utility_pub.user_id,
1626: last_update_login = hz_utility_pub.last_update_login
1627: WHERE --query_param_id = p_from_id
1628: query_param_id IN (SELECT param.query_param_id
1629: FROM jtf_perz_query_param param
1630: , (SELECT q.query_id
1631: FROM jtf_perz_query q
1632: , jtf_perz_query_param p
1633: WHERE q.query_type = 'JTF_TASK'

Line 1632: , jtf_perz_query_param p

1628: query_param_id IN (SELECT param.query_param_id
1629: FROM jtf_perz_query_param param
1630: , (SELECT q.query_id
1631: FROM jtf_perz_query q
1632: , jtf_perz_query_param p
1633: WHERE q.query_type = 'JTF_TASK'
1634: AND q.application_id = 690
1635: AND p.query_id = q.query_id
1636: AND p.parameter_name = 'CUSTOMER'