8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
13: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
15: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
16: )
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
13: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
15: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
16: )
17: IS
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
13: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
15: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
13: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
15: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
334:
335: -- Procedure Apply_Attribute_Changes
336:
337: PROCEDURE Apply_Attribute_Changes
338: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
339: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
340: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
341: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
342: )
335: -- Procedure Apply_Attribute_Changes
336:
337: PROCEDURE Apply_Attribute_Changes
338: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
339: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
340: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
341: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
342: )
343: IS
336:
337: PROCEDURE Apply_Attribute_Changes
338: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
339: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
340: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
341: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
342: )
343: IS
344: BEGIN
337: PROCEDURE Apply_Attribute_Changes
338: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
339: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
340: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
341: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
342: )
343: IS
344: BEGIN
345:
518:
519: -- Function Complete_Record
520:
521: FUNCTION Complete_Record
522: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
523: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
524: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
525: IS
526: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
519: -- Function Complete_Record
520:
521: FUNCTION Complete_Record
522: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
523: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
524: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
525: IS
526: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
527: BEGIN
520:
521: FUNCTION Complete_Record
522: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
523: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
524: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
525: IS
526: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
527: BEGIN
528:
522: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
523: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
524: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
525: IS
526: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
527: BEGIN
528:
529: oe_debug_pub.add('Entering proc Complete_Record in FormulaLines Util Pkg');
530: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
666:
667: -- Function Convert_Miss_To_Null
668:
669: FUNCTION Convert_Miss_To_Null
670: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
671: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
672: IS
673: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
674: BEGIN
667: -- Function Convert_Miss_To_Null
668:
669: FUNCTION Convert_Miss_To_Null
670: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
671: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
672: IS
673: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
674: BEGIN
675:
669: FUNCTION Convert_Miss_To_Null
670: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
671: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
672: IS
673: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
674: BEGIN
675:
676: oe_debug_pub.add('Entering proc Convert_Miss_To_Null in FormulaLines Util Pkg');
677: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
813:
814: -- Procedure Update_Row
815:
816: PROCEDURE Update_Row
817: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
818: )
819: IS
820: BEGIN
821:
888:
889: -- Procedure Insert_Row
890:
891: PROCEDURE Insert_Row
892: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
893: )
894: IS
895: BEGIN
896:
1031: -- Function Query_Row
1032:
1033: FUNCTION Query_Row
1034: ( p_price_formula_line_id IN NUMBER
1035: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1036: IS
1037: BEGIN
1038:
1039: oe_debug_pub.add('Entering and Leaving proc Query_Row in FormulaLines Util Pkg');
1051: ( p_price_formula_line_id IN NUMBER :=
1052: FND_API.G_MISS_NUM
1053: , p_price_formula_id IN NUMBER :=
1054: FND_API.G_MISS_NUM
1055: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type
1056: IS
1057: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1058: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1059:
1053: , p_price_formula_id IN NUMBER :=
1054: FND_API.G_MISS_NUM
1055: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type
1056: IS
1057: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1058: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1059:
1060: CURSOR l_FORMULA_LINES_csr IS
1061: SELECT ATTRIBUTE1
1054: FND_API.G_MISS_NUM
1055: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type
1056: IS
1057: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1058: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;
1059:
1060: CURSOR l_FORMULA_LINES_csr IS
1061: SELECT ATTRIBUTE1
1062: , ATTRIBUTE10
1208: --
1209:
1210: PROCEDURE Lock_Row
1211: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1212: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1213: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1214: )
1215: IS
1216: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1209:
1210: PROCEDURE Lock_Row
1211: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1212: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1213: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1214: )
1215: IS
1216: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1217: BEGIN
1212: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1213: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1214: )
1215: IS
1216: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1217: BEGIN
1218:
1219: oe_debug_pub.add('Entering proc Lock_Row in FormulaLines Util Pkg');
1220: SELECT ATTRIBUTE1
1427:
1428: -- Function Get_Values
1429:
1430: FUNCTION Get_Values
1431: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1432: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
1433: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
1434: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1435: IS
1428: -- Function Get_Values
1429:
1430: FUNCTION Get_Values
1431: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1432: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
1433: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
1434: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1435: IS
1436: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
1429:
1430: FUNCTION Get_Values
1431: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1432: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
1433: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
1434: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1435: IS
1436: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
1437: BEGIN
1430: FUNCTION Get_Values
1431: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1432: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
1433: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
1434: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1435: IS
1436: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
1437: BEGIN
1438:
1432: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
1433: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
1434: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1435: IS
1436: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type;
1437: BEGIN
1438:
1439: oe_debug_pub.add('Entering proc Get_Values in FormulaLines Util Pkg');
1440: IF p_FORMULA_LINES_rec.price_formula_id IS NOT NULL AND
1494:
1495: -- Function Get_Ids
1496:
1497: FUNCTION Get_Ids
1498: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1499: , p_FORMULA_LINES_val_rec IN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1500: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1501: IS
1502: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1495: -- Function Get_Ids
1496:
1497: FUNCTION Get_Ids
1498: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1499: , p_FORMULA_LINES_val_rec IN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1500: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1501: IS
1502: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1503: BEGIN
1496:
1497: FUNCTION Get_Ids
1498: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1499: , p_FORMULA_LINES_val_rec IN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1500: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1501: IS
1502: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1503: BEGIN
1504:
1498: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1499: , p_FORMULA_LINES_val_rec IN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type
1500: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
1501: IS
1502: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1503: BEGIN
1504:
1505: oe_debug_pub.add('Entering proc Get_Ids in FormulaLines Util Pkg');
1506: -- initialize return_status.