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_TASK_ASSIGNMENTS_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 15: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

11:
12:
13:
14: PROCEDURE Create_Task_Assignment_Periods
15: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 18: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

14: PROCEDURE Create_Task_Assignment_Periods
15: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

Line 19: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

15: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
23: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

Line 20: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
23: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
24: ,x_msg_count OUT NOCOPY NUMBER

Line 21: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

17: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
23: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2

Line 327: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

323: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
324: END IF;
325:
326: IF p_pm_product_code IS NOT NULL
327: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
328:
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
330: pa_interface_utils_pub.map_new_amg_msg
331: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'

Line 330: pa_interface_utils_pub.map_new_amg_msg

326: IF p_pm_product_code IS NOT NULL
327: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
328:
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
330: pa_interface_utils_pub.map_new_amg_msg
331: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
332: ,p_msg_attribute => 'CHANGE'
333: ,p_resize_flag => 'N'
334: ,p_msg_context => 'GENERAL'

Line 362: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

358: l_module_name := 'PA_PM_ADD_TASK_ASSIGNMENT';
359:
360: --> Project Id check.
361:
362: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
363:
364: l_project_id := p_pa_project_id;
365:
366: --dbms_output.put_line('Project_id successfully passed..Check ' || l_project_id);

Line 422: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )

418: -- Function security procedure check whether user have the
419: -- privilege to add task or not
420:
421: --dbms_output.put_line('Security Initialize successful.');
422: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )
423:
424: --Get the CBS flag 16598322
425: l_cbs_enabled_project := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => l_project_id);
426:

Line 451: pa_interface_utils_pub.map_new_amg_msg

447: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
448: END IF;
449: --dbms_output.put_line('PA_PM_ADD_TASK_ASSIGNMENT function check successful.');
450: IF l_function_allowed = 'N' THEN
451: pa_interface_utils_pub.map_new_amg_msg
452: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
453: ,p_msg_attribute => 'CHANGE'
454: ,p_resize_flag => 'Y'
455: ,p_msg_context => 'GENERAL'

Line 483: pa_interface_utils_pub.map_new_amg_msg

479:
480: -- The user does not have update privileges on this project
481: -- Hence , raise error
482: --dbms_output.put_line('pa_security.allow_query or update not allowed..');
483: pa_interface_utils_pub.map_new_amg_msg
484: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
485: ,p_msg_attribute => 'CHANGE'
486: ,p_resize_flag => 'Y'
487: ,p_msg_context => 'GENERAL'

Line 507: pa_interface_utils_pub.map_new_amg_msg

503: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
505: THEN
506: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
507: pa_interface_utils_pub.map_new_amg_msg
508: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'
509: ,p_msg_attribute => 'CHANGE'
510: ,p_resize_flag => 'N'
511: ,p_msg_context => 'GENERAL'

Line 528: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

524: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
525: END IF;
526:
527: IF p_pa_structure_version_id IS NOT NULL AND
528: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
529:
530: l_struct_elem_version_id := p_pa_structure_version_id;
531:
532: ELSE

Line 543: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

539:
540: --dbms_output.put_line(' structure version: ' || l_struct_elem_version_id );
541: --Project Structures Integration
542:
543: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
544: l_struct_elem_version_id IS NULL )
545: THEN
546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
547: THEN

Line 548: pa_interface_utils_pub.map_new_amg_msg

544: l_struct_elem_version_id IS NULL )
545: THEN
546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
547: THEN
548: pa_interface_utils_pub.map_new_amg_msg
549: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
550: ,p_msg_attribute => 'CHANGE'
551: ,p_resize_flag => 'N'
552: ,p_msg_context => 'GENERAL'

Line 588: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

584: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id, l_project_id);
585: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id, l_project_currency_code;
586: CLOSE C_Get_Budget_Version_Id;
587:
588: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
589: l_budget_version_id IS NULL )
590: THEN
591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
592: THEN

Line 656: p_task_assignment_periods_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

652: l_task_elem_version_id := NULL;
653:
654: -- Bug 9544497
655: IF p_task_assignment_periods_in(i).pa_task_assignment_id is not NULL AND
656: p_task_assignment_periods_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
657: OPEN C_Res_Asgmt_Data(p_task_assignment_periods_in(i).pa_task_assignment_id );
658: FETCH C_Res_Asgmt_Data into C_Res_Asgmt_Data_Rec;
659: CLOSE C_Res_Asgmt_Data;
660:

