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.PA_RESOURCE_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 22: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

18:
19: PROCEDURE Get_Resource_Name
20: (
21: p_resource_type_code IN VARCHAR2,
22: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: p_resource_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: );
26:

Line 31: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

27: PROCEDURE Insert_Members (
28: p_resource_list_id IN NUMBER,
29: p_group_resource_type IN VARCHAR2,
30: p_resource_type_code IN VARCHAR2,
31: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
33: p_resource_alias IN VARCHAR2,
34: p_sort_order IN NUMBER,
35: p_enabled_flag IN VARCHAR2,

Line 32: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

28: p_resource_list_id IN NUMBER,
29: p_group_resource_type IN VARCHAR2,
30: p_resource_type_code IN VARCHAR2,
31: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
33: p_resource_alias IN VARCHAR2,
34: p_sort_order IN NUMBER,
35: p_enabled_flag IN VARCHAR2,
36: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 36: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

32: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
33: p_resource_alias IN VARCHAR2,
34: p_sort_order IN NUMBER,
35: p_enabled_flag IN VARCHAR2,
36: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37: p_job_group_id IN NUMBER, --Added for bug 2486405.
38: p_parent_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
39: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
40: p_track_as_labor_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 146: IF p_resource_list_rec.end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:
145: -- l_resource_list_rec.return_status := FND_API.g_ret_sts_success;
146: IF p_resource_list_rec.end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
147: l_end_date := NULL;
148: ELSE
149: l_end_date := p_resource_list_rec.end_date;
150: END IF;

Line 270: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

266: --
267:
268: PROCEDURE Process_Members
269: (p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
270: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
271: p_member_tbl IN member_tbl,
272: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
273: p_job_group_id IN NUMBER, --Added for bug 2486405.
274: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 272: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

268: PROCEDURE Process_Members
269: (p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
270: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
271: p_member_tbl IN member_tbl,
272: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
273: p_job_group_id IN NUMBER, --Added for bug 2486405.
274: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
275: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
276: p_member_out_tbl OUT NOCOPY member_out_tbl --File.Sql.39 bug 4440895

Line 306: --IF p_group_resource_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR or

302: SAVEPOINT Process_Members_Pub;
303:
304: p_return_status := FND_API.g_ret_sts_success;
305:
306: --IF p_group_resource_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR or
307: -- p_group_resource_type IS NULL THEN
308: -- NULL;
309: -- Get_Group_resource_type(p_resource_list_id,
310: -- l_group_resource_type);

Line 441: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

437: PROCEDURE Insert_Members (
438: p_resource_list_id IN NUMBER,
439: p_group_resource_type IN VARCHAR2,
440: p_resource_type_code IN VARCHAR2,
441: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
442: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
443: p_resource_alias IN VARCHAR2,
444: p_sort_order IN NUMBER,
445: p_enabled_flag IN VARCHAR2,

Line 442: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

438: p_resource_list_id IN NUMBER,
439: p_group_resource_type IN VARCHAR2,
440: p_resource_type_code IN VARCHAR2,
441: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
442: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
443: p_resource_alias IN VARCHAR2,
444: p_sort_order IN NUMBER,
445: p_enabled_flag IN VARCHAR2,
446: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 446: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

442: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
443: p_resource_alias IN VARCHAR2,
444: p_sort_order IN NUMBER,
445: p_enabled_flag IN VARCHAR2,
446: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
447: p_job_group_id IN NUMBER, --Added for bug 2486405.
448: p_parent_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
449: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
450: p_track_as_labor_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 486: (p_resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN

482: BEGIN
483: p_return_status := FND_API.g_ret_sts_success;
484:
485: IF ((p_resource_alias IS NULL ) OR
486: (p_resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN
487: FND_MESSAGE.SET_NAME('PA','PA_NEW_ALIAS_IS_INVALID ');
488: FND_MSG_PUB.ADD;
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;

Line 539: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

535: ELSIF
536: p_group_resource_type = 'ORGANIZATION'
537: THEN
538: IF (p_resource_group_alias IS NULL OR
539: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
540: l_resource_group_name := p_resource_group_name;
541: ELSE
542: l_resource_group_name := p_resource_group_name;
543: END IF;

Line 697: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

693:
694:
695: PROCEDURE Load_Resource_List
696: ( p_api_version_number IN NUMBER,
697: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
698: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
699: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 698: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

694:
695: PROCEDURE Load_Resource_List
696: ( p_api_version_number IN NUMBER,
697: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
698: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
699: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
702: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 699: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

695: PROCEDURE Load_Resource_List
696: ( p_api_version_number IN NUMBER,
697: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
698: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
699: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
702: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
703: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

696: ( p_api_version_number IN NUMBER,
697: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
698: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
699: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
702: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
703: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
704: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Added for bug 2486405.

Line 701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

697: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
698: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
699: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
702: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
703: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
704: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Added for bug 2486405.
705: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 702: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

698: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
699: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
702: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
703: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
704: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Added for bug 2486405.
705: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
706: )

Line 703: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

699: p_group_resource_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
702: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
703: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
704: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Added for bug 2486405.
705: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
706: )
707: IS

Line 704: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Added for bug 2486405.

700: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
701: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
702: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
703: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
704: p_job_group_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Added for bug 2486405.
705: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
706: )
707: IS
708:

Line 772: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

768:
769:
770: PROCEDURE Load_Members
771: ( p_api_version_number IN NUMBER,
772: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
773: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
774: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 773: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

769:
770: PROCEDURE Load_Members
771: ( p_api_version_number IN NUMBER,
772: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
773: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
774: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 774: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

770: PROCEDURE Load_Members
771: ( p_api_version_number IN NUMBER,
772: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
773: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
774: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
778: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

771: ( p_api_version_number IN NUMBER,
772: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
773: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
774: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
778: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
779: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

772: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
773: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
774: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
778: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
779: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
780: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

773: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
774: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
778: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
779: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
780: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
781: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 778: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

774: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
778: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
779: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
780: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
781: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
782: )

Line 779: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

775: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
778: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
779: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
780: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
781: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
782: )
783: IS

Line 780: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

776: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
777: p_resource_list_member_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
778: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
779: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
780: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
781: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
782: )
783: IS
784:

Line 807: IF (p_sort_order = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

803: -- VALUE LAYER ---------------------------------------------------------------
804:
805: -- Default Sort Order if Parameter NOT Passed
806:
807: IF (p_sort_order = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
808: l_sort_order := NULL;
809: ELSE
810: l_sort_order := p_sort_order;
811: END IF;

Line 816: IF (p_enabled_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

812:
813:
814: -- Default Enabled Flag if Parameter NOT Passed
815:
816: IF (p_enabled_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
817: l_enabled_flag := 'Y';
818: ELSE
819: l_enabled_flag := p_enabled_flag;
820: END IF;

Line 1032: p_member_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

1028:
1029: PROCEDURE Fetch_Members
1030: ( p_api_version_number IN NUMBER,
1031: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1032: p_member_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1033: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1034: p_member_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1035: IS
1036:

Line 1054: IF p_member_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: END IF;
1052: -- Check Line index value
1053:
1054: IF p_member_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1055: l_index := 1;
1056: ELSE
1057: l_index := p_member_index ;
1058: END IF;

Line 1138: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

1134: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1135: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1136: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1137: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1138: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1139: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1140: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1141: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1142: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 1139: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

1135: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1136: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1137: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1138: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1139: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1140: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1141: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1142: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1143: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 1140: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

1136: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1137: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1138: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1139: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1140: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1141: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1142: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1143: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1144: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 1141: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

1137: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1138: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1139: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1140: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1141: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1142: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1143: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1144: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1145: p_member_tbl IN member_tbl,

Line 1142: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

1138: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1139: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1140: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1141: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1142: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1143: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1144: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1145: p_member_tbl IN member_tbl,
1146: p_member_out_tbl OUT NOCOPY member_out_tbl --File.Sql.39 bug 4440895

Line 1143: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

1139: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1140: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1141: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1142: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1143: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1144: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1145: p_member_tbl IN member_tbl,
1146: p_member_out_tbl OUT NOCOPY member_out_tbl --File.Sql.39 bug 4440895
1147: )

Line 1144: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

1140: p_new_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1141: p_grouped_by_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1142: p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1143: p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1144: p_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
1145: p_member_tbl IN member_tbl,
1146: p_member_out_tbl OUT NOCOPY member_out_tbl --File.Sql.39 bug 4440895
1147: )
1148: IS

Line 1317: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)) THEN

1313: -- updated at all.
1314: -- The end date can be null.
1315: -- If a start date and end date are passed, then the start date must be not be later than the end date.
1316:
1317: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)) THEN
1318: IF (p_start_date IS NULL) THEN
1319: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1320: THEN
1321: FND_MESSAGE.SET_NAME('PA','PA_INVALID_START_DATE');

Line 1325: ELSIF ((p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1321: FND_MESSAGE.SET_NAME('PA','PA_INVALID_START_DATE');
1322: FND_MSG_PUB.ADD;
1323: END IF;
1324: RAISE FND_API.G_EXC_ERROR;
1325: ELSIF ((p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1326: AND (p_end_date IS NOT NULL)) THEN
1327: IF (p_start_date > p_end_date)
1328: THEN
1329: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1355: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1351: END IF;
1352:
1353: -- New List Name Must NOT Already Exist
1354:
1355: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1356: OPEN l_new_list_name_csr (p_new_list_name);
1357: FETCH l_new_list_name_csr INTO l_dummy;
1358: IF (l_new_list_name_csr %FOUND) THEN
1359: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1373: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1369: END IF;
1370:
1371: -- Cannot Change Grouped-By-Type if List Already has Members
1372:
1373: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1374: OPEN l_grouped_by_type_csr ( l_resource_list_id);
1375: FETCH l_grouped_by_type_csr INTO l_dummy;
1376: IF (l_grouped_by_type_csr%FOUND) THEN
1377: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1392: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1388:
1389:
1390: -- Get Grouped_By_Type Resource_Type_Id
1391:
1392: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1393: IF (p_grouped_by_type = 'NONE') THEN
1394: l_resource_type_id := 0;
1395: ELSE
1396: OPEN l_resource_type_csr (p_grouped_by_type);

Line 1423: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1419:
1420:
1421: -- Validate Date IN Parameters Against Existing Resource List Row
1422:
1423: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1424: OR (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1425: THEN
1426: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
1427: (l_end_date_active_old IS NOT NULL))

Line 1424: OR (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))

1420:
1421: -- Validate Date IN Parameters Against Existing Resource List Row
1422:
1423: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1424: OR (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1425: THEN
1426: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
1427: (l_end_date_active_old IS NOT NULL))
1428: THEN

Line 1426: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND

1422:
1423: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1424: OR (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1425: THEN
1426: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) AND
1427: (l_end_date_active_old IS NOT NULL))
1428: THEN
1429: IF (p_start_date > l_end_date_active_old)
1430: THEN

Line 1440: IF (p_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438: END IF;
1439:
1440: IF (p_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1441: THEN
1442: IF ((p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1443: AND (p_end_date IS NOT NULL))
1444: THEN

Line 1442: IF ((p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1438: END IF;
1439:
1440: IF (p_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1441: THEN
1442: IF ((p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1443: AND (p_end_date IS NOT NULL))
1444: THEN
1445: IF (l_start_date_active_old > p_end_date)
1446: THEN

Line 1466: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1462: l_statement := 'UPDATE PA_RESOURCE_LISTS SET ';
1463:
1464: --Changes done for SQL BIND VARIABLE by xin liu. 13-May-2003
1465:
1466: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1467: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1468: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1469: THEN
1470: l_statement := l_statement || 'NAME = :xName'||',';

Line 1467: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

1463:
1464: --Changes done for SQL BIND VARIABLE by xin liu. 13-May-2003
1465:
1466: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1467: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1468: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1469: THEN
1470: l_statement := l_statement || 'NAME = :xName'||',';
1471: l_update_header_flag := 'Y';

Line 1468: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

1464: --Changes done for SQL BIND VARIABLE by xin liu. 13-May-2003
1465:
1466: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1467: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1468: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1469: THEN
1470: l_statement := l_statement || 'NAME = :xName'||',';
1471: l_update_header_flag := 'Y';
1472: END IF;

Line 1474: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1470: l_statement := l_statement || 'NAME = :xName'||',';
1471: l_update_header_flag := 'Y';
1472: END IF;
1473:
1474: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1475: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>
1476: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1477: THEN
1478: l_statement := l_statement || 'GROUP_RESOURCE_TYPE_ID = :xGRTID'||',';

Line 1475: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>

1471: l_update_header_flag := 'Y';
1472: END IF;
1473:
1474: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1475: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>
1476: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1477: THEN
1478: l_statement := l_statement || 'GROUP_RESOURCE_TYPE_ID = :xGRTID'||',';
1479: l_update_header_flag := 'Y';

Line 1476: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

1472: END IF;
1473:
1474: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1475: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>
1476: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1477: THEN
1478: l_statement := l_statement || 'GROUP_RESOURCE_TYPE_ID = :xGRTID'||',';
1479: l_update_header_flag := 'Y';
1480: END IF;

Line 1482: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1478: l_statement := l_statement || 'GROUP_RESOURCE_TYPE_ID = :xGRTID'||',';
1479: l_update_header_flag := 'Y';
1480: END IF;
1481:
1482: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1483: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1484: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1485: THEN
1486: l_statement := l_statement || 'DESCRIPTION =:xDescription' ||',';

Line 1483: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

1479: l_update_header_flag := 'Y';
1480: END IF;
1481:
1482: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1483: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1484: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1485: THEN
1486: l_statement := l_statement || 'DESCRIPTION =:xDescription' ||',';
1487: l_update_header_flag := 'Y';

Line 1484: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

1480: END IF;
1481:
1482: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1483: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1484: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1485: THEN
1486: l_statement := l_statement || 'DESCRIPTION =:xDescription' ||',';
1487: l_update_header_flag := 'Y';
1488: END IF;

Line 1490: IF (p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1486: l_statement := l_statement || 'DESCRIPTION =:xDescription' ||',';
1487: l_update_header_flag := 'Y';
1488: END IF;
1489:
1490: IF (p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1491: AND (nvl(p_start_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <> nvl(l_start_date_active_old,
1492: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1493: THEN
1494: l_statement := l_statement || 'START_DATE_ACTIVE = '||''''||TO_CHAR(p_start_date)||''''||',';

Line 1491: AND (nvl(p_start_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <> nvl(l_start_date_active_old,

1487: l_update_header_flag := 'Y';
1488: END IF;
1489:
1490: IF (p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1491: AND (nvl(p_start_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <> nvl(l_start_date_active_old,
1492: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1493: THEN
1494: l_statement := l_statement || 'START_DATE_ACTIVE = '||''''||TO_CHAR(p_start_date)||''''||',';
1495: l_update_header_flag := 'Y';

Line 1492: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))

1488: END IF;
1489:
1490: IF (p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1491: AND (nvl(p_start_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <> nvl(l_start_date_active_old,
1492: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1493: THEN
1494: l_statement := l_statement || 'START_DATE_ACTIVE = '||''''||TO_CHAR(p_start_date)||''''||',';
1495: l_update_header_flag := 'Y';
1496: END IF;

Line 1498: IF (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1494: l_statement := l_statement || 'START_DATE_ACTIVE = '||''''||TO_CHAR(p_start_date)||''''||',';
1495: l_update_header_flag := 'Y';
1496: END IF;
1497:
1498: IF (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1499: AND (nvl(p_end_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <> nvl(l_end_date_active_old,
1500: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1501: THEN
1502: l_statement := l_statement || 'END_DATE_ACTIVE = '||''''||TO_CHAR(p_end_date)||''''||',';

Line 1499: AND (nvl(p_end_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <> nvl(l_end_date_active_old,

1495: l_update_header_flag := 'Y';
1496: END IF;
1497:
1498: IF (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1499: AND (nvl(p_end_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <> nvl(l_end_date_active_old,
1500: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1501: THEN
1502: l_statement := l_statement || 'END_DATE_ACTIVE = '||''''||TO_CHAR(p_end_date)||''''||',';
1503: l_update_header_flag := 'Y';

Line 1500: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))

1496: END IF;
1497:
1498: IF (p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1499: AND (nvl(p_end_date, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) <> nvl(l_end_date_active_old,
1500: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE))
1501: THEN
1502: l_statement := l_statement || 'END_DATE_ACTIVE = '||''''||TO_CHAR(p_end_date)||''''||',';
1503: l_update_header_flag := 'Y';
1504: END IF;

Line 1527: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1523:
1524: l_cursor := dbms_sql.open_cursor;
1525: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
1526:
1527: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1528: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1529: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1530: THEN
1531: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xName',p_new_list_name );

Line 1528: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

1524: l_cursor := dbms_sql.open_cursor;
1525: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
1526:
1527: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1528: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1529: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1530: THEN
1531: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xName',p_new_list_name );
1532: END IF;

Line 1529: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

1525: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
1526:
1527: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1528: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1529: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1530: THEN
1531: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xName',p_new_list_name );
1532: END IF;
1533:

Line 1534: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1530: THEN
1531: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xName',p_new_list_name );
1532: END IF;
1533:
1534: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1535: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>
1536: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1537: THEN
1538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xGRTID',l_resource_type_id );

Line 1535: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>

1531: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xName',p_new_list_name );
1532: END IF;
1533:
1534: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1535: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>
1536: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1537: THEN
1538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xGRTID',l_resource_type_id );
1539: END IF;

Line 1536: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

1532: END IF;
1533:
1534: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1535: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>
1536: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1537: THEN
1538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xGRTID',l_resource_type_id );
1539: END IF;
1540:

Line 1541: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1537: THEN
1538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xGRTID',l_resource_type_id );
1539: END IF;
1540:
1541: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1542: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1543: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1544: THEN
1545: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xDescription', p_description);

Line 1542: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

1538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xGRTID',l_resource_type_id );
1539: END IF;
1540:
1541: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1542: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1543: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1544: THEN
1545: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xDescription', p_description);
1546:

Line 1543: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

1539: END IF;
1540:
1541: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1542: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1543: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1544: THEN
1545: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xDescription', p_description);
1546:
1547: END IF;

Line 1563: IF (p_member_tbl(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1559: FOR I IN 1..p_member_tbl.COUNT LOOP
1560:
1561: p_member_out_tbl(i).return_status := FND_API.G_RET_STS_SUCCESS;
1562:
1563: IF (p_member_tbl(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: AND (p_member_tbl(i).resource_list_member_id IS NOT NULL) THEN
1565:
1566: -- Validate Passed Resource_List_Member_id
1567:

Line 1879: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

1875: PROCEDURE Delete_Resource_list
1876: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
1877: p_api_version_number IN NUMBER,
1878: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1879: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1880: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1881: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1882: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1883: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1880: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

1876: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
1877: p_api_version_number IN NUMBER,
1878: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1879: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1880: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1881: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1882: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1883: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1884: x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2145: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2141: PROCEDURE Add_Resource_List_Member
2142: (p_commit IN VARCHAR2 := FND_API.G_FALSE,
2143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2144: p_api_version_number IN NUMBER,
2145: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2146: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2147: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2148: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 2146: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2142: (p_commit IN VARCHAR2 := FND_API.G_FALSE,
2143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2144: p_api_version_number IN NUMBER,
2145: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2146: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2147: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2148: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2150: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 2147: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2144: p_api_version_number IN NUMBER,
2145: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2146: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2147: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2148: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2150: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2151: p_resource_alias IN VARCHAR2 ,

Line 2148: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2144: p_api_version_number IN NUMBER,
2145: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2146: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2147: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2148: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2150: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2151: p_resource_alias IN VARCHAR2 ,
2152: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2145: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2146: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2147: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2148: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2150: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2151: p_resource_alias IN VARCHAR2 ,
2152: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2153: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 2150: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2146: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2147: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2148: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2150: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2151: p_resource_alias IN VARCHAR2 ,
2152: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2153: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2154: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2152: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2148: p_resource_group_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2150: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2151: p_resource_alias IN VARCHAR2 ,
2152: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2153: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2154: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2155: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2156: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2153: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2149: p_resource_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2150: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2151: p_resource_alias IN VARCHAR2 ,
2152: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2153: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2154: p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2155: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2156: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2157: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2259: IF p_resource_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2256: END IF;
2257:
2258:
2259: IF p_resource_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2260: p_resource_list_member_id := NULL;
2261: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2262: THEN
2263: FND_MESSAGE.SET_NAME('PA','PA_RL_RES_TYPE_CODE_REQD');

Line 2269: IF p_resource_attr_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2265: END IF;
2266: RAISE FND_API.G_EXC_ERROR;
2267: END IF;
2268:
2269: IF p_resource_attr_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2270: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2271: THEN
2272: IF p_resource_type_code = 'EMPLOYEE' THEN
2273: FND_MESSAGE.SET_NAME('PA', 'PA_NO_PERSON_ID');

Line 2331: (p_resource_group_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

2327: CLOSE l_resource_list_csr;
2328: END IF;
2329:
2330: IF l_group_resource_type_id <> 0 AND
2331: (p_resource_group_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
2332: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
2333: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2334: THEN
2335: FND_MESSAGE.SET_NAME('PA', 'PA_RL_GROUPED');

Line 2332: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

2328: END IF;
2329:
2330: IF l_group_resource_type_id <> 0 AND
2331: (p_resource_group_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
2332: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
2333: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2334: THEN
2335: FND_MESSAGE.SET_NAME('PA', 'PA_RL_GROUPED');
2336: FND_MSG_PUB.ADD;

Line 2341: IF (p_sort_order = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

2337: END IF;
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340:
2341: IF (p_sort_order = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
2342: l_sort_order := NULL;
2343: ELSE
2344: l_sort_order := p_sort_order;
2345: END IF;

Line 2347: IF (p_enabled_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

2343: ELSE
2344: l_sort_order := p_sort_order;
2345: END IF;
2346:
2347: IF (p_enabled_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
2348: l_enabled_flag := 'Y';
2349: ELSE
2350: l_enabled_flag := p_enabled_flag;
2351: END IF;

Line 2358: IF p_resource_group_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2354: l_resource_group_name := p_resource_group_name;
2355: l_resource_group_alias := p_resource_group_alias;
2356:
2357: IF l_group_resource_type_id <> 0 THEN
2358: IF p_resource_group_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2359: l_resource_group_name := p_resource_group_alias;
2360: ELSIF
2361: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2362: l_resource_group_alias := SUBSTR(p_resource_group_name,1,30);

Line 2361: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2357: IF l_group_resource_type_id <> 0 THEN
2358: IF p_resource_group_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2359: l_resource_group_name := p_resource_group_alias;
2360: ELSIF
2361: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2362: l_resource_group_alias := SUBSTR(p_resource_group_name,1,30);
2363: END IF;
2364: END IF;
2365:

Line 2493: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2489: PROCEDURE Update_Resource_List_Member
2490: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
2491: p_api_version_number IN NUMBER,
2492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2493: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2494: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2495: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2496: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2497: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 2494: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2490: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
2491: p_api_version_number IN NUMBER,
2492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2493: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2494: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2495: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2496: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2497: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2498: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2495: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2491: p_api_version_number IN NUMBER,
2492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2493: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2494: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2495: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2496: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2497: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2498: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2499: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 2496: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2493: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2494: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2495: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2496: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2497: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2498: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2499: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2500: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2497: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2493: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2494: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2495: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2496: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2497: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2498: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2499: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2500: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2501: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2498: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2494: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2495: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2496: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2497: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2498: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2499: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2500: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2501: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2502: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2499: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2495: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2496: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2497: p_new_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2498: p_sort_order IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2499: p_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2500: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2501: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2502: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2503: )

Line 2703: IF (p_enabled_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

2699:
2700: -- Check Proper Values Passed for P_ENABLED_FLAG.
2701: -- Default Value to 'Y' if NOT Passed at All.
2702:
2703: IF (p_enabled_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
2704: l_enabled_flag_new := 'Y';
2705: ELSE
2706: IF (p_enabled_flag IN ('Y', 'N')) THEN
2707: l_enabled_flag_new := p_enabled_flag;

Line 2723: IF (p_new_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

2719: --
2720: -- If a resource list is not grouped, then the new alias must be unique accross the list.
2721: -- Otherwise, a new alias must be unique within the group of the original alias.
2722:
2723: IF (p_new_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
2724:
2725: OPEN l_group_resource_type_csr (l_resource_list_id);
2726: FETCH l_group_resource_type_csr INTO l_group_resource_type_id;
2727: CLOSE l_group_resource_type_csr;

Line 2786: IF (p_new_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

2782:
2783: l_update_member_flag := 'N';
2784: l_statement := 'UPDATE PA_RESOURCE_LIST_MEMBERS SET ';
2785:
2786: IF (p_new_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2787: AND (NVL(p_new_alias, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> NVL(l_alias_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
2788: THEN
2789: l_statement := l_statement || 'ALIAS = '||''''||p_new_alias||''''||',';
2790: l_update_member_flag := 'Y';

Line 2787: AND (NVL(p_new_alias, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> NVL(l_alias_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

2783: l_update_member_flag := 'N';
2784: l_statement := 'UPDATE PA_RESOURCE_LIST_MEMBERS SET ';
2785:
2786: IF (p_new_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2787: AND (NVL(p_new_alias, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> NVL(l_alias_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
2788: THEN
2789: l_statement := l_statement || 'ALIAS = '||''''||p_new_alias||''''||',';
2790: l_update_member_flag := 'Y';
2791: END IF;

Line 2793: IF (p_sort_order <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

2789: l_statement := l_statement || 'ALIAS = '||''''||p_new_alias||''''||',';
2790: l_update_member_flag := 'Y';
2791: END IF;
2792:
2793: IF (p_sort_order <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2794: AND (NVL(p_sort_order, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <> NVL(l_sort_order_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
2795: THEN
2796: l_statement := l_statement || 'SORT_ORDER = '||''''||p_sort_order||''''||',';
2797: l_update_member_flag := 'Y';

Line 2794: AND (NVL(p_sort_order, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <> NVL(l_sort_order_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

2790: l_update_member_flag := 'Y';
2791: END IF;
2792:
2793: IF (p_sort_order <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
2794: AND (NVL(p_sort_order, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <> NVL(l_sort_order_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
2795: THEN
2796: l_statement := l_statement || 'SORT_ORDER = '||''''||p_sort_order||''''||',';
2797: l_update_member_flag := 'Y';
2798: END IF;

Line 2800: IF (l_enabled_flag_new <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

2796: l_statement := l_statement || 'SORT_ORDER = '||''''||p_sort_order||''''||',';
2797: l_update_member_flag := 'Y';
2798: END IF;
2799:
2800: IF (l_enabled_flag_new <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2801: AND (NVL(l_enabled_flag_new, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> NVL(l_enabled_flag_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
2802: THEN
2803: l_statement := l_statement || 'ENABLED_FLAG = '||''''|| l_enabled_flag_new ||''''||',';
2804: l_update_member_flag := 'Y';

Line 2801: AND (NVL(l_enabled_flag_new, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> NVL(l_enabled_flag_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

2797: l_update_member_flag := 'Y';
2798: END IF;
2799:
2800: IF (l_enabled_flag_new <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
2801: AND (NVL(l_enabled_flag_new, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> NVL(l_enabled_flag_old, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
2802: THEN
2803: l_statement := l_statement || 'ENABLED_FLAG = '||''''|| l_enabled_flag_new ||''''||',';
2804: l_update_member_flag := 'Y';
2805: END IF;

Line 2909: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2905: PROCEDURE Delete_Resource_list_Member
2906: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
2907: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2908: p_api_version_number IN NUMBER,
2909: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2910: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2911: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2912: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2913: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2910: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2906: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
2907: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2908: p_api_version_number IN NUMBER,
2909: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2910: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2911: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2912: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2913: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2914: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2911: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

2907: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2908: p_api_version_number IN NUMBER,
2909: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2910: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2911: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2912: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2913: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2914: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2915: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2912: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

2908: p_api_version_number IN NUMBER,
2909: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2910: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2911: p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
2912: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2913: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2914: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2915: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2916: x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3200: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

3196: PROCEDURE Sort_Resource_List_Members
3197: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
3198: p_api_version_number IN NUMBER,
3199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3200: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3201: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3202: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3203: p_sort_by IN VARCHAR2,
3204: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3201: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

3197: ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
3198: p_api_version_number IN NUMBER,
3199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3200: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3201: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3202: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3203: p_sort_by IN VARCHAR2,
3204: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3205: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3202: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

3198: p_api_version_number IN NUMBER,
3199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3200: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3201: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3202: p_resource_group_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3203: p_sort_by IN VARCHAR2,
3204: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3205: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3206: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3361: IF (p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3357: RAISE FND_API.G_EXC_ERROR;
3358: END IF;
3359:
3360: -- Default Group Alias to Local Variable
3361: IF (p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3362: l_resource_group_alias := NULL;
3363: ELSE
3364: l_resource_group_alias := p_resource_group_alias;
3365: END IF;

Line 3597: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

3593:
3594:
3595: PROCEDURE Convert_List_Name_To_Id
3596: (
3597: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3598: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3599: p_out_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3600: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3601: )

Line 3598: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

3594:
3595: PROCEDURE Convert_List_Name_To_Id
3596: (
3597: p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3598: p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3599: p_out_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3600: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3601: )
3602:

Line 3619: IF p_resource_list_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

3615:
3616: BEGIN
3617: p_return_status := FND_API.G_RET_STS_SUCCESS;
3618:
3619: IF p_resource_list_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3620: -- Validate Passed Resource_List_Id
3621:
3622: OPEN l_resource_list_csr (p_resource_list_id);
3623: FETCH l_resource_list_csr INTO l_dummy;

Line 3640: ELSIF --(i.e p_resource_list_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

3636: p_out_resource_list_id := p_resource_list_id;
3637: END IF;
3638:
3639:
3640: ELSIF --(i.e p_resource_list_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
3641: p_resource_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3642:
3643: l_resource_list_id :=
3644: Fetch_Resource_list_id

Line 3641: p_resource_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

3637: END IF;
3638:
3639:
3640: ELSIF --(i.e p_resource_list_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
3641: p_resource_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3642:
3643: l_resource_list_id :=
3644: Fetch_Resource_list_id
3645: (p_resource_list_name => p_resource_list_name );

Line 3659: END IF; -- If p_resource_list_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3655: ELSE
3656: p_out_resource_list_id := l_resource_list_id;
3657: END IF;
3658:
3659: END IF; -- If p_resource_list_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3660:
3661: EXCEPTION
3662:
3663: WHEN FND_API.G_EXC_ERROR THEN

Line 3762: p_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

3758:
3759: PROCEDURE Convert_Alias_To_Id
3760: (
3761: p_resource_list_id IN NUMBER,
3762: p_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3763: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3764: p_project_id IN NUMBER DEFAULT NULL,
3765: p_out_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3766: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3763: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

3759: PROCEDURE Convert_Alias_To_Id
3760: (
3761: p_resource_list_id IN NUMBER,
3762: p_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3763: p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3764: p_project_id IN NUMBER DEFAULT NULL,
3765: p_out_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3766: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3767: )

Line 3811: IF (p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

3807: l_object_id := p_project_id;
3808: END IF;
3809: END IF;
3810:
3811: IF (p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3812: -- Validate Passed Resource_List_Member_Id
3813:
3814: OPEN l_resource_list_members_csr(
3815: p_resource_list_member_id => p_resource_list_member_id,

Line 3835: ELSIF (p_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3831: CLOSE l_resource_list_members_csr;
3832: p_out_resource_list_member_id := p_resource_list_member_id;
3833: END IF;
3834:
3835: ELSIF (p_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3836:
3837: -- Fetch Resource List Member Id
3838: -- old model only
3839: IF l_migration_code is NULL then

Line 3872: END IF; -- IF p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3868: ELSE
3869: p_out_resource_list_member_id := l_resource_list_member_id;
3870: END IF;
3871:
3872: END IF; -- IF p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3873:
3874: EXCEPTION
3875:
3876: WHEN FND_API.G_EXC_ERROR THEN

Line 3904: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

3900:
3901: PROCEDURE Get_Resource_Name
3902: (
3903: p_resource_type_code IN VARCHAR2,
3904: p_resource_attr_value IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
3905: p_resource_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3906: p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3907: )
3908: IS