APPS.OTA_INITIALIZATION_WF dependencies on OE_ORDER_HEADERS

Line 55: l_order_number oe_order_headers.order_number%type;

51: p_process IN VARCHAR2)
52:
53: IS
54:
55: l_order_number oe_order_headers.order_number%type;
56: l_header_id oe_order_headers.header_id%type;
57: l_process wf_activities.name%type := upper(p_process);
58: l_itemkey wf_items.item_key%type := to_char(p_line_id);
59: l_owner_name per_people_f.full_name%type;

Line 56: l_header_id oe_order_headers.header_id%type;

52:
53: IS
54:
55: l_order_number oe_order_headers.order_number%type;
56: l_header_id oe_order_headers.header_id%type;
57: l_process wf_activities.name%type := upper(p_process);
58: l_itemkey wf_items.item_key%type := to_char(p_line_id);
59: l_owner_name per_people_f.full_name%type;
60: l_event_title ota_events_tl.title%type; --MLS change _tl added

Line 70: FROM OE_ORDER_HEADERS_ALL

66: CURSOR C_ORDER
67: IS
68: SELECT ORDER_NUMBER ,
69: HEADER_ID
70: FROM OE_ORDER_HEADERS_ALL
71: WHERE HEADER_ID IN(
72: SELECT HEADER_ID
73: FROM OE_ORDER_LINES_ALL
74: WHERE LINE_ID = p_line_id);

Line 184: OE_ORDER_HEADERS_ALL

180: SELECT
181: order_number ,
182: header_id
183: FROM
184: OE_ORDER_HEADERS_ALL
185: WHERE
186: HEADER_ID IN(
187: SELECT
188: HEADER_ID

Line 217: l_order_number oe_order_headers.order_number%type;

213:
214:
215: l_user_name varchar2(100);
216: l_full_name per_all_people_f.full_name%TYPE;
217: l_order_number oe_order_headers.order_number%type;
218: l_header_id oe_order_headers.header_id%type;
219: l_proc varchar2(72) := g_package||'initialize_cancel_event';
220: l_wf_date VARCHAR2(30);
221: l_item_key wf_items.item_key%TYPE;

Line 218: l_header_id oe_order_headers.header_id%type;

214:
215: l_user_name varchar2(100);
216: l_full_name per_all_people_f.full_name%TYPE;
217: l_order_number oe_order_headers.order_number%type;
218: l_header_id oe_order_headers.header_id%type;
219: l_proc varchar2(72) := g_package||'initialize_cancel_event';
220: l_wf_date VARCHAR2(30);
221: l_item_key wf_items.item_key%TYPE;
222: l_line_number oe_order_lines_all.line_number%type;

Line 364: OE_ORDER_HEADERS_ALL

360: SELECT
361: order_number ,
362: header_id
363: FROM
364: OE_ORDER_HEADERS_ALL
365: WHERE
366: HEADER_ID IN(
367: SELECT
368: HEADER_ID

Line 382: l_order_number oe_order_headers.order_number%type;

378: oe_order_lines_all
379: where
380: line_id = p_line_id;
381:
382: l_order_number oe_order_headers.order_number%type;
383: l_header_id oe_order_headers.header_id%type;
384: l_process wf_activities.name%type := upper(p_process);
385: l_itemkey wf_items.item_key%type;
386: l_line_number oe_order_lines_all.line_number%type;

Line 383: l_header_id oe_order_headers.header_id%type;

379: where
380: line_id = p_line_id;
381:
382: l_order_number oe_order_headers.order_number%type;
383: l_header_id oe_order_headers.header_id%type;
384: l_process wf_activities.name%type := upper(p_process);
385: l_itemkey wf_items.item_key%type;
386: l_line_number oe_order_lines_all.line_number%type;
387: