546: IF p_calling_module = 1 then
547: -- Constructing the node value
548:
549: x_node_value := to_char(nvl(Pegging_id,-111))
550: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
551: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
552: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
553: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
554: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
547: -- Constructing the node value
548:
549: x_node_value := to_char(nvl(Pegging_id,-111))
550: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
551: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
552: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
553: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
554: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
555: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
548:
549: x_node_value := to_char(nvl(Pegging_id,-111))
550: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
551: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
552: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
553: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
554: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
555: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
556:
549: x_node_value := to_char(nvl(Pegging_id,-111))
550: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
551: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
552: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
553: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
554: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
555: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
556:
557:
550: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))
551: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
552: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
553: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
554: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
555: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
556:
557:
558: if p_node_type = 1 then -- demand
551: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
552: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
553: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))
554: ||fnd_global.local_chr(58)|| to_char(nvl(Pegging_id,-111))
555: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111));
556:
557:
558: if p_node_type = 1 then -- demand
559:
557:
558: if p_node_type = 1 then -- demand
559:
560: x_node_value := x_node_value
561: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
562: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
563: ||fnd_global.local_chr(58)||' -111 '||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
564:
565:
558: if p_node_type = 1 then -- demand
559:
560: x_node_value := x_node_value
561: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
562: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
563: ||fnd_global.local_chr(58)||' -111 '||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
564:
565:
566: else
559:
560: x_node_value := x_node_value
561: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))
562: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
563: ||fnd_global.local_chr(58)||' -111 '||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);
564:
565:
566: else
567: x_node_value := x_node_value
564:
565:
566: else
567: x_node_value := x_node_value
568: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
569: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
570: ||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);
571: ---bug #3556405
572: end if;
565:
566: else
567: x_node_value := x_node_value
568: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
569: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
570: ||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);
571: ---bug #3556405
572: end if;
573: ELSE
566: else
567: x_node_value := x_node_value
568: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))
569: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))
570: ||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);
571: ---bug #3556405
572: end if;
573: ELSE
574: if p_node_type = 1 then -- expanding to demands nodes