APPS.CSM_EMAIL_QUERY_PKG dependencies on CSP_PART_SEARCH_PVT

Line 2517: l_required_parts_tbl csp_part_search_pvt.required_parts_tbl;

2513: L_GIVEN_ITEM_NAME VARCHAR2(200);
2514: L_GIVEN_ITEM_DESC VARCHAR2(4000);
2515: L_ORG_NAME VARCHAR2(240);
2516: L_RETURN_STATUS VARCHAR2(100);
2517: l_required_parts_tbl csp_part_search_pvt.required_parts_tbl;
2518: l_search_params_rec csp_part_search_pvt.search_params_rec;
2519: l_count NUMBER;
2520: l_resource_id NUMBER;
2521:

Line 2518: l_search_params_rec csp_part_search_pvt.search_params_rec;

2514: L_GIVEN_ITEM_DESC VARCHAR2(4000);
2515: L_ORG_NAME VARCHAR2(240);
2516: L_RETURN_STATUS VARCHAR2(100);
2517: l_required_parts_tbl csp_part_search_pvt.required_parts_tbl;
2518: l_search_params_rec csp_part_search_pvt.search_params_rec;
2519: l_count NUMBER;
2520: l_resource_id NUMBER;
2521:
2522: BEGIN

Line 2578: csp_part_search_pvt.search(p_required_parts => l_required_parts_tbl,

2574:
2575:
2576: --get the substitutes
2577:
2578: csp_part_search_pvt.search(p_required_parts => l_required_parts_tbl,
2579: p_search_params => l_search_params_rec,
2580: x_return_status => L_RETURN_STATUS,
2581: x_msg_data => l_msg_data,
2582: x_msg_count => l_msg_count

Line 2707: l_required_parts_tbl csp_part_search_pvt.required_parts_tbl;

2703: L_GIVEN_ITEM_NAME VARCHAR2(200);
2704: L_GIVEN_ITEM_DESC VARCHAR2(4000);
2705: L_ORG_NAME VARCHAR2(240);
2706: L_RETURN_STATUS VARCHAR2(100);
2707: l_required_parts_tbl csp_part_search_pvt.required_parts_tbl;
2708: L_EXCESS_REC CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE;
2709: L_RETURN_REC CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE;
2710: l_count NUMBER;
2711: L_RETURN_ORG_NAME VARCHAR2(240);