APPS.QA_CHAR_INDEXES_PKG dependencies on QA_CHAR_INDEXES

Line 1: PACKAGE BODY qa_char_indexes_pkg AS

1: PACKAGE BODY qa_char_indexes_pkg AS
2: /* $Header: qaindexb.pls 120.0 2005/05/24 19:10:53 appldev noship $ */
3:
4: -- A constant to fool GSCC. See bug 3554899
5: -- Copied from qltvcreb

Line 31: FROM qa_char_indexes

27:
28:
29: CURSOR c_enabled(p_char_id NUMBER) IS
30: SELECT enabled_flag
31: FROM qa_char_indexes
32: WHERE char_id = p_char_id;
33:
34:
35: FUNCTION index_exists(p_char_id NUMBER)

Line 99: FROM qa_char_indexes

95: --
96:
97: CURSOR c IS
98: SELECT default_result_column
99: FROM qa_char_indexes
100: WHERE char_id = p_char_id AND enabled_flag = 1;
101:
102: l_result_column VARCHAR2(30);
103:

Line 124: UPDATE qa_char_indexes

120: -- a negative error code if not (or if index doesn't exist).
121: -- Does not perform database commit.
122: --
123: BEGIN
124: UPDATE qa_char_indexes
125: SET enabled_flag = 2
126: WHERE char_id = p_char_id;
127:
128: RETURN 0;

Line 442: FROM qa_char_indexes

438: p_additional_parameters VARCHAR2) IS
439:
440: CURSOR c IS
441: SELECT rowid
442: FROM qa_char_indexes
443: WHERE char_id = p_char_id;
444:
445: BEGIN
446: INSERT INTO qa_char_indexes(

Line 446: INSERT INTO qa_char_indexes(

442: FROM qa_char_indexes
443: WHERE char_id = p_char_id;
444:
445: BEGIN
446: INSERT INTO qa_char_indexes(
447: created_by,
448: creation_date,
449: last_updated_by,
450: last_update_date,

Line 501: FROM qa_char_indexes

497: --
498: BEGIN
499:
500: DELETE
501: FROM qa_char_indexes
502: WHERE char_id = p_char_id;
503:
504: IF SQL%NOTFOUND THEN
505: RAISE no_data_found;

Line 514: -- qa_char_indexes table is also deleted to register the fact.

510:
511: FUNCTION drop_index(p_char_id NUMBER) RETURN INTEGER IS
512: --
513: -- Main function to drop an index. If successful, the index record in
514: -- qa_char_indexes table is also deleted to register the fact.
515: --
516: -- Return 0 if successful, a negative error code if not.
517: --
518: -- Because this is a DDL, by definition a commit is

Line 525: FROM qa_char_indexes

521: l_index_name VARCHAR2(30);
522: l_ddl VARCHAR2(100);
523: CURSOR c IS
524: SELECT index_name
525: FROM qa_char_indexes
526: WHERE char_id = p_char_id;
527: BEGIN
528: SAVEPOINT l_drop_index;
529:

Line 580: -- successfully, then the qa_char_indexes table is

576: --
577: -- Main function to create or regenerate index.
578: -- If an index already exists, then it is dropped before
579: -- creating. If an index is created or regenerated
580: -- successfully, then the qa_char_indexes table is
581: -- updated with that fact.
582: --
583: -- Return 0 if successful, a negative error code if not.
584: --

Line 650: FROM qa_char_indexes

646: -- for varchar2 conversions. kabalakr.
647:
648: CURSOR c IS
649: SELECT dbms_lob.substr(text, dbms_lob.getlength(text), 1)
650: FROM qa_char_indexes
651: WHERE char_id = p_char_id AND enabled_flag = 1;
652:
653: BEGIN
654: OPEN c;

Line 706: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: entered the wrapper');

702: l_return NUMBER;
703:
704: BEGIN
705:
706: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: entered the wrapper');
707:
708: l_type_of_action := to_number(argument1);
709: l_char_id := to_number(argument3);
710:

Line 747: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: exiting the wrapper');

743: retcode := 2;
744: END IF;
745: END IF;
746:
747: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: exiting the wrapper');
748:
749: END wrapper;
750:
751:

Line 827: END qa_char_indexes_pkg;

823: status => g_status,
824: industry => g_industry,
825: oracle_schema => g_qa_schema);
826:
827: END qa_char_indexes_pkg;