APPS.XDPSTATUS dependencies on XDP_FA_RUNTIME_LIST

Line 1332: FROM XDP_FA_RUNTIME_LIST

1328:
1329: CURSOR c_GetFA(WIInstanceID NUMBER) IS
1330: SELECT STATUS_CODE,
1331: FA_INSTANCE_ID
1332: FROM XDP_FA_RUNTIME_LIST
1333: WHERE WORKITEM_INSTANCE_ID = WIInstanceID ;
1334:
1335: BEGIN
1336:

Line 1605: FROM xdp_fa_runtime_list

1601: l_FAStatus varchar2(40);
1602:
1603: cursor cur_fa_status( cp_FAInstanceID in VARCHAR2 ) IS
1604: SELECT status_code
1605: FROM xdp_fa_runtime_list
1606: WHERE fa_instance_id = cp_FAInstanceID;
1607:
1608: e_SendMessageException exception;
1609:

Line 2005: FROM XDP_FA_RUNTIME_LIST

2001: l_fA_status_code VARCHAR2(40);
2002:
2003: CURSOR c_GetFaStat IS
2004: SELECT Status_code
2005: FROM XDP_FA_RUNTIME_LIST
2006: WHERE FA_INSTANCE_ID = FAInstanceID;
2007: -- FOR UPDATE;
2008:
2009: x_progress VARCHAR2(2000);

Line 2069: FROM XDP_FA_RUNTIME_LIST

2065: -- FOR UPDATE;
2066:
2067: CURSOR c_GetFA IS
2068: SELECT 1
2069: FROM XDP_FA_RUNTIME_LIST
2070: WHERE WORKITEM_INSTANCE_ID = WorkitemInstanceID
2071: AND STATUS_CODE = 'ERROR' ;
2072:
2073:

Line 2508: UPDATE xdp_fa_runtime_list

2504:
2505: BEGIN
2506: IF p_status IN ('IN PROGRESS','ERROR') THEN
2507:
2508: UPDATE xdp_fa_runtime_list
2509: SET status_code = p_status ,
2510: last_update_date = sysdate,
2511: last_updated_by = fnd_global.user_id,
2512: last_update_login = fnd_global.login_id

Line 2515: UPDATE xdp_fa_runtime_list

2511: last_updated_by = fnd_global.user_id,
2512: last_update_login = fnd_global.login_id
2513: WHERE fa_instance_id = p_fa_instance_id ;
2514: ELSE
2515: UPDATE xdp_fa_runtime_list
2516: SET status_code = p_status ,
2517: completion_date = sysdate ,
2518: last_update_date = sysdate,
2519: last_updated_by = fnd_global.user_id,

Line 2554: xdp_fa_runtime_list fr

2550: WHERE fw.order_id = oh.order_id
2551: AND fw.status_code = 'ERROR') OR
2552: EXISTS (SELECT 'Y'
2553: FROM xdp_fulfill_worklist fw,
2554: xdp_fa_runtime_list fr
2555: WHERE fw.workitem_instance_id = fr.workitem_instance_id
2556: AND fw.order_id = oh.order_id
2557: AND fr.status_code = 'ERROR')) ;
2558:

Line 2595: xdp_fa_runtime_list fr

2591: WHERE fw.line_item_id = oli.line_item_id
2592: AND fw.status_code = 'ERROR') OR
2593: EXISTS (SELECT 'Y'
2594: FROM xdp_fulfill_worklist fw,
2595: xdp_fa_runtime_list fr
2596: WHERE fw.workitem_instance_id = fr.workitem_instance_id
2597: AND fw.line_item_id = oli.line_item_id
2598: AND fr.status_code = 'ERROR')) ;
2599:

Line 2610: xdp_fa_runtime_list fr

2606: WHERE fw.line_item_id = lr.line_item_id
2607: AND fw.status_code = 'ERROR') OR
2608: EXISTS (SELECT 'Y'
2609: FROM xdp_fulfill_worklist fw,
2610: xdp_fa_runtime_list fr
2611: WHERE fw.workitem_instance_id = fr.workitem_instance_id
2612: AND fw.line_item_id = lr.line_item_id
2613: AND fr.status_code = 'ERROR')) ;
2614: BEGIN

Line 2650: FROM xdp_fa_runtime_list fr

2646: SELECT 'Y'
2647: FROM xdp_fulfill_worklist fw
2648: WHERE workitem_instance_id = p_WIInstance_id
2649: AND EXISTS (SELECT 'Y'
2650: FROM xdp_fa_runtime_list fr
2651: WHERE fr.workitem_instance_id = fw.workitem_instance_id
2652: AND fr.status_code = 'ERROR') ;
2653:
2654: BEGIN

Line 2672: FROM xdp_fa_runtime_list fr

2668: l_status BOOLEAN := FALSE ;
2669:
2670: CURSOR c_fa IS
2671: SELECT 'Y'
2672: FROM xdp_fa_runtime_list fr
2673: WHERE fr.fa_instance_id = p_FAInstance_id
2674: AND fr.status_code = 'ERROR' ;
2675:
2676: BEGIN

Line 2751: FROM xdp_fa_runtime_list

2747: WHERE workitem_instance_id = p_WIInstance_id;
2748:
2749: cursor cur_fa_status is
2750: SELECT status_code
2751: FROM xdp_fa_runtime_list
2752: WHERE workitem_instance_id = p_WIInstance_id;
2753:
2754: l_status VARCHAR2(200);
2755: l_system_hold BOOLEAN := FALSE;