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.HZ_PARTY_STAGE dependencies on FND_REQUEST

Line 1436: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1432: l_idx_mem := '0';
1433: END;
1434: END;
1435: END IF;
1436: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1437: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1438: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1439: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1440: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 1677: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',

1673: l_sub_requests(i) := 1;
1674: END LOOP;
1675: log('Spawning ' || l_num_workers || ' Workers for staging');
1676: FOR I in 1..l_num_workers LOOP
1677: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',
1678: 'Stage Party Data Worker ' || to_char(i),
1679: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1680: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1681: IF l_sub_requests(i) = 0 THEN

Line 1700: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1696: l_index := 'HZ_PARTIES';
1697: ELSE
1698: l_index := 'HZ_PARTIES_BTREE';
1699: END IF;
1700: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1701: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1702: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1703: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1704: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 1724: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1720: ELSE
1721: l_index := 'HZ_PARTY_SITES_BTREE';
1722: END IF;
1723:
1724: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1725: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1726: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1727: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1728: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 1747: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1743: l_index := 'HZ_ORG_CONTACTS';
1744: ELSE
1745: l_index := 'HZ_ORG_CONTACTS_BTREE';
1746: END IF;
1747: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1748: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1749: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1750: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1751: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 1770: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1766: l_index := 'HZ_CONTACT_POINTS';
1767: ELSE
1768: l_index := 'HZ_CONTACT_POINTS_BTREE';
1769: END IF;
1770: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1771: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1772: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1773: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1774: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 1842: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',

1838: log('Spawning ' || l_num_workers || ' Workers for staging');
1839:
1840: -- Dispatch the Stage Data Worker
1841: FOR I in 1..l_num_workers LOOP
1842: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',
1843: 'Stage Party Data Worker ' || to_char(i),
1844: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1845: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1846: IF l_sub_requests(i) = 0 THEN

Line 1941: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',

1937:
1938:
1939: log('Spawning ' || l_num_workers || ' Workers for staging');
1940: FOR I in 1..l_num_workers LOOP
1941: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',
1942: 'Stage Party Data Worker ' || to_char(i),
1943: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1944: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1945: IF l_sub_requests(i) = 0 THEN

Line 1959: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1955: l_req_id := l_sub_requests(1);
1956:
1957: IF l_req_id>0 THEN
1958: l_index := 'HZ_PARTIES';
1959: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1960: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1961: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1962: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1963: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 1978: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1974: END IF;
1975:
1976: IF l_req_id>0 THEN
1977: l_index := 'HZ_PARTY_SITES';
1978: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1979: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1980: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1981: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1982: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 1997: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1993: END IF;
1994:
1995: IF l_req_id>0 THEN
1996: l_index := 'HZ_ORG_CONTACTS';
1997: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1998: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1999: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2000: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2001: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2016: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2012: END IF;
2013:
2014: IF l_req_id>0 THEN
2015: l_index := 'HZ_CONTACT_POINTS';
2016: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2017: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2018: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2019: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2020: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2058: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2054: END LOOP;
2055:
2056: l_req_id := 1;
2057: IF l_req_id<>0 THEN
2058: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2059: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2060: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2061: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2062: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2080: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2076: IF l_index_creation = 'SERIAL' THEN
2077: l_sub_requests(1) := l_req_id;
2078: END IF;
2079:
2080: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2081: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2082: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2083: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2084: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2102: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2098: IF l_index_creation = 'SERIAL' THEN
2099: l_sub_requests(1) := l_req_id;
2100: END IF;
2101:
2102: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2103: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2104: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2105: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2106: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2124: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2120: IF l_index_creation = 'SERIAL' THEN
2121: l_sub_requests(1) := l_req_id;
2122: END IF;
2123:
2124: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2125: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2126: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2127: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2128: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2180: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2176: WHEN OTHERS THEN
2177: log('Error dropping hz_stage_parties_t1 ' || SQLERRM);
2178: END;
2179:
2180: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2181: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2182: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2183: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2184: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2220: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2216: IF l_index_creation = 'SERIAL' THEN
2217: l_sub_requests(1):=l_req_id;
2218: END IF;
2219:
2220: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2221: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2222: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2223: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2224: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2260: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2256: IF l_index_creation = 'SERIAL' THEN
2257: l_sub_requests(1):=l_req_id;
2258: END IF;
2259:
2260: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2261: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2262: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2263: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2264: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2300: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2296: IF l_index_creation = 'SERIAL' THEN
2297: l_sub_requests(1):=l_req_id;
2298: END IF;
2299:
2300: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2301: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2302: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2303: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2304: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2323: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2319: l_sub_requests(i) := 1;
2320: END LOOP;
2321:
2322: l_index := 'HZ_PARTIES_BTREE';
2323: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2324: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2325: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2326: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2327: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2341: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2337: END IF;
2338:
2339: l_index := 'HZ_PARTY_SITES_BTREE';
2340:
2341: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2342: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2343: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2344: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2345: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2359: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2355: END IF;
2356:
2357: l_index := 'HZ_ORG_CONTACTS_BTREE';
2358:
2359: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2360: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2361: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2362: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2363: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2377: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

2373: END IF;
2374:
2375: l_index := 'HZ_CONTACT_POINTS_BTREE';
2376:
2377: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2378: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2379: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2380: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2381: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

Line 2437: l_req_id := FND_REQUEST.SUBMIT_REQUEST(

2433: l_realtime_sync_value := 'Y';
2434: OPEN c_sync;
2435: FETCH c_sync INTO l_sync_count;
2436: IF(c_sync%FOUND) THEN
2437: l_req_id := FND_REQUEST.SUBMIT_REQUEST(
2438: application => 'AR', /**** Application Name ****/
2439: program => 'ARHDQSYN', /*** Program Name ***/
2440: sub_request => FALSE, /*** Sub Request ***/
2441: argument1 => NULL, /* p_num_of_workers */