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.JTF_RS_GROUP_RELATE_VUHK dependencies on FND_API

Line 32: p_return_code := fnd_api.g_ret_sts_success;

28: P_COUNT OUT NOCOPY NUMBER,
29: P_RETURN_CODE OUT NOCOPY VARCHAR2
30: ) IS
31: BEGIN
32: p_return_code := fnd_api.g_ret_sts_success;
33: END create_res_group_relate_pre;
34:
35:
36: PROCEDURE update_res_group_relate_pre

Line 38: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

34:
35:
36: PROCEDURE update_res_group_relate_pre
37: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
38: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
39: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
40: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
41: P_DATA OUT NOCOPY VARCHAR2,
42: P_COUNT OUT NOCOPY NUMBER,

Line 39: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

35:
36: PROCEDURE update_res_group_relate_pre
37: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
38: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
39: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
40: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
41: P_DATA OUT NOCOPY VARCHAR2,
42: P_COUNT OUT NOCOPY NUMBER,
43: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 108: p_return_code := fnd_api.g_ret_sts_success;

104:
105: CURSOR get_orgs IS
106: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
107: BEGIN
108: p_return_code := fnd_api.g_ret_sts_success;
109:
110: IF fnd_profile.value('CN_MARK_EVENTS') <> 'Y' THEN
111: RETURN;
112: END IF;

Line 164: p_init_msg_list => FND_API.G_false,

