DBA Data[Home] [Help]

APPS.JTF_TASK_RESOURCES_PVT dependencies on JTF_TASK_RESOURCES_PUB

Line 470: jtf_task_resources_pub.lock_task_resources

466:
467: --if l_enabled_flag = fnd_api.G_true then
468:
469:
470: jtf_task_resources_pub.lock_task_resources
471: ( P_API_VERSION => 1.0 ,
472: P_INIT_MSG_LIST => fnd_api.g_false ,
473: P_COMMIT => fnd_api.g_false ,
474: P_RESOURCE_REQUIREMENT_ID => l_resource_req_id ,

Line 601: jtf_task_resources_pub.lock_task_resources

597:
598: ---call the table handler to delete the resource req
599:
600:
601: jtf_task_resources_pub.lock_task_resources
602: ( P_API_VERSION => 1.0 ,
603: P_INIT_MSG_LIST => fnd_api.g_false ,
604: P_COMMIT => fnd_api.g_false ,
605: P_RESOURCE_REQUIREMENT_ID => l_resource_req_id ,

Line 684: P_SORT_DATA IN JTF_TASK_RESOURCES_PUB.SORT_DATA,

680: P_TASK_TYPE_ID IN NUMBER DEFAULT NULL ,
681: P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT NULL ,
682: P_TASK_TEMPLATE_ID IN NUMBER DEFAULT NULL ,
683: P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT NULL ,
684: P_SORT_DATA IN JTF_TASK_RESOURCES_PUB.SORT_DATA,
685: P_QUERY_OR_NEXT_CODE IN VARCHAR2 default 'Q' ,
686: P_START_POINTER IN NUMBER ,
687: P_REC_WANTED IN NUMBER ,
688: P_SHOW_ALL IN VARCHAR2 default 'Y' ,

Line 695: X_TASK_RSC_REQ_REC OUT NOCOPY JTF_TASK_RESOURCES_PUB.TASK_RSC_REQ_TBL,

691: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,
692: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
693: X_MSG_COUNT OUT NOCOPY NUMBER ,
694: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
695: X_TASK_RSC_REQ_REC OUT NOCOPY JTF_TASK_RESOURCES_PUB.TASK_RSC_REQ_TBL,
696: X_TOTAL_RETRIEVED OUT NOCOPY NUMBER ,
697: X_TOTAL_RETURNED OUT NOCOPY NUMBER ) IS
698:
699: -- declare variables

Line 706: v_type jtf_task_resources_pub.task_rsc_req_rec;

702: v_dummy integer;
703: v_cnt integer;
704: v_end integer;
705: v_start integer;
706: v_type jtf_task_resources_pub.task_rsc_req_rec;
707: v_tbl jtf_task_resources_pub.task_rsc_req_tbl;
708: v_select varchar2(2000);
709:
710:

Line 707: v_tbl jtf_task_resources_pub.task_rsc_req_tbl;

703: v_cnt integer;
704: v_end integer;
705: v_start integer;
706: v_type jtf_task_resources_pub.task_rsc_req_rec;
707: v_tbl jtf_task_resources_pub.task_rsc_req_tbl;
708: v_select varchar2(2000);
709:
710:
711: