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.

[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_DJ_CLOSE_TEMP

Line 34: TYPE l_close_temp_typ IS TABLE OF WIP_DJ_CLOSE_TEMP%ROWTYPE;

30: l_return_Status VARCHAR2(1);
31: l_msg VARCHAR(240);
32: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
33: l_number_temp NUMBER ;
34: TYPE l_close_temp_typ IS TABLE OF WIP_DJ_CLOSE_TEMP%ROWTYPE;
35: l_close_temp_tbl1 l_close_temp_typ:=l_close_temp_typ();
36: l_close_temp_tbl2 l_close_temp_typ:=l_close_temp_typ();
37: l_close_final_tbl l_close_temp_typ:=l_close_temp_typ();
38: ex_dml_errors EXCEPTION;

Line 53: SELECT WIP_DJ_CLOSE_TEMP_S.nextval

49: p_params => l_params,
50: x_returnStatus => l_return_Status);
51: END IF;
52:
53: SELECT WIP_DJ_CLOSE_TEMP_S.nextval
54: INTO x_group_id
55: FROM DUAL ;
56:
57:

Line 91: FROM WIP_DJ_CLOSE_TEMP WDCT

87: AND AP.OPEN_FLAG = 'Y'
88: AND WE.WIP_ENTITY_ID = DJ.WIP_ENTITY_ID
89: AND NOT EXISTS
90: (SELECT 'X'
91: FROM WIP_DJ_CLOSE_TEMP WDCT
92: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
93: AND DJ.STATUS_TYPE IN
94: -- (1,3,4,5,6,7,9,11,15)
95: (WIP_CONSTANTS.UNRELEASED,

Line 208: FROM WIP_DJ_CLOSE_TEMP WDCT

204: AND AP.ORGANIZATION_ID = DJ.ORGANIZATION_ID
205: AND AP.OPEN_FLAG = 'Y'
206: AND WE.WIP_ENTITY_ID = DJ.WIP_ENTITY_ID
207: AND NOT EXISTS ( SELECT 'X'
208: FROM WIP_DJ_CLOSE_TEMP WDCT
209: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID )
210: AND DJ.STATUS_TYPE IN
211: -- (1,3,4,5,6,7,9,11,15)
212: (WIP_CONSTANTS.UNRELEASED,

Line 306: FROM WIP_DJ_CLOSE_TEMP WDCT

302: AND AP.OPEN_FLAG = 'Y'
303: AND WE.WIP_ENTITY_ID = DJ.WIP_ENTITY_ID
304: AND NOT EXISTS
305: (SELECT 'X'
306: FROM WIP_DJ_CLOSE_TEMP WDCT
307: WHERE WDCT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
308: AND DJ.STATUS_TYPE IN
309: -- (1,3,4,5,6,7,9,11,15)
310: (WIP_CONSTANTS.UNRELEASED,

Line 411: INSERT INTO WIP_DJ_CLOSE_TEMP

407: l_close_final_tbl:=l_close_temp_tbl1 MULTISET UNION l_close_temp_tbl2;
408:
409: BEGIN
410: forall indx in l_close_final_tbl.first..l_close_final_tbl.last SAVE EXCEPTIONS
411: INSERT INTO WIP_DJ_CLOSE_TEMP
412: VALUES l_close_final_tbl(indx);
413: EXCEPTION
414: WHEN ex_dml_errors THEN
415: wip_logger.log('Error in Insertion into WIP_DJ_CLOSE_TEMP',l_return_status);

Line 415: wip_logger.log('Error in Insertion into WIP_DJ_CLOSE_TEMP',l_return_status);

411: INSERT INTO WIP_DJ_CLOSE_TEMP
412: VALUES l_close_final_tbl(indx);
413: EXCEPTION
414: WHEN ex_dml_errors THEN
415: wip_logger.log('Error in Insertion into WIP_DJ_CLOSE_TEMP',l_return_status);
416: FOR i IN 1 ..SQL%BULK_EXCEPTIONS.count LOOP
417: wip_logger.log('wip_entity_id= ' ||l_close_final_tbl(SQL%BULK_EXCEPTIONS(i).error_index).wip_entity_id ||',Error='||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),l_return_status);
418: END LOOP;
419: END;

Line 427: FROM WIP_DJ_CLOSE_TEMP

423: l_close_final_tbl.delete;
424:
425: SELECT count(*)
426: INTO l_number_temp
427: FROM WIP_DJ_CLOSE_TEMP
428: WHERE group_id = x_group_id ;
429:
430: fnd_file.put_line(FND_FILE.LOG,'Records inserted in close temp '||to_char(l_number_temp));
431:

Line 668: -- invalid records from wip_dj_close_temp collecting the

664: END IF;
665:
666: --
667: -- The most efficient algorithm is to start deleting all
668: -- invalid records from wip_dj_close_temp collecting the
669: -- wip_entity_ids at the same time. Then use BULK op
670: -- to update wip_discrete_jobs' status for those records.
671: -- bso Sat Jun 17 17:18:45 PDT 2006
672: --

Line 674: DELETE FROM wip_dj_close_temp wdct

670: -- to update wip_discrete_jobs' status for those records.
671: -- bso Sat Jun 17 17:18:45 PDT 2006
672: --
673:
674: DELETE FROM wip_dj_close_temp wdct
675: WHERE wdct.organization_id = p_organization_id AND
676: wdct.group_id = p_group_id AND
677: wdct.actual_close_date <
678: (SELECT wdj.date_released

Line 751: FROM WIP_DJ_CLOSE_TEMP

747: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
748:
749: CURSOR c_pending_txns IS
750: SELECT WIP_ENTITY_NAME
751: FROM WIP_DJ_CLOSE_TEMP
752: WHERE GROUP_ID = p_group_id
753: AND ORGANIZATION_ID = p_organization_id
754: AND WIP_ENTITY_ID IN
755: (SELECT WIP_ENTITY_ID

Line 796: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;

792: AND MTRL.txn_source_id = WLC.wip_entity_id
793: AND MTRL.line_status = 7 /*Bugfix 6455522 added one condition for mtrl.line_status=7*/
794: AND LPN.LPN_CONTEXT = 2);
795:
796: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
797: l_failed_counter NUMBER ;
798: BEGIN
799:
800: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 822: UPDATE WIP_DJ_CLOSE_TEMP

818: x_returnStatus := FND_API.G_RET_STS_ERROR ;
819: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
820: end if ;
821:
822: UPDATE WIP_DJ_CLOSE_TEMP
823: SET STATUS_TYPE = 99
824: WHERE WIP_ENTITY_NAME = l_failed_jobs ;
825:
826: EXIT WHEN c_pending_txns%NOTFOUND ;

Line 833: FROM WIP_DJ_CLOSE_TEMP

829: UPDATE WIP_DISCRETE_JOBS
830: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
831: WHERE WIP_ENTITY_ID IN
832: (SELECT WIP_ENTITY_ID
833: FROM WIP_DJ_CLOSE_TEMP
834: WHERE GROUP_ID = p_group_id
835: AND ORGANIZATION_ID = p_organization_id
836: AND STATUS_TYPE = 99);
837:

Line 838: DELETE FROM WIP_DJ_CLOSE_TEMP

834: WHERE GROUP_ID = p_group_id
835: AND ORGANIZATION_ID = p_organization_id
836: AND STATUS_TYPE = 99);
837:
838: DELETE FROM WIP_DJ_CLOSE_TEMP
839: WHERE GROUP_ID = p_group_id
840: AND ORGANIZATION_ID = p_organization_id
841: AND STATUS_TYPE = 99;
842:

Line 890: from wip_dj_close_temp wdct,

886: IS
887: cursor c_jobs is
888: select wdct.wip_entity_id,
889: we.organization_id
890: from wip_dj_close_temp wdct,
891: wip_entities we
892: where we.wip_entity_id = wdct.wip_entity_id
893: and we.organization_id = wdct.organization_id
894: and wdct.group_id = p_group_id

Line 911: UPDATE WIP_DJ_CLOSE_TEMP

907: (p_wip_entity_id => l_jobRec.wip_entity_id,
908: p_organization_id => l_jobRec.organization_id);
909:
910: IF (l_ret_exp_status = false) then
911: UPDATE WIP_DJ_CLOSE_TEMP
912: SET STATUS_TYPE = 99
913: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
914:
915: x_returnstatus := FND_API.G_RET_STS_ERROR;

Line 932: from wip_dj_close_temp wdct,

928: IS
929: cursor c_jobs is
930: select wdct.wip_entity_id,
931: we.wip_entity_name
932: from wip_dj_close_temp wdct,
933: wip_entities we
934: where we.wip_entity_id = wdct.wip_entity_id
935: and we.organization_id = wdct.organization_id
936: and wdct.group_id = p_group_id

Line 966: UPDATE WIP_DJ_CLOSE_TEMP

962: (p_wip_entity_id => l_jobRec.wip_entity_id,
963: p_operation_seq_num => NULL);
964:
965: IF (l_ret_status <> 'N') then
966: UPDATE WIP_DJ_CLOSE_TEMP
967: SET STATUS_TYPE = 99
968: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
969: l_failed_counter := l_failed_counter + 1 ;
970: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));

Line 979: FROM WIP_DJ_CLOSE_TEMP

975: UPDATE WIP_DISCRETE_JOBS
976: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
977: WHERE WIP_ENTITY_ID IN
978: (SELECT WIP_ENTITY_ID
979: FROM WIP_DJ_CLOSE_TEMP
980: WHERE GROUP_ID = p_group_id
981: AND ORGANIZATION_ID = p_organization_id
982: AND STATUS_TYPE = 99);
983:

Line 984: DELETE FROM WIP_DJ_CLOSE_TEMP

980: WHERE GROUP_ID = p_group_id
981: AND ORGANIZATION_ID = p_organization_id
982: AND STATUS_TYPE = 99);
983:
984: DELETE FROM WIP_DJ_CLOSE_TEMP
985: WHERE GROUP_ID = p_group_id
986: AND ORGANIZATION_ID = p_organization_id
987: AND STATUS_TYPE = 99;
988:

Line 1033: from wip_dj_close_temp wdct,

1029: cursor c_jobs is
1030: select wdct.wip_entity_id,
1031: we.entity_type,
1032: we.wip_entity_name
1033: from wip_dj_close_temp wdct,
1034: wip_entities we
1035: where we.wip_entity_id = wdct.wip_entity_id
1036: and we.organization_id = wdct.organization_id
1037: and wdct.group_id = p_group_id

Line 1054: UPDATE WIP_DJ_CLOSE_TEMP

1050: x_return_status => l_ret_status,
1051: x_msg_data => l_msg_data);
1052: fnd_file.put_line(FND_FILE.LOG,'return status '||l_ret_status);
1053: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS ) then
1054: UPDATE WIP_DJ_CLOSE_TEMP
1055: SET STATUS_TYPE = 99
1056: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
1057: l_failed_counter := l_failed_counter + 1 ;
1058: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));

