APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on OE_ORDER_HEADERS_ALL

Line 52: l_blanket_number OE_ORDER_HEADERS_ALL.BLANKET_NUMBER%TYPE;

48: -- Create appropriate cursor statements (use p_doc_id parameter)
49:
50: l_api_name CONSTANT VARCHAR2(30) := 'GET_OE_HEADER_VALUES';
51:
52: l_blanket_number OE_ORDER_HEADERS_ALL.BLANKET_NUMBER%TYPE;
53: l_user_status_code OE_ORDER_HEADERS_ALL.USER_STATUS_CODE%TYPE;
54: l_context OE_ORDER_HEADERS_ALL.CONTEXT%TYPE;
55:
56:

Line 53: l_user_status_code OE_ORDER_HEADERS_ALL.USER_STATUS_CODE%TYPE;

49:
50: l_api_name CONSTANT VARCHAR2(30) := 'GET_OE_HEADER_VALUES';
51:
52: l_blanket_number OE_ORDER_HEADERS_ALL.BLANKET_NUMBER%TYPE;
53: l_user_status_code OE_ORDER_HEADERS_ALL.USER_STATUS_CODE%TYPE;
54: l_context OE_ORDER_HEADERS_ALL.CONTEXT%TYPE;
55:
56:
57: --

Line 54: l_context OE_ORDER_HEADERS_ALL.CONTEXT%TYPE;

50: l_api_name CONSTANT VARCHAR2(30) := 'GET_OE_HEADER_VALUES';
51:
52: l_blanket_number OE_ORDER_HEADERS_ALL.BLANKET_NUMBER%TYPE;
53: l_user_status_code OE_ORDER_HEADERS_ALL.USER_STATUS_CODE%TYPE;
54: l_context OE_ORDER_HEADERS_ALL.CONTEXT%TYPE;
55:
56:
57: --
58: -- Define Cursor to read the variable value for the document

Line 69: FROM OE_ORDER_HEADERS_ALL

65: Cursor l_oe_header_csr Is
66: SELECT BLANKET_NUMBER,
67: USER_STATUS_CODE,
68: CONTEXT
69: FROM OE_ORDER_HEADERS_ALL
70: WHERE HEADER_ID = p_doc_id;
71:
72: BEGIN
73: