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_SRP_PAYGROUP_PUB dependencies on CN_SALESREPS

Line 85: from cn_salesreps

81:
82: -- get resource start and end dates
83: select start_date_active, end_date_active
84: into l_res_start_date, l_res_end_date
85: from cn_salesreps
86: where salesrep_id = l_salesrep_id
87: and org_id = l_org_id;
88:
89: -- get intersection with resource start and end dates

Line 131: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,

127: PROCEDURE chk_and_get_salesrep_id( p_emp_num IN VARCHAR2,
128: p_type IN VARCHAR2,
129: p_source_id IN NUMBER,
130: p_org_id IN NUMBER,
131: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_loading_status OUT NOCOPY VARCHAR2) IS
134:
135: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

Line 135: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

131: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_loading_status OUT NOCOPY VARCHAR2) IS
134:
135: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
136: l_emp_num cn_salesreps.employee_number%TYPE;
137: p_show_message VARCHAR2(1);
138: BEGIN
139: -- change for performance. Force to hit index on employee_number

Line 136: l_emp_num cn_salesreps.employee_number%TYPE;

132: x_return_status OUT NOCOPY VARCHAR2,
133: x_loading_status OUT NOCOPY VARCHAR2) IS
134:
135: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
136: l_emp_num cn_salesreps.employee_number%TYPE;
137: p_show_message VARCHAR2(1);
138: BEGIN
139: -- change for performance. Force to hit index on employee_number
140: -- Bug 1508614

Line 148: FROM cn_salesreps

144:
145: IF p_emp_num IS NULL THEN
146: SELECT salesrep_id
147: INTO l_salesrep_id
148: FROM cn_salesreps
149: WHERE employee_number IS NULL
150: AND source_id = p_source_id
151: AND org_id = p_org_id
152: AND ((type = p_type) OR (type IS NULL AND p_type IS NULL));

Line 156: FROM cn_salesreps

152: AND ((type = p_type) OR (type IS NULL AND p_type IS NULL));
153: ELSE
154: SELECT /*+ first_rows */ salesrep_id
155: INTO l_salesrep_id
156: FROM cn_salesreps
157: WHERE upper(employee_number) = l_emp_num
158: AND source_id = p_source_id
159: AND org_id = p_org_id
160: AND ((type = p_type) OR (type IS NULL AND p_type IS NULL));

Line 1291: l_salesrep_type cn_salesreps.type%TYPE;

1287: l_api_name CONSTANT VARCHAR2(30) := 'Create_Mass_Asgn_Srp_Pay';
1288: l_api_version CONSTANT NUMBER := 1.0;
1289: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
1290: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1291: l_salesrep_type cn_salesreps.type%TYPE;
1292: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1293: l_org_id cn_salesreps.org_id%TYPE;
1294: l_emp_num cn_salesreps.employee_number%TYPE;
1295: l_pay_group_name cn_pay_groups.name%TYPE;

Line 1292: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

1288: l_api_version CONSTANT NUMBER := 1.0;
1289: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
1290: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1291: l_salesrep_type cn_salesreps.type%TYPE;
1292: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1293: l_org_id cn_salesreps.org_id%TYPE;
1294: l_emp_num cn_salesreps.employee_number%TYPE;
1295: l_pay_group_name cn_pay_groups.name%TYPE;
1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

Line 1293: l_org_id cn_salesreps.org_id%TYPE;

1289: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
1290: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1291: l_salesrep_type cn_salesreps.type%TYPE;
1292: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1293: l_org_id cn_salesreps.org_id%TYPE;
1294: l_emp_num cn_salesreps.employee_number%TYPE;
1295: l_pay_group_name cn_pay_groups.name%TYPE;
1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1297: l_pg_start_date cn_pay_groups.start_date%TYPE;

Line 1294: l_emp_num cn_salesreps.employee_number%TYPE;

