DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on FND_PROFILE

Line 526: set wjsi.job_name = fnd_profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval,

522: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
523: end if;
524:
525: update wip_job_schedule_interface wjsi
526: set wjsi.job_name = fnd_profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval,
527: wjsi.last_update_date = sysdate
528: where wjsi.group_id = p_groupID
529: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
530: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

Line 1206: l_see_eng_items_flag := fnd_profile.value('WIP_SEE_ENG_ITEMS');

1202: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
1203: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1204: end if;
1205:
1206: l_see_eng_items_flag := fnd_profile.value('WIP_SEE_ENG_ITEMS');
1207: update wip_job_schedule_interface wjsi
1208: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1209: wjsi.last_update_date = sysdate
1210: where wjsi.group_id = p_groupID

Line 3132: l_orginalOrgContext := nvl(fnd_profile.value('ORG_ID'), -1);

3128:
3129: validateKanban(line.rowid, p_validationLevel, l_msg);
3130:
3131: -- save the original org context
3132: l_orginalOrgContext := nvl(fnd_profile.value('ORG_ID'), -1);
3133:
3134: -- set the org context for future PJM validation
3135: -- Bug 4890514. Performance Fix
3136: -- saugupta 25th-May-2006

Line 3522: fnd_profile.put('MFG_ORGANIZATION_ID',wjsi_row.organization_id);

3518: l_result varchar2(1);
3519: l_ou_context number;
3520: begin
3521: -- fix MOAC, set id so project view works
3522: fnd_profile.put('MFG_ORGANIZATION_ID',wjsi_row.organization_id);
3523:
3524: -- Set Additional OU context when Flow is from AFAS as required by Projects in Bug 12674069.
3525: SELECT TO_NUMBER(org_information3) into l_ou_context
3526: FROM hr_organization_information