298:
299: --Bug: 5920143. New column include_establishments has beed added in
300: -- record definition.
301: TYPE Movement_Stat_Usages_Rec_Type IS RECORD
302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE
303: , zone_code mtl_stat_type_usages.zone_code%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
299: --Bug: 5920143. New column include_establishments has beed added in
300: -- record definition.
301: TYPE Movement_Stat_Usages_Rec_Type IS RECORD
302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE
303: , zone_code mtl_stat_type_usages.zone_code%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
300: -- record definition.
301: TYPE Movement_Stat_Usages_Rec_Type IS RECORD
302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE
303: , zone_code mtl_stat_type_usages.zone_code%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
301: TYPE Movement_Stat_Usages_Rec_Type IS RECORD
302: ( legal_entity_id mtl_stat_type_usages.legal_entity_id%TYPE
303: , zone_code mtl_stat_type_usages.zone_code%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
304: , usage_type mtl_stat_type_usages.usage_type%TYPE
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE
311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE
312: , gl_currency_code VARCHAR2(15)
305: , stat_type mtl_stat_type_usages.stat_type%TYPE
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE
311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE
312: , gl_currency_code VARCHAR2(15)
313: , gl_set_of_books_id NUMBER
306: , start_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE
311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE
312: , gl_currency_code VARCHAR2(15)
313: , gl_set_of_books_id NUMBER
314: , gl_end_date DATE
307: , end_date DATE
308: , conversion_option mtl_stat_type_usages.conversion_option%TYPE
309: , conversion_type mtl_stat_type_usages.conversion_type%TYPE
310: , category_set_id mtl_stat_type_usages.category_set_id%TYPE
311: , weight_uom_code mtl_stat_type_usages.weight_uom_code%TYPE
312: , gl_currency_code VARCHAR2(15)
313: , gl_set_of_books_id NUMBER
314: , gl_end_date DATE
315: , gl_period_name VARCHAR2(15)
312: , gl_currency_code VARCHAR2(15)
313: , gl_set_of_books_id NUMBER
314: , gl_end_date DATE
315: , gl_period_name VARCHAR2(15)
316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
313: , gl_set_of_books_id NUMBER
314: , gl_end_date DATE
315: , gl_period_name VARCHAR2(15)
316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
314: , gl_end_date DATE
315: , gl_period_name VARCHAR2(15)
316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
315: , gl_period_name VARCHAR2(15)
316: , start_period_name mtl_stat_type_usages.start_period_name%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
317: , end_period_name mtl_stat_type_usages.end_period_name%TYPE
318: , period_set_name mtl_stat_type_usages.period_set_name%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
319: , period_type mtl_stat_type_usages.period_type%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
320: , attribute_rule_set_code
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
321: mtl_stat_type_usages.attribute_rule_set_code%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
322: , alt_uom_rule_set_code
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
323: mtl_stat_type_usages.alt_uom_rule_set_code%TYPE
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
331: );
324: , triangulation_mode mtl_stat_type_usages.triangulation_mode%TYPE
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
331: );
332:
325: , reference_period_rule mtl_stat_type_usages.reference_period_rule%TYPE
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
331: );
332:
333:
326: , pending_invoice_days mtl_stat_type_usages.pending_invoice_days%TYPE
327: , prior_invoice_days mtl_stat_type_usages.prior_invoice_days%TYPE
328: , returns_processing mtl_stat_type_usages.returns_processing%TYPE
329: , kit_method mtl_stat_type_usages.kit_method%TYPE
330: , include_establishments mtl_stat_type_usages.include_establishments%TYPE
331: );
332:
333:
334: -- Declare the REF Cursor