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 DBMS_SQL

Line 1451: v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; -- added for bug 3799389

1447: pa_debug.G_err_stage:= 'READING SRC LINES FOR EXCLUDES';
1448: IF P_DEBUG_MODE = 'Y' THEN
1449: pa_debug.write_file('populate_run_sources: ' || 'LOG', pa_debug.G_err_stage);
1450: END IF;
1451: v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; -- added for bug 3799389
1452:
1453: FOR source_lines_rec IN c_alloc_source_lines LOOP
1454: IF (source_lines_rec.exclude_flag = 'Y') THEN
1455: build_src_sql( source_lines_rec.project_org_id

Line 1467: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */

1463: , v_src_sql_str ) ;
1464: IF P_DEBUG_MODE = 'Y' THEN
1465: pa_debug.write_file('populate_run_sources: ' || 'LOG',v_src_sql_str);
1466: END IF;
1467: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1468: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;
1469: IF source_lines_rec.project_org_id is NOT NULL THEN
1470: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1471: END IF ;

Line 1468: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;

1464: IF P_DEBUG_MODE = 'Y' THEN
1465: pa_debug.write_file('populate_run_sources: ' || 'LOG',v_src_sql_str);
1466: END IF;
1467: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1468: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;
1469: IF source_lines_rec.project_org_id is NOT NULL THEN
1470: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1471: END IF ;
1472: IF source_lines_rec.project_type is NOT NULL THEN

Line 1470: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;

1466: END IF;
1467: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1468: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;
1469: IF source_lines_rec.project_org_id is NOT NULL THEN
1470: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1471: END IF ;
1472: IF source_lines_rec.project_type is NOT NULL THEN
1473: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1474: END IF ;

Line 1473: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;

1469: IF source_lines_rec.project_org_id is NOT NULL THEN
1470: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1471: END IF ;
1472: IF source_lines_rec.project_type is NOT NULL THEN
1473: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1474: END IF ;
1475: IF source_lines_rec.task_org_id is NOT NULL THEN
1476: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1477: END IF ;

Line 1476: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;

1472: IF source_lines_rec.project_type is NOT NULL THEN
1473: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1474: END IF ;
1475: IF source_lines_rec.task_org_id is NOT NULL THEN
1476: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1477: END IF ;
1478: IF source_lines_rec.service_type is NOT NULL THEN
1479: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1480: END IF ;

Line 1479: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;

1475: IF source_lines_rec.task_org_id is NOT NULL THEN
1476: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1477: END IF ;
1478: IF source_lines_rec.service_type is NOT NULL THEN
1479: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1480: END IF ;
1481: IF source_lines_rec.class_category is NOT NULL THEN
1482: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1483: END IF ;

Line 1482: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;

1478: IF source_lines_rec.service_type is NOT NULL THEN
1479: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1480: END IF ;
1481: IF source_lines_rec.class_category is NOT NULL THEN
1482: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1483: END IF ;
1484: IF source_lines_rec.class_code is NOT NULL THEN
1485: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1486: END IF ;

Line 1485: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;

1481: IF source_lines_rec.class_category is NOT NULL THEN
1482: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1483: END IF ;
1484: IF source_lines_rec.class_code is NOT NULL THEN
1485: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1486: END IF ;
1487: IF source_lines_rec.project_id is NOT NULL THEN
1488: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1489: END IF ;

Line 1488: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;

1484: IF source_lines_rec.class_code is NOT NULL THEN
1485: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1486: END IF ;
1487: IF source_lines_rec.project_id is NOT NULL THEN
1488: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1489: END IF ;
1490: IF source_lines_rec.task_id is NOT NULL THEN
1491: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1492: END IF ;

Line 1491: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;

1487: IF source_lines_rec.project_id is NOT NULL THEN
1488: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1489: END IF ;
1490: IF source_lines_rec.task_id is NOT NULL THEN
1491: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1492: END IF ;
1493: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1494: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1495: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;

Line 1493: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;

1489: END IF ;
1490: IF source_lines_rec.task_id is NOT NULL THEN
1491: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1492: END IF ;
1493: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1494: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1495: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1496: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1497: LOOP

Line 1494: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;

1490: IF source_lines_rec.task_id is NOT NULL THEN
1491: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1492: END IF ;
1493: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1494: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1495: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1496: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1497: LOOP
1498: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN

Line 1495: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;

1491: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1492: END IF ;
1493: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1494: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1495: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1496: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1497: LOOP
1498: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1499: EXIT ;

Line 1496: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;

1492: END IF ;
1493: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1494: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1495: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1496: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1497: LOOP
1498: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1499: EXIT ;
1500: END IF ;

Line 1498: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN

1494: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1495: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1496: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1497: LOOP
1498: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1499: EXIT ;
1500: END IF ;
1501: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1502: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;

Line 1501: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;

1497: LOOP
1498: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1499: EXIT ;
1500: END IF ;
1501: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1502: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1503: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1504: IF P_DEBUG_MODE = 'Y' THEN
1505: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||

Line 1502: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;

1498: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1499: EXIT ;
1500: END IF ;
1501: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1502: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1503: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1504: IF P_DEBUG_MODE = 'Y' THEN
1505: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||
1506: to_char(v_src_top_task_id));

Line 1503: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;

1499: EXIT ;
1500: END IF ;
1501: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1502: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1503: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1504: IF P_DEBUG_MODE = 'Y' THEN
1505: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||
1506: to_char(v_src_top_task_id));
1507: END IF;

Line 1522: DBMS_SQL.CLOSE_CURSOR(v_source_csr_id ); --added for bug 3799389

1518: , G_last_update_login );
1519: END LOOP; /* endloop explode srcs Dynamic sql */
1520: END IF; /* End if of source excludes from table */
1521: END LOOP; /* endloop read srcs */
1522: DBMS_SQL.CLOSE_CURSOR(v_source_csr_id ); --added for bug 3799389
1523: IF p_source_clnt_extn_flag = 'Y' THEN
1524: pa_debug.G_err_stage:= 'READING SRC CLIENT EXTENSION FOR INCLUDES';
1525: IF P_DEBUG_MODE = 'Y' THEN
1526: pa_debug.write_file('populate_run_sources: ' || 'LOG', pa_debug.G_err_stage);

Line 1644: v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; -- added for bug 3799389

1640: END LOOP;
1641: END IF; /* if count>0 */
1642: END IF; /* end src_extn_flag = 'Y' */
1643: pa_debug.G_err_stage:= 'READING SRC LINES FOR INCLUDES';
1644: v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; -- added for bug 3799389
1645: FOR source_lines_rec IN c_alloc_source_lines LOOP
1646: IF (source_lines_rec.exclude_flag = 'N') THEN
1647: pa_debug.G_err_stage:= 'EXPLODING SOURCE LINES FOR INCLUDES';
1648: IF P_DEBUG_MODE = 'Y' THEN

Line 1663: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */

1659: , v_src_sql_str ) ;
1660: IF P_DEBUG_MODE = 'Y' THEN
1661: pa_debug.write_file('populate_run_sources: ' || 'LOG',v_src_sql_str);
1662: END IF;
1663: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1664: IF P_DEBUG_MODE = 'Y' THEN
1665: pa_debug.write_file('populate_run_sources: ' || 'LOG','Parsing the code' );
1666: END IF;
1667: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;

Line 1667: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;

1663: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1664: IF P_DEBUG_MODE = 'Y' THEN
1665: pa_debug.write_file('populate_run_sources: ' || 'LOG','Parsing the code' );
1666: END IF;
1667: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;
1668: IF P_DEBUG_MODE = 'Y' THEN
1669: pa_debug.write_file('populate_run_sources: ' || 'LOG','After Parsing the code' );
1670: END IF;
1671: IF source_lines_rec.project_org_id is NOT NULL THEN

Line 1672: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;

1668: IF P_DEBUG_MODE = 'Y' THEN
1669: pa_debug.write_file('populate_run_sources: ' || 'LOG','After Parsing the code' );
1670: END IF;
1671: IF source_lines_rec.project_org_id is NOT NULL THEN
1672: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1673: END IF ;
1674: IF source_lines_rec.project_type is NOT NULL THEN
1675: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1676: END IF ;

Line 1675: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;

1671: IF source_lines_rec.project_org_id is NOT NULL THEN
1672: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1673: END IF ;
1674: IF source_lines_rec.project_type is NOT NULL THEN
1675: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1676: END IF ;
1677: IF source_lines_rec.task_org_id is NOT NULL THEN
1678: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1679: END IF ;

Line 1678: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;

1674: IF source_lines_rec.project_type is NOT NULL THEN
1675: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1676: END IF ;
1677: IF source_lines_rec.task_org_id is NOT NULL THEN
1678: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1679: END IF ;
1680: IF source_lines_rec.service_type is NOT NULL THEN
1681: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1682: END IF ;

Line 1681: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;

1677: IF source_lines_rec.task_org_id is NOT NULL THEN
1678: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1679: END IF ;
1680: IF source_lines_rec.service_type is NOT NULL THEN
1681: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1682: END IF ;
1683: IF source_lines_rec.class_category is NOT NULL THEN
1684: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1685: END IF ;

Line 1684: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;

1680: IF source_lines_rec.service_type is NOT NULL THEN
1681: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1682: END IF ;
1683: IF source_lines_rec.class_category is NOT NULL THEN
1684: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1685: END IF ;
1686: IF source_lines_rec.class_code is NOT NULL THEN
1687: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1688: END IF ;

Line 1687: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;

1683: IF source_lines_rec.class_category is NOT NULL THEN
1684: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1685: END IF ;
1686: IF source_lines_rec.class_code is NOT NULL THEN
1687: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1688: END IF ;
1689: IF source_lines_rec.project_id is NOT NULL THEN
1690: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1691: END IF ;

Line 1690: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;

1686: IF source_lines_rec.class_code is NOT NULL THEN
1687: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1688: END IF ;
1689: IF source_lines_rec.project_id is NOT NULL THEN
1690: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1691: END IF ;
1692: IF source_lines_rec.task_id is NOT NULL THEN
1693: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1694: END IF ;

Line 1693: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;

1689: IF source_lines_rec.project_id is NOT NULL THEN
1690: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1691: END IF ;
1692: IF source_lines_rec.task_id is NOT NULL THEN
1693: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1694: END IF ;
1695: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1696: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1697: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;

Line 1695: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;

1691: END IF ;
1692: IF source_lines_rec.task_id is NOT NULL THEN
1693: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1694: END IF ;
1695: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1696: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1697: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1698: IF P_DEBUG_MODE = 'Y' THEN
1699: pa_debug.write_file('populate_run_sources: ' || 'LOG','Executing the code' );

Line 1696: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;

1692: IF source_lines_rec.task_id is NOT NULL THEN
1693: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1694: END IF ;
1695: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1696: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1697: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1698: IF P_DEBUG_MODE = 'Y' THEN
1699: pa_debug.write_file('populate_run_sources: ' || 'LOG','Executing the code' );
1700: END IF;

Line 1697: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;

1693: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1694: END IF ;
1695: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1696: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1697: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1698: IF P_DEBUG_MODE = 'Y' THEN
1699: pa_debug.write_file('populate_run_sources: ' || 'LOG','Executing the code' );
1700: END IF;
1701: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;

Line 1701: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;

1697: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1698: IF P_DEBUG_MODE = 'Y' THEN
1699: pa_debug.write_file('populate_run_sources: ' || 'LOG','Executing the code' );
1700: END IF;
1701: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1702: IF P_DEBUG_MODE = 'Y' THEN
1703: pa_debug.write_file('populate_run_sources: ' || 'LOG','After Executing the code' );
1704: END IF;
1705: LOOP

Line 1706: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN

1702: IF P_DEBUG_MODE = 'Y' THEN
1703: pa_debug.write_file('populate_run_sources: ' || 'LOG','After Executing the code' );
1704: END IF;
1705: LOOP
1706: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1707: EXIT ;
1708: END IF ;
1709: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1710: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;

Line 1709: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;

1705: LOOP
1706: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1707: EXIT ;
1708: END IF ;
1709: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1710: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1711: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1712: IF P_DEBUG_MODE = 'Y' THEN
1713: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||

Line 1710: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;

1706: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1707: EXIT ;
1708: END IF ;
1709: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1710: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1711: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1712: IF P_DEBUG_MODE = 'Y' 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));

Line 1711: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;

1707: EXIT ;
1708: END IF ;
1709: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1710: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1711: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1712: IF P_DEBUG_MODE = 'Y' 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;

Line 1764: DBMS_SQL.CLOSE_CURSOR(v_source_csr_id ); --added for bug 3799389

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
1765: IF (p_resource_list_id IS NOT NULL ) THEN
1766: /* -- validate_srce_proj_for_RL ----------------------- */
1767: pa_debug.G_err_stage:= 'VALIDATING RSRCE ASSIGNMENTS TO SRC PROJECTS';
1768: IF P_DEBUG_MODE = 'Y' THEN

Line 2226: v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; --added for bug 3799389

2222: pa_debug.G_err_stage:= 'READING TRG LINES FOR EXCLUDES';
2223: IF P_DEBUG_MODE = 'Y' THEN
2224: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);
2225: END IF;
2226: v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; --added for bug 3799389
2227: FOR target_lines_rec IN c_alloc_target_lines LOOP
2228: IF (target_lines_rec.exclude_flag = 'Y') THEN
2229: build_tgt_sql( target_lines_rec.project_org_id
2230: , target_lines_rec.project_type

Line 2244: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */

2240: , v_tgt_sql_str ) ;
2241: IF P_DEBUG_MODE = 'Y' THEN
2242: pa_debug.write_file('populate_run_targets: ' || 'LOG',v_tgt_sql_str);
2243: END IF;
2244: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2245: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2246: IF target_lines_rec.project_org_id is NOT NULL THEN
2247: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2248: END IF ;

Line 2245: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;

2241: IF P_DEBUG_MODE = 'Y' THEN
2242: pa_debug.write_file('populate_run_targets: ' || 'LOG',v_tgt_sql_str);
2243: END IF;
2244: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2245: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2246: IF target_lines_rec.project_org_id is NOT NULL THEN
2247: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2248: END IF ;
2249: IF target_lines_rec.project_type is NOT NULL THEN

Line 2247: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;

2243: END IF;
2244: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2245: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2246: IF target_lines_rec.project_org_id is NOT NULL THEN
2247: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2248: END IF ;
2249: IF target_lines_rec.project_type is NOT NULL THEN
2250: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2251: END IF ;

Line 2250: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;

2246: IF target_lines_rec.project_org_id is NOT NULL THEN
2247: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2248: END IF ;
2249: IF target_lines_rec.project_type is NOT NULL THEN
2250: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2251: END IF ;
2252: IF target_lines_rec.task_org_id is NOT NULL THEN
2253: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2254: END IF ;

Line 2253: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;

2249: IF target_lines_rec.project_type is NOT NULL THEN
2250: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2251: END IF ;
2252: IF target_lines_rec.task_org_id is NOT NULL THEN
2253: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2254: END IF ;
2255: IF target_lines_rec.service_type is NOT NULL THEN
2256: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2257: END IF ;

