DBA Data[Home] [Help]

APPS.OKL_AM_REMARKET_ASSET_PVT dependencies on QP_LIST_HEADERS

Line 669: --FROM QP_LIST_HEADERS_B -- SECHAWLA 08-DEC-04 4047159

665:
666: -- This cursor is used to validate the list_header_id
667: CURSOR l_qplisthdr_csr(p_list_header_id NUMBER) IS
668: --SELECT 'x' -- SECHAWLA 08-DEC-04 4047159
669: --FROM QP_LIST_HEADERS_B -- SECHAWLA 08-DEC-04 4047159
670: SELECT name
671: FROM QP_LIST_HEADERS
672: WHERE LIST_HEADER_ID = p_list_header_id;
673:

Line 671: FROM QP_LIST_HEADERS

667: CURSOR l_qplisthdr_csr(p_list_header_id NUMBER) IS
668: --SELECT 'x' -- SECHAWLA 08-DEC-04 4047159
669: --FROM QP_LIST_HEADERS_B -- SECHAWLA 08-DEC-04 4047159
670: SELECT name
671: FROM QP_LIST_HEADERS
672: WHERE LIST_HEADER_ID = p_list_header_id;
673:
674:
675: -- SECHAWLA Bug# 2620853 : Cursor not required, as we are not going to use distribution account id

Line 719: l_pricelist_name QP_LIST_HEADERS.name%TYPE; -- SECHAWLA 08-DEC-04 4047159

715: l_New_Item_Id NUMBER;
716: l_return_status VARCHAR2(1);
717: l_temp VARCHAR2(25);
718: -- l_pricelist_exists VARCHAR2(1); -- SECHAWLA 08-DEC-04 4047159
719: l_pricelist_name QP_LIST_HEADERS.name%TYPE; -- SECHAWLA 08-DEC-04 4047159
720: --SECHAWLA 2706328 : Fixed the datatype for l_temp_org_name
721: l_temp_org_name mtl_organizations.organization_name%TYPE;
722: l_temp_ccid VARCHAR2(1);
723: l_count NUMBER;