160: l_srp.end_date := l_end_date;
161:
162: cn_rollup_pvt.get_ancestor_salesrep
163: ( p_api_version => 1.0,
164: p_init_msg_list => FND_API.G_false,
165: p_commit => FND_API.G_false,
166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
167: x_return_status => l_return_status,
168: x_msg_count => l_msg_count,

Line 165: p_commit => FND_API.G_false,

161:
162: cn_rollup_pvt.get_ancestor_salesrep
163: ( p_api_version => 1.0,
164: p_init_msg_list => FND_API.G_false,
165: p_commit => FND_API.G_false,
166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
167: x_return_status => l_return_status,
168: x_msg_count => l_msg_count,
169: x_msg_data => l_msg_data,

Line 166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

162: cn_rollup_pvt.get_ancestor_salesrep
163: ( p_api_version => 1.0,
164: p_init_msg_list => FND_API.G_false,
165: p_commit => FND_API.G_false,
166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
167: x_return_status => l_return_status,
168: x_msg_count => l_msg_count,
169: x_msg_data => l_msg_data,
170: p_srp => l_srp,

Line 242: p_init_msg_list => FND_API.G_false,

238: l_srp.end_date := g_end_date_old;
239:
240: cn_rollup_pvt.get_ancestor_salesrep
241: ( p_api_version => 1.0,
242: p_init_msg_list => FND_API.G_false,
243: p_commit => FND_API.G_false,
244: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
245: x_return_status => l_return_status,
246: x_msg_count => l_msg_count,

Line 243: p_commit => FND_API.G_false,

239:
240: cn_rollup_pvt.get_ancestor_salesrep
241: ( p_api_version => 1.0,
242: p_init_msg_list => FND_API.G_false,
243: p_commit => FND_API.G_false,
244: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
245: x_return_status => l_return_status,
246: x_msg_count => l_msg_count,
247: x_msg_data => l_msg_data,

Line 244: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

240: cn_rollup_pvt.get_ancestor_salesrep
241: ( p_api_version => 1.0,
242: p_init_msg_list => FND_API.G_false,
243: p_commit => FND_API.G_false,
244: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
245: x_return_status => l_return_status,
246: x_msg_count => l_msg_count,
247: x_msg_data => l_msg_data,
248: p_srp => l_srp,

Line 317: p_return_code := fnd_api.g_ret_sts_unexp_error;

313: restore_context(l_orig_acc_mode, l_orig_org_id);
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: p_return_code := fnd_api.g_ret_sts_unexp_error;
318: restore_context(l_orig_acc_mode, l_orig_org_id);
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 327: p_encoded => FND_API.g_false

323: FND_MSG_PUB.count_and_get
324: (
325: p_count => p_count ,
326: p_data => p_data ,
327: p_encoded => FND_API.g_false
328: );
329:
330: END update_res_group_relate_pre;
331:

Line 403: p_return_code := fnd_api.g_ret_sts_success;

399:
400: CURSOR get_orgs is
401: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
402: BEGIN
403: p_return_code := fnd_api.g_ret_sts_success;
404:
405: IF fnd_profile.value('CN_MARK_EVENTS') <> 'Y' THEN
406: RETURN;
407: END IF;

Line 483: p_init_msg_list => FND_API.G_false,

479: l_srp.end_date := l_end_date;
480:
481: cn_rollup_pvt.get_ancestor_salesrep
482: ( p_api_version => 1.0,
483: p_init_msg_list => FND_API.G_false,
484: p_commit => FND_API.G_false,
485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
486: x_return_status => l_return_status,
487: x_msg_count => l_msg_count,

Line 484: p_commit => FND_API.G_false,

480:
481: cn_rollup_pvt.get_ancestor_salesrep
482: ( p_api_version => 1.0,
483: p_init_msg_list => FND_API.G_false,
484: p_commit => FND_API.G_false,
485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
486: x_return_status => l_return_status,
487: x_msg_count => l_msg_count,
488: x_msg_data => l_msg_data,

Line 485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

481: cn_rollup_pvt.get_ancestor_salesrep
482: ( p_api_version => 1.0,
483: p_init_msg_list => FND_API.G_false,
484: p_commit => FND_API.G_false,
485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
486: x_return_status => l_return_status,
487: x_msg_count => l_msg_count,
488: x_msg_data => l_msg_data,
489: p_srp => l_srp,

Line 540: p_return_code := fnd_api.g_ret_sts_unexp_error;

536: restore_context(l_orig_acc_mode, l_orig_org_id);
537:
538: EXCEPTION
539: WHEN OTHERS THEN
540: p_return_code := fnd_api.g_ret_sts_unexp_error;
541: restore_context(l_orig_acc_mode, l_orig_org_id);
542: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
543: THEN
544: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 550: p_encoded => FND_API.g_false

546: FND_MSG_PUB.count_and_get
547: (
548: p_count => p_count ,
549: p_data => p_data ,
550: p_encoded => FND_API.g_false
551: );
552: END delete_res_group_relate_pre;
553:
554: PROCEDURE create_res_group_relate_post

Line 627: p_return_code := fnd_api.g_ret_sts_success;

623:
624: CURSOR get_orgs is
625: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
626: BEGIN
627: p_return_code := fnd_api.g_ret_sts_success;
628:
629: IF fnd_profile.value('CN_MARK_EVENTS') <> 'Y' THEN
630: RETURN;
631: END IF;

Line 708: p_init_msg_list => FND_API.G_false,

704: l_srp.group_id := p_group_id;
705:
706: cn_rollup_pvt.get_ancestor_salesrep
707: ( p_api_version => 1.0,
708: p_init_msg_list => FND_API.G_false,
709: p_commit => FND_API.G_false,
710: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
711: x_return_status => l_return_status,
712: x_msg_count => l_msg_count,

Line 709: p_commit => FND_API.G_false,

705:
706: cn_rollup_pvt.get_ancestor_salesrep
707: ( p_api_version => 1.0,
708: p_init_msg_list => FND_API.G_false,
709: p_commit => FND_API.G_false,
710: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
711: x_return_status => l_return_status,
712: x_msg_count => l_msg_count,
713: x_msg_data => l_msg_data,

Line 710: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

706: cn_rollup_pvt.get_ancestor_salesrep
707: ( p_api_version => 1.0,
708: p_init_msg_list => FND_API.G_false,
709: p_commit => FND_API.G_false,
710: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
711: x_return_status => l_return_status,
712: x_msg_count => l_msg_count,
713: x_msg_data => l_msg_data,
714: p_srp => l_srp,

Line 765: p_return_code := fnd_api.g_ret_sts_unexp_error;

761: restore_context(l_orig_acc_mode, l_orig_org_id);
762:
763: EXCEPTION
764: WHEN OTHERS THEN
765: p_return_code := fnd_api.g_ret_sts_unexp_error;
766: restore_context(l_orig_acc_mode, l_orig_org_id);
767: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
768: THEN
769: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 775: p_encoded => FND_API.g_false

771: FND_MSG_PUB.count_and_get
772: (
773: p_count => p_count ,
774: p_data => p_data ,
775: p_encoded => FND_API.g_false
776: );
777: END create_res_group_relate_post;
778:
779:

Line 782: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

778:
779:
780: PROCEDURE update_res_group_relate_post
781: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
782: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
783: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
784: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
785: P_DATA OUT NOCOPY VARCHAR2,
786: P_COUNT OUT NOCOPY NUMBER,

Line 783: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

779:
780: PROCEDURE update_res_group_relate_post
781: (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
782: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
783: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
784: P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
785: P_DATA OUT NOCOPY VARCHAR2,
786: P_COUNT OUT NOCOPY NUMBER,
787: P_RETURN_CODE OUT NOCOPY VARCHAR2

Line 835: p_return_code := fnd_api.g_ret_sts_success;

831:
832: CURSOR get_orgs IS
833: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
834: BEGIN
835: p_return_code := fnd_api.g_ret_sts_success;
836:
837: IF fnd_profile.value('CN_MARK_EVENTS') <> 'Y' THEN
838: RETURN;
839: END IF;

Line 882: p_init_msg_list => FND_API.G_false,

878: l_srp.end_date := l_end_date;
879:
880: cn_rollup_pvt.get_ancestor_salesrep
881: ( p_api_version => 1.0,
882: p_init_msg_list => FND_API.G_false,
883: p_commit => FND_API.G_false,
884: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
885: x_return_status => l_return_status,
886: x_msg_count => l_msg_count,

Line 883: p_commit => FND_API.G_false,

879:
880: cn_rollup_pvt.get_ancestor_salesrep
881: ( p_api_version => 1.0,
882: p_init_msg_list => FND_API.G_false,
883: p_commit => FND_API.G_false,
884: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
885: x_return_status => l_return_status,
886: x_msg_count => l_msg_count,
887: x_msg_data => l_msg_data,

Line 884: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

880: cn_rollup_pvt.get_ancestor_salesrep
881: ( p_api_version => 1.0,
882: p_init_msg_list => FND_API.G_false,
883: p_commit => FND_API.G_false,
884: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
885: x_return_status => l_return_status,
886: x_msg_count => l_msg_count,
887: x_msg_data => l_msg_data,
888: p_srp => l_srp,

Line 945: p_init_msg_list => FND_API.G_false,

941: l_srp.end_date := p_end_date_active;
942:
943: cn_rollup_pvt.get_ancestor_salesrep
944: ( p_api_version => 1.0,
945: p_init_msg_list => FND_API.G_false,
946: p_commit => FND_API.G_false,
947: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
948: x_return_status => l_return_status,
949: x_msg_count => l_msg_count,

Line 946: p_commit => FND_API.G_false,

942:
943: cn_rollup_pvt.get_ancestor_salesrep
944: ( p_api_version => 1.0,
945: p_init_msg_list => FND_API.G_false,
946: p_commit => FND_API.G_false,
947: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
948: x_return_status => l_return_status,
949: x_msg_count => l_msg_count,
950: x_msg_data => l_msg_data,

Line 947: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

943: cn_rollup_pvt.get_ancestor_salesrep
944: ( p_api_version => 1.0,
945: p_init_msg_list => FND_API.G_false,
946: p_commit => FND_API.G_false,
947: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
948: x_return_status => l_return_status,
949: x_msg_count => l_msg_count,
950: x_msg_data => l_msg_data,
951: p_srp => l_srp,

Line 1001: p_return_code := fnd_api.g_ret_sts_unexp_error;

997: restore_context(l_orig_acc_mode, l_orig_org_id);
998:
999: EXCEPTION
1000: WHEN OTHERS THEN
1001: p_return_code := fnd_api.g_ret_sts_unexp_error;
1002: restore_context(l_orig_acc_mode, l_orig_org_id);
1003: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1004: THEN
1005: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 1011: p_encoded => FND_API.g_false

1007: FND_MSG_PUB.count_and_get
1008: (
1009: p_count => p_count ,
1010: p_data => p_data ,
1011: p_encoded => FND_API.g_false
1012: );
1013: END update_res_group_relate_post;
1014:
1015: PROCEDURE delete_res_group_relate_post

Line 1023: p_return_code := fnd_api.g_ret_sts_success;

1019: P_COUNT OUT NOCOPY NUMBER,
1020: P_RETURN_CODE OUT NOCOPY VARCHAR2
1021: ) IS
1022: BEGIN
1023: p_return_code := fnd_api.g_ret_sts_success;
1024: END delete_res_group_relate_post;
1025:
1026:
1027: FUNCTION Ok_To_Generate_Msg

Line 1033: p_return_code := fnd_api.g_ret_sts_success;

1029: P_COUNT OUT NOCOPY NUMBER,
1030: P_RETURN_CODE OUT NOCOPY VARCHAR2)
1031: RETURN BOOLEAN IS
1032: BEGIN
1033: p_return_code := fnd_api.g_ret_sts_success;
1034: RETURN false;
1035: END ok_to_generate_msg;
1036:
1037: END jtf_rs_group_relate_vuhk;