APPS.XNP_WF_STANDARD dependencies on XDP_WORKLIST_DETAILS

Line 6: -- workitem parameters in xdp_worklist_details.

2: /* $Header: XNPWFACB.pls 120.0 2005/05/30 11:48:18 appldev noship $ */
3:
4:
5: -- Copies Item attributes defined in workflow to the equivalant
6: -- workitem parameters in xdp_worklist_details.
7:
8: Procedure downloadFAParams( itemtype IN VARCHAR2,
9: itemkey IN VARCHAR2,
10: actid IN NUMBER,

Line 1611: FROM xdp_worklist_details

1607:
1608:
1609: CURSOR c_get_params (cv_wi_instance_id NUMBER)IS
1610: SELECT parameter_name, parameter_value, parameter_ref_value
1611: FROM xdp_worklist_details
1612: WHERE workitem_instance_id = cv_wi_instance_id;
1613:
1614: e_EXECUTE_FA EXCEPTION;
1615: x_progress VARCHAR2(2000);

Line 7608: FROM xdp_worklist_details

7604: Procedure downloadWIParams(itemtype in varchar2, itemkey in varchar2) IS
7605:
7606: CURSOR c_get_params (cv_wi_instance_id NUMBER)IS
7607: SELECT parameter_name
7608: FROM xdp_worklist_details
7609: WHERE workitem_instance_id = cv_wi_instance_id
7610: FOR UPDATE;
7611:
7612:

Line 7633: UPDATE xdp_worklist_details

7629: BEGIN
7630: l_param_val := wf_engine.GetItemAttrText(itemtype => downloadWIParams.itemtype,
7631: itemkey => downloadWIParams.itemkey,
7632: aname => l_param_name);
7633: UPDATE xdp_worklist_details
7634: SET parameter_value = l_param_val,
7635: LAST_UPDATE_DATE = sysdate,
7636: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7637: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID