DBA Data[Home] [Help]

APPS.MSC_PEG_UTIL dependencies on FND_GLOBAL

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

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

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

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

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

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:

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

Line 555: ||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
559:

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

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:

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

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

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

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

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

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;

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

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

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

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