DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_OMINT_PUB

Line 2237: service_rec_type OKS_OMINT_PUB.check_service_rec_type;

2233:
2234:
2235: /* check for product availability */
2236:
2237: service_rec_type OKS_OMINT_PUB.check_service_rec_type;
2238: l_service_id NUMBER;
2239: l_service_item_id NUMBER;
2240: l_product_id NUMBER;
2241: l_product_item_id NUMBER;

Line 2573: OKS_OMINT_PUB.Is_Service_Available

2569:
2570: If l_sts_code = 'ENTERED'
2571: then
2572: --changes for passing org_id in is_service_available
2573: OKS_OMINT_PUB.Is_Service_Available
2574: (
2575: p_api_version => 1.0 ,
2576: p_init_msg_list => 'F' ,
2577: x_msg_count => l_msg_Count ,

Line 6284: service_rec_type OKS_OMINT_PUB.check_service_rec_type;

6280: X_Return_Status OUT NOCOPY VARCHAR2,
6281: p_chr_id IN NUMBER
6282: )
6283: IS
6284: service_rec_type OKS_OMINT_PUB.check_service_rec_type;
6285: l_service_id NUMBER;
6286: l_service_item_id NUMBER;
6287: l_product_id NUMBER;
6288: l_product_item_id NUMBER;

Line 6446: OKS_OMINT_PUB.Is_Service_Available

6442: l_available_YN := NULL;
6443:
6444: IF l_sts_code = 'ENTERED' THEN
6445: --changes for passing org_id in is_service_available
6446: OKS_OMINT_PUB.Is_Service_Available
6447: (
6448: p_api_version => 1.0,
6449: p_init_msg_list => 'F',
6450: x_msg_count => l_msg_Count,