APPS.XDP_AQ_UTILITIES dependencies on XDP_ORDER_HEADERS

Line 264: update XDP_ORDER_HEADERS

260: message_properties => lv_MessageProperties,
261: payload =>lv_wf_object,
262: msgid => lv_MsgID);
263:
264: update XDP_ORDER_HEADERS
265: set
266: last_updated_by = FND_GLOBAL.USER_ID,
267: last_update_date = sysdate,
268: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 363: from xdp_order_headers

359: END;
360:
361: select state,previous_order_id,priority, provisioning_date
362: into lv_state,lv_order_id,lv_priority, lv_prov_date
363: from xdp_order_headers
364: where
365: order_id = lv_wf_object.order_id;
366:
367: if lv_state = 'SUSPENDED' THEN

Line 375: from xdp_order_headers

371: elsif lv_state IN ('WAIT','HOLD') THEN
372: if lv_order_id is not null then
373: begin
374: select state into lv_state2
375: from xdp_order_headers
376: where order_id = lv_order_id;
377: exception
378: when no_data_found then
379: lv_state2 := 'CANCELED';

Line 528: from xdp_order_headers

524: -- SetContext(lv_MessageProperties.sender_id.name)
525:
526: select state,previous_order_id,priority, provisioning_date
527: into lv_state,lv_order_id,lv_priority,lv_prov_date
528: from xdp_order_headers
529: where
530: order_id = lv_wf_object.order_id;
531:
532: if lv_state = 'SUSPENDED' THEN

Line 540: from xdp_order_headers

536: elsif lv_state IN ('WAIT','HOLD') THEN
537: if lv_order_id is not null then
538: begin
539: select state into lv_state2
540: from xdp_order_headers
541: where order_id = lv_order_id;
542: exception
543: when no_data_found then
544: lv_state2 := 'CANCELED';

Line 668: update XDP_ORDER_HEADERS

664: payload =>lv_wf_object,
665: msgid => lv_MsgID);
666:
667:
668: update XDP_ORDER_HEADERS
669: set last_updated_by = FND_GLOBAL.USER_ID,
670: last_update_date = sysdate,
671: last_update_login = FND_GLOBAL.LOGIN_ID,
672: status_code = 'READY',

Line 753: FROM xdp_order_headers

749: END;
750:
751: SELECT status_code
752: INTO lv_state
753: FROM xdp_order_headers
754: WHERE order_id = lv_wf_object.order_id;
755:
756: -- if lv_state = 'SUSPENDED' THEN
757: -- -- Update the msg delay to new high number

Line 3748: FROM xdp_order_headers

3744: SELECT count(*)
3745: INTO l_count
3746: FROM fnd_lookup_values
3747: WHERE UPPER(lookup_code) = ( SELECT UPPER(order_type)
3748: FROM xdp_order_headers
3749: WHERE order_id = l_order_id )
3750: AND lookup_type = 'XDP_HA_ORDER_TYPES';
3751:
3752: IF l_count < 1 THEN