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

Line 283: l_create_csr := dbms_sql.open_cursor;

279:
280: --update ldh set s=l_sql_string1;
281: --commit;
282:
283: l_create_csr := dbms_sql.open_cursor;
284:
285: -- Issue a dynamic SQL statement to create/recreate spec.
286: dbms_sql.parse(l_create_csr, l_sql_string1, dbms_sql.v7);
287: l_rows_processed := dbms_sql.execute(l_create_csr);

Line 286: dbms_sql.parse(l_create_csr, l_sql_string1, dbms_sql.v7);

282:
283: l_create_csr := dbms_sql.open_cursor;
284:
285: -- Issue a dynamic SQL statement to create/recreate spec.
286: dbms_sql.parse(l_create_csr, l_sql_string1, dbms_sql.v7);
287: l_rows_processed := dbms_sql.execute(l_create_csr);
288:
289: -- Issue a dynamic SQL statement to create/recreate body.
290: dbms_sql.parse(l_create_csr, l_sql_string2, dbms_sql.v7);

Line 287: l_rows_processed := dbms_sql.execute(l_create_csr);

283: l_create_csr := dbms_sql.open_cursor;
284:
285: -- Issue a dynamic SQL statement to create/recreate spec.
286: dbms_sql.parse(l_create_csr, l_sql_string1, dbms_sql.v7);
287: l_rows_processed := dbms_sql.execute(l_create_csr);
288:
289: -- Issue a dynamic SQL statement to create/recreate body.
290: dbms_sql.parse(l_create_csr, l_sql_string2, dbms_sql.v7);
291: l_rows_processed := dbms_sql.execute(l_create_csr);

Line 290: dbms_sql.parse(l_create_csr, l_sql_string2, dbms_sql.v7);

286: dbms_sql.parse(l_create_csr, l_sql_string1, dbms_sql.v7);
287: l_rows_processed := dbms_sql.execute(l_create_csr);
288:
289: -- Issue a dynamic SQL statement to create/recreate body.
290: dbms_sql.parse(l_create_csr, l_sql_string2, dbms_sql.v7);
291: l_rows_processed := dbms_sql.execute(l_create_csr);
292:
293: dbms_sql.close_cursor(l_create_csr);
294:

Line 291: l_rows_processed := dbms_sql.execute(l_create_csr);

287: l_rows_processed := dbms_sql.execute(l_create_csr);
288:
289: -- Issue a dynamic SQL statement to create/recreate body.
290: dbms_sql.parse(l_create_csr, l_sql_string2, dbms_sql.v7);
291: l_rows_processed := dbms_sql.execute(l_create_csr);
292:
293: dbms_sql.close_cursor(l_create_csr);
294:
295: -- Generic exception trap.

Line 293: dbms_sql.close_cursor(l_create_csr);

289: -- Issue a dynamic SQL statement to create/recreate body.
290: dbms_sql.parse(l_create_csr, l_sql_string2, dbms_sql.v7);
291: l_rows_processed := dbms_sql.execute(l_create_csr);
292:
293: dbms_sql.close_cursor(l_create_csr);
294:
295: -- Generic exception trap.
296: exception
297: when others then

Line 298: dbms_sql.close_cursor(l_create_csr);

294:
295: -- Generic exception trap.
296: exception
297: when others then
298: dbms_sql.close_cursor(l_create_csr);
299: raise;
300:
301: END create_record_package;
302:

Line 597: l_call_api_csr := dbms_sql.open_cursor;

593:
594: --update ldh set s=l_sql_string;
595: --commit;
596:
597: l_call_api_csr := dbms_sql.open_cursor;
598: dbms_sql.parse(l_call_api_csr, l_sql_string, dbms_sql.v7);
599:
600: -- Bind the variables v1..v'99' to sql string.
601: FOR i IN 1..p_attr_num LOOP

Line 598: dbms_sql.parse(l_call_api_csr, l_sql_string, dbms_sql.v7);

594: --update ldh set s=l_sql_string;
595: --commit;
596:
597: l_call_api_csr := dbms_sql.open_cursor;
598: dbms_sql.parse(l_call_api_csr, l_sql_string, dbms_sql.v7);
599:
600: -- Bind the variables v1..v'99' to sql string.
601: FOR i IN 1..p_attr_num LOOP
602: IF l_attr_tbl(i).data_type = 'NUM ' THEN

