APPS.ITG_ORGEFF_PVT dependencies on ITG_ORG_EFFECTIVITY

Line 34: FROM itg_org_effectivity

30: p_doctyp VARCHAR2,
31: p_pubsub VARCHAR2
32: ) IS
33: SELECT start_date, end_date, effectivity_enabled
34: FROM itg_org_effectivity
35: WHERE (organization_id = p_orgid OR organization_id IS NULL)
36: AND (cln_doc_type = p_doctyp OR cln_doc_type IS NULL)
37: AND doc_direction = p_pubsub
38: ORDER BY organization_id ASC,

Line 51: FROM itg_org_effectivity

47: p_doctyp VARCHAR2,
48: p_pubsub VARCHAR2
49: ) IS
50: SELECT start_date, end_date, effectivity_enabled
51: FROM itg_org_effectivity
52: WHERE NVL(organization_id, -1) = NVL(p_orgid, -1)
53: AND cln_doc_type = p_doctyp
54: AND doc_direction = p_pubsub;
55:

Line 137: FROM itg_org_effectivity

133: l_flag VARCHAR2(1);
134:
135: CURSOR existing_row_csr IS
136: SELECT effectivity_id
137: FROM itg_org_effectivity
138: WHERE NVL(organization_id, -1) = NVL(p_organization_id, -1)
139: AND cln_doc_type = p_cln_doc_type
140: AND doc_direction = p_doc_direction;
141:

Line 218: UPDATE itg_org_effectivity

214: IF l_found THEN
215: ITG_Debug.msg('UE', 'Updating existing effectivity row.');
216: DECLARE
217: BEGIN
218: UPDATE itg_org_effectivity
219: SET start_date = p_start_date,
220: end_date = p_end_date,
221: effectivity_enabled = NVL(l_flag, effectivity_enabled),
222: last_updated_by = FND_GLOBAL.user_id,

Line 235: INSERT INTO itg_org_effectivity (

231: END;
232: ELSE
233: ITG_Debug.msg('UE', 'Inserting new effectivity row.');
234: BEGIN
235: INSERT INTO itg_org_effectivity (
236: effectivity_id,
237: organization_id,
238: cln_doc_type,
239: doc_direction,

Line 249: itg_org_effectivity_s.nextval,

245: last_updated_by,
246: last_update_date,
247: last_update_login
248: ) VALUES (
249: itg_org_effectivity_s.nextval,
250: p_organization_id,
251: p_cln_doc_type,
252: p_doc_direction,
253: p_start_date,