APPS.JTF_RS_TEAM_USAGE_VUHK dependencies on CN_COMP_TEAMS

Line 19: t_team_name cn_comp_teams.name%type;

15: P_TEAM_ID IN NUMBER,
16: P_USAGE IN VARCHAR2,
17: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
18:
19: t_team_name cn_comp_teams.name%type;
20: t_start_date_active cn_comp_teams.start_date_active%type;
21: t_end_date_active cn_comp_teams.end_date_active%type;
22: l_event_log_id number;
23: l_orig_org_id NUMBER;

Line 20: t_start_date_active cn_comp_teams.start_date_active%type;

16: P_USAGE IN VARCHAR2,
17: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
18:
19: t_team_name cn_comp_teams.name%type;
20: t_start_date_active cn_comp_teams.start_date_active%type;
21: t_end_date_active cn_comp_teams.end_date_active%type;
22: l_event_log_id number;
23: l_orig_org_id NUMBER;
24: l_orig_acc_mode VARCHAR2(1);

Line 21: t_end_date_active cn_comp_teams.end_date_active%type;

17: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
18:
19: t_team_name cn_comp_teams.name%type;
20: t_start_date_active cn_comp_teams.start_date_active%type;
21: t_end_date_active cn_comp_teams.end_date_active%type;
22: l_event_log_id number;
23: l_orig_org_id NUMBER;
24: l_orig_acc_mode VARCHAR2(1);
25:

Line 29: from cn_comp_teams

25:
26: -- get team info
27: CURSOR c_team_info IS
28: select name, start_date_active, end_date_active
29: from cn_comp_teams
30: where comp_team_id = P_TEAM_ID;
31:
32: -- get orgs
33: CURSOR get_orgs IS

Line 81: t_team_name cn_comp_teams.name%type;

77: (P_TEAM_ID IN NUMBER,
78: P_USAGE IN VARCHAR2,
79: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
80:
81: t_team_name cn_comp_teams.name%type;
82: t_start_date_active cn_comp_teams.start_date_active%type;
83: t_end_date_active cn_comp_teams.end_date_active%type;
84: l_event_log_id number;
85: l_orig_org_id NUMBER;

Line 82: t_start_date_active cn_comp_teams.start_date_active%type;

78: P_USAGE IN VARCHAR2,
79: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
80:
81: t_team_name cn_comp_teams.name%type;
82: t_start_date_active cn_comp_teams.start_date_active%type;
83: t_end_date_active cn_comp_teams.end_date_active%type;
84: l_event_log_id number;
85: l_orig_org_id NUMBER;
86: l_orig_acc_mode VARCHAR2(1);

Line 83: t_end_date_active cn_comp_teams.end_date_active%type;

79: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
80:
81: t_team_name cn_comp_teams.name%type;
82: t_start_date_active cn_comp_teams.start_date_active%type;
83: t_end_date_active cn_comp_teams.end_date_active%type;
84: l_event_log_id number;
85: l_orig_org_id NUMBER;
86: l_orig_acc_mode VARCHAR2(1);
87:

Line 91: from cn_comp_teams

87:
88: -- get team info
89: CURSOR c_team_info IS
90: select name, start_date_active, end_date_active
91: from cn_comp_teams
92: where comp_team_id = P_TEAM_ID;
93:
94: CURSOR get_orgs IS
95: SELECT org_id