[Home] [Help]
7855: ,x_line_rec.SERVICE_BILL_OPTION_CODE
7856: ,x_line_rec.SERVICE_FIRST_PERIOD_AMOUNT
7857: ,x_line_rec.SUBSCRIPTION_ENABLE_FLAG
7858: ,x_line_rec.SERVICE_FIRST_PERIOD_ENDDATE
7859: FROM OE_ORDER_LINES_HISTORY
7860: WHERE LINE_ID = p_line_id
7861: and version_number = p_version
7862: and header_id=p_header_id
7863: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
8557: ,x_line_rec.SERVICE_BILL_OPTION_CODE
8558: ,x_line_rec.SERVICE_FIRST_PERIOD_AMOUNT
8559: ,x_line_rec.SUBSCRIPTION_ENABLE_FLAG
8560: ,x_line_rec.SERVICE_FIRST_PERIOD_ENDDATE
8561: FROM OE_ORDER_LINES
8562: WHERE LINE_ID = p_line_id
8563: -- and version_number = p_version
8564: and header_id=p_header_id;
8565: EXCEPTION
18648:
18649: l_line_id NUMBER;
18650: CURSOR C_get_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
18651: SELECT distinct line_id
18652: from oe_order_lines_history
18653: where header_id = p_header_id
18654: --Bug 8478088
18655: and version_flag = 'Y'
18656: --and transaction_phase_code = p_transaction_phase_code
18656: --and transaction_phase_code = p_transaction_phase_code
18657: and version_number in (p_prior_version,p_current_version,p_next_version)
18658: union
18659: SELECT line_id
18660: from oe_order_lines_all
18661: where header_id=p_header_id;
18662:
18663: CURSOR C_get_hist_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
18664: SELECT distinct line_id
18661: where header_id=p_header_id;
18662:
18663: CURSOR C_get_hist_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
18664: SELECT distinct line_id
18665: from oe_order_lines_history
18666: where header_id = p_header_id
18667: --Bug 8478088
18668: and version_flag = 'Y'
18669: --and transaction_phase_code = p_transaction_phase_code