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 1461: v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; -- added for bug 3799389

1457: pa_debug.G_err_stage:= 'READING SRC LINES FOR EXCLUDES';
1458: IF P_DEBUG_MODE = 'Y' THEN
1459: pa_debug.write_file('populate_run_sources: ' || 'LOG', pa_debug.G_err_stage);
1460: END IF;
1461: v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; -- added for bug 3799389
1462:
1463: FOR source_lines_rec IN c_alloc_source_lines LOOP
1464: IF (source_lines_rec.exclude_flag = 'Y') THEN
1465: build_src_sql( source_lines_rec.project_org_id

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

1473: , v_src_sql_str ) ;
1474: IF P_DEBUG_MODE = 'Y' THEN
1475: pa_debug.write_file('populate_run_sources: ' || 'LOG',v_src_sql_str);
1476: END IF;
1477: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1478: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;
1479: IF source_lines_rec.project_org_id is NOT NULL THEN
1480: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1481: END IF ;

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

1474: IF P_DEBUG_MODE = 'Y' THEN
1475: pa_debug.write_file('populate_run_sources: ' || 'LOG',v_src_sql_str);
1476: END IF;
1477: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1478: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;
1479: IF source_lines_rec.project_org_id is NOT NULL THEN
1480: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1481: END IF ;
1482: IF source_lines_rec.project_type is NOT NULL THEN

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

1476: END IF;
1477: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1478: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;
1479: IF source_lines_rec.project_org_id is NOT NULL THEN
1480: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1481: END IF ;
1482: IF source_lines_rec.project_type is NOT NULL THEN
1483: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1484: END IF ;

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

1479: IF source_lines_rec.project_org_id is NOT NULL THEN
1480: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1481: END IF ;
1482: IF source_lines_rec.project_type is NOT NULL THEN
1483: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1484: END IF ;
1485: IF source_lines_rec.task_org_id is NOT NULL THEN
1486: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1487: END IF ;

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

1482: IF source_lines_rec.project_type is NOT NULL THEN
1483: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1484: END IF ;
1485: IF source_lines_rec.task_org_id is NOT NULL THEN
1486: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1487: END IF ;
1488: IF source_lines_rec.service_type is NOT NULL THEN
1489: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1490: END IF ;

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

1485: IF source_lines_rec.task_org_id is NOT NULL THEN
1486: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1487: END IF ;
1488: IF source_lines_rec.service_type is NOT NULL THEN
1489: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1490: END IF ;
1491: IF source_lines_rec.class_category is NOT NULL THEN
1492: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1493: END IF ;

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

1488: IF source_lines_rec.service_type is NOT NULL THEN
1489: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1490: END IF ;
1491: IF source_lines_rec.class_category is NOT NULL THEN
1492: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1493: END IF ;
1494: IF source_lines_rec.class_code is NOT NULL THEN
1495: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1496: END IF ;

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

1491: IF source_lines_rec.class_category is NOT NULL THEN
1492: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1493: END IF ;
1494: IF source_lines_rec.class_code is NOT NULL THEN
1495: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1496: END IF ;
1497: IF source_lines_rec.project_id is NOT NULL THEN
1498: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1499: END IF ;

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

1494: IF source_lines_rec.class_code is NOT NULL THEN
1495: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1496: END IF ;
1497: IF source_lines_rec.project_id is NOT NULL THEN
1498: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1499: END IF ;
1500: IF source_lines_rec.task_id is NOT NULL THEN
1501: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1502: END IF ;

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

1497: IF source_lines_rec.project_id is NOT NULL THEN
1498: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1499: END IF ;
1500: IF source_lines_rec.task_id is NOT NULL THEN
1501: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1502: END IF ;
1503: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1504: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1505: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;

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

1499: END IF ;
1500: IF source_lines_rec.task_id is NOT NULL THEN
1501: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1502: END IF ;
1503: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1504: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1505: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1506: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1507: LOOP

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

1500: IF source_lines_rec.task_id is NOT NULL THEN
1501: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1502: END IF ;
1503: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1504: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1505: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1506: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1507: LOOP
1508: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN

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

1501: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1502: END IF ;
1503: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1504: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1505: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1506: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1507: LOOP
1508: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1509: EXIT ;

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

1502: END IF ;
1503: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1504: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1505: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1506: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1507: LOOP
1508: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1509: EXIT ;
1510: END IF ;

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

1504: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1505: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1506: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1507: LOOP
1508: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1509: EXIT ;
1510: END IF ;
1511: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1512: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;

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

1507: LOOP
1508: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1509: EXIT ;
1510: END IF ;
1511: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1512: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1513: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1514: IF P_DEBUG_MODE = 'Y' THEN
1515: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||

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

1508: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1509: EXIT ;
1510: END IF ;
1511: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1512: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1513: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1514: IF P_DEBUG_MODE = 'Y' THEN
1515: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||
1516: to_char(v_src_top_task_id));

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

1509: EXIT ;
1510: END IF ;
1511: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1512: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1513: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1514: IF P_DEBUG_MODE = 'Y' THEN
1515: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||
1516: to_char(v_src_top_task_id));
1517: END IF;

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

1528: , G_last_update_login );
1529: END LOOP; /* endloop explode srcs Dynamic sql */
1530: END IF; /* End if of source excludes from table */
1531: END LOOP; /* endloop read srcs */
1532: DBMS_SQL.CLOSE_CURSOR(v_source_csr_id ); --added for bug 3799389
1533: IF p_source_clnt_extn_flag = 'Y' THEN
1534: pa_debug.G_err_stage:= 'READING SRC CLIENT EXTENSION FOR INCLUDES';
1535: IF P_DEBUG_MODE = 'Y' THEN
1536: pa_debug.write_file('populate_run_sources: ' || 'LOG', pa_debug.G_err_stage);

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

1650: END LOOP;
1651: END IF; /* if count>0 */
1652: END IF; /* end src_extn_flag = 'Y' */
1653: pa_debug.G_err_stage:= 'READING SRC LINES FOR INCLUDES';
1654: v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; -- added for bug 3799389
1655: FOR source_lines_rec IN c_alloc_source_lines LOOP
1656: IF (source_lines_rec.exclude_flag = 'N') THEN
1657: pa_debug.G_err_stage:= 'EXPLODING SOURCE LINES FOR INCLUDES';
1658: IF P_DEBUG_MODE = 'Y' THEN

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

1669: , v_src_sql_str ) ;
1670: IF P_DEBUG_MODE = 'Y' THEN
1671: pa_debug.write_file('populate_run_sources: ' || 'LOG',v_src_sql_str);
1672: END IF;
1673: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1674: IF P_DEBUG_MODE = 'Y' THEN
1675: pa_debug.write_file('populate_run_sources: ' || 'LOG','Parsing the code' );
1676: END IF;
1677: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;

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

1673: /* v_source_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
1674: IF P_DEBUG_MODE = 'Y' THEN
1675: pa_debug.write_file('populate_run_sources: ' || 'LOG','Parsing the code' );
1676: END IF;
1677: DBMS_SQL.PARSE(v_source_csr_id, v_src_sql_str, DBMS_SQL.V7) ;
1678: IF P_DEBUG_MODE = 'Y' THEN
1679: pa_debug.write_file('populate_run_sources: ' || 'LOG','After Parsing the code' );
1680: END IF;
1681: IF source_lines_rec.project_org_id is NOT NULL THEN

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

1678: IF P_DEBUG_MODE = 'Y' THEN
1679: pa_debug.write_file('populate_run_sources: ' || 'LOG','After Parsing the code' );
1680: END IF;
1681: IF source_lines_rec.project_org_id is NOT NULL THEN
1682: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1683: END IF ;
1684: IF source_lines_rec.project_type is NOT NULL THEN
1685: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1686: END IF ;

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

1681: IF source_lines_rec.project_org_id is NOT NULL THEN
1682: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_org_id',source_lines_rec.project_org_id) ;
1683: END IF ;
1684: IF source_lines_rec.project_type is NOT NULL THEN
1685: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1686: END IF ;
1687: IF source_lines_rec.task_org_id is NOT NULL THEN
1688: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1689: END IF ;

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

1684: IF source_lines_rec.project_type is NOT NULL THEN
1685: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_type',source_lines_rec.project_type) ;
1686: END IF ;
1687: IF source_lines_rec.task_org_id is NOT NULL THEN
1688: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1689: END IF ;
1690: IF source_lines_rec.service_type is NOT NULL THEN
1691: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1692: END IF ;

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

1687: IF source_lines_rec.task_org_id is NOT NULL THEN
1688: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_org_id',source_lines_rec.task_org_id) ;
1689: END IF ;
1690: IF source_lines_rec.service_type is NOT NULL THEN
1691: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1692: END IF ;
1693: IF source_lines_rec.class_category is NOT NULL THEN
1694: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1695: END IF ;

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

1690: IF source_lines_rec.service_type is NOT NULL THEN
1691: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_service_type_code',source_lines_rec.service_type) ;
1692: END IF ;
1693: IF source_lines_rec.class_category is NOT NULL THEN
1694: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1695: END IF ;
1696: IF source_lines_rec.class_code is NOT NULL THEN
1697: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1698: END IF ;

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

1693: IF source_lines_rec.class_category is NOT NULL THEN
1694: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_category',source_lines_rec.class_category) ;
1695: END IF ;
1696: IF source_lines_rec.class_code is NOT NULL THEN
1697: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1698: END IF ;
1699: IF source_lines_rec.project_id is NOT NULL THEN
1700: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1701: END IF ;

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

1696: IF source_lines_rec.class_code is NOT NULL THEN
1697: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_class_code',source_lines_rec.class_code) ;
1698: END IF ;
1699: IF source_lines_rec.project_id is NOT NULL THEN
1700: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1701: END IF ;
1702: IF source_lines_rec.task_id is NOT NULL THEN
1703: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1704: END IF ;

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

1699: IF source_lines_rec.project_id is NOT NULL THEN
1700: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_project_id',source_lines_rec.project_id) ;
1701: END IF ;
1702: IF source_lines_rec.task_id is NOT NULL THEN
1703: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1704: END IF ;
1705: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1706: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1707: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;

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

1701: END IF ;
1702: IF source_lines_rec.task_id is NOT NULL THEN
1703: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1704: END IF ;
1705: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1706: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1707: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1708: IF P_DEBUG_MODE = 'Y' THEN
1709: pa_debug.write_file('populate_run_sources: ' || 'LOG','Executing the code' );

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

1702: IF source_lines_rec.task_id is NOT NULL THEN
1703: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1704: END IF ;
1705: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1706: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1707: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1708: IF P_DEBUG_MODE = 'Y' THEN
1709: pa_debug.write_file('populate_run_sources: ' || 'LOG','Executing the code' );
1710: END IF;

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

1703: DBMS_SQL.BIND_VARIABLE(v_source_csr_id,':lp_task_id',source_lines_rec.task_id) ;
1704: END IF ;
1705: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,1,v_src_project_id ) ;
1706: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,2,v_src_task_id ) ;
1707: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1708: IF P_DEBUG_MODE = 'Y' THEN
1709: pa_debug.write_file('populate_run_sources: ' || 'LOG','Executing the code' );
1710: END IF;
1711: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;

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

1707: DBMS_SQL.DEFINE_COLUMN(v_source_csr_id,3,v_src_top_task_id ) ;
1708: IF P_DEBUG_MODE = 'Y' THEN
1709: pa_debug.write_file('populate_run_sources: ' || 'LOG','Executing the code' );
1710: END IF;
1711: v_dummy := DBMS_SQL.execute(v_source_csr_id) ;
1712: IF P_DEBUG_MODE = 'Y' THEN
1713: pa_debug.write_file('populate_run_sources: ' || 'LOG','After Executing the code' );
1714: END IF;
1715: LOOP

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

1712: IF P_DEBUG_MODE = 'Y' THEN
1713: pa_debug.write_file('populate_run_sources: ' || 'LOG','After Executing the code' );
1714: END IF;
1715: LOOP
1716: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1717: EXIT ;
1718: END IF ;
1719: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1720: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;

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

1715: LOOP
1716: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1717: EXIT ;
1718: END IF ;
1719: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1720: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1721: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1722: IF P_DEBUG_MODE = 'Y' THEN
1723: pa_debug.write_file('populate_run_sources: ' || 'LOG',to_char(v_src_project_id) || to_char(v_src_task_id) ||

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

1716: IF DBMS_SQL.FETCH_ROWS(v_source_csr_id) = 0 THEN
1717: EXIT ;
1718: END IF ;
1719: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1720: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1721: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1722: IF P_DEBUG_MODE = 'Y' 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));

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

1717: EXIT ;
1718: END IF ;
1719: dbms_sql.column_value(v_source_csr_id,1,v_src_project_id) ;
1720: dbms_sql.column_value(v_source_csr_id,2,v_src_task_id ) ;
1721: dbms_sql.column_value(v_source_csr_id,3,v_src_top_task_id ) ;
1722: IF P_DEBUG_MODE = 'Y' 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;

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

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

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

2232: pa_debug.G_err_stage:= 'READING TRG LINES FOR EXCLUDES';
2233: IF P_DEBUG_MODE = 'Y' THEN
2234: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);
2235: END IF;
2236: v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; --added for bug 3799389
2237: FOR target_lines_rec IN c_alloc_target_lines LOOP
2238: IF (target_lines_rec.exclude_flag = 'Y') THEN
2239: build_tgt_sql( target_lines_rec.project_org_id
2240: , target_lines_rec.project_type

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

2250: , v_tgt_sql_str ) ;
2251: IF P_DEBUG_MODE = 'Y' THEN
2252: pa_debug.write_file('populate_run_targets: ' || 'LOG',v_tgt_sql_str);
2253: END IF;
2254: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2255: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2256: IF target_lines_rec.project_org_id is NOT NULL THEN
2257: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2258: END IF ;

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

2251: IF P_DEBUG_MODE = 'Y' THEN
2252: pa_debug.write_file('populate_run_targets: ' || 'LOG',v_tgt_sql_str);
2253: END IF;
2254: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2255: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2256: IF target_lines_rec.project_org_id is NOT NULL THEN
2257: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2258: END IF ;
2259: IF target_lines_rec.project_type is NOT NULL THEN

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

2253: END IF;
2254: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2255: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2256: IF target_lines_rec.project_org_id is NOT NULL THEN
2257: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2258: END IF ;
2259: IF target_lines_rec.project_type is NOT NULL THEN
2260: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2261: END IF ;

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

2256: IF target_lines_rec.project_org_id is NOT NULL THEN
2257: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2258: END IF ;
2259: IF target_lines_rec.project_type is NOT NULL THEN
2260: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2261: END IF ;
2262: IF target_lines_rec.task_org_id is NOT NULL THEN
2263: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2264: END IF ;

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

2259: IF target_lines_rec.project_type is NOT NULL THEN
2260: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2261: END IF ;
2262: IF target_lines_rec.task_org_id is NOT NULL THEN
2263: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2264: END IF ;
2265: IF target_lines_rec.service_type is NOT NULL THEN
2266: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2267: END IF ;

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

2262: IF target_lines_rec.task_org_id is NOT NULL THEN
2263: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2264: END IF ;
2265: IF target_lines_rec.service_type is NOT NULL THEN
2266: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2267: END IF ;
2268: IF target_lines_rec.class_category is NOT NULL THEN
2269: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2270: END IF ;

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

2265: IF target_lines_rec.service_type is NOT NULL THEN
2266: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2267: END IF ;
2268: IF target_lines_rec.class_category is NOT NULL THEN
2269: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2270: END IF ;
2271: IF target_lines_rec.class_code is NOT NULL THEN
2272: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2273: END IF ;

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

2268: IF target_lines_rec.class_category is NOT NULL THEN
2269: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2270: END IF ;
2271: IF target_lines_rec.class_code is NOT NULL THEN
2272: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2273: END IF ;
2274: IF target_lines_rec.project_id is NOT NULL THEN
2275: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2276: END IF ;

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

2271: IF target_lines_rec.class_code is NOT NULL THEN
2272: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2273: END IF ;
2274: IF target_lines_rec.project_id is NOT NULL THEN
2275: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2276: END IF ;
2277: IF target_lines_rec.task_id is NOT NULL THEN
2278: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2279: END IF ;

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

2274: IF target_lines_rec.project_id is NOT NULL THEN
2275: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2276: END IF ;
2277: IF target_lines_rec.task_id is NOT NULL THEN
2278: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2279: END IF ;
2280: IF p_expnd_item_date is NOT NULL THEN
2281: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2282: END IF ;

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

2277: IF target_lines_rec.task_id is NOT NULL THEN
2278: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2279: END IF ;
2280: IF p_expnd_item_date is NOT NULL THEN
2281: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2282: END IF ;
2283: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2284: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2285: END IF ;

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

2280: IF p_expnd_item_date is NOT NULL THEN
2281: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2282: END IF ;
2283: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2284: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2285: END IF ;
2286: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2287: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2288: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;

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

2282: END IF ;
2283: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2284: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2285: END IF ;
2286: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2287: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2288: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2289: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2290: LOOP

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

2283: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2284: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2285: END IF ;
2286: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2287: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2288: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2289: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2290: LOOP
2291: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN

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

2284: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2285: END IF ;
2286: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2287: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2288: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2289: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2290: LOOP
2291: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2292: EXIT ;

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

2285: END IF ;
2286: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2287: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2288: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2289: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2290: LOOP
2291: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2292: EXIT ;
2293: END IF ;

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

2287: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2288: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2289: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2290: LOOP
2291: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2292: EXIT ;
2293: END IF ;
2294: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2295: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;

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

2290: LOOP
2291: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2292: EXIT ;
2293: END IF ;
2294: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2295: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2296: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2297: IF P_DEBUG_MODE = 'Y' THEN
2298: pa_debug.write_file('populate_run_targets: ' || 'LOG',to_char(v_tgt_project_id) || to_char(v_tgt_task_id) ||

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

2291: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2292: EXIT ;
2293: END IF ;
2294: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2295: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2296: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2297: IF P_DEBUG_MODE = 'Y' THEN
2298: pa_debug.write_file('populate_run_targets: ' || 'LOG',to_char(v_tgt_project_id) || to_char(v_tgt_task_id) ||
2299: to_char(v_tgt_top_task_id));

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

2292: EXIT ;
2293: END IF ;
2294: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2295: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2296: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2297: IF P_DEBUG_MODE = 'Y' THEN
2298: pa_debug.write_file('populate_run_targets: ' || 'LOG',to_char(v_tgt_project_id) || to_char(v_tgt_task_id) ||
2299: to_char(v_tgt_top_task_id));
2300: END IF;

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

2314: , p_dup_targets_flag );
2315: END LOOP; /* for c_alloc_targets */
2316: END IF;
2317: END LOOP; /* for c_alloc_target_lines */
2318: DBMS_SQL.CLOSE_CURSOR(v_target_csr_id ); --added for bug 3799389
2319: IF (p_trgt_client_extn = 'Y') THEN
2320: pa_debug.G_err_stage:= 'READING TRG CLIENT EXTENSION FOR INCLUDES';
2321: IF P_DEBUG_MODE = 'Y' THEN
2322: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);

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

2389: pa_debug.G_err_stage:= 'READING TRG LINES FOR INCLUDES';
2390: IF P_DEBUG_MODE = 'Y' THEN
2391: pa_debug.write_file('populate_run_targets: ' || 'LOG', pa_debug.G_err_stage);
2392: END IF;
2393: v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; --added for bug 3799389
2394: FOR target_lines_rec IN c_alloc_target_lines LOOP
2395: IF (target_lines_rec.exclude_flag = 'N') THEN
2396: build_tgt_sql( target_lines_rec.project_org_id
2397: , target_lines_rec.project_type

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

2407: , v_tgt_sql_str ) ;
2408: IF P_DEBUG_MODE = 'Y' THEN
2409: pa_debug.write_file('populate_run_targets: ' || 'LOG',v_tgt_sql_str);
2410: END IF;
2411: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2412: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2413: IF target_lines_rec.project_org_id is NOT NULL THEN
2414: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2415: END IF ;

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

2408: IF P_DEBUG_MODE = 'Y' THEN
2409: pa_debug.write_file('populate_run_targets: ' || 'LOG',v_tgt_sql_str);
2410: END IF;
2411: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2412: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2413: IF target_lines_rec.project_org_id is NOT NULL THEN
2414: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2415: END IF ;
2416: IF target_lines_rec.project_type is NOT NULL THEN

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

