APPS.QLTVCREB dependencies on QA_SS_CONST

Line 405: IF current_element = qa_ss_const.sales_order THEN

401: --
402: -- If the element has a specially-coded stored function, then
403: -- use the stored function...
404: --
405: IF current_element = qa_ss_const.sales_order THEN
406: v_sql_table(i) := ', qr.' || l_element_hardcoded_column;
407: i := i + 1;
408: v_sql_table(i) := ', qa_flex_util.sales_order(qr.so_header_id) "'
409: || trans(l_element_name) || '"';

Line 413: ELSIF current_element = qa_ss_const.rma_number THEN

409: || trans(l_element_name) || '"';
410: i := i + 1;
411: column_count := column_count + 2;
412:
413: ELSIF current_element = qa_ss_const.rma_number THEN
414: v_sql_table(i) := ', qr.' || l_element_hardcoded_column;
415: i := i + 1;
416: v_sql_table(i) := ', qa_flex_util.rma_number(qr.rma_header_id) "'
417: || trans(l_element_name) || '"';

Line 421: ELSIF current_element = qa_ss_const.project_number THEN

417: || trans(l_element_name) || '"';
418: i := i + 1;
419: column_count := column_count + 2;
420:
421: ELSIF current_element = qa_ss_const.project_number THEN
422: v_sql_table(i) := ', qr.' || l_element_hardcoded_column;
423: i := i + 1;
424: v_sql_table(i) := ', qa_flex_util.project_number(qr.project_id) "'
425: || trans(l_element_name) || '"';

Line 813: IF fk.char_id = qa_ss_const.sales_order THEN

809: --(qr.status IS NULL OR qr.status = 2)';
810:
811: FOR fk in pcursor LOOP
812:
813: IF fk.char_id = qa_ss_const.sales_order THEN
814: v_select := v_select || ', qr.' || fk.hardcoded_column;
815: v_select := v_select ||
816: ', qa_flex_util.sales_order(qr.so_header_id) "' || fk.name || '"';
817:

Line 818: ELSIF fk.char_id = qa_ss_const.rma_number THEN

814: v_select := v_select || ', qr.' || fk.hardcoded_column;
815: v_select := v_select ||
816: ', qa_flex_util.sales_order(qr.so_header_id) "' || fk.name || '"';
817:
818: ELSIF fk.char_id = qa_ss_const.rma_number THEN
819: v_select := v_select || ', qr.' || fk.hardcoded_column;
820: v_select := v_select ||
821: ', qa_flex_util.rma_number(qr.rma_header_id) "' || fk.name || '"';
822:

Line 823: ELSIF fk.char_id = qa_ss_const.project_number THEN

819: v_select := v_select || ', qr.' || fk.hardcoded_column;
820: v_select := v_select ||
821: ', qa_flex_util.rma_number(qr.rma_header_id) "' || fk.name || '"';
822:
823: ELSIF fk.char_id = qa_ss_const.project_number THEN
824: v_select := v_select || ', qr.' || fk.hardcoded_column;
825: v_select := v_select ||
826: ', qa_flex_util.project_number(qr.project_id) "' || fk.name || '"';
827: