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.PNP_UTIL_FUNC dependencies on DBMS_SQL

Line 603: l_cursor := DBMS_SQL.OPEN_CURSOR;

599: loc_index := 0;
600: alloc_area := 0;
601: l_statement := l_statement || ')';
602:
603: l_cursor := DBMS_SQL.OPEN_CURSOR;
604: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
605: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
607: dbms_sql.define_column (l_cursor, 1,alloc_area);

Line 604: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);

600: alloc_area := 0;
601: l_statement := l_statement || ')';
602:
603: l_cursor := DBMS_SQL.OPEN_CURSOR;
604: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
605: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
607: dbms_sql.define_column (l_cursor, 1,alloc_area);
608: l_rows := DBMS_SQL.execute(l_cursor);

Line 605: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );

601: l_statement := l_statement || ')';
602:
603: l_cursor := DBMS_SQL.OPEN_CURSOR;
604: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
605: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
607: dbms_sql.define_column (l_cursor, 1,alloc_area);
608: l_rows := DBMS_SQL.execute(l_cursor);
609: l_rows := dbms_sql.fetch_rows( l_cursor );

Line 606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );

602:
603: l_cursor := DBMS_SQL.OPEN_CURSOR;
604: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
605: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
607: dbms_sql.define_column (l_cursor, 1,alloc_area);
608: l_rows := DBMS_SQL.execute(l_cursor);
609: l_rows := dbms_sql.fetch_rows( l_cursor );
610: dbms_sql.column_value (l_cursor, 1,alloc_area);

Line 607: dbms_sql.define_column (l_cursor, 1,alloc_area);

603: l_cursor := DBMS_SQL.OPEN_CURSOR;
604: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
605: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
607: dbms_sql.define_column (l_cursor, 1,alloc_area);
608: l_rows := DBMS_SQL.execute(l_cursor);
609: l_rows := dbms_sql.fetch_rows( l_cursor );
610: dbms_sql.column_value (l_cursor, 1,alloc_area);
611: DBMS_SQL.CLOSE_CURSOR (l_cursor);

Line 608: l_rows := DBMS_SQL.execute(l_cursor);

604: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
605: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
607: dbms_sql.define_column (l_cursor, 1,alloc_area);
608: l_rows := DBMS_SQL.execute(l_cursor);
609: l_rows := dbms_sql.fetch_rows( l_cursor );
610: dbms_sql.column_value (l_cursor, 1,alloc_area);
611: DBMS_SQL.CLOSE_CURSOR (l_cursor);
612:

Line 609: l_rows := dbms_sql.fetch_rows( l_cursor );

605: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
607: dbms_sql.define_column (l_cursor, 1,alloc_area);
608: l_rows := DBMS_SQL.execute(l_cursor);
609: l_rows := dbms_sql.fetch_rows( l_cursor );
610: dbms_sql.column_value (l_cursor, 1,alloc_area);
611: DBMS_SQL.CLOSE_CURSOR (l_cursor);
612:
613: l_statement := '';

Line 610: dbms_sql.column_value (l_cursor, 1,alloc_area);

606: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
607: dbms_sql.define_column (l_cursor, 1,alloc_area);
608: l_rows := DBMS_SQL.execute(l_cursor);
609: l_rows := dbms_sql.fetch_rows( l_cursor );
610: dbms_sql.column_value (l_cursor, 1,alloc_area);
611: DBMS_SQL.CLOSE_CURSOR (l_cursor);
612:
613: l_statement := '';
614: l_Allocated_Area_Emp := NVL(l_Allocated_Area_Emp, 0) + alloc_area;

Line 611: DBMS_SQL.CLOSE_CURSOR (l_cursor);

607: dbms_sql.define_column (l_cursor, 1,alloc_area);
608: l_rows := DBMS_SQL.execute(l_cursor);
609: l_rows := dbms_sql.fetch_rows( l_cursor );
610: dbms_sql.column_value (l_cursor, 1,alloc_area);
611: DBMS_SQL.CLOSE_CURSOR (l_cursor);
612:
613: l_statement := '';
614: l_Allocated_Area_Emp := NVL(l_Allocated_Area_Emp, 0) + alloc_area;
615: end if;

Line 623: l_cursor := DBMS_SQL.OPEN_CURSOR;

619: loc_index := 0;
620: alloc_area := 0;
621: l_statement := l_statement || ')';
622:
623: l_cursor := DBMS_SQL.OPEN_CURSOR;
624: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
625: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
627: dbms_sql.define_column (l_cursor, 1,alloc_area);

Line 624: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);

620: alloc_area := 0;
621: l_statement := l_statement || ')';
622:
623: l_cursor := DBMS_SQL.OPEN_CURSOR;
624: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
625: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
627: dbms_sql.define_column (l_cursor, 1,alloc_area);
628: l_rows := DBMS_SQL.execute(l_cursor);

Line 625: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );

621: l_statement := l_statement || ')';
622:
623: l_cursor := DBMS_SQL.OPEN_CURSOR;
624: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
625: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
627: dbms_sql.define_column (l_cursor, 1,alloc_area);
628: l_rows := DBMS_SQL.execute(l_cursor);
629: l_rows := dbms_sql.fetch_rows( l_cursor );

Line 626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );

622:
623: l_cursor := DBMS_SQL.OPEN_CURSOR;
624: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
625: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
627: dbms_sql.define_column (l_cursor, 1,alloc_area);
628: l_rows := DBMS_SQL.execute(l_cursor);
629: l_rows := dbms_sql.fetch_rows( l_cursor );
630: dbms_sql.column_value (l_cursor, 1,alloc_area);

Line 627: dbms_sql.define_column (l_cursor, 1,alloc_area);

623: l_cursor := DBMS_SQL.OPEN_CURSOR;
624: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
625: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
627: dbms_sql.define_column (l_cursor, 1,alloc_area);
628: l_rows := DBMS_SQL.execute(l_cursor);
629: l_rows := dbms_sql.fetch_rows( l_cursor );
630: dbms_sql.column_value (l_cursor, 1,alloc_area);
631: DBMS_SQL.CLOSE_CURSOR (l_cursor);

Line 628: l_rows := DBMS_SQL.execute(l_cursor);

624: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
625: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
627: dbms_sql.define_column (l_cursor, 1,alloc_area);
628: l_rows := DBMS_SQL.execute(l_cursor);
629: l_rows := dbms_sql.fetch_rows( l_cursor );
630: dbms_sql.column_value (l_cursor, 1,alloc_area);
631: DBMS_SQL.CLOSE_CURSOR (l_cursor);
632:

Line 629: l_rows := dbms_sql.fetch_rows( l_cursor );

625: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
627: dbms_sql.define_column (l_cursor, 1,alloc_area);
628: l_rows := DBMS_SQL.execute(l_cursor);
629: l_rows := dbms_sql.fetch_rows( l_cursor );
630: dbms_sql.column_value (l_cursor, 1,alloc_area);
631: DBMS_SQL.CLOSE_CURSOR (l_cursor);
632:
633: l_statement := '';

Line 630: dbms_sql.column_value (l_cursor, 1,alloc_area);

626: dbms_sql.bind_variable (l_cursor,'l_date',l_date );
627: dbms_sql.define_column (l_cursor, 1,alloc_area);
628: l_rows := DBMS_SQL.execute(l_cursor);
629: l_rows := dbms_sql.fetch_rows( l_cursor );
630: dbms_sql.column_value (l_cursor, 1,alloc_area);
631: DBMS_SQL.CLOSE_CURSOR (l_cursor);
632:
633: l_statement := '';
634: l_Allocated_Area_Emp := NVL(l_Allocated_Area_Emp, 0) + alloc_area;

Line 631: DBMS_SQL.CLOSE_CURSOR (l_cursor);

627: dbms_sql.define_column (l_cursor, 1,alloc_area);
628: l_rows := DBMS_SQL.execute(l_cursor);
629: l_rows := dbms_sql.fetch_rows( l_cursor );
630: dbms_sql.column_value (l_cursor, 1,alloc_area);
631: DBMS_SQL.CLOSE_CURSOR (l_cursor);
632:
633: l_statement := '';
634: l_Allocated_Area_Emp := NVL(l_Allocated_Area_Emp, 0) + alloc_area;
635: end if;

Line 1224: l_cursor := DBMS_SQL.OPEN_CURSOR;

1220: loc_index := 0;
1221: utilized_cap := 0;
1222: l_statement := l_statement || ')';
1223:
1224: l_cursor := DBMS_SQL.OPEN_CURSOR;
1225: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1226: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);

Line 1225: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);

1221: utilized_cap := 0;
1222: l_statement := l_statement || ')';
1223:
1224: l_cursor := DBMS_SQL.OPEN_CURSOR;
1225: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1226: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1229: l_rows := DBMS_SQL.execute(l_cursor);

Line 1226: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );

1222: l_statement := l_statement || ')';
1223:
1224: l_cursor := DBMS_SQL.OPEN_CURSOR;
1225: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1226: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1229: l_rows := DBMS_SQL.execute(l_cursor);
1230: l_rows := dbms_sql.fetch_rows( l_cursor );

Line 1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );

1223:
1224: l_cursor := DBMS_SQL.OPEN_CURSOR;
1225: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1226: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1229: l_rows := DBMS_SQL.execute(l_cursor);
1230: l_rows := dbms_sql.fetch_rows( l_cursor );
1231: dbms_sql.column_value (l_cursor, 1,utilized_cap);

Line 1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);

1224: l_cursor := DBMS_SQL.OPEN_CURSOR;
1225: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1226: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1229: l_rows := DBMS_SQL.execute(l_cursor);
1230: l_rows := dbms_sql.fetch_rows( l_cursor );
1231: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1232: DBMS_SQL.CLOSE_CURSOR (l_cursor);

Line 1229: l_rows := DBMS_SQL.execute(l_cursor);

1225: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1226: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1229: l_rows := DBMS_SQL.execute(l_cursor);
1230: l_rows := dbms_sql.fetch_rows( l_cursor );
1231: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1232: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1233:

Line 1230: l_rows := dbms_sql.fetch_rows( l_cursor );

1226: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1229: l_rows := DBMS_SQL.execute(l_cursor);
1230: l_rows := dbms_sql.fetch_rows( l_cursor );
1231: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1232: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1233:
1234: l_statement := '';

Line 1231: dbms_sql.column_value (l_cursor, 1,utilized_cap);

1227: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1229: l_rows := DBMS_SQL.execute(l_cursor);
1230: l_rows := dbms_sql.fetch_rows( l_cursor );
1231: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1232: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1233:
1234: l_statement := '';
1235: l_UtilizedCapacityEmp := NVL(l_UtilizedCapacityEmp, 0) + utilized_cap;

Line 1232: DBMS_SQL.CLOSE_CURSOR (l_cursor);

1228: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1229: l_rows := DBMS_SQL.execute(l_cursor);
1230: l_rows := dbms_sql.fetch_rows( l_cursor );
1231: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1232: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1233:
1234: l_statement := '';
1235: l_UtilizedCapacityEmp := NVL(l_UtilizedCapacityEmp, 0) + utilized_cap;
1236: end if;

Line 1244: l_cursor := DBMS_SQL.OPEN_CURSOR;

1240: loc_index := 0;
1241: utilized_cap := 0;
1242: l_statement := l_statement || ')';
1243:
1244: l_cursor := DBMS_SQL.OPEN_CURSOR;
1245: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1246: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);

Line 1245: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);

1241: utilized_cap := 0;
1242: l_statement := l_statement || ')';
1243:
1244: l_cursor := DBMS_SQL.OPEN_CURSOR;
1245: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1246: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1249: l_rows := DBMS_SQL.execute(l_cursor);

Line 1246: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );

1242: l_statement := l_statement || ')';
1243:
1244: l_cursor := DBMS_SQL.OPEN_CURSOR;
1245: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1246: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1249: l_rows := DBMS_SQL.execute(l_cursor);
1250: l_rows := dbms_sql.fetch_rows( l_cursor );

Line 1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );

1243:
1244: l_cursor := DBMS_SQL.OPEN_CURSOR;
1245: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1246: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1249: l_rows := DBMS_SQL.execute(l_cursor);
1250: l_rows := dbms_sql.fetch_rows( l_cursor );
1251: dbms_sql.column_value (l_cursor, 1,utilized_cap);

Line 1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);

1244: l_cursor := DBMS_SQL.OPEN_CURSOR;
1245: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1246: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1249: l_rows := DBMS_SQL.execute(l_cursor);
1250: l_rows := dbms_sql.fetch_rows( l_cursor );
1251: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1252: DBMS_SQL.CLOSE_CURSOR (l_cursor);

Line 1249: l_rows := DBMS_SQL.execute(l_cursor);

1245: DBMS_SQL.PARSE (l_cursor, l_query || l_statement, DBMS_SQL.native);
1246: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1249: l_rows := DBMS_SQL.execute(l_cursor);
1250: l_rows := dbms_sql.fetch_rows( l_cursor );
1251: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1252: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1253:

Line 1250: l_rows := dbms_sql.fetch_rows( l_cursor );

1246: dbms_sql.bind_variable (l_cursor,'p_as_of_date',l_As_Of_Date );
1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1249: l_rows := DBMS_SQL.execute(l_cursor);
1250: l_rows := dbms_sql.fetch_rows( l_cursor );
1251: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1252: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1253:
1254: l_statement := '';

Line 1251: dbms_sql.column_value (l_cursor, 1,utilized_cap);