Line 2256: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;

2252: IF target_lines_rec.task_org_id is NOT NULL THEN
2253: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2254: END IF ;
2255: IF target_lines_rec.service_type is NOT NULL THEN
2256: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2257: END IF ;
2258: IF target_lines_rec.class_category is NOT NULL THEN
2259: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2260: END IF ;

Line 2259: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;

2255: IF target_lines_rec.service_type is NOT NULL THEN
2256: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2257: END IF ;
2258: IF target_lines_rec.class_category is NOT NULL THEN
2259: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2260: END IF ;
2261: IF target_lines_rec.class_code is NOT NULL THEN
2262: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2263: END IF ;

Line 2262: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;

2258: IF target_lines_rec.class_category is NOT NULL THEN
2259: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2260: END IF ;
2261: IF target_lines_rec.class_code is NOT NULL THEN
2262: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2263: END IF ;
2264: IF target_lines_rec.project_id is NOT NULL THEN
2265: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2266: END IF ;

Line 2265: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;

2261: IF target_lines_rec.class_code is NOT NULL THEN
2262: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2263: END IF ;
2264: IF target_lines_rec.project_id is NOT NULL THEN
2265: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2266: END IF ;
2267: IF target_lines_rec.task_id is NOT NULL THEN
2268: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2269: END IF ;

Line 2268: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;

2264: IF target_lines_rec.project_id is NOT NULL THEN
2265: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2266: END IF ;
2267: IF target_lines_rec.task_id is NOT NULL THEN
2268: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2269: END IF ;
2270: IF p_expnd_item_date is NOT NULL THEN
2271: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2272: END IF ;

Line 2271: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;

2267: IF target_lines_rec.task_id is NOT NULL THEN
2268: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2269: END IF ;
2270: IF p_expnd_item_date is NOT NULL THEN
2271: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2272: END IF ;
2273: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2274: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2275: END IF ;

Line 2274: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;

2270: IF p_expnd_item_date is NOT NULL THEN
2271: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2272: END IF ;
2273: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2274: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2275: END IF ;
2276: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2277: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2278: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;

Line 2276: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;

2272: END IF ;
2273: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2274: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2275: END IF ;
2276: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2277: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2278: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2279: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2280: LOOP

Line 2277: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;

2273: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2274: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2275: END IF ;
2276: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2277: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2278: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2279: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2280: LOOP
2281: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN

Line 2278: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;

2274: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2275: END IF ;
2276: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2277: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2278: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2279: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2280: LOOP
2281: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2282: EXIT ;

Line 2279: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;

2275: END IF ;
2276: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2277: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2278: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2279: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2280: LOOP
2281: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2282: EXIT ;
2283: END IF ;

Line 2281: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN

2277: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2278: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2279: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2280: LOOP
2281: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2282: EXIT ;
2283: END IF ;
2284: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2285: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;

Line 2284: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;

2280: LOOP
2281: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2282: EXIT ;
2283: END IF ;
2284: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2285: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2286: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2287: IF P_DEBUG_MODE = 'Y' THEN
2288: pa_debug.write_file('populate_run_targets: ' || 'LOG',to_char(v_tgt_project_id) || to_char(v_tgt_task_id) ||

Line 2285: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;

2281: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2282: EXIT ;
2283: END IF ;
2284: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2285: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2286: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2287: IF P_DEBUG_MODE = 'Y' THEN
2288: pa_debug.write_file('populate_run_targets: ' || 'LOG',to_char(v_tgt_project_id) || to_char(v_tgt_task_id) ||
2289: to_char(v_tgt_top_task_id));

Line 2286: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;

2282: EXIT ;
2283: END IF ;
2284: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2285: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2286: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2287: IF P_DEBUG_MODE = 'Y' THEN
2288: pa_debug.write_file('populate_run_targets: ' || 'LOG',to_char(v_tgt_project_id) || to_char(v_tgt_task_id) ||
2289: to_char(v_tgt_top_task_id));
2290: END IF;

Line 2308: DBMS_SQL.CLOSE_CURSOR(v_target_csr_id ); --added for bug 3799389

2304: , p_dup_targets_flag );
2305: END LOOP; /* for c_alloc_targets */
2306: END IF;
2307: END LOOP; /* for c_alloc_target_lines */
2308: DBMS_SQL.CLOSE_CURSOR(v_target_csr_id ); --added for bug 3799389
2309: IF (p_trgt_client_extn = 'Y') THEN
2310: pa_debug.G_err_stage:= 'READING TRG CLIENT EXTENSION FOR INCLUDES';
2311: IF P_DEBUG_MODE = 'Y' THEN
2312: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);

Line 2383: v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; --added for bug 3799389

2379: pa_debug.G_err_stage:= 'READING TRG LINES FOR INCLUDES';
2380: IF P_DEBUG_MODE = 'Y' THEN
2381: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);
2382: END IF;
2383: v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; --added for bug 3799389
2384: FOR target_lines_rec IN c_alloc_target_lines LOOP
2385: IF (target_lines_rec.exclude_flag = 'N') THEN
2386: build_tgt_sql( target_lines_rec.project_org_id
2387: , target_lines_rec.project_type

Line 2401: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */

2397: , v_tgt_sql_str ) ;
2398: IF P_DEBUG_MODE = 'Y' THEN
2399: pa_debug.write_file('populate_run_targets: ' || 'LOG',v_tgt_sql_str);
2400: END IF;
2401: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2402: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2403: IF target_lines_rec.project_org_id is NOT NULL THEN
2404: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2405: END IF ;

Line 2402: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;

2398: IF P_DEBUG_MODE = 'Y' THEN
2399: pa_debug.write_file('populate_run_targets: ' || 'LOG',v_tgt_sql_str);
2400: END IF;
2401: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2402: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2403: IF target_lines_rec.project_org_id is NOT NULL THEN
2404: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2405: END IF ;
2406: IF target_lines_rec.project_type is NOT NULL THEN

Line 2404: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;

2400: END IF;
2401: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2402: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2403: IF target_lines_rec.project_org_id is NOT NULL THEN
2404: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2405: END IF ;
2406: IF target_lines_rec.project_type is NOT NULL THEN
2407: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2408: END IF ;

Line 2407: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;

2403: IF target_lines_rec.project_org_id is NOT NULL THEN
2404: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2405: END IF ;
2406: IF target_lines_rec.project_type is NOT NULL THEN
2407: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2408: END IF ;
2409: IF target_lines_rec.task_org_id is NOT NULL THEN
2410: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2411: END IF ;

Line 2410: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;

2406: IF target_lines_rec.project_type is NOT NULL THEN
2407: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2408: END IF ;
2409: IF target_lines_rec.task_org_id is NOT NULL THEN
2410: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2411: END IF ;
2412: IF target_lines_rec.service_type is NOT NULL THEN
2413: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2414: END IF ;

Line 2413: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;

2409: IF target_lines_rec.task_org_id is NOT NULL THEN
2410: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2411: END IF ;
2412: IF target_lines_rec.service_type is NOT NULL THEN
2413: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2414: END IF ;
2415: IF target_lines_rec.class_category is NOT NULL THEN
2416: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2417: END IF ;

Line 2416: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;

2412: IF target_lines_rec.service_type is NOT NULL THEN
2413: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2414: END IF ;
2415: IF target_lines_rec.class_category is NOT NULL THEN
2416: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2417: END IF ;
2418: IF target_lines_rec.class_code is NOT NULL THEN
2419: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2420: END IF ;

Line 2419: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;

2415: IF target_lines_rec.class_category is NOT NULL THEN
2416: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2417: END IF ;
2418: IF target_lines_rec.class_code is NOT NULL THEN
2419: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2420: END IF ;
2421: IF target_lines_rec.project_id is NOT NULL THEN
2422: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2423: END IF ;

