DBA Data[Home] [Help]

APPS.BOM_GTIN_RULES dependencies on BOM_ROLLUP_PUB

Line 487: l_rollup_map Bom_Rollup_Pub.Rollup_Action_Map := Bom_Rollup_Pub.G_EMPTY_ACTION_MAP;

483: , p_structure_name IN VARCHAR2 := NULL
484: , x_error_message OUT NOCOPY VARCHAR2
485: ) IS
486:
487: l_rollup_map Bom_Rollup_Pub.Rollup_Action_Map := Bom_Rollup_Pub.G_EMPTY_ACTION_MAP;
488: l_return_status varchar2(1) := 'S';
489: l_msg_count number := 0;
490: l_msg_data varchar2(3000) := null;
491:

Line 497: IF (Bom_Rollup_Pub.Is_UCCNet_Enabled(p_item_id, p_organization_id) = 'Y')

493: -- We are not considering the p_structure_name anymore to calculate the preferred structure
494: -- as items are also calling the same api and the callee doesn't have a structure name
495: IF p_transaction_type IN ('CREATE','DELETE')
496: THEN
497: IF (Bom_Rollup_Pub.Is_UCCNet_Enabled(p_item_id, p_organization_id) = 'Y')
498: THEN
499: Bom_Rollup_Pub.Add_Rollup_Function
500: ( p_Object_Name => 'EGO_ITEM'
501: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

Line 499: Bom_Rollup_Pub.Add_Rollup_Function

495: IF p_transaction_type IN ('CREATE','DELETE')
496: THEN
497: IF (Bom_Rollup_Pub.Is_UCCNet_Enabled(p_item_id, p_organization_id) = 'Y')
498: THEN
499: Bom_Rollup_Pub.Add_Rollup_Function
500: ( p_Object_Name => 'EGO_ITEM'
501: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT
502: , p_DML_Function => 'Bom_Compute_Functions.Set_Net_Weight'
503: , p_DML_Delayed_Write => 'N'

Line 501: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

497: IF (Bom_Rollup_Pub.Is_UCCNet_Enabled(p_item_id, p_organization_id) = 'Y')
498: THEN
499: Bom_Rollup_Pub.Add_Rollup_Function
500: ( p_Object_Name => 'EGO_ITEM'
501: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT
502: , p_DML_Function => 'Bom_Compute_Functions.Set_Net_Weight'
503: , p_DML_Delayed_Write => 'N'
504: , x_Rollup_Action_Map => l_rollup_map
505: );

Line 507: Bom_Rollup_Pub.Add_Rollup_Function

503: , p_DML_Delayed_Write => 'N'
504: , x_Rollup_Action_Map => l_rollup_map
505: );
506:
507: Bom_Rollup_Pub.Add_Rollup_Function
508: ( p_Object_Name => 'EGO_ITEM'
509: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPOGATE_BRAND_INFO
510: , p_DML_Function => 'Bom_Compute_Functions.Set_Brand_Info'
511: , p_DML_Delayed_Write => 'N'

Line 509: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPOGATE_BRAND_INFO

505: );
506:
507: Bom_Rollup_Pub.Add_Rollup_Function
508: ( p_Object_Name => 'EGO_ITEM'
509: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPOGATE_BRAND_INFO
510: , p_DML_Function => 'Bom_Compute_Functions.Set_Brand_Info'
511: , p_DML_Delayed_Write => 'N'
512: , x_Rollup_Action_Map => l_rollup_map
513: );

Line 514: Bom_Rollup_Pub.Add_Rollup_Function

510: , p_DML_Function => 'Bom_Compute_Functions.Set_Brand_Info'
511: , p_DML_Delayed_Write => 'N'
512: , x_Rollup_Action_Map => l_rollup_map
513: );
514: Bom_Rollup_Pub.Add_Rollup_Function
515: ( p_Object_Name => 'EGO_ITEM'
516: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_TOP_GTIN_FLAG
517: , p_DML_Function => 'Bom_Compute_Functions.Set_Top_GTIN_Flag'
518: , p_DML_Delayed_Write => 'N'

Line 516: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_TOP_GTIN_FLAG

512: , x_Rollup_Action_Map => l_rollup_map
513: );
514: Bom_Rollup_Pub.Add_Rollup_Function
515: ( p_Object_Name => 'EGO_ITEM'
516: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_TOP_GTIN_FLAG
517: , p_DML_Function => 'Bom_Compute_Functions.Set_Top_GTIN_Flag'
518: , p_DML_Delayed_Write => 'N'
519: , x_Rollup_Action_Map => l_rollup_map
520: );

Line 522: Bom_Rollup_Pub.Add_Rollup_Function

518: , p_DML_Delayed_Write => 'N'
519: , x_Rollup_Action_Map => l_rollup_map
520: );
521:
522: Bom_Rollup_Pub.Add_Rollup_Function
523: ( p_Object_Name => 'EGO_ITEM'
524: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_MULTI_ROW_ATTRS
525: , p_DML_Function => 'Bom_Compute_Functions.Set_Multirow_Attributes'
526: , p_DML_Delayed_Write => 'N'

Line 524: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_MULTI_ROW_ATTRS

520: );
521:
522: Bom_Rollup_Pub.Add_Rollup_Function
523: ( p_Object_Name => 'EGO_ITEM'
524: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_MULTI_ROW_ATTRS
525: , p_DML_Function => 'Bom_Compute_Functions.Set_Multirow_Attributes'
526: , p_DML_Delayed_Write => 'N'
527: , x_Rollup_Action_Map => l_rollup_map
528: );

Line 530: Bom_Rollup_Pub.Add_Rollup_Function

526: , p_DML_Delayed_Write => 'N'
527: , x_Rollup_Action_Map => l_rollup_map
528: );
529:
530: Bom_Rollup_Pub.Add_Rollup_Function
531: ( p_Object_Name => 'EGO_ITEM'
532: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPAGATE_SH_TEMPS
533: , p_DML_Function => 'Bom_Compute_Functions.Set_SH_Temps'
534: , p_DML_Delayed_Write => 'N'

Line 532: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPAGATE_SH_TEMPS

528: );
529:
530: Bom_Rollup_Pub.Add_Rollup_Function
531: ( p_Object_Name => 'EGO_ITEM'
532: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPAGATE_SH_TEMPS
533: , p_DML_Function => 'Bom_Compute_Functions.Set_SH_Temps'
534: , p_DML_Delayed_Write => 'N'
535: , x_Rollup_Action_Map => l_rollup_map
536: );

Line 537: ELSIF (Bom_Rollup_Pub.Is_Pack_Item(p_item_id, p_organization_id) = 'Y')

533: , p_DML_Function => 'Bom_Compute_Functions.Set_SH_Temps'
534: , p_DML_Delayed_Write => 'N'
535: , x_Rollup_Action_Map => l_rollup_map
536: );
537: ELSIF (Bom_Rollup_Pub.Is_Pack_Item(p_item_id, p_organization_id) = 'Y')
538: THEN
539: Bom_Rollup_Pub.Add_Rollup_Function
540: ( p_Object_Name => 'EGO_ITEM'
541: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

Line 539: Bom_Rollup_Pub.Add_Rollup_Function

535: , x_Rollup_Action_Map => l_rollup_map
536: );
537: ELSIF (Bom_Rollup_Pub.Is_Pack_Item(p_item_id, p_organization_id) = 'Y')
538: THEN
539: Bom_Rollup_Pub.Add_Rollup_Function
540: ( p_Object_Name => 'EGO_ITEM'
541: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT
542: , p_DML_Function => 'Bom_Compute_Functions.Set_Net_Weight'
543: , p_DML_Delayed_Write => 'N'

Line 541: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

537: ELSIF (Bom_Rollup_Pub.Is_Pack_Item(p_item_id, p_organization_id) = 'Y')
538: THEN
539: Bom_Rollup_Pub.Add_Rollup_Function
540: ( p_Object_Name => 'EGO_ITEM'
541: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT
542: , p_DML_Function => 'Bom_Compute_Functions.Set_Net_Weight'
543: , p_DML_Delayed_Write => 'N'
544: , x_Rollup_Action_Map => l_rollup_map
545: );

Line 553: Bom_Rollup_Pub.Add_Rollup_Function

549: END IF;
550:
551: IF p_transaction_type IN ('UPDATE')
552: THEN
553: Bom_Rollup_Pub.Add_Rollup_Function
554: ( p_Object_Name => 'EGO_ITEM'
555: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT
556: , p_DML_Function => 'Bom_Compute_Functions.Set_Net_Weight'
557: , p_DML_Delayed_Write => 'N'

Line 555: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

551: IF p_transaction_type IN ('UPDATE')
552: THEN
553: Bom_Rollup_Pub.Add_Rollup_Function
554: ( p_Object_Name => 'EGO_ITEM'
555: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT
556: , p_DML_Function => 'Bom_Compute_Functions.Set_Net_Weight'
557: , p_DML_Delayed_Write => 'N'
558: , x_Rollup_Action_Map => l_rollup_map
559: );

Line 565: Bom_Rollup_Pub.g_attr_diffs := null;

561:
562: IF p_transaction_type = 'DELETE' AND
563: p_parent_item_id IS NOT NULL
564: THEN
565: Bom_Rollup_Pub.g_attr_diffs := null;
566: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_parent_item_id
567: , p_organization_id => p_organization_id
568: , p_structure_type_name => p_structure_type_name
569: , p_action_map => l_rollup_map

Line 566: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_parent_item_id

562: IF p_transaction_type = 'DELETE' AND
563: p_parent_item_id IS NOT NULL
564: THEN
565: Bom_Rollup_Pub.g_attr_diffs := null;
566: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_parent_item_id
567: , p_organization_id => p_organization_id
568: , p_structure_type_name => p_structure_type_name
569: , p_action_map => l_rollup_map
570: , p_validate => p_validate

Line 575: Bom_Rollup_Pub.g_attr_diffs := null;

571: , p_halt_on_error => p_halt_on_error
572: , x_error_message => x_error_message );
573: -- note: because of the Items flow, we want to store attr_diffs
574: -- between calls to Perform_Rollup; however, in this case we want to clear them
575: Bom_Rollup_Pub.g_attr_diffs := null;
576: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id
577: , p_organization_id => p_organization_id
578: , p_structure_type_name => p_structure_type_name
579: , p_action_map => l_rollup_map

Line 576: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id

572: , x_error_message => x_error_message );
573: -- note: because of the Items flow, we want to store attr_diffs
574: -- between calls to Perform_Rollup; however, in this case we want to clear them
575: Bom_Rollup_Pub.g_attr_diffs := null;
576: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id
577: , p_organization_id => p_organization_id
578: , p_structure_type_name => p_structure_type_name
579: , p_action_map => l_rollup_map
580: , p_validate => p_validate

Line 583: Bom_Rollup_Pub.g_attr_diffs := null;

579: , p_action_map => l_rollup_map
580: , p_validate => p_validate
581: , p_halt_on_error => p_halt_on_error
582: , x_error_message => x_error_message );
583: Bom_Rollup_Pub.g_attr_diffs := null;
584:
585: ELSE
586: Bom_Rollup_Pub.g_attr_diffs := null;
587: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id

Line 586: Bom_Rollup_Pub.g_attr_diffs := null;

582: , x_error_message => x_error_message );
583: Bom_Rollup_Pub.g_attr_diffs := null;
584:
585: ELSE
586: Bom_Rollup_Pub.g_attr_diffs := null;
587: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id
588: , p_organization_id => p_organization_id
589: , p_parent_item_id => p_parent_item_id
590: , p_structure_type_name => p_structure_type_name

Line 587: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id

583: Bom_Rollup_Pub.g_attr_diffs := null;
584:
585: ELSE
586: Bom_Rollup_Pub.g_attr_diffs := null;
587: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id
588: , p_organization_id => p_organization_id
589: , p_parent_item_id => p_parent_item_id
590: , p_structure_type_name => p_structure_type_name
591: , p_action_map => l_rollup_map

Line 595: Bom_Rollup_Pub.g_attr_diffs := null;

591: , p_action_map => l_rollup_map
592: , p_validate => p_validate
593: , p_halt_on_error => p_halt_on_error
594: , x_error_message => x_error_message );
595: Bom_Rollup_Pub.g_attr_diffs := null;
596: END IF;
597: END;
598:
599: --added by dikrishn for bug3938873