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 289: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

285: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
286: END IF;
287:
288: IF p_pm_product_code IS NOT NULL
289: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
290:
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
292: pa_interface_utils_pub.map_new_amg_msg
293: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'

Line 292: pa_interface_utils_pub.map_new_amg_msg

288: IF p_pm_product_code IS NOT NULL
289: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
290:
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
292: pa_interface_utils_pub.map_new_amg_msg
293: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
294: ,p_msg_attribute => 'CHANGE'
295: ,p_resize_flag => 'N'
296: ,p_msg_context => 'GENERAL'

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

320: l_module_name := 'PA_PM_ADD_TASK_ASSIGNMENT';
321:
322: --> Project Id check.
323:
324: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
325:
326: l_project_id := p_pa_project_id;
327:
328: --dbms_output.put_line('Project_id successfully passed..Check ' || l_project_id);

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

380: -- Function security procedure check whether user have the
381: -- privilege to add task or not
382:
383: --dbms_output.put_line('Security Initialize successful.');
384: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )
385:
386: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
387: (p_api_version_number => p_api_version_number,
388: p_responsibility_id => l_resp_id,

Line 410: pa_interface_utils_pub.map_new_amg_msg

406: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
407: END IF;
408: --dbms_output.put_line('PA_PM_ADD_TASK_ASSIGNMENT function check successful.');
409: IF l_function_allowed = 'N' THEN
410: pa_interface_utils_pub.map_new_amg_msg
411: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
412: ,p_msg_attribute => 'CHANGE'
413: ,p_resize_flag => 'Y'
414: ,p_msg_context => 'GENERAL'

Line 442: pa_interface_utils_pub.map_new_amg_msg

438:
439: -- The user does not have update privileges on this project
440: -- Hence , raise error
441: --dbms_output.put_line('pa_security.allow_query or update not allowed..');
442: pa_interface_utils_pub.map_new_amg_msg
443: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
444: ,p_msg_attribute => 'CHANGE'
445: ,p_resize_flag => 'Y'
446: ,p_msg_context => 'GENERAL'

Line 466: pa_interface_utils_pub.map_new_amg_msg

462: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
464: THEN
465: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
466: pa_interface_utils_pub.map_new_amg_msg
467: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'
468: ,p_msg_attribute => 'CHANGE'
469: ,p_resize_flag => 'N'
470: ,p_msg_context => 'GENERAL'

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

483: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
484: END IF;
485:
486: IF p_pa_structure_version_id IS NOT NULL AND
487: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
488:
489: l_struct_elem_version_id := p_pa_structure_version_id;
490:
491: ELSE

Line 502: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

498:
499: --dbms_output.put_line(' structure version: ' || l_struct_elem_version_id );
500: --Project Structures Integration
501:
502: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
503: l_struct_elem_version_id IS NULL )
504: THEN
505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
506: THEN

Line 507: pa_interface_utils_pub.map_new_amg_msg

503: l_struct_elem_version_id IS NULL )
504: THEN
505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
506: THEN
507: pa_interface_utils_pub.map_new_amg_msg
508: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
509: ,p_msg_attribute => 'CHANGE'
510: ,p_resize_flag => 'N'
511: ,p_msg_context => 'GENERAL'

Line 547: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

543: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id, l_project_id);
544: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id, l_project_currency_code;
545: CLOSE C_Get_Budget_Version_Id;
546:
547: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
548: l_budget_version_id IS NULL )
549: THEN
550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
551: THEN

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

616: l_task_elem_version_id := C_Res_Asgmt_Data_Rec.wbs_element_version_id;
617:
618:
619: 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
620: p_task_assignment_periods_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
621:
622: OPEN C_task_version(p_task_assignment_periods_in(i).pa_task_element_version_id);
623: FETCH C_task_version INTO l_task_elem_version_id, l_d_task_id;
624: CLOSE C_task_version;

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

624: CLOSE C_task_version;
625:
626:
627: 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
628: p_task_assignment_periods_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
629:
630: l_d_task_id := p_task_assignment_periods_in(i).pa_task_id;
631:
632: --dbms_output.put_line('l_d_task_id valid input:'|| l_d_task_id);

Line 641: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

637: END IF;
638:
639: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
640:
641: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
642: l_d_task_id IS NULL )
643: THEN
644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
645: THEN

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

659:
660:
661: ELSIF l_task_elem_version_id IS NULL AND p_task_assignment_periods_in.exists(i) AND
662: p_task_assignment_periods_in(i).pm_task_reference IS NOT NULL AND
663: p_task_assignment_periods_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
664:
665: --dbms_output.put_line('l_d_task_reference'|| p_task_assignment_periods_in(i).pm_task_reference);
666:
667:

Line 677: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

673: ,p_return_status => l_return_status);
674:
675: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
676:
677: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
678: l_d_task_id IS NULL )
679: THEN
680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
681: THEN

Line 699: l_task_elem_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

695:
696: END IF;
697:
698: IF l_task_elem_version_id is not NULL AND
699: l_task_elem_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
700:
701: --extended already.
702:
703: l_task_elem_version_id_tbl(i):= l_task_elem_version_id;

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

718:
719: --dbms_output.put_line('l_task_elem_version_id' || l_task_elem_version_id);
720:
721: IF p_task_assignment_periods_in(i).pa_task_assignment_id is NOT null AND
722: p_task_assignment_periods_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
723:
724: --dbms_output.put_line('Accepting Task Assignment Id given:' || p_task_assignment_periods_in(i).pa_task_assignment_id );
725: l_resource_assignment_id_tbl(i) := p_task_assignment_periods_in(i).pa_task_assignment_id;
726:

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

724: --dbms_output.put_line('Accepting Task Assignment Id given:' || p_task_assignment_periods_in(i).pa_task_assignment_id );
725: l_resource_assignment_id_tbl(i) := p_task_assignment_periods_in(i).pa_task_assignment_id;
726:
727: ELSIF p_task_assignment_periods_in(i).pm_task_asgmt_reference is not null AND
728: p_task_assignment_periods_in(i).pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
729:
730: --dbms_output.put_line('Converting Task Asgmt Reference:' || p_task_assignment_periods_in(i).pm_task_asgmt_reference );
731:
732: PA_TASK_ASSIGNMENTS_PUB.Convert_PM_TARef_To_ID( p_pm_product_code => p_pm_product_code

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

746: END IF;
747:
748:
749: IF l_resource_assignment_id_tbl(i) IS NULL OR
750: l_resource_assignment_id_tbl(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
751: --new message case bug 3855080
752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
753: THEN
754: PA_UTILS.ADD_MESSAGE

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

776:
777: IF (
778: (
779: (p_task_assignment_periods_in(i).start_date IS NULL OR
780: p_task_assignment_periods_in(i).start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
781: )
782: OR
783: (p_task_assignment_periods_in(i).end_date IS NULL OR
784: p_task_assignment_periods_in(i).end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

780: p_task_assignment_periods_in(i).start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
781: )
782: OR
783: (p_task_assignment_periods_in(i).end_date IS NULL OR
784: p_task_assignment_periods_in(i).end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
785: )
786: )
787: AND
788: (p_task_assignment_periods_in(i).period_name IS NULL OR

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

785: )
786: )
787: AND
788: (p_task_assignment_periods_in(i).period_name IS NULL OR
789: p_task_assignment_periods_in(i).period_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790: )
791: )THEN
792:
793: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

869:
870: IF l_progress_safe <> 'N' THEN
871:
872: IF p_task_assignment_periods_in(i).resource_list_member_id IS NOT NULL AND
873: p_task_assignment_periods_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
874:
875: l_resource_list_id := PA_TASK_ASSIGNMENT_UTILS.Get_WP_Resource_List_Id(l_project_id);
876:
877: PA_PLANNING_RESOURCE_UTILS.check_list_member_on_list(

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

898: END IF;
899:
900: ELSIF p_task_assignment_periods_in(i).pa_task_assignment_id IS NULL AND
901: (p_task_assignment_periods_in(i).resource_list_member_id IS NULL OR
902: p_task_assignment_periods_in(i).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
904: THEN
905: PA_UTILS.ADD_MESSAGE
906: (p_app_short_name => 'PA',

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

1226: FUNCTION PFCHAR(P_CHAR IN VARCHAR2 DEFAULT to_char(NULL) ) RETURN VARCHAR2 IS
1227: begin
1228:
1229:
1230: if p_char IS NOT NULL and p_char = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1231:
1232: return to_char(NULL);
1233:
1234: elsif p_char IS NOT NULL and p_char = FND_API.G_MISS_CHAR THEN

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

1254: begin
1255:
1256:
1257: --dbms_output.put_line('entered pfnum 1');
1258: if p_num IS NOT NULL and p_num = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1259: --dbms_output.put_line('entered pfnum 2');
1260:
1261: return to_number(NULL);
1262:

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

1285: FUNCTION PFDATE(P_DATE IN DATE DEFAULT TO_DATE(NULL)) RETURN DATE IS
1286: begin
1287:
1288:
1289: if p_date IS NOT NULL and p_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1290:
1291: return to_date(NULL);
1292:
1293: elsif p_date IS NOT NULL and p_date = FND_API.G_MISS_DATE THEN

Line 2082: AND p_period_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2078:
2079: --1. get dates from period name
2080: IF p_period_name IS NOT NULL
2081: AND p_period_name <> FND_API.G_MISS_CHAR
2082: AND p_period_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2083:
2084: OPEN get_period_dates_from_name;
2085: FETCH get_period_dates_from_name
2086: INTO l_period_start_date, l_period_end_date, l_period_name;

Line 2092: AND p_period_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

2088:
2089: --2. get period name from dates
2090: ELSIF p_period_start_date IS NOT NULL
2091: AND p_period_start_date <> FND_API.G_MISS_DATE
2092: AND p_period_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2093:
2094: OPEN get_period_name_from_dates;
2095: FETCH get_period_name_from_dates
2096: INTO l_period_start_date, l_period_end_date, l_period_name;