Line 670: p_task_assignment_periods_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

666: --l_task_elem_version_id := C_Res_Asgmt_Data_Rec.wbs_element_version_id;
667:
668:
669: IF l_task_elem_version_id IS NULL AND p_task_assignment_periods_in.exists(i) AND p_task_assignment_periods_in(i).pa_task_element_version_id IS NOT NULL AND
670: p_task_assignment_periods_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
671:
672: OPEN C_task_version(p_task_assignment_periods_in(i).pa_task_element_version_id);
673: FETCH C_task_version INTO l_task_elem_version_id, l_d_task_id;
674: CLOSE C_task_version;

Line 678: p_task_assignment_periods_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

674: CLOSE C_task_version;
675:
676:
677: ELSIF l_task_elem_version_id IS NULL AND p_task_assignment_periods_in.exists(i) AND p_task_assignment_periods_in(i).pa_task_id IS NOT NULL AND
678: p_task_assignment_periods_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
679:
680: l_d_task_id := p_task_assignment_periods_in(i).pa_task_id;
681:
682: --dbms_output.put_line('l_d_task_id valid input:'|| l_d_task_id);

Line 691: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

687: END IF;
688:
689: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
690:
691: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
692: l_d_task_id IS NULL )
693: THEN
694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
695: THEN

Line 713: p_task_assignment_periods_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

709:
710:
711: ELSIF l_task_elem_version_id IS NULL AND p_task_assignment_periods_in.exists(i) AND
712: p_task_assignment_periods_in(i).pm_task_reference IS NOT NULL AND
713: p_task_assignment_periods_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
714:
715: --dbms_output.put_line('l_d_task_reference'|| p_task_assignment_periods_in(i).pm_task_reference);
716:
717:

Line 727: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

723: ,p_return_status => l_return_status);
724:
725: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
726:
727: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
728: l_d_task_id IS NULL )
729: THEN
730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
731: THEN

Line 749: l_task_elem_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

745:
746: END IF;
747:
748: IF l_task_elem_version_id is not NULL AND
749: l_task_elem_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
750:
751: --extended already.
752:
753: l_task_elem_version_id_tbl(i):= l_task_elem_version_id;

Line 772: p_task_assignment_periods_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

768:
769: --dbms_output.put_line('l_task_elem_version_id' || l_task_elem_version_id);
770:
771: IF p_task_assignment_periods_in(i).pa_task_assignment_id is NOT null AND
772: p_task_assignment_periods_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
773:
774: --dbms_output.put_line('Accepting Task Assignment Id given:' || p_task_assignment_periods_in(i).pa_task_assignment_id );
775: l_resource_assignment_id_tbl(i) := p_task_assignment_periods_in(i).pa_task_assignment_id;
776:

Line 778: p_task_assignment_periods_in(i).pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

