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 872: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

868:
869: LOOP
870: rows_updated := 0;
871: /*
872: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
873: arg_request_id,
874: arg_user_id,
875: 'ENTITY',
876: 'mtl_demand(1)',

Line 912: mrp_print_pk.stop_watch(arg_request_id,

908: END LOOP;
909:
910: CLOSE mtl_demand_cur1;
911: /*
912: mrp_print_pk.stop_watch(arg_request_id,
913: var_watch_id,
914: rows_updated);
915: */
916: COMMIT;

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

935: var_first_time :=nvl(FND_PROFILE.VALUE('MRP_PLNG_MGR_FIRST_TIME'),'Y');
936:
937: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
938: /*
939: mrp_print_pk.mrprint('First time : '|| var_first_time,
940: arg_request_id, arg_user_id);
941:
942: */
943:

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

947:
948: IF (var_first_time = 'N') Then
949:
950: /*
951: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
952: arg_request_id,
953: arg_user_id,
954: 'ENTITY',
955: 'mrp_so_lines_temp',

Line 1001: mrp_print_pk.stop_watch(arg_request_id,

997: CLOSE so_lines_temp;
998:
999: line_id_arr.DELETE;
1000: /*
1001: mrp_print_pk.stop_watch(arg_request_id,
1002: var_watch_id,
1003: rows_updated);
1004: */
1005:

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

1030: -- run for the first time.
1031:
1032:
1033: /*
1034: var_watch_id := mrp_print_pk.start_watch('GEN-LOCK TABLE',
1035: arg_request_id,
1036: arg_user_id,
1037: 'TABLE',
1038: 'mrp_sales_order_updates',

Line 1050: mrp_print_pk.stop_watch(arg_request_id,

1046: LOCK TABLE mrp_sales_order_updates IN SHARE ROW EXCLUSIVE MODE;
1047:
1048:
1049: /*
1050: mrp_print_pk.stop_watch(arg_request_id,
1051: var_watch_id,
1052: rows_updated);
1053: */
1054:

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

1055: END IF;
1056:
1057:
1058: /*
1059: var_watch_id := mrp_print_pk.start_watch('GEN-SELECTING',
1060: arg_request_id,
1061: arg_user_id,
1062: 'ENTITY',
1063: 'mrp_sales_order_updates',

Line 1604: mrp_print_pk.stop_watch(arg_request_id,

1600:
1601:
1602: /*
1603:
1604: mrp_print_pk.stop_watch(arg_request_id,
1605: var_watch_id,
1606: counter);
1607:
1608: IF var_debug THEN

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

1606: counter);
1607:
1608: IF var_debug THEN
1609:
1610: mrp_print_pk.mrprint('Rows to update : '|| to_char(to_update),
1611: arg_request_id, arg_user_id);
1612:
1613:
1614: var_watch_id := mrp_print_pk.start_watch('GEN-INSERTED ROWS',

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

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

Line 1624: mrp_print_pk.stop_watch(arg_request_id,

1620: 'TABLE',
1621: 'mrp_sales_order_updates',
1622: 'N');
1623:
1624: mrp_print_pk.stop_watch(arg_request_id,
1625: var_watch_id);
1626:
1627: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1628: arg_request_id,

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

1623:
1624: mrp_print_pk.stop_watch(arg_request_id,
1625: var_watch_id);
1626:
1627: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1628: arg_request_id,
1629: arg_user_id,
1630: 'ENTITY',
1631: 'mrp_sales_order_updates',

Line 1634: mrp_print_pk.stop_watch(arg_request_id,

1630: 'ENTITY',
1631: 'mrp_sales_order_updates',
1632: 'N');
1633:
1634: mrp_print_pk.stop_watch(arg_request_id,
1635: var_watch_id,
1636: update_count);
1637:
1638: END IF;

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

1672:
1673: /*
1674: IF var_debug THEN
1675:
1676: mrp_print_pk.mrprint('Processing Calendar: '|| var_cal_code,
1677: arg_request_id, arg_user_id);
1678: mrp_print_pk.mrprint('Min Date : '||
1679: to_char(var_min_cal_date,'DD-MON-RR'),
1680: arg_request_id, arg_user_id);

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

1674: IF var_debug THEN
1675:
1676: mrp_print_pk.mrprint('Processing Calendar: '|| var_cal_code,
1677: arg_request_id, arg_user_id);
1678: mrp_print_pk.mrprint('Min Date : '||
1679: to_char(var_min_cal_date,'DD-MON-RR'),
1680: arg_request_id, arg_user_id);
1681: mrp_print_pk.mrprint('Max Date : '||
1682: to_char(var_max_cal_date,'DD-MON-RR'),

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

1677: arg_request_id, arg_user_id);
1678: mrp_print_pk.mrprint('Min Date : '||
1679: to_char(var_min_cal_date,'DD-MON-RR'),
1680: arg_request_id, arg_user_id);
1681: mrp_print_pk.mrprint('Max Date : '||
1682: to_char(var_max_cal_date,'DD-MON-RR'),
1683: arg_request_id, arg_user_id);
1684:
1685: END IF;

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

1706: /*
1707: IF var_debug THEN
1708:
1709: insert_count := sql%rowcount;
1710: var_watch_id := mrp_print_pk.start_watch('GEN-INSERTED ROWS',
1711: arg_request_id,
1712: arg_user_id,
1713: 'NUMBER',
1714: to_char(insert_count),

Line 1720: mrp_print_pk.stop_watch(arg_request_id,

1716: 'TABLE',
1717: 'msc_form_query',
1718: 'N');
1719:
1720: mrp_print_pk.stop_watch(arg_request_id,
1721: var_watch_id);
1722:
1723: END IF;
1724: */

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

