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.

[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PUB dependencies on CN_SRP_PMT_PLANS

Line 1: PACKAGE BODY CN_SRP_PMT_PLANS_PUB AS

1: PACKAGE BODY CN_SRP_PMT_PLANS_PUB AS
2: /* $Header: cnpsppab.pls 120.4 2005/10/27 16:03:49 mblum noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PMT_PLANS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpsppab.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PMT_PLANS_PUB';

1: PACKAGE BODY CN_SRP_PMT_PLANS_PUB AS
2: /* $Header: cnpsppab.pls 120.4 2005/10/27 16:03:49 mblum noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PMT_PLANS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpsppab.pls';
6:
7: G_EMP_NUM CONSTANT VARCHAR2(80)
8: := cn_api.get_lkup_meaning('EMP_NUM','SRP_OBJECT_TYPE');

Line 24: x_srp_pmt_plans_row IN OUT NOCOPY cn_srp_pmt_plans%ROWTYPE ,

20: x_return_status OUT NOCOPY VARCHAR2 ,
21: x_msg_count OUT NOCOPY NUMBER ,
22: x_msg_data OUT NOCOPY VARCHAR2 ,
23: p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type,
24: x_srp_pmt_plans_row IN OUT NOCOPY cn_srp_pmt_plans%ROWTYPE ,
25: x_srp_start_date OUT NOCOPY cn_salesreps.start_date_active%TYPE,
26: x_srp_end_date OUT NOCOPY cn_salesreps.end_date_active%TYPE,
27: x_pp_start_date OUT NOCOPY cn_pmt_plans.start_date%TYPE,
28: x_pp_end_date OUT NOCOPY cn_pmt_plans.end_date%TYPE,

Line 111: FROM cn_srp_pmt_plans_all

107: BEGIN
108: IF p_action = 'GETOLDREC' THEN
109: SELECT *
110: INTO x_srp_pmt_plans_row
111: FROM cn_srp_pmt_plans_all
112: WHERE pmt_plan_id = x_srp_pmt_plans_row.pmt_plan_id
113: AND salesrep_id = x_srp_pmt_plans_row.salesrep_id
114: AND trunc(start_date) = trunc(p_srp_pmt_plans_rec.start_date)
115: ;

Line 147: x_srp_pmt_plans_row IN OUT NOCOPY cn_srp_pmt_plans%ROWTYPE ,

143: x_return_status OUT NOCOPY VARCHAR2 ,
144: x_msg_count OUT NOCOPY NUMBER ,
145: x_msg_data OUT NOCOPY VARCHAR2 ,
146: p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type,
147: x_srp_pmt_plans_row IN OUT NOCOPY cn_srp_pmt_plans%ROWTYPE ,
148: p_action IN VARCHAR2,
149: p_loading_status IN VARCHAR2 ,
150: x_loading_status OUT NOCOPY VARCHAR2
151: )

Line 282: l_spp_row cn_srp_pmt_plans%ROWTYPE ;

278:
279: l_api_name CONSTANT VARCHAR2(30) := 'Create_Srp_Pmt_Plan';
280: l_api_version CONSTANT NUMBER := 1.0;
281: l_spp_rec srp_pmt_plans_rec_type;
282: l_spp_row cn_srp_pmt_plans%ROWTYPE ;
283:
284: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
285: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
286: l_start_date cn_srp_pmt_plans.start_date%TYPE;

Line 284: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;

280: l_api_version CONSTANT NUMBER := 1.0;
281: l_spp_rec srp_pmt_plans_rec_type;
282: l_spp_row cn_srp_pmt_plans%ROWTYPE ;
283:
284: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
285: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
286: l_start_date cn_srp_pmt_plans.start_date%TYPE;
287: l_end_date cn_srp_pmt_plans.end_date%TYPE;
288: l_action VARCHAR2(30) := 'CREATE';

Line 285: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;

281: l_spp_rec srp_pmt_plans_rec_type;
282: l_spp_row cn_srp_pmt_plans%ROWTYPE ;
283:
284: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
285: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
286: l_start_date cn_srp_pmt_plans.start_date%TYPE;
287: l_end_date cn_srp_pmt_plans.end_date%TYPE;
288: l_action VARCHAR2(30) := 'CREATE';
289: l_create_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;

Line 286: l_start_date cn_srp_pmt_plans.start_date%TYPE;

282: l_spp_row cn_srp_pmt_plans%ROWTYPE ;
283:
284: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
285: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
286: l_start_date cn_srp_pmt_plans.start_date%TYPE;
287: l_end_date cn_srp_pmt_plans.end_date%TYPE;
288: l_action VARCHAR2(30) := 'CREATE';
289: l_create_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
290: l_org_id NUMBER;

Line 287: l_end_date cn_srp_pmt_plans.end_date%TYPE;

283:
284: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
285: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
286: l_start_date cn_srp_pmt_plans.start_date%TYPE;
287: l_end_date cn_srp_pmt_plans.end_date%TYPE;
288: l_action VARCHAR2(30) := 'CREATE';
289: l_create_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
290: l_org_id NUMBER;
291: l_status VARCHAR2(1);

Line 289: l_create_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;

285: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
286: l_start_date cn_srp_pmt_plans.start_date%TYPE;
287: l_end_date cn_srp_pmt_plans.end_date%TYPE;
288: l_action VARCHAR2(30) := 'CREATE';
289: l_create_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
290: l_org_id NUMBER;
291: l_status VARCHAR2(1);
292:
293: -- Declaration for user hooks

Line 330: 'cn.plsql.cn_srp_pmt_plans_pub.create_srp_pmt_plan.org_validate',

326: status => l_status);
327:
328: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
329: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
330: 'cn.plsql.cn_srp_pmt_plans_pub.create_srp_pmt_plan.org_validate',
331: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
332: end if;
333: l_spp_rec.org_id := l_org_id;
334:

Line 379: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

375:
376: --
377: -- User hooks
378: --
379: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
380: 'CREATE_SRP_PMT_PLAN',
381: 'B',
382: 'C')
383: THEN

Line 384: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_pre

380: 'CREATE_SRP_PMT_PLAN',
381: 'B',
382: 'C')
383: THEN
384: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_pre
385: (p_api_version => p_api_version,
386: p_init_msg_list => fnd_api.g_false,
387: p_commit => fnd_api.g_false,
388: p_validation_level => p_validation_level,

Line 406: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: END IF;
405:
406: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
407: 'CREATE_SRP_PMT_PLAN',
408: 'B',
409: 'V')
410: THEN

Line 411: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_pre

407: 'CREATE_SRP_PMT_PLAN',
408: 'B',
409: 'V')
410: THEN
411: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_pre
412: (p_api_version => p_api_version,
413: p_init_msg_list => fnd_api.g_false,
414: p_commit => fnd_api.g_false,
415: p_validation_level => p_validation_level,

Line 446: cn_srp_pmt_plans_pvt.create_srp_pmt_plan

442: l_create_rec.srp_role_id := p_srp_pmt_plans_rec.srp_role_id;
443: l_create_rec.role_pmt_plan_id := p_srp_pmt_plans_rec.role_pmt_plan_id;
444: l_create_rec.lock_flag := p_srp_pmt_plans_rec.lock_flag;
445:
446: cn_srp_pmt_plans_pvt.create_srp_pmt_plan
447: ( p_api_version => p_api_version,
448: p_init_msg_list => fnd_api.g_false,
449: p_commit => fnd_api.g_false,
450: p_validation_level => p_validation_level,

Line 470: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

466:
467: --
468: -- Post processing hooks
469: --
470: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
471: 'CREATE_SRP_PMT_PLAN',
472: 'A',
473: 'V')
474: THEN

Line 475: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_post

471: 'CREATE_SRP_PMT_PLAN',
472: 'A',
473: 'V')
474: THEN
475: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_post
476: (p_api_version => p_api_version,
477: p_init_msg_list => fnd_api.g_false,
478: p_commit => fnd_api.g_false,
479: p_validation_level => p_validation_level,

Line 497: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495: END IF;
496:
497: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
498: 'CREATE_SRP_PMT_PLAN',
499: 'A',
500: 'C')
501: THEN

Line 502: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_post

498: 'CREATE_SRP_PMT_PLAN',
499: 'A',
500: 'C')
501: THEN
502: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_post
503: (p_api_version => p_api_version,
504: p_init_msg_list => fnd_api.g_false,
505: p_commit => fnd_api.g_false,
506: p_validation_level => p_validation_level,

Line 527: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

523:
524: --
525: -- Message enable hook
526: --
527: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
528: 'CREATE_SRP_PMT_PLAN',
529: 'M',
530: 'M')
531: THEN

Line 532: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg

528: 'CREATE_SRP_PMT_PLAN',
529: 'M',
530: 'M')
531: THEN
532: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg
533: (p_srp_pmt_plans_rec => l_spp_rec)
534: THEN
535: -- Clear bind variables
536: -- XMLGEN.clearBindValues;

Line 645: l_spp_row cn_srp_pmt_plans%ROWTYPE;

641: l_api_name CONSTANT VARCHAR2(30) := 'Update_Srp_Pmt_Plan';
642: l_api_version CONSTANT NUMBER := 1.0;
643: l_spp_rec srp_pmt_plans_rec_type;
644: l_old_spp_rec srp_pmt_plans_rec_type;
645: l_spp_row cn_srp_pmt_plans%ROWTYPE;
646: l_old_spp_row cn_srp_pmt_plans%ROWTYPE;
647: l_org_id NUMBER;
648: l_status VARCHAR2(1);
649:

Line 646: l_old_spp_row cn_srp_pmt_plans%ROWTYPE;

642: l_api_version CONSTANT NUMBER := 1.0;
643: l_spp_rec srp_pmt_plans_rec_type;
644: l_old_spp_rec srp_pmt_plans_rec_type;
645: l_spp_row cn_srp_pmt_plans%ROWTYPE;
646: l_old_spp_row cn_srp_pmt_plans%ROWTYPE;
647: l_org_id NUMBER;
648: l_status VARCHAR2(1);
649:
650: l_start_date cn_srp_pmt_plans.start_date%TYPE;

Line 650: l_start_date cn_srp_pmt_plans.start_date%TYPE;

646: l_old_spp_row cn_srp_pmt_plans%ROWTYPE;
647: l_org_id NUMBER;
648: l_status VARCHAR2(1);
649:
650: l_start_date cn_srp_pmt_plans.start_date%TYPE;
651: l_end_date cn_srp_pmt_plans.end_date%TYPE;
652: l_srp_start_date cn_salesreps.start_date_active%TYPE;
653: l_srp_end_date cn_salesreps.end_date_active%TYPE;
654: l_pp_start_date cn_pmt_plans.start_date%TYPE;

Line 651: l_end_date cn_srp_pmt_plans.end_date%TYPE;

647: l_org_id NUMBER;
648: l_status VARCHAR2(1);
649:
650: l_start_date cn_srp_pmt_plans.start_date%TYPE;
651: l_end_date cn_srp_pmt_plans.end_date%TYPE;
652: l_srp_start_date cn_salesreps.start_date_active%TYPE;
653: l_srp_end_date cn_salesreps.end_date_active%TYPE;
654: l_pp_start_date cn_pmt_plans.start_date%TYPE;
655: l_pp_end_date cn_pmt_plans.end_date%TYPE;

Line 657: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

653: l_srp_end_date cn_salesreps.end_date_active%TYPE;
654: l_pp_start_date cn_pmt_plans.start_date%TYPE;
655: l_pp_end_date cn_pmt_plans.end_date%TYPE;
656: l_action VARCHAR2(30) := 'UPDATE';
657: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
658: l_update_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
659:
660: -- Declaration for user hooks
661: l_OAI_array JTF_USR_HKS.oai_data_array_type;

Line 658: l_update_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;

654: l_pp_start_date cn_pmt_plans.start_date%TYPE;
655: l_pp_end_date cn_pmt_plans.end_date%TYPE;
656: l_action VARCHAR2(30) := 'UPDATE';
657: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
658: l_update_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
659:
660: -- Declaration for user hooks
661: l_OAI_array JTF_USR_HKS.oai_data_array_type;
662: l_bind_data_id NUMBER ;

Line 697: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.error',

693: Nvl(l_spp_rec.org_id, -99) then
694: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
695: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
696: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
697: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.error',
698: true);
699: end if;
700:
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 716: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.org_validate',

712: status => l_status);
713:
714: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
715: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
716: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.org_validate',
717: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
718: end if;
719: l_old_spp_rec.org_id := l_org_id;
720: l_spp_rec.org_id := l_org_id;

Line 811: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

807:
808: --
809: -- User hooks
810: --
811: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
812: 'UPDATE_SRP_PMT_PLAN',
813: 'B',
814: 'C')
815: THEN

Line 816: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_pre

812: 'UPDATE_SRP_PMT_PLAN',
813: 'B',
814: 'C')
815: THEN
816: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_pre
817: (p_api_version => p_api_version,
818: p_init_msg_list => fnd_api.g_false,
819: p_commit => fnd_api.g_false,
820: p_validation_level => p_validation_level,

Line 838: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836: END IF;
837:
838: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
839: 'UPDATE_SRP_PMT_PLAN',
840: 'B',
841: 'V')
842: THEN

Line 843: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_pre

839: 'UPDATE_SRP_PMT_PLAN',
840: 'B',
841: 'V')
842: THEN
843: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_pre
844: (p_api_version => p_api_version,
845: p_init_msg_list => fnd_api.g_false,
846: p_commit => fnd_api.g_false,
847: p_validation_level => p_validation_level,

Line 879: cn_srp_pmt_plans_pvt.update_srp_pmt_plan

875: l_update_rec.srp_role_id := p_srp_pmt_plans_rec.srp_role_id;
876: l_update_rec.role_pmt_plan_id := p_srp_pmt_plans_rec.role_pmt_plan_id;
877: l_update_rec.lock_flag := p_srp_pmt_plans_rec.lock_flag;
878:
879: cn_srp_pmt_plans_pvt.update_srp_pmt_plan
880: ( p_api_version => p_api_version,
881: p_init_msg_list => fnd_api.g_false,
882: p_commit => fnd_api.g_false,
883: p_validation_level => p_validation_level,

Line 902: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

898:
899: --
900: -- Post processing hooks
901: --
902: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
903: 'UPDATE_SRP_PMT_PLAN',
904: 'A',
905: 'V')
906: THEN

Line 907: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_post

903: 'UPDATE_SRP_PMT_PLAN',
904: 'A',
905: 'V')
906: THEN
907: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_post
908: (p_api_version => p_api_version,
909: p_init_msg_list => fnd_api.g_false,
910: p_commit => fnd_api.g_false,
911: p_validation_level => p_validation_level,

Line 929: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END IF;
927: END IF;
928:
929: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
930: 'UPDATE_SRP_PMT_PLAN',
931: 'A',
932: 'C')
933: THEN

Line 934: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_post

930: 'UPDATE_SRP_PMT_PLAN',
931: 'A',
932: 'C')
933: THEN
934: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_post
935: (p_api_version => p_api_version,
936: p_init_msg_list => fnd_api.g_false,
937: p_commit => fnd_api.g_false,
938: p_validation_level => p_validation_level,

Line 959: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

955:
956: --
957: -- Message enable hook
958: --
959: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
960: 'CREATE_SRP_PMT_PLAN',
961: 'M',
962: 'M')
963: THEN

Line 964: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg

960: 'CREATE_SRP_PMT_PLAN',
961: 'M',
962: 'M')
963: THEN
964: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg
965: (p_srp_pmt_plans_rec => l_spp_rec)
966: THEN
967: -- Clear bind variables
968: -- XMLGEN.clearBindValues;

Line 1074: l_spp_row cn_srp_pmt_plans%ROWTYPE;

1070:
1071: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Srp_Pmt_Plan';
1072: l_api_version CONSTANT NUMBER := 1.0;
1073: l_spp_rec srp_pmt_plans_rec_type := G_MISS_SRP_PMT_PLANS_REC;
1074: l_spp_row cn_srp_pmt_plans%ROWTYPE;
1075:
1076: l_srp_start_date cn_salesreps.start_date_active%TYPE;
1077: l_srp_end_date cn_salesreps.end_date_active%TYPE;
1078: l_pp_start_date cn_pmt_plans.start_date%TYPE;

Line 1123: 'cn.plsql.cn_srp_pmt_plans_pub.delete_srp_pmt_plan.org_validate',

1119: status => l_status);
1120:
1121: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1123: 'cn.plsql.cn_srp_pmt_plans_pub.delete_srp_pmt_plan.org_validate',
1124: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
1125: end if;
1126: l_spp_rec.org_id := l_org_id;
1127:

Line 1172: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1168:
1169: --
1170: -- User hooks
1171: --
1172: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1173: 'DELETE_SRP_PMT_PLAN',
1174: 'B',
1175: 'C')
1176: THEN

Line 1177: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_pre

1173: 'DELETE_SRP_PMT_PLAN',
1174: 'B',
1175: 'C')
1176: THEN
1177: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_pre
1178: (p_api_version => p_api_version,
1179: p_init_msg_list => fnd_api.g_false,
1180: p_commit => fnd_api.g_false,
1181: p_validation_level => p_validation_level,

Line 1197: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: END IF;
1196:
1197: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1198: 'DELETE_SRP_PMT_PLAN',
1199: 'B',
1200: 'V')
1201: THEN

Line 1202: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_pre

1198: 'DELETE_SRP_PMT_PLAN',
1199: 'B',
1200: 'V')
1201: THEN
1202: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_pre
1203: (p_api_version => p_api_version,
1204: p_init_msg_list => fnd_api.g_false,
1205: p_commit => fnd_api.g_false,
1206: p_validation_level => p_validation_level,

Line 1224: cn_srp_pmt_plans_pvt.delete_srp_pmt_plan

1220: END IF;
1221:
1222: -- API body
1223:
1224: cn_srp_pmt_plans_pvt.delete_srp_pmt_plan
1225: (
1226: p_api_version => p_api_version,
1227: p_init_msg_list => fnd_api.g_false,
1228: p_commit => fnd_api.g_false,

Line 1247: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1243:
1244: --
1245: -- Post processing hooks
1246: --
1247: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1248: 'DELETE_SRP_PMT_PLAN',
1249: 'A',
1250: 'V')
1251: THEN

Line 1252: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_post

1248: 'DELETE_SRP_PMT_PLAN',
1249: 'A',
1250: 'V')
1251: THEN
1252: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_post
1253: (p_api_version => p_api_version,
1254: p_init_msg_list => fnd_api.g_false,
1255: p_commit => fnd_api.g_false,
1256: p_validation_level => p_validation_level,

Line 1273: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: END IF;
1271: END IF;
1272:
1273: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1274: 'DELETE_SRP_PMT_PLAN',
1275: 'A',
1276: 'C')
1277: THEN

Line 1278: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_post

1274: 'DELETE_SRP_PMT_PLAN',
1275: 'A',
1276: 'C')
1277: THEN
1278: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_post
1279: (p_api_version => p_api_version,
1280: p_init_msg_list => fnd_api.g_false,
1281: p_commit => fnd_api.g_false,
1282: p_validation_level => p_validation_level,

Line 1301: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

1297: END IF;
1298: --
1299: -- Message enable hook
1300: --
1301: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
1302: 'DELETE_SRP_PMT_PLAN',
1303: 'M',
1304: 'M')
1305: THEN

Line 1306: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg

1302: 'DELETE_SRP_PMT_PLAN',
1303: 'M',
1304: 'M')
1305: THEN
1306: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg
1307: (p_srp_pmt_plans_rec => l_spp_rec)
1308: THEN
1309: -- Clear bind variables
1310: -- XMLGEN.clearBindValues;

Line 1414: cn_srp_pmt_plans_pvt.create_mass_asgn_srp_pmt_plan

1410: x_srp_pmt_plan_id OUT NOCOPY NUMBER,
1411: x_loading_status OUT NOCOPY VARCHAR2
1412: ) IS
1413: BEGIN
1414: cn_srp_pmt_plans_pvt.create_mass_asgn_srp_pmt_plan
1415: (p_api_version => p_api_version,
1416: p_init_msg_list => p_init_msg_list,
1417: p_commit => p_commit,
1418: p_validation_level => p_validation_level,

Line 1446: cn_srp_pmt_plans_pvt.update_mass_asgn_srp_pmt_plan

1442: p_role_pmt_plan_id IN NUMBER,
1443: x_loading_status OUT NOCOPY VARCHAR2
1444: ) IS
1445: BEGIN
1446: cn_srp_pmt_plans_pvt.update_mass_asgn_srp_pmt_plan
1447: (p_api_version => p_api_version,
1448: p_init_msg_list => p_init_msg_list,
1449: p_commit => p_commit,
1450: p_validation_level => p_validation_level,

Line 1477: cn_srp_pmt_plans_pvt.delete_mass_asgn_srp_pmt_plan

1473: p_role_pmt_plan_id IN NUMBER,
1474: x_loading_status OUT NOCOPY VARCHAR2
1475: ) IS
1476: BEGIN
1477: cn_srp_pmt_plans_pvt.delete_mass_asgn_srp_pmt_plan
1478: (p_api_version => p_api_version,
1479: p_init_msg_list => p_init_msg_list,
1480: p_commit => p_commit,
1481: p_validation_level => p_validation_level,

Line 1491: END CN_SRP_PMT_PLANS_PUB;

1487: x_loading_status => x_loading_status);
1488:
1489: END Delete_Mass_Asgn_Srp_Pmt_Plan;
1490:
1491: END CN_SRP_PMT_PLANS_PUB;