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_DISCRETE_JOBS

Line 82: WIP_DISCRETE_JOBS DJ,

78: WE.WIP_ENTITY_NAME,
79: DJ.PRIMARY_ITEM_ID,
80: DJ.STATUS_TYPE
81: FROM ORG_ACCT_PERIODS AP,
82: WIP_DISCRETE_JOBS DJ,
83: WIP_ENTITIES WE
84: WHERE DJ.ORGANIZATION_ID = p_organization_id
85: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID
86: AND AP.ORGANIZATION_ID = DJ.ORGANIZATION_ID

Line 200: WIP_DISCRETE_JOBS DJ ,

196: WE.WIP_ENTITY_NAME ,
197: DJ.PRIMARY_ITEM_ID ,
198: DJ.STATUS_TYPE
199: FROM ORG_ACCT_PERIODS AP ,
200: WIP_DISCRETE_JOBS DJ ,
201: WIP_ENTITIES WE
202: WHERE DJ.ORGANIZATION_ID = p_organization_id
203: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID
204: AND AP.ORGANIZATION_ID = DJ.ORGANIZATION_ID

Line 297: WIP_DISCRETE_JOBS DJ,

293: p_act_close_date,
294: x_group_id
295: BULK COLLECT INTO l_close_temp_tbl2
296: FROM ORG_ACCT_PERIODS AP,
297: WIP_DISCRETE_JOBS DJ,
298: WIP_ENTITIES WE
299: WHERE DJ.ORGANIZATION_ID = p_organization_id
300: AND WE.ORGANIZATION_ID = DJ.ORGANIZATION_ID
301: AND AP.ORGANIZATION_ID = DJ.ORGANIZATION_ID

Line 670: -- to update wip_discrete_jobs' status for those records.

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: --
673:
674: DELETE FROM wip_dj_close_temp wdct

Line 679: FROM wip_discrete_jobs wdj

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
679: FROM wip_discrete_jobs wdj
680: WHERE wdj.wip_entity_id = wdct.wip_entity_id AND
681: wdj.organization_id = p_organization_id)
682: RETURNING wdct.wip_entity_id
683: BULK COLLECT INTO l_failed_ids;

Line 694: -- update wip_discrete_jobs' status_type to fail_close.

690: x_returnstatus := FND_API.G_RET_STS_SUCCESS;
691: ELSE
692: --
693: -- Some invalid jobs found. Set expected error flag and
694: -- update wip_discrete_jobs' status_type to fail_close.
695: --
696: x_returnstatus := FND_API.G_RET_STS_ERROR;
697:
698: FORALL i IN l_failed_ids.FIRST .. l_failed_ids.LAST

Line 699: UPDATE wip_discrete_jobs

695: --
696: x_returnstatus := FND_API.G_RET_STS_ERROR;
697:
698: FORALL i IN l_failed_ids.FIRST .. l_failed_ids.LAST
699: UPDATE wip_discrete_jobs
700: SET status_type = WIP_CONSTANTS.FAIL_CLOSE
701: WHERE organization_id = p_organization_id AND
702: wip_entity_id = l_failed_ids(i);
703:

Line 829: UPDATE WIP_DISCRETE_JOBS

825:
826: EXIT WHEN c_pending_txns%NOTFOUND ;
827: END LOOP ;
828:
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

Line 975: UPDATE WIP_DISCRETE_JOBS

971: x_returnstatus := FND_API.G_RET_STS_ERROR;
972: END IF;
973: end loop;
974:
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

Line 1063: UPDATE WIP_DISCRETE_JOBS

1059: x_returnstatus := FND_API.G_RET_STS_ERROR;
1060: END IF;
1061: end loop;
1062:
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

Line 1197: UPDATE WIP_DISCRETE_JOBS

1193: EXIT WHEN c_pending_txns%NOTFOUND ;
1194: END LOOP ;
1195: fnd_file.put_line(FND_FILE.LOG,'Number of failed jobs because of past close date : '||l_failed_counter);
1196:
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

Line 1447: UPDATE WIP_DISCRETE_JOBS

1443: END LOOP ;
1444:
1445: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed in Delivered Quantity : '||to_char( l_failed_counter));
1446: /*Bug 13625290*/
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

Line 1771: WIP_DISCRETE_JOBS WDJ,

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
1775: AND WDJ.ORGANIZATION_ID = TEMP.ORGANIZATION_ID

Line 1789: WIP_DISCRETE_JOBS WDJ,

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
1793: AND WDJ.ORGANIZATION_ID = p_organization_id

Line 2238: UPDATE wip_discrete_jobs

2234: RAISE FND_API.G_EXC_ERROR ;
2235: END IF;
2236: /*Bug 6908428*/
2237:
2238: UPDATE wip_discrete_jobs
2239: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,
2240: request_id = fnd_global.conc_request_id ,
2241: last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,

Line 2723: UPDATE WIP_DISCRETE_JOBS wdj

2719: --Fix bug 15874569
2720: SAVEPOINT closingJob;
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

Line 2874: UPDATE WIP_DISCRETE_JOBS wdj

2870:
2871: /*Bug 6908428*/
2872:
2873:
2874: UPDATE WIP_DISCRETE_JOBS wdj
2875: SET LAST_UPDATE_DATE = SYSDATE,
2876: last_updated_by = fnd_global.user_id,
2877: last_update_login = fnd_global.login_id,
2878: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE