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.MRP_MANAGER_PK dependencies on MRP_PRINT_PK

Line 18: var_watch_id := mrp_print_pk.start_watch(

14: SELECT mrp_form_query_s.nextval
15: INTO var_batch_id
16: FROM dual;
17:
18: var_watch_id := mrp_print_pk.start_watch(
19: 'GEN-inserting',
20: arg_request_id,
21: arg_user_id,
22: 'ENTITY',

Line 129: mrp_print_pk.stop_watch(arg_request_id,

125: AND upd3.request_id IS NOT NULL
126: AND upd3.error_message IS NULL
127: AND upd3.process_status = 3;
128:
129: mrp_print_pk.stop_watch(arg_request_id,
130: var_watch_id,
131: SQL%ROWCOUNT);
132:
133: var_watch_id := mrp_print_pk.start_watch(

Line 133: var_watch_id := mrp_print_pk.start_watch(

129: mrp_print_pk.stop_watch(arg_request_id,
130: var_watch_id,
131: SQL%ROWCOUNT);
132:
133: var_watch_id := mrp_print_pk.start_watch(
134: 'GEN-inserting',
135: arg_request_id,
136: arg_user_id,
137: 'ENTITY',

Line 182: mrp_print_pk.stop_watch(arg_request_id,

178: AND comp_item.organization_id = query.number2
179: AND comp_item.inventory_item_id = query.number1
180: AND query.query_id = var_batch_id;
181:
182: mrp_print_pk.stop_watch(arg_request_id,
183: var_watch_id,
184: SQL%ROWCOUNT);
185:
186: arg_in_process_id := var_batch_id;

Line 202: var_watch_id := mrp_print_pk.start_watch(

198: SELECT mrp_form_query_s.nextval
199: INTO var_batch_id
200: FROM dual;
201:
202: var_watch_id := mrp_print_pk.start_watch(
203: 'GEN-inserting',
204: arg_request_id,
205: arg_user_id,
206: 'ENTITY',

Line 328: mrp_print_pk.stop_watch(arg_request_id,

324: AND upd3.request_id IS NOT NULL
325: AND upd3.error_message IS NULL
326: AND upd3.process_status = 3;
327:
328: mrp_print_pk.stop_watch(arg_request_id,
329: var_watch_id,
330: SQL%ROWCOUNT);
331:
332: var_watch_id := mrp_print_pk.start_watch(

Line 332: var_watch_id := mrp_print_pk.start_watch(

328: mrp_print_pk.stop_watch(arg_request_id,
329: var_watch_id,
330: SQL%ROWCOUNT);
331:
332: var_watch_id := mrp_print_pk.start_watch(
333: 'GEN-inserting',
334: arg_request_id,
335: arg_user_id,
336: 'ENTITY',

Line 397: mrp_print_pk.stop_watch(arg_request_id,

393: AND comp_item.organization_id = query.number2
394: AND comp_item.inventory_item_id = query.number1
395: AND query.query_id = var_batch_id;
396:
397: mrp_print_pk.stop_watch(arg_request_id,
398: var_watch_id,
399: SQL%ROWCOUNT);
400:
401: var_watch_id := mrp_print_pk.start_watch(

Line 401: var_watch_id := mrp_print_pk.start_watch(

397: mrp_print_pk.stop_watch(arg_request_id,
398: var_watch_id,
399: SQL%ROWCOUNT);
400:
401: var_watch_id := mrp_print_pk.start_watch(
402: 'GEN-inserting',
403: arg_request_id,
404: arg_user_id,
405: 'ENTITY',

Line 464: mrp_print_pk.stop_watch(arg_request_id,

460: FROM mrp_form_query
461: WHERE query_id = var_batch_id
462: AND number1 = upd2.inventory_item_id);
463:
464: mrp_print_pk.stop_watch(arg_request_id,
465: var_watch_id,
466: SQL%ROWCOUNT);
467:
468:

Line 876: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

872:
873: LOOP
874: rows_updated := 0;
875:
876: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
877: arg_request_id,
878: arg_user_id,
879: 'ENTITY',
880: 'mtl_demand(1)',

Line 916: mrp_print_pk.stop_watch(arg_request_id,

912: END LOOP;
913:
914: CLOSE mtl_demand_cur1;
915:
916: mrp_print_pk.stop_watch(arg_request_id,
917: var_watch_id,
918: rows_updated);
919:
920: COMMIT;

Line 943: mrp_print_pk.mrprint('First time : '|| var_first_time,

939: var_first_time :=nvl(FND_PROFILE.VALUE('MRP_PLNG_MGR_FIRST_TIME'),'Y');
940:
941: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
942: /*
943: mrp_print_pk.mrprint('First time : '|| var_first_time,
944: arg_request_id, arg_user_id);
945:
946: */
947:

Line 955: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

951:
952: IF (var_first_time = 'N') Then
953:
954: /*
955: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
956: arg_request_id,
957: arg_user_id,
958: 'ENTITY',
959: 'mrp_so_lines_temp',

Line 1005: mrp_print_pk.stop_watch(arg_request_id,

1001: CLOSE so_lines_temp;
1002:
1003: line_id_arr.DELETE;
1004: /*
1005: mrp_print_pk.stop_watch(arg_request_id,
1006: var_watch_id,
1007: rows_updated);
1008: */
1009:

Line 1038: var_watch_id := mrp_print_pk.start_watch('GEN-LOCK TABLE',

1034: -- run for the first time.
1035:
1036:
1037: /*
1038: var_watch_id := mrp_print_pk.start_watch('GEN-LOCK TABLE',
1039: arg_request_id,
1040: arg_user_id,
1041: 'TABLE',
1042: 'mrp_sales_order_updates',

Line 1054: mrp_print_pk.stop_watch(arg_request_id,

1050: LOCK TABLE mrp_sales_order_updates IN SHARE ROW EXCLUSIVE MODE;
1051:
1052:
1053: /*
1054: mrp_print_pk.stop_watch(arg_request_id,
1055: var_watch_id,
1056: rows_updated);
1057: */
1058:

Line 1063: var_watch_id := mrp_print_pk.start_watch('GEN-SELECTING',

1059: END IF;
1060:
1061:
1062: /*
1063: var_watch_id := mrp_print_pk.start_watch('GEN-SELECTING',
1064: arg_request_id,
1065: arg_user_id,
1066: 'ENTITY',
1067: 'mrp_sales_order_updates',

Line 1609: mrp_print_pk.stop_watch(arg_request_id,

1605:
1606:
1607: /*
1608:
1609: mrp_print_pk.stop_watch(arg_request_id,
1610: var_watch_id,
1611: counter);
1612:
1613: IF var_debug THEN

Line 1615: mrp_print_pk.mrprint('Rows to update : '|| to_char(to_update),

1611: counter);
1612:
1613: IF var_debug THEN
1614:
1615: mrp_print_pk.mrprint('Rows to update : '|| to_char(to_update),
1616: arg_request_id, arg_user_id);
1617:
1618:
1619: var_watch_id := mrp_print_pk.start_watch('GEN-INSERTED ROWS',

Line 1619: var_watch_id := mrp_print_pk.start_watch('GEN-INSERTED ROWS',

1615: mrp_print_pk.mrprint('Rows to update : '|| to_char(to_update),
1616: arg_request_id, arg_user_id);
1617:
1618:
1619: var_watch_id := mrp_print_pk.start_watch('GEN-INSERTED ROWS',
1620: arg_request_id,
1621: arg_user_id,
1622: 'NUMBER',
1623: to_char(insert_count),

Line 1629: mrp_print_pk.stop_watch(arg_request_id,

1625: 'TABLE',
1626: 'mrp_sales_order_updates',
1627: 'N');
1628:
1629: mrp_print_pk.stop_watch(arg_request_id,
1630: var_watch_id);
1631:
1632: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1633: arg_request_id,

Line 1632: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

1628:
1629: mrp_print_pk.stop_watch(arg_request_id,
1630: var_watch_id);
1631:
1632: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1633: arg_request_id,
1634: arg_user_id,
1635: 'ENTITY',
1636: 'mrp_sales_order_updates',

Line 1639: mrp_print_pk.stop_watch(arg_request_id,

1635: 'ENTITY',
1636: 'mrp_sales_order_updates',
1637: 'N');
1638:
1639: mrp_print_pk.stop_watch(arg_request_id,
1640: var_watch_id,
1641: update_count);
1642:
1643: END IF;

Line 1681: mrp_print_pk.mrprint('Processing Calendar: '|| var_cal_code,

1677:
1678: /*
1679: IF var_debug THEN
1680:
1681: mrp_print_pk.mrprint('Processing Calendar: '|| var_cal_code,
1682: arg_request_id, arg_user_id);
1683: mrp_print_pk.mrprint('Min Date : '||
1684: to_char(var_min_cal_date,'DD-MON-RR'),
1685: arg_request_id, arg_user_id);

Line 1683: mrp_print_pk.mrprint('Min Date : '||

1679: IF var_debug THEN
1680:
1681: mrp_print_pk.mrprint('Processing Calendar: '|| var_cal_code,
1682: arg_request_id, arg_user_id);
1683: mrp_print_pk.mrprint('Min Date : '||
1684: to_char(var_min_cal_date,'DD-MON-RR'),
1685: arg_request_id, arg_user_id);
1686: mrp_print_pk.mrprint('Max Date : '||
1687: to_char(var_max_cal_date,'DD-MON-RR'),

Line 1686: mrp_print_pk.mrprint('Max Date : '||

1682: arg_request_id, arg_user_id);
1683: mrp_print_pk.mrprint('Min Date : '||
1684: to_char(var_min_cal_date,'DD-MON-RR'),
1685: arg_request_id, arg_user_id);
1686: mrp_print_pk.mrprint('Max Date : '||
1687: to_char(var_max_cal_date,'DD-MON-RR'),
1688: arg_request_id, arg_user_id);
1689:
1690: END IF;

Line 1715: var_watch_id := mrp_print_pk.start_watch('GEN-INSERTED ROWS',

1711: /*
1712: IF var_debug THEN
1713:
1714: insert_count := sql%rowcount;
1715: var_watch_id := mrp_print_pk.start_watch('GEN-INSERTED ROWS',
1716: arg_request_id,
1717: arg_user_id,
1718: 'NUMBER',
1719: to_char(insert_count),

Line 1725: mrp_print_pk.stop_watch(arg_request_id,

1721: 'TABLE',
1722: 'msc_form_query',
1723: 'N');
1724:
1725: mrp_print_pk.stop_watch(arg_request_id,
1726: var_watch_id);
1727:
1728: END IF;
1729: */

Line 1737: mrp_print_pk.mrprint('Processed '|| to_char(calendar%rowcount)

1733: /*
1734: IF var_debug THEN
1735:
1736:
1737: mrp_print_pk.mrprint('Processed '|| to_char(calendar%rowcount)
1738: ||' orgs',
1739: arg_request_id, arg_user_id);
1740:
1741: END IF;

Line 1752: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

1748: /*
1749: IF var_debug THEN
1750:
1751:
1752: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1753: arg_request_id,
1754: arg_user_id,
1755: 'ENTITY',
1756: 'mrp_sales_order_updates',

Line 1773: mrp_print_pk.stop_watch(arg_request_id,

1769: /*
1770: IF var_debug THEN
1771:
1772:
1773: mrp_print_pk.stop_watch(arg_request_id,
1774: var_watch_id,
1775: SQL%ROWCOUNT);
1776:
1777: END IF;

Line 1887: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

1883: end if;
1884:
1885: IF g_om_installed = 'OE' THEN
1886:
1887: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1888: arg_request_id,
1889: arg_user_id,
1890: 'ENTITY',
1891: 'mtl_demand',

Line 1922: mrp_print_pk.stop_watch(arg_request_id,

1918: END LOOP;
1919:
1920: CLOSE lock_mtl_demand_cur;
1921:
1922: mrp_print_pk.stop_watch(arg_request_id,
1923: var_watch_id,
1924: rows_updated);
1925:
1926: END IF;*/

Line 1928: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

1924: rows_updated);
1925:
1926: END IF;*/
1927:
1928: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1929: arg_request_id,
1930: arg_user_id,
1931: 'ENTITY',
1932: 'mrp_sales_order_updates',

Line 1948: mrp_print_pk.stop_watch(arg_request_id,

1944: WHERE request_id = arg_request_id
1945: AND process_status = 3
1946: AND error_message IS NULL;
1947:
1948: mrp_print_pk.stop_watch(arg_request_id,
1949: var_watch_id,
1950: SQL%ROWCOUNT);
1951:
1952: END update_sales_orders;

Line 1961: var_watch_id := mrp_print_pk.start_watch(

1957: arg_user_id IN NUMBER,
1958: arg_desig IN VARCHAR2) IS
1959: BEGIN
1960:
1961: var_watch_id := mrp_print_pk.start_watch(
1962: 'GEN-inserting',
1963: arg_request_id,
1964: arg_user_id,
1965: 'ENTITY',

Line 2000: mrp_print_pk.stop_watch(arg_request_id,

1996: WHERE items.organization_id = dates.organization_id
1997: AND items.forecast_designator = dates.forecast_designator
1998: AND items.inventory_item_id = dates.inventory_item_id);
1999:
2000: mrp_print_pk.stop_watch(arg_request_id,
2001: var_watch_id,
2002: SQL%ROWCOUNT);
2003:
2004: END create_forecast_items;