APPS.XDP_INTERFACES dependencies on XDP_FA_RUNTIME_LIST

Line 180: -- Private API which will update xdp_fa_runtime_list status_code

176: return_code OUT NOCOPY NUMBER,
177: error_description OUT NOCOPY VARCHAR2) ;
178:
179: --
180: -- Private API which will update xdp_fa_runtime_list status_code
181: --
182: --
183:
184: PROCEDURE UPDATE_XDP_FA_INSTANCE_STATUS

Line 347: xdp_fa_runtime_list fr

343:
344: CURSOR c_fa IS
345: SELECT 'Y'
346: FROM xdp_fulfill_worklist fw,
347: xdp_fa_runtime_list fr
348: WHERE fw.order_id = p_order_id
349: AND fw.workitem_instance_id = fr.workitem_instance_id
350: AND fr.status_code IN ('IN PROGRESS');
351:

Line 1268: FROM xdp_fa_runtime_list frt,

1264: frt.msgid,
1265: frt.status_code ,
1266: frt.wf_item_type,
1267: frt.wf_item_key
1268: FROM xdp_fa_runtime_list frt,
1269: xdp_fulfill_worklist fwt
1270: WHERE fwt.order_id = l_order_id and
1271: fwt.workitem_instance_id = frt.workitem_instance_id;
1272:

Line 1387: FROM xdp_fa_runtime_list fr

1383: LOOP
1384:
1385: SELECT fr.status_code
1386: INTO lv_state
1387: FROM xdp_fa_runtime_list fr
1388: WHERE fa_instance_id = c_fa_rec.fa_instance_id
1389: FOR UPDATE OF fr.status_code NOWAIT;
1390:
1391: IF lv_state IN ('CANCELED','ABORTED') THEN

Line 1660: FROM xdp_fa_runtime_list frt,

1656:
1657: CURSOR lc_fa(l_order_id NUMBER) IS
1658: SELECT fa_instance_id,
1659: frt.msgid
1660: FROM xdp_fa_runtime_list frt,
1661: xdp_fulfill_worklist fwt
1662: WHERE fwt.order_id = l_order_id and
1663: fwt.workitem_instance_id = frt.workitem_instance_id;
1664:

Line 1789: from xdp_fa_runtime_list

1785:
1786: FOR lv_fa_rec in lc_fa(p_sdp_order_id)
1787: loop
1788: select status_code into lv_state
1789: from xdp_fa_runtime_list
1790: where fa_instance_id = lv_fa_rec.fa_instance_id;
1791:
1792: if lv_state IN ('CANCELED','ABORTED','SUCCESS','SUCCESS_WITH_OVERRIDE') then
1793: null;

Line 2026: update xdp_fa_runtime_list

2022: IF lv_lock_status = G_LOCK_MSG_SUCCESS THEN
2023: -- Great, we had lock and remove the FA from queue
2024: lv_lock := 'N';
2025:
2026: update xdp_fa_runtime_list
2027: set last_updated_by = FND_GLOBAL.USER_ID,
2028: last_update_date = sysdate,
2029: last_update_login = FND_GLOBAL.LOGIN_ID,
2030: status_code = 'CANCELED',

Line 2051: from xdp_fa_runtime_list

2047: wf_item_key
2048: into lv_state,
2049: lv_item_type,
2050: lv_item_key
2051: from xdp_fa_runtime_list
2052: where fa_instance_id = p_fa_instance_id
2053: for update of status_code;
2054:
2055: if lv_state in ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED') THEN

Line 2059: update xdp_fa_runtime_list

2055: if lv_state in ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED') THEN
2056: rollback to lv_fa_tag;
2057: return;
2058: else
2059: update xdp_fa_runtime_list
2060: set last_updated_by = FND_GLOBAL.USER_ID,
2061: last_update_date = sysdate,
2062: last_update_login = FND_GLOBAL.LOGIN_ID,
2063: status_code = 'CANCELED',

Line 3950: -- Private API which will update xdp_fa_runtime_list status_code

3946: error_description := FND_MESSAGE.GET;
3947: END UPDATE_XDP_WI_INSTANCE_STATUS;
3948:
3949: --
3950: -- Private API which will update xdp_fa_runtime_list status_code
3951: --
3952: --
3953:
3954: PROCEDURE UPDATE_XDP_FA_INSTANCE_STATUS

Line 3971: UPDATE xdp_fa_runtime_list

3967: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'xdp.plsql.XDP_INTERFACES.UPDATE_XDP_FA_INSTANCE_STATUS', dbg_msg);
3968: END IF;
3969: END IF;
3970: END IF;
3971: UPDATE xdp_fa_runtime_list
3972: SET last_updated_by = FND_GLOBAL.USER_ID,
3973: last_update_date = sysdate,
3974: last_update_login = FND_GLOBAL.LOGIN_ID,
3975: status_code = p_status,