DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on DUAL

Line 456: p_role_resource_type => 'RS_INDIVIDUAL',

452: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
453: p_api_version => 1.0,
454: p_init_msg_list => null,
455: p_commit => null,
456: p_role_resource_type => 'RS_INDIVIDUAL',
457: p_role_resource_id => p_imp_res_tbl(i).resource_id,
458: p_role_id => p_imp_res_tbl(i).role_id,
459: p_start_date_active => p_imp_res_tbl(i).role_start_date_active,
460: p_end_date_active => p_imp_res_tbl(i).role_end_date_active,

Line 478: FROM dual;

474: IF l_transaction_number is null
475: THEN
476: SELECT jtf_rs_transaction_num_s.nextval
477: INTO l_transaction_number
478: FROM dual;
479: END IF;
480:
481: x_transaction_num := l_transaction_number;
482:

Line 628: p_role_resource_type => 'RS_INDIVIDUAL',

624: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
625: p_api_version => 1.0,
626: p_init_msg_list => null,
627: p_commit => null,
628: p_role_resource_type => 'RS_INDIVIDUAL',
629: p_role_resource_id => l_resource_id,
630: p_role_id => j.role_id,
631: p_start_date_active => l_asg_start_date,
632: p_end_date_active => null,

Line 888: p_role_resource_type => 'RS_INDIVIDUAL',

884: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
885: p_api_version => 1.0,
886: p_init_msg_list => null,
887: p_commit => null,
888: p_role_resource_type => 'RS_INDIVIDUAL',
889: p_role_resource_id => l_resource_id,
890: p_role_id => p_imp_res_tbl(i).role_id,
891: p_start_date_active => p_imp_res_tbl(i).rs_start_date_active,
892: p_end_date_active => p_imp_res_tbl(i).rs_end_date_active,