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.WIP_JOBCLOSE_PRIV dependencies on WIP_DJ_CLOSE_TEMP

Line 46: SELECT WIP_DJ_CLOSE_TEMP_S.nextval

42: p_params => l_params,
43: x_returnStatus => l_return_Status);
44: END IF;
45:
46: SELECT WIP_DJ_CLOSE_TEMP_S.nextval
47: INTO x_group_id
48: FROM DUAL ;
49:
50: INSERT INTO WIP_DJ_CLOSE_TEMP

Line 50: INSERT INTO WIP_DJ_CLOSE_TEMP

46: SELECT WIP_DJ_CLOSE_TEMP_S.nextval
47: INTO x_group_id
48: FROM DUAL ;
49:
50: INSERT INTO WIP_DJ_CLOSE_TEMP
51: ( wip_entity_id ,
52: organization_id ,
53: wip_entity_name ,
54: primary_item_id ,

Line 75: FROM WIP_DJ_CLOSE_TEMP WDCT

71: AND AP.OPEN_FLAG = 'Y'
72: AND WE.WIP_ENTITY_ID = DJ.WIP_ENTITY_ID
73: AND NOT EXISTS
74: (SELECT 'X'
75: FROM WIP_DJ_CLOSE_TEMP WDCT
76: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
77: AND DJ.STATUS_TYPE IN
78: -- (1,3,4,5,6,7,9,11,15)
79: (WIP_CONSTANTS.UNRELEASED,

Line 164: FROM WIP_DJ_CLOSE_TEMP

160: DJ.PRIMARY_ITEM_ID, DJ.STATUS_TYPE ;
161:
162: SELECT count(*)
163: INTO l_number_temp
164: FROM WIP_DJ_CLOSE_TEMP
165: WHERE group_id = x_group_id ;
166:
167: fnd_file.put_line(FND_FILE.LOG,'Records inserted in close temp '||to_char(l_number_temp));
168:

Line 401: -- invalid records from wip_dj_close_temp collecting the

397: END IF;
398:
399: --
400: -- The most efficient algorithm is to start deleting all
401: -- invalid records from wip_dj_close_temp collecting the
402: -- wip_entity_ids at the same time. Then use BULK op
403: -- to update wip_discrete_jobs' status for those records.
404: -- bso Sat Jun 17 17:18:45 PDT 2006
405: --

Line 407: DELETE FROM wip_dj_close_temp wdct

403: -- to update wip_discrete_jobs' status for those records.
404: -- bso Sat Jun 17 17:18:45 PDT 2006
405: --
406:
407: DELETE FROM wip_dj_close_temp wdct
408: WHERE wdct.organization_id = p_organization_id AND
409: wdct.group_id = p_group_id AND
410: wdct.actual_close_date <
411: (SELECT wdj.date_released

Line 484: FROM WIP_DJ_CLOSE_TEMP

480: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
481:
482: CURSOR c_pending_txns IS
483: SELECT WIP_ENTITY_NAME
484: FROM WIP_DJ_CLOSE_TEMP
485: WHERE GROUP_ID = p_group_id
486: AND ORGANIZATION_ID = p_organization_id
487: AND WIP_ENTITY_ID IN
488: (SELECT WIP_ENTITY_ID

Line 529: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;

525: AND MTRL.txn_source_id = WLC.wip_entity_id
526: AND MTRL.line_status = 7 /*Bugfix 6455522 added one condition for mtrl.line_status=7*/
527: AND LPN.LPN_CONTEXT = 2);
528:
529: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
530: l_failed_counter NUMBER ;
531: BEGIN
532:
533: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 555: UPDATE WIP_DJ_CLOSE_TEMP

551: x_returnStatus := FND_API.G_RET_STS_ERROR ;
552: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
553: end if ;
554:
555: UPDATE WIP_DJ_CLOSE_TEMP
556: SET STATUS_TYPE = 99
557: WHERE WIP_ENTITY_NAME = l_failed_jobs ;
558:
559: EXIT WHEN c_pending_txns%NOTFOUND ;

Line 566: FROM WIP_DJ_CLOSE_TEMP

562: UPDATE WIP_DISCRETE_JOBS
563: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
564: WHERE WIP_ENTITY_ID IN
565: (SELECT WIP_ENTITY_ID
566: FROM WIP_DJ_CLOSE_TEMP
567: WHERE GROUP_ID = p_group_id
568: AND ORGANIZATION_ID = p_organization_id
569: AND STATUS_TYPE = 99);
570:

Line 571: DELETE FROM WIP_DJ_CLOSE_TEMP

567: WHERE GROUP_ID = p_group_id
568: AND ORGANIZATION_ID = p_organization_id
569: AND STATUS_TYPE = 99);
570:
571: DELETE FROM WIP_DJ_CLOSE_TEMP
572: WHERE GROUP_ID = p_group_id
573: AND ORGANIZATION_ID = p_organization_id
574: AND STATUS_TYPE = 99;
575:

Line 623: from wip_dj_close_temp wdct,

619: IS
620: cursor c_jobs is
621: select wdct.wip_entity_id,
622: we.organization_id
623: from wip_dj_close_temp wdct,
624: wip_entities we
625: where we.wip_entity_id = wdct.wip_entity_id
626: and we.organization_id = wdct.organization_id
627: and wdct.group_id = p_group_id

Line 644: UPDATE WIP_DJ_CLOSE_TEMP

640: (p_wip_entity_id => l_jobRec.wip_entity_id,
641: p_organization_id => l_jobRec.organization_id);
642:
643: IF (l_ret_exp_status = false) then
644: UPDATE WIP_DJ_CLOSE_TEMP
645: SET STATUS_TYPE = 99
646: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
647:
648: x_returnstatus := FND_API.G_RET_STS_ERROR;

Line 665: from wip_dj_close_temp wdct,

661: IS
662: cursor c_jobs is
663: select wdct.wip_entity_id,
664: we.wip_entity_name
665: from wip_dj_close_temp wdct,
666: wip_entities we
667: where we.wip_entity_id = wdct.wip_entity_id
668: and we.organization_id = wdct.organization_id
669: and wdct.group_id = p_group_id

Line 699: UPDATE WIP_DJ_CLOSE_TEMP

695: (p_wip_entity_id => l_jobRec.wip_entity_id,
696: p_operation_seq_num => NULL);
697:
698: IF (l_ret_status <> 'N') then
699: UPDATE WIP_DJ_CLOSE_TEMP
700: SET STATUS_TYPE = 99
701: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
702: l_failed_counter := l_failed_counter + 1 ;
703: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));

Line 712: FROM WIP_DJ_CLOSE_TEMP

708: UPDATE WIP_DISCRETE_JOBS
709: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
710: WHERE WIP_ENTITY_ID IN
711: (SELECT WIP_ENTITY_ID
712: FROM WIP_DJ_CLOSE_TEMP
713: WHERE GROUP_ID = p_group_id
714: AND ORGANIZATION_ID = p_organization_id
715: AND STATUS_TYPE = 99);
716:

Line 717: DELETE FROM WIP_DJ_CLOSE_TEMP

713: WHERE GROUP_ID = p_group_id
714: AND ORGANIZATION_ID = p_organization_id
715: AND STATUS_TYPE = 99);
716:
717: DELETE FROM WIP_DJ_CLOSE_TEMP
718: WHERE GROUP_ID = p_group_id
719: AND ORGANIZATION_ID = p_organization_id
720: AND STATUS_TYPE = 99;
721:

Line 766: from wip_dj_close_temp wdct,

762: cursor c_jobs is
763: select wdct.wip_entity_id,
764: we.entity_type,
765: we.wip_entity_name
766: from wip_dj_close_temp wdct,
767: wip_entities we
768: where we.wip_entity_id = wdct.wip_entity_id
769: and we.organization_id = wdct.organization_id
770: and wdct.group_id = p_group_id

Line 787: UPDATE WIP_DJ_CLOSE_TEMP

783: x_return_status => l_ret_status,
784: x_msg_data => l_msg_data);
785: fnd_file.put_line(FND_FILE.LOG,'return status '||l_ret_status);
786: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS ) then
787: UPDATE WIP_DJ_CLOSE_TEMP
788: SET STATUS_TYPE = 99
789: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
790: l_failed_counter := l_failed_counter + 1 ;
791: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));

Line 800: FROM WIP_DJ_CLOSE_TEMP

796: UPDATE WIP_DISCRETE_JOBS
797: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
798: WHERE WIP_ENTITY_ID IN
799: (SELECT WIP_ENTITY_ID
800: FROM WIP_DJ_CLOSE_TEMP
801: WHERE GROUP_ID = p_group_id
802: AND ORGANIZATION_ID = p_organization_id
803: AND STATUS_TYPE = 99);
804:

