DBA Data[Home] [Help]

APPS.OE_CHARGE_PVT dependencies on OE_GLOBALS

Line 540: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)

536: END IF;
537: IF l_line_adj_tbl(l_charge_index).list_line_type_code = 'FREIGHT_CHARGE'
538: AND NVL(l_line_adj_tbl(l_charge_index).applied_flag,'N') = 'Y'
539: AND l_line_adj_tbl(l_charge_index).operation IN
540: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)
541: AND l_line_adj_tbl(l_charge_index).line_id =
542: p_line_tbl(l_line_index).line_id
543: THEN
544:

Line 559: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)

555: WHILE l_tmp_index IS NOT NULL LOOP
556:
557: IF l_tmp_index <> l_charge_index
558: AND l_line_adj_tbl(l_tmp_index).operation IN
559: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)
560: AND l_line_adj_tbl(l_tmp_index).list_line_type_code
561: = 'FREIGHT_CHARGE'
562: AND NVL(l_line_adj_tbl(l_tmp_index).applied_flag,'N') = 'Y'
563: AND l_line_adj_tbl(l_charge_index).charge_type_code

Line 582: OE_GLOBALS.G_OPR_UPDATE

578: IF l_line_adj_tbl(l_tmp_index).adjusted_amount >=
579: l_line_adj_tbl(l_charge_index).adjusted_amount
580: THEN
581: IF l_line_adj_tbl(l_charge_index).operation =
582: OE_GLOBALS.G_OPR_UPDATE
583: THEN
584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add( 'THE SELECTED OPERATION IS SET TO DELETE' ) ;
586: END IF;

Line 588: OE_GLOBALS.G_OPR_DELETE;

584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add( 'THE SELECTED OPERATION IS SET TO DELETE' ) ;
586: END IF;
587: l_line_adj_tbl(l_charge_index).operation :=
588: OE_GLOBALS.G_OPR_DELETE;
589: ELSE
590: IF l_debug_level > 0 THEN
591: oe_debug_pub.add( 'THE SELECTED OPERATION IS SET TO NONE' ) ;
592: END IF;

Line 594: OE_GLOBALS.G_OPR_NONE;

590: IF l_debug_level > 0 THEN
591: oe_debug_pub.add( 'THE SELECTED OPERATION IS SET TO NONE' ) ;
592: END IF;
593: l_line_adj_tbl(l_charge_index).operation :=
594: OE_GLOBALS.G_OPR_NONE;
595: END IF;
596: EXIT;
597: END IF;
598:

Line 612: OE_GLOBALS.G_OPR_UPDATE

608: l_att_index := l_line_adj_att_tbl.FIRST;
609: WHILE l_att_index IS NOT NULL LOOP
610:
611: IF l_line_adj_att_tbl(l_att_index).operation =
612: OE_GLOBALS.G_OPR_UPDATE
613: AND l_line_adj_tbl(l_charge_index).price_adjustment_id =
614: l_line_adj_att_tbl(l_att_index).price_adjustment_id
615: THEN
616:

Line 618: OE_GLOBALS.G_OPR_DELETE;

614: l_line_adj_att_tbl(l_att_index).price_adjustment_id
615: THEN
616:
617: l_line_adj_att_tbl(l_att_index).operation :=
618: OE_GLOBALS.G_OPR_DELETE;
619:
620: ELSIF l_line_adj_att_tbl(l_att_index).operation =
621: OE_GLOBALS.G_OPR_CREATE
622: AND l_charge_index = l_line_adj_att_tbl(l_att_index).adj_index

Line 621: OE_GLOBALS.G_OPR_CREATE

617: l_line_adj_att_tbl(l_att_index).operation :=
618: OE_GLOBALS.G_OPR_DELETE;
619:
620: ELSIF l_line_adj_att_tbl(l_att_index).operation =
621: OE_GLOBALS.G_OPR_CREATE
622: AND l_charge_index = l_line_adj_att_tbl(l_att_index).adj_index
623: THEN
624:
625: l_line_adj_att_tbl(l_att_index).operation :=

Line 626: OE_GLOBALS.G_OPR_NONE;

622: AND l_charge_index = l_line_adj_att_tbl(l_att_index).adj_index
623: THEN
624:
625: l_line_adj_att_tbl(l_att_index).operation :=
626: OE_GLOBALS.G_OPR_NONE;
627:
628: END IF;
629:
630: l_att_index := l_line_adj_att_tbl.NEXT(l_att_index);

Line 634: IF l_line_adj_tbl(l_charge_index).operation = OE_GLOBALS.G_OPR_NONE

630: l_att_index := l_line_adj_att_tbl.NEXT(l_att_index);
631: END LOOP; /* For Line Adj Att table */
632:
633: END IF;
634: IF l_line_adj_tbl(l_charge_index).operation = OE_GLOBALS.G_OPR_NONE
635: THEN
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add( 'THE DELETING CHARGE TYPE IS ' || L_LINE_ADJ_TBL ( L_CHARGE_INDEX ) .CHARGE_TYPE_CODE ) ;
638: END IF;

Line 690: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)

686:
687: IF l_Header_adj_tbl(l_charge_index).list_line_type_code = 'FREIGHT_CHARGE'
688: AND NVL(l_Header_adj_tbl(l_charge_index).applied_flag,'N') = 'Y'
689: AND l_Header_adj_tbl(l_charge_index).operation IN
690: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)
691: AND l_Header_adj_tbl(l_charge_index).Header_id = l_header_id
692: AND (l_Header_adj_tbl(l_charge_index).line_id IS NULL OR
693: l_Header_adj_tbl(l_charge_index).line_id = FND_API.G_MISS_NUM)
694: THEN

Line 701: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)

697: WHILE l_tmp_index IS NOT NULL LOOP
698:
699: IF l_tmp_index <> l_charge_index
700: AND l_Header_adj_tbl(l_tmp_index).operation IN
701: (OE_GLOBALS.G_OPR_UPDATE, OE_GLOBALS.G_OPR_CREATE)
702: AND l_Header_adj_tbl(l_tmp_index).list_Line_type_code
703: = 'FREIGHT_CHARGE'
704: AND NVL(l_Header_adj_tbl(l_tmp_index).applied_flag,'N') = 'Y'
705: AND l_Header_adj_tbl(l_charge_index).charge_type_code

Line 715: OE_GLOBALS.G_OPR_UPDATE

711: IF l_Header_adj_tbl(l_tmp_index).adjusted_amount >=
712: l_Header_adj_tbl(l_charge_index).adjusted_amount
713: THEN
714: IF l_Header_adj_tbl(l_charge_index).operation =
715: OE_GLOBALS.G_OPR_UPDATE
716: THEN
717: l_Header_adj_tbl(l_charge_index).operation :=
718: OE_GLOBALS.G_OPR_DELETE;
719: ELSE

Line 718: OE_GLOBALS.G_OPR_DELETE;

714: IF l_Header_adj_tbl(l_charge_index).operation =
715: OE_GLOBALS.G_OPR_UPDATE
716: THEN
717: l_Header_adj_tbl(l_charge_index).operation :=
718: OE_GLOBALS.G_OPR_DELETE;
719: ELSE
720: l_Header_adj_tbl(l_charge_index).operation :=
721: OE_GLOBALS.G_OPR_NONE;
722: END IF;

Line 721: OE_GLOBALS.G_OPR_NONE;

717: l_Header_adj_tbl(l_charge_index).operation :=
718: OE_GLOBALS.G_OPR_DELETE;
719: ELSE
720: l_Header_adj_tbl(l_charge_index).operation :=
721: OE_GLOBALS.G_OPR_NONE;
722: END IF;
723: EXIT;
724: END IF;
725:

Line 739: OE_GLOBALS.G_OPR_UPDATE

735: l_att_index := l_Header_adj_att_tbl.FIRST;
736: WHILE l_att_index IS NOT NULL LOOP
737:
738: IF l_Header_adj_att_tbl(l_att_index).operation =
739: OE_GLOBALS.G_OPR_UPDATE
740: AND l_Header_adj_tbl(l_charge_index).price_adjustment_id =
741: l_Header_adj_att_tbl(l_att_index).price_adjustment_id
742: THEN
743:

Line 745: OE_GLOBALS.G_OPR_DELETE;

741: l_Header_adj_att_tbl(l_att_index).price_adjustment_id
742: THEN
743:
744: l_Header_adj_att_tbl(l_att_index).operation :=
745: OE_GLOBALS.G_OPR_DELETE;
746:
747: ELSIF l_Header_adj_att_tbl(l_att_index).operation =
748: OE_GLOBALS.G_OPR_CREATE
749: AND l_charge_index = l_Header_adj_att_tbl(l_att_index).adj_index

Line 748: OE_GLOBALS.G_OPR_CREATE

744: l_Header_adj_att_tbl(l_att_index).operation :=
745: OE_GLOBALS.G_OPR_DELETE;
746:
747: ELSIF l_Header_adj_att_tbl(l_att_index).operation =
748: OE_GLOBALS.G_OPR_CREATE
749: AND l_charge_index = l_Header_adj_att_tbl(l_att_index).adj_index
750: THEN
751:
752: l_Header_adj_att_tbl(l_att_index).operation :=

Line 753: OE_GLOBALS.G_OPR_NONE;

749: AND l_charge_index = l_Header_adj_att_tbl(l_att_index).adj_index
750: THEN
751:
752: l_Header_adj_att_tbl(l_att_index).operation :=
753: OE_GLOBALS.G_OPR_NONE;
754:
755: END IF;
756:
757: l_att_index := l_Header_adj_att_tbl.NEXT(l_att_index);