Line 1067: FROM WIP_DJ_CLOSE_TEMP

1063: UPDATE WIP_DISCRETE_JOBS
1064: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
1065: WHERE WIP_ENTITY_ID IN
1066: (SELECT WIP_ENTITY_ID
1067: FROM WIP_DJ_CLOSE_TEMP
1068: WHERE GROUP_ID = p_group_id
1069: AND ORGANIZATION_ID = p_organization_id
1070: AND STATUS_TYPE = 99);
1071:

Line 1072: DELETE FROM WIP_DJ_CLOSE_TEMP

1068: WHERE GROUP_ID = p_group_id
1069: AND ORGANIZATION_ID = p_organization_id
1070: AND STATUS_TYPE = 99);
1071:
1072: DELETE FROM WIP_DJ_CLOSE_TEMP
1073: WHERE GROUP_ID = p_group_id
1074: AND ORGANIZATION_ID = p_organization_id
1075: AND STATUS_TYPE = 99;
1076:

Line 1089: from wip_dj_close_temp wdct,

1085: IS
1086: cursor c_jobs is
1087: select wdct.wip_entity_id,
1088: we.entity_type
1089: from wip_dj_close_temp wdct,
1090: wip_entities we
1091: where we.wip_entity_id = wdct.wip_entity_id
1092: and we.organization_id = wdct.organization_id
1093: and wdct.group_id = p_group_id

Line 1142: FROM WIP_DJ_CLOSE_TEMP

1138: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1139:
1140: CURSOR c_pending_txns IS
1141: SELECT WIP_ENTITY_NAME
1142: FROM WIP_DJ_CLOSE_TEMP
1143: WHERE WIP_ENTITY_ID IN
1144: (SELECT wdct.WIP_ENTITY_ID
1145: FROM WIP_TRANSACTIONS wt,
1146: WIP_DJ_CLOSE_TEMP wdct

Line 1146: WIP_DJ_CLOSE_TEMP wdct

1142: FROM WIP_DJ_CLOSE_TEMP
1143: WHERE WIP_ENTITY_ID IN
1144: (SELECT wdct.WIP_ENTITY_ID
1145: FROM WIP_TRANSACTIONS wt,
1146: WIP_DJ_CLOSE_TEMP wdct
1147: WHERE wdct.GROUP_ID = p_group_id
1148: AND wdct.ORGANIZATION_ID = p_organization_id
1149: AND wdct.WIP_ENTITY_ID = wt.WIP_ENTITY_ID
1150: AND wt.ORGANIZATION_ID = p_organization_id

Line 1155: WIP_DJ_CLOSE_TEMP wdct

1151: AND wt.TRANSACTION_DATE > wdct.ACTUAL_CLOSE_DATE
1152: UNION
1153: SELECT wdct.WIP_ENTITY_ID
1154: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1155: WIP_DJ_CLOSE_TEMP wdct
1156: WHERE wdct.GROUP_ID = p_group_id
1157: AND wdct.ORGANIZATION_ID = p_organization_id
1158: AND wdct.WIP_ENTITY_ID = mmt.TRANSACTION_SOURCE_ID
1159: AND mmt.TRANSACTION_SOURCE_TYPE_ID = 5

Line 1162: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;

1158: AND wdct.WIP_ENTITY_ID = mmt.TRANSACTION_SOURCE_ID
1159: AND mmt.TRANSACTION_SOURCE_TYPE_ID = 5
1160: AND mmt.ORGANIZATION_ID = p_organization_id
1161: AND mmt.TRANSACTION_DATE > wdct.ACTUAL_CLOSE_DATE) ;
1162: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1163: l_failed_counter NUMBER ;
1164: BEGIN
1165: fnd_file.put_line(FND_FILE.LOG,'Inside Procedure Close Date ');
1166: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1189: UPDATE WIP_DJ_CLOSE_TEMP

1185: x_returnstatus := FND_API.G_RET_STS_ERROR ;
1186: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1187: end if ;
1188:
1189: UPDATE WIP_DJ_CLOSE_TEMP
1190: SET STATUS_TYPE = 99
1191: WHERE WIP_ENTITY_NAME = l_failed_jobs ;
1192:
1193: EXIT WHEN c_pending_txns%NOTFOUND ;

Line 1201: FROM WIP_DJ_CLOSE_TEMP

1197: UPDATE WIP_DISCRETE_JOBS
1198: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
1199: WHERE WIP_ENTITY_ID IN
1200: (SELECT WIP_ENTITY_ID
1201: FROM WIP_DJ_CLOSE_TEMP
1202: WHERE GROUP_ID = p_group_id
1203: AND ORGANIZATION_ID = p_organization_id
1204: AND STATUS_TYPE = 99);
1205:

Line 1206: DELETE FROM WIP_DJ_CLOSE_TEMP

1202: WHERE GROUP_ID = p_group_id
1203: AND ORGANIZATION_ID = p_organization_id
1204: AND STATUS_TYPE = 99);
1205:
1206: DELETE FROM WIP_DJ_CLOSE_TEMP
1207: WHERE GROUP_ID = p_group_id
1208: AND ORGANIZATION_ID = p_organization_id
1209: AND STATUS_TYPE = 99;
1210:

Line 1260: FROM WIP_DJ_CLOSE_TEMP WDCT

1256: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1257:
1258: CURSOR c_open_po IS
1259: SELECT WIP_ENTITY_NAME
1260: FROM WIP_DJ_CLOSE_TEMP WDCT
1261: WHERE wdct.GROUP_ID = p_group_id
1262: AND wdct.ORGANIZATION_ID = p_organization_id
1263: AND EXISTS
1264: (SELECT '1'

Line 1299: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;

1295: WHERE PRI.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
1296: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
1297: ) ;
1298:
1299: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1300: l_failed_counter NUMBER ;
1301:
1302: BEGIN
1303: fnd_file.put_line(FND_FILE.LOG,'Open PO Check');

Line 1388: FROM WIP_DJ_CLOSE_TEMP WDCT

1384:
1385: /*Bug 9877786(FP of 9791544)*/
1386: CURSOR c_delivered_qty IS
1387: SELECT WIP_ENTITY_NAME
1388: FROM WIP_DJ_CLOSE_TEMP WDCT
1389: WHERE wdct.GROUP_ID = p_group_id
1390: AND wdct.ORGANIZATION_ID = p_organization_id
1391: AND EXISTS
1392: (SELECT '1'

Line 1406: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;

1402: AND PD2.LINE_LOCATION_ID IS NOT NULL
1403: AND PD2.PO_LINE_ID IS NOT NULL)
1404: );
1405:
1406: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1407: l_failed_counter NUMBER ;
1408:
1409: BEGIN
1410: fnd_file.put_line(FND_FILE.LOG,'Delivery Quantity Check');