Line 805: DELETE FROM WIP_DJ_CLOSE_TEMP

801: WHERE GROUP_ID = p_group_id
802: AND ORGANIZATION_ID = p_organization_id
803: AND STATUS_TYPE = 99);
804:
805: DELETE FROM WIP_DJ_CLOSE_TEMP
806: WHERE GROUP_ID = p_group_id
807: AND ORGANIZATION_ID = p_organization_id
808: AND STATUS_TYPE = 99;
809:

Line 822: from wip_dj_close_temp wdct,

818: IS
819: cursor c_jobs is
820: select wdct.wip_entity_id,
821: we.entity_type
822: from wip_dj_close_temp wdct,
823: wip_entities we
824: where we.wip_entity_id = wdct.wip_entity_id
825: and we.organization_id = wdct.organization_id
826: and wdct.group_id = p_group_id

Line 875: FROM WIP_DJ_CLOSE_TEMP

871: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
872:
873: CURSOR c_pending_txns IS
874: SELECT WIP_ENTITY_NAME
875: FROM WIP_DJ_CLOSE_TEMP
876: WHERE WIP_ENTITY_ID IN
877: (SELECT wdct.WIP_ENTITY_ID
878: FROM WIP_TRANSACTIONS wt,
879: WIP_DJ_CLOSE_TEMP wdct

Line 879: WIP_DJ_CLOSE_TEMP wdct

875: FROM WIP_DJ_CLOSE_TEMP
876: WHERE WIP_ENTITY_ID IN
877: (SELECT wdct.WIP_ENTITY_ID
878: FROM WIP_TRANSACTIONS wt,
879: WIP_DJ_CLOSE_TEMP wdct
880: WHERE wdct.GROUP_ID = p_group_id
881: AND wdct.ORGANIZATION_ID = p_organization_id
882: AND wdct.WIP_ENTITY_ID = wt.WIP_ENTITY_ID
883: AND wt.ORGANIZATION_ID = p_organization_id

Line 888: WIP_DJ_CLOSE_TEMP wdct

884: AND wt.TRANSACTION_DATE > wdct.ACTUAL_CLOSE_DATE
885: UNION
886: SELECT wdct.WIP_ENTITY_ID
887: FROM MTL_MATERIAL_TRANSACTIONS mmt,
888: WIP_DJ_CLOSE_TEMP wdct
889: WHERE wdct.GROUP_ID = p_group_id
890: AND wdct.ORGANIZATION_ID = p_organization_id
891: AND wdct.WIP_ENTITY_ID = mmt.TRANSACTION_SOURCE_ID
892: AND mmt.TRANSACTION_SOURCE_TYPE_ID = 5

Line 895: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;

891: AND wdct.WIP_ENTITY_ID = mmt.TRANSACTION_SOURCE_ID
892: AND mmt.TRANSACTION_SOURCE_TYPE_ID = 5
893: AND mmt.ORGANIZATION_ID = p_organization_id
894: AND mmt.TRANSACTION_DATE > wdct.ACTUAL_CLOSE_DATE) ;
895: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
896: l_failed_counter NUMBER ;
897: BEGIN
898: fnd_file.put_line(FND_FILE.LOG,'Inside Procedure Close Date ');
899: x_returnStatus := fnd_api.g_ret_sts_success;

Line 922: UPDATE WIP_DJ_CLOSE_TEMP

918: x_returnstatus := FND_API.G_RET_STS_ERROR ;
919: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
920: end if ;
921:
922: UPDATE WIP_DJ_CLOSE_TEMP
923: SET STATUS_TYPE = 99
924: WHERE WIP_ENTITY_NAME = l_failed_jobs ;
925:
926: EXIT WHEN c_pending_txns%NOTFOUND ;

Line 934: FROM WIP_DJ_CLOSE_TEMP

930: UPDATE WIP_DISCRETE_JOBS
931: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
932: WHERE WIP_ENTITY_ID IN
933: (SELECT WIP_ENTITY_ID
934: FROM WIP_DJ_CLOSE_TEMP
935: WHERE GROUP_ID = p_group_id
936: AND ORGANIZATION_ID = p_organization_id
937: AND STATUS_TYPE = 99);
938:

Line 939: DELETE FROM WIP_DJ_CLOSE_TEMP

935: WHERE GROUP_ID = p_group_id
936: AND ORGANIZATION_ID = p_organization_id
937: AND STATUS_TYPE = 99);
938:
939: DELETE FROM WIP_DJ_CLOSE_TEMP
940: WHERE GROUP_ID = p_group_id
941: AND ORGANIZATION_ID = p_organization_id
942: AND STATUS_TYPE = 99;
943:

