DBA Data[Home] [Help]

APPS.QA_LOCATION dependencies on QA_SS_CONST

Line 34: qa_ss_const.LOCATION, 'QR.', l_most_common, final);

30: -- Bug 3930666. Construct the decode statement
31: -- using the efficient qa_char_indexes_pkg.
32: --
33: l_status := qa_char_indexes_pkg.construct_decode_function(
34: qa_ss_const.LOCATION, 'QR.', l_most_common, final);
35:
36: IF l_status = qa_char_indexes_pkg.ERR_ELEMENT_NOT_IN_USE THEN
37: -- Great! Element not in use, simply return.
38: RETURN;

Line 75: dbms_sql.bind_variable(c, ':1', qa_ss_const.LOCATION);

71: WHERE qpc.char_id = :1 AND qpc.plan_id = qr.plan_id AND :2 = ';
72:
73: c := dbms_sql.open_cursor;
74: dbms_sql.parse(c, final, 0, final.last, false, dbms_sql.native);
75: dbms_sql.bind_variable(c, ':1', qa_ss_const.LOCATION);
76: dbms_sql.bind_variable(c, ':2', loc_code);
77: n := dbms_sql.execute_and_fetch(c);
78: dbms_sql.close_cursor(c);
79: