APPS.QP_QUALIFIER_RULES_UTIL dependencies on QP_QUALIFIER_RULES_PUB

Line 12: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_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_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
13: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
16: )

Line 13: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
13: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
16: )
17: IS

Line 14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
13: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
13: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 291: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

287:
288: -- Procedure Apply_Attribute_Changes
289:
290: PROCEDURE Apply_Attribute_Changes
291: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
292: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
293: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
294: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
295: )

Line 292: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=

288: -- Procedure Apply_Attribute_Changes
289:
290: PROCEDURE Apply_Attribute_Changes
291: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
292: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
293: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
294: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
295: )
296: IS

Line 293: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC

289:
290: PROCEDURE Apply_Attribute_Changes
291: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
292: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
293: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
294: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
295: )
296: IS
297: BEGIN

Line 294: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

290: PROCEDURE Apply_Attribute_Changes
291: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
292: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
293: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
294: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
295: )
296: IS
297: BEGIN
298:

Line 448: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

444:
445: -- Function Complete_Record
446:
447: FUNCTION Complete_Record
448: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
449: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
450: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
451: IS
452: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;

Line 449: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

445: -- Function Complete_Record
446:
447: FUNCTION Complete_Record
448: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
449: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
450: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
451: IS
452: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
453: BEGIN

Line 450: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

446:
447: FUNCTION Complete_Record
448: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
449: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
450: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
451: IS
452: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
453: BEGIN
454:

Line 452: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;

448: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
449: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
450: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
451: IS
452: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
453: BEGIN
454:
455: IF l_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
456: l_QUALIFIER_RULES_rec.attribute1 := p_old_QUALIFIER_RULES_rec.attribute1;

Line 574: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

570:
571: -- Function Convert_Miss_To_Null
572:
573: FUNCTION Convert_Miss_To_Null
574: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
575: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
576: IS
577: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
578: BEGIN

Line 575: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

571: -- Function Convert_Miss_To_Null
572:
573: FUNCTION Convert_Miss_To_Null
574: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
575: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
576: IS
577: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
578: BEGIN
579:

Line 577: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;

573: FUNCTION Convert_Miss_To_Null
574: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
575: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
576: IS
577: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
578: BEGIN
579:
580: IF l_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
581: l_QUALIFIER_RULES_rec.attribute1 := NULL;

Line 699: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

695:
696: -- Procedure Update_Row
697:
698: PROCEDURE Update_Row
699: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
700: )
701: IS
702: BEGIN
703:

Line 755: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

751:
752: -- Procedure Insert_Row
753:
754: PROCEDURE Insert_Row
755: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
756: )
757: IS
758: BEGIN
759:

Line 879: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

875: -- Function Query_Row
876:
877: FUNCTION Query_Row
878: ( p_qualifier_rule_id IN NUMBER
879: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
880: IS
881: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
882: BEGIN
883:

Line 881: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

877: FUNCTION Query_Row
878: ( p_qualifier_rule_id IN NUMBER
879: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
880: IS
881: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
882: BEGIN
883:
884: SELECT ATTRIBUTE1
885: , ATTRIBUTE10

Line 967: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

963: --
964:
965: PROCEDURE Lock_Row
966: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
967: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
968: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
969: )
970: IS
971: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

Line 968: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

964:
965: PROCEDURE Lock_Row
966: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
967: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
968: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
969: )
970: IS
971: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
972: BEGIN

Line 971: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

967: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
968: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
969: )
970: IS
971: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
972: BEGIN
973:
974:
975:

Line 1172: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

1168:
1169: -- Function Get_Values
1170:
1171: FUNCTION Get_Values
1172: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1173: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1174: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1175: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1176: IS

Line 1173: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=

1169: -- Function Get_Values
1170:
1171: FUNCTION Get_Values
1172: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1173: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1174: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1175: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1176: IS
1177: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;

Line 1174: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC

1170:
1171: FUNCTION Get_Values
1172: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1173: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1174: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1175: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1176: IS
1177: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1178: BEGIN

Line 1175: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type

1171: FUNCTION Get_Values
1172: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1173: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1174: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1175: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1176: IS
1177: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1178: BEGIN
1179:

Line 1177: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;

1173: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1174: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1175: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1176: IS
1177: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1178: BEGIN
1179:
1180: IF p_QUALIFIER_RULES_rec.qualifier_rule_id IS NOT NULL AND
1181: p_QUALIFIER_RULES_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND

Line 1197: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

1193:
1194: -- Function Get_Ids
1195:
1196: FUNCTION Get_Ids
1197: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1198: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1199: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1200: IS
1201: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

Line 1198: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type

1194: -- Function Get_Ids
1195:
1196: FUNCTION Get_Ids
1197: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1198: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1199: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1200: IS
1201: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1202: BEGIN

Line 1199: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

1195:
1196: FUNCTION Get_Ids
1197: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1198: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1199: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1200: IS
1201: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1202: BEGIN
1203:

Line 1201: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

1197: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1198: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
1199: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1200: IS
1201: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1202: BEGIN
1203:
1204: -- initialize return_status.
1205: