DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJECT_STRUCTURE_PUB1

Line 7605: -- PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

7601:
7602: --Commented by hsiu
7603: -- IF (l_dest_template_flag = 'Y' AND l_structure_type = 'WORKPLAN') THEN
7604: --Create new structure
7605: -- PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
7606: -- ( p_validate_only => FND_API.G_FALSE
7607: -- ,p_project_id => p_dest_project_id
7608: -- ,p_structure_number => l_name
7609: -- ,p_structure_name => l_name

Line 7703: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

7699: -- ELSE
7700: --copy from
7701: --end commented code by hsiu
7702:
7703: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
7704: ( p_validate_only => FND_API.G_FALSE
7705: ,p_project_id => p_dest_project_id
7706: ,p_structure_number => l_name
7707: ,p_structure_name => l_name

Line 8680: PA_PROJECT_STRUCTURE_PUB1.create_structure_Version(

8676: delete from pa_proj_elem_ver_schedule
8677: where project_id = p_project_id;
8678:
8679: --create_structure_version
8680: PA_PROJECT_STRUCTURE_PUB1.create_structure_Version(
8681: p_structure_id => l_struc_id,
8682: x_structure_version_id => l_struc_ver_id,
8683: x_return_status => l_ret_stat,
8684: x_msg_count => l_msg_count,

Line 8701: PA_PROJECT_STRUCTURE_PUB1.create_structure_version_attr(

8697: RAISE FND_API.G_EXC_ERROR;
8698: END IF;
8699:
8700: --create_structure_version_attr
8701: PA_PROJECT_STRUCTURE_PUB1.create_structure_version_attr(
8702: p_structure_version_id => l_struc_ver_id,
8703: p_structure_version_name => p_structure_name,
8704: p_structure_version_desc => p_description,
8705: x_return_status => l_ret_stat,

Line 9734: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

9730: and lookup_code = 'WORKPLAN';
9731:
9732: l_name := substrb(l_name||l_append||l_suffix, 1, 240);
9733: --Create new structure
9734: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
9735: ( p_validate_only => FND_API.G_FALSE
9736: ,p_project_id => p_project_id
9737: ,p_structure_number => l_name
9738: ,p_structure_name => l_name

Line 9905: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

9901: END IF;
9902: END LOOP;
9903: CLOSE get_top_tasks;
9904:
9905: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
9906: PA_PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_Wo_Val(
9907: p_structure_version_id => l_del_struc_ver_id
9908: ,p_record_version_number => l_struc_ver_rvn
9909: ,x_return_status => l_return_status

Line 10065: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

10061: END IF;
10062: END LOOP;
10063: CLOSE get_top_tasks;
10064:
10065: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
10066: PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL(
10067: p_structure_version_id => l_del_struc_ver_id
10068: ,p_record_version_number => l_struc_ver_rvn
10069: ,x_return_status => l_return_status

Line 10176: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

10172: END IF;
10173: END LOOP;
10174: CLOSE get_top_tasks;
10175:
10176: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
10177: PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL(
10178: p_structure_version_id => l_del_struc_ver_id
10179: ,p_record_version_number => l_struc_ver_rvn
10180: ,x_return_status => l_return_status

Line 10597: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

10593: END IF;
10594: END LOOP;
10595: CLOSE get_top_tasks;
10596:
10597: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
10598: PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL(
10599: p_structure_version_id => l_del_struc_ver_id
10600: ,p_record_version_number => l_struc_ver_rvn
10601: ,x_return_status => l_return_status

Line 11179: PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

11175: LOOP
11176: FETCH sel_other_structure_ver into l_del_struc_ver_id,
11177: l_struc_ver_rvn;
11178: EXIT WHEN sel_other_structure_ver%NOTFOUND;
11179: PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
11180: p_structure_version_id => l_del_struc_ver_id
11181: ,p_record_version_number => l_struc_ver_rvn
11182: ,p_calling_from => 'DEL_WP_STRUC_DISABLE_VERSION' ---Added for bug 6023347
11183: ,x_return_status => l_return_status

Line 14276: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14272: NULL;
14273: ELSIF (p_workplan_enabled_flag = 'N' and p_financial_enabled_flag = 'Y') THEN
14274: --disable workplan (enable financial)
14275: --create financial structure API
14276: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14277: (p_validate_only => FND_API.G_FALSE
14278: ,p_project_id => p_project_id
14279: ,p_structure_number => l_name
14280: ,p_structure_name => l_name

Line 14298: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE

14294: RAISE FND_API.G_EXC_ERROR;
14295: END IF;
14296:
14297: --create row in pa_proj_workplan_attr
14298: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
14299: (p_validate_only => FND_API.G_FALSE
14300: ,p_project_id => p_project_id
14301: ,p_proj_element_id => l_structure_id
14302: ,x_return_status => l_return_status

Line 14377: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14373:
14374: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'N') THEN
14375: --disable financial (enable workplan)
14376: --create workplan structure
14377: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14378: (p_validate_only => FND_API.G_FALSE
14379: ,p_project_id => p_project_id
14380: ,p_structure_number => l_wp_name
14381: ,p_structure_name => l_wp_name

Line 14477: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14473:
14474: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SHARE_PARTIAL', 'SHARE_FULL')) THEN
14475: --partial share/full share
14476: --enable workplan structure API
14477: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14478: (p_validate_only => FND_API.G_FALSE
14479: ,p_project_id => p_project_id
14480: ,p_structure_number => l_name
14481: ,p_structure_name => l_name

Line 14638: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14634:
14635: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SPLIT_MAPPING','SPLIT_NO_MAPPING')) THEN
14636: --split mapping/split no mapping
14637: --enable financial structure API
14638: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14639: (p_validate_only => FND_API.G_FALSE
14640: ,p_project_id => p_project_id
14641: ,p_structure_number => l_name
14642: ,p_structure_name => l_name

Line 14660: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE

14656: RAISE FND_API.G_EXC_ERROR;
14657: END IF;
14658:
14659: --create row in pa_proj_workplan_attr
14660: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
14661: (p_validate_only => FND_API.G_FALSE
14662: ,p_project_id => p_project_id
14663: ,p_proj_element_id => l_structure_id
14664: ,x_return_status => l_return_status

Line 14737: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14733: RAISE FND_API.G_EXC_ERROR;
14734: END IF;
14735:
14736: --create workplan structure
14737: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14738: (p_validate_only => FND_API.G_FALSE
14739: ,p_project_id => p_project_id
14740: ,p_structure_number => l_wp_name
14741: ,p_structure_name => l_wp_name

Line 14847: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

14843: --workplan currently disabled (financial enabled)
14844: IF (p_workplan_enabled_flag = 'N' and p_financial_enabled_flag = 'N') THEN
14845: --disabled both
14846: --disable financial structure API
14847: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
14848: p_validate_only => FND_API.G_FALSE
14849: ,p_project_id => p_project_id
14850: ,x_return_status => l_return_status
14851: ,x_msg_count => l_msg_count

Line 14870: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

14866: NULL;
14867: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'N') THEN
14868: --disable financial (enable workplan)
14869: --disable financial structure API
14870: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
14871: p_validate_only => FND_API.G_FALSE
14872: ,p_project_id => p_project_id
14873: ,x_return_status => l_return_status
14874: ,x_msg_count => l_msg_count

Line 14888: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14884: RAISE FND_API.G_EXC_ERROR;
14885: END IF;
14886:
14887: --create workplan structure
14888: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14889: (p_validate_only => FND_API.G_FALSE
14890: ,p_project_id => p_project_id
14891: ,p_structure_number => l_wp_name
14892: ,p_structure_name => l_wp_name

Line 15268: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

15264:
15265: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SPLIT_NO_MAPPING', 'SPLIT_MAPPING')) THEN
15266: --split mapping
15267: --Create default workplan structure
15268: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
15269: (p_validate_only => FND_API.G_FALSE
15270: ,p_project_id => p_project_id
15271: ,p_structure_number => l_wp_name
15272: ,p_structure_name => l_wp_name

Line 15449: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

15445: NULL;
15446: ELSIF (p_financial_enabled_flag = 'Y') THEN
15447: --call enable financial structure API
15448: --enable financial structure API
15449: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
15450: (p_validate_only => FND_API.G_FALSE
15451: ,p_project_id => p_project_id
15452: ,p_structure_number => l_name
15453: ,p_structure_name => l_name

Line 15471: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE

15467: RAISE FND_API.G_EXC_ERROR;
15468: END IF;
15469:
15470: --create row in pa_proj_workplan_attr
15471: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
15472: (p_validate_only => FND_API.G_FALSE
15473: ,p_project_id => p_project_id
15474: ,p_proj_element_id => l_structure_id
15475: ,x_return_status => l_return_status

Line 15755: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

15751: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SPLIT_NO_MAPPING','SPLIT_MAPPING')) THEN
15752: --split mapping/ no mapping
15753: --call enable financial structure API
15754: --create financial structure API
15755: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
15756: (p_validate_only => FND_API.G_FALSE
15757: ,p_project_id => p_project_id
15758: ,p_structure_number => l_name
15759: ,p_structure_name => l_name

Line 15777: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE

15773: RAISE FND_API.G_EXC_ERROR;
15774: END IF;
15775:
15776: --create row in pa_proj_workplan_attr
15777: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
15778: (p_validate_only => FND_API.G_FALSE
15779: ,p_project_id => p_project_id
15780: ,p_proj_element_id => l_structure_id
15781: ,x_return_status => l_return_status

Line 16167: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

16163:
16164: IF (p_workplan_enabled_flag = 'Y' AND p_sharing_option_code IN ('SPLIT_NO_MAPPING','SPLIT_MAPPING')) THEN
16165: --Create empty workplan structure
16166: l_structure_id := NULL;
16167: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
16168: (p_validate_only => FND_API.G_FALSE
16169: ,p_project_id => p_project_id
16170: ,p_structure_number => l_wp_name
16171: ,p_structure_name => l_wp_name

Line 16283: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

16279: element_number = l_wp_name
16280: where proj_element_id = l_structure_id;
16281:
16282: --Need delete financial tasks API
16283: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
16284: p_validate_only => FND_API.G_FALSE
16285: ,p_project_id => p_project_id
16286: ,x_return_status => l_return_status
16287: ,x_msg_count => l_msg_count

Line 16306: PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG(

16302: LOOP
16303: FETCH sel_all_wp_structure_ver INTO l_structure_version_id, l_struc_ver_rvn;
16304: EXIT WHEN sel_all_wp_structure_ver%NOTFOUND;
16305:
16306: PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG(
16307: p_validate_only => FND_API.G_FALSE
16308: ,p_project_id => p_project_id
16309: ,p_task_version_id => NULL
16310: ,p_structure_version_id => l_structure_version_id

Line 16632: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

16628: --end bug 3894059
16629:
16630: IF (p_workplan_enabled_flag = 'Y' AND p_sharing_option_code IN ('SPLIT_NO_MAPPING','SPLIT_MAPPING')) THEN
16631: --Create empty workplan structure
16632: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
16633: (p_validate_only => FND_API.G_FALSE
16634: ,p_project_id => p_project_id
16635: ,p_structure_number => l_wp_name
16636: ,p_structure_name => l_wp_name

Line 16748: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

16744: element_number = l_wp_name
16745: where proj_element_id = l_structure_id;
16746:
16747: --Need delete financial tasks API
16748: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
16749: p_validate_only => FND_API.G_FALSE
16750: ,p_project_id => p_project_id
16751: ,x_return_status => l_return_status
16752: ,x_msg_count => l_msg_count

Line 16771: PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG(

16767: LOOP
16768: FETCH sel_all_wp_structure_ver INTO l_structure_version_id, l_struc_ver_rvn;
16769: EXIT WHEN sel_all_wp_structure_ver%NOTFOUND;
16770:
16771: PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG(
16772: p_validate_only => FND_API.G_FALSE
16773: ,p_project_id => p_project_id
16774: ,p_task_version_id => NULL
16775: ,p_structure_version_id => l_structure_version_id

Line 16894: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

16890: END IF;
16891:
16892: IF (p_financial_enabled_flag = 'N') THEN
16893: --disable financial structure API
16894: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
16895: p_validate_only => FND_API.G_FALSE
16896: ,p_project_id => p_project_id
16897: ,x_return_status => l_return_status
16898: ,x_msg_count => l_msg_count

Line 17288: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

17284: END IF;
17285:
17286: IF (p_financial_enabled_flag = 'N') THEN
17287: --disable financial structure API
17288: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
17289: p_validate_only => FND_API.G_FALSE
17290: ,p_project_id => p_project_id
17291: ,x_return_status => l_return_status
17292: ,x_msg_count => l_msg_count

Line 17627: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

17623: --get deliverable name
17624: l_del_name := substrb(l_name||l_append||l_suffix, 1, 240);
17625:
17626: --create workplan structure
17627: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
17628: (p_validate_only => FND_API.G_FALSE
17629: ,p_project_id => p_project_id
17630: ,p_structure_number => l_del_name
17631: ,p_structure_name => l_del_name