DBA Data[Home] [Help]

APPS.CST_MGD_INFL_ADJUSTMENT_CP dependencies on FND_PROFILE

Line 530: FND_PROFILE.Get(l_profile_category_name, l_category_id);

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

Line 531: FND_PROFILE.Get(l_profile_category_set_name, l_category_set_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
535: , G_MODULE_HEAD || l_routine || '.itemcat'

Line 584: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);

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 :=

Line 587: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);

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'));

Line 589: TO_NUMBER(fnd_profile.value('LOGIN_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'));

Line 591: TO_NUMBER(fnd_profile.value('CONC_REQUEST_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'));

Line 593: TO_NUMBER(fnd_profile.value('PROG_APPL_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:

Line 595: TO_NUMBER(fnd_profile.value('CONC_PROG_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:
598: -- get period end item unit avg. cost
599: CST_MGD_INFL_ADJUSTMENT_PVT.Get_Period_End_Avg_Cost