526: WHERE organization_id = p_org_id
527: AND acct_period_id = p_acct_period_id
528: AND status = 'PROCESS';
529:
530: FND_PROFILE.Get(l_profile_category_name, l_category_id);
531: FND_PROFILE.Get(l_profile_category_set_name, l_category_set_id);
532:
533: IF (l_state_level >= l_debug_level) THEN
534: FND_LOG.string(l_state_level
527: AND acct_period_id = p_acct_period_id
528: AND status = 'PROCESS';
529:
530: FND_PROFILE.Get(l_profile_category_name, l_category_id);
531: FND_PROFILE.Get(l_profile_category_set_name, l_category_set_id);
532:
533: IF (l_state_level >= l_debug_level) THEN
534: FND_LOG.string(l_state_level
535: , G_MODULE_HEAD || l_routine || '.itemcat'
580: l_inflation_adjustment_rec.category_set_id :=
581: TO_NUMBER(l_category_set_id);
582: l_inflation_adjustment_rec.last_update_date := SYSDATE;
583: l_inflation_adjustment_rec.last_updated_by :=
584: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
585: l_inflation_adjustment_rec.creation_date := SYSDATE;
586: l_inflation_adjustment_rec.created_by :=
587: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
588: l_inflation_adjustment_rec.last_update_login :=
583: l_inflation_adjustment_rec.last_updated_by :=
584: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
585: l_inflation_adjustment_rec.creation_date := SYSDATE;
586: l_inflation_adjustment_rec.created_by :=
587: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
588: l_inflation_adjustment_rec.last_update_login :=
589: TO_NUMBER(fnd_profile.value('LOGIN_ID'));
590: l_inflation_adjustment_rec.request_id :=
591: TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
585: l_inflation_adjustment_rec.creation_date := SYSDATE;
586: l_inflation_adjustment_rec.created_by :=
587: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
588: l_inflation_adjustment_rec.last_update_login :=
589: TO_NUMBER(fnd_profile.value('LOGIN_ID'));
590: l_inflation_adjustment_rec.request_id :=
591: TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
592: l_inflation_adjustment_rec.program_application_id :=
593: TO_NUMBER(fnd_profile.value('PROG_APPL_ID'));
587: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
588: l_inflation_adjustment_rec.last_update_login :=
589: TO_NUMBER(fnd_profile.value('LOGIN_ID'));
590: l_inflation_adjustment_rec.request_id :=
591: TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
592: l_inflation_adjustment_rec.program_application_id :=
593: TO_NUMBER(fnd_profile.value('PROG_APPL_ID'));
594: l_inflation_adjustment_rec.program_id :=
595: TO_NUMBER(fnd_profile.value('CONC_PROG_ID'));
589: TO_NUMBER(fnd_profile.value('LOGIN_ID'));
590: l_inflation_adjustment_rec.request_id :=
591: TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
592: l_inflation_adjustment_rec.program_application_id :=
593: TO_NUMBER(fnd_profile.value('PROG_APPL_ID'));
594: l_inflation_adjustment_rec.program_id :=
595: TO_NUMBER(fnd_profile.value('CONC_PROG_ID'));
596: l_inflation_adjustment_rec.program_update_date := SYSDATE;
597:
591: TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
592: l_inflation_adjustment_rec.program_application_id :=
593: TO_NUMBER(fnd_profile.value('PROG_APPL_ID'));
594: l_inflation_adjustment_rec.program_id :=
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