1290: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1291: l_salesrep_type cn_salesreps.type%TYPE;
1292: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1293: l_org_id cn_salesreps.org_id%TYPE;
1294: l_emp_num cn_salesreps.employee_number%TYPE;
1295: l_pay_group_name cn_pay_groups.name%TYPE;
1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1297: l_pg_start_date cn_pay_groups.start_date%TYPE;
1298: l_pg_end_date cn_pay_groups.end_date%TYPE;

Line 1346: from cn_salesreps

1342: AND org_id = l_org_id;
1343:
1344: select employee_number, type
1345: into l_emp_num, l_salesrep_type
1346: from cn_salesreps
1347: where salesrep_id = l_salesrep_id
1348: AND org_id = l_org_id;
1349:
1350: select name

Line 1492: l_salesrep_type_old cn_salesreps.type%TYPE;

1488: l_count NUMBER;
1489: l_count_pay NUMBER;
1490: l_count_role NUMBER;
1491: l_count_srp_pay_group NUMBER;
1492: l_salesrep_type_old cn_salesreps.type%TYPE;
1493: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;
1494: l_emp_num_old cn_salesreps.employee_number%TYPE;
1495: l_pay_group_name_old cn_pay_groups.name%TYPE;
1496: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;

Line 1493: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;

1489: l_count_pay NUMBER;
1490: l_count_role NUMBER;
1491: l_count_srp_pay_group NUMBER;
1492: l_salesrep_type_old cn_salesreps.type%TYPE;
1493: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;
1494: l_emp_num_old cn_salesreps.employee_number%TYPE;
1495: l_pay_group_name_old cn_pay_groups.name%TYPE;
1496: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;
1497: l_role_id_old cn_roles.role_id%TYPE;

Line 1494: l_emp_num_old cn_salesreps.employee_number%TYPE;

1490: l_count_role NUMBER;
1491: l_count_srp_pay_group NUMBER;
1492: l_salesrep_type_old cn_salesreps.type%TYPE;
1493: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;
1494: l_emp_num_old cn_salesreps.employee_number%TYPE;
1495: l_pay_group_name_old cn_pay_groups.name%TYPE;
1496: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;
1497: l_role_id_old cn_roles.role_id%TYPE;
1498: l_start_date_old cn_srp_pay_groups.start_date%TYPE;

Line 1508: l_salesrep_type_new cn_salesreps.type%TYPE;

1504: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1505: oldrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1506:
1507: delrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1508: l_salesrep_type_new cn_salesreps.type%TYPE;
1509: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1510: l_emp_num_new cn_salesreps.employee_number%TYPE;
1511: l_pay_group_name_new cn_pay_groups.name%TYPE;
1512: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;

Line 1509: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;

1505: oldrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1506:
1507: delrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1508: l_salesrep_type_new cn_salesreps.type%TYPE;
1509: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1510: l_emp_num_new cn_salesreps.employee_number%TYPE;
1511: l_pay_group_name_new cn_pay_groups.name%TYPE;
1512: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1513: l_pp_start_date_new cn_pay_groups.start_date%TYPE;

Line 1510: l_emp_num_new cn_salesreps.employee_number%TYPE;

1506:
1507: delrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1508: l_salesrep_type_new cn_salesreps.type%TYPE;
1509: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1510: l_emp_num_new cn_salesreps.employee_number%TYPE;
1511: l_pay_group_name_new cn_pay_groups.name%TYPE;
1512: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1513: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1514: l_pp_end_date_new cn_pay_groups.end_date%TYPE;

Line 1617: FROM cn_salesreps

1613: */
1614:
1615: SELECT employee_number, type
1616: INTO l_emp_num_old, l_salesrep_type_old
1617: FROM cn_salesreps
1618: WHERE salesrep_id = l_salesrep_id_old
1619: AND org_id = l_org_id;
1620:
1621: SELECT name

Line 1651: FROM cn_salesreps

1647: AND org_id = l_org_id;
1648:
1649: SELECT employee_number, type
1650: INTO l_emp_num_new, l_salesrep_type_new
1651: FROM cn_salesreps
1652: WHERE salesrep_id = l_salesrep_id_new
1653: AND org_id = l_org_id;
1654:
1655: SELECT pay_group_id, start_date, end_date