eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_GET_SRP_DATA_PVT dependencies on CN_SRP_HR_DATA

Line 6: name CN_SRP_HR_DATA.NAME%TYPE,

2: /*$Header: cnvsfgts.pls 115.6 2002/11/21 21:18:29 hlchen ship $*/
3:
4: TYPE srp_data_rec_type IS RECORD
5: (srp_id NUMBER,
6: name CN_SRP_HR_DATA.NAME%TYPE,
7: emp_num CN_SRP_HR_DATA.EMP_NUM%TYPE,
8: start_date DATE,
9: end_date DATE,
10: cost_center VARCHAR2(30),

Line 7: emp_num CN_SRP_HR_DATA.EMP_NUM%TYPE,

3:
4: TYPE srp_data_rec_type IS RECORD
5: (srp_id NUMBER,
6: name CN_SRP_HR_DATA.NAME%TYPE,
7: emp_num CN_SRP_HR_DATA.EMP_NUM%TYPE,
8: start_date DATE,
9: end_date DATE,
10: cost_center VARCHAR2(30),
11: comp_group_id NUMBER,

Line 26: -- Search_Srp_Data returns all the salesreps from cn_srp_hr_data along with

22: -- Get_Srp_List returns a list of all the salesreps
23: PROCEDURE Get_Srp_List
24: (x_srp_data OUT NOCOPY srp_data_tbl_type);
25:
26: -- Search_Srp_Data returns all the salesreps from cn_srp_hr_data along with
27: -- their current job title (using p_date) and comp group assignment. You can
28: -- search over four criteria (name, job title, emp num, and comp group).
29: -- Search is case insensitive and nulls are returned (for % query).
30: PROCEDURE Search_Srp_Data