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.PO_INQ_SV dependencies on PO_DOCUMENT_TYPES

Line 97: FROM po_document_types podt

93: /* Get the security_level */
94:
95: SELECT podt.security_level_code
96: INTO x_security_level
97: FROM po_document_types podt
98: WHERE podt.document_subtype = x_subtype_code
99: AND podt.document_type_code = x_object_type_code;
100:
101: x_progress := '030';

Line 138: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;

134:
135: is
136:
137: /* Start Bug 3336172 */
138: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
139: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
140: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
141:
142: l_sec_level_tbl g_sec_level_tbl_type;

Line 139: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;

135: is
136:
137: /* Start Bug 3336172 */
138: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
139: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
140: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
141:
142: l_sec_level_tbl g_sec_level_tbl_type;
143: l_doc_type_code_tbl g_doc_type_code_tbl_type;

Line 140: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;

136:
137: /* Start Bug 3336172 */
138: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
139: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
140: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
141:
142: l_sec_level_tbl g_sec_level_tbl_type;
143: l_doc_type_code_tbl g_doc_type_code_tbl_type;
144: l_doc_subtype_tbl g_doc_subtype_tbl_type;

Line 163: * B. Use the PO_DOCUMENT_TYPES_B base view instead of PO_DOCUMENT_TYPES

159: * A. Removing the 6 way cartesian join all on the same table.
160: * Instead, use a PL-SQL table variable to store the data
161: * we need, and then loop through it. This should avoid the
162: * massive join while also avoiding 6 PL/SQL to SQL context switches.
163: * B. Use the PO_DOCUMENT_TYPES_B base view instead of PO_DOCUMENT_TYPES
164: * There is no need for translation in this code, so the base view, which
165: * does not join with a translation table is a better choice.
166: * Note: we use three PL-SQL tables, as in 8I DB, you cannot bulk collect
167: * into a table of records! In 9I, that is allowed, but for now,

Line 173: FROM po_document_types_b

169: */
170:
171: SELECT security_level_code, document_type_code, document_subtype
172: BULK COLLECT into l_sec_level_tbl, l_doc_type_code_tbl, l_doc_subtype_tbl
173: FROM po_document_types_b
174: WHERE (document_type_code = 'PO' and document_subtype = 'STANDARD')
175: or (document_type_code = 'PA' and document_subtype = 'BLANKET')
176: or (document_type_code = 'PA' and document_subtype = 'CONTRACT')
177: or (document_type_code = 'PO' and document_subtype = 'PLANNED')

Line 239: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

235: -- refactored entire procedure to remove duplicate logic
236: -- and call the new get_active_encumbrance_amount API instead
237:
238: l_return_status VARCHAR2(1);
239: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
240: l_progress VARCHAR2(3);
241: x_active_enc_amount NUMBER;
242:
243: BEGIN

Line 1933: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,

1929: ===========================================================================*/
1930:
1931: FUNCTION get_type_name
1932: (
1933: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1935: )
1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1937: IS

Line 1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE

1930:
1931: FUNCTION get_type_name
1932: (
1933: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1935: )
1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1937: IS
1938: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;

Line 1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE

1932: (
1933: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1935: )
1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1937: IS
1938: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;
1939: BEGIN
1940:

Line 1938: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;

1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1935: )
1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1937: IS
1938: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;
1939: BEGIN
1940:
1941: SELECT type_name
1942: INTO x_type_name

Line 1943: FROM po_document_types_vl

1939: BEGIN
1940:
1941: SELECT type_name
1942: INTO x_type_name
1943: FROM po_document_types_vl
1944: WHERE document_type_code = p_document_type_code
1945: AND document_subtype = p_document_subtype;
1946:
1947: return (x_type_name);