744: IF p_calling_module = 1 then
745: -- Constructing the node value
746:
747: x_node_value := to_char(nvl(Pegging_id,-111))
748: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
749: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
750: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
751: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
752: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
745: -- Constructing the node value
746:
747: x_node_value := to_char(nvl(Pegging_id,-111))
748: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
749: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
750: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
751: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
752: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
753: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
746:
747: x_node_value := to_char(nvl(Pegging_id,-111))
748: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
749: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
750: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
751: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
752: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
753: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
754:
747: x_node_value := to_char(nvl(Pegging_id,-111))
748: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
749: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
750: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
751: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
752: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
753: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
754:
755:
748: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
749: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
750: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
751: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
752: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
753: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
754:
755:
756: if p_node_type = 1 then -- demand
749: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
750: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
751: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
752: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
753: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
754:
755:
756: if p_node_type = 1 then -- demand
757:
755:
756: if p_node_type = 1 then -- demand
757:
758: x_node_value := x_node_value
759: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
760: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
761: ||fnd_global.local_chr(58)||' -111 '||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
762:
763:
756: if p_node_type = 1 then -- demand
757:
758: x_node_value := x_node_value
759: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
760: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
761: ||fnd_global.local_chr(58)||' -111 '||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
762:
763:
764: else
757:
758: x_node_value := x_node_value
759: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
760: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
761: ||fnd_global.local_chr(58)||' -111 '||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
762:
763:
764: else
765: x_node_value := x_node_value
762:
763:
764: else
765: x_node_value := x_node_value
766: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
767: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
768: ||fnd_global.local_chr(58)||to_char(nvl(p_prev_pegging_value ,-111))||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
769: ---bug #3556405
770: end if;
763:
764: else
765: x_node_value := x_node_value
766: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
767: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
768: ||fnd_global.local_chr(58)||to_char(nvl(p_prev_pegging_value ,-111))||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
769: ---bug #3556405
770: end if;
771: ELSE
764: else
765: x_node_value := x_node_value
766: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
767: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
768: ||fnd_global.local_chr(58)||to_char(nvl(p_prev_pegging_value ,-111))||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
769: ---bug #3556405
770: end if;
771: ELSE
772: if p_node_type = 1 then -- expanding to demands nodes