DBA Data[Home] [Help]

APPS.BOM_GTIN_RULES dependencies on BOM_ROLLUP_PUB

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

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

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

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

Line 502: Bom_Rollup_Pub.Add_Rollup_Function

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

Line 504: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

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

Line 510: Bom_Rollup_Pub.Add_Rollup_Function

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

Line 512: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPOGATE_BRAND_INFO

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

Line 517: Bom_Rollup_Pub.Add_Rollup_Function

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

Line 519: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_TOP_GTIN_FLAG

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

Line 525: Bom_Rollup_Pub.Add_Rollup_Function

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

Line 527: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_MULTI_ROW_ATTRS

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

Line 533: Bom_Rollup_Pub.Add_Rollup_Function

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

Line 535: , p_Rollup_Action => Bom_Rollup_Pub.G_PROPAGATE_SH_TEMPS

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

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

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

Line 542: Bom_Rollup_Pub.Add_Rollup_Function

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

Line 544: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

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

Line 556: Bom_Rollup_Pub.Add_Rollup_Function

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

Line 558: , p_Rollup_Action => Bom_Rollup_Pub.G_COMPUTE_NET_WEIGHT

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

Line 568: Bom_Rollup_Pub.g_attr_diffs := null;

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

Line 569: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_parent_item_id

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

Line 578: Bom_Rollup_Pub.g_attr_diffs := null;

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

Line 579: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id

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

Line 586: Bom_Rollup_Pub.g_attr_diffs := null;

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

Line 589: Bom_Rollup_Pub.g_attr_diffs := null;

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

Line 590: Bom_Rollup_Pub.Perform_Rollup( p_item_id => p_item_id

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

Line 598: Bom_Rollup_Pub.g_attr_diffs := null;

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