2410: END IF;
2411: /* v_target_csr_id := DBMS_SQL.OPEN_CURSOR ; commented for bug 3799389 */
2412: DBMS_SQL.PARSE(v_target_csr_id, v_tgt_sql_str, DBMS_SQL.V7) ;
2413: IF target_lines_rec.project_org_id is NOT NULL THEN
2414: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2415: END IF ;
2416: IF target_lines_rec.project_type is NOT NULL THEN
2417: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2418: END IF ;

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

2413: IF target_lines_rec.project_org_id is NOT NULL THEN
2414: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_org_id',target_lines_rec.project_org_id) ;
2415: END IF ;
2416: IF target_lines_rec.project_type is NOT NULL THEN
2417: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2418: END IF ;
2419: IF target_lines_rec.task_org_id is NOT NULL THEN
2420: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2421: END IF ;

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

2416: IF target_lines_rec.project_type is NOT NULL THEN
2417: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_type',target_lines_rec.project_type) ;
2418: END IF ;
2419: IF target_lines_rec.task_org_id is NOT NULL THEN
2420: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2421: END IF ;
2422: IF target_lines_rec.service_type is NOT NULL THEN
2423: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2424: END IF ;

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

2419: IF target_lines_rec.task_org_id is NOT NULL THEN
2420: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_org_id',target_lines_rec.task_org_id) ;
2421: END IF ;
2422: IF target_lines_rec.service_type is NOT NULL THEN
2423: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2424: END IF ;
2425: IF target_lines_rec.class_category is NOT NULL THEN
2426: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2427: END IF ;

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

2422: IF target_lines_rec.service_type is NOT NULL THEN
2423: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_service_type_code',target_lines_rec.service_type) ;
2424: END IF ;
2425: IF target_lines_rec.class_category is NOT NULL THEN
2426: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2427: END IF ;
2428: IF target_lines_rec.class_code is NOT NULL THEN
2429: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2430: END IF ;

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

2425: IF target_lines_rec.class_category is NOT NULL THEN
2426: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_category',target_lines_rec.class_category) ;
2427: END IF ;
2428: IF target_lines_rec.class_code is NOT NULL THEN
2429: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2430: END IF ;
2431: IF target_lines_rec.project_id is NOT NULL THEN
2432: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2433: END IF ;

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

2428: IF target_lines_rec.class_code is NOT NULL THEN
2429: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_class_code',target_lines_rec.class_code) ;
2430: END IF ;
2431: IF target_lines_rec.project_id is NOT NULL THEN
2432: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2433: END IF ;
2434: IF target_lines_rec.task_id is NOT NULL THEN
2435: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2436: END IF ;

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

2431: IF target_lines_rec.project_id is NOT NULL THEN
2432: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_project_id',target_lines_rec.project_id) ;
2433: END IF ;
2434: IF target_lines_rec.task_id is NOT NULL THEN
2435: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2436: END IF ;
2437: IF p_expnd_item_date is NOT NULL THEN
2438: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2439: END IF ;

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