Line 993: FROM WIP_DJ_CLOSE_TEMP WDCT

989: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
990:
991: CURSOR c_open_po IS
992: SELECT WIP_ENTITY_NAME
993: FROM WIP_DJ_CLOSE_TEMP WDCT
994: WHERE wdct.GROUP_ID = p_group_id
995: AND wdct.ORGANIZATION_ID = p_organization_id
996: AND EXISTS
997: (SELECT '1'

Line 1031: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;

1027: WHERE PRI.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
1028: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
1029: ) ;
1030:
1031: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1032: l_failed_counter NUMBER ;
1033:
1034: BEGIN
1035: fnd_file.put_line(FND_FILE.LOG,'Open PO Check');

Line 1191: wip_dj_close_temp wdct

1187:
1188: CURSOR C_del_reservation IS
1189: SELECT wrv.reservation_id
1190: FROM wip_reservations_v wrv,
1191: wip_dj_close_temp wdct
1192: WHERE wdct.organization_id = p_organization_id
1193: AND wdct.group_id = p_group_id
1194: AND wdct.wip_entity_id = wrv.wip_entity_id;
1195:

Line 1363: FROM WIP_DJ_CLOSE_TEMP TEMP,

1359: fnd_file.put_line(FND_FILE.LOG,'Report Quantity Precision');
1360:
1361: SELECT COUNT(*)
1362: INTO l_std_asst_jobs
1363: FROM WIP_DJ_CLOSE_TEMP TEMP,
1364: WIP_DISCRETE_JOBS WDJ,
1365: WIP_ACCOUNTING_CLASSES WAC
1366: WHERE WDJ.WIP_ENTITY_ID = TEMP.WIP_ENTITY_ID
1367: AND TEMP.ORGANIZATION_ID = p_organization_id

Line 1381: FROM WIP_DJ_CLOSE_TEMP TEMP,

1377: WIP_CONSTANTS.EAM_CLASS ) ;
1378:
1379: SELECT COUNT(*)
1380: INTO l_expense_jobs
1381: FROM WIP_DJ_CLOSE_TEMP TEMP,
1382: WIP_DISCRETE_JOBS WDJ,
1383: WIP_ACCOUNTING_CLASSES WAC
1384: WHERE WDJ.WIP_ENTITY_ID = TEMP.WIP_ENTITY_ID
1385: AND TEMP.ORGANIZATION_ID = p_organization_id

Line 1813: FROM wip_dj_close_temp

