eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HEADER_UTIL dependencies on OE_ORDER_HEADERS

Line 3970: FROM OE_ORDER_HEADERS

3966: -- everytime there is an update on the record.
3967:
3968: SELECT lock_control
3969: INTO l_lock_control
3970: FROM OE_ORDER_HEADERS
3971: WHERE header_id = p_header_rec.header_id;
3972:
3973: l_lock_control := l_lock_control + 1;
3974:

Line 3997: UPDATE OE_ORDER_HEADERS

3993: END IF;
3994: END IF; /*code_release_level*/
3995: -- notification framework end
3996:
3997: UPDATE OE_ORDER_HEADERS
3998: SET ACCOUNTING_RULE_ID = p_header_rec.accounting_rule_id
3999: , ACCOUNTING_RULE_DURATION = p_header_rec.accounting_rule_duration
4000: , AGREEMENT_ID = p_header_rec.agreement_id
4001: , ATTRIBUTE1 = p_header_rec.attribute1

Line 4245: INSERT INTO OE_ORDER_HEADERS

4241: RAISE FND_API.G_EXC_ERROR;
4242: END IF;
4243:
4244:
4245: INSERT INTO OE_ORDER_HEADERS
4246: ( ACCOUNTING_RULE_ID
4247: , ACCOUNTING_RULE_DURATION
4248: , AGREEMENT_ID
4249: , ATTRIBUTE1

Line 4724: FROM OE_ORDER_HEADERS

4720: OR l_price_request_code is NULL THEN
4721: oe_debug_pub.add('Select price_request_code from HEADER',1);
4722: SELECT price_request_code
4723: INTO l_price_request_code
4724: FROM OE_ORDER_HEADERS
4725: WHERE HEADER_ID = p_header_id;
4726: END IF;
4727:
4728: OE_DELAYED_REQUESTS_UTIL.REVERSE_LIMITS

Line 4798: DELETE FROM OE_ORDER_HEADERS

4794: x_msg_data =>l_msg_data);
4795: END IF;
4796: /*End contract deletion*/
4797:
4798: DELETE FROM OE_ORDER_HEADERS
4799: WHERE HEADER_ID = p_header_id;
4800: /* AND
4801: (NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0))
4802: ;*/

Line 5384: FROM OE_ORDER_HEADERS_ALL

5380: , x_header_rec.customer_signature
5381: , x_header_rec.customer_signature_date
5382: --key Transaction Dates
5383: , x_header_rec.order_firmed_date
5384: FROM OE_ORDER_HEADERS_ALL
5385: WHERE HEADER_ID = p_header_id;
5386: /* AND
5387: (NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0))
5388: ;*/

Line 5494: FROM OE_ORDER_HEADERS_ALL

5490: END IF;
5491:
5492: SELECT header_id, lock_control
5493: INTO l_header_id, l_db_lock_control
5494: FROM OE_ORDER_HEADERS_ALL
5495: WHERE HEADER_ID = l_header_id
5496: FOR UPDATE NOWAIT;
5497:
5498: -- { Start of the fix 2436046, query part is old

Line 6991: FROM OE_ORDER_HEADERS

6987: THEN
6988:
6989: SELECT SOLD_TO_ORG_ID
6990: INTO l_sold_to_org_id
6991: FROM OE_ORDER_HEADERS
6992: WHERE HEADER_ID = p_x_header_rec.header_id;
6993:
6994: ELSE
6995:

Line 7228: FROM OE_ORDER_HEADERS

7224:
7225: SELECT SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID
7226: -- bug 8340976 INTO l_sold_to_org_id, l_invoice_to_org_id, l_deliver_to_org_id
7227: INTO l_ship_to_org_id, l_invoice_to_org_id, l_deliver_to_org_id
7228: FROM OE_ORDER_HEADERS
7229: WHERE HEADER_ID = p_x_header_rec.header_id;
7230:
7231: IF p_x_header_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
7232: l_ship_to_org_id := p_x_header_rec.ship_to_org_id;

Line 7656: FROM oe_order_headers_all

7652:
7653: BEGIN
7654: SELECT order_number,order_type_id
7655: INTO l_order_number,l_order_type_id
7656: FROM oe_order_headers_all
7657: WHERE header_id = p_header_id;
7658:
7659: x_order_source := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
7660: x_order_number := l_order_number;

Line 7697: from oe_order_headers

7693: BEGIN
7694:
7695: Select header_id
7696: into l_header_id
7697: from oe_order_headers
7698: where order_number = p_order_number AND
7699: order_type_id = (select tl.transaction_type_id
7700: from oe_transaction_types_tl tl,
7701: oe_transaction_types_all ta

Line 7963: From OE_ORDER_HEADERS_ALL

7959: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7960:
7961: Select Count(Header_id) into
7962: lcount
7963: From OE_ORDER_HEADERS_ALL
7964: WHERE order_type_id = p_x_header_rec.order_type_id
7965: and order_number = p_x_header_rec.order_number
7966: -- We need to remove the check condition around the version number.
7967: --Bug #3357896.

Line 7998: From OE_ORDER_HEADERS_ALL

7994: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
7995:
7996: Select Count(Header_id) into
7997: lcount
7998: From OE_ORDER_HEADERS_ALL
7999: WHERE order_type_id = p_x_header_rec.order_type_id
8000: and quote_number = p_x_header_rec.quote_number
8001: -- We need to remove the check condition around the version number.
8002: --Bug #3357896.

Line 9438: FROM OE_ORDER_HEADERS_ALL

9434: --satisfied.
9435: BEGIN
9436: SELECT PAYMENT_TERM_ID,TRANSACTIONAL_CURR_CODE
9437: INTO l_payment_term_id,l_currency_code
9438: FROM OE_ORDER_HEADERS_ALL
9439: WHERE HEADER_ID = p_x_header_rec.header_id;
9440: EXCEPTION
9441: WHEN NO_DATA_FOUND THEN
9442: l_payment_term_id := NULL;

Line 9607: from oe_order_headers_all

9603: oe_debug_pub.add('Entering OR_HEADER_UTIL.Validate_Gapless_Seq',1);
9604:
9605: select order_type_id into
9606: l_order_type_id
9607: from oe_order_headers_all
9608: where header_id = l_header_id;
9609:
9610: ltype := Get_ord_seq_type(l_order_type_id,l_transaction_phase_code);
9611:

Line 9970: FROM OE_ORDER_HEADERS_ALL

9966: SELECT order_source_id, orig_sys_document_ref, change_sequence,
9967: source_document_type_id, source_document_id
9968: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
9969: l_source_document_type_id, l_source_document_id
9970: FROM OE_ORDER_HEADERS_ALL
9971: WHERE header_id = p_x_header_rec.header_Id;
9972: EXCEPTION
9973: WHEN NO_DATA_FOUND THEN
9974: l_order_source_id := null;

Line 10012: FROM OE_ORDER_HEADERS_ALL

10008:
10009: BEGIN
10010: SELECT NVL(SOLD_TO_ORG_ID,p_x_header_rec.sold_to_org_id)
10011: INTO p_x_header_rec.sold_to_org_id
10012: FROM OE_ORDER_HEADERS_ALL
10013: WHERE HEADER_ID = p_x_header_rec.header_id;
10014: EXCEPTION
10015: WHEN OTHERS THEN
10016: NULL;