DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PUB dependencies on PA_TASKS_MAINT_UTILS

Line 271: pa_tasks_maint_utils.set_org_id(p_project_id);

267: l_carrying_out_org_name VARCHAR2(250);
268:
269: BEGIN
270:
271: pa_tasks_maint_utils.set_org_id(p_project_id);
272:
273: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.CREATE_TASK');
274:
275: IF (p_debug_mode = 'Y') THEN

Line 303: /* pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

299: ((p_reference_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
300: (p_reference_task_id IS NOT NULL)) THEN
301:
302: --Call Check API.
303: /* pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
304: p_project_id => p_project_id,
305: p_task_name => p_reference_task_name,
306: p_task_id => p_reference_task_id,
307: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 328: /* pa_tasks_maint_utils.check_task_mgr_name_or_id(

324: ((p_task_manager_person_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
325: (p_task_manager_person_id IS NOT NULL)) THEN
326: --Call Check API.
327:
328: /* pa_tasks_maint_utils.check_task_mgr_name_or_id(
329: p_task_mgr_name => p_task_manager_name,
330: p_task_mgr_id => p_task_manager_person_id,
331: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
332: x_task_mgr_id => l_task_manager_id,

Line 410: /* PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

406:
407: --dbms_output.put_line( 'Call Lock project ' );
408:
409: --Call Lock project
410: /* PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
411: p_validate_only => p_validate_only,
412: p_calling_module => p_calling_module,
413: p_project_id => p_project_id,
414: p_wbs_record_version_number => p_wbs_record_version_number,

Line 572: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, 1, 'INSERT', 'DOWN'),

568:
569: update PA_TASKS
570: set
571: display_sequence =
572: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, 1, 'INSERT', 'DOWN'),
573: record_version_number = record_version_number + 1
574: where project_id = p_project_id
575: and (display_sequence > -(l_display_seq+1) or display_sequence < 0);
576: HY */ NULL;

Line 585: /* PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

581: END;
582:
583: --dbms_output.put_line( 'Before INCREMENT_WBS_REC_VER_NUM' );
584:
585: /* PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
586: p_project_id => p_project_id,
587: p_wbs_record_version_number => p_wbs_record_version_number,
588: x_return_status => x_return_status );*/
589:

Line 927: pa_tasks_maint_utils.set_org_id(p_project_id);

923: l_parent_task_id_tbl l_parent_task_id_tbl_type;
924: l_parent_task_date DATE;
925:
926: BEGIN
927: pa_tasks_maint_utils.set_org_id(p_project_id);
928:
929: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.UPDATE_TASK');
930:
931: IF (p_debug_mode = 'Y') THEN

Line 960: -- /* pa_tasks_maint_utils.check_task_mgr_name_or_id(

956: -- ((p_task_manager_person_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
957: -- (p_task_manager_person_id IS NOT NULL)) THEN
958: -- --Call Check API.
959: --
960: -- /* pa_tasks_maint_utils.check_task_mgr_name_or_id(
961: -- p_task_mgr_name => p_task_manager_name,
962: -- p_task_mgr_id => p_task_manager_person_id,
963: -- x_task_mgr_id => l_task_manager_id,
964: -- x_return_status => l_return_status,

Line 1031: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

1027: --Call Lock project
1028: IF p_wbs_record_version_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
1029: p_wbs_record_version_number IS NOT NULL
1030: THEN
1031: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
1032: p_validate_only => p_validate_only,
1033: p_calling_module => p_calling_module,
1034: p_project_id => p_project_id,
1035: p_wbs_record_version_number => p_wbs_record_version_number,

Line 1176: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

1172:
1173: IF p_wbs_record_version_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
1174: p_wbs_record_version_number IS NOT NULL
1175: THEN
1176: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
1177: p_project_id => p_project_id,
1178: p_wbs_record_version_number => p_wbs_record_version_number,
1179: x_return_status => x_return_status );
1180: END IF;

Line 1341: pa_tasks_maint_utils.set_org_id(p_project_id);

1337: WHERE project_id = p_project_id
1338: AND task_id = p_task_id;*/
1339:
1340: BEGIN
1341: pa_tasks_maint_utils.set_org_id(p_project_id);
1342:
1343:
1344: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.DELETE_TASK');
1345:

Line 1381: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

