eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_TEXT_UTIL dependencies on FND_API

Line 624: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE

620: PROCEDURE Process_Asset_DML_Opn
621: (
622: p_event IN VARCHAR2
623: , p_instance_id IN NUMBER
624: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
625: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
626: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
627: )
628: IS

Line 625: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

621: (
622: p_event IN VARCHAR2
623: , p_instance_id IN NUMBER
624: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
625: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
626: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
627: )
628: IS
629: l_text_ins VARCHAR2(1);

Line 626: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

622: p_event IN VARCHAR2
623: , p_instance_id IN NUMBER
624: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
625: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
626: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
627: )
628: IS
629: l_text_ins VARCHAR2(1);
630: l_text_upd VARCHAR2(1);

Line 644: , last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM, last_updated_by, p_last_updated_by)

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)
646: WHERE instance_id = p_instance_id;
647:
648: ELSIF (l_count = 0) THEN

Line 645: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)

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)
646: WHERE instance_id = p_instance_id;
647:
648: ELSIF (l_count = 0) THEN
649:

Line 666: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_updated_by)

662: , l_text_ins
663: , SYSDATE
664: , fnd_global.user_id
665: , SYSDATE
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

Line 667: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, fnd_global.login_id, p_last_update_login));

663: , SYSDATE
664: , fnd_global.user_id
665: , SYSDATE
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;

Line 690: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

686: PROCEDURE Process_Asset_Update_Event
687: (
688: p_event IN VARCHAR2 DEFAULT NULL
689: , p_instance_id IN NUMBER
690: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
691: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
692: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
693: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
694: )

Line 691: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE

687: (
688: p_event IN VARCHAR2 DEFAULT NULL
689: , p_instance_id IN NUMBER
690: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
691: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
692: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
693: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
694: )
695: IS

Line 692: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

688: p_event IN VARCHAR2 DEFAULT NULL
689: , p_instance_id IN NUMBER
690: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
691: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
692: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
693: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
694: )
695: IS
696: l_eam VARCHAR2(5);

Line 693: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM

689: , p_instance_id IN NUMBER
690: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
691: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
692: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
693: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
694: )
695: IS
696: l_eam VARCHAR2(5);
697: l_ctx VARCHAR2(8);

Line 711: IF (p_commit = FND_API.G_TRUE) THEN

707: , p_instance_id
708: , p_last_update_date
709: , p_last_updated_by
710: , p_last_update_login );
711: IF (p_commit = FND_API.G_TRUE) THEN
712: COMMIT;
713: END IF;
714: END IF;
715:

Line 717: IF (p_commit = FND_API.G_TRUE OR p_instance_id = -1) THEN

713: END IF;
714: END IF;
715:
716: /* If Text index exists execute sync up */
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';

Line 755: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE

751: (
752: p_event IN VARCHAR2,
753: p_wip_entity_id IN NUMBER,
754: p_organization_id IN NUMBER
755: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
756: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
757: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
758: )
759: IS

Line 756: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM

752: p_event IN VARCHAR2,
753: p_wip_entity_id IN NUMBER,
754: p_organization_id IN NUMBER
755: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
756: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
757: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
758: )
759: IS
760: l_text_ins VARCHAR2(1) := '1';

Line 757: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM

753: p_wip_entity_id IN NUMBER,
754: p_organization_id IN NUMBER
755: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
756: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
757: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
758: )
759: IS
760: l_text_ins VARCHAR2(1) := '1';
761: l_text_upd VARCHAR2(1) := '2';

Line 813: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

809: (
810: p_event IN VARCHAR2 DEFAULT NULL,
811: p_wip_entity_id IN NUMBER,
812: p_organization_id IN NUMBER DEFAULT NULL
813: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
814: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
815: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
816: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
817: )

Line 814: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE

810: p_event IN VARCHAR2 DEFAULT NULL,
811: p_wip_entity_id IN NUMBER,
812: p_organization_id IN NUMBER DEFAULT NULL
813: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
814: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
815: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
816: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
817: )
818: IS

Line 815: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM

811: p_wip_entity_id IN NUMBER,
812: p_organization_id IN NUMBER DEFAULT NULL
813: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
814: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
815: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
816: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
817: )
818: IS
819: l_eam VARCHAR2(5);

Line 816: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM

812: p_organization_id IN NUMBER DEFAULT NULL
813: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
814: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
815: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
816: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
817: )
818: IS
819: l_eam VARCHAR2(5);
820: l_ctx VARCHAR2(8);

Line 842: IF (p_commit = FND_API.G_TRUE OR p_wip_entity_id = -1) THEN

838:
839: END IF;
840:
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';

Line 873: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

869: PROCEDURE Process_Status_Update_Event
870: (
871: p_event IN VARCHAR2 DEFAULT NULL,
872: p_status_id IN NUMBER
873: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
874: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
875: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
876: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
877: , x_return_status IN OUT NOCOPY VARCHAR2

Line 874: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE

870: (
871: p_event IN VARCHAR2 DEFAULT NULL,
872: p_status_id IN NUMBER
873: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
874: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
875: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
876: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
877: , x_return_status IN OUT NOCOPY VARCHAR2
878: )

Line 875: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM

871: p_event IN VARCHAR2 DEFAULT NULL,
872: p_status_id IN NUMBER
873: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
874: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
875: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
876: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
877: , x_return_status IN OUT NOCOPY VARCHAR2
878: )
879: IS

Line 876: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM

872: p_status_id IN NUMBER
873: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
874: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
875: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
876: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
877: , x_return_status IN OUT NOCOPY VARCHAR2
878: )
879: IS
880: l_eam VARCHAR2(5);

Line 909: IF (p_commit = FND_API.G_TRUE OR p_status_id = -1) THEN

905: END LOOP;
906: END IF;
907:
908: /* If Text index exists execute sync up */
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';