Line 1438: UPDATE WIP_DJ_CLOSE_TEMP

1434: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1435: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1436: end if ;
1437: /*Bug 13625290*/
1438: UPDATE WIP_DJ_CLOSE_TEMP
1439: SET STATUS_TYPE = 99
1440: WHERE WIP_ENTITY_NAME = l_failed_jobs ;
1441:
1442: EXIT WHEN c_delivered_qty%NOTFOUND ;

Line 1451: FROM WIP_DJ_CLOSE_TEMP

1447: UPDATE WIP_DISCRETE_JOBS
1448: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
1449: WHERE WIP_ENTITY_ID IN
1450: (SELECT WIP_ENTITY_ID
1451: FROM WIP_DJ_CLOSE_TEMP
1452: WHERE GROUP_ID = p_group_id
1453: AND ORGANIZATION_ID = p_organization_id
1454: AND STATUS_TYPE = 99);
1455:

Line 1456: DELETE FROM WIP_DJ_CLOSE_TEMP

1452: WHERE GROUP_ID = p_group_id
1453: AND ORGANIZATION_ID = p_organization_id
1454: AND STATUS_TYPE = 99);
1455:
1456: DELETE FROM WIP_DJ_CLOSE_TEMP
1457: WHERE GROUP_ID = p_group_id
1458: AND ORGANIZATION_ID = p_organization_id
1459: AND STATUS_TYPE = 99;
1460:

Line 1583: wip_dj_close_temp wdct

1579: /* fix for bug 8681037 (FP 8461467) */
1580:
1581: /* SELECT wrv.reservation_id
1582: FROM wip_reservations_v wrv,
1583: wip_dj_close_temp wdct
1584: WHERE wdct.organization_id = p_organization_id
1585: AND wdct.group_id = p_group_id
1586: AND wdct.wip_entity_id = wrv.wip_entity_id;
1587: */

Line 1591: wip_dj_close_temp wdct, -- otimizacao

1587: */
1588: select /*+ leading(wdct) index(mr MTL_RESERVATIONS_N9) */ -- otimizacao
1589: mr.reservation_id
1590: from
1591: wip_dj_close_temp wdct, -- otimizacao
1592: mtl_reservations mr, -- otimizacao
1593: mtl_sales_orders mso, -- otimizacao
1594: oe_order_lines_all ool -- otimizacao
1595: where ((wdct.organization_id= p_organization_id and wdct.group_id= p_group_id)

Line 1770: FROM WIP_DJ_CLOSE_TEMP TEMP,

1766: fnd_file.put_line(FND_FILE.LOG,'Report Quantity Precision');
1767:
1768: SELECT COUNT(*)
1769: INTO l_std_asst_jobs
1770: FROM WIP_DJ_CLOSE_TEMP TEMP,
1771: WIP_DISCRETE_JOBS WDJ,
1772: WIP_ACCOUNTING_CLASSES WAC
1773: WHERE WDJ.WIP_ENTITY_ID = TEMP.WIP_ENTITY_ID
1774: AND TEMP.ORGANIZATION_ID = p_organization_id

Line 1788: FROM WIP_DJ_CLOSE_TEMP TEMP,

1784: WIP_CONSTANTS.EAM_CLASS ) ;
1785:
1786: SELECT COUNT(*)
1787: INTO l_expense_jobs
1788: FROM WIP_DJ_CLOSE_TEMP TEMP,
1789: WIP_DISCRETE_JOBS WDJ,
1790: WIP_ACCOUNTING_CLASSES WAC
1791: WHERE WDJ.WIP_ENTITY_ID = TEMP.WIP_ENTITY_ID
1792: AND TEMP.ORGANIZATION_ID = p_organization_id

Line 2110: SAVEPOINT wip_close; --Bug#14285578- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back

2106: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.wip_close',
2107: p_params => l_params,
2108: x_returnStatus => l_return_Status);
2109: END IF;
2110: SAVEPOINT wip_close; --Bug#14285578- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back
2111:
2112: IF ( p_select_jobs = l_at_submission_time) THEN
2113:
2114: /***************************************************/

Line 2248: FROM wip_dj_close_temp

2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id
2246: WHERE organization_id = p_organization_id
2247: AND wip_entity_id in (SELECT wip_entity_id
2248: FROM wip_dj_close_temp
2249: WHERE group_id = l_group_id
2250: AND organization_id = p_organization_id);
2251:
2252: /*Bug 6908428: Updating the status in eam_work_order_details pending close for eam workorders */

Line 2283: SAVEPOINT wip_close; --Bug#13639508- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back

2279: l_group_id := p_group_id ;
2280:
2281: END IF ;
2282:
2283: SAVEPOINT wip_close; --Bug#13639508- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back
2284: fnd_file.put_line(FND_FILE.LOG,'GROUP ID '||to_char(l_group_id));
2285:
2286: /*Fix bug 9250439*/
2287: SELECT COUNT(*)

Line 2289: FROM WIP_DJ_CLOSE_TEMP

2285:
2286: /*Fix bug 9250439*/
2287: SELECT COUNT(*)
2288: INTO l_jobs_to_close
2289: FROM WIP_DJ_CLOSE_TEMP
2290: WHERE GROUP_ID = l_group_id
2291: AND ROWNUM = 1;
2292:
2293: IF (l_jobs_to_close = 0) THEN

Line 2552: FROM WIP_DJ_CLOSE_TEMP

2548:
2549: IF p_act_close_date IS NULL THEN
2550: SELECT MAX(ACTUAL_CLOSE_DATE)
2551: INTO l_acct_period_close_date
2552: FROM WIP_DJ_CLOSE_TEMP
2553: WHERE GROUP_ID = l_group_id;
2554: END IF;
2555:
2556: SELECT ACCT_PERIOD_ID

Line 2592: SAVEPOINT wip_close; --Bug#13639508- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back

2588: * Costing Function updates *
2589: * *
2590: ******************************************/
2591:
2592: SAVEPOINT wip_close; --Bug#13639508- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back
2593:
2594: SELECT WIP_TRANSACTIONS_S.nextval
2595: INTO l_costing_group_id
2596: FROM DUAL;

Line 2640: FROM WIP_DJ_CLOSE_TEMP wdct,

2636: wdct.WIP_ENTITY_ID,
2637: wdct.WIP_ENTITY_NAME,
2638: we.ENTITY_TYPE,
2639: wdct.ACTUAL_CLOSE_DATE
2640: FROM WIP_DJ_CLOSE_TEMP wdct,
2641: ORG_ACCT_PERIODS oap,
2642: WIP_ENTITIES we
2643: WHERE wdct.GROUP_ID = l_group_id
2644: AND we.wip_entity_id = wdct.wip_entity_id

Line 2725: FROM WIP_DJ_CLOSE_TEMP wdct

2721: LOOP
2722: BEGIN
2723: UPDATE WIP_DISCRETE_JOBS wdj
2724: SET DATE_CLOSED = (SELECT wdct.ACTUAL_CLOSE_DATE
2725: FROM WIP_DJ_CLOSE_TEMP wdct
2726: WHERE wdct.ORGANIZATION_ID = p_organization_id
2727: AND wdj.ORGANIZATION_ID = p_organization_id
2728: AND wdj.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
2729: AND wdct.GROUP_ID = l_group_id),

Line 2736: FROM WIP_DJ_CLOSE_TEMP

2732: last_update_login = fnd_global.login_id,
2733: STATUS_TYPE = WIP_CONSTANTS.CLOSED
2734: WHERE ORGANIZATION_ID = p_organization_id
2735: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2736: FROM WIP_DJ_CLOSE_TEMP
2737: WHERE ORGANIZATION_ID = p_organization_id
2738: AND GROUP_ID = l_group_id);
2739: EXIT;
2740: EXCEPTION

Line 2761: FROM WIP_DJ_CLOSE_TEMP wdct

2757: last_updated_by = fnd_global.user_id,
2758: last_update_login = fnd_global.login_id
2759: WHERE ORGANIZATION_ID = p_organization_id
2760: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
2761: FROM WIP_DJ_CLOSE_TEMP wdct
2762: WHERE wdct.ORGANIZATION_ID = p_organization_id
2763: AND wdct.GROUP_ID = l_group_id);
2764:
2765:

Line 2798: FROM WIP_DJ_CLOSE_TEMP

2794:
2795:
2796: SELECT COUNT(*)
2797: INTO l_num_close
2798: FROM WIP_DJ_CLOSE_TEMP
2799: WHERE ORGANIZATION_ID = p_organization_id
2800: AND GROUP_ID = l_group_id;
2801:
2802: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));

Line 2811: DELETE FROM WIP_DJ_CLOSE_TEMP

2807: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2808:
2809:
2810: IF ( l_num_close > 0 ) THEN
2811: DELETE FROM WIP_DJ_CLOSE_TEMP
2812: WHERE ORGANIZATION_ID = p_organization_id
2813: AND GROUP_ID = l_group_id;
2814: END IF;
2815:

Line 2833: rollback TO wip_close;--Bug#13639508- Rollback to the savepoint so that insertion into wip_dj_close_temp is not rolled back

2829: COMMIT ;
2830:
2831: EXCEPTION
2832: WHEN others THEN
2833: rollback TO wip_close;--Bug#13639508- Rollback to the savepoint so that insertion into wip_dj_close_temp is not rolled back
2834:
2835: fnd_file.put_line( FND_FILE.LOG,'Exception has occured');
2836: x_returnStatus := FND_API.G_RET_STS_ERROR ;
2837: /* Update jobs to Failed Close status */

Line 2881: FROM WIP_DJ_CLOSE_TEMP

2877: last_update_login = fnd_global.login_id,
2878: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
2879: WHERE ORGANIZATION_ID = p_organization_id
2880: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2881: FROM WIP_DJ_CLOSE_TEMP
2882: WHERE ORGANIZATION_ID = p_organization_id
2883: AND GROUP_ID = l_group_id);
2884:
2885: /* Clean up Temp Table */

Line 2887: DELETE FROM WIP_DJ_CLOSE_TEMP

2883: AND GROUP_ID = l_group_id);
2884:
2885: /* Clean up Temp Table */
2886:
2887: DELETE FROM WIP_DJ_CLOSE_TEMP
2888: WHERE ORGANIZATION_ID = p_organization_id
2889: AND GROUP_ID = l_group_id;
2890:
2891: --