1377: end if;
1378:
1379: /*--Call Lock project
1380:
1381: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
1382: p_validate_only => p_validate_only,
1383: p_calling_module => p_calling_module,
1384: p_project_id => p_project_id,
1385: p_wbs_record_version_number => p_wbs_record_version_number,

Line 1445: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, l_task_cnt, 'DELETE', 'DOWN'),

1441:
1442: update PA_TASKS
1443: set
1444: display_sequence =
1445: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, l_task_cnt, 'DELETE', 'DOWN'),
1446: record_version_number = record_version_number + 1
1447: where project_id = p_project_id
1448: and (display_sequence > selected_seq_num);
1449: EXCEPTION

Line 1456: /*PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

1452: raise FND_API.G_EXC_ERROR;
1453: END;*/
1454:
1455:
1456: /*PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
1457: p_project_id => p_project_id,
1458: p_wbs_record_version_number => p_wbs_record_version_number,
1459: x_return_status => x_return_status );*/
1460:

Line 1555: pa_tasks_maint_utils.set_org_id(p_project_id);

1551: l_task_id NUMBER;
1552: l_project_id NUMBER;
1553: BEGIN
1554:
1555: pa_tasks_maint_utils.set_org_id(p_project_id);
1556:
1557: -- Standard call to check for call compatibility
1558: IF (p_debug_mode = 'Y')
1559: THEN

Line 1595: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

1591: (p_project_name IS NOT NULL)) OR
1592: ((p_project_id <> FND_API.G_MISS_NUM) AND
1593: (p_project_id IS NOT NULL)) THEN
1594: --Call Check API.
1595: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
1596: p_project_id => p_project_id,
1597: p_project_name => p_project_name,
1598: x_project_id => l_project_id,
1599: x_return_status => l_return_status,

Line 1613: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

1609: (p_task_name IS NOT NULL)) OR
1610: ((p_task_id <> FND_API.G_MISS_NUM) AND
1611: (p_task_id IS NOT NULL)) THEN
1612: --Call Check API.
1613: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
1614: p_project_id => l_project_id,
1615: p_task_id => p_task_id,
1616: p_task_name => p_task_name,
1617: x_task_id => l_task_id,