2434: IF target_lines_rec.task_id is NOT NULL THEN
2435: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_task_id',target_lines_rec.task_id) ;
2436: END IF ;
2437: IF p_expnd_item_date is NOT NULL THEN
2438: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2439: END IF ;
2440: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2441: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2442: END IF ;

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

2437: IF p_expnd_item_date is NOT NULL THEN
2438: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':p_expnd_item_date',p_expnd_item_date) ;
2439: END IF ;
2440: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2441: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2442: END IF ;
2443: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2444: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2445: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;

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

2439: END IF ;
2440: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2441: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2442: END IF ;
2443: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2444: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2445: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2446: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2447: LOOP

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

2440: IF ( nvl(target_lines_rec.billable_only_flag,'N') = 'Y' ) THEN
2441: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2442: END IF ;
2443: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2444: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2445: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2446: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2447: LOOP
2448: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN

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

2441: DBMS_SQL.BIND_VARIABLE(v_target_csr_id,':lp_billable_only_flag',target_lines_rec.billable_only_flag) ;
2442: END IF ;
2443: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2444: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2445: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2446: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2447: LOOP
2448: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2449: EXIT ;

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

2442: END IF ;
2443: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,1,v_tgt_project_id ) ;
2444: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2445: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2446: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2447: LOOP
2448: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2449: EXIT ;
2450: END IF ;

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

2444: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,2,v_tgt_task_id ) ;
2445: DBMS_SQL.DEFINE_COLUMN(v_target_csr_id,3,v_tgt_top_task_id ) ;
2446: v_dummy := DBMS_SQL.execute(v_target_csr_id) ;
2447: LOOP
2448: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2449: EXIT ;
2450: END IF ;
2451: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2452: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;

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

2447: LOOP
2448: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2449: EXIT ;
2450: END IF ;
2451: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2452: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2453: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2454: IF P_DEBUG_MODE = 'Y' THEN
2455: pa_debug.write_file('populate_run_targets: ' || 'LOG','Exploded proj/tasks: '|| to_char(v_tgt_project_id) ||

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

2448: IF DBMS_SQL.FETCH_ROWS(v_target_csr_id) = 0 THEN
2449: EXIT ;
2450: END IF ;
2451: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2452: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2453: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2454: IF P_DEBUG_MODE = 'Y' THEN
2455: pa_debug.write_file('populate_run_targets: ' || 'LOG','Exploded proj/tasks: '|| to_char(v_tgt_project_id) ||
2456: to_char(v_tgt_task_id) ||

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

2449: EXIT ;
2450: END IF ;
2451: dbms_sql.column_value(v_target_csr_id,1,v_tgt_project_id) ;
2452: dbms_sql.column_value(v_target_csr_id,2,v_tgt_task_id ) ;
2453: dbms_sql.column_value(v_target_csr_id,3,v_tgt_top_task_id ) ;
2454: IF P_DEBUG_MODE = 'Y' THEN
2455: pa_debug.write_file('populate_run_targets: ' || 'LOG','Exploded proj/tasks: '|| to_char(v_tgt_project_id) ||
2456: to_char(v_tgt_task_id) ||
2457: to_char(v_tgt_top_task_id));

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

2477: END IF; /* exclude_curr_proj_task */
2478: END LOOP;
2479: END IF;
2480: END LOOP;
2481: DBMS_SQL.CLOSE_CURSOR(v_target_csr_id ); --added for bug 3799389
2482: /* -- validate budget_entry_level_code for trg_proj --------------- */
2483: IF( p_bas_budget_entry_method_code IS NOT NULL) THEN
2484: pa_debug.G_err_stage:= 'VALIDATING BASIS BUDGET ENTRY METHOD TO TRG PROJECTS';
2485: IF P_DEBUG_MODE = 'Y' THEN