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_PLAN_ASSIGNS_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 1: PACKAGE BODY CN_SRP_PLAN_ASSIGNS_PVT AS

1: PACKAGE BODY CN_SRP_PLAN_ASSIGNS_PVT AS
2: /* $Header: cnvspab.pls 120.2.12010000.2 2009/11/05 21:59:37 rnagaraj ship $ */
3:
4: -- Global variablefor the translatable name for all Plan Assign objects.
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PLAN_ASSIGNS_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PLAN_ASSIGNS_PVT';

1: PACKAGE BODY CN_SRP_PLAN_ASSIGNS_PVT AS
2: /* $Header: cnvspab.pls 120.2.12010000.2 2009/11/05 21:59:37 rnagaraj ship $ */
3:
4: -- Global variablefor the translatable name for all Plan Assign objects.
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PLAN_ASSIGNS_PVT';
6: G_NULL_DATE CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
7:
8: --| ----------------------------------------------------------------------+
9: --| Procedure : valid_srp_plan_assign

Line 19: x_srp_plan_assigns_row IN OUT NOCOPY cn_srp_plan_assigns%ROWTYPE ,

15: x_msg_count OUT NOCOPY NUMBER ,
16: x_msg_data OUT NOCOPY VARCHAR2 ,
17: p_srp_role_id IN NUMBER,
18: p_role_plan_id IN NUMBER,
19: x_srp_plan_assigns_row IN OUT NOCOPY cn_srp_plan_assigns%ROWTYPE ,
20: x_role_id OUT NOCOPY NUMBER,
21: p_loading_status IN VARCHAR2 ,
22: x_loading_status OUT NOCOPY VARCHAR2
23: )

Line 187: FROM cn_srp_plan_assigns

183: IF x_srp_plan_assigns_row.srp_plan_assign_id IS NULL THEN
184: SELECT 1 INTO l_dummy FROM dual
185: WHERE NOT EXISTS
186: (SELECT 1
187: FROM cn_srp_plan_assigns
188: WHERE role_plan_id = p_role_plan_id
189: AND srp_role_id = p_srp_role_id);
190: END IF ;
191: EXCEPTION

Line 280: l_spa_row cn_srp_plan_assigns%ROWTYPE ;

276: ) IS
277:
278: l_api_name CONSTANT VARCHAR2(30) := 'Create_Srp_Plan_Assigns';
279: l_api_version CONSTANT NUMBER := 1.0;
280: l_spa_row cn_srp_plan_assigns%ROWTYPE ;
281: l_role_id cn_roles.role_id%TYPE;
282: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
283:
284: l_temp_count NUMBER;

Line 335: -- Create comp plan assignment into cn_srp_plan_assigns

331: ELSIF x_loading_status = 'CN_SPA_NO_INTERSECT_DATE' THEN
332: x_loading_status := 'CN_INSERTED';
333: GOTO end_of_create_srp_plan_assigns;
334: ELSE
335: -- Create comp plan assignment into cn_srp_plan_assigns
336: cn_srp_plan_assigns_pkg.insert_row
337: (x_srp_plan_assign_id => x_srp_plan_assign_id
338: ,x_srp_role_id => l_spa_row.srp_role_id
339: ,x_role_plan_id => l_spa_row.role_plan_id

Line 336: cn_srp_plan_assigns_pkg.insert_row

332: x_loading_status := 'CN_INSERTED';
333: GOTO end_of_create_srp_plan_assigns;
334: ELSE
335: -- Create comp plan assignment into cn_srp_plan_assigns
336: cn_srp_plan_assigns_pkg.insert_row
337: (x_srp_plan_assign_id => x_srp_plan_assign_id
338: ,x_srp_role_id => l_spa_row.srp_role_id
339: ,x_role_plan_id => l_spa_row.role_plan_id
340: ,x_salesrep_id => l_spa_row.salesrep_id

Line 498: l_spa_row cn_srp_plan_assigns%ROWTYPE ;

494: ) IS
495:
496: l_api_name CONSTANT VARCHAR2(30) := 'Update_Srp_Plan_Assigns';
497: l_api_version CONSTANT NUMBER := 1.0;
498: l_spa_row cn_srp_plan_assigns%ROWTYPE ;
499: l_role_id cn_roles.role_id%TYPE;
500: l_old_start_date cn_srp_plan_assigns.start_date%TYPE;
501: l_old_end_date cn_srp_plan_assigns.end_date%TYPE;
502: l_srp_plan_assigns_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

Line 500: l_old_start_date cn_srp_plan_assigns.start_date%TYPE;

496: l_api_name CONSTANT VARCHAR2(30) := 'Update_Srp_Plan_Assigns';
497: l_api_version CONSTANT NUMBER := 1.0;
498: l_spa_row cn_srp_plan_assigns%ROWTYPE ;
499: l_role_id cn_roles.role_id%TYPE;
500: l_old_start_date cn_srp_plan_assigns.start_date%TYPE;
501: l_old_end_date cn_srp_plan_assigns.end_date%TYPE;
502: l_srp_plan_assigns_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
503:
504: l_temp_count NUMBER;

Line 501: l_old_end_date cn_srp_plan_assigns.end_date%TYPE;

497: l_api_version CONSTANT NUMBER := 1.0;
498: l_spa_row cn_srp_plan_assigns%ROWTYPE ;
499: l_role_id cn_roles.role_id%TYPE;
500: l_old_start_date cn_srp_plan_assigns.start_date%TYPE;
501: l_old_end_date cn_srp_plan_assigns.end_date%TYPE;
502: l_srp_plan_assigns_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
503:
504: l_temp_count NUMBER;
505: l_temp_start_date DATE;

Line 502: l_srp_plan_assigns_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

498: l_spa_row cn_srp_plan_assigns%ROWTYPE ;
499: l_role_id cn_roles.role_id%TYPE;
500: l_old_start_date cn_srp_plan_assigns.start_date%TYPE;
501: l_old_end_date cn_srp_plan_assigns.end_date%TYPE;
502: l_srp_plan_assigns_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
503:
504: l_temp_count NUMBER;
505: l_temp_start_date DATE;
506: l_temp_end_date DATE;

Line 533: -- Check old rec exist in cn_srp_plan_assigns

529: -- Initialize API return status to success
530: x_return_status := FND_API.G_RET_STS_SUCCESS;
531: x_loading_status := 'CN_UPDATED';
532: -- API body
533: -- Check old rec exist in cn_srp_plan_assigns
534: BEGIN
535: SELECT * INTO l_spa_row
536: FROM cn_srp_plan_assigns
537: WHERE srp_role_id = p_srp_role_id

Line 536: FROM cn_srp_plan_assigns

532: -- API body
533: -- Check old rec exist in cn_srp_plan_assigns
534: BEGIN
535: SELECT * INTO l_spa_row
536: FROM cn_srp_plan_assigns
537: WHERE srp_role_id = p_srp_role_id
538: AND role_plan_id = p_role_plan_id;
539: EXCEPTION
540: WHEN NO_DATA_FOUND THEN

Line 541: -- CN_SRP_PLAN_ASSIGNS_NOT_EXIST, create new record

537: WHERE srp_role_id = p_srp_role_id
538: AND role_plan_id = p_role_plan_id;
539: EXCEPTION
540: WHEN NO_DATA_FOUND THEN
541: -- CN_SRP_PLAN_ASSIGNS_NOT_EXIST, create new record
542: CN_SRP_PLAN_ASSIGNS_PVT.Create_Srp_Plan_Assigns
543: (p_api_version => 1.0,
544: x_return_status => x_return_status,
545: x_msg_count => x_msg_count,

Line 542: CN_SRP_PLAN_ASSIGNS_PVT.Create_Srp_Plan_Assigns

538: AND role_plan_id = p_role_plan_id;
539: EXCEPTION
540: WHEN NO_DATA_FOUND THEN
541: -- CN_SRP_PLAN_ASSIGNS_NOT_EXIST, create new record
542: CN_SRP_PLAN_ASSIGNS_PVT.Create_Srp_Plan_Assigns
543: (p_api_version => 1.0,
544: x_return_status => x_return_status,
545: x_msg_count => x_msg_count,
546: x_msg_data => x_msg_data,

Line 577: -- Delete entry in cn_srp_plan_assigns

573: );
574: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
575: RAISE FND_API.G_EXC_ERROR ;
576: ELSIF x_loading_status = 'CN_SPA_NO_INTERSECT_DATE' THEN
577: -- Delete entry in cn_srp_plan_assigns
578: Delete_Srp_Plan_Assigns
579: (p_api_version => 1.0,
580: x_return_status => x_return_status,
581: x_msg_count => x_msg_count,

Line 593: -- Update comp plan assignment into cn_srp_plan_assigns

589: ELSE
590: x_loading_status := 'CN_UPDATED';
591: END IF;
592: ELSE
593: -- Update comp plan assignment into cn_srp_plan_assigns
594: cn_srp_plan_assigns_pkg.update_row
595: (x_srp_plan_assign_id => l_spa_row.srp_plan_assign_id
596: ,x_srp_role_id => l_spa_row.srp_role_id
597: ,x_role_plan_id => l_spa_row.role_plan_id

Line 594: cn_srp_plan_assigns_pkg.update_row

590: x_loading_status := 'CN_UPDATED';
591: END IF;
592: ELSE
593: -- Update comp plan assignment into cn_srp_plan_assigns
594: cn_srp_plan_assigns_pkg.update_row
595: (x_srp_plan_assign_id => l_spa_row.srp_plan_assign_id
596: ,x_srp_role_id => l_spa_row.srp_role_id
597: ,x_role_plan_id => l_spa_row.role_plan_id
598: ,x_salesrep_id => l_spa_row.salesrep_id

Line 739: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

735: ) IS
736:
737: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Srp_Plan_Assigns';
738: l_api_version CONSTANT NUMBER := 1.0;
739: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
740:
741: BEGIN
742: -- Standard Start of API savepoint
743: SAVEPOINT Delete_Srp_Plan_Assigns;

Line 761: FROM cn_srp_plan_assigns

757: -- API body
758: -- Check if record exist in db
759: BEGIN
760: SELECT srp_plan_assign_id INTO l_srp_plan_assign_id
761: FROM cn_srp_plan_assigns
762: WHERE srp_role_id = p_srp_role_id
763: AND role_plan_id = p_role_plan_id;
764: EXCEPTION
765: WHEN NO_DATA_FOUND THEN

Line 767: -- FND_MESSAGE.Set_Name('CN', 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST');

763: AND role_plan_id = p_role_plan_id;
764: EXCEPTION
765: WHEN NO_DATA_FOUND THEN
766: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
767: -- FND_MESSAGE.Set_Name('CN', 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST');
768: -- FND_MSG_PUB.Add;
769: -- END IF;
770: -- x_loading_status := 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST';
771: -- RAISE FND_API.G_EXC_ERROR ;

Line 770: -- x_loading_status := 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST';

766: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
767: -- FND_MESSAGE.Set_Name('CN', 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST');
768: -- FND_MSG_PUB.Add;
769: -- END IF;
770: -- x_loading_status := 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST';
771: -- RAISE FND_API.G_EXC_ERROR ;
772:
773: -- CN_SRP_PLAN_ASSIGNS_NOT_EXIST, nothing to delete, exit api
774: GOTO end_of_delete_srp_plan_assigns;

Line 773: -- CN_SRP_PLAN_ASSIGNS_NOT_EXIST, nothing to delete, exit api

769: -- END IF;
770: -- x_loading_status := 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST';
771: -- RAISE FND_API.G_EXC_ERROR ;
772:
773: -- CN_SRP_PLAN_ASSIGNS_NOT_EXIST, nothing to delete, exit api
774: GOTO end_of_delete_srp_plan_assigns;
775: END;
776: -- Delete detail record
777: cn_srp_quota_assigns_pkg.delete_record

Line 781: -- Delete comp plan assignment from cn_srp_plan_assigns

777: cn_srp_quota_assigns_pkg.delete_record
778: (x_srp_plan_assign_id => l_srp_plan_assign_id
779: ,x_quota_id => null);
780:
781: -- Delete comp plan assignment from cn_srp_plan_assigns
782: cn_srp_plan_assigns_pkg.delete_row
783: (x_srp_plan_assign_id => l_srp_plan_assign_id);
784: -- End of API body.
785: << end_of_delete_srp_plan_assigns >>

Line 782: cn_srp_plan_assigns_pkg.delete_row

778: (x_srp_plan_assign_id => l_srp_plan_assign_id
779: ,x_quota_id => null);
780:
781: -- Delete comp plan assignment from cn_srp_plan_assigns
782: cn_srp_plan_assigns_pkg.delete_row
783: (x_srp_plan_assign_id => l_srp_plan_assign_id);
784: -- End of API body.
785: << end_of_delete_srp_plan_assigns >>
786: NULL;

Line 835: END CN_SRP_PLAN_ASSIGNS_PVT ;

831: p_encoded => FND_API.G_FALSE
832: );
833: END Delete_Srp_Plan_Assigns;
834:
835: END CN_SRP_PLAN_ASSIGNS_PVT ;