APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_ORDER_HEADER_HISTORY

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

279: /* Get all entity ids specific history views */
280: -- Not including entities greater than 1000 (blankets, payments)
281: CURSOR c_entities IS
282: SELECT ENTITY_ID
283: ,decode(ENTITY_ID, 1, 'oe_order_header_history',
284:
285: 2, 'oe_order_lines_history',
286: 5, 'oe_sales_credit_history',
287: 6, 'oe_price_adjs_history',

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

681: -- end bug 4394119
682:
683: if (c_ent_rec.entity_id = 1) then
684: l_id_stmt := ' select distinct header_id, header_id entity_number '||
685: ' from oe_order_header_history where nvl(audit_flag, ''Y'') = ''Y'' and hist_creation_date between :m and :n and ';
686:
687: l_order_by := ' 1 = 1 ';
688: elsif (c_ent_rec.entity_id = 2) then
689: l_id_stmt := ' select distinct header_id, line_id entity_number '

Line 970: from oe_order_header_history

966: select credit_card_code, credit_card_number
967: ,credit_card_holder_name, credit_card_expiration_date
968: into l_credit_card_code, l_credit_card_number
969: ,l_credit_card_holder_name, l_credit_card_expiration_date
970: from oe_order_header_history
971: where hist_creation_date = l_hist_creation_date
972: and header_id = l_header_id;
973: EXCEPTION WHEN NO_DATA_FOUND THEN
974: null;

Line 1254: from oe_order_header_history

1250:
1251: BEGIN
1252: select instrument_id
1253: into l_last_instrument_id
1254: from oe_order_header_history
1255: where header_id = l_header_id
1256: and hist_creation_date =
1257: (select max(hist_creation_date)
1258: from oe_order_header_history

Line 1258: from oe_order_header_history

1254: from oe_order_header_history
1255: where header_id = l_header_id
1256: and hist_creation_date =
1257: (select max(hist_creation_date)
1258: from oe_order_header_history
1259: where header_id = l_header_id);
1260: EXCEPTION WHEN NO_DATA_FOUND THEN
1261: null;
1262: END;

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

1306:
1307: IF c_attr_tbl(j).attribute_id = 49
1308:
1309: -- l_attribute_value_last is the instrument id on the current order
1310: -- l_last_instrument_id is the last record in oe_order_header_history.
1311: AND OE_GLOBALS.Is_Same_Credit_Card(p_cc_num_old => null
1312: ,p_cc_num_new => null
1313: ,p_instrument_id_old => l_attribute_value_last
1314: -- ,p_instrument_id_new => l_attribute_value) THEN

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

1334: IF l_credit_card_number IS NULL AND
1335: l_credit_card_code IS NULL
1336: AND c_attr_tbl(j).attribute_id in (47,48)
1337: AND l_count_last = 0 THEN
1338: -- this is to get the last record in oe_order_header_history,
1339: -- if it stores card history id then set flag to 'N' when
1340: -- calling Get_Card_Attribute_Value to get l_attribute_value.
1341:
1342: l_instr_flag :='N';

Line 1863: FROM oe_order_header_history

1859:
1860: BEGIN
1861: SELECT instrument_id, credit_card_expiration_date,credit_card_number,credit_card_code
1862: INTO l_old_instrument_id,l_old_exp_date,l_old_cc_number, l_old_cc_code
1863: FROM oe_order_header_history
1864: WHERE header_id = p_header_id
1865: AND hist_creation_date = p_old_hist_creation_date;
1866: EXCEPTION WHEN NO_DATA_FOUND THEN
1867: null;

Line 1874: FROM oe_order_header_history

1870:
1871: BEGIN
1872: SELECT instrument_id,credit_card_expiration_date, credit_card_number,credit_card_code
1873: INTO l_new_instrument_id,l_new_exp_date,l_new_cc_number, l_new_cc_code
1874: FROM oe_order_header_history
1875: WHERE header_id = p_header_id
1876: AND hist_creation_date = p_new_hist_creation_date;
1877: EXCEPTION WHEN NO_DATA_FOUND THEN
1878: null;