[Home] [Help]
353: cst_period_close_summary
354: WHERE acct_period_id = c_acct_period_id
355: AND organization_id = c_organization_id
356: AND cost_group_id = c_cost_group_id
357: AND CST_MGD_INFL_ADJUSTMENT_PVT.Infl_Item_Category(inventory_item_id
358: ,c_organization_id
359: ,c_category_set_id
360: ,c_category_id
361: ) = 'Y'
366: mtl_per_close_dtls
367: WHERE acct_period_id = c_acct_period_id
368: AND organization_id = c_organization_id
369: AND cost_group_id = c_cost_group_id
370: AND CST_MGD_INFL_ADJUSTMENT_PVT.Infl_Item_Category(inventory_item_id
371: ,c_organization_id
372: ,c_category_set_id
373: ,c_category_id
374: ) = 'Y';
407: IF l_wms_enabled_flag = 'Y' THEN
408: RAISE l_wms_org_exc;
409: END IF;
410:
411: CST_MGD_INFL_ADJUSTMENT_PVT.Check_Period_Close
412: ( p_org_id => p_org_id
413: , p_acct_period_id => p_acct_period_id
414: );
415:
420: );
421:
422: /* removed as part of bug#1474753 fix
423: -- Check for historical data
424: CST_MGD_INFL_ADJUSTMENT_PVT.Check_First_Time
425: ( p_country_code => p_country_code
426: , p_org_id => p_org_id
427: , x_get_hist_data_flag => l_get_hist_data_flag
428: );
432: -- Get previous account period id and scheduled close date.
433: -- previous period obtained only if the previous period inflation
434: -- is transferred to GL,otherwise returns null
435: --
436: CST_MGD_INFL_ADJUSTMENT_PVT.Get_Previous_Acct_Period_ID
437: ( p_organization_id => p_org_id
438: , p_acct_period_id => p_acct_period_id
439: , x_prev_acct_period_id => l_prev_acct_period_id
440: , x_prev_sch_close_date => l_prev_sch_close_date
453: );
454: END IF;
455:
456: -- Get current period start date.
457: CST_MGD_INFL_ADJUSTMENT_PVT.Get_Curr_Period_Start_Date
458: ( p_org_id => p_org_id
459: , p_acct_period_id => p_acct_period_id
460: , x_curr_period_start_date => l_curr_period_start_date
461: , x_curr_period_end_date => l_curr_period_end_date
595: TO_NUMBER(fnd_profile.value('CONC_PROG_ID'));
596: l_inflation_adjustment_rec.program_update_date := SYSDATE;
597:
598: -- get period end item unit avg. cost
599: CST_MGD_INFL_ADJUSTMENT_PVT.Get_Period_End_Avg_Cost
600: ( p_acct_period_id => p_acct_period_id
601: , p_org_id => p_org_id
602: , p_inv_item_id => l_inv_item_id
603: , p_cost_group_id => l_cost_group_id
613: );
614: END IF;
615:
616: -- calling inflation adjustment engine
617: CST_MGD_INFL_ADJUSTMENT_PVT.Create_Inflation_Adjusted_Cost
618: ( p_api_version_number => l_api_version_number
619: , p_init_msg_list => FND_API.G_FALSE
620: , x_return_status => l_return_status
621: , x_msg_count => l_msg_count
634: -- ======================================================
635: -- Set the inflation processor status to PROCESS
636: -- Insert a record with status PROCESS
637: -- ======================================================
638: CST_MGD_INFL_ADJUSTMENT_PVT.Create_Infl_Period_Status
639: ( p_org_id => p_org_id
640: , p_acct_period_id => p_acct_period_id
641: , x_return_status => l_return_status
642: );
796: )
797: IS
798: l_routine CONSTANT VARCHAR2(30) := 'transfer_to_gl';
799: l_acct_entry_tbl_rec
800: CST_MGD_INFL_ADJUSTMENT_PVT.Infl_Adj_Acct_Tbl_Rec_Type;
801: l_transfer_entry_tbl_rec
802: CST_MGD_INFL_ADJUSTMENT_PVT.Infl_Adj_Acct_Tbl_Rec_Type;
803: l_status NUMBER;
804: l_infl_adj_item_id NUMBER;
798: l_routine CONSTANT VARCHAR2(30) := 'transfer_to_gl';
799: l_acct_entry_tbl_rec
800: CST_MGD_INFL_ADJUSTMENT_PVT.Infl_Adj_Acct_Tbl_Rec_Type;
801: l_transfer_entry_tbl_rec
802: CST_MGD_INFL_ADJUSTMENT_PVT.Infl_Adj_Acct_Tbl_Rec_Type;
803: l_status NUMBER;
804: l_infl_adj_item_id NUMBER;
805: l_inventory_adj_acct_cr NUMBER;
806: l_inventory_adj_acct_dr NUMBER;
865: RAISE no_infl_processor_run_exc;
866: END IF;
867:
868:
869: CST_MGD_INFL_ADJUSTMENT_PVT.Get_Set_Of_Books_ID
870: ( p_org_id => p_org_id
871: , x_set_of_books_id => l_set_of_books_id
872: );
873:
870: ( p_org_id => p_org_id
871: , x_set_of_books_id => l_set_of_books_id
872: );
873:
874: CST_MGD_INFL_ADJUSTMENT_PVT.Get_Currency_Code
875: ( p_set_of_books_id => l_set_of_books_id
876: , x_currency_code => l_currency_code
877: );
878:
885: ( p_je_source_name => 'Inflation'
886: , x_user_source_name => l_user_source_name
887: );
888:
889: CST_MGD_INFL_ADJUSTMENT_PVT.Get_Curr_Period_Start_Date
890: ( p_org_id => p_org_id
891: , p_acct_period_id => p_acct_period_id
892: , x_curr_period_start_date => l_curr_period_start_date
893: , x_curr_period_end_date => l_curr_period_end_date
913: , l_monetary_corr_acct_cr
914: , l_sales_cost_acct_dr;
915: EXIT WHEN l_infl_adj_item_csr%NOTFOUND;
916:
917: CST_MGD_INFL_ADJUSTMENT_PVT.GL_Interface_Default
918: ( p_country_code => p_country_code
919: , p_org_id => p_org_id
920: , p_inv_item_id => l_infl_adj_item_id
921: , p_acct_period_id => p_acct_period_id
939: IF NVL(l_acct_entry_tbl_rec(l_index).entered_cr, 0) +
940: NVL(l_acct_entry_tbl_rec(l_index).entered_dr, 0)
941: <> 0
942: THEN
943: CST_MGD_INFL_ADJUSTMENT_PVT.Create_Journal_Entries
944: ( p_infl_adj_acct_rec => l_acct_entry_tbl_rec(l_index)
945: );
946: END IF;
947: EXIT WHEN l_index = l_acct_entry_tbl_rec.LAST;
951: END LOOP;
952:
953: -- Set period status to final
954: -- Update status table to 'FINAL'
955: CST_MGD_INFL_ADJUSTMENT_PVT.Update_Infl_Period_Status
956: ( p_org_id => p_org_id
957: , p_acct_period_id => p_acct_period_id
958: , x_return_status => l_return_status
959: );