eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_QP_FORM_PRICE_LIST_LINE dependencies on QP_GLOBALS

Line 128: l_control_rec QP_GLOBALS.Control_Rec_Type;

124: IS
125: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
126: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
127: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
128: l_control_rec QP_GLOBALS.Control_Rec_Type;
129: l_return_status VARCHAR2(1);
130: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
131: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
132: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 181: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;

177: l_PRICE_LIST_LINE_rec.context := NULL;
178:
179: -- Set Operation to Create
180:
181: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
182:
183: -- Populate PRICE_LIST_LINE table
184:
185: l_PRICE_LIST_LINE_tbl(1) := l_PRICE_LIST_LINE_rec;

Line 495: l_control_rec QP_GLOBALS.Control_Rec_Type;

491: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
492: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
493: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
495: l_control_rec QP_GLOBALS.Control_Rec_Type;
496: l_return_status VARCHAR2(1);
497: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
498: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
499: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 682: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

678:
679: -- Set Operation.
680:
681: IF FND_API.To_Boolean(l_PRICE_LIST_LINE_rec.db_flag) THEN
682: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
683: ELSE
684: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
685: END IF;
686:

Line 684: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;

680:
681: IF FND_API.To_Boolean(l_PRICE_LIST_LINE_rec.db_flag) THEN
682: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
683: ELSE
684: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
685: END IF;
686:
687: -- Populate PRICE_LIST_LINE table
688:

Line 815: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.accrual_qty,

811: );
812:
813: -- Return changed attributes.
814:
815: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.accrual_qty,
816: l_PRICE_LIST_LINE_rec.accrual_qty)
817: THEN
818: x_accrual_qty := l_x_PRICE_LIST_LINE_rec.accrual_qty;
819: END IF;

Line 821: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.accrual_uom_code,

817: THEN
818: x_accrual_qty := l_x_PRICE_LIST_LINE_rec.accrual_qty;
819: END IF;
820:
821: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.accrual_uom_code,
822: l_PRICE_LIST_LINE_rec.accrual_uom_code)
823: THEN
824: x_accrual_uom_code := l_x_PRICE_LIST_LINE_rec.accrual_uom_code;
825: x_accrual_uom := l_PRICE_LIST_LINE_val_rec.accrual_uom;

Line 828: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.arithmetic_operator,

824: x_accrual_uom_code := l_x_PRICE_LIST_LINE_rec.accrual_uom_code;
825: x_accrual_uom := l_PRICE_LIST_LINE_val_rec.accrual_uom;
826: END IF;
827:
828: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.arithmetic_operator,
829: l_PRICE_LIST_LINE_rec.arithmetic_operator)
830: THEN
831: x_arithmetic_operator := l_x_PRICE_LIST_LINE_rec.arithmetic_operator;
832: END IF;

Line 834: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute1,

830: THEN
831: x_arithmetic_operator := l_x_PRICE_LIST_LINE_rec.arithmetic_operator;
832: END IF;
833:
834: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute1,
835: l_PRICE_LIST_LINE_rec.attribute1)
836: THEN
837: x_attribute1 := l_x_PRICE_LIST_LINE_rec.attribute1;
838: END IF;

Line 840: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute10,

836: THEN
837: x_attribute1 := l_x_PRICE_LIST_LINE_rec.attribute1;
838: END IF;
839:
840: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute10,
841: l_PRICE_LIST_LINE_rec.attribute10)
842: THEN
843: x_attribute10 := l_x_PRICE_LIST_LINE_rec.attribute10;
844: END IF;

Line 846: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute11,

842: THEN
843: x_attribute10 := l_x_PRICE_LIST_LINE_rec.attribute10;
844: END IF;
845:
846: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute11,
847: l_PRICE_LIST_LINE_rec.attribute11)
848: THEN
849: x_attribute11 := l_x_PRICE_LIST_LINE_rec.attribute11;
850: END IF;

Line 852: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute12,

848: THEN
849: x_attribute11 := l_x_PRICE_LIST_LINE_rec.attribute11;
850: END IF;
851:
852: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute12,
853: l_PRICE_LIST_LINE_rec.attribute12)
854: THEN
855: x_attribute12 := l_x_PRICE_LIST_LINE_rec.attribute12;
856: END IF;

Line 858: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute13,

854: THEN
855: x_attribute12 := l_x_PRICE_LIST_LINE_rec.attribute12;
856: END IF;
857:
858: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute13,
859: l_PRICE_LIST_LINE_rec.attribute13)
860: THEN
861: x_attribute13 := l_x_PRICE_LIST_LINE_rec.attribute13;
862: END IF;

Line 864: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute14,

860: THEN
861: x_attribute13 := l_x_PRICE_LIST_LINE_rec.attribute13;
862: END IF;
863:
864: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute14,
865: l_PRICE_LIST_LINE_rec.attribute14)
866: THEN
867: x_attribute14 := l_x_PRICE_LIST_LINE_rec.attribute14;
868: END IF;

Line 870: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute15,

866: THEN
867: x_attribute14 := l_x_PRICE_LIST_LINE_rec.attribute14;
868: END IF;
869:
870: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute15,
871: l_PRICE_LIST_LINE_rec.attribute15)
872: THEN
873: x_attribute15 := l_x_PRICE_LIST_LINE_rec.attribute15;
874: END IF;

Line 876: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute2,

872: THEN
873: x_attribute15 := l_x_PRICE_LIST_LINE_rec.attribute15;
874: END IF;
875:
876: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute2,
877: l_PRICE_LIST_LINE_rec.attribute2)
878: THEN
879: x_attribute2 := l_x_PRICE_LIST_LINE_rec.attribute2;
880: END IF;

Line 882: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute3,

878: THEN
879: x_attribute2 := l_x_PRICE_LIST_LINE_rec.attribute2;
880: END IF;
881:
882: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute3,
883: l_PRICE_LIST_LINE_rec.attribute3)
884: THEN
885: x_attribute3 := l_x_PRICE_LIST_LINE_rec.attribute3;
886: END IF;

Line 888: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute4,

884: THEN
885: x_attribute3 := l_x_PRICE_LIST_LINE_rec.attribute3;
886: END IF;
887:
888: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute4,
889: l_PRICE_LIST_LINE_rec.attribute4)
890: THEN
891: x_attribute4 := l_x_PRICE_LIST_LINE_rec.attribute4;
892: END IF;

Line 894: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute5,

890: THEN
891: x_attribute4 := l_x_PRICE_LIST_LINE_rec.attribute4;
892: END IF;
893:
894: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute5,
895: l_PRICE_LIST_LINE_rec.attribute5)
896: THEN
897: x_attribute5 := l_x_PRICE_LIST_LINE_rec.attribute5;
898: END IF;

Line 900: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute6,

896: THEN
897: x_attribute5 := l_x_PRICE_LIST_LINE_rec.attribute5;
898: END IF;
899:
900: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute6,
901: l_PRICE_LIST_LINE_rec.attribute6)
902: THEN
903: x_attribute6 := l_x_PRICE_LIST_LINE_rec.attribute6;
904: END IF;

Line 906: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute7,

902: THEN
903: x_attribute6 := l_x_PRICE_LIST_LINE_rec.attribute6;
904: END IF;
905:
906: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute7,
907: l_PRICE_LIST_LINE_rec.attribute7)
908: THEN
909: x_attribute7 := l_x_PRICE_LIST_LINE_rec.attribute7;
910: END IF;

Line 912: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute8,

908: THEN
909: x_attribute7 := l_x_PRICE_LIST_LINE_rec.attribute7;
910: END IF;
911:
912: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute8,
913: l_PRICE_LIST_LINE_rec.attribute8)
914: THEN
915: x_attribute8 := l_x_PRICE_LIST_LINE_rec.attribute8;
916: END IF;

Line 918: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute9,

914: THEN
915: x_attribute8 := l_x_PRICE_LIST_LINE_rec.attribute8;
916: END IF;
917:
918: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.attribute9,
919: l_PRICE_LIST_LINE_rec.attribute9)
920: THEN
921: x_attribute9 := l_x_PRICE_LIST_LINE_rec.attribute9;
922: END IF;

Line 924: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.automatic_flag,

920: THEN
921: x_attribute9 := l_x_PRICE_LIST_LINE_rec.attribute9;
922: END IF;
923:
924: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.automatic_flag,
925: l_PRICE_LIST_LINE_rec.automatic_flag)
926: THEN
927: x_automatic_flag := l_x_PRICE_LIST_LINE_rec.automatic_flag;
928: x_automatic := l_PRICE_LIST_LINE_val_rec.automatic;

Line 931: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.base_qty,

927: x_automatic_flag := l_x_PRICE_LIST_LINE_rec.automatic_flag;
928: x_automatic := l_PRICE_LIST_LINE_val_rec.automatic;
929: END IF;
930:
931: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.base_qty,
932: l_PRICE_LIST_LINE_rec.base_qty)
933: THEN
934: x_base_qty := l_x_PRICE_LIST_LINE_rec.base_qty;
935: END IF;

Line 937: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.base_uom_code,

933: THEN
934: x_base_qty := l_x_PRICE_LIST_LINE_rec.base_qty;
935: END IF;
936:
937: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.base_uom_code,
938: l_PRICE_LIST_LINE_rec.base_uom_code)
939: THEN
940: x_base_uom_code := l_x_PRICE_LIST_LINE_rec.base_uom_code;
941: x_base_uom := l_PRICE_LIST_LINE_val_rec.base_uom;

Line 944: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.comments,

940: x_base_uom_code := l_x_PRICE_LIST_LINE_rec.base_uom_code;
941: x_base_uom := l_PRICE_LIST_LINE_val_rec.base_uom;
942: END IF;
943:
944: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.comments,
945: l_PRICE_LIST_LINE_rec.comments)
946: THEN
947: x_comments := l_x_PRICE_LIST_LINE_rec.comments;
948: END IF;

Line 950: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.context,

946: THEN
947: x_comments := l_x_PRICE_LIST_LINE_rec.comments;
948: END IF;
949:
950: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.context,
951: l_PRICE_LIST_LINE_rec.context)
952: THEN
953: x_context := l_x_PRICE_LIST_LINE_rec.context;
954: END IF;

Line 956: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.effective_period_uom,

952: THEN
953: x_context := l_x_PRICE_LIST_LINE_rec.context;
954: END IF;
955:
956: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.effective_period_uom,
957: l_PRICE_LIST_LINE_rec.effective_period_uom)
958: THEN
959: x_effective_period_uom := l_x_PRICE_LIST_LINE_rec.effective_period_uom;
960: END IF;

Line 962: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.end_date_active,

958: THEN
959: x_effective_period_uom := l_x_PRICE_LIST_LINE_rec.effective_period_uom;
960: END IF;
961:
962: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.end_date_active,
963: l_PRICE_LIST_LINE_rec.end_date_active)
964: THEN
965: x_end_date_active := l_x_PRICE_LIST_LINE_rec.end_date_active;
966: END IF;

Line 968: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.estim_accrual_rate,

964: THEN
965: x_end_date_active := l_x_PRICE_LIST_LINE_rec.end_date_active;
966: END IF;
967:
968: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.estim_accrual_rate,
969: l_PRICE_LIST_LINE_rec.estim_accrual_rate)
970: THEN
971: x_estim_accrual_rate := l_x_PRICE_LIST_LINE_rec.estim_accrual_rate;
972: END IF;

Line 974: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.generate_using_formula_id,

970: THEN
971: x_estim_accrual_rate := l_x_PRICE_LIST_LINE_rec.estim_accrual_rate;
972: END IF;
973:
974: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.generate_using_formula_id,
975: l_PRICE_LIST_LINE_rec.generate_using_formula_id)
976: THEN
977: x_generate_using_formula_id := l_x_PRICE_LIST_LINE_rec.generate_using_formula_id;
978: x_generate_using_formula := l_PRICE_LIST_LINE_val_rec.generate_using_formula;

Line 981: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.inventory_item_id,

977: x_generate_using_formula_id := l_x_PRICE_LIST_LINE_rec.generate_using_formula_id;
978: x_generate_using_formula := l_PRICE_LIST_LINE_val_rec.generate_using_formula;
979: END IF;
980:
981: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.inventory_item_id,
982: l_PRICE_LIST_LINE_rec.inventory_item_id)
983: THEN
984: x_inventory_item_id := l_x_PRICE_LIST_LINE_rec.inventory_item_id;
985: x_inventory_item := l_PRICE_LIST_LINE_val_rec.inventory_item;

Line 988: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.list_header_id,

984: x_inventory_item_id := l_x_PRICE_LIST_LINE_rec.inventory_item_id;
985: x_inventory_item := l_PRICE_LIST_LINE_val_rec.inventory_item;
986: END IF;
987:
988: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.list_header_id,
989: l_PRICE_LIST_LINE_rec.list_header_id)
990: THEN
991: x_list_header_id := l_x_PRICE_LIST_LINE_rec.list_header_id;
992: x_list_header := l_PRICE_LIST_LINE_val_rec.list_header;

Line 995: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.list_line_id,

991: x_list_header_id := l_x_PRICE_LIST_LINE_rec.list_header_id;
992: x_list_header := l_PRICE_LIST_LINE_val_rec.list_header;
993: END IF;
994:
995: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.list_line_id,
996: l_PRICE_LIST_LINE_rec.list_line_id)
997: THEN
998: x_list_line_id := l_x_PRICE_LIST_LINE_rec.list_line_id;
999: x_list_line := l_PRICE_LIST_LINE_val_rec.list_line;

Line 1002: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.list_line_type_code,

998: x_list_line_id := l_x_PRICE_LIST_LINE_rec.list_line_id;
999: x_list_line := l_PRICE_LIST_LINE_val_rec.list_line;
1000: END IF;
1001:
1002: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.list_line_type_code,
1003: l_PRICE_LIST_LINE_rec.list_line_type_code)
1004: THEN
1005: x_list_line_type_code := l_x_PRICE_LIST_LINE_rec.list_line_type_code;
1006: x_list_line_type := l_PRICE_LIST_LINE_val_rec.list_line_type;

Line 1009: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.list_price,

1005: x_list_line_type_code := l_x_PRICE_LIST_LINE_rec.list_line_type_code;
1006: x_list_line_type := l_PRICE_LIST_LINE_val_rec.list_line_type;
1007: END IF;
1008:
1009: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.list_price,
1010: l_PRICE_LIST_LINE_rec.list_price)
1011: THEN
1012: x_list_price := l_x_PRICE_LIST_LINE_rec.list_price;
1013: END IF;

Line 1015: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.from_rltd_modifier_id,

1011: THEN
1012: x_list_price := l_x_PRICE_LIST_LINE_rec.list_price;
1013: END IF;
1014:
1015: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.from_rltd_modifier_id,
1016: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id)
1017: THEN
1018: x_from_rltd_modifier_id := l_x_PRICE_LIST_LINE_rec.from_rltd_modifier_id;
1019: END IF;

Line 1021: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.rltd_modifier_group_no,

1017: THEN
1018: x_from_rltd_modifier_id := l_x_PRICE_LIST_LINE_rec.from_rltd_modifier_id;
1019: END IF;
1020:
1021: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.rltd_modifier_group_no,
1022: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no)
1023: THEN
1024: x_rltd_modifier_group_no := l_x_PRICE_LIST_LINE_rec.rltd_modifier_group_no;
1025: END IF;

Line 1027: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.product_precedence,

1023: THEN
1024: x_rltd_modifier_group_no := l_x_PRICE_LIST_LINE_rec.rltd_modifier_group_no;
1025: END IF;
1026:
1027: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.product_precedence,
1028: l_PRICE_LIST_LINE_rec.product_precedence)
1029: THEN
1030: x_product_precedence := l_x_PRICE_LIST_LINE_rec.product_precedence;
1031: END IF;

Line 1033: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.modifier_level_code,

1029: THEN
1030: x_product_precedence := l_x_PRICE_LIST_LINE_rec.product_precedence;
1031: END IF;
1032:
1033: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.modifier_level_code,
1034: l_PRICE_LIST_LINE_rec.modifier_level_code)
1035: THEN
1036: x_modifier_level_code := l_x_PRICE_LIST_LINE_rec.modifier_level_code;
1037: x_modifier_level := l_PRICE_LIST_LINE_val_rec.modifier_level;

Line 1040: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.number_effective_periods,

1036: x_modifier_level_code := l_x_PRICE_LIST_LINE_rec.modifier_level_code;
1037: x_modifier_level := l_PRICE_LIST_LINE_val_rec.modifier_level;
1038: END IF;
1039:
1040: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.number_effective_periods,
1041: l_PRICE_LIST_LINE_rec.number_effective_periods)
1042: THEN
1043: x_number_effective_periods := l_x_PRICE_LIST_LINE_rec.number_effective_periods;
1044: END IF;

Line 1046: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.operand,

1042: THEN
1043: x_number_effective_periods := l_x_PRICE_LIST_LINE_rec.number_effective_periods;
1044: END IF;
1045:
1046: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.operand,
1047: l_PRICE_LIST_LINE_rec.operand)
1048: THEN
1049: x_operand := l_x_PRICE_LIST_LINE_rec.operand;
1050: END IF;

Line 1052: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.organization_id,

1048: THEN
1049: x_operand := l_x_PRICE_LIST_LINE_rec.operand;
1050: END IF;
1051:
1052: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.organization_id,
1053: l_PRICE_LIST_LINE_rec.organization_id)
1054: THEN
1055: x_organization_id := l_x_PRICE_LIST_LINE_rec.organization_id;
1056: x_organization := l_PRICE_LIST_LINE_val_rec.organization;

Line 1059: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.override_flag,

1055: x_organization_id := l_x_PRICE_LIST_LINE_rec.organization_id;
1056: x_organization := l_PRICE_LIST_LINE_val_rec.organization;
1057: END IF;
1058:
1059: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.override_flag,
1060: l_PRICE_LIST_LINE_rec.override_flag)
1061: THEN
1062: x_override_flag := l_x_PRICE_LIST_LINE_rec.override_flag;
1063: x_override := l_PRICE_LIST_LINE_val_rec.override;

Line 1066: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.percent_price,

1062: x_override_flag := l_x_PRICE_LIST_LINE_rec.override_flag;
1063: x_override := l_PRICE_LIST_LINE_val_rec.override;
1064: END IF;
1065:
1066: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.percent_price,
1067: l_PRICE_LIST_LINE_rec.percent_price)
1068: THEN
1069: x_percent_price := l_x_PRICE_LIST_LINE_rec.percent_price;
1070: END IF;

Line 1072: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.price_break_type_code,

1068: THEN
1069: x_percent_price := l_x_PRICE_LIST_LINE_rec.percent_price;
1070: END IF;
1071:
1072: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.price_break_type_code,
1073: l_PRICE_LIST_LINE_rec.price_break_type_code)
1074: THEN
1075: x_price_break_type_code := l_x_PRICE_LIST_LINE_rec.price_break_type_code;
1076: x_price_break_type := l_PRICE_LIST_LINE_val_rec.price_break_type;

Line 1079: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.price_by_formula_id,

1075: x_price_break_type_code := l_x_PRICE_LIST_LINE_rec.price_break_type_code;
1076: x_price_break_type := l_PRICE_LIST_LINE_val_rec.price_break_type;
1077: END IF;
1078:
1079: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.price_by_formula_id,
1080: l_PRICE_LIST_LINE_rec.price_by_formula_id)
1081: THEN
1082: x_price_by_formula_id := l_x_PRICE_LIST_LINE_rec.price_by_formula_id;
1083: x_price_by_formula := l_PRICE_LIST_LINE_val_rec.price_by_formula;

Line 1086: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.primary_uom_flag,

1082: x_price_by_formula_id := l_x_PRICE_LIST_LINE_rec.price_by_formula_id;
1083: x_price_by_formula := l_PRICE_LIST_LINE_val_rec.price_by_formula;
1084: END IF;
1085:
1086: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.primary_uom_flag,
1087: l_PRICE_LIST_LINE_rec.primary_uom_flag)
1088: THEN
1089: x_primary_uom_flag := l_x_PRICE_LIST_LINE_rec.primary_uom_flag;
1090: x_primary_uom := l_PRICE_LIST_LINE_val_rec.primary_uom;

Line 1093: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.print_on_invoice_flag,

1089: x_primary_uom_flag := l_x_PRICE_LIST_LINE_rec.primary_uom_flag;
1090: x_primary_uom := l_PRICE_LIST_LINE_val_rec.primary_uom;
1091: END IF;
1092:
1093: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.print_on_invoice_flag,
1094: l_PRICE_LIST_LINE_rec.print_on_invoice_flag)
1095: THEN
1096: x_print_on_invoice_flag := l_x_PRICE_LIST_LINE_rec.print_on_invoice_flag;
1097: x_print_on_invoice := l_PRICE_LIST_LINE_val_rec.print_on_invoice;

Line 1100: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.rebate_trxn_type_code,

1096: x_print_on_invoice_flag := l_x_PRICE_LIST_LINE_rec.print_on_invoice_flag;
1097: x_print_on_invoice := l_PRICE_LIST_LINE_val_rec.print_on_invoice;
1098: END IF;
1099:
1100: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.rebate_trxn_type_code,
1101: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
1102: THEN
1103: x_rebate_trxn_type_code := l_x_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
1104: x_rebate_transaction_type := l_PRICE_LIST_LINE_val_rec.rebate_transaction_type;

Line 1109: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.recurring_value,

1105: END IF;
1106:
1107:
1108: -- block pricing
1109: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.recurring_value,
1110: l_PRICE_LIST_LINE_rec.recurring_value)
1111: THEN
1112: x_recurring_value := l_x_PRICE_LIST_LINE_rec.recurring_value;
1113: END IF;

Line 1116: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.related_item_id,

1112: x_recurring_value := l_x_PRICE_LIST_LINE_rec.recurring_value;
1113: END IF;
1114:
1115:
1116: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.related_item_id,
1117: l_PRICE_LIST_LINE_rec.related_item_id)
1118: THEN
1119: x_related_item_id := l_x_PRICE_LIST_LINE_rec.related_item_id;
1120: x_related_item := l_PRICE_LIST_LINE_val_rec.related_item;

Line 1123: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.relationship_type_id,

1119: x_related_item_id := l_x_PRICE_LIST_LINE_rec.related_item_id;
1120: x_related_item := l_PRICE_LIST_LINE_val_rec.related_item;
1121: END IF;
1122:
1123: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.relationship_type_id,
1124: l_PRICE_LIST_LINE_rec.relationship_type_id)
1125: THEN
1126: x_relationship_type_id := l_x_PRICE_LIST_LINE_rec.relationship_type_id;
1127: x_relationship_type := l_PRICE_LIST_LINE_val_rec.relationship_type;

Line 1130: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.reprice_flag,

1126: x_relationship_type_id := l_x_PRICE_LIST_LINE_rec.relationship_type_id;
1127: x_relationship_type := l_PRICE_LIST_LINE_val_rec.relationship_type;
1128: END IF;
1129:
1130: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.reprice_flag,
1131: l_PRICE_LIST_LINE_rec.reprice_flag)
1132: THEN
1133: x_reprice_flag := l_x_PRICE_LIST_LINE_rec.reprice_flag;
1134: x_reprice := l_PRICE_LIST_LINE_val_rec.reprice;

Line 1137: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.revision,

1133: x_reprice_flag := l_x_PRICE_LIST_LINE_rec.reprice_flag;
1134: x_reprice := l_PRICE_LIST_LINE_val_rec.reprice;
1135: END IF;
1136:
1137: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.revision,
1138: l_PRICE_LIST_LINE_rec.revision)
1139: THEN
1140: x_revision := l_x_PRICE_LIST_LINE_rec.revision;
1141: END IF;

Line 1143: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.revision_date,

1139: THEN
1140: x_revision := l_x_PRICE_LIST_LINE_rec.revision;
1141: END IF;
1142:
1143: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.revision_date,
1144: l_PRICE_LIST_LINE_rec.revision_date)
1145: THEN
1146: x_revision_date := l_x_PRICE_LIST_LINE_rec.revision_date;
1147: END IF;

Line 1149: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.revision_reason_code,

1145: THEN
1146: x_revision_date := l_x_PRICE_LIST_LINE_rec.revision_date;
1147: END IF;
1148:
1149: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.revision_reason_code,
1150: l_PRICE_LIST_LINE_rec.revision_reason_code)
1151: THEN
1152: x_revision_reason_code := l_x_PRICE_LIST_LINE_rec.revision_reason_code;
1153: x_revision_reason := l_PRICE_LIST_LINE_val_rec.revision_reason;

Line 1156: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.start_date_active,

1152: x_revision_reason_code := l_x_PRICE_LIST_LINE_rec.revision_reason_code;
1153: x_revision_reason := l_PRICE_LIST_LINE_val_rec.revision_reason;
1154: END IF;
1155:
1156: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.start_date_active,
1157: l_PRICE_LIST_LINE_rec.start_date_active)
1158: THEN
1159: x_start_date_active := l_x_PRICE_LIST_LINE_rec.start_date_active;
1160: END IF;

Line 1162: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.substitution_attribute,

1158: THEN
1159: x_start_date_active := l_x_PRICE_LIST_LINE_rec.start_date_active;
1160: END IF;
1161:
1162: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.substitution_attribute,
1163: l_PRICE_LIST_LINE_rec.substitution_attribute)
1164: THEN
1165: x_substitution_attribute := l_x_PRICE_LIST_LINE_rec.substitution_attribute;
1166: END IF;

Line 1168: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.substitution_context,

1164: THEN
1165: x_substitution_attribute := l_x_PRICE_LIST_LINE_rec.substitution_attribute;
1166: END IF;
1167:
1168: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.substitution_context,
1169: l_PRICE_LIST_LINE_rec.substitution_context)
1170: THEN
1171: x_substitution_context := l_x_PRICE_LIST_LINE_rec.substitution_context;
1172: END IF;

Line 1174: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.substitution_value,

1170: THEN
1171: x_substitution_context := l_x_PRICE_LIST_LINE_rec.substitution_context;
1172: END IF;
1173:
1174: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.substitution_value,
1175: l_PRICE_LIST_LINE_rec.substitution_value)
1176: THEN
1177: x_substitution_value := l_x_PRICE_LIST_LINE_rec.substitution_value;
1178: END IF;

Line 1180: IF NOT QP_GLOBALS.Equal (l_x_PRICE_LIST_LINE_rec.customer_item_id,

1176: THEN
1177: x_substitution_value := l_x_PRICE_LIST_LINE_rec.substitution_value;
1178: END IF;
1179:
1180: IF NOT QP_GLOBALS.Equal (l_x_PRICE_LIST_LINE_rec.customer_item_id,
1181: l_PRICE_LIST_LINE_rec.customer_item_id)
1182: THEN
1183: x_customer_item_id := l_x_PRICE_LIST_LINE_rec.customer_item_id;
1184: END IF;

Line 1186: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.break_uom_code,

1182: THEN
1183: x_customer_item_id := l_x_PRICE_LIST_LINE_rec.customer_item_id;
1184: END IF;
1185:
1186: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.break_uom_code,
1187: l_PRICE_LIST_LINE_rec.break_uom_code)
1188: THEN
1189: x_break_uom_code := l_x_PRICE_LIST_LINE_rec.break_uom_code;
1190: END IF;

Line 1192: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.break_uom_context,

1188: THEN
1189: x_break_uom_code := l_x_PRICE_LIST_LINE_rec.break_uom_code;
1190: END IF;
1191:
1192: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.break_uom_context,
1193: l_PRICE_LIST_LINE_rec.break_uom_context)
1194: THEN
1195: x_break_uom_context := l_x_PRICE_LIST_LINE_rec.break_uom_context;
1196: END IF;

Line 1198: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.break_uom_attribute,

1194: THEN
1195: x_break_uom_context := l_x_PRICE_LIST_LINE_rec.break_uom_context;
1196: END IF;
1197:
1198: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.break_uom_attribute,
1199: l_PRICE_LIST_LINE_rec.break_uom_attribute)
1200: THEN
1201: x_break_uom_attribute := l_x_PRICE_LIST_LINE_rec.break_uom_attribute;
1202: END IF;

Line 1204: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.continuous_price_break_flag,

1200: THEN
1201: x_break_uom_attribute := l_x_PRICE_LIST_LINE_rec.break_uom_attribute;
1202: END IF;
1203:
1204: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_LINE_rec.continuous_price_break_flag,
1205: l_PRICE_LIST_LINE_rec.continuous_price_break_flag)
1206: THEN
1207: x_continuous_price_break_flag := l_x_PRICE_LIST_LINE_rec.continuous_price_break_flag;
1208: END IF;

Line 1298: l_control_rec QP_GLOBALS.Control_Rec_Type;

1294: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1295: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1296: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1297: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1298: l_control_rec QP_GLOBALS.Control_Rec_Type;
1299: l_return_status VARCHAR2(1);
1300: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1301: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1302: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1338: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

1334:
1335: -- Set Operation.
1336:
1337: IF FND_API.To_Boolean(l_PRICE_LIST_LINE_rec.db_flag) THEN
1338: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1339: ELSE
1340: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1341: END IF;
1342:

Line 1340: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;

1336:
1337: IF FND_API.To_Boolean(l_PRICE_LIST_LINE_rec.db_flag) THEN
1338: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1339: ELSE
1340: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1341: END IF;
1342:
1343: -- Populate PRICE_LIST_LINE table
1344:

Line 1464: l_control_rec QP_GLOBALS.Control_Rec_Type;

1460: )
1461: IS
1462: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1463: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1464: l_control_rec QP_GLOBALS.Control_Rec_Type;
1465: l_return_status VARCHAR2(1);
1466: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1467: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1468: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1499: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_DELETE;

1495: );
1496:
1497: -- Set Operation.
1498:
1499: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_DELETE;
1500:
1501: -- Populate PRICE_LIST_LINE table
1502:
1503: l_PRICE_LIST_LINE_tbl(1) := l_PRICE_LIST_LINE_rec;

Line 1598: l_control_rec QP_GLOBALS.Control_Rec_Type;

1594: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1595: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1596: )
1597: IS
1598: l_control_rec QP_GLOBALS.Control_Rec_Type;
1599: l_return_status VARCHAR2(1);
1600: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1602: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1613: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE;

1609: -- Set control flags.
1610:
1611: l_control_rec.controlled_operation := TRUE;
1612: l_control_rec.process := TRUE;
1613: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE;
1614:
1615: l_control_rec.default_attributes := FALSE;
1616: l_control_rec.change_attributes := FALSE;
1617: l_control_rec.validate_entity := FALSE;

Line 1861: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_LOCK;

1857: l_PRICE_LIST_LINE_rec.start_date_active := p_start_date_active;
1858: l_PRICE_LIST_LINE_rec.substitution_attribute := p_substitution_attribute;
1859: l_PRICE_LIST_LINE_rec.substitution_context := p_substitution_context;
1860: l_PRICE_LIST_LINE_rec.substitution_value := p_substitution_value;
1861: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_LOCK;
1862: l_PRICE_LIST_LINE_rec.recurring_value := p_recurring_value; -- block pricing
1863: l_PRICE_LIST_LINE_rec.customer_item_id := p_customer_item_id;
1864: l_PRICE_LIST_LINE_rec.break_uom_code := p_break_uom_code;
1865: l_PRICE_LIST_LINE_rec.break_uom_context := p_break_uom_context;

Line 2028: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE

2024: BEGIN
2025: OE_MSG_PUB.initialize;
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2028: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE
2029: ,p_entity_id => p_list_line_id
2030: ,x_return_status => l_return_status);
2031:
2032: OE_MSG_PUB.Count_And_Get