DBA Data[Home] [Help]

APPS.MSC_UI_PEG_UTIL dependencies on FND_GLOBAL

Line 748: ||fnd_global.local_chr(58)||to_char(nvl(Prev_pegging_id,-111))

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))

Line 749: ||fnd_global.local_chr(58)||to_char(nvl(Demand_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));

Line 750: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_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:

Line 751: ||fnd_global.local_chr(58)||to_char(nvl(p_supply_org_id,-111))

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:

Line 752: ||fnd_global.local_chr(58)|| 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:
756: if p_node_type = 1 then -- demand

Line 753: ||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
757:

Line 759: ||fnd_global.local_chr(58)||to_char(nvl(Demand_id,-111))

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:

Line 760: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))

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

Line 761: ||fnd_global.local_chr(58)||' -111 '||fnd_global.local_chr(58)||to_char(pvt_l_node_number + 1);

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

Line 766: ||fnd_global.local_chr(58)||to_char(nvl(Transaction_id,-111))

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;

Line 767: ||fnd_global.local_chr(58)||to_char(nvl(Item_id,-111))

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

Line 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);

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