APPS.XNP_WF_STANDARD dependencies on XDP_FA_DETAILS

Line 1665: -- STEP2: Download Work Item params from workflow to the xdp_fa_details table..

1661: l_FA_NAME,
1662: l_FE_NAME);
1663:
1664:
1665: -- STEP2: Download Work Item params from workflow to the xdp_fa_details table..
1666: downloadFAParams( EXECUTE_FA_N_SYNC_WI_PAR.itemtype,
1667: EXECUTE_FA_N_SYNC_WI_PAR.itemkey,
1668: EXECUTE_FA_N_SYNC_WI_PAR.actid,
1669: l_FA_INSTANCE_ID );

Line 7666: FROM xdp_fa_details

7662: l_param_value VARCHAR2(4000);
7663:
7664: CURSOR c_get_fa_params( cv_fa_instance_id NUMBER ) IS
7665: SELECT parameter_name
7666: FROM xdp_fa_details
7667: WHERE fa_instance_id = cv_fa_instance_id
7668: FOR UPDATE;
7669:
7670: BEGIN

Line 7689: UPDATE xdp_fa_details

7685: --get Item attribute value..
7686: l_param_value := wf_engine.GetItemAttrText(itemtype => downloadFAParams.itemtype,
7687: itemkey => downloadFAParams.itemkey,
7688: aname => l_item_attrib_name);
7689: UPDATE xdp_fa_details
7690: SET parameter_value = l_param_value,
7691: LAST_UPDATE_DATE = sysdate,
7692: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7693: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 7722: FROM xdp_fa_details

7718: l_param_value VARCHAR2(4000);
7719:
7720: CURSOR c_get_fa_params( cv_fa_instance_id NUMBER ) IS
7721: SELECT parameter_name, parameter_value
7722: FROM xdp_fa_details
7723: WHERE fa_instance_id = cv_fa_instance_id;
7724:
7725: BEGIN
7726: