DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL_MOD dependencies on QP_QUALIFIER_RULES_PUB

Line 919: --l_qualifiers_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

915: IS
916: l_check_active_flag VARCHAR2(1);
917: l_active_flag VARCHAR2(1);
918: --l_status VARCHAR2(1);
919: --l_qualifiers_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
920: BEGIN
921: SELECT ACTIVE_FLAG
922: INTO l_active_flag
923: FROM QP_LIST_HEADERS_B

Line 1184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

1180: ( p_qualifier_id IN NUMBER :=
1181: FND_API.G_MISS_NUM
1182: , p_list_header_id IN NUMBER :=
1183: FND_API.G_MISS_NUM
1184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1185: IS
1186: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1187: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1188:

Line 1186: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

1182: , p_list_header_id IN NUMBER :=
1183: FND_API.G_MISS_NUM
1184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1185: IS
1186: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1187: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1188:
1189: CURSOR l_QUALIFIERS_csr IS
1190: SELECT ATTRIBUTE1

Line 1187: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

1183: FND_API.G_MISS_NUM
1184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1185: IS
1186: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1187: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1188:
1189: CURSOR l_QUALIFIERS_csr IS
1190: SELECT ATTRIBUTE1
1191: , ATTRIBUTE10