APPS.IBE_OM_INTEGRATION_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 38: l_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;

34: l_messageName WF_MESSAGES.NAME%TYPE;
35: l_msgEnabled VARCHAR2(3);
36: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
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;

Line 39: l_org_id OE_ORDER_HEADERS_ALL.ORG_ID%TYPE;

35: l_msgEnabled VARCHAR2(3);
36: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
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:

Line 47: FROM oe_order_headers_all

43:
44:
45: CURSOR c_get_ord_num(p_order_header_id NUMBER) IS
46: SELECT order_number, org_id
47: FROM oe_order_headers_all
48: WHERE header_id = p_order_header_id;
49:
50: CURSOR c_get_party_id(p_order_header_id NUMBER) IS
51: SELECT fnd.customer_id

Line 53: oe_order_headers_all oe

49:
50: CURSOR c_get_party_id(p_order_header_id NUMBER) IS
51: SELECT fnd.customer_id
52: FROM fnd_user fnd,
53: oe_order_headers_all oe
54: WHERE oe.header_id = p_order_header_id
55: AND oe.created_by = fnd.user_id;
56:
57: CURSOR c_get_reject_reason_desc(p_reject_reason_code VARCHAR2) IS