APPS.OZF_RESALE_WF_PVT dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 2375: FROM wf_item_attribute_values wiav

2371: CURSOR wf_values_csr(p_item_type VARCHAR2,
2372: p_item_key VARCHAR2,
2373: p_name VARCHAR2) IS
2374: SELECT number_value
2375: FROM wf_item_attribute_values wiav
2376: WHERE wiav.item_type = p_item_type
2377: AND wiav.item_key like p_item_key||'%'
2378: AND wiav.name = p_name;
2379:

Line 3763: FROM wf_item_attribute_values wiav

3759: CURSOR wf_values_csr(p_item_type VARCHAR2,
3760: p_item_key VARCHAR2,
3761: p_name VARCHAR2) IS
3762: SELECT number_value
3763: FROM wf_item_attribute_values wiav
3764: WHERE wiav.item_type = p_item_type
3765: AND wiav.item_key like p_item_key||'%'
3766: AND wiav.name = p_name;
3767:

Line 4015: FROM wf_item_attribute_values wiav

4011: CURSOR wf_values_csr(p_item_type VARCHAR2,
4012: p_item_key VARCHAR2,
4013: p_name VARCHAR2) IS
4014: SELECT number_value
4015: FROM wf_item_attribute_values wiav
4016: WHERE wiav.item_type = p_item_type
4017: AND wiav.item_key like p_item_key||'%'
4018: AND wiav.name = p_name;
4019:

Line 4072: -- in case of Interface batch, no record in wf_item_attribute_values with Itemkey as p_batch_id ||'-'||to_char(sysdate,'MM/DD/YYYY HH:MI:SS')

4068: FETCH emp_infor_csr INTO l_emp_id;
4069: CLOSE emp_infor_csr;
4070:
4071: -- fix for bug 16066424
4072: -- in case of Interface batch, no record in wf_item_attribute_values with Itemkey as p_batch_id ||'-'||to_char(sysdate,'MM/DD/YYYY HH:MI:SS')
4073:
4074: l_user_id := l_user_id_fnd ;
4075: l_resp_id := l_resp_id_fnd ;
4076: