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_ALLOC_RUN dependencies on PA_TASK_UTILS

Line 1215: || ' pa_task_utils.check_child_exists(:lp_task_id)=0) OR '

1211: l_class_catg_str:= ' pc.class_category = :lp_class_category ' ;
1212: l_class_code_str:= ' pc.class_code = :lp_class_code ' ;
1213: l_proj_id_str := ' pp.project_id = :lp_project_id ' ;
1214: l_task_id_str := ' ( (pt.task_id = :lp_task_id AND '
1215: || ' pa_task_utils.check_child_exists(:lp_task_id)=0) OR '
1216: || ' (pt.top_task_id = :lp_task_id AND pt.task_id in '
1217: || ' (select pt1.task_id FROM pa_tasks pt1 '
1218: || ' WHERE pt1.top_task_id = :lp_task_id '
1219: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;

Line 1219: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;

1215: || ' pa_task_utils.check_child_exists(:lp_task_id)=0) OR '
1216: || ' (pt.top_task_id = :lp_task_id AND pt.task_id in '
1217: || ' (select pt1.task_id FROM pa_tasks pt1 '
1218: || ' WHERE pt1.top_task_id = :lp_task_id '
1219: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1220: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1221: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1222: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1223: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;

Line 1226: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;

1222: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1223: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1224: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1225: --l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ; commented as part of the bug 13949738
1226: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;
1227: IF p_project_org_id is NOT NULL THEN
1228: l_where_str0 := l_where_str0 || l_proj_org_str || ' AND ' ;
1229: -- l_where_str0 := l_where_str0 || l_proj_org_str ;
1230: END IF ;

Line 1298: AND pa_task_utils.check_child_exists(task_id) = 0;

1294: CURSOR c_leaf_tasks_under_task(p_tsk_id IN NUMBER) IS
1295: SELECT task_id
1296: FROM pa_tasks
1297: WHERE top_task_id = p_tsk_id
1298: AND pa_task_utils.check_child_exists(task_id) = 0;
1299: leaf_task_rec c_leaf_tasks_under_task%ROWTYPE;
1300: CURSOR c_leaf_tasks_under_proj(p_proj_id IN NUMBER) IS
1301: SELECT task_id
1302: FROM pa_tasks

Line 1304: AND pa_task_utils.check_child_exists(task_id) = 0;

1300: CURSOR c_leaf_tasks_under_proj(p_proj_id IN NUMBER) IS
1301: SELECT task_id
1302: FROM pa_tasks
1303: WHERE project_id = p_proj_id
1304: AND pa_task_utils.check_child_exists(task_id) = 0;
1305: CURSOR c_alloc_run_src_projects IS
1306: SELECT project_id, task_id
1307: FROM pa_alloc_run_sources
1308: WHERE rule_id = p_rule_id

Line 1405: IF( pa_task_utils.check_child_exists(v_cx_task_id) = 0) THEN

1401: , G_last_updated_by
1402: , G_last_update_login );
1403: ELSE /* v_cx_task_id is NOT NULL i.e. a valid task_id */
1404: /* check if lowest level task */
1405: IF( pa_task_utils.check_child_exists(v_cx_task_id) = 0) THEN
1406: /* if lowest level task */
1407: IF (exclude_curr_proj_task( p_run_id, 'SRC', v_cx_project_id
1408: , v_cx_task_id ) = 0) THEN
1409: /* include current project/task, so insert... */

Line 1450: END IF; /* pa_task_utils */

1446: , G_last_update_login );
1447: END IF; /* exclude_curr_proj_task */
1448: END LOOP;
1449: END IF; /* top_task */
1450: END IF; /* pa_task_utils */
1451: END IF; /* end v_cx_task_id */
1452: END IF; /* if v_cx_project_id = 0 */
1453: END IF; /* end exclude_flag = 'Y' */
1454: END LOOP;

Line 1601: IF( pa_task_utils.check_child_exists(v_cx_task_id) = 0) THEN

1597: END IF ;
1598: END LOOP ;
1599: ELSE /* v_cx_task_id is NOT NULL */
1600: -- check if lowest level task
1601: IF( pa_task_utils.check_child_exists(v_cx_task_id) = 0) THEN
1602: IF (exclude_curr_proj_task( p_run_id, 'SRC', v_cx_project_id
1603: , v_cx_task_id ) = 0) THEN
1604: /* include current project/task, so insert... */
1605: insert_alloc_run_sources( p_rule_id

Line 1646: END IF; /* end pa_task_utils */

1642: , G_last_update_login );
1643: END IF; /* exclude_curr_proj */
1644: END LOOP;
1645: END IF; /* if v_top_task_id */
1646: END IF; /* end pa_task_utils */
1647: END IF; /* v_cx_task_id = 0 */
1648: END IF; /* v_cx_project_id <> 0 */
1649: END IF; /* end exclude_flag = 'N' */
1650: END LOOP;

Line 1727: IF( pa_task_utils.check_child_exists(v_src_task_id)= 0) THEN

1723: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||
1724: to_char(v_src_top_task_id));
1725: END IF;
1726: -- check if lowest level task
1727: IF( pa_task_utils.check_child_exists(v_src_task_id)= 0) THEN
1728: /* if lowest level task */
1729: IF (exclude_curr_proj_task( p_run_id, 'SRC', v_src_project_id
1730: , v_src_task_id ) = 0) THEN
1731: /* include current project/task, so insert */

Line 1770: END IF; /* end pa_task_utils */

1766: , G_last_update_login );
1767: END IF; /* exclude_curr_proj */
1768: END LOOP; /* End of leaf_task_rec */
1769: END IF; /* if v_top_task */
1770: END IF; /* end pa_task_utils */
1771: END LOOP; /* end alloc_sources for loop - Dyn sql*/
1772: END IF; /* end exclude_flag = 'N' */
1773: END LOOP; /* alloc_source_lines */
1774: DBMS_SQL.CLOSE_CURSOR(v_source_csr_id ); --added for bug 3799389

Line 2207: (pa_task_utils.check_child_exists(v_cx_task_id)= 0)) THEN

2203: v_cx_err_flag := 'Y' ;
2204: END IF;
2205: IF (v_cx_err_flag = 'N' AND v_cx_exclude_flag = 'Y') THEN
2206: IF (v_cx_task_id is NULL OR
2207: (pa_task_utils.check_child_exists(v_cx_task_id)= 0)) THEN
2208: insert_alloc_run_targets( p_rule_id, p_run_id
2209: , (I * -1) /* line_num */
2210: , v_cx_project_id
2211: , v_cx_task_id

Line 2339: IF( pa_task_utils.check_child_exists(v_cx_task_id)= 0) THEN

2335: IF v_cx_exclude_flag = 'N' THEN
2336: IF (v_cx_project_id <> 0 ) THEN
2337: IF ( v_cx_task_id IS NOT NULL ) THEN /* if task_id is NOT NULL */
2338: /* check if lowest level task */
2339: IF( pa_task_utils.check_child_exists(v_cx_task_id)= 0) THEN
2340: /* if lowest level chargeable task */
2341: IF (exclude_curr_proj_task( p_run_id, 'TRG', v_cx_project_id
2342: , v_cx_task_id ) = 0) THEN
2343: /* include current project/task, so insert... */

Line 2364: END IF; /* pa_task_utils */

2360: alloc_errors( p_rule_id, p_run_id, 'T', 'E',
2361: 'PA_AL_NOT_A_CHARGEABLE_TASK',FALSE,'Y',
2362: v_cx_project_id,
2363: v_cx_task_id );
2364: END IF; /* pa_task_utils */
2365: ELSE
2366: FOR chargeable_tasks in c_chargeable_tasks_in_proj(v_cx_project_id
2367: ,p_expnd_item_date)
2368: LOOP