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.XDP_INTERFACES dependencies on XDP_ORDER_HEADERS

Line 144: -- Private API which will update xdp_order_headers status_code

140: return_code OUT NOCOPY NUMBER,
141: error_description OUT NOCOPY VARCHAR2);
142:
143: --
144: -- Private API which will update xdp_order_headers status_code
145: --
146: --
147: PROCEDURE UPDATE_XDP_ORDER_STATUS
148: (p_order_id IN NUMBER ,

Line 280: SELECT XDP_ORDER_HEADERS_S.NextVal

276: l_workitem_name VARCHAR2(200);
277: l_order_id NUMBER;
278: BEGIN
279:
280: SELECT XDP_ORDER_HEADERS_S.NextVal
281: INTO l_order_id
282: FROM dual;
283:
284: l_ORDER_HEADER.order_number := 'DRC-'||TO_CHAR(l_order_id+1);

Line 422: FROM xdp_order_headers

418: BEGIN
419: IF p_order_version IS NOT NULL THEN
420: SELECT order_id
421: INTO lv_id
422: FROM xdp_order_headers
423: WHERE external_order_number = (p_order_number) and
424: external_order_version = (p_order_version);
425: ELSE
426: SELECT order_id

Line 428: FROM xdp_order_headers

424: external_order_version = (p_order_version);
425: ELSE
426: SELECT order_id
427: INTO lv_id
428: FROM xdp_order_headers
429: WHERE external_order_number = (p_order_number) and
430: external_order_version IS NULL;
431: END IF;
432:

Line 504: FROM xdp_order_line_items xoli, xdp_order_headers xoh

500: --Cursor to fetch the item_keys for the SFM-OM Interface flows to be cancelled.
501: */
502: CURSOR lc_intf_flow_keys (p_order_number NUMBER) IS
503: SELECT line_number
504: FROM xdp_order_line_items xoli, xdp_order_headers xoh
505: WHERE xoli.order_id = xoh.order_id
506: AND xoh.order_source = 'OE_ORDER_HEADERS_ALL'
507: AND xoh.order_id = p_order_number;
508:

Line 723: FROM xdp_order_headers

719: order_type
720: INTO lv_state,
721: lv_msg_id,
722: lv_order_type
723: FROM xdp_order_headers
724: WHERE order_id = p_sdp_order_id;
725:
726: --============================================================
727: -- Validate Order Type in High Availability Maintenance Mode

Line 936: FROM xdp_order_headers

932: END IF;
933:
934: SELECT status_code
935: INTO l_status_code
936: FROM xdp_order_headers
937: WHERE order_id = p_order_id
938: FOR UPDATE NOWAIT ;
939:
940: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

Line 942: dbg_msg := ('Aquired Lock on XDP_ORDER_HEADERS Calling UPDATE_XDP_ORDER_STATUS ');

938: FOR UPDATE NOWAIT ;
939:
940: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
941: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_INTERFACES.CANCEL_STANDBY_ORDER')) THEN
942: dbg_msg := ('Aquired Lock on XDP_ORDER_HEADERS Calling UPDATE_XDP_ORDER_STATUS ');
943: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
944: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_INTERFACES.CANCEL_STANDBY_ORDER', dbg_msg);
945: END IF;
946: END IF;

Line 949: -- update status_code of the XDP_ORDER_HEADERS

945: END IF;
946: END IF;
947: END IF;
948:
949: -- update status_code of the XDP_ORDER_HEADERS
950:
951: UPDATE_XDP_ORDER_STATUS
952: (p_order_id => p_order_id,
953: p_status => 'CANCELED',

Line 1168: FROM xdp_order_headers

1164: END IF;
1165:
1166: SELECT wf_item_type, wf_item_key
1167: INTO l_main_wf_item_type, l_main_wf_item_key
1168: FROM xdp_order_headers
1169: WHERE order_id = p_sdp_order_id;
1170:
1171: IF (l_main_wf_item_type IS NOT NULL AND l_main_wf_item_key IS NOT NULL) THEN
1172: BEGIN --For the exceptions from the WF API call.

Line 1316: FROM xdp_order_headers

1312: lv_item_type,
1313: lv_item_key,
1314: lv_state,
1315: lv_msg_id
1316: FROM xdp_order_headers
1317: WHERE order_id = p_sdp_order_id
1318: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;
1319:
1320: -- Order has already been canceled

Line 1318: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;

1314: lv_state,
1315: lv_msg_id
1316: FROM xdp_order_headers
1317: WHERE order_id = p_sdp_order_id
1318: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;
1319:
1320: -- Order has already been canceled
1321: IF lv_state IN ('CANCELED','ABORTED') THEN
1322:

Line 1547: FROM xdp_order_headers oh

1543: END LOOP;
1544:
1545: SELECT oh.status_code --- ?? Do I need to lock it again ?
1546: INTO lv_state
1547: FROM xdp_order_headers oh
1548: WHERE oh.order_id = p_sdp_order_id
1549: FOR UPDATE OF oh.status_code NOWAIT;
1550:
1551: IF lv_state IN ('CANCELED','ABORTED') then

Line 1692: FROM xdp_order_headers

1688: lv_item_type,
1689: lv_item_key,
1690: lv_state,
1691: lv_msg_id
1692: FROM xdp_order_headers
1693: WHERE order_id = p_sdp_order_id
1694: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;
1695:
1696: -- Order has already been canceled

Line 1694: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;

1690: lv_state,
1691: lv_msg_id
1692: FROM xdp_order_headers
1693: WHERE order_id = p_sdp_order_id
1694: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;
1695:
1696: -- Order has already been canceled
1697: IF lv_state IN ('CANCELED','ABORTED') THEN
1698: return_code := -191315;

Line 1739: update xdp_order_headers

1735:
1736: -- No Order Workflow has been started
1737: -- Simply update the state to CANCELED
1738:
1739: update xdp_order_headers
1740: set last_updated_by = FND_GLOBAL.USER_ID,
1741: last_update_date = sysdate,
1742: last_update_login = FND_GLOBAL.LOGIN_ID,
1743: status_code = 'CANCELED',

Line 1860: from xdp_order_headers

1856: savepoint lv_order_tag2;
1857:
1858: select status_code
1859: into lv_state
1860: from xdp_order_headers
1861: where order_id = p_sdp_order_id
1862: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE ;
1863:
1864: if lv_state IN ('CANCELED','ABORTED') then

Line 1862: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE ;

1858: select status_code
1859: into lv_state
1860: from xdp_order_headers
1861: where order_id = p_sdp_order_id
1862: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE ;
1863:
1864: if lv_state IN ('CANCELED','ABORTED') then
1865: return_code := -191315;
1866: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');

Line 1878: update xdp_order_headers

1874: FND_MESSAGE.SET_TOKEN('ORDER_ID', p_sdp_order_id);
1875: error_description := FND_MESSAGE.GET;
1876: return;
1877: else
1878: update xdp_order_headers
1879: set last_updated_by = FND_GLOBAL.USER_ID,
1880: last_update_date = sysdate,
1881: last_update_login = FND_GLOBAL.LOGIN_ID,
1882: status_code = 'CANCELED',

Line 2138: from xdp_order_headers

2134: return_code := 0;
2135:
2136: select wf_item_type,wf_item_key
2137: into lv_type, lv_key
2138: from xdp_order_headers
2139: where order_id = p_sdp_order_id;
2140:
2141:
2142: FOR lv_wf_rec IN lc_wf_process(lv_type,lv_key) LOOP

Line 2294: XDP_ORDER_HEADERS

2290: x_state ,
2291: x_completion_date,
2292: x_cancellation_date
2293: from
2294: XDP_ORDER_HEADERS
2295: WHERE
2296: order_id = p_sdp_order_id;
2297:
2298: EXCEPTION

Line 2342: XDP_ORDER_HEADERS

2338: x_state,
2339: x_completion_date,
2340: x_cancellation_date
2341: from
2342: XDP_ORDER_HEADERS
2343: WHERE
2344: external_order_number = (p_order_number) and
2345: NVL(external_order_version,'-1') = NVL((p_order_version),'-1') ;
2346:

Line 2443: XDP_ORDER_HEADERS ohr

2439: x_completion_date,
2440: x_cancellation_date
2441: from
2442: XDP_ORDER_LINE_ITEMS olm,
2443: XDP_ORDER_HEADERS ohr
2444: WHERE
2445: olm.order_id = ohr.order_id and
2446: ohr.external_order_number = (p_order_number) and
2447: NVL(ohr.external_order_version,'-1') = NVL((p_order_version) ,'-1') and

Line 2492: XDP_ORDER_HEADERS ohr

2488: olm.completion_date,
2489: olm.cancel_provisioning_date
2490: from
2491: XDP_ORDER_LINE_ITEMS olm,
2492: XDP_ORDER_HEADERS ohr
2493: WHERE
2494: olm.order_id = ohr.order_id and
2495: ohr.external_order_number = (p_order_number) and
2496: NVL(ohr.external_order_version,'-1') = NVL((p_order_version) ,'-1') and

Line 3055: FROM XDP_ORDER_HEADERS

3051: x_order_status.order_number,
3052: x_order_status.order_version,
3053: x_order_status.actual_fulfillment_date,
3054: x_order_status.completion_date
3055: FROM XDP_ORDER_HEADERS
3056: WHERE order_id = p_order_id;
3057:
3058: BEGIN
3059: x_order_status.fulfillment_status := XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS');

Line 3191: FROM XDP_ORDER_HEADERS

3187: x_order_header.attribute17,
3188: x_order_header.attribute18,
3189: x_order_header.attribute19,
3190: x_order_header.attribute20
3191: FROM XDP_ORDER_HEADERS
3192: WHERE order_id = p_order_id;
3193: x_order_header.execution_mode := NULL;
3194: x_order_header.account_number:= NULL;
3195: x_order_header.fulfillment_status := NULL;

Line 3379: FROM XDP_ORDER_HEADERS

3375: l_order_id := p_order_id;
3376:
3377: IF l_order_id IS NULL THEN
3378: SELECT order_id into l_order_id
3379: FROM XDP_ORDER_HEADERS
3380: WHERE EXTERNAL_ORDER_NUMBER = (p_order_number)
3381: AND NVL(EXTERNAL_ORDER_VERSION,'-1') = NVL((p_order_version),'-1') ;
3382: END IF;
3383:

Line 3423: FROM XDP_ORDER_HEADERS

3419: l_order_id := p_order_id;
3420:
3421: IF l_order_id IS NULL THEN
3422: SELECT order_id into l_order_id
3423: FROM XDP_ORDER_HEADERS
3424: WHERE EXTERNAL_ORDER_NUMBER = (p_order_number)
3425: AND NVL(EXTERNAL_ORDER_VERSION,'-1') = NVL((p_order_version),'-1') ;
3426: END IF;
3427:

Line 3821: -- Private API which will update xdp_order_headers status_code

3817: END CANCEL_WORKITEM;
3818:
3819:
3820: --
3821: -- Private API which will update xdp_order_headers status_code
3822: --
3823: --
3824: PROCEDURE update_xdp_order_status
3825: (p_order_id IN NUMBER ,

Line 3842: UPDATE xdp_order_headers

3838: END IF;
3839: END IF;
3840: END IF;
3841:
3842: UPDATE xdp_order_headers
3843: SET last_updated_by = FND_GLOBAL.USER_ID,
3844: last_update_date = sysdate,
3845: last_update_login = FND_GLOBAL.LOGIN_ID,
3846: status_code = p_status,