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 957: /* pa_tasks_maint_utils.check_task_mgr_name_or_id(

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

Line 1023: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

1019: --Call Lock project
1020: IF p_wbs_record_version_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
1021: p_wbs_record_version_number IS NOT NULL
1022: THEN
1023: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
1024: p_validate_only => p_validate_only,
1025: p_calling_module => p_calling_module,
1026: p_project_id => p_project_id,
1027: p_wbs_record_version_number => p_wbs_record_version_number,

Line 1168: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

1164:
1165: IF p_wbs_record_version_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
1166: p_wbs_record_version_number IS NOT NULL
1167: THEN
1168: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
1169: p_project_id => p_project_id,
1170: p_wbs_record_version_number => p_wbs_record_version_number,
1171: x_return_status => x_return_status );
1172: END IF;

Line 1333: pa_tasks_maint_utils.set_org_id(p_project_id);

1329: WHERE project_id = p_project_id
1330: AND task_id = p_task_id;*/
1331:
1332: BEGIN
1333: pa_tasks_maint_utils.set_org_id(p_project_id);
1334:
1335:
1336: pa_debug.init_err_stack('PA_TASKS_MAINT_PUB.DELETE_TASK');
1337:

Line 1373: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

1369: end if;
1370:
1371: /*--Call Lock project
1372:
1373: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
1374: p_validate_only => p_validate_only,
1375: p_calling_module => p_calling_module,
1376: p_project_id => p_project_id,
1377: p_wbs_record_version_number => p_wbs_record_version_number,

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

1433:
1434: update PA_TASKS
1435: set
1436: display_sequence =
1437: PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, l_task_cnt, 'DELETE', 'DOWN'),
1438: record_version_number = record_version_number + 1
1439: where project_id = p_project_id
1440: and (display_sequence > selected_seq_num);
1441: EXCEPTION

Line 1448: /*PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

1444: raise FND_API.G_EXC_ERROR;
1445: END;*/
1446:
1447:
1448: /*PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
1449: p_project_id => p_project_id,
1450: p_wbs_record_version_number => p_wbs_record_version_number,
1451: x_return_status => x_return_status );*/
1452:

Line 1547: pa_tasks_maint_utils.set_org_id(p_project_id);

1543: l_task_id NUMBER;
1544: l_project_id NUMBER;
1545: BEGIN
1546:
1547: pa_tasks_maint_utils.set_org_id(p_project_id);
1548:
1549: -- Standard call to check for call compatibility
1550: IF (p_debug_mode = 'Y')
1551: THEN

Line 1587: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

1583: (p_project_name IS NOT NULL)) OR
1584: ((p_project_id <> FND_API.G_MISS_NUM) AND
1585: (p_project_id IS NOT NULL)) THEN
1586: --Call Check API.
1587: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
1588: p_project_id => p_project_id,
1589: p_project_name => p_project_name,
1590: x_project_id => l_project_id,
1591: x_return_status => l_return_status,

Line 1605: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

1601: (p_task_name IS NOT NULL)) OR
1602: ((p_task_id <> FND_API.G_MISS_NUM) AND
1603: (p_task_id IS NOT NULL)) THEN
1604: --Call Check API.
1605: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
1606: p_project_id => l_project_id,
1607: p_task_id => p_task_id,
1608: p_task_name => p_task_name,
1609: x_task_id => l_task_id,

