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 1424: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',

1420: l_idx_mem := '0';
1421: END;
1422: END;
1423: END IF;
1424: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1425: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1426: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1427: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1428: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

1661: l_sub_requests(i) := 1;
1662: END LOOP;
1663: log('Spawning ' || l_num_workers || ' Workers for staging');
1664: FOR I in 1..l_num_workers LOOP
1665: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',
1666: 'Stage Party Data Worker ' || to_char(i),
1667: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1668: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1669: IF l_sub_requests(i) = 0 THEN

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

1684: l_index := 'HZ_PARTIES';
1685: ELSE
1686: l_index := 'HZ_PARTIES_BTREE';
1687: END IF;
1688: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1689: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1690: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1691: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1692: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

1708: ELSE
1709: l_index := 'HZ_PARTY_SITES_BTREE';
1710: END IF;
1711:
1712: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1713: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1714: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1715: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1716: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

1731: l_index := 'HZ_ORG_CONTACTS';
1732: ELSE
1733: l_index := 'HZ_ORG_CONTACTS_BTREE';
1734: END IF;
1735: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1736: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1737: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1738: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1739: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

1754: l_index := 'HZ_CONTACT_POINTS';
1755: ELSE
1756: l_index := 'HZ_CONTACT_POINTS_BTREE';
1757: END IF;
1758: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1759: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1760: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1761: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1762: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

1826: log('Spawning ' || l_num_workers || ' Workers for staging');
1827:
1828: -- Dispatch the Stage Data Worker
1829: FOR I in 1..l_num_workers LOOP
1830: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',
1831: 'Stage Party Data Worker ' || to_char(i),
1832: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1833: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1834: IF l_sub_requests(i) = 0 THEN

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

1921:
1922:
1923: log('Spawning ' || l_num_workers || ' Workers for staging');
1924: FOR I in 1..l_num_workers LOOP
1925: l_sub_requests(i) := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMSTW',
1926: 'Stage Party Data Worker ' || to_char(i),
1927: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1928: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1929: IF l_sub_requests(i) = 0 THEN

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

1939: l_req_id := l_sub_requests(1);
1940:
1941: IF l_req_id>0 THEN
1942: l_index := 'HZ_PARTIES';
1943: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
1944: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1945: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
1946: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
1947: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

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

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

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

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

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

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

2038: END LOOP;
2039:
2040: l_req_id := 1;
2041: IF l_req_id<>0 THEN
2042: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2043: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2044: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2045: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2046: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

2060: IF l_index_creation = 'SERIAL' THEN
2061: l_sub_requests(1) := l_req_id;
2062: END IF;
2063:
2064: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2065: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2066: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2067: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2068: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

2082: IF l_index_creation = 'SERIAL' THEN
2083: l_sub_requests(1) := l_req_id;
2084: END IF;
2085:
2086: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2087: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2088: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2089: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2090: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

2104: IF l_index_creation = 'SERIAL' THEN
2105: l_sub_requests(1) := l_req_id;
2106: END IF;
2107:
2108: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2109: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2110: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2111: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2112: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

2160: WHEN OTHERS THEN
2161: log('Error dropping hz_stage_parties_t1 ' || SQLERRM);
2162: END;
2163:
2164: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2165: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2166: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2167: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2168: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

2200: IF l_index_creation = 'SERIAL' THEN
2201: l_sub_requests(1):=l_req_id;
2202: END IF;
2203:
2204: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2205: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2206: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2207: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2208: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

2240: IF l_index_creation = 'SERIAL' THEN
2241: l_sub_requests(1):=l_req_id;
2242: END IF;
2243:
2244: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2245: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2246: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2247: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2248: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

2280: IF l_index_creation = 'SERIAL' THEN
2281: l_sub_requests(1):=l_req_id;
2282: END IF;
2283:
2284: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2285: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2286: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2287: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2288: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

2303: l_sub_requests(i) := 1;
2304: END LOOP;
2305:
2306: l_index := 'HZ_PARTIES_BTREE';
2307: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHDQMCR',
2308: 'DQM Create Index', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
2309: TRUE, to_char(l_sub_requests(1)), to_char(l_sub_requests(2)),
2310: to_char(l_sub_requests(3)), to_char(l_sub_requests(4)),
2311: to_char(l_sub_requests(5)), to_char(l_sub_requests(6)),

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

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

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

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

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

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

Line 2419: l_req_id := FND_REQUEST.SUBMIT_REQUEST(

2415: l_realtime_sync_value := 'Y';
2416: OPEN c_sync;
2417: FETCH c_sync INTO l_sync_count;
2418: IF(c_sync%FOUND) THEN
2419: l_req_id := FND_REQUEST.SUBMIT_REQUEST(
2420: application => 'AR', /**** Application Name ****/
2421: program => 'ARHDQSYN', /*** Program Name ***/
2422: sub_request => FALSE, /*** Sub Request ***/
2423: argument1 => NULL, /* p_num_of_workers */