eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASKS_MAINT_UTILS dependencies on PA_INTERFACE_UTILS_PUB

Line 10: p_task_mgr_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

6: --End add rtarway FP-M development
7:
8: procedure CHECK_TASK_MGR_NAME_OR_ID
9: (
10: p_task_mgr_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
11: ,p_task_mgr_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12: ,p_project_id IN NUMBER := NULL
13: ,p_check_id_flag IN VARCHAR2 := 'A'
14: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 11: ,p_task_mgr_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7:
8: procedure CHECK_TASK_MGR_NAME_OR_ID
9: (
10: p_task_mgr_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
11: ,p_task_mgr_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12: ,p_project_id IN NUMBER := NULL
13: ,p_check_id_flag IN VARCHAR2 := 'A'
14: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
15: ,x_task_mgr_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 44: IF (p_task_mgr_id IS NULL OR p_task_mgr_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

40: and trunc(sysdate) between ppp.START_DATE_ACTIVE
41: and NVL(ppp.end_date_active, SYSDATE));
42:
43: BEGIN
44: IF (p_task_mgr_id IS NULL OR p_task_mgr_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
45: -- ID is empty
46: IF (p_task_mgr_name IS NOT NULL AND p_task_mgr_name<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
47: --Added for task manager changes;
48: IF (PA_TASKS_MAINT_UTILS.GET_TASK_MANAGER_PROFILE = 'N') THEN

Line 46: IF (p_task_mgr_name IS NOT NULL AND p_task_mgr_name<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

42:
43: BEGIN
44: IF (p_task_mgr_id IS NULL OR p_task_mgr_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
45: -- ID is empty
46: IF (p_task_mgr_name IS NOT NULL AND p_task_mgr_name<> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
47: --Added for task manager changes;
48: IF (PA_TASKS_MAINT_UTILS.GET_TASK_MANAGER_PROFILE = 'N') THEN
49: --select from pa_employees
50: OPEN c;

Line 175: p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

171:
172:
173: procedure CHECK_PROJECT_NAME_OR_ID
174: (
175: p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
176: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
177: ,p_check_id_flag IN VARCHAR2 := 'A'
178: ,x_project_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
179: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 176: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

172:
173: procedure CHECK_PROJECT_NAME_OR_ID
174: (
175: p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
176: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
177: ,p_check_id_flag IN VARCHAR2 := 'A'
178: ,x_project_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
179: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 192: IF (p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

188: from pa_projects_all
189: where UPPER(name) = UPPER(p_project_name);
190:
191: BEGIN
192: IF (p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
193: -- ID is empty
194: IF (p_project_name IS NOT NULL AND p_project_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
195: OPEN c;
196: LOOP

Line 194: IF (p_project_name IS NOT NULL AND p_project_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

190:
191: BEGIN
192: IF (p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
193: -- ID is empty
194: IF (p_project_name IS NOT NULL AND p_project_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
195: OPEN c;
196: LOOP
197: FETCH c INTO l_current_id;
198: EXIT WHEN c%NOTFOUND;

Line 268: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

264: END CHECK_PROJECT_NAME_OR_ID;
265:
266: procedure CHECK_TASK_NAME_OR_ID
267: (
268: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
269: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
270: ,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
271: ,p_check_id_flag IN VARCHAR2 := 'A'
272: ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 269: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

265:
266: procedure CHECK_TASK_NAME_OR_ID
267: (
268: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
269: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
270: ,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
271: ,p_check_id_flag IN VARCHAR2 := 'A'
272: ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
273: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 270: ,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

266: procedure CHECK_TASK_NAME_OR_ID
267: (
268: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
269: ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
270: ,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
271: ,p_check_id_flag IN VARCHAR2 := 'A'
272: ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
273: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
274: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 287: IF (p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

283: from pa_tasks
284: where UPPER(task_name) = UPPER(p_task_name)
285: and project_id = p_project_id;
286: BEGIN
287: IF (p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
288: -- ID is empty
289: IF (p_task_name IS NOT NULL AND p_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
290: OPEN c;
291: LOOP

Line 289: IF (p_task_name IS NOT NULL AND p_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

285: and project_id = p_project_id;
286: BEGIN
287: IF (p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
288: -- ID is empty
289: IF (p_task_name IS NOT NULL AND p_task_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
290: OPEN c;
291: LOOP
292: FETCH c INTO l_current_id;
293: EXIT WHEN c%NOTFOUND;

Line 887: IF (p_sch_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR

883: l_f2 VARCHAR2(1);
884: l_ret VARCHAR2(1);
885:
886: BEGIN
887: IF (p_sch_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
888: p_sch_start_date IS NULL) AND
889: (p_sch_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
890: p_sch_end_date IS NULL) THEN
891: check_start_end_date(

Line 889: (p_sch_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR

885:
886: BEGIN
887: IF (p_sch_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
888: p_sch_start_date IS NULL) AND
889: (p_sch_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
890: p_sch_end_date IS NULL) THEN
891: check_start_end_date(
892: p_old_start_date => null,
893: p_old_end_date => null,

Line 961: IF (p_estimate_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR

957: l_f2 VARCHAR2(1);
958: l_ret VARCHAR2(1);
959: BEGIN
960:
961: IF (p_estimate_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
962: p_estimate_start_date IS NULL) AND
963: (p_estimate_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
964: p_estimate_end_date IS NULL) THEN
965: check_start_end_date(

Line 963: (p_estimate_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR

959: BEGIN
960:
961: IF (p_estimate_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
962: p_estimate_start_date IS NULL) AND
963: (p_estimate_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
964: p_estimate_end_date IS NULL) THEN
965: check_start_end_date(
966: p_old_start_date => null,
967: p_old_end_date => null,

Line 1010: IF (p_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR

1006: l_f2 VARCHAR2(1);
1007: l_ret VARCHAR2(1);
1008: BEGIN
1009:
1010: IF (p_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1011: p_actual_start_date IS NULL) AND
1012: (p_actual_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1013: p_actual_end_date IS NULL) THEN
1014: check_start_end_date(

Line 1012: (p_actual_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR

1008: BEGIN
1009:
1010: IF (p_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1011: p_actual_start_date IS NULL) AND
1012: (p_actual_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
1013: p_actual_end_date IS NULL) THEN
1014: check_start_end_date(
1015: p_old_start_date => null,
1016: p_old_end_date => null,

Line 1680: IF p_reference_project_id IS NULL OR p_reference_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1676: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1677: ) AS
1678: BEGIN
1679: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1680: IF p_reference_project_id IS NULL OR p_reference_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1681: THEN
1682: x_error_msg_code := 'PA_TASK_TARGET_PRJ_ID_REQ';
1683: x_return_status:= FND_API.G_RET_STS_ERROR;
1684: RAISE FND_API.G_EXC_ERROR;

Line 1687: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1683: x_return_status:= FND_API.G_RET_STS_ERROR;
1684: RAISE FND_API.G_EXC_ERROR;
1685: END IF;
1686:
1687: IF p_reference_task_id IS NULL OR p_reference_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1688: THEN
1689: x_error_msg_code := 'PA_TASK_TARGET_TASK_ID_REQ';
1690: x_return_status:= FND_API.G_RET_STS_ERROR;
1691: RAISE FND_API.G_EXC_ERROR;

Line 1723: IF p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1719: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1720: ) AS
1721: BEGIN
1722: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1723: IF p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1724: THEN
1725: x_error_msg_code := 'PA_TASK_SOURCE_PRJ_ID_REQ';
1726: x_return_status:= FND_API.G_RET_STS_ERROR;
1727: RAISE FND_API.G_EXC_ERROR;

Line 1730: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1726: x_return_status:= FND_API.G_RET_STS_ERROR;
1727: RAISE FND_API.G_EXC_ERROR;
1728: END IF;
1729:
1730: IF p_task_id IS NULL OR p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1731: THEN
1732: x_error_msg_code := 'PA_TASK_SOURCE_TASK_ID_REQ';
1733: x_return_status:= FND_API.G_RET_STS_ERROR;
1734: RAISE FND_API.G_EXC_ERROR;

Line 1770: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

1766: from pa_lookups
1767: where lookup_type = 'PA_DATE' and lookup_code = p_context;
1768: end if;
1769:
1770: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1771: AND p_new_start_date IS NOT NULL --redundant, but added for clarity
1772: THEN
1773: IF p_new_start_date <> NVL(p_old_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1774: THEN

Line 1773: IF p_new_start_date <> NVL(p_old_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1769:
1770: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1771: AND p_new_start_date IS NOT NULL --redundant, but added for clarity
1772: THEN
1773: IF p_new_start_date <> NVL(p_old_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1774: THEN
1775: p_update_start_date_flag := 'Y';
1776: l_start_date := p_new_start_date;
1777: ELSE

Line 1782: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

1778: p_update_start_date_flag := 'N';
1779: l_start_date := p_new_start_date;
1780: END IF;
1781:
1782: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1783: AND p_new_end_date IS NOT NULL --redundant, but added for clarity
1784: THEN
1785: IF p_new_end_date <> NVL(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1786: THEN

Line 1785: IF p_new_end_date <> NVL(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1781:
1782: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1783: AND p_new_end_date IS NOT NULL --redundant, but added for clarity
1784: THEN
1785: IF p_new_end_date <> NVL(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1786: THEN
1787: p_update_end_date_flag := 'Y';
1788: l_end_date := p_new_end_date;
1789: ELSE

Line 1800: pa_interface_utils_pub.map_new_amg_msg

1796: IF FND_MSG_PUB.check_msg_level
1797: (FND_MSG_PUB.G_MSG_LVL_ERROR)
1798: THEN
1799: /*
1800: pa_interface_utils_pub.map_new_amg_msg
1801: ( p_old_message_code => 'PA_INVALID_START_DATE2'
1802: ,p_msg_attribute => 'CHANGE'
1803: ,p_resize_flag => 'N'
1804: ,p_msg_context => 'GENERAL'

Line 1841: pa_interface_utils_pub.map_new_amg_msg

1837: IF l_start_date > p_old_end_date THEN
1838: IF FND_MSG_PUB.check_msg_level
1839: (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1840: /*
1841: pa_interface_utils_pub.map_new_amg_msg
1842: ( p_old_message_code => 'PA_INVALID_START_DATE2'
1843: ,p_msg_attribute => 'CHANGE'
1844: ,p_resize_flag => 'N'
1845: ,p_msg_context => 'GENERAL'

Line 1872: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

1868: ELSE
1869: p_update_start_date_flag := 'N';
1870: END IF;
1871:
1872: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1873: AND p_new_end_date IS NOT NULL
1874: THEN
1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1876: THEN

Line 1878: pa_interface_utils_pub.map_new_amg_msg

1874: THEN
1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1876: THEN
1877: /*
1878: pa_interface_utils_pub.map_new_amg_msg
1879: ( p_old_message_code => 'PA_DATES_INVALID'
1880: ,p_msg_attribute => 'CHANGE'
1881: ,p_resize_flag => 'N'
1882: ,p_msg_context => 'GENERAL'

Line 1914: pa_interface_utils_pub.map_new_amg_msg

1910: THEN
1911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1912: THEN
1913: /*
1914: pa_interface_utils_pub.map_new_amg_msg
1915: ( p_old_message_code => 'PA_DATES_INVALID'
1916: ,p_msg_attribute => 'CHANGE'
1917: ,p_resize_flag => 'N'
1918: ,p_msg_context => 'GENERAL'

Line 1940: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

1936: ELSE --p_new_start_date was not passed
1937:
1938: p_update_start_date_flag := 'N';
1939:
1940: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1941: AND p_new_end_date IS NOT NULL
1942: THEN
1943: IF p_new_end_date <> nvl(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1944: THEN

Line 1943: IF p_new_end_date <> nvl(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1939:
1940: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1941: AND p_new_end_date IS NOT NULL
1942: THEN
1943: IF p_new_end_date <> nvl(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1944: THEN
1945: p_update_end_date_flag := 'Y';
1946:
1947: IF p_old_start_date IS NULL

Line 1953: pa_interface_utils_pub.map_new_amg_msg

1949: THEN
1950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1951: THEN
1952: /*
1953: pa_interface_utils_pub.map_new_amg_msg
1954: ( p_old_message_code => 'PA_INVALID_START_DATE2'
1955: ,p_msg_attribute => 'CHANGE'
1956: ,p_resize_flag => 'N'
1957: ,p_msg_context => 'GENERAL'