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_QUALIFIERS_UTIL dependencies on QP_QUALIFIER_RULES_PUB

Line 12: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_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_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
13: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
15: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
16: )

Line 13: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
13: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
15: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
16: )
17: IS

Line 14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
13: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
15: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
13: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
15: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 458: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

454:
455: -- Procedure Apply_Attribute_Changes
456:
457: PROCEDURE Apply_Attribute_Changes
458: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
459: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
460: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
461: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
462: )

Line 459: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

455: -- Procedure Apply_Attribute_Changes
456:
457: PROCEDURE Apply_Attribute_Changes
458: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
459: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
460: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
461: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
462: )
463: IS

Line 460: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

456:
457: PROCEDURE Apply_Attribute_Changes
458: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
459: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
460: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
461: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
462: )
463: IS
464: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 461: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

457: PROCEDURE Apply_Attribute_Changes
458: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
459: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
460: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
461: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
462: )
463: IS
464: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
465: BEGIN

Line 700: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

696:
697: -- Function Complete_Record
698:
699: FUNCTION Complete_Record
700: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
701: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
702: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
703: IS
704: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;

Line 701: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

697: -- Function Complete_Record
698:
699: FUNCTION Complete_Record
700: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
701: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
702: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
703: IS
704: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
705: BEGIN

Line 702: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

698:
699: FUNCTION Complete_Record
700: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
701: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
702: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
703: IS
704: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
705: BEGIN
706:

Line 704: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;

700: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
701: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
702: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
703: IS
704: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
705: BEGIN
706:
707: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
708: l_QUALIFIERS_rec.attribute1 := p_old_QUALIFIERS_rec.attribute1;

Line 889: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

885:
886: -- Function Convert_Miss_To_Null
887:
888: FUNCTION Convert_Miss_To_Null
889: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
890: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
891: IS
892: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
893: BEGIN

Line 890: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

886: -- Function Convert_Miss_To_Null
887:
888: FUNCTION Convert_Miss_To_Null
889: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
890: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
891: IS
892: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
893: BEGIN
894:

Line 892: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;

888: FUNCTION Convert_Miss_To_Null
889: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
890: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
891: IS
892: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
893: BEGIN
894:
895: IF l_QUALIFIERS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
896: l_QUALIFIERS_rec.attribute1 := NULL;

Line 1078: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

1074:
1075: -- Procedure Update_Row
1076:
1077: PROCEDURE Update_Row
1078: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
1079: )
1080: IS
1081: l_check_active_flag VARCHAR2(1);
1082: l_qual_attr_value_from_number NUMBER := NULL;

Line 1086: --l_qualifiers_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

1082: l_qual_attr_value_from_number NUMBER := NULL;
1083: l_qual_attr_value_to_number NUMBER := NULL;
1084: l_qual_attr_value_from VARCHAR2(240);
1085: --l_status VARCHAR2(1);
1086: --l_qualifiers_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1087: BEGIN
1088:
1089: -- l_qualifiers_rec:=Query_Row(p_QUALIFIERS_rec.qualifier_id);
1090:

Line 1205: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

1201:
1202: -- Procedure Update_coupon_Row Added for bug 7316016
1203:
1204: PROCEDURE Update_coupon_Row
1205: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
1206: )
1207: IS
1208: BEGIN
1209: UPDATE QP_COUPONS

Line 1234: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

1230:
1231: -- Procedure Insert_Row
1232:
1233: PROCEDURE Insert_Row
1234: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
1235: )
1236: IS
1237: l_list_type_code VARCHAR2(30) := '';
1238: l_active_flag VARCHAR2(1) := '';

Line 1975: --l_qualifiers_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

1971: )
1972: IS
1973: --l_check_active_flag VARCHAR2(1);
1974: --l_status VARCHAR2(1);
1975: --l_qualifiers_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1976: BEGIN
1977: -- l_qualifiers_rec:=Query_Row(p_qualifier_id);
1978: IF p_qualifier_rule_id <> FND_API.G_MISS_NUM
1979: THEN

Line 2055: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2051: -- Function Query_Row
2052:
2053: FUNCTION Query_Row
2054: ( p_qualifier_id IN NUMBER
2055: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2056: IS
2057: BEGIN
2058:
2059: RETURN Query_Rows

Line 2074: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

2070: ( p_qualifier_id IN NUMBER :=
2071: FND_API.G_MISS_NUM
2072: , p_qualifier_rule_id IN NUMBER :=
2073: FND_API.G_MISS_NUM
2074: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2075: IS
2076: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2077: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2078:

Line 2076: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

2072: , p_qualifier_rule_id IN NUMBER :=
2073: FND_API.G_MISS_NUM
2074: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2075: IS
2076: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2077: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2078:
2079: CURSOR l_QUALIFIERS_csr IS
2080: SELECT ATTRIBUTE1

Line 2077: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

2073: FND_API.G_MISS_NUM
2074: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2075: IS
2076: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2077: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2078:
2079: CURSOR l_QUALIFIERS_csr IS
2080: SELECT ATTRIBUTE1
2081: , ATTRIBUTE10

Line 2267: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2263: --
2264:
2265: PROCEDURE Lock_Row
2266: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2267: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2268: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2269: )
2270: IS
2271: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 2268: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2264:
2265: PROCEDURE Lock_Row
2266: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2267: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2268: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2269: )
2270: IS
2271: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2272: BEGIN

Line 2271: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

2267: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2268: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2269: )
2270: IS
2271: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2272: BEGIN
2273:
2274: oe_debug_pub.add('in QPXUQPQB.pls lock row');
2275:

Line 2628: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2624:
2625: -- Function Get_Values
2626:
2627: FUNCTION Get_Values
2628: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2629: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2630: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2631: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2632: IS

Line 2629: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

2625: -- Function Get_Values
2626:
2627: FUNCTION Get_Values
2628: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2629: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2630: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2631: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2632: IS
2633: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;

Line 2630: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

2626:
2627: FUNCTION Get_Values
2628: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2629: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2630: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2631: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2632: IS
2633: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
2634: BEGIN

Line 2631: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type

2627: FUNCTION Get_Values
2628: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2629: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2630: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2631: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2632: IS
2633: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
2634: BEGIN
2635:

Line 2633: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;

2629: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2630: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2631: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2632: IS
2633: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
2634: BEGIN
2635:
2636: /*IF p_QUALIFIERS_rec.comparison_operator_code IS NOT NULL AND
2637: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND

Line 2713: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2709:
2710: -- Function Get_Ids
2711:
2712: FUNCTION Get_Ids
2713: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2714: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2715: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2716: IS
2717: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 2714: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type

2710: -- Function Get_Ids
2711:
2712: FUNCTION Get_Ids
2713: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2714: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2715: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2716: IS
2717: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2718: BEGIN

Line 2715: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2711:
2712: FUNCTION Get_Ids
2713: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2714: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2715: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2716: IS
2717: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2718: BEGIN
2719:

Line 2717: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

2713: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2714: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2715: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2716: IS
2717: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2718: BEGIN
2719:
2720: -- initialize return_status.
2721:

Line 3044: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

3040:
3041: END Get_Ids;
3042:
3043: Procedure Pre_Write_Process
3044: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3045: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3046: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3047: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3048: ) IS

Line 3045: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

3041: END Get_Ids;
3042:
3043: Procedure Pre_Write_Process
3044: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3045: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3046: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3047: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3048: ) IS
3049: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;

Line 3046: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

3042:
3043: Procedure Pre_Write_Process
3044: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3045: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3046: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3047: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3048: ) IS
3049: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
3050: l_return_status varchar2(30);

Line 3047: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

3043: Procedure Pre_Write_Process
3044: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3045: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3046: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3047: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3048: ) IS
3049: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
3050: l_return_status varchar2(30);
3051: l_hlq_count NUMBER := 0;

Line 3049: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;

3045: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3046: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3047: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3048: ) IS
3049: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
3050: l_return_status varchar2(30);
3051: l_hlq_count NUMBER := 0;
3052: --Header Level Qualifier Count
3053: l_llq_count NUMBER := 0;