DBA Data[Home] [Help]

APPS.OE_BLANKET_WF dependencies on OE_BLANKET_HEADERS_ALL

Line 178: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

174: OE_STANDARD_WF.Set_Msg_Context(actid);
175: IF (funcmode = 'RUN') then
176: SELECT obhe.Start_Date_Active, obhe.End_Date_Active
177: INTO l_start_date, l_end_date
178: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
179: WHERE obha.header_id = to_number(itemkey)
180: AND obha.order_number = obhe.order_number;
181:
182: -- start date has not been reached

Line 325: FROM oe_blanket_headers_all

321: END;
322:
323: SELECT order_number
324: INTO l_blanket_number
325: FROM oe_blanket_headers_all
326: WHERE header_id = l_header_id;
327:
328: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
329: fnd_message.set_token('BLANKET_NUMBER', to_char(l_blanket_number));

Line 373: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

369: END;
370:
371: SELECT obhe.end_date_active
372: INTO l_end_date
373: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
374: WHERE obha.header_id = l_header_id
375: AND obha.order_number = obhe.order_number;
376:
377: document := to_char(l_end_date, 'DD-MON-RRRR');

Line 432: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx

428:
429: -- set WF header attributes, values may have been changed during the wait period
430: select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
431: into l_sold_to_org_id, l_end_date, l_salesrep_id
432: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
433: where bh.header_id = to_number(itemkey)
434: and bh.order_number = bhx.order_number;
435:
436: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 594: FROM oe_blanket_headers_all

590: END IF;
591:
592: SELECT transaction_phase_code
593: INTO l_transaction_phase_code
594: FROM oe_blanket_headers_all
595: WHERE header_id = p_header_id;
596:
597: IF nvl(l_transaction_phase_code, 'F') = 'N' THEN
598: -- currently during negotiation phase, there is no impact

Line 856: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx

852:
853: -- set WF header attributes, values may have been changed during the wait period
854: select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
855: into l_sold_to_org_id, l_end_date, l_salesrep_id
856: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
857: where bh.header_id = p_header_id
858: and bh.order_number = bhx.order_number;
859:
860: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 977: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx

973: END IF;
974:
975: select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
976: into l_sold_to_org_id, l_end_date, l_salesrep_id
977: from oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
978: where bh.header_id = p_header_id
979: and bh.order_number = bhx.order_number;
980:
981: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 1070: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

1066: END IF;
1067:
1068: SELECT obhe.End_Date_Active
1069: INTO l_end_date
1070: FROM oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
1071: WHERE obha.header_id = to_number(itemkey)
1072: AND obha.order_number = obhe.order_number;
1073:
1074: