DBA Data[Home] [Help]

APPS.JTF_AM_FILTER_RESOURCE_PVT dependencies on JTF_ASSIGN_PUB

Line 8: x_assign_resources_tbl IN OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,

4: PROCEDURE SEARCH_SKILL
5: ( p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 ,
7: p_commit IN VARCHAR2 ,
8: x_assign_resources_tbl IN OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,
9: p_skill_param_tbl IN JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2)

Line 16: l_assign_resource_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;

12: x_msg_data OUT NOCOPY VARCHAR2)
13:
14: IS
15:
16: l_assign_resource_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
17:
18: cursor c_rule(l_document_type in varchar2,
19: l_product_id_passed in number,
20: l_category_id_passed in number,

Line 386: -- this is called JTF_ASSIGN_PUB.get_assign_sr_resources

382: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
383:
384: END SEARCH_SKILL;
385:
386: -- this is called JTF_ASSIGN_PUB.get_assign_sr_resources
387: PROCEDURE SERVICE_SECURITY_CHECK
388: ( p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 ,
390: p_commit IN VARCHAR2 ,

Line 391: x_assign_resources_tbl IN OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,

387: PROCEDURE SERVICE_SECURITY_CHECK
388: ( p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 ,
390: p_commit IN VARCHAR2 ,
391: x_assign_resources_tbl IN OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,
392: p_sr_tbl IN JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type,
393: x_return_status OUT NOCOPY VARCHAR2,
394: x_msg_count OUT NOCOPY NUMBER,
395: x_msg_data OUT NOCOPY VARCHAR2)

Line 401: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;

397:
398: l_api_version NUMBER := 1.0;
399: l_api_name varchar2(30) := 'SERVICE_SECURITY_CHECK';
400: l_resource_tbl JTF_AM_FILTER_RESOURCE_PVT.resource_tbl_type;
401: l_assign_resources_tbl JTF_ASSIGN_PUB.AssignResources_tbl_type;
402: l_msg_count NUMBER;
403: l_msg_data VARCHAR2(2000);
404: l_return_status VARCHAR2(10);
405: l_resource_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();