APPS.XDP_AQ_UTILITIES dependencies on XDP_FULFILL_WORKLIST

Line 926: xdp_fulfill_worklist xfw

922: lv_workitem_name varchar2(40);
923: cursor c_GetWorkitemName is
924: select xw.workitem_name workitem_name
925: from xdp_workitems xw,
926: xdp_fulfill_worklist xfw
927: where xfw.workitem_instance_id = p_wi_instance_id
928: and xfw.workitem_id = xw.workitem_id;
929:
930: BEGIN

Line 968: update XDP_FULFILL_WORKLIST

964: message_properties => lv_MessageProperties,
965: payload =>lv_wf_object,
966: msgid => lv_MsgID);
967:
968: update XDP_FULFILL_WORKLIST
969: set last_updated_by = FND_GLOBAL.USER_ID,
970: last_update_date = sysdate,
971: last_update_login = FND_GLOBAL.LOGIN_ID,
972: STATUS_CODE = 'READY',

Line 1039: from xdp_fulfill_worklist

1035: END;
1036:
1037: select status_code
1038: into lv_state
1039: from xdp_fulfill_worklist
1040: where
1041: workitem_instance_id = lv_wf_object.workitem_instance_id;
1042:
1043: -- if lv_state = 'SUSPENDED' THEN

Line 1058: update XDP_FULFILL_WORKLIST

1054: message_properties => lv_MessageProperties,
1055: payload => lv_tmp,
1056: msgid => lv_MsgID);
1057:
1058: update XDP_FULFILL_WORKLIST
1059: set last_updated_by = FND_GLOBAL.USER_ID,
1060: last_update_date = sysdate,
1061: last_update_login = FND_GLOBAL.LOGIN_ID,
1062: STATUS_CODE = 'IN PROGRESS'

Line 1171: -- update XDP_FULFILL_WORKLIST

1167: end if;
1168:
1169: -- Commented out as this initialization is done in Work Item workflow by spusegao on 08/07/01
1170: --
1171: -- update XDP_FULFILL_WORKLIST
1172: -- set last_updated_by = FND_GLOBAL.USER_ID,
1173: -- last_update_date = sysdate,
1174: -- last_update_login = FND_GLOBAL.LOGIN_ID,
1175: -- STATUS_CODE = 'IN PROGRESS'

Line 1620: xdp_fulfill_worklist fwt

1616: fwt.status_code
1617: INTO lv_fa_state,
1618: lv_wi_state
1619: FROM xdp_fa_runtime_list frt,
1620: xdp_fulfill_worklist fwt
1621: WHERE fa_instance_id = lv_wf_object.fa_instance_id
1622: AND frt.workitem_instance_id = fwt.workitem_instance_id;
1623:
1624: IF (lv_fa_state <> 'CANCELED' OR

Line 3197: FROM xdp_fulfill_worklist

3193:
3194: BEGIN
3195: SELECT provisioning_date
3196: INTO l_prov_date
3197: FROM xdp_fulfill_worklist
3198: WHERE workitem_instance_id = p_workitem_instance_id ;
3199: RETURN l_prov_date;
3200: EXCEPTION
3201: WHEN OTHERS THEN