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 1303: l_source_id cn_salesreps.source_id%TYPE;

1299: l_srp_start_date cn_srp_roles.start_date%TYPE;
1300: l_srp_end_date cn_pay_groups.end_date%TYPE;
1301: l_start_date cn_srp_pay_groups.start_date%TYPE;
1302: l_end_date cn_srp_pay_groups.start_date%TYPE;
1303: l_source_id cn_salesreps.source_id%TYPE;
1304:
1305: BEGIN
1306: -- Standard Start of API savepoint
1307: SAVEPOINT Create_Mass_Asgn_Srp_Pay;

Line 1347: from cn_salesreps

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

Line 1494: l_salesrep_type_old cn_salesreps.type%TYPE;

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

Line 1495: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;

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

Line 1496: l_emp_num_old cn_salesreps.employee_number%TYPE;

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

Line 1510: l_salesrep_type_new cn_salesreps.type%TYPE;

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

Line 1511: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;

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

Line 1512: l_emp_num_new cn_salesreps.employee_number%TYPE;

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

Line 1521: l_source_id_old cn_salesreps.source_id%TYPE;

1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1520: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1521: l_source_id_old cn_salesreps.source_id%TYPE;
1522: l_source_id_new cn_salesreps.source_id%TYPE;
1523:
1524:
1525: --changed the cursor to get proper srp-pay_group assignment to be updated--Hanaraya

Line 1522: l_source_id_new cn_salesreps.source_id%TYPE;

1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1520: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1521: l_source_id_old cn_salesreps.source_id%TYPE;
1522: l_source_id_new cn_salesreps.source_id%TYPE;
1523:
1524:
1525: --changed the cursor to get proper srp-pay_group assignment to be updated--Hanaraya
1526: CURSOR get_pay_groups

Line 1621: FROM cn_salesreps

1617: */
1618:
1619: SELECT employee_number, type,source_id
1620: INTO l_emp_num_old, l_salesrep_type_old,l_source_id_old
1621: FROM cn_salesreps
1622: WHERE salesrep_id = l_salesrep_id_old
1623: AND org_id = l_org_id;
1624:
1625:

Line 1658: FROM cn_salesreps

1654: AND org_id = l_org_id;
1655:
1656: SELECT employee_number, type,source_id
1657: INTO l_emp_num_new, l_salesrep_type_new,l_source_id_new
1658: FROM cn_salesreps
1659: WHERE salesrep_id = l_salesrep_id_new
1660: AND org_id = l_org_id;
1661:
1662: SELECT pay_group_id, start_date, end_date