Line 1623: PA_TASKS_MAINT_UTILS.SRC_PRJ_TASK_ID_REQ_CHECK(

1619: l_task_id := p_task_id;
1620: --END IF;
1621:
1622: --project and task id Required check.
1623: PA_TASKS_MAINT_UTILS.SRC_PRJ_TASK_ID_REQ_CHECK(
1624: p_project_id => l_project_id,
1625: p_task_id => l_task_id,
1626: x_return_status => l_return_status,
1627: x_error_msg_code => l_error_msg_code );

Line 1643: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

1639:
1640: --Call Lock project
1641: /* temporarily commenting for project structures
1642:
1643: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
1644: p_validate_only => p_validate_only,
1645: p_calling_module => p_calling_module,
1646: p_project_id => l_project_id,
1647: p_wbs_record_version_number => p_wbs_record_version_number,

Line 1735: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

1731: End if;
1732: RAISE FND_API.G_EXC_ERROR;
1733: End if;
1734:
1735: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
1736: p_project_id => p_project_id,
1737: p_wbs_record_version_number => p_wbs_record_version_number,
1738: x_return_status => x_return_status );
1739:

Line 1851: pa_tasks_maint_utils.set_org_id(p_project_id);

1847: l_ref_task_id NUMBER;
1848:
1849: BEGIN
1850:
1851: pa_tasks_maint_utils.set_org_id(p_project_id);
1852:
1853: -- Standard call to check for call compatibility
1854: IF (p_debug_mode = 'Y')
1855: THEN

Line 1887: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

1883: (p_project_name IS NOT NULL)) OR
1884: ((p_project_id <> FND_API.G_MISS_NUM) AND
1885: (p_project_id IS NOT NULL)) THEN
1886: --Call Check API.
1887: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
1888: p_project_id => p_project_id,
1889: p_project_name => p_project_name,
1890: x_project_id => l_project_id,
1891: x_return_status => l_return_status,

Line 1907: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

1903: (p_task_name IS NOT NULL)) OR
1904: ((p_task_id <> FND_API.G_MISS_NUM) AND
1905: (p_task_id IS NOT NULL)) THEN
1906: --Call Check API.
1907: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
1908: p_project_id => l_project_id,
1909: p_task_id => p_task_id,
1910: p_task_name => p_task_name,
1911: x_task_id => l_task_id,

Line 1928: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

1924: (p_reference_project_name IS NOT NULL)) OR
1925: ((p_reference_project_id <> FND_API.G_MISS_NUM) AND
1926: (p_reference_project_id IS NOT NULL)) THEN
1927: --Call Check API.
1928: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
1929: p_project_id => p_reference_project_id,
1930: p_project_name => p_reference_project_name,
1931: x_project_id => l_ref_project_id,
1932: x_return_status => l_return_status,

Line 1948: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

1944: (p_reference_task_name IS NOT NULL)) OR
1945: ((p_reference_task_id <> FND_API.G_MISS_NUM) AND
1946: (p_reference_task_id IS NOT NULL)) THEN
1947: --Call Check API.
1948: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
1949: p_project_id => l_ref_project_id,
1950: p_task_id => p_reference_task_id,
1951: p_task_name => p_reference_task_name,
1952: x_task_id => l_ref_task_id,

Line 1976: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

1972:
1973: /* temporarily commenting for project structures
1974:
1975: --Call Lock project
1976: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
1977: p_validate_only => p_validate_only,
1978: p_calling_module => p_calling_module,
1979: p_project_id => l_ref_project_id,
1980: p_wbs_record_version_number => p_wbs_record_version_number,

Line 2063: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

2059: End if;
2060: RAISE FND_API.G_EXC_ERROR;
2061: End if;
2062:
2063: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
2064: p_project_id => l_ref_project_id,
2065: p_wbs_record_version_number => p_wbs_record_version_number,
2066: x_return_status => x_return_status );
2067:

Line 2185: pa_tasks_maint_utils.set_org_id(p_project_id);

2181: l_ref_task_id NUMBER;
2182:
2183: BEGIN
2184:
2185: pa_tasks_maint_utils.set_org_id(p_project_id);
2186: -- Standard call to check for call compatibility
2187: IF (p_debug_mode = 'Y')
2188: THEN
2189: pa_debug.debug('Copy Task PUB : Checking the api version number.');

Line 2218: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

2214: (p_project_name IS NOT NULL)) OR
2215: ((p_project_id <> FND_API.G_MISS_NUM) AND
2216: (p_project_id IS NOT NULL)) THEN
2217: --Call Check API.
2218: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
2219: p_project_id => p_project_id,
2220: p_project_name => p_project_name,
2221: p_check_id_flag => 'Y', -- Bug 2623999
2222: x_project_id => l_project_id,

Line 2237: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

2233: (p_task_name IS NOT NULL)) OR
2234: ((p_task_id <> FND_API.G_MISS_NUM) AND
2235: (p_task_id IS NOT NULL)) THEN
2236: --Call Check API.
2237: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
2238: p_project_id => l_project_id,
2239: p_task_id => p_task_id,
2240: p_check_id_flag => 'Y', -- Bug 2623999
2241: p_task_name => p_task_name,

Line 2258: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(

2254: (p_reference_project_name IS NOT NULL)) OR
2255: ((p_reference_project_id <> FND_API.G_MISS_NUM) AND
2256: (p_reference_project_id IS NOT NULL)) THEN
2257: --Call Check API.
2258: pa_tasks_maint_utils.CHECK_PROJECT_NAME_OR_ID(
2259: p_project_id => p_reference_project_id,
2260: p_project_name => p_reference_project_name,
2261: x_project_id => l_ref_project_id,
2262: x_return_status => l_return_status,

Line 2276: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(

2272: (p_reference_task_name IS NOT NULL)) OR
2273: ((p_reference_task_id <> FND_API.G_MISS_NUM) AND
2274: (p_reference_task_id IS NOT NULL)) THEN
2275: --Call Check API.
2276: pa_tasks_maint_utils.CHECK_TASK_NAME_OR_ID(
2277: p_project_id => l_ref_project_id,
2278: p_task_id => p_reference_task_id,
2279: p_task_name => p_reference_task_name,
2280: x_task_id => l_ref_task_id,

Line 2297: PA_TASKS_MAINT_UTILS.REF_PRJ_TASK_ID_REQ_CHECK(

2293: l_ref_project_id := p_reference_project_id;
2294: l_ref_task_id := p_reference_task_id;
2295:
2296: --Ref project and task id Required check.
2297: PA_TASKS_MAINT_UTILS.REF_PRJ_TASK_ID_REQ_CHECK(
2298: p_reference_project_id => l_ref_project_id,
2299: p_reference_task_id => l_ref_task_id,
2300: x_return_status => l_return_status,
2301: x_error_msg_code => l_error_msg_code );

Line 2316: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(

2312:
2313: /* temporarily commenting for project structures
2314:
2315: --Call Lock project
2316: PA_TASKS_MAINT_UTILS.LOCK_PROJECT(
2317: p_validate_only => p_validate_only,
2318: p_calling_module => p_calling_module,
2319: p_project_id => l_ref_project_id,
2320: p_wbs_record_version_number => p_wbs_record_version_number,

Line 2408: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(

2404: End if;
2405: RAISE FND_API.G_EXC_ERROR;
2406: End if;
2407:
2408: PA_TASKS_MAINT_UTILS.INCREMENT_WBS_REC_VER_NUM(
2409: p_project_id => l_ref_project_id,
2410: p_wbs_record_version_number => p_wbs_record_version_number,
2411: x_return_status => x_return_status );
2412: