DBA Data[Home] [Help]

APPS.CST_EAMJOB_ACTESTIMATE dependencies on FND_DATE

Line 332: fnd_date.date_to_canonical(SYSDATE),

328: p_alt_bom_designator IN VARCHAR2 := NULL,
329: p_alt_rtg_designator IN VARCHAR2 := NULL,
330: p_cost_group_id IN NUMBER := NULL,
331: p_effective_datetime IN VARCHAR2 :=
332: fnd_date.date_to_canonical(SYSDATE),
333:
334: p_user_id IN NUMBER,
335: p_request_id IN NUMBER,
336: p_prog_id IN NUMBER,

Line 352: fnd_date.canonical_to_date(p_effective_datetime);

348: l_msg_count NUMBER := 0;
349: l_msg_data VARCHAR2(8000) := '';
350:
351: l_effective_datetime DATE :=
352: fnd_date.canonical_to_date(p_effective_datetime);
353: l_eam_item_type NUMBER := 0;
354: l_rates_ct NUMBER := 0;
355: l_lot_size NUMBER := 0;
356: l_round_unit NUMBER := 0;

Line 557: fnd_date.canonical_to_date(p_effective_datetime))

553: AND NVL(bic.acd_type,1) <> 3
554: AND NVL(bic.eco_for_production,2) = 2
555: AND bic.wip_supply_type IN (1,4)
556: AND (bic.effectivity_date <=
557: fnd_date.canonical_to_date(p_effective_datetime))
558: AND NVL(bic.disable_date,
559: fnd_date.canonical_to_date(p_effective_datetime)+1) >
560: fnd_date.canonical_to_date(p_effective_datetime)
561: AND ccicv.inventory_item_id(+) = bic.component_item_id

Line 559: fnd_date.canonical_to_date(p_effective_datetime)+1) >

555: AND bic.wip_supply_type IN (1,4)
556: AND (bic.effectivity_date <=
557: fnd_date.canonical_to_date(p_effective_datetime))
558: AND NVL(bic.disable_date,
559: fnd_date.canonical_to_date(p_effective_datetime)+1) >
560: fnd_date.canonical_to_date(p_effective_datetime)
561: AND ccicv.inventory_item_id(+) = bic.component_item_id
562: AND ccicv.organization_id(+) = p_organization_id
563: AND ccicv.cost_group_id(+) = decode(l_primary_cost_method,1,1,

Line 560: fnd_date.canonical_to_date(p_effective_datetime)

556: AND (bic.effectivity_date <=
557: fnd_date.canonical_to_date(p_effective_datetime))
558: AND NVL(bic.disable_date,
559: fnd_date.canonical_to_date(p_effective_datetime)+1) >
560: fnd_date.canonical_to_date(p_effective_datetime)
561: AND ccicv.inventory_item_id(+) = bic.component_item_id
562: AND ccicv.organization_id(+) = p_organization_id
563: AND ccicv.cost_group_id(+) = decode(l_primary_cost_method,1,1,
564: l_cost_group_id)

Line 1073: fnd_date.date_to_canonical(SYSDATE),

1069: p_alt_bom_designator IN VARCHAR2 := NULL,
1070: p_alt_rtg_designator IN VARCHAR2 := NULL,
1071: p_cost_group_id IN NUMBER := NULL,
1072: p_effective_datetime IN VARCHAR2 :=
1073: fnd_date.date_to_canonical(SYSDATE),
1074:
1075: p_user_id IN NUMBER,
1076: p_request_id IN NUMBER,
1077: p_prog_id IN NUMBER,