APPS.EAM_TEXT_UTIL dependencies on EAM_WORK_ORDER_TEXT

Line 467: eam_work_order_text ewot,wip_discrete_jobs wdj

463: wdj.activity_type,wdj.activity_cause,wdj.activity_source
464: INTO
465: l_wip_entity_id,l_org_id,l_priority,l_work_order_type,l_activity_type,l_activity_cause,l_activity_source
466: FROM
467: eam_work_order_text ewot,wip_discrete_jobs wdj
468: WHERE
469: ewot.rowid = p_rowid
470: AND ewot.wip_entity_id = wdj.wip_entity_id;
471:

Line 748: --- Procedure to insert / update / delete records in eam_work_order_text

744: END Process_Asset_Update_Event;
745:
746: -- -----------------------------------------------------------------------------
747: -- Process_Wo_DML_Opn
748: --- Procedure to insert / update / delete records in eam_work_order_text
749: -- -----------------------------------------------------------------------------
750: PROCEDURE Process_Wo_Dml_Opn
751: (
752: p_event IN VARCHAR2,

Line 765: UPDATE eam_work_order_text

761: l_text_upd VARCHAR2(1) := '2';
762: BEGIN
763:
764: IF ( p_event = 'UPDATE' ) THEN
765: UPDATE eam_work_order_text
766: SET text = l_text_upd
767: , last_update_date = SYSDATE
768: , last_updated_by = FND_GLOBAL.user_id
769: , last_update_login = FND_GLOBAL.login_id

Line 773: INSERT INTO eam_work_order_text

769: , last_update_login = FND_GLOBAL.login_id
770: WHERE wip_entity_id = p_wip_entity_id;
771:
772: ELSIF ( p_event = 'INSERT' ) THEN
773: INSERT INTO eam_work_order_text
774: (
775: organization_id
776: , wip_entity_id
777: , text

Line 845: l_table := 'EAM_WORK_ORDER_TEXT';

841: /* If Text index exists execute sync up */
842: IF (p_commit = FND_API.G_TRUE OR p_wip_entity_id = -1) THEN
843: l_eam := 'EAM';
844: l_ctx := 'CTXSYS';
845: l_table := 'EAM_WORK_ORDER_TEXT';
846: l_index := 'EAM_WORK_ORDER_TEXT_CTX1';
847: l_status := 'VALID';
848: SELECT count(*) into l_count
849: FROM all_indexes

Line 846: l_index := 'EAM_WORK_ORDER_TEXT_CTX1';

842: IF (p_commit = FND_API.G_TRUE OR p_wip_entity_id = -1) THEN
843: l_eam := 'EAM';
844: l_ctx := 'CTXSYS';
845: l_table := 'EAM_WORK_ORDER_TEXT';
846: l_index := 'EAM_WORK_ORDER_TEXT_CTX1';
847: l_status := 'VALID';
848: SELECT count(*) into l_count
849: FROM all_indexes
850: WHERE (owner = l_eam OR owner = USER OR owner = l_ctx)

Line 856: ' eam_text_util.Sync_Index(''EAM_WORK_ORDER_TEXT_CTX1''); '||

852: AND status = l_status AND domidx_status = l_status AND domidx_opstatus = l_status;
853: IF (l_count > 0) THEN
854: EXECUTE IMMEDIATE
855: ' BEGIN '||
856: ' eam_text_util.Sync_Index(''EAM_WORK_ORDER_TEXT_CTX1''); '||
857: ' END;';
858: END IF;
859: END IF;
860:

Line 913: l_table := 'EAM_WORK_ORDER_TEXT';

909: IF (p_commit = FND_API.G_TRUE OR p_status_id = -1) THEN
910:
911: l_eam := 'EAM';
912: l_ctx := 'CTXSYS';
913: l_table := 'EAM_WORK_ORDER_TEXT';
914: l_index := 'EAM_WORK_ORDER_TEXT_CTX1';
915: l_status := 'VALID';
916:
917: SELECT count(*) into l_count

Line 914: l_index := 'EAM_WORK_ORDER_TEXT_CTX1';

910:
911: l_eam := 'EAM';
912: l_ctx := 'CTXSYS';
913: l_table := 'EAM_WORK_ORDER_TEXT';
914: l_index := 'EAM_WORK_ORDER_TEXT_CTX1';
915: l_status := 'VALID';
916:
917: SELECT count(*) into l_count
918: FROM all_indexes

Line 926: ' eam_text_util.Sync_Index(''EAM_WORK_ORDER_TEXT_CTX1''); '||

922:
923: IF (l_count > 0) THEN
924: EXECUTE IMMEDIATE
925: ' BEGIN '||
926: ' eam_text_util.Sync_Index(''EAM_WORK_ORDER_TEXT_CTX1''); '||
927: ' END;';
928: END IF;
929:
930: END IF;