APPS.IBE_OM_INTEGRATION_GRP dependencies on WF_LOOKUPS

Line 41: l_reject_reason_desc WF_LOOKUPS.MEANING%TYPE;

37: l_url VARCHAR2(30) :=null;
38: l_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
39: l_org_id OE_ORDER_HEADERS_ALL.ORG_ID%TYPE;
40: l_usertype VARCHAR2(30);
41: l_reject_reason_desc WF_LOOKUPS.MEANING%TYPE;
42: l_reject_reason_code WF_LOOKUPS.LOOKUP_CODE%TYPE;
43:
44:
45: CURSOR c_get_ord_num(p_order_header_id NUMBER) IS

Line 42: l_reject_reason_code WF_LOOKUPS.LOOKUP_CODE%TYPE;

38: l_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
39: l_org_id OE_ORDER_HEADERS_ALL.ORG_ID%TYPE;
40: l_usertype VARCHAR2(30);
41: l_reject_reason_desc WF_LOOKUPS.MEANING%TYPE;
42: l_reject_reason_code WF_LOOKUPS.LOOKUP_CODE%TYPE;
43:
44:
45: CURSOR c_get_ord_num(p_order_header_id NUMBER) IS
46: SELECT order_number, org_id

Line 59: FROM wf_lookups

55: AND oe.created_by = fnd.user_id;
56:
57: CURSOR c_get_reject_reason_desc(p_reject_reason_code VARCHAR2) IS
58: SELECT meaning
59: FROM wf_lookups
60: WHERE lookup_type = 'OE_RMA_REJECTION_REASON'
61: AND lookup_code = p_reject_reason_code;
62:
63:

Line 226: -- get reject reason code meaning from wf_lookups

222: l_usertype:= NULL;
223:
224: ibe_workflow_pvt.getUserType(l_party_id,l_usertype);
225:
226: -- get reject reason code meaning from wf_lookups
227:
228: IF p_reject_reason_code is NULL THEN
229: l_reject_reason_code := 'NONE';
230: ELSE