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_FORMULA_LINES_UTIL dependencies on QP_PRICE_FORMULA_PUB

Line 12: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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

Line 13: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=

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

Line 14: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC

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;

Line 15: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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;

Line 338: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_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: )

Line 339: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=

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

Line 340: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC

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

Line 341: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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:

Line 522: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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;

Line 523: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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

Line 524: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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:

Line 526: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;

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

Line 670: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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

Line 671: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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:

Line 673: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;

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

Line 817: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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:

Line 892: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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:

Line 1035: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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

Line 1055: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type

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:

Line 1057: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

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

Line 1058: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

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

Line 1212: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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;

Line 1213: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ 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

Line 1216: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

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

Line 1431: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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

Line 1432: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=

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;

Line 1433: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC

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

Line 1434: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Val_Rec_Type

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:

Line 1436: l_FORMULA_LINES_val_rec QP_Price_Formula_PUB.Formula_Lines_Val_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:
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

Line 1498: ( p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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;

Line 1499: , p_FORMULA_LINES_val_rec IN QP_Price_Formula_PUB.Formula_Lines_Val_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

Line 1500: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Rec_Type

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:

Line 1502: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;

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.