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 1204: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 1233: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 1974: --l_qualifiers_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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

Line 2054: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 2073: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

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

Line 2075: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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

Line 2076: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

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

Line 2266: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

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

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

Line 2270: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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

Line 2674: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2670:
2671: -- Function Get_Values
2672:
2673: FUNCTION Get_Values
2674: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2675: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2676: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2677: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2678: IS

Line 2675: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

2671: -- Function Get_Values
2672:
2673: FUNCTION Get_Values
2674: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2675: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2676: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2677: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2678: IS
2679: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;

Line 2676: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

2672:
2673: FUNCTION Get_Values
2674: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2675: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2676: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2677: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2678: IS
2679: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
2680: BEGIN

Line 2677: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type

2673: FUNCTION Get_Values
2674: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2675: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2676: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2677: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2678: IS
2679: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
2680: BEGIN
2681:

Line 2679: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;

2675: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
2676: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
2677: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2678: IS
2679: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
2680: BEGIN
2681:
2682: /*IF p_QUALIFIERS_rec.comparison_operator_code IS NOT NULL AND
2683: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND

Line 2759: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2755:
2756: -- Function Get_Ids
2757:
2758: FUNCTION Get_Ids
2759: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2760: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2761: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2762: IS
2763: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 2760: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type

2756: -- Function Get_Ids
2757:
2758: FUNCTION Get_Ids
2759: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2760: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2761: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2762: IS
2763: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2764: BEGIN

Line 2761: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

2757:
2758: FUNCTION Get_Ids
2759: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2760: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2761: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2762: IS
2763: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2764: BEGIN
2765:

Line 2763: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

2759: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2760: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
2761: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
2762: IS
2763: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2764: BEGIN
2765:
2766: -- initialize return_status.
2767:

Line 3090: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

3086:
3087: END Get_Ids;
3088:
3089: Procedure Pre_Write_Process
3090: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3091: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3092: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3093: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3094: ) IS

Line 3091: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

3087: END Get_Ids;
3088:
3089: Procedure Pre_Write_Process
3090: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3091: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3092: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3093: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3094: ) IS
3095: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;

Line 3092: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

3088:
3089: Procedure Pre_Write_Process
3090: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3091: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3092: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3093: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3094: ) IS
3095: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
3096: l_return_status varchar2(30);

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

3089: Procedure Pre_Write_Process
3090: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3091: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3092: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3093: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3094: ) IS
3095: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
3096: l_return_status varchar2(30);
3097: l_hlq_count NUMBER := 0;

Line 3095: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;

3091: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
3092: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
3093: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
3094: ) IS
3095: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type := p_QUALIFIERS_rec;
3096: l_return_status varchar2(30);
3097: l_hlq_count NUMBER := 0;
3098: --Header Level Qualifier Count
3099: l_llq_count NUMBER := 0;