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.JMF_SHIKYU_ADJUSTMENT_PROC dependencies on JMF_SHIKYU_ADJUSTMENTS

Line 27: --| from the JMF_SHIKYU_ADJUSTMENTS table since |

23: --| 28-MAY-2005 shu Created. |
24: --| 12-JUL-2005 vchu Fixed GSCC errors (File.Sql.46). |
25: --| Removed the init procedure. |
26: --| 22-JUL-2005 vchu The transaction_id column has been removed |
27: --| from the JMF_SHIKYU_ADJUSTMENTS table since |
28: --| it is redundant of the request_id column. |
29: --| All references to transaction_id have been |
30: --| replaced by request_id in this package. |
31: --| 03-OCT-2005 shu Added calls to JMF_SHIKYU_UTIL.debug_output. |

Line 113: FROM jmf_shikyu_adjustments --JMF_SUBCONTRACT_ORDERS

109: l_p_max_workers NUMBER;
110:
111: CURSOR c_negative_adj IS
112: SELECT DISTINCT adjustment_id
113: FROM jmf_shikyu_adjustments --JMF_SUBCONTRACT_ORDERS
114: WHERE request_id IS NULL
115: AND batch_id IS NULL
116: AND adjustment < 0
117: --AND group_id = NVL(p_group_id,group_id) --group_id is for future use

Line 122: FROM jmf_shikyu_adjustments --JMF_SUBCONTRACT_ORDERS

118: ORDER BY adjustment_id;
119:
120: CURSOR c_positive_adj IS
121: SELECT DISTINCT adjustment_id
122: FROM jmf_shikyu_adjustments --JMF_SUBCONTRACT_ORDERS
123: WHERE request_id IS NULL
124: AND batch_id IS NULL
125: AND adjustment > 0
126: --AND group_id = NVL(p_group_id,group_id) --group_id is for future use

Line 228: FROM jmf_shikyu_adjustments

224:
225: -- get the rows that need to be adjusted
226: SELECT COUNT(adjustment_id)
227: INTO l_adjust_rows
228: FROM jmf_shikyu_adjustments
229: WHERE request_id IS NULL
230: AND batch_id IS NULL
231: AND adjustment <> 0
232: --AND group_id = NVL(p_group_id,group_id) --group_id is for future use

Line 287: UPDATE jmf_shikyu_adjustments

283:
284: l_counter := 0;
285: l_cur_batch_max_adj_id := l_cons_adj_id_tbl(l_cur_cons_adj_id_index);
286:
287: UPDATE jmf_shikyu_adjustments
288: SET batch_id = l_batch_id,
289: last_update_date = sysdate,
290: last_updated_by = FND_GLOBAL.user_id,
291: last_update_login = FND_GLOBAL.login_id

