DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_TEAM_VUHK dependencies on CN_API

Line 66: l_date_range_action_tbl cn_api.date_range_action_tbl_type;

62: l_old_end_date_active DATE;
63:
64: l_team_event_name VARCHAR(60);
65:
66: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
67:
68: l_orig_org_id NUMBER;
69: l_orig_acc_mode VARCHAR2(1);
70:

Line 94: cn_api.get_date_range_diff_action

90: into l_old_start_date_active, l_old_end_date_active
91: from jtf_rs_teams_vl
92: where team_id = P_TEAM_ID;
93:
94: cn_api.get_date_range_diff_action
95: ( start_date_new => P_START_DATE_ACTIVE
96: ,end_date_new => P_END_DATE_ACTIVE
97: ,start_date_old => l_old_start_date_active
98: ,end_date_old => l_old_end_date_active