1809: program_application_id = fnd_global.prog_appl_id,
1810: program_id = fnd_global.conc_program_id
1811: WHERE organization_id = p_organization_id
1812: AND wip_entity_id in (SELECT wip_entity_id
1813: FROM wip_dj_close_temp
1814: WHERE group_id = l_group_id
1815: AND organization_id = p_organization_id);
1816:
1817: /*Bug 6908428: Updating the status in eam_work_order_details pending close for eam workorders */

Line 2139: FROM WIP_DJ_CLOSE_TEMP wdct,

2135: wdct.WIP_ENTITY_ID,
2136: wdct.WIP_ENTITY_NAME,
2137: we.ENTITY_TYPE,
2138: wdct.ACTUAL_CLOSE_DATE
2139: FROM WIP_DJ_CLOSE_TEMP wdct,
2140: ORG_ACCT_PERIODS oap,
2141: WIP_ENTITIES we
2142: WHERE wdct.GROUP_ID = l_group_id
2143: AND we.wip_entity_id = wdct.wip_entity_id

Line 2221: FROM WIP_DJ_CLOSE_TEMP wdct

2217:
2218:
2219: UPDATE WIP_DISCRETE_JOBS wdj
2220: SET DATE_CLOSED = (SELECT wdct.ACTUAL_CLOSE_DATE
2221: FROM WIP_DJ_CLOSE_TEMP wdct
2222: WHERE wdct.ORGANIZATION_ID = p_organization_id
2223: AND wdj.ORGANIZATION_ID = p_organization_id
2224: AND wdj.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
2225: AND wdct.GROUP_ID = l_group_id),

Line 2232: FROM WIP_DJ_CLOSE_TEMP

2228: last_update_login = fnd_global.login_id,
2229: STATUS_TYPE = WIP_CONSTANTS.CLOSED
2230: WHERE ORGANIZATION_ID = p_organization_id
2231: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2232: FROM WIP_DJ_CLOSE_TEMP
2233: WHERE ORGANIZATION_ID = p_organization_id
2234: AND GROUP_ID = l_group_id);
2235:
2236:

Line 2250: FROM WIP_DJ_CLOSE_TEMP wdct

2246: last_updated_by = fnd_global.user_id,
2247: last_update_login = fnd_global.login_id
2248: WHERE ORGANIZATION_ID = p_organization_id
2249: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
2250: FROM WIP_DJ_CLOSE_TEMP wdct
2251: WHERE wdct.ORGANIZATION_ID = p_organization_id
2252: AND wdct.GROUP_ID = l_group_id);
2253:
2254:

Line 2287: FROM WIP_DJ_CLOSE_TEMP

2283:
2284:
2285: SELECT COUNT(*)
2286: INTO l_num_close
2287: FROM WIP_DJ_CLOSE_TEMP
2288: WHERE ORGANIZATION_ID = p_organization_id
2289: AND GROUP_ID = l_group_id;
2290:
2291: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));

Line 2300: DELETE FROM WIP_DJ_CLOSE_TEMP

2296: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2297:
2298:
2299: IF ( l_num_close > 0 ) THEN
2300: DELETE FROM WIP_DJ_CLOSE_TEMP
2301: WHERE ORGANIZATION_ID = p_organization_id
2302: AND GROUP_ID = l_group_id;
2303: END IF;
2304:

Line 2367: FROM WIP_DJ_CLOSE_TEMP

2363: last_update_login = fnd_global.login_id,
2364: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
2365: WHERE ORGANIZATION_ID = p_organization_id
2366: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2367: FROM WIP_DJ_CLOSE_TEMP
2368: WHERE ORGANIZATION_ID = p_organization_id
2369: AND GROUP_ID = l_group_id);
2370:
2371: /* Clean up Temp Table */

Line 2373: DELETE FROM WIP_DJ_CLOSE_TEMP

2369: AND GROUP_ID = l_group_id);
2370:
2371: /* Clean up Temp Table */
2372:
2373: DELETE FROM WIP_DJ_CLOSE_TEMP
2374: WHERE ORGANIZATION_ID = p_organization_id
2375: AND GROUP_ID = l_group_id;
2376:
2377: --