APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_ORDER_HEADER_HISTORY

Line 382: ,decode(ENTITY_ID, 1, 'oe_order_header_history',

378: /* Get all entity ids specific history views */
379: -- Not including entities greater than 1000 (blankets, payments)
380: CURSOR c_entities IS
381: SELECT ENTITY_ID
382: ,decode(ENTITY_ID, 1, 'oe_order_header_history',
383:
384: 2, 'oe_order_lines_history',
385: 5, 'oe_sales_credit_history',
386: 6, 'oe_price_adjs_history',

Line 823: ' from oe_order_header_history where nvl(audit_flag, ''Y'') = ''Y'' and hist_creation_date between :m and :n and ';

819:
820: /*8265428 start
821: if (c_ent_rec.entity_id = 1) then
822: l_id_stmt := ' select distinct header_id, header_id entity_number '||
823: ' from oe_order_header_history where nvl(audit_flag, ''Y'') = ''Y'' and hist_creation_date between :m and :n and ';
824:
825: l_order_by := ' 1 = 1 ';
826: elsif (c_ent_rec.entity_id = 2) then
827: l_id_stmt := ' select distinct header_id, line_id entity_number '

Line 854: ' from oe_order_header_history where nvl(audit_flag, ''Y'') = ''Y'' and hist_creation_date between

850: --8265428 start
851:
852: if (c_ent_rec.entity_id = 1) then
853: l_id_stmt := ' select distinct header_id, header_id entity_number '||
854: ' from oe_order_header_history where nvl(audit_flag, ''Y'') = ''Y'' and hist_creation_date between
855: to_date('''||To_Char(min_hist_creation_date,'DD-MON-RRRR HH24 MI SS')||''',''DD-MON-RRRR HH24 MI SS'') and
856: to_date('''||To_Char(max_hist_creation_date,'DD-MON-RRRR HH24 MI SS')||''',''DD-MON-RRRR HH24 MI SS'') and ';
857:
858: l_order_by := ' 1 = 1 ';

Line 1198: from oe_order_header_history

1194: select credit_card_code, credit_card_number
1195: ,credit_card_holder_name, credit_card_expiration_date
1196: into l_credit_card_code, l_credit_card_number
1197: ,l_credit_card_holder_name, l_credit_card_expiration_date
1198: from oe_order_header_history
1199: where hist_creation_date = l_hist_creation_date
1200: and header_id = l_header_id;
1201: EXCEPTION WHEN NO_DATA_FOUND THEN
1202: null;

Line 1578: from oe_order_header_history

1574:
1575: BEGIN
1576: select instrument_id
1577: into l_last_instrument_id
1578: from oe_order_header_history
1579: where header_id = l_header_id
1580: and hist_creation_date =
1581: (select max(hist_creation_date)
1582: from oe_order_header_history

Line 1582: from oe_order_header_history

1578: from oe_order_header_history
1579: where header_id = l_header_id
1580: and hist_creation_date =
1581: (select max(hist_creation_date)
1582: from oe_order_header_history
1583: where header_id = l_header_id);
1584: EXCEPTION WHEN NO_DATA_FOUND THEN
1585: null;
1586: END;

Line 1634: -- l_last_instrument_id is the last record in oe_order_header_history.

1630:
1631: IF c_attr_tbl(j).attribute_id = 49
1632:
1633: -- l_attribute_value_last is the instrument id on the current order
1634: -- l_last_instrument_id is the last record in oe_order_header_history.
1635: AND OE_GLOBALS.Is_Same_Credit_Card(p_cc_num_old => null
1636: ,p_cc_num_new => null
1637: ,p_instrument_id_old => l_attribute_value_last
1638: -- ,p_instrument_id_new => l_attribute_value) THEN

Line 1662: -- this is to get the last record in oe_order_header_history,

1658: IF l_credit_card_number IS NULL AND
1659: l_credit_card_code IS NULL
1660: AND c_attr_tbl(j).attribute_id in (47,48)
1661: AND l_count_last = 0 THEN
1662: -- this is to get the last record in oe_order_header_history,
1663: -- if it stores card history id then set flag to 'N' when
1664: -- calling Get_Card_Attribute_Value to get l_attribute_value.
1665:
1666: l_instr_flag :='N';

Line 2234: FROM oe_order_header_history

2230:
2231: BEGIN
2232: SELECT instrument_id, credit_card_expiration_date,credit_card_number,credit_card_code
2233: INTO l_old_instrument_id,l_old_exp_date,l_old_cc_number, l_old_cc_code
2234: FROM oe_order_header_history
2235: WHERE header_id = p_header_id
2236: AND hist_creation_date = p_old_hist_creation_date;
2237: EXCEPTION WHEN NO_DATA_FOUND THEN
2238: null;

Line 2245: FROM oe_order_header_history

2241:
2242: BEGIN
2243: SELECT instrument_id,credit_card_expiration_date, credit_card_number,credit_card_code
2244: INTO l_new_instrument_id,l_new_exp_date,l_new_cc_number, l_new_cc_code
2245: FROM oe_order_header_history
2246: WHERE header_id = p_header_id
2247: AND hist_creation_date = p_new_hist_creation_date;
2248: EXCEPTION WHEN NO_DATA_FOUND THEN
2249: null;