Line 2422: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;

2418: IF target_lines_rec.class_code is NOT NULL THEN
2419: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2420: END IF ;
2421: IF target_lines_rec.project_id is NOT NULL THEN
2422: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2423: END IF ;
2424: IF target_lines_rec.task_id is NOT NULL THEN
2425: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2426: END IF ;

Line 2425: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;

2421: IF target_lines_rec.project_id is NOT NULL THEN
2422: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2423: END IF ;
2424: IF target_lines_rec.task_id is NOT NULL THEN
2425: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2426: END IF ;
2427: IF p_expnd_item_date is NOT NULL THEN
2428: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2429: END IF ;

Line 2428: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;

2424: IF target_lines_rec.task_id is NOT NULL THEN
2425: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2426: END IF ;
2427: IF p_expnd_item_date is NOT NULL THEN
2428: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2429: END IF ;
2430: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2431: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2432: END IF ;

Line 2431: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;

2427: IF p_expnd_item_date is NOT NULL THEN
2428: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2429: END IF ;
2430: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2431: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2432: END IF ;
2433: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2434: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2435: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;

Line 2433: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;

2429: END IF ;
2430: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2431: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2432: END IF ;
2433: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2434: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2435: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2436: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2437: LOOP

Line 2434: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;

2430: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2431: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2432: END IF ;
2433: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2434: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2435: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2436: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2437: LOOP
2438: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN

Line 2435: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;

2431: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2432: END IF ;
2433: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2434: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2435: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2436: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2437: LOOP
2438: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2439: EXIT ;

Line 2436: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;

2432: END IF ;
2433: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2434: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2435: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2436: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2437: LOOP
2438: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2439: EXIT ;
2440: END IF ;

Line 2438: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN

2434: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2435: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2436: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2437: LOOP
2438: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2439: EXIT ;
2440: END IF ;
2441: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2442: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;

Line 2441: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;

2437: LOOP
2438: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2439: EXIT ;
2440: END IF ;
2441: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2442: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2443: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2444: IF P_DEBUG_MODE = 'Y' THEN
2445: pa_debug.write_file('populate_run_targets: ' || 'LOG','Exploded proj/tasks: '|| to_char(v_tgt_project_id) ||

Line 2442: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;

2438: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2439: EXIT ;
2440: END IF ;
2441: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2442: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2443: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2444: IF P_DEBUG_MODE = 'Y' THEN
2445: pa_debug.write_file('populate_run_targets: ' || 'LOG','Exploded proj/tasks: '|| to_char(v_tgt_project_id) ||
2446: to_char(v_tgt_task_id) ||

Line 2443: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;

2439: EXIT ;
2440: END IF ;
2441: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2442: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2443: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2444: IF P_DEBUG_MODE = 'Y' THEN
2445: pa_debug.write_file('populate_run_targets: ' || 'LOG','Exploded proj/tasks: '|| to_char(v_tgt_project_id) ||
2446: to_char(v_tgt_task_id) ||
2447: to_char(v_tgt_top_task_id));

Line 2471: DBMS_SQL.CLOSE_CURSOR(v_target_csr_id ); --added for bug 3799389

2467: END IF; /* exclude_curr_proj_task */
2468: END LOOP;
2469: END IF;
2470: END LOOP;
2471: DBMS_SQL.CLOSE_CURSOR(v_target_csr_id ); --added for bug 3799389
2472: /* -- validate budget_entry_level_code for trg_proj --------------- */
2473: IF( p_bas_budget_entry_method_code IS NOT NULL) THEN
2474: pa_debug.G_err_stage:= 'VALIDATING BASIS BUDGET ENTRY METHOD TO TRG PROJECTS';
2475: IF P_DEBUG_MODE = 'Y' THEN