1728: /*
1729: IF var_debug THEN
1730:
1731:
1732: mrp_print_pk.mrprint('Processed '|| to_char(calendar%rowcount)
1733: ||' orgs',
1734: arg_request_id, arg_user_id);
1735:
1736: END IF;

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

1743: /*
1744: IF var_debug THEN
1745:
1746:
1747: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1748: arg_request_id,
1749: arg_user_id,
1750: 'ENTITY',
1751: 'mrp_sales_order_updates',

Line 1768: mrp_print_pk.stop_watch(arg_request_id,

1764: /*
1765: IF var_debug THEN
1766:
1767:
1768: mrp_print_pk.stop_watch(arg_request_id,
1769: var_watch_id,
1770: SQL%ROWCOUNT);
1771:
1772: END IF;

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

1878: end if;
1879:
1880: IF g_om_installed = 'OE' THEN
1881:
1882: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1883: arg_request_id,
1884: arg_user_id,
1885: 'ENTITY',
1886: 'mtl_demand',

Line 1917: mrp_print_pk.stop_watch(arg_request_id,

1913: END LOOP;
1914:
1915: CLOSE lock_mtl_demand_cur;
1916:
1917: mrp_print_pk.stop_watch(arg_request_id,
1918: var_watch_id,
1919: rows_updated);
1920:
1921: END IF;

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

1919: rows_updated);
1920:
1921: END IF;
1922:
1923: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1924: arg_request_id,
1925: arg_user_id,
1926: 'ENTITY',
1927: 'mrp_sales_order_updates',

Line 1943: mrp_print_pk.stop_watch(arg_request_id,

1939: WHERE request_id = arg_request_id
1940: AND process_status = 3
1941: AND error_message IS NULL;
1942:
1943: mrp_print_pk.stop_watch(arg_request_id,
1944: var_watch_id,
1945: SQL%ROWCOUNT);
1946:
1947: END update_sales_orders;

Line 1956: var_watch_id := mrp_print_pk.start_watch(

1952: arg_user_id IN NUMBER,
1953: arg_desig IN VARCHAR2) IS
1954: BEGIN
1955:
1956: var_watch_id := mrp_print_pk.start_watch(
1957: 'GEN-inserting',
1958: arg_request_id,
1959: arg_user_id,
1960: 'ENTITY',

Line 1995: mrp_print_pk.stop_watch(arg_request_id,

1991: WHERE items.organization_id = dates.organization_id
1992: AND items.forecast_designator = dates.forecast_designator
1993: AND items.inventory_item_id = dates.inventory_item_id);
1994:
1995: mrp_print_pk.stop_watch(arg_request_id,
1996: var_watch_id,
1997: SQL%ROWCOUNT);
1998:
1999: END create_forecast_items;