Line 329: /*UPDATE jmf_shikyu_adjustments

325:
326:
327: IF l_return_status = fnd_api.g_ret_sts_success
328: THEN
329: /*UPDATE jmf_shikyu_adjustments
330: SET request_id = l_request_id,
331: last_update_date = sysdate,
332: last_updated_by = FND_GLOBAL.user_id,
333: last_update_login = FND_GLOBAL.login_id

Line 350: UPDATE jmf_shikyu_adjustments

346: ' ,l_request_id: ' || l_request_id
347: );
348: -- **** for debug information in readonly UT environment.--- end ****
349: ELSE
350: UPDATE jmf_shikyu_adjustments
351: SET batch_id = NULL,
352: last_update_date = sysdate,
353: last_updated_by = FND_GLOBAL.user_id,
354: last_update_login = FND_GLOBAL.login_id

Line 416: UPDATE jmf_shikyu_adjustments

412: THEN
413: l_counter := 0;
414: l_cur_batch_max_adj_id := l_cons_adj_id_tbl(l_cur_cons_adj_id_index);
415:
416: UPDATE jmf_shikyu_adjustments
417: SET batch_id = l_batch_id,
418: last_update_date = sysdate,
419: last_updated_by = FND_GLOBAL.user_id,
420: last_update_login = FND_GLOBAL.login_id

Line 458: /*UPDATE jmf_shikyu_adjustments

454: -- **** for debug information in readonly UT environment.--- end ****
455:
456: IF l_return_status = fnd_api.g_ret_sts_success
457: THEN
458: /*UPDATE jmf_shikyu_adjustments
459: SET request_id = l_request_id,
460: last_update_date = sysdate,
461: last_updated_by = FND_GLOBAL.user_id,
462: last_update_login = FND_GLOBAL.login_id

Line 478: UPDATE jmf_shikyu_adjustments

474: ' ,l_request_id: ' || l_request_id
475: );
476: -- **** for debug information in readonly UT environment.--- end ****
477: ELSE
478: UPDATE jmf_shikyu_adjustments
479: SET batch_id = NULL,
480: last_update_date = sysdate,
481: last_updated_by = FND_GLOBAL.user_id,
482: last_update_login = FND_GLOBAL.login_id

Line 516: ,p_message => 'Update jmf_shikyu_adjustments'

512: JMF_SHIKYU_RPT_UTIL.debug_output
513: (
514: p_output_to => 'FND_LOG.STRING'
515: ,p_api_name => G_MODULE_PREFIX || l_api_name
516: ,p_message => 'Update jmf_shikyu_adjustments'
517: );
518: JMF_SHIKYU_RPT_UTIL.debug_output
519: (
520: p_output_to => 'FND_LOG.STRING'

Line 542: UPDATE jmf_shikyu_adjustments

538: ' ,l_request_id: ' || l_request_id
539: );
540: -- **** for debug information in readonly UT environment.--- end ****
541:
542: UPDATE jmf_shikyu_adjustments
543: SET request_id = l_batch_request_id_tbl(l_cur_batch_id_index),
544: last_update_date = sysdate,
545: last_updated_by = FND_GLOBAL.user_id,
546: last_update_login = FND_GLOBAL.login_id

Line 550: UPDATE jmf_shikyu_adjustments

546: last_update_login = FND_GLOBAL.login_id
547: WHERE batch_id = l_cur_batch_id_index
548: AND request_id IS NULL
549: ;
550: UPDATE jmf_shikyu_adjustments
551: SET request_id = NULL,
552: batch_id = NULL,
553: last_update_date = sysdate,
554: last_updated_by = FND_GLOBAL.user_id,

Line 565: UPDATE jmf_shikyu_adjustments

561:
562: END LOOP; --end of loop c_negative_adj
563:
564: --20051013 add to update the batch_id that without request rows to be process again.
565: UPDATE jmf_shikyu_adjustments
566: SET batch_id = NULL,
567: last_update_date = sysdate,
568: last_updated_by = FND_GLOBAL.user_id,
569: last_update_login = FND_GLOBAL.login_id

Line 877: FROM jmf_shikyu_adjustments

873: ,subcontract_po_shipment_id
874: ,shikyu_component_id
875: ,adjustment
876: ,uom
877: FROM jmf_shikyu_adjustments
878: WHERE batch_id = p_batch_id
879: ORDER BY adjustment;
880:
881: l_adjustment_id jmf_shikyu_adjustments.adjustment_id%TYPE;

Line 881: l_adjustment_id jmf_shikyu_adjustments.adjustment_id%TYPE;

877: FROM jmf_shikyu_adjustments
878: WHERE batch_id = p_batch_id
879: ORDER BY adjustment;
880:
881: l_adjustment_id jmf_shikyu_adjustments.adjustment_id%TYPE;
882: l_subcontract_po_shipment_id jmf_shikyu_adjustments.subcontract_po_shipment_id%TYPE;
883: l_shikyu_component_id jmf_shikyu_adjustments.shikyu_component_id%TYPE;
884: l_adjustment jmf_shikyu_adjustments.adjustment%TYPE;
885: l_uom jmf_shikyu_adjustments.uom%TYPE;

Line 882: l_subcontract_po_shipment_id jmf_shikyu_adjustments.subcontract_po_shipment_id%TYPE;

878: WHERE batch_id = p_batch_id
879: ORDER BY adjustment;
880:
881: l_adjustment_id jmf_shikyu_adjustments.adjustment_id%TYPE;
882: l_subcontract_po_shipment_id jmf_shikyu_adjustments.subcontract_po_shipment_id%TYPE;
883: l_shikyu_component_id jmf_shikyu_adjustments.shikyu_component_id%TYPE;
884: l_adjustment jmf_shikyu_adjustments.adjustment%TYPE;
885: l_uom jmf_shikyu_adjustments.uom%TYPE;
886:

Line 883: l_shikyu_component_id jmf_shikyu_adjustments.shikyu_component_id%TYPE;

879: ORDER BY adjustment;
880:
881: l_adjustment_id jmf_shikyu_adjustments.adjustment_id%TYPE;
882: l_subcontract_po_shipment_id jmf_shikyu_adjustments.subcontract_po_shipment_id%TYPE;
883: l_shikyu_component_id jmf_shikyu_adjustments.shikyu_component_id%TYPE;
884: l_adjustment jmf_shikyu_adjustments.adjustment%TYPE;
885: l_uom jmf_shikyu_adjustments.uom%TYPE;
886:
887: BEGIN

Line 884: l_adjustment jmf_shikyu_adjustments.adjustment%TYPE;

880:
881: l_adjustment_id jmf_shikyu_adjustments.adjustment_id%TYPE;
882: l_subcontract_po_shipment_id jmf_shikyu_adjustments.subcontract_po_shipment_id%TYPE;
883: l_shikyu_component_id jmf_shikyu_adjustments.shikyu_component_id%TYPE;
884: l_adjustment jmf_shikyu_adjustments.adjustment%TYPE;
885: l_uom jmf_shikyu_adjustments.uom%TYPE;
886:
887: BEGIN
888: -- **** for debug information in readonly UT environment.--- begin ****

Line 885: l_uom jmf_shikyu_adjustments.uom%TYPE;

881: l_adjustment_id jmf_shikyu_adjustments.adjustment_id%TYPE;
882: l_subcontract_po_shipment_id jmf_shikyu_adjustments.subcontract_po_shipment_id%TYPE;
883: l_shikyu_component_id jmf_shikyu_adjustments.shikyu_component_id%TYPE;
884: l_adjustment jmf_shikyu_adjustments.adjustment%TYPE;
885: l_uom jmf_shikyu_adjustments.uom%TYPE;
886:
887: BEGIN
888: -- **** for debug information in readonly UT environment.--- begin ****
889: JMF_SHIKYU_RPT_UTIL.debug_output

Line 949: UPDATE jmf_shikyu_adjustments

945: ,p_api_name => G_MODULE_PREFIX || l_api_name
946: ,p_message => 'l_adjustment_id: ' || l_adjustment_id
947: );
948: -- **** for debug information in readonly UT environment.--- end ****
949: UPDATE jmf_shikyu_adjustments
950: SET request_id = -1,
951: last_update_date = sysdate,
952: last_updated_by = FND_GLOBAL.user_id,
953: last_update_login = FND_GLOBAL.login_id

Line 1710: FROM jmf_shikyu_adjustments

1706: l_adjustment_total NUMBER;
1707: BEGIN
1708: SELECT nvl(SUM(adjustment), 0)
1709: INTO l_adjustment_total
1710: FROM jmf_shikyu_adjustments
1711: WHERE subcontract_po_shipment_id = p_po_shipment_id
1712: AND shikyu_component_id = p_component_id
1713: AND request_id IS NOT NULL;
1714: