DBA Data[Home] [Help]

APPS.QP_LIST_HEADERS_PVT dependencies on QP_QUALIFIER_RULES_PUB

Line 817: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

813:
814: PROCEDURE Qualifierss
815: ( p_validation_level IN NUMBER
816: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
817: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
818: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
819: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
820: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
821: )

Line 818: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

814: PROCEDURE Qualifierss
815: ( p_validation_level IN NUMBER
816: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
817: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
818: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
819: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
820: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
821: )
822: IS

Line 819: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

815: ( p_validation_level IN NUMBER
816: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
817: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
818: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
819: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
820: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
821: )
822: IS
823: l_return_status VARCHAR2(1);

Line 820: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

816: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
817: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
818: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
819: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
820: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
821: )
822: IS
823: l_return_status VARCHAR2(1);
824: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 825: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

821: )
822: IS
823: l_return_status VARCHAR2(1);
824: l_control_rec QP_GLOBALS.Control_Rec_Type;
825: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
826: l_p_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
827: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
828: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
829: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 826: l_p_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

822: IS
823: l_return_status VARCHAR2(1);
824: l_control_rec QP_GLOBALS.Control_Rec_Type;
825: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
826: l_p_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
827: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
828: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
829: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
830: l_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;

Line 827: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

823: l_return_status VARCHAR2(1);
824: l_control_rec QP_GLOBALS.Control_Rec_Type;
825: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
826: l_p_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
827: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
828: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
829: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
830: l_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
831: l_pte_code VARCHAR2(30);

Line 828: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

824: l_control_rec QP_GLOBALS.Control_Rec_Type;
825: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
826: l_p_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
827: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
828: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
829: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
830: l_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
831: l_pte_code VARCHAR2(30);
832: l_source_system_code VARCHAR2(30);

Line 829: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

825: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
826: l_p_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
827: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
828: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
829: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
830: l_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
831: l_pte_code VARCHAR2(30);
832: l_source_system_code VARCHAR2(30);
833: l_saved_pte_code VARCHAR2(30);

Line 860: l_old_QUALIFIERS_rec := Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_REC;

856:
857: IF l_old_QUALIFIERS_tbl.EXISTS(I) THEN
858: l_old_QUALIFIERS_rec := l_old_QUALIFIERS_tbl(I);
859: ELSE
860: l_old_QUALIFIERS_rec := Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_REC;
861: END IF;
862:
863: -- Load API control record
864:

Line 1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

1851: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1852: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

Line 1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

1853: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

1854: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
1855: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

Line 1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

1856: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1857: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1858: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
1859: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
1860: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
1861: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1862: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

Line 1867: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

1863: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
1864: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
1865: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
1866: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
1867: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
1868: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1869: )
1870: IS
1871: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

1881: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

1882: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

1883: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

1884: l_p_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

1885: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

1886: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1887: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1888: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1889: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1890: l_p_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1891: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1892: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1893: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1894: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

2382: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
2383: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
2384: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

Line 2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176

2384: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
2385: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
2386: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
2387: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
2388: --Qp_Qualifier_Rules_Pub.G_MISS_QUALIFIERS_TBL --2422176
2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2391: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2392: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 2393: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

2389: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
2390: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
2391: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2392: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2393: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2394: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2395: )
2396: IS
2397: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2401: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

2397: l_api_version_number CONSTANT NUMBER := 1.0;
2398: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
2399: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2400: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2401: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2402: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
2403: BEGIN
2404:
2405: -- Standard call to check for call compatibility

Line 2613: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

2609: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2610: , p_list_header_id IN NUMBER
2611: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
2612: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
2613: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
2614: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
2615: )
2616: IS
2617: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2621: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

2617: l_api_version_number CONSTANT NUMBER := 1.0;
2618: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
2619: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
2620: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2621: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2622: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2623: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
2624: BEGIN
2625: