APPS.QP_FORMULA_UTIL dependencies on QP_PRICE_FORMULA_PUB

Line 12: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_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_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
13: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
15: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
16: )

Line 13: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
13: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
15: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
16: )
17: IS

Line 14: QP_Price_Formula_PUB.G_MISS_FORMULA_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
13: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
15: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
13: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
15: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 284: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

280:
281: -- Procedure Apply_Attribute_Changes
282:
283: PROCEDURE Apply_Attribute_Changes
284: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
285: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
286: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
287: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
288: )

Line 285: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=

281: -- Procedure Apply_Attribute_Changes
282:
283: PROCEDURE Apply_Attribute_Changes
284: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
285: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
286: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
287: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
288: )
289: IS

Line 286: QP_Price_Formula_PUB.G_MISS_FORMULA_REC

282:
283: PROCEDURE Apply_Attribute_Changes
284: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
285: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
286: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
287: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
288: )
289: IS
290: BEGIN

Line 287: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type

283: PROCEDURE Apply_Attribute_Changes
284: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
285: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
286: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
287: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
288: )
289: IS
290: BEGIN
291:

Line 438: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

434:
435: -- Function Complete_Record
436:
437: FUNCTION Complete_Record
438: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
439: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
440: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
441: IS
442: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;

Line 439: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

435: -- Function Complete_Record
436:
437: FUNCTION Complete_Record
438: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
439: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
440: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
441: IS
442: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;
443: BEGIN

Line 440: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type

436:
437: FUNCTION Complete_Record
438: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
439: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
440: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
441: IS
442: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;
443: BEGIN
444:

Line 442: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;

438: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
439: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
440: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
441: IS
442: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;
443: BEGIN
444:
445: oe_debug_pub.add('Entering proc Complete_Record in Formula Util Pkg');
446: IF l_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 562: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

558:
559: -- Function Convert_Miss_To_Null
560:
561: FUNCTION Convert_Miss_To_Null
562: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
563: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
564: IS
565: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;
566: BEGIN

Line 563: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type

559: -- Function Convert_Miss_To_Null
560:
561: FUNCTION Convert_Miss_To_Null
562: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
563: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
564: IS
565: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;
566: BEGIN
567:

Line 565: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;

561: FUNCTION Convert_Miss_To_Null
562: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
563: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
564: IS
565: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;
566: BEGIN
567:
568: oe_debug_pub.add('Entering proc Convert_Miss_To_Null in Formula Util Pkg');
569: IF l_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 685: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

681:
682: -- Procedure Update_Row
683:
684: PROCEDURE Update_Row
685: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
686: )
687: IS
688: BEGIN
689:

Line 750: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

746:
747: -- Procedure Insert_Row
748:
749: PROCEDURE Insert_Row
750: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
751: )
752: IS
753: BEGIN
754:

Line 893: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type

889: -- Function Query_Row
890:
891: FUNCTION Query_Row
892: ( p_price_formula_id IN NUMBER
893: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
894: IS
895: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
896: BEGIN
897:

Line 895: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

891: FUNCTION Query_Row
892: ( p_price_formula_id IN NUMBER
893: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
894: IS
895: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
896: BEGIN
897:
898: oe_debug_pub.add('Entering proc Query_Row in Formula Util Pkg');
899: SELECT ATTRIBUTE1

Line 985: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

981: --
982:
983: PROCEDURE Lock_Row
984: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
985: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
986: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
987: )
988: IS
989: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

Line 986: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type

982:
983: PROCEDURE Lock_Row
984: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
985: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
986: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
987: )
988: IS
989: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
990: BEGIN

Line 989: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

985: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
986: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
987: )
988: IS
989: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
990: BEGIN
991:
992: oe_debug_pub.add('Entering proc Lock_Row in Formula Util Pkg');
993: SELECT ATTRIBUTE1

Line 1172: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

1168:
1169: -- Function Get_Values
1170:
1171: FUNCTION Get_Values
1172: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
1173: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
1174: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
1175: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1176: IS

Line 1173: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=

1169: -- Function Get_Values
1170:
1171: FUNCTION Get_Values
1172: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
1173: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
1174: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
1175: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1176: IS
1177: l_FORMULA_val_rec QP_Price_Formula_PUB.Formula_Val_Rec_Type;

Line 1174: QP_Price_Formula_PUB.G_MISS_FORMULA_REC

1170:
1171: FUNCTION Get_Values
1172: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
1173: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
1174: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
1175: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1176: IS
1177: l_FORMULA_val_rec QP_Price_Formula_PUB.Formula_Val_Rec_Type;
1178: BEGIN

Line 1175: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type

1171: FUNCTION Get_Values
1172: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
1173: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
1174: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
1175: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1176: IS
1177: l_FORMULA_val_rec QP_Price_Formula_PUB.Formula_Val_Rec_Type;
1178: BEGIN
1179:

Line 1177: l_FORMULA_val_rec QP_Price_Formula_PUB.Formula_Val_Rec_Type;

1173: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
1174: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
1175: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1176: IS
1177: l_FORMULA_val_rec QP_Price_Formula_PUB.Formula_Val_Rec_Type;
1178: BEGIN
1179:
1180: oe_debug_pub.add('Entering proc Get_Values in Formula Util Pkg');
1181: IF p_FORMULA_rec.price_formula_id IS NOT NULL AND

Line 1199: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

1195:
1196: -- Function Get_Ids
1197:
1198: FUNCTION Get_Ids
1199: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
1200: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1201: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
1202: IS
1203: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

Line 1200: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type

1196: -- Function Get_Ids
1197:
1198: FUNCTION Get_Ids
1199: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
1200: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1201: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
1202: IS
1203: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1204: BEGIN

Line 1201: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type

1197:
1198: FUNCTION Get_Ids
1199: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
1200: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1201: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
1202: IS
1203: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1204: BEGIN
1205:

Line 1203: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;

1199: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
1200: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
1201: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type
1202: IS
1203: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1204: BEGIN
1205:
1206: oe_debug_pub.add('Entering proc Get_Ids in Formula Util Pkg');
1207: -- initialize return_status.