DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on PO_DOCUMENT_TYPES

Line 59: FROM po_document_types podt

55: /* Get the security_level */
56:
57: SELECT podt.security_level_code
58: INTO x_security_level
59: FROM po_document_types podt
60: WHERE podt.document_subtype = x_subtype_code
61: AND podt.document_type_code = x_object_type_code;
62:
63: x_progress := '030';

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

96:
97: is
98:
99: /* Start Bug 3336172 */
100: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
101: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
102: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
103:
104: l_sec_level_tbl g_sec_level_tbl_type;

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

97: is
98:
99: /* Start Bug 3336172 */
100: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
101: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
102: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
103:
104: l_sec_level_tbl g_sec_level_tbl_type;
105: l_doc_type_code_tbl g_doc_type_code_tbl_type;

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

98:
99: /* Start Bug 3336172 */
100: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
101: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
102: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
103:
104: l_sec_level_tbl g_sec_level_tbl_type;
105: l_doc_type_code_tbl g_doc_type_code_tbl_type;
106: l_doc_subtype_tbl g_doc_subtype_tbl_type;

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

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

Line 135: FROM po_document_types_b

131: */
132:
133: SELECT security_level_code, document_type_code, document_subtype
134: BULK COLLECT into l_sec_level_tbl, l_doc_type_code_tbl, l_doc_subtype_tbl
135: FROM po_document_types_b
136: WHERE (document_type_code = 'PO' and document_subtype = 'STANDARD')
137: or (document_type_code = 'PA' and document_subtype = 'BLANKET')
138: or (document_type_code = 'PA' and document_subtype = 'CONTRACT')
139: or (document_type_code = 'PO' and document_subtype = 'PLANNED')

Line 201: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

197: -- refactored entire procedure to remove duplicate logic
198: -- and call the new get_active_encumbrance_amount API instead
199:
200: l_return_status VARCHAR2(1);
201: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
202: l_progress VARCHAR2(3);
203: x_active_enc_amount NUMBER;
204:
205: BEGIN

Line 1879: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,

1875: ===========================================================================*/
1876:
1877: FUNCTION get_type_name
1878: (
1879: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1881: )
1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1883: IS

Line 1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE

1876:
1877: FUNCTION get_type_name
1878: (
1879: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1881: )
1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1883: IS
1884: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;

Line 1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE

1878: (
1879: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1881: )
1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1883: IS
1884: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;
1885: BEGIN
1886:

Line 1884: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;

1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1881: )
1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1883: IS
1884: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;
1885: BEGIN
1886:
1887: SELECT type_name
1888: INTO x_type_name

Line 1889: FROM po_document_types_vl

1885: BEGIN
1886:
1887: SELECT type_name
1888: INTO x_type_name
1889: FROM po_document_types_vl
1890: WHERE document_type_code = p_document_type_code
1891: AND document_subtype = p_document_subtype;
1892:
1893: return (x_type_name);