1247: dbms_sql.bind_variable (l_cursor,'g_end_of_time',g_end_of_time );
1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1249: l_rows := DBMS_SQL.execute(l_cursor);
1250: l_rows := dbms_sql.fetch_rows( l_cursor );
1251: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1252: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1253:
1254: l_statement := '';
1255: l_UtilizedCapacityEmp := NVL(l_UtilizedCapacityEmp, 0) + utilized_cap;

Line 1252: DBMS_SQL.CLOSE_CURSOR (l_cursor);

1248: dbms_sql.define_column (l_cursor, 1,utilized_cap);
1249: l_rows := DBMS_SQL.execute(l_cursor);
1250: l_rows := dbms_sql.fetch_rows( l_cursor );
1251: dbms_sql.column_value (l_cursor, 1,utilized_cap);
1252: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1253:
1254: l_statement := '';
1255: l_UtilizedCapacityEmp := NVL(l_UtilizedCapacityEmp, 0) + utilized_cap;
1256: end if;

Line 1828: l_cursor := dbms_sql.open_cursor;

1824: WHERE default_code_combination_id = code_combination_id
1825: AND employee_id = :l_employee_id';
1826:
1827: /* open cursor */
1828: l_cursor := dbms_sql.open_cursor;
1829:
1830: /* parse */
1831: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1832:

Line 1831: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);

1827: /* open cursor */
1828: l_cursor := dbms_sql.open_cursor;
1829:
1830: /* parse */
1831: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1832:
1833: /* bind variables */
1834: dbms_sql.bind_variable(l_cursor,'l_employee_id',l_employee_id);
1835:

Line 1834: dbms_sql.bind_variable(l_cursor,'l_employee_id',l_employee_id);

1830: /* parse */
1831: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1832:
1833: /* bind variables */
1834: dbms_sql.bind_variable(l_cursor,'l_employee_id',l_employee_id);
1835:
1836: /* define column */
1837: dbms_sql.define_column (l_cursor,1,p_cost_center,30);
1838:

Line 1837: dbms_sql.define_column (l_cursor,1,p_cost_center,30);

1833: /* bind variables */
1834: dbms_sql.bind_variable(l_cursor,'l_employee_id',l_employee_id);
1835:
1836: /* define column */
1837: dbms_sql.define_column (l_cursor,1,p_cost_center,30);
1838:
1839: /* execute query and fetch */
1840: l_rows := dbms_sql.execute(l_cursor);
1841: l_count := dbms_sql.fetch_rows(l_cursor);

Line 1840: l_rows := dbms_sql.execute(l_cursor);

1836: /* define column */
1837: dbms_sql.define_column (l_cursor,1,p_cost_center,30);
1838:
1839: /* execute query and fetch */
1840: l_rows := dbms_sql.execute(l_cursor);
1841: l_count := dbms_sql.fetch_rows(l_cursor);
1842:
1843: /* get the value */
1844: dbms_sql.column_value(l_cursor,1,p_cost_center);

Line 1841: l_count := dbms_sql.fetch_rows(l_cursor);

1837: dbms_sql.define_column (l_cursor,1,p_cost_center,30);
1838:
1839: /* execute query and fetch */
1840: l_rows := dbms_sql.execute(l_cursor);
1841: l_count := dbms_sql.fetch_rows(l_cursor);
1842:
1843: /* get the value */
1844: dbms_sql.column_value(l_cursor,1,p_cost_center);
1845:

Line 1844: dbms_sql.column_value(l_cursor,1,p_cost_center);

1840: l_rows := dbms_sql.execute(l_cursor);
1841: l_count := dbms_sql.fetch_rows(l_cursor);
1842:
1843: /* get the value */
1844: dbms_sql.column_value(l_cursor,1,p_cost_center);
1845:
1846: /* if cursor open, close */
1847: IF dbms_sql.is_open (l_cursor) THEN
1848: dbms_sql.close_cursor (l_cursor);

Line 1847: IF dbms_sql.is_open (l_cursor) THEN

1843: /* get the value */
1844: dbms_sql.column_value(l_cursor,1,p_cost_center);
1845:
1846: /* if cursor open, close */
1847: IF dbms_sql.is_open (l_cursor) THEN
1848: dbms_sql.close_cursor (l_cursor);
1849: END IF;
1850:
1851:

Line 1848: dbms_sql.close_cursor (l_cursor);

1844: dbms_sql.column_value(l_cursor,1,p_cost_center);
1845:
1846: /* if cursor open, close */
1847: IF dbms_sql.is_open (l_cursor) THEN
1848: dbms_sql.close_cursor (l_cursor);
1849: END IF;
1850:
1851:
1852:

Line 2066: l_cursor := dbms_sql.open_cursor;

2062: --Bug#6366630: Added the IF condition to control Cost Center Validation using Profile Option --
2063: IF nvl(pn_mo_cache_utils.get_profile_value('PN_VALIDATE_ASSIGN_CC', p_org_id),'Y') = 'Y' THEN
2064: l_column_name := ltrim(rtrim(get_segment_column_name(p_org_id)));
2065: l_cost_center := p_cost_center;
2066: l_cursor := dbms_sql.open_cursor;
2067:
2068:
2069: sql_statement :=
2070: 'select account_type

Line 2073: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);

2069: sql_statement :=
2070: 'select account_type
2071: from gl_code_combinations where '||l_column_name||' = :l_cost_center';
2072:
2073: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
2074: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
2075: dbms_sql.define_column (l_cursor,1,l_dummy,1);
2076: l_rows := dbms_sql.execute(l_cursor);
2077: l_count := dbms_sql.fetch_rows(l_cursor);

Line 2074: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);

2070: 'select account_type
2071: from gl_code_combinations where '||l_column_name||' = :l_cost_center';
2072:
2073: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
2074: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
2075: dbms_sql.define_column (l_cursor,1,l_dummy,1);
2076: l_rows := dbms_sql.execute(l_cursor);
2077: l_count := dbms_sql.fetch_rows(l_cursor);
2078: dbms_sql.column_value (l_cursor,1,l_dummy);

Line 2075: dbms_sql.define_column (l_cursor,1,l_dummy,1);

2071: from gl_code_combinations where '||l_column_name||' = :l_cost_center';
2072:
2073: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
2074: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
2075: dbms_sql.define_column (l_cursor,1,l_dummy,1);
2076: l_rows := dbms_sql.execute(l_cursor);
2077: l_count := dbms_sql.fetch_rows(l_cursor);
2078: dbms_sql.column_value (l_cursor,1,l_dummy);
2079: IF dbms_sql.is_open (l_cursor) THEN

Line 2076: l_rows := dbms_sql.execute(l_cursor);

2072:
2073: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
2074: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
2075: dbms_sql.define_column (l_cursor,1,l_dummy,1);
2076: l_rows := dbms_sql.execute(l_cursor);
2077: l_count := dbms_sql.fetch_rows(l_cursor);
2078: dbms_sql.column_value (l_cursor,1,l_dummy);
2079: IF dbms_sql.is_open (l_cursor) THEN
2080: dbms_sql.close_cursor (l_cursor);

Line 2077: l_count := dbms_sql.fetch_rows(l_cursor);

2073: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
2074: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
2075: dbms_sql.define_column (l_cursor,1,l_dummy,1);
2076: l_rows := dbms_sql.execute(l_cursor);
2077: l_count := dbms_sql.fetch_rows(l_cursor);
2078: dbms_sql.column_value (l_cursor,1,l_dummy);
2079: IF dbms_sql.is_open (l_cursor) THEN
2080: dbms_sql.close_cursor (l_cursor);
2081: END IF;

Line 2078: dbms_sql.column_value (l_cursor,1,l_dummy);

2074: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
2075: dbms_sql.define_column (l_cursor,1,l_dummy,1);
2076: l_rows := dbms_sql.execute(l_cursor);
2077: l_count := dbms_sql.fetch_rows(l_cursor);
2078: dbms_sql.column_value (l_cursor,1,l_dummy);
2079: IF dbms_sql.is_open (l_cursor) THEN
2080: dbms_sql.close_cursor (l_cursor);
2081: END IF;
2082: IF l_count <> 1 THEN

Line 2079: IF dbms_sql.is_open (l_cursor) THEN

2075: dbms_sql.define_column (l_cursor,1,l_dummy,1);
2076: l_rows := dbms_sql.execute(l_cursor);
2077: l_count := dbms_sql.fetch_rows(l_cursor);
2078: dbms_sql.column_value (l_cursor,1,l_dummy);
2079: IF dbms_sql.is_open (l_cursor) THEN
2080: dbms_sql.close_cursor (l_cursor);
2081: END IF;
2082: IF l_count <> 1 THEN
2083: RETURN false;

Line 2080: dbms_sql.close_cursor (l_cursor);

2076: l_rows := dbms_sql.execute(l_cursor);
2077: l_count := dbms_sql.fetch_rows(l_cursor);
2078: dbms_sql.column_value (l_cursor,1,l_dummy);
2079: IF dbms_sql.is_open (l_cursor) THEN
2080: dbms_sql.close_cursor (l_cursor);
2081: END IF;
2082: IF l_count <> 1 THEN
2083: RETURN false;
2084: END IF;