DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on FND_API

Line 907: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

903: * @rep:compatibility S
904: */
905: PROCEDURE create_project
906: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
907: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
908: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
909: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
910: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
911: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 908: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

904: */
905: PROCEDURE create_project
906: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
907: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
908: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
909: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
910: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
911: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
912: ,p_workflow_started OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1140: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1136: * @rep:compatibility S
1137: */
1138: PROCEDURE add_task
1139: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1140: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1141: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1142: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1143: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1144: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1141: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1137: */
1138: PROCEDURE add_task
1139: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1140: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1141: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1142: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1143: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1144: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1145: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1340: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1336: * @rep:compatibility S
1337: */
1338: PROCEDURE delete_task
1339: ( p_api_version_number IN NUMBER := 1.0 -- for bug# 3802319, earlier PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM was used
1340: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1342: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1343: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1344: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1341: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1337: */
1338: PROCEDURE delete_task
1339: ( p_api_version_number IN NUMBER := 1.0 -- for bug# 3802319, earlier PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM was used
1340: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1342: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1343: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1344: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1345: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1567: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1563: * @rep:compatibility S
1564: */
1565: PROCEDURE load_project
1566: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1567: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1568: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1569: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1570: ,p_pa_project_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1571: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1743: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1739: * @rep:compatibility S
1740: */
1741: PROCEDURE load_key_member
1742: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1743: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1744: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1745: ,p_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1746: ,p_project_role_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1747: ,p_project_role_meaning IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 6408593

Line 1776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1772: * @rep:compatibility S
1773: */
1774: PROCEDURE load_org_role
1775: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1777: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1778: ,p_resource_source_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1779: ,p_project_role_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1780: ,p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 1809: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1805: * @rep:compatibility S
1806: */
1807: PROCEDURE load_class_category
1808: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1809: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1810: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1811: ,p_class_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1812: ,p_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1813: ,p_new_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Added for Bug 7028230

Line 2015: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2011: * @rep:compatibility S
2012: */
2013: PROCEDURE load_task
2014: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2015: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2016: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2017: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2018: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2019: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 2209: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2205: * @rep:compatibility S
2206: */
2207: PROCEDURE execute_create_project
2208: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2209: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2210: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2211: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2212: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2213: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2210: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2206: */
2207: PROCEDURE execute_create_project
2208: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2209: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2210: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2211: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2212: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2213: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2214: ,p_workflow_started OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2253: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2249: * @rep:compatibility S
2250: */
2251: PROCEDURE fetch_task
2252: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2253: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2254: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2255: ,p_task_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2256: ,p_pa_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2257: ,p_pm_task_reference OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2306: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2302: * @rep:compatibility S
2303: */
2304: PROCEDURE Check_Delete_Task_OK
2305: ( p_api_version_number IN NUMBER
2306: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2307: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2308: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2309: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2310: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2346: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2342: * @rep:compatibility S
2343: */
2344: PROCEDURE Check_Add_Subtask_OK
2345: (p_api_version_number IN NUMBER
2346: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2347: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2348: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2349: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2350: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2382: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2378: * @rep:compatibility S
2379: */
2380: PROCEDURE Check_Unique_Task_Reference
2381: (p_api_version_number IN NUMBER
2382: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2383: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2384: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2385: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2386: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2414: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2410: * @rep:compatibility S
2411: */
2412: PROCEDURE Check_Unique_Project_Reference
2413: (p_api_version_number IN NUMBER
2414: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2415: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2416: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2417: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2418: , p_pm_project_reference IN VARCHAR2

Line 2445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2441: * @rep:compatibility S
2442: */
2443: PROCEDURE Check_Delete_Project_OK
2444: (p_api_version_number IN NUMBER
2445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2446: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2447: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2448: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2449: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2482: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2478: * @rep:compatibility S
2479: */
2480: PROCEDURE Check_Change_Parent_OK
2481: (p_api_version_number IN NUMBER
2482: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2483: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2484: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2485: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2486: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2518: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2514: * @rep:compatibility S
2515: */
2516: PROCEDURE Check_Change_Project_Org_OK
2517: (p_api_version_number IN NUMBER
2518: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2519: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2520: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2521: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2522: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2551: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2547: * @rep:compatibility S
2548: */
2549: PROCEDURE Check_Unique_Task_Number
2550: (p_api_version_number IN NUMBER
2551: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2552: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2553: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2554: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2555: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2586: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2582: * @rep:compatibility S
2583: */
2584: PROCEDURE Check_Task_Number_Change_Ok
2585: ( p_api_version_number IN NUMBER
2586: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2587: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2588: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2589: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2590: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2662: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2658: * @rep:compatibility S
2659: */
2660: PROCEDURE update_project
2661: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2662: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2663: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2664: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2665: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2666: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2663: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2659: */
2660: PROCEDURE update_project
2661: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2662: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2663: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2664: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2665: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2666: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2667: ,p_workflow_started OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2907: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2903: * @rep:compatibility S
2904: */
2905: PROCEDURE update_task
2906: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2907: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2908: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2909: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2910: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2911: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2908: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2904: */
2905: PROCEDURE update_task
2906: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2907: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2908: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2909: p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2910: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2911: p_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2912: --Project Structures

Line 3125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

3121: * @rep:compatibility S
3122: */
3123: PROCEDURE execute_update_project
3124: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3126: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3127: ,p_op_validate_flag IN VARCHAR2 := 'Y'--added by rtarway, bug 4218977
3128: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3129: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3126: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3122: */
3123: PROCEDURE execute_update_project
3124: ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3126: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3127: ,p_op_validate_flag IN VARCHAR2 := 'Y'--added by rtarway, bug 4218977
3128: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3129: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3130: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

3156: * @rep:compatibility S
3157: */
3158: PROCEDURE delete_project
3159: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3161: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3162: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3163: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3164: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3161: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3157: */
3158: PROCEDURE delete_project
3159: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3161: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3162: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3163: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3164: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3165: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 3172: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

3168:
3169:
3170: PROCEDURE approve_project
3171: ( p_api_version_number IN NUMBER
3172: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3173: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3174: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3175: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3176: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3173: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3169:
3170: PROCEDURE approve_project
3171: ( p_api_version_number IN NUMBER
3172: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3173: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3174: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3175: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3176: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3177: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 3392: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3388: */
3389: PROCEDURE load_tasks
3390: (
3391: p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3392: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3393: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3394: ,p_pm_task_reference IN PA_VC_1000_150
3395: ,p_pa_task_id IN PA_NUM_1000_NUM
3396: ,p_task_name IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- bug 6193314 .modified from PA_VC_1000_150

Line 3585: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3581: * @rep:compatibility S
3582: */
3583: PROCEDURE fetch_tasks
3584: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3585: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3586: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3587: ,p_task_index IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
3588: ,p_pa_task_id OUT NOCOPY PA_NUM_1000_NUM --File.Sql.39 bug 4440895
3589: ,p_task_version_id OUT NOCOPY PA_NUM_1000_NUM --File.Sql.39 bug 4440895

Line 3654: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

3650: * @rep:category BUSINESS_ENTITY PA_TASK
3651: * @rep:compatibility S
3652: */
3653: PROCEDURE load_extensible_attribute(P_API_VERSION_NUMBER IN NUMBER := 1.0,
3654: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3655: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3656: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3657: P_TRANSACTION_TYPE IN VARCHAR2 := PA_PROJECT_PUB.G_SYNC_MODE,
3658: P_TASK_ID IN NUMBER := NULL,

Line 3655: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

3651: * @rep:compatibility S
3652: */
3653: PROCEDURE load_extensible_attribute(P_API_VERSION_NUMBER IN NUMBER := 1.0,
3654: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3655: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3656: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3657: P_TRANSACTION_TYPE IN VARCHAR2 := PA_PROJECT_PUB.G_SYNC_MODE,
3658: P_TASK_ID IN NUMBER := NULL,
3659: P_TASK_REFERENCE IN VARCHAR2 := NULL,

Line 3711: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

3707: * @rep:category BUSINESS_ENTITY PA_TASK
3708: * @rep:compatibility S
3709: */
3710: PROCEDURE load_extensible_attributes(P_API_VERSION_NUMBER IN NUMBER,
3711: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3712: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3713: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3714: P_TRANSACTION_TYPE IN PA_VC_1000_10 := PA_VC_1000_10(PA_PROJECT_PUB.G_SYNC_MODE),
3715: P_TASK_ID IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(NULL),

Line 3712: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

3708: * @rep:compatibility S
3709: */
3710: PROCEDURE load_extensible_attributes(P_API_VERSION_NUMBER IN NUMBER,
3711: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3712: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3713: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3714: P_TRANSACTION_TYPE IN PA_VC_1000_10 := PA_VC_1000_10(PA_PROJECT_PUB.G_SYNC_MODE),
3715: P_TASK_ID IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(NULL),
3716: P_TASK_REFERENCE IN PA_VC_1000_150 := PA_VC_1000_150(NULL),

Line 3753: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3749: * @rep:compatibility S
3750: */
3751: PROCEDURE load_structure
3752: ( p_api_version_number IN NUMBER
3753: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3754: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3755: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3756: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
3757: ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 3810: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

3806: * @rep:compatibility S
3807: */
3808: PROCEDURE delete_structure_version
3809: ( p_api_version_number IN NUMBER := 1.0 -- for bug# 3802759
3810: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3811: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3812: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3813: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3814: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3811: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3807: */
3808: PROCEDURE delete_structure_version
3809: ( p_api_version_number IN NUMBER := 1.0 -- for bug# 3802759
3810: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3811: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3812: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3813: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3814: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3815: ,p_structure_version_id IN NUMBER

Line 3944: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3940: * @rep:compatibility S
3941: */
3942: PROCEDURE fetch_structure_version
3943: ( p_api_version_number IN NUMBER
3944: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3945: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3946: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
3947: ,p_pa_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3948: ,p_struc_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3977: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3973: * @rep:compatibility S
3974: */
3975: PROCEDURE fetch_task_version
3976: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3977: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3978: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3979: ,p_task_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3980: ,p_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3981: ,p_task_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4007: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

4003: * @rep:compatibility S
4004: */
4005: PROCEDURE get_task_version
4006: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4007: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4008: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4009: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4086: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

4082: * @rep:compatibility S
4083: */
4084: PROCEDURE apply_lp_prog_on_cwv(
4085: p_api_version IN NUMBER :=1.0
4086: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4087: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4088: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4089: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4090: ,p_working_str_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4087: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

4083: */
4084: PROCEDURE apply_lp_prog_on_cwv(
4085: p_api_version IN NUMBER :=1.0
4086: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4087: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4088: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4089: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4090: ,p_working_str_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4091: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4145: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

4141: * @rep:compatibility S
4142: */
4143: PROCEDURE load_deliverable
4144: ( p_api_version IN NUMBER := 1.0
4145: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4146: , p_debug_mode IN VARCHAR2 := 'N'
4147: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4148: , p_deliverable_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4149: , p_deliverable_short_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4223: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

4219: * @rep:compatibility S
4220: */
4221: PROCEDURE load_deliverables
4222: ( p_api_version IN NUMBER := 1.0
4223: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4224: , p_debug_mode IN VARCHAR2 := 'N'
4225: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4226: , p_deliverable_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4227: --, p_deliverable_name IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 4362: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

4358: * @rep:compatibility S
4359: */
4360: PROCEDURE load_action
4361: ( p_api_version IN NUMBER := 1.0
4362: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4363: , p_debug_mode IN VARCHAR2 := 'N'
4364: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4365: , p_action_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4366: , p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4540: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

4536: * @rep:compatibility S
4537: */
4538: PROCEDURE load_actions
4539: ( p_api_version IN NUMBER := 1.0
4540: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4541: , p_debug_mode IN VARCHAR2 := 'N'
4542: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4543: --, p_action_name IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
4544: , p_action_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 4671: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

4667: * @rep:compatibility S
4668: */
4669: PROCEDURE create_deliverable
4670: ( p_api_version IN NUMBER := 1.0
4671: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4672: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4673: , p_debug_mode IN VARCHAR2 := 'N'
4674: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4675: , p_deliverable_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4672: , p_commit IN VARCHAR2 := FND_API.G_FALSE

4668: */
4669: PROCEDURE create_deliverable
4670: ( p_api_version IN NUMBER := 1.0
4671: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4672: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4673: , p_debug_mode IN VARCHAR2 := 'N'
4674: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4675: , p_deliverable_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4676: , p_deliverable_short_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4820: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

4816: * @rep:compatibility S
4817: */
4818: PROCEDURE create_deliverable_action
4819: ( p_api_version IN NUMBER := 1.0
4820: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4821: , p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
4822: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4823: , p_action_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: , p_action_owner_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4821: , p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

4817: */
4818: PROCEDURE create_deliverable_action
4819: ( p_api_version IN NUMBER := 1.0
4820: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4821: , p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
4822: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4823: , p_action_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: , p_action_owner_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4825: , p_function_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4822: , p_commit IN VARCHAR2 := FND_API.G_FALSE

4818: PROCEDURE create_deliverable_action
4819: ( p_api_version IN NUMBER := 1.0
4820: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4821: , p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
4822: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4823: , p_action_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4824: , p_action_owner_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4825: , p_function_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4826: , p_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 4953: , p_commit IN VARCHAR2 := FND_API.G_FALSE

4949: */
4950: PROCEDURE update_deliverable
4951: ( p_api_version IN NUMBER := 1.0
4952: , p_init_msg_list IN VARCHAR2 := 'F'
4953: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4954: , p_debug_mode IN VARCHAR2 := 'N'
4955: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4956: , p_deliverable_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4957: , p_deliverable_short_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5102: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5098: * @rep:compatibility S
5099: */
5100: PROCEDURE update_deliverable_action
5101: ( p_api_version IN NUMBER := 1.0
5102: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5103: , p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5104: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5105: , p_action_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5106: , p_action_owner_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5103: , p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

5099: */
5100: PROCEDURE update_deliverable_action
5101: ( p_api_version IN NUMBER := 1.0
5102: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5103: , p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5104: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5105: , p_action_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5106: , p_action_owner_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5107: , p_function_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5104: , p_commit IN VARCHAR2 := FND_API.G_FALSE

5100: PROCEDURE update_deliverable_action
5101: ( p_api_version IN NUMBER := 1.0
5102: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5103: , p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5104: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5105: , p_action_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5106: , p_action_owner_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5107: , p_function_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5108: , p_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 5205: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5201: * @rep:compatibility S
5202: */
5203: Procedure Delete_Deliverables (
5204: p_api_version IN NUMBER := 1.0
5205: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5206: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5207: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5208: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5206: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5202: */
5203: Procedure Delete_Deliverables (
5204: p_api_version IN NUMBER := 1.0
5205: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5206: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5207: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5208: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5210: -- for bug# 3729250

Line 5246: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5242: * @rep:compatibility S
5243: */
5244: PROCEDURE delete_deliverable_actions
5245: ( p_api_version IN NUMBER := 1.0 -- 3749480 changed default value
5246: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5247: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5248: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5249: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5250: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5247: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5243: */
5244: PROCEDURE delete_deliverable_actions
5245: ( p_api_version IN NUMBER := 1.0 -- 3749480 changed default value
5246: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5247: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5248: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5249: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5250: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5251: -- for bug# 3729250 , changed datatype from NUMBER to VARCHAR2

Line 5291: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5287: * @rep:compatibility S
5288: */
5289: Procedure ASSOCIATE_DLV_TO_TASK (
5290: p_api_version IN NUMBER := 1.0
5291: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5292: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5293: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5294: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5295: -- added for bug# 3729250

Line 5292: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5288: */
5289: Procedure ASSOCIATE_DLV_TO_TASK (
5290: p_api_version IN NUMBER := 1.0
5291: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5292: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5293: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5294: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5295: -- added for bug# 3729250
5296: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5293: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

5289: Procedure ASSOCIATE_DLV_TO_TASK (
5290: p_api_version IN NUMBER := 1.0
5291: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5292: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5293: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5294: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5295: -- added for bug# 3729250
5296: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5297: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5333: * @rep:compatibility S
5334: */
5335: Procedure ASSOCIATE_DLV_TO_TASK_ASSIGN (
5336: p_api_version IN NUMBER := 1.0
5337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5339: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5340: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5341: -- added for bug# 3729250

Line 5338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5334: */
5335: Procedure ASSOCIATE_DLV_TO_TASK_ASSIGN (
5336: p_api_version IN NUMBER := 1.0
5337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5339: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5340: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5341: -- added for bug# 3729250
5342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5339: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

5335: Procedure ASSOCIATE_DLV_TO_TASK_ASSIGN (
5336: p_api_version IN NUMBER := 1.0
5337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5339: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5340: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5341: -- added for bug# 3729250
5342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5343: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5382: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

5378: * @rep:compatibility S
5379: */
5380: Procedure DELETE_DLV_TO_TASK_ASSCN (
5381: p_api_version IN NUMBER :=1.0
5382: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5383: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5384: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5385: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5386: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5383: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

5379: */
5380: Procedure DELETE_DLV_TO_TASK_ASSCN (
5381: p_api_version IN NUMBER :=1.0
5382: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5383: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5384: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5385: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5386: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5387: ,p_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5427: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5423: * @rep:compatibility S
5424: */
5425: Procedure DELETE_DLV_TO_TASK_ASSIGN (
5426: p_api_version IN NUMBER := 1.0
5427: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5428: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5429: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5430: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5431: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5428: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5424: */
5425: Procedure DELETE_DLV_TO_TASK_ASSIGN (
5426: p_api_version IN NUMBER := 1.0
5427: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5428: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5429: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5430: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5431: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5432: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5429: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

5425: Procedure DELETE_DLV_TO_TASK_ASSIGN (
5426: p_api_version IN NUMBER := 1.0
5427: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5428: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5429: ,p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
5430: ,p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5431: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5432: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5433: ,p_task_assign_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5475: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5471: * @rep:compatibility S
5472: */
5473: PROCEDURE update_mapping
5474: ( p_api_version IN NUMBER := 1.0
5475: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5476: , p_commit IN VARCHAR2 := FND_API.G_TRUE
5477: , p_debug_mode IN VARCHAR2 := 'N'
5478: , px_mapped_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5479: , p_mapped_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5476: , p_commit IN VARCHAR2 := FND_API.G_TRUE

5472: */
5473: PROCEDURE update_mapping
5474: ( p_api_version IN NUMBER := 1.0
5475: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5476: , p_commit IN VARCHAR2 := FND_API.G_TRUE
5477: , p_debug_mode IN VARCHAR2 := 'N'
5478: , px_mapped_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5479: , p_mapped_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5480: , p_mapped_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5522: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5518: * @rep:compatibility S
5519: */
5520: PROCEDURE create_mapping
5521: ( p_api_version IN NUMBER := 1.0
5522: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5523: , p_commit IN VARCHAR2 := FND_API.G_TRUE
5524: , p_debug_mode IN VARCHAR2 := 'N'
5525: , px_mapped_task_id IN NUMBER
5526: , p_mapped_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5523: , p_commit IN VARCHAR2 := FND_API.G_TRUE

5519: */
5520: PROCEDURE create_mapping
5521: ( p_api_version IN NUMBER := 1.0
5522: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5523: , p_commit IN VARCHAR2 := FND_API.G_TRUE
5524: , p_debug_mode IN VARCHAR2 := 'N'
5525: , px_mapped_task_id IN NUMBER
5526: , p_mapped_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5527: , p_mapped_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5541: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5537: ) ;
5538:
5539: PROCEDURE process_tasks_table
5540: ( p_api_version IN NUMBER := 1.0
5541: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5542: , p_debug_mode IN VARCHAR2 := 'N'
5543: , p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5544: , p_tasks_in_tbl IN OUT NOCOPY task_in_tbl_type --File.Sql.39 bug 4440895
5545: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5583: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5579: */
5580: PROCEDURE Delete_Mapping
5581: (
5582: p_api_version IN NUMBER := 1.0
5583: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5584: , p_commit IN VARCHAR2 := FND_API.G_TRUE
5585: , p_debug_mode IN VARCHAR2 := 'N'
5586: , p_wp_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5587: , p_fp_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5584: , p_commit IN VARCHAR2 := FND_API.G_TRUE

5580: PROCEDURE Delete_Mapping
5581: (
5582: p_api_version IN NUMBER := 1.0
5583: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5584: , p_commit IN VARCHAR2 := FND_API.G_TRUE
5585: , p_debug_mode IN VARCHAR2 := 'N'
5586: , p_wp_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5587: , p_fp_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5588: , p_wp_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5648: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5644: * @rep:compatibility S
5645: */
5646: PROCEDURE Create_Dependency(
5647: p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5648: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5649: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5650: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5651: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5652: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5649: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5645: */
5646: PROCEDURE Create_Dependency(
5647: p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5648: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5649: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5650: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5651: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5652: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5653: ,p_pm_product_code IN VARCHAR2

Line 5713: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5709: */
5710:
5711: PROCEDURE Update_Dependency(
5712: p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5713: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5714: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5715: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5716: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5717: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5714: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5710:
5711: PROCEDURE Update_Dependency(
5712: p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5713: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5714: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5715: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5716: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5717: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5718: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5775: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5771: */
5772:
5773: PROCEDURE Delete_Dependency(
5774: p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5775: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5777: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5778: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5779: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5772:
5773: PROCEDURE Delete_Dependency(
5774: p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5775: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5777: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5778: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5779: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5780: ,p_pm_product_code IN VARCHAR2

Line 5835: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5831: */
5832:
5833: PROCEDURE check_task_mfd
5834: ( p_api_version_number IN NUMBER
5835: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5836: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5837: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5838: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5839: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5887: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5883: -- Bug 5436264 : AMG API FOR PROCESS STRUCTURE UPDATES
5884:
5885: PROCEDURE process_structure_updates
5886: (p_api_version_number IN NUMBER := 1.0
5887: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5888: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5889: , p_return_status OUT NOCOPY VARCHAR2
5890: , p_msg_count OUT NOCOPY NUMBER
5891: , p_msg_data OUT NOCOPY VARCHAR2

Line 5888: , p_commit IN VARCHAR2 := FND_API.G_FALSE

5884:
5885: PROCEDURE process_structure_updates
5886: (p_api_version_number IN NUMBER := 1.0
5887: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5888: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5889: , p_return_status OUT NOCOPY VARCHAR2
5890: , p_msg_count OUT NOCOPY NUMBER
5891: , p_msg_data OUT NOCOPY VARCHAR2
5892: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5914: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5910: -- Bug # 5072032.
5911:
5912: PROCEDURE SETUP_PROJECT_AS_PROGRAM
5913: (p_api_version IN NUMBER := 1.0
5914: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5915: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5916: , p_debug_mode IN VARCHAR2 := 'N'
5917: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5918: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5915: , p_commit IN VARCHAR2 := FND_API.G_FALSE

5911:
5912: PROCEDURE SETUP_PROJECT_AS_PROGRAM
5913: (p_api_version IN NUMBER := 1.0
5914: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5915: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5916: , p_debug_mode IN VARCHAR2 := 'N'
5917: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5918: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5919: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 5928: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5924: , x_msg_data OUT NOCOPY VARCHAR2);
5925:
5926: PROCEDURE CREATE_PROGRAM_LINKS
5927: (p_api_version IN NUMBER := 1.0
5928: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5929: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5930: , p_debug_mode IN VARCHAR2 := 'N'
5931: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5932: , p_program_links_tbl IN PA_PROJECT_PUB.PROGRAM_LINKS_TBL_TYPE

Line 5929: , p_commit IN VARCHAR2 := FND_API.G_FALSE

5925:
5926: PROCEDURE CREATE_PROGRAM_LINKS
5927: (p_api_version IN NUMBER := 1.0
5928: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5929: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5930: , p_debug_mode IN VARCHAR2 := 'N'
5931: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5932: , p_program_links_tbl IN PA_PROJECT_PUB.PROGRAM_LINKS_TBL_TYPE
5933: , x_return_status OUT NOCOPY VARCHAR2

Line 5939: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5935: , x_msg_data OUT NOCOPY VARCHAR2);
5936:
5937: PROCEDURE UPDATE_PROGRAM_LINK_COMMENTS
5938: (p_api_version IN NUMBER := 1.0
5939: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5940: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5941: , p_debug_mode IN VARCHAR2 := 'N'
5942: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5943: , p_program_links_tbl IN PA_PROJECT_PUB.PROGRAM_LINKS_TBL_TYPE

Line 5940: , p_commit IN VARCHAR2 := FND_API.G_FALSE

5936:
5937: PROCEDURE UPDATE_PROGRAM_LINK_COMMENTS
5938: (p_api_version IN NUMBER := 1.0
5939: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5940: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5941: , p_debug_mode IN VARCHAR2 := 'N'
5942: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5943: , p_program_links_tbl IN PA_PROJECT_PUB.PROGRAM_LINKS_TBL_TYPE
5944: , x_return_status OUT NOCOPY VARCHAR2

Line 5950: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5946: , x_msg_data OUT NOCOPY VARCHAR2);
5947:
5948: PROCEDURE DELETE_PROGRAM_LINK
5949: (p_api_version IN NUMBER := 1.0
5950: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5951: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5952: , p_debug_mode IN VARCHAR2 := 'N'
5953: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5954: , p_object_relationship_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5951: , p_commit IN VARCHAR2 := FND_API.G_FALSE

5947:
5948: PROCEDURE DELETE_PROGRAM_LINK
5949: (p_api_version IN NUMBER := 1.0
5950: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5951: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5952: , p_debug_mode IN VARCHAR2 := 'N'
5953: , p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5954: , p_object_relationship_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5955: , p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5990: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

5986: -- End fix for Bug 7525628
5987:
5988: PROCEDURE BULK_UPDATE_TASKS_LITE
5989: ( p_api_version_number IN NUMBER
5990: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5991: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5992: ,x_msg_count OUT NOCOPY NUMBER
5993: ,x_msg_data OUT NOCOPY VARCHAR2
5994: ,x_return_status OUT NOCOPY VARCHAR2

Line 5991: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

5987:
5988: PROCEDURE BULK_UPDATE_TASKS_LITE
5989: ( p_api_version_number IN NUMBER
5990: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5991: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
5992: ,x_msg_count OUT NOCOPY NUMBER
5993: ,x_msg_data OUT NOCOPY VARCHAR2
5994: ,x_return_status OUT NOCOPY VARCHAR2
5995: ,p_project_id IN NUMBER

Line 6006: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

6002: );
6003:
6004: PROCEDURE BULK_ADD_TASKS_LITE
6005: ( p_api_version_number IN NUMBER
6006: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6007: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6008: ,x_msg_count OUT NOCOPY NUMBER
6009: ,x_msg_data OUT NOCOPY VARCHAR2
6010: ,x_return_status OUT NOCOPY VARCHAR2

Line 6007: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

6003:
6004: PROCEDURE BULK_ADD_TASKS_LITE
6005: ( p_api_version_number IN NUMBER
6006: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6007: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6008: ,x_msg_count OUT NOCOPY NUMBER
6009: ,x_msg_data OUT NOCOPY VARCHAR2
6010: ,x_return_status OUT NOCOPY VARCHAR2
6011: ,p_project_id IN NUMBER

Line 6024: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

6020:
6021: -- Added following three new api's to indent, outdent and move tasks for Huawei enhancement - bug 13923366
6022: PROCEDURE BULK_INDENT_TASKS_LITE (
6023: p_api_version IN NUMBER :=1.0,
6024: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
6025: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
6026: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
6027: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
6028: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

Line 6025: p_commit IN VARCHAR2 :=FND_API.G_FALSE,

6021: -- Added following three new api's to indent, outdent and move tasks for Huawei enhancement - bug 13923366
6022: PROCEDURE BULK_INDENT_TASKS_LITE (
6023: p_api_version IN NUMBER :=1.0,
6024: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
6025: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
6026: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
6027: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
6028: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
6029: p_debug_mode IN VARCHAR2 :='N',

Line 6026: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

6022: PROCEDURE BULK_INDENT_TASKS_LITE (
6023: p_api_version IN NUMBER :=1.0,
6024: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
6025: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
6026: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
6027: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
6028: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
6029: p_debug_mode IN VARCHAR2 :='N',
6030: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 6027: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

6023: p_api_version IN NUMBER :=1.0,
6024: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
6025: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
6026: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
6027: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
6028: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
6029: p_debug_mode IN VARCHAR2 :='N',
6030: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
6031: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 6042: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

6038: );
6039:
6040: PROCEDURE BULK_OUTDENT_TASKS_LITE (
6041: p_api_version IN NUMBER :=1.0,
6042: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
6043: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
6044: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
6045: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
6046: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

Line 6043: p_commit IN VARCHAR2 :=FND_API.G_FALSE,

6039:
6040: PROCEDURE BULK_OUTDENT_TASKS_LITE (
6041: p_api_version IN NUMBER :=1.0,
6042: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
6043: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
6044: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
6045: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
6046: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
6047: p_debug_mode IN VARCHAR2 :='N',

Line 6044: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

6040: PROCEDURE BULK_OUTDENT_TASKS_LITE (
6041: p_api_version IN NUMBER :=1.0,
6042: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
6043: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
6044: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
6045: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
6046: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
6047: p_debug_mode IN VARCHAR2 :='N',
6048: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 6045: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

6041: p_api_version IN NUMBER :=1.0,
6042: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
6043: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
6044: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
6045: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
6046: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
6047: p_debug_mode IN VARCHAR2 :='N',
6048: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
6049: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 6060: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

6056: );
6057:
6058: PROCEDURE BULK_MOVE_TASKS_LITE
6059: ( p_api_version IN NUMBER := 1.0,
6060: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6061: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6062: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
6063: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6064: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',

Line 6061: p_commit IN VARCHAR2 := FND_API.G_FALSE,

6057:
6058: PROCEDURE BULK_MOVE_TASKS_LITE
6059: ( p_api_version IN NUMBER := 1.0,
6060: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6061: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6062: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
6063: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6064: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
6065: p_debug_mode IN VARCHAR2 := 'N',

Line 6062: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

6058: PROCEDURE BULK_MOVE_TASKS_LITE
6059: ( p_api_version IN NUMBER := 1.0,
6060: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6061: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6062: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
6063: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6064: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
6065: p_debug_mode IN VARCHAR2 := 'N',
6066: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 6063: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6059: ( p_api_version IN NUMBER := 1.0,
6060: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6061: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6062: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
6063: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6064: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
6065: p_debug_mode IN VARCHAR2 := 'N',
6066: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
6067: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 6079: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

6075: x_msg_data OUT NOCOPY VARCHAR2
6076: );
6077:
6078: PROCEDURE Bulk_Delete_Task ( p_api_version_number IN NUMBER := 1.0
6079: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6080: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6081: ,p_msg_count OUT NOCOPY NUMBER
6082: ,p_msg_data OUT NOCOPY VARCHAR2
6083: ,p_return_status OUT NOCOPY VARCHAR2

Line 6080: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

6076: );
6077:
6078: PROCEDURE Bulk_Delete_Task ( p_api_version_number IN NUMBER := 1.0
6079: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6080: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6081: ,p_msg_count OUT NOCOPY NUMBER
6082: ,p_msg_data OUT NOCOPY VARCHAR2
6083: ,p_return_status OUT NOCOPY VARCHAR2
6084: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 6100: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

6096: );
6097:
6098: procedure STRUCTURE_ROLLUP (
6099: p_api_version IN NUMBER := 1.0,
6100: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6102: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
6103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6104: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',

Line 6101: p_commit IN VARCHAR2 := FND_API.G_FALSE,

6097:
6098: procedure STRUCTURE_ROLLUP (
6099: p_api_version IN NUMBER := 1.0,
6100: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6102: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
6103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6104: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
6105: p_debug_mode IN VARCHAR2 := 'N',

Line 6102: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

6098: procedure STRUCTURE_ROLLUP (
6099: p_api_version IN NUMBER := 1.0,
6100: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6102: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
6103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6104: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
6105: p_debug_mode IN VARCHAR2 := 'N',
6106: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 6103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6099: p_api_version IN NUMBER := 1.0,
6100: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6102: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
6103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6104: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
6105: p_debug_mode IN VARCHAR2 := 'N',
6106: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
6107: p_structure_version_id IN NUMBER := NULL,

Line 6158: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

6154: */
6155:
6156: PROCEDURE ADD_COST_CODE_TO_TASK (
6157: p_api_version IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6158: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6159: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6160: , p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6161: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6162: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 6159: , p_commit IN VARCHAR2 := FND_API.G_FALSE

6155:
6156: PROCEDURE ADD_COST_CODE_TO_TASK (
6157: p_api_version IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6158: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6159: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6160: , p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6161: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6162: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6163: , p_task_cost_code_in IN TASK_COST_CODE_TBL

Line 6201: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

6197:
6198:
6199: PROCEDURE DELETE_COST_CODE_FROM_TASK (
6200: p_api_version IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6201: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6202: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6203: , p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6204: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6205: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 6202: , p_commit IN VARCHAR2 := FND_API.G_FALSE

6198:
6199: PROCEDURE DELETE_COST_CODE_FROM_TASK (
6200: p_api_version IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6201: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6202: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6203: , p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6204: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6205: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6206: , p_task_cost_code_in IN TASK_COST_CODE_TBL