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 1207: || ' pa_task_utils.check_child_exists(:lp_task_id)=0) OR '

1203: l_class_catg_str:= ' pc.class_category = :lp_class_category ' ;
1204: l_class_code_str:= ' pc.class_code = :lp_class_code ' ;
1205: l_proj_id_str := ' pp.project_id = :lp_project_id ' ;
1206: l_task_id_str := ' ( (pt.task_id = :lp_task_id AND '
1207: || ' pa_task_utils.check_child_exists(:lp_task_id)=0) OR '
1208: || ' (pt.top_task_id = :lp_task_id AND pt.task_id in '
1209: || ' (select pt1.task_id FROM pa_tasks pt1 '
1210: || ' WHERE pt1.top_task_id = :lp_task_id '
1211: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;

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

1207: || ' pa_task_utils.check_child_exists(:lp_task_id)=0) OR '
1208: || ' (pt.top_task_id = :lp_task_id AND pt.task_id in '
1209: || ' (select pt1.task_id FROM pa_tasks pt1 '
1210: || ' WHERE pt1.top_task_id = :lp_task_id '
1211: || ' AND pa_task_utils.check_child_exists(pt1.task_id)=0 )))' ;
1212: l_select_clause := 'Select pt.project_id, pt.task_id, pt.top_task_id ' ;
1213: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1214: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1215: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;

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

1214: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1215: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1216: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1217: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ;
1218: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;
1219: IF p_project_org_id is NOT NULL THEN
1220: l_where_str0 := l_where_str0 || l_proj_org_str || ' AND ' ;
1221: -- l_where_str0 := l_where_str0 || l_proj_org_str ;
1222: END IF ;

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

1284: CURSOR c_leaf_tasks_under_task(p_tsk_id IN NUMBER) IS
1285: SELECT task_id
1286: FROM pa_tasks
1287: WHERE top_task_id = p_tsk_id
1288: AND pa_task_utils.check_child_exists(task_id) = 0;
1289: leaf_task_rec c_leaf_tasks_under_task%ROWTYPE;
1290: CURSOR c_leaf_tasks_under_proj(p_proj_id IN NUMBER) IS
1291: SELECT task_id
1292: FROM pa_tasks

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

1290: CURSOR c_leaf_tasks_under_proj(p_proj_id IN NUMBER) IS
1291: SELECT task_id
1292: FROM pa_tasks
1293: WHERE project_id = p_proj_id
1294: AND pa_task_utils.check_child_exists(task_id) = 0;
1295: CURSOR c_alloc_run_src_projects IS
1296: SELECT project_id, task_id
1297: FROM pa_alloc_run_sources
1298: WHERE rule_id = p_rule_id

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

1391: , G_last_updated_by
1392: , G_last_update_login );
1393: ELSE /* v_cx_task_id is NOT NULL i.e. a valid task_id */
1394: /* check if lowest level task */
1395: IF( pa_task_utils.check_child_exists(v_cx_task_id) = 0) THEN
1396: /* if lowest level task */
1397: IF (exclude_curr_proj_task( p_run_id, 'SRC', v_cx_project_id
1398: , v_cx_task_id ) = 0) THEN
1399: /* include current project/task, so insert... */

Line 1440: END IF; /* pa_task_utils */

1436: , G_last_update_login );
1437: END IF; /* exclude_curr_proj_task */
1438: END LOOP;
1439: END IF; /* top_task */
1440: END IF; /* pa_task_utils */
1441: END IF; /* end v_cx_task_id */
1442: END IF; /* if v_cx_project_id = 0 */
1443: END IF; /* end exclude_flag = 'Y' */
1444: END LOOP;

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

1587: END IF ;
1588: END LOOP ;
1589: ELSE /* v_cx_task_id is NOT NULL */
1590: -- check if lowest level task
1591: IF( pa_task_utils.check_child_exists(v_cx_task_id) = 0) THEN
1592: IF (exclude_curr_proj_task( p_run_id, 'SRC', v_cx_project_id
1593: , v_cx_task_id ) = 0) THEN
1594: /* include current project/task, so insert... */
1595: insert_alloc_run_sources( p_rule_id

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

1632: , G_last_update_login );
1633: END IF; /* exclude_curr_proj */
1634: END LOOP;
1635: END IF; /* if v_top_task_id */
1636: END IF; /* end pa_task_utils */
1637: END IF; /* v_cx_task_id = 0 */
1638: END IF; /* v_cx_project_id <> 0 */
1639: END IF; /* end exclude_flag = 'N' */
1640: END LOOP;

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

1713: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||
1714: to_char(v_src_top_task_id));
1715: END IF;
1716: -- check if lowest level task
1717: IF( pa_task_utils.check_child_exists(v_src_task_id)= 0) THEN
1718: /* if lowest level task */
1719: IF (exclude_curr_proj_task( p_run_id, 'SRC', v_src_project_id
1720: , v_src_task_id ) = 0) THEN
1721: /* include current project/task, so insert */

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

1756: , G_last_update_login );
1757: END IF; /* exclude_curr_proj */
1758: END LOOP; /* End of leaf_task_rec */
1759: END IF; /* if v_top_task */
1760: END IF; /* end pa_task_utils */
1761: END LOOP; /* end alloc_sources for loop - Dyn sql*/
1762: END IF; /* end exclude_flag = 'N' */
1763: END LOOP; /* alloc_source_lines */
1764: DBMS_SQL.CLOSE_CURSOR(v_source_csr_id ); --added for bug 3799389

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

2193: v_cx_err_flag := 'Y' ;
2194: END IF;
2195: IF (v_cx_err_flag = 'N' AND v_cx_exclude_flag = 'Y') THEN
2196: IF (v_cx_task_id is NULL OR
2197: (pa_task_utils.check_child_exists(v_cx_task_id)= 0)) THEN
2198: insert_alloc_run_targets( p_rule_id, p_run_id
2199: , (I * -1) /* line_num */
2200: , v_cx_project_id
2201: , v_cx_task_id

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

2325: IF v_cx_exclude_flag = 'N' THEN
2326: IF (v_cx_project_id <> 0 ) THEN
2327: IF ( v_cx_task_id IS NOT NULL ) THEN /* if task_id is NOT NULL */
2328: /* check if lowest level task */
2329: IF( pa_task_utils.check_child_exists(v_cx_task_id)= 0) THEN
2330: /* if lowest level chargeable task */
2331: IF (exclude_curr_proj_task( p_run_id, 'TRG', v_cx_project_id
2332: , v_cx_task_id ) = 0) THEN
2333: /* include current project/task, so insert... */

Line 2354: END IF; /* pa_task_utils */

2350: alloc_errors( p_rule_id, p_run_id, 'T', 'E',
2351: 'PA_AL_NOT_A_CHARGEABLE_TASK',FALSE,'Y',
2352: v_cx_project_id,
2353: v_cx_task_id );
2354: END IF; /* pa_task_utils */
2355: ELSE
2356: FOR chargeable_tasks in c_chargeable_tasks_in_proj(v_cx_project_id
2357: ,p_expnd_item_date)
2358: LOOP