APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_LINES_HISTORY

Line 6: -- 2. oe_order_lines_history

2: /* $Header: OEXHVERB.pls 120.8.12020000.3 2013/01/17 07:19:05 sujithku ship $ */
3:
4: -- This API will be used to create history records for entities.
5: -- 1. oe_order_header_history
6: -- 2. oe_order_lines_history
7: -- 3. oe_price_adjs_history
8: -- 4. oe_sales_credit_history
9: -- It will skip the records which already exists for the specified version.
10: --

Line 564: INSERT INTO oe_order_lines_history

560:
561: -- Create History Records for Lines
562: l_api_name := 'Create_Line_History';
563:
564: INSERT INTO oe_order_lines_history
565: (
566: LINE_ID,
567: ORG_ID,
568: HEADER_ID,

Line 1275: FROM oe_order_lines_history b

1271: SERVICE_FIRST_PERIOD_ENDDATE
1272: FROM OE_ORDER_LINES_ALL a
1273: WHERE header_id = p_header_id
1274: AND NOT EXISTS (select b.line_id
1275: FROM oe_order_lines_history b
1276: WHERE a.line_id = b.line_id
1277: AND a.header_id = b.header_id
1278: AND b.version_number = l_version_number
1279: AND b.version_flag = l_version_flag);

Line 1681: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY l

1677: WHERE h.header_id = l.header_id
1678: AND l.line_id = p_line_id;
1679: EXCEPTION WHEN NO_DATA_FOUND THEN
1680: SELECT h.version_number INTO l_current_version_number
1681: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY l
1682: WHERE h.header_id = l.header_id
1683: AND l.line_id = p_line_id
1684: AND rownum = 1;
1685: END;

Line 3348: FROM OE_ORDER_LINES_HISTORY

3344: ,SERVICE_BILL_OPTION_CODE
3345: ,SERVICE_FIRST_PERIOD_AMOUNT
3346: ,SUBSCRIPTION_ENABLE_FLAG
3347: ,SERVICE_FIRST_PERIOD_ENDDATE
3348: FROM OE_ORDER_LINES_HISTORY
3349: WHERE LINE_ID = p_line_id
3350: AND VERSION_NUMBER = l_version_number
3351: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
3352: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 3694: FROM OE_ORDER_LINES_HISTORY

3690: ,SERVICE_BILL_OPTION_CODE
3691: ,SERVICE_FIRST_PERIOD_AMOUNT
3692: ,SUBSCRIPTION_ENABLE_FLAG
3693: ,SERVICE_FIRST_PERIOD_ENDDATE
3694: FROM OE_ORDER_LINES_HISTORY
3695: WHERE HEADER_ID = p_header_id
3696: AND VERSION_NUMBER = l_version_number
3697: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
3698: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 4042: FROM OE_ORDER_LINES_HISTORY

4038: ,SERVICE_BILL_OPTION_CODE
4039: ,SERVICE_FIRST_PERIOD_AMOUNT
4040: ,SUBSCRIPTION_ENABLE_FLAG
4041: ,SERVICE_FIRST_PERIOD_ENDDATE
4042: FROM OE_ORDER_LINES_HISTORY
4043: WHERE LINE_SET_ID = p_line_set_id
4044: AND VERSION_NUMBER = l_version_number
4045: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4046: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'