eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WS_TIME_ENTRY dependencies on STANDARD

Line 3435: l_standard_rate_flag number;

3431: l_primary_item_id number;
3432: l_project_id number;
3433: l_task_id number;
3434: l_basis_type number;
3435: l_standard_rate_flag number;
3436: l_actual_resource_rate number;
3437: l_primary_uom varchar2(3);
3438: l_primary_quantity number;
3439: conversion_rate number;

Line 3610: --Bug 10097774 get resource basis_type, standard_rate_flag, primary_uom

3606: wip_logger.log('l_department_id = '|| l_department_id ||' l_department_code = '|| l_department_code, l_retStatus);
3607: end if;
3608:
3609:
3610: --Bug 10097774 get resource basis_type, standard_rate_flag, primary_uom
3611: -- Modified for Bug 16528843.
3612: begin
3613: select wor.basis_type, wor.standard_rate_flag, wor.uom_code,ca.activity_id, ca.activity
3614: into l_basis_type, l_standard_rate_flag, l_primary_uom, l_activity_id, l_activity_name

Line 3613: select wor.basis_type, wor.standard_rate_flag, wor.uom_code,ca.activity_id, ca.activity

3609:
3610: --Bug 10097774 get resource basis_type, standard_rate_flag, primary_uom
3611: -- Modified for Bug 16528843.
3612: begin
3613: select wor.basis_type, wor.standard_rate_flag, wor.uom_code,ca.activity_id, ca.activity
3614: into l_basis_type, l_standard_rate_flag, l_primary_uom, l_activity_id, l_activity_name
3615: from wip_operation_resources wor,cst_activities ca
3616: where wor.wip_entity_id = p_wip_entity_id
3617: and wor.operation_seq_num = p_operation_seq_num

Line 3614: into l_basis_type, l_standard_rate_flag, l_primary_uom, l_activity_id, l_activity_name

3610: --Bug 10097774 get resource basis_type, standard_rate_flag, primary_uom
3611: -- Modified for Bug 16528843.
3612: begin
3613: select wor.basis_type, wor.standard_rate_flag, wor.uom_code,ca.activity_id, ca.activity
3614: into l_basis_type, l_standard_rate_flag, l_primary_uom, l_activity_id, l_activity_name
3615: from wip_operation_resources wor,cst_activities ca
3616: where wor.wip_entity_id = p_wip_entity_id
3617: and wor.operation_seq_num = p_operation_seq_num
3618: and wor.resource_seq_num = l_resource_seq_num -- p_resource_seq_num Bug 13481688

Line 3626: select br.default_basis_type, br.standard_rate_flag, br.unit_of_measure,ca.activity_id, ca.activity

3622: and (ca.organization_id is null or ca.organization_id = p_organization_id);
3623:
3624: exception
3625: when no_data_found then
3626: select br.default_basis_type, br.standard_rate_flag, br.unit_of_measure,ca.activity_id, ca.activity
3627: into l_basis_type, l_standard_rate_flag, l_primary_uom,l_activity_id, l_activity_name
3628: from bom_resources br,cst_activities ca
3629: where br.resource_id = p_resource_id
3630: and br.default_activity_id = ca.activity_id (+)

Line 3627: into l_basis_type, l_standard_rate_flag, l_primary_uom,l_activity_id, l_activity_name

3623:
3624: exception
3625: when no_data_found then
3626: select br.default_basis_type, br.standard_rate_flag, br.unit_of_measure,ca.activity_id, ca.activity
3627: into l_basis_type, l_standard_rate_flag, l_primary_uom,l_activity_id, l_activity_name
3628: from bom_resources br,cst_activities ca
3629: where br.resource_id = p_resource_id
3630: and br.default_activity_id = ca.activity_id (+)
3631: and nvl(ca.disable_date(+),sysdate+1) > sysdate

Line 3638: wip_logger.log('l_standard_rate_flag = '|| l_standard_rate_flag, l_retStatus);

3634:
3635: if (l_logLevel <= wip_constants.full_logging) then
3636: wip_logger.log('derive_insert_wcti Phase 60', l_retStatus);
3637: wip_logger.log('l_basis_type = '|| l_basis_type, l_retStatus);
3638: wip_logger.log('l_standard_rate_flag = '|| l_standard_rate_flag, l_retStatus);
3639: wip_logger.log('l_primary_uom = '|| l_primary_uom, l_retStatus);
3640: end if;
3641:
3642: --Bug 10097774 get primary_item_id, project_id, task_id

Line 3760: standard_rate_flag, --Bug 10097774

3756: department_code, --Bug 10097774
3757: resource_type, --Bug 10097774
3758: basis_type, --Bug 10097774
3759: autocharge_type, --Bug 10097774
3760: standard_rate_flag, --Bug 10097774
3761: primary_quantity, --Bug 10097774
3762: primary_uom, --Bug 10097774
3763: actual_resource_rate, --Bug 10097774
3764: project_id, --Bug 10097774

Line 3804: l_standard_rate_flag, --Bug 10097774

3800: l_department_code, --Bug 10097774
3801: l_resource_type, --Bug 10097774
3802: l_basis_type, --Bug 10097774
3803: WIP_CONSTANTS.MANUAL, --Bug 10097774
3804: l_standard_rate_flag, --Bug 10097774
3805: round(l_primary_quantity, WIP_CONSTANTS.MAX_DISPLAYED_PRECISION), --Bug 10097774
3806: l_primary_uom, --Bug 10097774
3807: l_actual_resource_rate,--Bug 10097774
3808: l_project_id,--Bug 10097774

Line 3825: standard_rate_flag,

3821: resource_id,
3822: uom_code,
3823: basis_type,
3824: activity_id,
3825: standard_rate_flag,
3826: usage_rate_or_amount,
3827: scheduled_flag,
3828: assigned_units,
3829: autocharge_type,

Line 3849: wti.standard_rate_flag,

3845: wti.resource_id,
3846: wti.primary_uom,
3847: wti.basis_type,
3848: br.default_activity_id,
3849: wti.standard_rate_flag,
3850: nvl(wti.usage_rate_or_amount,0),
3851: 2,
3852: 1,
3853: 2,