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 3821: FROM OE_ORDER_HEADERS

3817: -- everytime there is an update on the record.
3818:
3819: SELECT lock_control
3820: INTO l_lock_control
3821: FROM OE_ORDER_HEADERS
3822: WHERE header_id = p_header_rec.header_id;
3823:
3824: l_lock_control := l_lock_control + 1;
3825:

Line 3848: UPDATE OE_ORDER_HEADERS

3844: END IF;
3845: END IF; /*code_release_level*/
3846: -- notification framework end
3847:
3848: UPDATE OE_ORDER_HEADERS
3849: SET ACCOUNTING_RULE_ID = p_header_rec.accounting_rule_id
3850: , ACCOUNTING_RULE_DURATION = p_header_rec.accounting_rule_duration
3851: , AGREEMENT_ID = p_header_rec.agreement_id
3852: , ATTRIBUTE1 = p_header_rec.attribute1

Line 4096: INSERT INTO OE_ORDER_HEADERS

4092: RAISE FND_API.G_EXC_ERROR;
4093: END IF;
4094:
4095:
4096: INSERT INTO OE_ORDER_HEADERS
4097: ( ACCOUNTING_RULE_ID
4098: , ACCOUNTING_RULE_DURATION
4099: , AGREEMENT_ID
4100: , ATTRIBUTE1

Line 4575: FROM OE_ORDER_HEADERS

4571: OR l_price_request_code is NULL THEN
4572: oe_debug_pub.add('Select price_request_code from HEADER',1);
4573: SELECT price_request_code
4574: INTO l_price_request_code
4575: FROM OE_ORDER_HEADERS
4576: WHERE HEADER_ID = p_header_id;
4577: END IF;
4578:
4579: OE_DELAYED_REQUESTS_UTIL.REVERSE_LIMITS

Line 4648: DELETE FROM OE_ORDER_HEADERS

4644: x_msg_data =>l_msg_data);
4645: END IF;
4646: /*End contract deletion*/
4647:
4648: DELETE FROM OE_ORDER_HEADERS
4649: WHERE HEADER_ID = p_header_id;
4650: /* AND
4651: (NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0))
4652: ;*/

Line 5234: FROM OE_ORDER_HEADERS_ALL

5230: , x_header_rec.customer_signature
5231: , x_header_rec.customer_signature_date
5232: --key Transaction Dates
5233: , x_header_rec.order_firmed_date
5234: FROM OE_ORDER_HEADERS_ALL
5235: WHERE HEADER_ID = p_header_id;
5236: /* AND
5237: (NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0))
5238: ;*/

Line 5344: FROM OE_ORDER_HEADERS_ALL

5340: END IF;
5341:
5342: SELECT header_id, lock_control
5343: INTO l_header_id, l_db_lock_control
5344: FROM OE_ORDER_HEADERS_ALL
5345: WHERE HEADER_ID = l_header_id
5346: FOR UPDATE NOWAIT;
5347:
5348: -- { Start of the fix 2436046, query part is old

Line 6841: FROM OE_ORDER_HEADERS

6837: THEN
6838:
6839: SELECT SOLD_TO_ORG_ID
6840: INTO l_sold_to_org_id
6841: FROM OE_ORDER_HEADERS
6842: WHERE HEADER_ID = p_x_header_rec.header_id;
6843:
6844: ELSE
6845:

Line 7077: FROM OE_ORDER_HEADERS

7073: THEN
7074:
7075: SELECT SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID
7076: INTO l_sold_to_org_id, l_invoice_to_org_id, l_deliver_to_org_id
7077: FROM OE_ORDER_HEADERS
7078: WHERE HEADER_ID = p_x_header_rec.header_id;
7079:
7080: IF p_x_header_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
7081: l_ship_to_org_id := p_x_header_rec.ship_to_org_id;

Line 7504: FROM oe_order_headers_all

7500:
7501: BEGIN
7502: SELECT order_number,order_type_id
7503: INTO l_order_number,l_order_type_id
7504: FROM oe_order_headers_all
7505: WHERE header_id = p_header_id;
7506:
7507: x_order_source := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
7508: x_order_number := l_order_number;

Line 7545: from oe_order_headers

7541: BEGIN
7542:
7543: Select header_id
7544: into l_header_id
7545: from oe_order_headers
7546: where order_number = p_order_number AND
7547: order_type_id = (select tl.transaction_type_id
7548: from oe_transaction_types_tl tl,
7549: oe_transaction_types_all ta

Line 7811: From OE_ORDER_HEADERS_ALL

7807: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7808:
7809: Select Count(Header_id) into
7810: lcount
7811: From OE_ORDER_HEADERS_ALL
7812: WHERE order_type_id = p_x_header_rec.order_type_id
7813: and order_number = p_x_header_rec.order_number
7814: -- We need to remove the check condition around the version number.
7815: --Bug #3357896.

Line 7846: From OE_ORDER_HEADERS_ALL

7842: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
7843:
7844: Select Count(Header_id) into
7845: lcount
7846: From OE_ORDER_HEADERS_ALL
7847: WHERE order_type_id = p_x_header_rec.order_type_id
7848: and quote_number = p_x_header_rec.quote_number
7849: -- We need to remove the check condition around the version number.
7850: --Bug #3357896.

Line 9220: FROM OE_ORDER_HEADERS_ALL

9216: --satisfied.
9217: BEGIN
9218: SELECT PAYMENT_TERM_ID,TRANSACTIONAL_CURR_CODE
9219: INTO l_payment_term_id,l_currency_code
9220: FROM OE_ORDER_HEADERS_ALL
9221: WHERE HEADER_ID = p_x_header_rec.header_id;
9222: EXCEPTION
9223: WHEN NO_DATA_FOUND THEN
9224: l_payment_term_id := NULL;

Line 9389: from oe_order_headers_all

9385: oe_debug_pub.add('Entering OR_HEADER_UTIL.Validate_Gapless_Seq',1);
9386:
9387: select order_type_id into
9388: l_order_type_id
9389: from oe_order_headers_all
9390: where header_id = l_header_id;
9391:
9392: ltype := Get_ord_seq_type(l_order_type_id,l_transaction_phase_code);
9393: