DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on DUAL

Line 464: p_role_resource_type => 'RS_INDIVIDUAL',

460: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
461: p_api_version => 1.0,
462: p_init_msg_list => null,
463: p_commit => null,
464: p_role_resource_type => 'RS_INDIVIDUAL',
465: p_role_resource_id => p_imp_res_tbl(i).resource_id,
466: p_role_id => p_imp_res_tbl(i).role_id,
467: p_start_date_active => p_imp_res_tbl(i).role_start_date_active,
468: p_end_date_active => p_imp_res_tbl(i).role_end_date_active,

Line 486: FROM dual;

482: IF l_transaction_number is null
483: THEN
484: SELECT jtf_rs_transaction_num_s.nextval
485: INTO l_transaction_number
486: FROM dual;
487: END IF;
488:
489: x_transaction_num := l_transaction_number;
490:

Line 636: p_role_resource_type => 'RS_INDIVIDUAL',

632: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
633: p_api_version => 1.0,
634: p_init_msg_list => null,
635: p_commit => null,
636: p_role_resource_type => 'RS_INDIVIDUAL',
637: p_role_resource_id => l_resource_id,
638: p_role_id => j.role_id,
639: p_start_date_active => l_asg_start_date,
640: p_end_date_active => null,

Line 896: p_role_resource_type => 'RS_INDIVIDUAL',

892: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
893: p_api_version => 1.0,
894: p_init_msg_list => null,
895: p_commit => null,
896: p_role_resource_type => 'RS_INDIVIDUAL',
897: p_role_resource_id => l_resource_id,
898: p_role_id => p_imp_res_tbl(i).role_id,
899: p_start_date_active => p_imp_res_tbl(i).rs_start_date_active,
900: p_end_date_active => p_imp_res_tbl(i).rs_end_date_active,