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_PVT dependencies on CN_SRP_PAY_GROUPS

Line 48: FROM cn_srp_pay_groups_all

44: x_loading_status := p_loading_status ;
45:
46: -- Check if already exist( duplicate assigned,unique key violation check)
47: SELECT COUNT(1) INTO l_dummy
48: FROM cn_srp_pay_groups_all
49: WHERE salesrep_id = p_salesrep_id
50: AND pay_group_id = p_pay_group_id
51: AND start_date = p_start_date
52: AND ( (end_date = p_end_date) OR

Line 208: FROM cn_srp_pay_groups_all

204: -- Check for overlapping assignments
205: --
206: SELECT count(1)
207: INTO l_count
208: FROM cn_srp_pay_groups_all
209: WHERE p_start_date between start_date AND Nvl(end_date, p_start_date)
210: AND salesrep_id = p_salesrep_id
211: AND org_id = p_org_id
212: AND srp_pay_group_id <> p_srp_pay_group_id;

Line 229: FROM cn_srp_pay_groups_all

225: END IF;
226:
227: SELECT count(1)
228: INTO l_count
229: FROM cn_srp_pay_groups_all
230: WHERE Nvl(p_end_date, l_null_date) between start_date
231: AND Nvl(end_date, Nvl(p_end_date, l_null_date))
232: AND salesrep_id = p_salesrep_id
233: AND org_id = p_org_id

Line 251: FROM cn_srp_pay_groups_all

247: END IF;
248:
249: SELECT count(1)
250: INTO l_count
251: FROM cn_srp_pay_groups_all
252: WHERE salesrep_id = p_salesrep_id
253: AND org_id = p_org_id
254: AND p_start_date <= start_date
255: AND Nvl(p_end_date, l_null_date) >= Nvl(end_date, l_null_date)

Line 494: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

490: ) IS
491:
492: l_api_name CONSTANT VARCHAR2(30) := 'Create_Srp_Pay_Group';
493: l_api_version CONSTANT NUMBER := 1.0;
494: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
495: l_role_id cn_roles.role_id%TYPE;
496: l_loading_status VARCHAR2(2000);
497: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
498: l_status VARCHAR2(30);

Line 550: SELECT cn_srp_pay_groups_s.NEXTVAL

546: -- Initialize API return status to success
547: x_return_status := FND_API.G_RET_STS_SUCCESS;
548: x_loading_status := 'CN_CREATED';
549:
550: SELECT cn_srp_pay_groups_s.NEXTVAL
551: INTO l_srp_pay_group_id
552: FROM dual;
553:
554: Validate_assignment

Line 615: CN_SRP_Pay_Groups_Pkg.Begin_Record(

611: RAISE FND_API.G_EXC_ERROR ;
612: END IF;
613:
614: -- ready to insert
615: CN_SRP_Pay_Groups_Pkg.Begin_Record(
616: x_operation => 'INSERT',
617: x_srp_pay_group_id => l_srp_pay_group_id,
618: x_salesrep_id => p_paygroup_assign_rec.salesrep_id,
619: x_pay_group_id => p_paygroup_assign_rec.pay_group_id,

Line 659: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PAY_GROUPS_EXIST');

655:
656: else
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
658: THEN
659: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PAY_GROUPS_EXIST');
660: FND_MSG_PUB.Add;
661: END IF;
662: x_loading_status := 'CN_SRP_PAY_GROUPS_EXIST';
663: RAISE FND_API.G_EXC_ERROR ;

Line 662: x_loading_status := 'CN_SRP_PAY_GROUPS_EXIST';

658: THEN
659: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PAY_GROUPS_EXIST');
660: FND_MSG_PUB.Add;
661: END IF;
662: x_loading_status := 'CN_SRP_PAY_GROUPS_EXIST';
663: RAISE FND_API.G_EXC_ERROR ;
664: END IF;
665:
666:

Line 912: from cn_srp_pay_groups_all

908: -- get the current object version number
909: select object_version_number, salesrep_id, start_date, end_date, lock_flag
910: into l_ovn_old, l_old_salesrep_id,
911: l_old_assignment_start_date, l_old_assignment_end_date, l_old_lock_flag
912: from cn_srp_pay_groups_all
913: where srp_pay_group_id = p_paygroup_assign_rec.srp_pay_group_id;
914:
915: IF l_ovn_old <> p_paygroup_assign_rec.object_version_number THEN
916: --

Line 1174: CN_SRP_Pay_Groups_Pkg.Begin_Record(

1170: IF p_paygroup_assign_rec.lock_flag = 'Y' THEN
1171: p_paygroup_assign_rec.role_pay_group_id := NULL;
1172: END IF;
1173:
1174: CN_SRP_Pay_Groups_Pkg.Begin_Record(
1175: x_operation => 'UPDATE',
1176: x_srp_pay_group_id => p_paygroup_assign_rec.srp_pay_group_id,
1177: x_salesrep_id => p_paygroup_assign_rec.salesrep_id,
1178: x_pay_group_id => p_paygroup_assign_rec.pay_group_id,

Line 1383: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1379: l_srp_role_id NUMBER;
1380: l_ws_count NUMBER;
1381: l_null_date CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');
1382: l_count NUMBER;
1383: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1384:
1385: -- clku
1386: CURSOR payee_check_curs(l_salesrep_id NUMBER) IS
1387: select srp_role_id from cn_srp_roles where

Line 1478: FROM cn_srp_pay_groups_all

1474: Close payee_check_curs;
1475:
1476: SELECT SRP_PAY_GROUP_ID
1477: INTO l_srp_pay_group_id
1478: FROM cn_srp_pay_groups_all
1479: WHERE pay_group_id = p_paygroup_assign_rec.pay_group_id
1480: AND start_date=p_paygroup_assign_rec.assignment_start_date
1481: AND (end_date =p_paygroup_assign_rec.assignment_end_date OR
1482: end_date IS NULL)

Line 1485: SELECT COUNT(1) INTO l_count from cn_srp_pay_groups_all

1481: AND (end_date =p_paygroup_assign_rec.assignment_end_date OR
1482: end_date IS NULL)
1483: AND salesrep_id =p_paygroup_assign_rec.salesrep_id;
1484:
1485: SELECT COUNT(1) INTO l_count from cn_srp_pay_groups_all
1486: WHERE srp_pay_group_id = l_srp_pay_group_id
1487: AND salesrep_id = p_paygroup_assign_rec.salesrep_id
1488: AND pay_group_id= p_paygroup_assign_rec.pay_group_id
1489: AND org_id = p_paygroup_assign_rec.org_id

Line 1586: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1582:
1583: l_count NUMBER(15);
1584: l_start_date DATE;
1585: l_end_date DATE;
1586: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1587: l_paygroup_assign_rec paygroup_assign_rec;
1588:
1589: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE) IS
1590: SELECT role_plan_id,role_id

Line 1620: from cn_srp_pay_groups_all

1616: AND org_id = p_paygroup_assign_rec.org_id;
1617:
1618: CURSOR get_srp_pg(l_salesrep_id NUMBER) IS
1619: select pay_group_id,start_date,end_date
1620: from cn_srp_pay_groups_all
1621: where salesrep_id = l_salesrep_id
1622: AND org_id = p_paygroup_assign_rec.org_id;
1623:
1624:

Line 1666: FROM cn_srp_pay_groups_all

1662:
1663: -- if made it here, then OK to delete
1664: SELECT SRP_PAY_GROUP_ID
1665: INTO l_srp_pay_group_id
1666: FROM cn_srp_pay_groups_all
1667: WHERE pay_group_id = p_paygroup_assign_rec.pay_group_id
1668: AND start_date=p_paygroup_assign_rec.assignment_start_date
1669: AND (end_date =p_paygroup_assign_rec.assignment_end_date OR
1670: end_date IS NULL)

Line 1673: DELETE FROM cn_srp_pay_groups_all

1669: AND (end_date =p_paygroup_assign_rec.assignment_end_date OR
1670: end_date IS NULL)
1671: AND salesrep_id =p_paygroup_assign_rec.salesrep_id;
1672:
1673: DELETE FROM cn_srp_pay_groups_all
1674: WHERE srp_pay_group_id = l_srp_pay_group_id;
1675:
1676: -- raise business event
1677: l_paygroup_assign_rec.srp_pay_group_id := l_srp_pay_group_id;

Line 1684: FROM cn_srp_pay_groups_all

1680: p_paygroup_assign_rec => l_paygroup_assign_rec);
1681:
1682: SELECT count (*), min(start_date),nvl(max(end_date),l_null_date) end_date
1683: INTO l_count,l_start_date,l_end_date
1684: FROM cn_srp_pay_groups_all
1685: WHERE salesrep_id = p_paygroup_assign_rec.salesrep_id
1686: AND org_id = p_paygroup_assign_rec.org_id;
1687:
1688: --Modified for bug fix 3137894.

Line 1848: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1844:
1845: l_return_status VARCHAR2(2000);
1846: l_msg_count NUMBER;
1847: l_msg_data VARCHAR2(2000);
1848: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1849: l_loading_status VARCHAR2(2000);
1850:
1851: newrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1852: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

Line 1858: l_start_date cn_srp_pay_groups.start_date%TYPE;

1854: l_pg_start_date cn_pay_groups.start_date%TYPE;
1855: l_pg_end_date cn_pay_groups.end_date%TYPE;
1856: l_srp_start_date cn_srp_roles.start_date%TYPE;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;
1859: l_end_date cn_srp_pay_groups.start_date%TYPE;
1860: l_org_id cn_srp_pay_groups.org_id%TYPE;
1861: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;
1862: l_count NUMBER;

Line 1859: l_end_date cn_srp_pay_groups.start_date%TYPE;

1855: l_pg_end_date cn_pay_groups.end_date%TYPE;
1856: l_srp_start_date cn_srp_roles.start_date%TYPE;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;
1859: l_end_date cn_srp_pay_groups.start_date%TYPE;
1860: l_org_id cn_srp_pay_groups.org_id%TYPE;
1861: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;
1862: l_count NUMBER;
1863: l_null_date CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');

Line 1860: l_org_id cn_srp_pay_groups.org_id%TYPE;

1856: l_srp_start_date cn_srp_roles.start_date%TYPE;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;
1859: l_end_date cn_srp_pay_groups.start_date%TYPE;
1860: l_org_id cn_srp_pay_groups.org_id%TYPE;
1861: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;
1862: l_count NUMBER;
1863: l_null_date CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');
1864:

Line 1861: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;

1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;
1859: l_end_date cn_srp_pay_groups.start_date%TYPE;
1860: l_org_id cn_srp_pay_groups.org_id%TYPE;
1861: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;
1862: l_count NUMBER;
1863: l_null_date CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');
1864:
1865: BEGIN

Line 1897: from cn_srp_pay_groups_all spp, cn_pay_groups_all cpp

1893: select spp.start_date, spp.end_date, spp.salesrep_id,
1894: spp.lock_flag,cpp.pay_group_id, spp.org_id
1895: into l_start_date, l_end_date, l_salesrep_id,
1896: l_lock_flag,l_pay_group_id, l_org_id
1897: from cn_srp_pay_groups_all spp, cn_pay_groups_all cpp
1898: where spp.role_pay_group_id = p_role_pay_group_id
1899: AND spp.salesrep_id = l_salesrep_id
1900: AND cpp.pay_group_id = spp.pay_group_id
1901: AND Greatest(spp.start_date, l_srp_start_date) <=

Line 1930: Update cn_srp_pay_groups_all

1926:
1927: IF l_count > 0
1928: THEN
1929: -- Making it a direct assignment if paysheets exist - for Bug 5557049.
1930: Update cn_srp_pay_groups_all
1931: set role_pay_group_id = null
1932: where role_pay_group_id = p_role_pay_group_id
1933: and salesrep_id = l_salesrep_id
1934: and org_id = l_org_id;