Line 603: dbms_sql.bind_variable(l_call_api_csr,

599:
600: -- Bind the variables v1..v'99' to sql string.
601: FOR i IN 1..p_attr_num LOOP
602: IF l_attr_tbl(i).data_type = 'NUM ' THEN
603: dbms_sql.bind_variable(l_call_api_csr,
604: 'v'||to_char(i),
605: to_number(l_attr_tbl(i).value));
606: ELSIF l_attr_tbl(i).data_type = 'CHAR' THEN
607: dbms_sql.bind_variable(l_call_api_csr,

Line 607: dbms_sql.bind_variable(l_call_api_csr,

603: dbms_sql.bind_variable(l_call_api_csr,
604: 'v'||to_char(i),
605: to_number(l_attr_tbl(i).value));
606: ELSIF l_attr_tbl(i).data_type = 'CHAR' THEN
607: dbms_sql.bind_variable(l_call_api_csr,
608: 'v'||to_char(i),
609: l_attr_tbl(i).value,
610: ATTR_VALUE_LEN);
611: ELSIF l_attr_tbl(i).data_type = 'DATE' THEN

Line 612: dbms_sql.bind_variable(l_call_api_csr,

608: 'v'||to_char(i),
609: l_attr_tbl(i).value,
610: ATTR_VALUE_LEN);
611: ELSIF l_attr_tbl(i).data_type = 'DATE' THEN
612: dbms_sql.bind_variable(l_call_api_csr,
613: 'v'||to_char(i),
614: to_date(l_attr_tbl(i).value, 'YYYYMMDDHH24MISS'));
615: END IF;
616: END LOOP;

Line 619: dbms_sql.bind_variable(l_call_api_csr, 'v_status', l_status, 1);

615: END IF;
616: END LOOP;
617:
618: -- Bind the variables v_status and v_message to sql string.
619: dbms_sql.bind_variable(l_call_api_csr, 'v_status', l_status, 1);
620: dbms_sql.bind_variable(l_call_api_csr, 'v_message', l_message, 2000);
621:
622: -- Call APIs.
623: l_rows_processed := dbms_sql.execute(l_call_api_csr);

Line 620: dbms_sql.bind_variable(l_call_api_csr, 'v_message', l_message, 2000);

616: END LOOP;
617:
618: -- Bind the variables v_status and v_message to sql string.
619: dbms_sql.bind_variable(l_call_api_csr, 'v_status', l_status, 1);
620: dbms_sql.bind_variable(l_call_api_csr, 'v_message', l_message, 2000);
621:
622: -- Call APIs.
623: l_rows_processed := dbms_sql.execute(l_call_api_csr);
624:

Line 623: l_rows_processed := dbms_sql.execute(l_call_api_csr);

619: dbms_sql.bind_variable(l_call_api_csr, 'v_status', l_status, 1);
620: dbms_sql.bind_variable(l_call_api_csr, 'v_message', l_message, 2000);
621:
622: -- Call APIs.
623: l_rows_processed := dbms_sql.execute(l_call_api_csr);
624:
625: -- Return variables v_status and v_message.
626: dbms_sql.variable_value(l_call_api_csr, 'v_status', l_status);
627: dbms_sql.variable_value(l_call_api_csr, 'v_message', l_message);

Line 626: dbms_sql.variable_value(l_call_api_csr, 'v_status', l_status);

622: -- Call APIs.
623: l_rows_processed := dbms_sql.execute(l_call_api_csr);
624:
625: -- Return variables v_status and v_message.
626: dbms_sql.variable_value(l_call_api_csr, 'v_status', l_status);
627: dbms_sql.variable_value(l_call_api_csr, 'v_message', l_message);
628: p_status := l_status;
629: p_message := l_message;
630:

Line 627: dbms_sql.variable_value(l_call_api_csr, 'v_message', l_message);

623: l_rows_processed := dbms_sql.execute(l_call_api_csr);
624:
625: -- Return variables v_status and v_message.
626: dbms_sql.variable_value(l_call_api_csr, 'v_status', l_status);
627: dbms_sql.variable_value(l_call_api_csr, 'v_message', l_message);
628: p_status := l_status;
629: p_message := l_message;
630:
631:

Line 644: dbms_sql.variable_value(l_call_api_csr, 'v'||to_char(i), l_temp_number);

640: rpad(l_attr_tbl(i).attribute_code, ATTR_CODE_LEN) ||
641: l_attr_tbl(i).data_type ||
642: l_attr_tbl(i).attribute_source;
643: IF l_attr_tbl(i).data_type = 'NUM ' THEN
644: dbms_sql.variable_value(l_call_api_csr, 'v'||to_char(i), l_temp_number);
645: l_attr_structure := l_attr_structure || ' ';
646: l_data_len := ATTR_NUMBER_LEN;
647: l_data_value := rpad(nvl(to_char(l_temp_number),' '), ATTR_NUMBER_LEN);
648: ELSIF l_attr_tbl(i).data_type = 'CHAR' THEN

Line 649: dbms_sql.variable_value(l_call_api_csr, 'v'||to_char(i), l_temp_char);

645: l_attr_structure := l_attr_structure || ' ';
646: l_data_len := ATTR_NUMBER_LEN;
647: l_data_value := rpad(nvl(to_char(l_temp_number),' '), ATTR_NUMBER_LEN);
648: ELSIF l_attr_tbl(i).data_type = 'CHAR' THEN
649: dbms_sql.variable_value(l_call_api_csr, 'v'||to_char(i), l_temp_char);
650: l_temp_char := rtrim(ltrim(l_temp_char));
651: l_data_len := nvl(length(l_temp_char), 0);
652: l_attr_structure := l_attr_structure || lpad(to_char(l_data_len), ATTR_SIZE_LEN);
653: l_data_value := l_temp_char;

Line 655: dbms_sql.variable_value(l_call_api_csr, 'v'||to_char(i), l_temp_date);

651: l_data_len := nvl(length(l_temp_char), 0);
652: l_attr_structure := l_attr_structure || lpad(to_char(l_data_len), ATTR_SIZE_LEN);
653: l_data_value := l_temp_char;
654: ELSIF l_attr_tbl(i).data_type = 'DATE' THEN
655: dbms_sql.variable_value(l_call_api_csr, 'v'||to_char(i), l_temp_date);
656: l_attr_structure := l_attr_structure || ' ';
657: l_data_len := ATTR_DATE_LEN;
658: l_data_value := rpad(nvl(to_char(l_temp_date, 'YYYYMMDDHH24MISS'),' '), ATTR_DATE_LEN);
659: END IF;

Line 667: dbms_sql.close_cursor(l_call_api_csr);

663: p_data := p_data || l_data_value;
664: END LOOP;
665: END IF;
666:
667: dbms_sql.close_cursor(l_call_api_csr);
668:
669: -- Generic exception trap.
670: exception
671: when others then

Line 686: dbms_sql.close_cursor(l_call_api_csr);

682: API Call 2 = ' || l_sql_call_string2;
683: p_message := l_message;
684:
685: p_status := 'E';
686: dbms_sql.close_cursor(l_call_api_csr);
687:
688: END api_shell;
689:
690: