DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PUB dependencies on OKL_MASS_RBK_CRITERIA

Line 14: -- selection criteria provided by user in OKL_MASS_RBK_CRITERIA

10:
11: ------------------------------------------------------------------------------
12: -- PROCEDURE build_and_get_contracts
13: -- This proecdure uses DYNAMIC SQL to get list of contracts from
14: -- selection criteria provided by user in OKL_MASS_RBK_CRITERIA
15: -- against REQUEST_NAME and inserts contract information to
16: -- OKL_RBK_SELECTED_CONTRACT table
17: -- It returns the list of contracts selected under present crietria
18: -- Calls:

Line 27: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,

23: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,
27: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
28: p_mrbv_tbl IN mrbv_tbl_type,
29: x_mstv_tbl OUT NOCOPY mstv_tbl_type,
30: x_rbk_count OUT NOCOPY NUMBER
31: ) IS

Line 339: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE

335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,
339: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE
340: ) IS
341:
342: l_api_name VARCHAR2(35) := 'process_mass_rebook';
343: l_proc_name VARCHAR2(35) := 'PROCESS_MASS_REBOOK';