APPS.ITG_ORGEFF_PVT dependencies on ITG_ORG_INDICATOR

Line 13: FROM itg_org_indicator

9: p_doctyp VARCHAR2,
10: p_pubsub VARCHAR2
11: ) IS
12: SELECT org_controlled
13: FROM itg_org_indicator
14: WHERE cln_doc_type = p_doctyp
15: AND doc_direction = p_pubsub;
16:
17: /* Check the effectivity. */

Line 58: l_orgind itg_org_indicator.org_controlled%TYPE;

54: AND doc_direction = p_pubsub;
55:
56: l_found BOOLEAN;
57: l_orgid NUMBER;
58: l_orgind itg_org_indicator.org_controlled%TYPE;
59: l_orgeff orgeff_csr%ROWTYPE;
60: BEGIN
61: /* Check if effectivity restrictions are globally enabled. */
62: /* TBD: add the site profile item ITG_ORG_EFFECTIVE ('Y'/'N'). */

Line 131: l_dummy itg_org_indicator.org_controlled%TYPE;

127: l_api_version CONSTANT NUMBER := 1.0;
128:
129: l_found BOOLEAN;
130: l_eff_id NUMBER;
131: l_dummy itg_org_indicator.org_controlled%TYPE;
132: l_count NUMBER;
133: l_flag VARCHAR2(1);
134:
135: CURSOR existing_row_csr IS