APPS.EAM_TEXT_UTIL dependencies on EAM_ASSET_TEXT

Line 237: eam_asset_text eat

233: msi.attribute15
234: INTO
235: l_instance_id, l_org_id, l_eam_item_type, l_criticality_code, l_buffer
236: FROM
237: eam_asset_text eat
238: , csi_item_instances cii
239: , mtl_system_items_b_kfv msi
240: , mtl_categories_kfv mck
241: WHERE

Line 618: --- Procedure to insert / update / delete records in eam_asset_text

614:
615:
616: -- -----------------------------------------------------------------------------
617: -- Process_Asset_DML_Opn
618: --- Procedure to insert / update / delete records in eam_asset_text
619: -- -----------------------------------------------------------------------------
620: PROCEDURE Process_Asset_DML_Opn
621: (
622: p_event IN VARCHAR2

Line 637: FROM eam_asset_text WHERE instance_id = p_instance_id AND rownum = 1;

633: l_text_ins := '1';
634: l_text_upd := '2';
635:
636: SELECT count(instance_id) INTO l_count
637: FROM eam_asset_text WHERE instance_id = p_instance_id AND rownum = 1;
638:
639: IF ( p_event = 'UPDATE' OR p_event = 'INSERT' ) THEN
640: IF (l_count = 1) THEN
641: UPDATE eam_asset_text

Line 641: UPDATE eam_asset_text

637: FROM eam_asset_text WHERE instance_id = p_instance_id AND rownum = 1;
638:
639: IF ( p_event = 'UPDATE' OR p_event = 'INSERT' ) THEN
640: IF (l_count = 1) THEN
641: UPDATE eam_asset_text
642: SET text = l_text_upd
643: , last_update_date = SYSDATE
644: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)
645: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

Line 650: INSERT INTO eam_asset_text

646: WHERE instance_id = p_instance_id;
647:
648: ELSIF (l_count = 0) THEN
649:
650: INSERT INTO eam_asset_text
651: (
652: instance_id
653: , text
654: , creation_date

Line 670: DELETE FROM eam_asset_text

666: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_updated_by)
667: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, fnd_global.login_id, p_last_update_login));
668: END IF;
669: ELSIF ( p_event = 'DELETE' ) THEN
670: DELETE FROM eam_asset_text
671: WHERE p_instance_id = p_instance_id;
672:
673: END IF; -- p_event
674: EXCEPTION

Line 721: l_table := 'EAM_ASSET_TEXT';

717: IF (p_commit = FND_API.G_TRUE OR p_instance_id = -1) THEN
718:
719: l_eam := 'EAM';
720: l_ctx := 'CTXSYS';
721: l_table := 'EAM_ASSET_TEXT';
722: l_index := 'EAM_ASSET_TEXT_CTX1';
723: l_status := 'VALID';
724: SELECT count(*) into l_count
725: FROM all_indexes

Line 722: l_index := 'EAM_ASSET_TEXT_CTX1';

718:
719: l_eam := 'EAM';
720: l_ctx := 'CTXSYS';
721: l_table := 'EAM_ASSET_TEXT';
722: l_index := 'EAM_ASSET_TEXT_CTX1';
723: l_status := 'VALID';
724: SELECT count(*) into l_count
725: FROM all_indexes
726: WHERE (owner = l_eam OR owner = USER OR owner = l_ctx)

Line 732: ' eam_text_util.Sync_Index(''EAM_ASSET_TEXT_CTX1''); '||

728: AND status = l_status AND domidx_status = l_status AND domidx_opstatus = l_status;
729: IF (l_count > 0) THEN
730: EXECUTE IMMEDIATE
731: ' BEGIN '||
732: ' eam_text_util.Sync_Index(''EAM_ASSET_TEXT_CTX1''); '||
733: ' END;';
734: /* Calling sync_index would cause database commit. Should be called after commit */
735: END IF;
736: END IF;