Line 1631: PA_TASKS_MAINT_UTILS.SRC_PRJ_TASK_ID_REQ_CHECK(

1627: l_task_id := p_task_id;
1628: --END IF;
1629:
1630: --project and task id Required check.
1631: PA_TASKS_MAINT_UTILS.SRC_PRJ_TASK_ID_REQ_CHECK(
1632: p_project_id => l_project_id,
1633: p_task_id => l_task_id,
1634: x_return_status => l_return_status,
1635: x_error_msg_code => l_error_msg_code );

Line 1651: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

1647:
1648: --Call Lock project
1649: /* temporarily commenting for project structures
1650:
1651: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
1652: p_validate_only => p_validate_only,
1653: p_calling_module => p_calling_module,
1654: p_project_id => l_project_id,
1655: p_wbs_record_version_number => p_wbs_record_version_number,

Line 1743: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

1739: End if;
1740: RAISE FND_API.G_EXC_ERROR;
1741: End if;
1742:
1743: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
1744: p_project_id => p_project_id,
1745: p_wbs_record_version_number => p_wbs_record_version_number,
1746: x_return_status => x_return_status );
1747:

Line 1859: pa_tasks_maint_utils.set_org_id(p_project_id);

1855: l_ref_task_id NUMBER;
1856:
1857: BEGIN
1858:
1859: pa_tasks_maint_utils.set_org_id(p_project_id);
1860:
1861: -- Standard call to check for call compatibility
1862: IF (p_debug_mode = 'Y')
1863: THEN

Line 1895: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

1891: (p_project_name IS NOT NULL)) OR
1892: ((p_project_id <> FND_API.G_MISS_NUM) AND
1893: (p_project_id IS NOT NULL)) THEN
1894: --Call Check API.
1895: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
1896: p_project_id => p_project_id,
1897: p_project_name => p_project_name,
1898: x_project_id => l_project_id,
1899: x_return_status => l_return_status,

Line 1915: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

1911: (p_task_name IS NOT NULL)) OR
1912: ((p_task_id <> FND_API.G_MISS_NUM) AND
1913: (p_task_id IS NOT NULL)) THEN
1914: --Call Check API.
1915: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
1916: p_project_id => l_project_id,
1917: p_task_id => p_task_id,
1918: p_task_name => p_task_name,
1919: x_task_id => l_task_id,

Line 1936: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

1932: (p_reference_project_name IS NOT NULL)) OR
1933: ((p_reference_project_id <> FND_API.G_MISS_NUM) AND
1934: (p_reference_project_id IS NOT NULL)) THEN
1935: --Call Check API.
1936: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
1937: p_project_id => p_reference_project_id,
1938: p_project_name => p_reference_project_name,
1939: x_project_id => l_ref_project_id,
1940: x_return_status => l_return_status,

Line 1956: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

1952: (p_reference_task_name IS NOT NULL)) OR
1953: ((p_reference_task_id <> FND_API.G_MISS_NUM) AND
1954: (p_reference_task_id IS NOT NULL)) THEN
1955: --Call Check API.
1956: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
1957: p_project_id => l_ref_project_id,
1958: p_task_id => p_reference_task_id,
1959: p_task_name => p_reference_task_name,
1960: x_task_id => l_ref_task_id,

Line 1984: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

1980:
1981: /* temporarily commenting for project structures
1982:
1983: --Call Lock project
1984: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
1985: p_validate_only => p_validate_only,
1986: p_calling_module => p_calling_module,
1987: p_project_id => l_ref_project_id,
1988: p_wbs_record_version_number => p_wbs_record_version_number,

Line 2071: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

2067: End if;
2068: RAISE FND_API.G_EXC_ERROR;
2069: End if;
2070:
2071: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
2072: p_project_id => l_ref_project_id,
2073: p_wbs_record_version_number => p_wbs_record_version_number,
2074: x_return_status => x_return_status );
2075:

Line 2193: pa_tasks_maint_utils.set_org_id(p_project_id);

2189: l_ref_task_id NUMBER;
2190:
2191: BEGIN
2192:
2193: pa_tasks_maint_utils.set_org_id(p_project_id);
2194: -- Standard call to check for call compatibility
2195: IF (p_debug_mode = 'Y')
2196: THEN
2197: pa_debug.debug('Copy Task PUB : Checking the api version number.');

Line 2226: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

2222: (p_project_name IS NOT NULL)) OR
2223: ((p_project_id <> FND_API.G_MISS_NUM) AND
2224: (p_project_id IS NOT NULL)) THEN
2225: --Call Check API.
2226: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
2227: p_project_id => p_project_id,
2228: p_project_name => p_project_name,
2229: p_check_id_flag => 'Y', -- Bug 2623999
2230: x_project_id => l_project_id,

Line 2245: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

2241: (p_task_name IS NOT NULL)) OR
2242: ((p_task_id <> FND_API.G_MISS_NUM) AND
2243: (p_task_id IS NOT NULL)) THEN
2244: --Call Check API.
2245: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
2246: p_project_id => l_project_id,
2247: p_task_id => p_task_id,
2248: p_check_id_flag => 'Y', -- Bug 2623999
2249: p_task_name => p_task_name,

Line 2266: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

2262: (p_reference_project_name IS NOT NULL)) OR
2263: ((p_reference_project_id <> FND_API.G_MISS_NUM) AND
2264: (p_reference_project_id IS NOT NULL)) THEN
2265: --Call Check API.
2266: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
2267: p_project_id => p_reference_project_id,
2268: p_project_name => p_reference_project_name,
2269: x_project_id => l_ref_project_id,
2270: x_return_status => l_return_status,

Line 2284: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

2280: (p_reference_task_name IS NOT NULL)) OR
2281: ((p_reference_task_id <> FND_API.G_MISS_NUM) AND
2282: (p_reference_task_id IS NOT NULL)) THEN
2283: --Call Check API.
2284: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
2285: p_project_id => l_ref_project_id,
2286: p_task_id => p_reference_task_id,
2287: p_task_name => p_reference_task_name,
2288: x_task_id => l_ref_task_id,

Line 2305: PA_TASKS_MAINT_UTILS.REF_PRJ_TASK_ID_REQ_CHECK(

2301: l_ref_project_id := p_reference_project_id;
2302: l_ref_task_id := p_reference_task_id;
2303:
2304: --Ref project and task id Required check.
2305: PA_TASKS_MAINT_UTILS.REF_PRJ_TASK_ID_REQ_CHECK(
2306: p_reference_project_id => l_ref_project_id,
2307: p_reference_task_id => l_ref_task_id,
2308: x_return_status => l_return_status,
2309: x_error_msg_code => l_error_msg_code );

Line 2324: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

2320:
2321: /* temporarily commenting for project structures
2322:
2323: --Call Lock project
2324: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
2325: p_validate_only => p_validate_only,
2326: p_calling_module => p_calling_module,
2327: p_project_id => l_ref_project_id,
2328: p_wbs_record_version_number => p_wbs_record_version_number,

Line 2416: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

2412: End if;
2413: RAISE FND_API.G_EXC_ERROR;
2414: End if;
2415:
2416: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
2417: p_project_id => l_ref_project_id,
2418: p_wbs_record_version_number => p_wbs_record_version_number,
2419: x_return_status => x_return_status );
2420: