DBA Data[Home] [Help]

APPS.QP_QUALIFIER_RULES_PVT dependencies on QP_LIST_HEADERS_B

Line 912: update qp_list_headers_b

908: WHEN OTHERS THEN NULL;
909: END;
910:
911: IF qual_count = 0 THEN
912: update qp_list_headers_b
913: set active_flag = 'N'
914: where list_header_id = l_list_header_id
915: and list_source_code = 'BSO';
916:

Line 1620: l_price_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;

1616: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1617: )
1618: IS
1619: /* For creating qualifiers */
1620: l_price_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
1621: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1622: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1623: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1624: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;