DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJECT_STRUCTURE_PUB1

Line 7665: -- PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

7661:
7662: --Commented by hsiu
7663: -- IF (l_dest_template_flag = 'Y' AND l_structure_type = 'WORKPLAN') THEN
7664: --Create new structure
7665: -- PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
7666: -- ( p_validate_only => FND_API.G_FALSE
7667: -- ,p_project_id => p_dest_project_id
7668: -- ,p_structure_number => l_name
7669: -- ,p_structure_name => l_name

Line 7763: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

7759: -- ELSE
7760: --copy from
7761: --end commented code by hsiu
7762:
7763: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
7764: ( p_validate_only => FND_API.G_FALSE
7765: ,p_project_id => p_dest_project_id
7766: ,p_structure_number => l_name
7767: ,p_structure_name => l_name

Line 9052: PA_PROJECT_STRUCTURE_PUB1.create_structure_Version(

9048: delete from pa_proj_elem_ver_schedule
9049: where project_id = p_project_id;
9050:
9051: --create_structure_version
9052: PA_PROJECT_STRUCTURE_PUB1.create_structure_Version(
9053: p_structure_id => l_struc_id,
9054: x_structure_version_id => l_struc_ver_id,
9055: x_return_status => l_ret_stat,
9056: x_msg_count => l_msg_count,

Line 9073: PA_PROJECT_STRUCTURE_PUB1.create_structure_version_attr(

9069: RAISE FND_API.G_EXC_ERROR;
9070: END IF;
9071:
9072: --create_structure_version_attr
9073: PA_PROJECT_STRUCTURE_PUB1.create_structure_version_attr(
9074: p_structure_version_id => l_struc_ver_id,
9075: p_structure_version_name => p_structure_name,
9076: p_structure_version_desc => p_description,
9077: x_return_status => l_ret_stat,

Line 10106: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

10102: and lookup_code = 'WORKPLAN';
10103:
10104: l_name := substrb(l_name||l_append||l_suffix, 1, 240);
10105: --Create new structure
10106: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
10107: ( p_validate_only => FND_API.G_FALSE
10108: ,p_project_id => p_project_id
10109: ,p_structure_number => l_name
10110: ,p_structure_name => l_name

Line 10277: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

10273: END IF;
10274: END LOOP;
10275: CLOSE get_top_tasks;
10276:
10277: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
10278: PA_PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_Wo_Val(
10279: p_structure_version_id => l_del_struc_ver_id
10280: ,p_record_version_number => l_struc_ver_rvn
10281: ,x_return_status => l_return_status

Line 10437: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

10433: END IF;
10434: END LOOP;
10435: CLOSE get_top_tasks;
10436:
10437: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
10438: PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL(
10439: p_structure_version_id => l_del_struc_ver_id
10440: ,p_record_version_number => l_struc_ver_rvn
10441: ,x_return_status => l_return_status

Line 10548: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

10544: END IF;
10545: END LOOP;
10546: CLOSE get_top_tasks;
10547:
10548: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
10549: PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL(
10550: p_structure_version_id => l_del_struc_ver_id
10551: ,p_record_version_number => l_struc_ver_rvn
10552: ,x_return_status => l_return_status

Line 10969: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

10965: END IF;
10966: END LOOP;
10967: CLOSE get_top_tasks;
10968:
10969: -- PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
10970: PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL(
10971: p_structure_version_id => l_del_struc_ver_id
10972: ,p_record_version_number => l_struc_ver_rvn
10973: ,x_return_status => l_return_status

Line 11551: PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(

11547: LOOP
11548: FETCH sel_other_structure_ver into l_del_struc_ver_id,
11549: l_struc_ver_rvn;
11550: EXIT WHEN sel_other_structure_ver%NOTFOUND;
11551: PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version(
11552: p_structure_version_id => l_del_struc_ver_id
11553: ,p_record_version_number => l_struc_ver_rvn
11554: ,p_calling_from => 'DEL_WP_STRUC_DISABLE_VERSION' ---Added for bug 6023347
11555: ,x_return_status => l_return_status

Line 14652: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14648: NULL;
14649: ELSIF (p_workplan_enabled_flag = 'N' and p_financial_enabled_flag = 'Y') THEN
14650: --disable workplan (enable financial)
14651: --create financial structure API
14652: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14653: (p_validate_only => FND_API.G_FALSE
14654: ,p_project_id => p_project_id
14655: ,p_structure_number => l_name
14656: ,p_structure_name => l_name

Line 14674: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE

14670: RAISE FND_API.G_EXC_ERROR;
14671: END IF;
14672:
14673: --create row in pa_proj_workplan_attr
14674: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
14675: (p_validate_only => FND_API.G_FALSE
14676: ,p_project_id => p_project_id
14677: ,p_proj_element_id => l_structure_id
14678: ,x_return_status => l_return_status

Line 14753: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14749:
14750: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'N') THEN
14751: --disable financial (enable workplan)
14752: --create workplan structure
14753: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14754: (p_validate_only => FND_API.G_FALSE
14755: ,p_project_id => p_project_id
14756: ,p_structure_number => l_wp_name
14757: ,p_structure_name => l_wp_name

Line 14853: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

14849:
14850: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SHARE_PARTIAL', 'SHARE_FULL')) THEN
14851: --partial share/full share
14852: --enable workplan structure API
14853: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
14854: (p_validate_only => FND_API.G_FALSE
14855: ,p_project_id => p_project_id
14856: ,p_structure_number => l_name
14857: ,p_structure_name => l_name

Line 15014: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

15010:
15011: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SPLIT_MAPPING','SPLIT_NO_MAPPING')) THEN
15012: --split mapping/split no mapping
15013: --enable financial structure API
15014: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
15015: (p_validate_only => FND_API.G_FALSE
15016: ,p_project_id => p_project_id
15017: ,p_structure_number => l_name
15018: ,p_structure_name => l_name

Line 15036: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE

15032: RAISE FND_API.G_EXC_ERROR;
15033: END IF;
15034:
15035: --create row in pa_proj_workplan_attr
15036: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
15037: (p_validate_only => FND_API.G_FALSE
15038: ,p_project_id => p_project_id
15039: ,p_proj_element_id => l_structure_id
15040: ,x_return_status => l_return_status

Line 15113: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

15109: RAISE FND_API.G_EXC_ERROR;
15110: END IF;
15111:
15112: --create workplan structure
15113: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
15114: (p_validate_only => FND_API.G_FALSE
15115: ,p_project_id => p_project_id
15116: ,p_structure_number => l_wp_name
15117: ,p_structure_name => l_wp_name

Line 15223: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

15219: --workplan currently disabled (financial enabled)
15220: IF (p_workplan_enabled_flag = 'N' and p_financial_enabled_flag = 'N') THEN
15221: --disabled both
15222: --disable financial structure API
15223: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
15224: p_validate_only => FND_API.G_FALSE
15225: ,p_project_id => p_project_id
15226: ,x_return_status => l_return_status
15227: ,x_msg_count => l_msg_count

Line 15246: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

15242: NULL;
15243: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'N') THEN
15244: --disable financial (enable workplan)
15245: --disable financial structure API
15246: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
15247: p_validate_only => FND_API.G_FALSE
15248: ,p_project_id => p_project_id
15249: ,x_return_status => l_return_status
15250: ,x_msg_count => l_msg_count

Line 15264: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

15260: RAISE FND_API.G_EXC_ERROR;
15261: END IF;
15262:
15263: --create workplan structure
15264: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
15265: (p_validate_only => FND_API.G_FALSE
15266: ,p_project_id => p_project_id
15267: ,p_structure_number => l_wp_name
15268: ,p_structure_name => l_wp_name

Line 15644: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

15640:
15641: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SPLIT_NO_MAPPING', 'SPLIT_MAPPING')) THEN
15642: --split mapping
15643: --Create default workplan structure
15644: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
15645: (p_validate_only => FND_API.G_FALSE
15646: ,p_project_id => p_project_id
15647: ,p_structure_number => l_wp_name
15648: ,p_structure_name => l_wp_name

Line 15825: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

15821: NULL;
15822: ELSIF (p_financial_enabled_flag = 'Y') THEN
15823: --call enable financial structure API
15824: --enable financial structure API
15825: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
15826: (p_validate_only => FND_API.G_FALSE
15827: ,p_project_id => p_project_id
15828: ,p_structure_number => l_name
15829: ,p_structure_name => l_name

Line 15847: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE

15843: RAISE FND_API.G_EXC_ERROR;
15844: END IF;
15845:
15846: --create row in pa_proj_workplan_attr
15847: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
15848: (p_validate_only => FND_API.G_FALSE
15849: ,p_project_id => p_project_id
15850: ,p_proj_element_id => l_structure_id
15851: ,x_return_status => l_return_status

Line 16131: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

16127: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SPLIT_NO_MAPPING','SPLIT_MAPPING')) THEN
16128: --split mapping/ no mapping
16129: --call enable financial structure API
16130: --create financial structure API
16131: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
16132: (p_validate_only => FND_API.G_FALSE
16133: ,p_project_id => p_project_id
16134: ,p_structure_number => l_name
16135: ,p_structure_name => l_name

Line 16153: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE

16149: RAISE FND_API.G_EXC_ERROR;
16150: END IF;
16151:
16152: --create row in pa_proj_workplan_attr
16153: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
16154: (p_validate_only => FND_API.G_FALSE
16155: ,p_project_id => p_project_id
16156: ,p_proj_element_id => l_structure_id
16157: ,x_return_status => l_return_status

Line 16543: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

16539:
16540: IF (p_workplan_enabled_flag = 'Y' AND p_sharing_option_code IN ('SPLIT_NO_MAPPING','SPLIT_MAPPING')) THEN
16541: --Create empty workplan structure
16542: l_structure_id := NULL;
16543: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
16544: (p_validate_only => FND_API.G_FALSE
16545: ,p_project_id => p_project_id
16546: ,p_structure_number => l_wp_name
16547: ,p_structure_name => l_wp_name

Line 16659: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

16655: element_number = l_wp_name
16656: where proj_element_id = l_structure_id;
16657:
16658: --Need delete financial tasks API
16659: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
16660: p_validate_only => FND_API.G_FALSE
16661: ,p_project_id => p_project_id
16662: ,x_return_status => l_return_status
16663: ,x_msg_count => l_msg_count

Line 16682: PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG(

16678: LOOP
16679: FETCH sel_all_wp_structure_ver INTO l_structure_version_id, l_struc_ver_rvn;
16680: EXIT WHEN sel_all_wp_structure_ver%NOTFOUND;
16681:
16682: PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG(
16683: p_validate_only => FND_API.G_FALSE
16684: ,p_project_id => p_project_id
16685: ,p_task_version_id => NULL
16686: ,p_structure_version_id => l_structure_version_id

Line 17008: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

17004: --end bug 3894059
17005:
17006: IF (p_workplan_enabled_flag = 'Y' AND p_sharing_option_code IN ('SPLIT_NO_MAPPING','SPLIT_MAPPING')) THEN
17007: --Create empty workplan structure
17008: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
17009: (p_validate_only => FND_API.G_FALSE
17010: ,p_project_id => p_project_id
17011: ,p_structure_number => l_wp_name
17012: ,p_structure_name => l_wp_name

Line 17124: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

17120: element_number = l_wp_name
17121: where proj_element_id = l_structure_id;
17122:
17123: --Need delete financial tasks API
17124: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
17125: p_validate_only => FND_API.G_FALSE
17126: ,p_project_id => p_project_id
17127: ,x_return_status => l_return_status
17128: ,x_msg_count => l_msg_count

Line 17147: PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG(

17143: LOOP
17144: FETCH sel_all_wp_structure_ver INTO l_structure_version_id, l_struc_ver_rvn;
17145: EXIT WHEN sel_all_wp_structure_ver%NOTFOUND;
17146:
17147: PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG(
17148: p_validate_only => FND_API.G_FALSE
17149: ,p_project_id => p_project_id
17150: ,p_task_version_id => NULL
17151: ,p_structure_version_id => l_structure_version_id

Line 17270: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

17266: END IF;
17267:
17268: IF (p_financial_enabled_flag = 'N') THEN
17269: --disable financial structure API
17270: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
17271: p_validate_only => FND_API.G_FALSE
17272: ,p_project_id => p_project_id
17273: ,x_return_status => l_return_status
17274: ,x_msg_count => l_msg_count

Line 17664: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(

17660: END IF;
17661:
17662: IF (p_financial_enabled_flag = 'N') THEN
17663: --disable financial structure API
17664: PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE(
17665: p_validate_only => FND_API.G_FALSE
17666: ,p_project_id => p_project_id
17667: ,x_return_status => l_return_status
17668: ,x_msg_count => l_msg_count

Line 18003: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE

17999: --get deliverable name
18000: l_del_name := substrb(l_name||l_append||l_suffix, 1, 240);
18001:
18002: --create workplan structure
18003: PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE
18004: (p_validate_only => FND_API.G_FALSE
18005: ,p_project_id => p_project_id
18006: ,p_structure_number => l_del_name
18007: ,p_structure_name => l_del_name