774: --dbms_output.put_line('Accepting Task Assignment Id given:' || p_task_assignment_periods_in(i).pa_task_assignment_id );
775: l_resource_assignment_id_tbl(i) := p_task_assignment_periods_in(i).pa_task_assignment_id;
776:
777: ELSIF p_task_assignment_periods_in(i).pm_task_asgmt_reference is not null AND
778: p_task_assignment_periods_in(i).pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
779:
780: --dbms_output.put_line('Converting Task Asgmt Reference:' || p_task_assignment_periods_in(i).pm_task_asgmt_reference );
781:
782: PA_TASK_ASSIGNMENTS_PUB.Convert_PM_TARef_To_ID( p_pm_product_code => p_pm_product_code

Line 801: l_resource_assignment_id_tbl(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

797: END IF;
798:
799:
800: IF l_resource_assignment_id_tbl(i) IS NULL OR
801: l_resource_assignment_id_tbl(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
802: --new message case bug 3855080
803: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
804: THEN
805: PA_UTILS.ADD_MESSAGE

Line 831: p_task_assignment_periods_in(i).start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

827:
828: IF (
829: (
830: (p_task_assignment_periods_in(i).start_date IS NULL OR
831: p_task_assignment_periods_in(i).start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
832: )
833: OR
834: (p_task_assignment_periods_in(i).end_date IS NULL OR
835: p_task_assignment_periods_in(i).end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 835: p_task_assignment_periods_in(i).end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

831: p_task_assignment_periods_in(i).start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
832: )
833: OR
834: (p_task_assignment_periods_in(i).end_date IS NULL OR
835: p_task_assignment_periods_in(i).end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
836: )
837: )
838: AND
839: (p_task_assignment_periods_in(i).period_name IS NULL OR

Line 840: p_task_assignment_periods_in(i).period_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

836: )
837: )
838: AND
839: (p_task_assignment_periods_in(i).period_name IS NULL OR
840: p_task_assignment_periods_in(i).period_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
841: )
842: )THEN
843:
844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 909: p_task_assignment_periods_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

905: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
906: END IF;
907:
908: IF p_task_assignment_periods_in(i).resource_list_member_id IS NOT NULL AND
909: p_task_assignment_periods_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
910: OPEN get_resource_alias(p_task_assignment_periods_in(i).resource_list_member_id);
911: FETCH get_resource_alias INTO l_rlm_alias;
912: CLOSE get_resource_alias;
913: END IF;

Line 965: p_task_assignment_periods_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

961:
962: -- IF l_progress_safe <> 'N' THEN
963:
964: IF p_task_assignment_periods_in(i).resource_list_member_id IS NOT NULL AND
965: p_task_assignment_periods_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
966:
967: l_resource_list_id := PA_TASK_ASSIGNMENT_UTILS.Get_WP_Resource_List_Id(l_project_id);
968:
969: PA_PLANNING_RESOURCE_UTILS.check_list_member_on_list(

Line 994: p_task_assignment_periods_in(i).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

990: END IF;
991:
992: ELSIF p_task_assignment_periods_in(i).pa_task_assignment_id IS NULL AND
993: (p_task_assignment_periods_in(i).resource_list_member_id IS NULL OR
994: p_task_assignment_periods_in(i).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
996: THEN
997: PA_UTILS.ADD_MESSAGE
998: (p_app_short_name => 'PA',

Line 1010: p_task_assignment_periods_in(i).cbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1006:
1007: -- ADD CBS VALIDATIONS HERE 16598322
1008: IF l_cbs_enabled_project = 'Y' THEN
1009: IF p_task_assignment_periods_in(i).cbs_element_id IS NOT NULL AND
1010: p_task_assignment_periods_in(i).cbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1011:
1012: PA_ALTERNATE_TASK_PVT.Is_Cost_Element_Valid(
1013: p_Cbs_Element_Id =>p_task_assignment_periods_in(i).cbs_element_id,
1014: p_Task_Id =>l_d_task_id,

Line 1443: if p_char IS NOT NULL and p_char = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1439: FUNCTION PFCHAR(P_CHAR IN VARCHAR2 DEFAULT to_char(NULL) ) RETURN VARCHAR2 IS
1440: begin
1441:
1442:
1443: if p_char IS NOT NULL and p_char = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1444:
1445: return to_char(NULL);
1446:
1447: elsif p_char IS NOT NULL and p_char = FND_API.G_MISS_CHAR THEN

Line 1471: if p_num IS NOT NULL and p_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1467: begin
1468:
1469:
1470: --dbms_output.put_line('entered pfnum 1');
1471: if p_num IS NOT NULL and p_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1472: --dbms_output.put_line('entered pfnum 2');
1473:
1474: return to_number(NULL);
1475:

Line 1502: if p_date IS NOT NULL and p_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

1498: FUNCTION PFDATE(P_DATE IN DATE DEFAULT TO_DATE(NULL)) RETURN DATE IS
1499: begin
1500:
1501:
1502: if p_date IS NOT NULL and p_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1503:
1504: return to_date(NULL);
1505:
1506: elsif p_date IS NOT NULL and p_date = FND_API.G_MISS_DATE THEN

Line 2322: AND p_period_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2318:
2319: --1. get dates from period name
2320: IF p_period_name IS NOT NULL
2321: AND p_period_name <> FND_API.G_MISS_CHAR
2322: AND p_period_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2323:
2324: OPEN get_period_dates_from_name;
2325: FETCH get_period_dates_from_name
2326: INTO l_period_start_date, l_period_end_date, l_period_name;

Line 2332: AND p_period_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

2328:
2329: --2. get period name from dates
2330: ELSIF p_period_start_date IS NOT NULL
2331: AND p_period_start_date <> FND_API.G_MISS_DATE
2332: AND p_period_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2333:
2334: OPEN get_period_name_from_dates;
2335: FETCH get_period_name_from_dates
2336: INTO l_period_start_date, l_period_end_date, l_period_name;