APPS.LOT_SPLIT_DATA_INSERT dependencies on ORG_ACCT_PERIODS

Line 692: l_acct_period_id org_acct_periods.acct_period_id%TYPE := 0;

688: l_temp_id NUMBER := 0;
689: l_batch_id NUMBER := 0;
690: l_transaction_action_id NUMBER := inv_globals.G_Action_inv_lot_split;
691: l_transaction_source_type_id NUMBER := inv_globals.G_SourceType_Inventory;
692: l_acct_period_id org_acct_periods.acct_period_id%TYPE := 0;
693: l_dist_account_id mtl_parameters.distribution_account_id%TYPE := NULL;
694: l_wsm_enabled_flag mtl_parameters.wsm_enabled_flag%TYPE := 'N';
695: l_xfr_lpn_id NUMBER := NULL;
696: l_msg_count NUMBER := NULL;

Line 718: l_msg_data := 'select acct_period_id from org_acct_periods';

714: SELECT mtl_material_transactions_s.NEXTVAL
715: INTO l_batch_id
716: FROM DUAL;
717:
718: l_msg_data := 'select acct_period_id from org_acct_periods';
719:
720: BEGIN
721: IF (l_debug = 1) THEN
722: INV_TRX_UTIL_PUB.trace('getting acct_period_id', g_pkg_name, 9);

Line 726: FROM org_acct_periods

722: INV_TRX_UTIL_PUB.trace('getting acct_period_id', g_pkg_name, 9);
723: END IF;
724: SELECT acct_period_id
725: INTO l_acct_period_id
726: FROM org_acct_periods
727: WHERE INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,tab_input(1).organization_id)
728: >= trunc(period_start_date )
729: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,tab_input(1).organization_id)
730: <= trunc(schedule_close_date)