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_PROCESS_ISOLATION_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 71: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type

67: ( p_bo_identifier IN VARCHAR2 := 'EAM'
68: , p_api_version_number IN NUMBER := 1.0
69: , p_init_msg_list IN BOOLEAN := FALSE
70: , p_commit IN VARCHAR2
71: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
72: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
73: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
74: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
75: , x_isolation_id OUT NOCOPY NUMBER

Line 72: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type

68: , p_api_version_number IN NUMBER := 1.0
69: , p_init_msg_list IN BOOLEAN := FALSE
70: , p_commit IN VARCHAR2
71: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
72: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
73: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
74: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
75: , x_isolation_id OUT NOCOPY NUMBER
76: , x_return_status OUT NOCOPY VARCHAR2

Line 73: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type

69: , p_init_msg_list IN BOOLEAN := FALSE
70: , p_commit IN VARCHAR2
71: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
72: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
73: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
74: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
75: , x_isolation_id OUT NOCOPY NUMBER
76: , x_return_status OUT NOCOPY VARCHAR2
77: , x_msg_count OUT NOCOPY NUMBER

Line 74: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type

70: , p_commit IN VARCHAR2
71: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
72: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
73: , p_re_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
74: , p_isolated_asset_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
75: , x_isolation_id OUT NOCOPY NUMBER
76: , x_return_status OUT NOCOPY VARCHAR2
77: , x_msg_count OUT NOCOPY NUMBER
78: , p_debug IN VARCHAR2

Line 90: lx_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

86:
87: l_return_status VARCHAR2(1);
88: l_msg_count NUMBER;
89: l_msg_data VARCHAR2(240);
90: lx_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
91: lx_re_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
92: lx_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
93: l_isolation_id NUMBER :=p_iso_header_rec.isolation_id;
94:

Line 91: lx_re_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;

87: l_return_status VARCHAR2(1);
88: l_msg_count NUMBER;
89: l_msg_data VARCHAR2(240);
90: lx_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
91: lx_re_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
92: lx_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
93: l_isolation_id NUMBER :=p_iso_header_rec.isolation_id;
94:
95: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

Line 92: lx_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;

88: l_msg_count NUMBER;
89: l_msg_data VARCHAR2(240);
90: lx_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
91: lx_re_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
92: lx_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
93: l_isolation_id NUMBER :=p_iso_header_rec.isolation_id;
94:
95: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
96: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

Line 95: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

91: lx_re_establish_iso_tbl EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type;
92: lx_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
93: l_isolation_id NUMBER :=p_iso_header_rec.isolation_id;
94:
95: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
96: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
97:
98: /* Error Handling Variables */
99: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type ;

Line 96: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;

92: lx_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
93: l_isolation_id NUMBER :=p_iso_header_rec.isolation_id;
94:
95: l_isolated_asset_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
96: l_safety_assoc_rec EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type;
97:
98: /* Error Handling Variables */
99: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type ;
100: l_error_level NUMBER :=EAM_ERROR_MESSAGE_PVT.G_BO_LEVEL;

Line 252: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type

248: (
249: p_validation_level IN NUMBER
250: , p_isolation_id IN NUMBER :=NULL
251: , p_organization_id IN NUMBER :=NULL
252: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
253: , x_iso_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
254: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
255: , x_return_status OUT NOCOPY VARCHAR2
256: )IS

Line 253: , x_iso_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type

249: p_validation_level IN NUMBER
250: , p_isolation_id IN NUMBER :=NULL
251: , p_organization_id IN NUMBER :=NULL
252: , p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
253: , x_iso_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
254: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
255: , x_return_status OUT NOCOPY VARCHAR2
256: )IS
257:

Line 268: l_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type :=p_iso_header_rec;

264:
265: l_isolation_id NUMBER := p_iso_header_rec.isolation_id;
266: l_workflow_enabled VARCHAR2(1);
267:
268: l_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type :=p_iso_header_rec;
269: l_old_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
270: l_out_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
271:
272:

Line 269: l_old_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;

265: l_isolation_id NUMBER := p_iso_header_rec.isolation_id;
266: l_workflow_enabled VARCHAR2(1);
267:
268: l_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type :=p_iso_header_rec;
269: l_old_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
270: l_out_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
271:
272:
273: l_maintenance_object_source NUMBER :=1; -- To check if work flow is enabled

Line 270: l_out_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;

266: l_workflow_enabled VARCHAR2(1);
267:
268: l_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type :=p_iso_header_rec;
269: l_old_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
270: l_out_iso_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
271:
272:
273: l_maintenance_object_source NUMBER :=1; -- To check if work flow is enabled
274: l_status_pending_event VARCHAR2(100) := 'oracle.apps.eam.isolation.status.change.pending';

Line 634: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type

630: * Purpose : This will process establishment records
631: ************************************************************/
632: PROCEDURE ESTABLISHMENT
633: ( p_organization_id IN NUMBER
634: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
635: , p_safety_source_id IN NUMBER
636: , x_establish_iso_tbl OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
637: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
638: , x_return_status OUT NOCOPY VARCHAR2

Line 636: , x_establish_iso_tbl OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type

632: PROCEDURE ESTABLISHMENT
633: ( p_organization_id IN NUMBER
634: , p_establish_iso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
635: , p_safety_source_id IN NUMBER
636: , x_establish_iso_tbl OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
637: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
638: , x_return_status OUT NOCOPY VARCHAR2
639: ) IS
640:

Line 650: l_establish_iso_rec EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type;

646:
647: l_return_status VARCHAR2(1);
648: L_count Number;
649: l_temp NUMBER;
650: l_establish_iso_rec EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type;
651: l_iso_seq NUMBER;
652:
653: ISO_ESTABLISH_ERROR EXCEPTION;
654: SAF_ASSET_EXISTENCE_ERROR EXCEPTION;

Line 843: , p_eam_iso_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type

839:
840: PROCEDURE RAISE_WORKFLOW_EVENTS
841: ( p_api_version IN NUMBER
842: , p_validation_level IN NUMBER
843: , p_eam_iso_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
844: , p_old_eam_iso_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
845: , p_approval_required IN BOOLEAN
846: , p_new_system_status IN NUMBER
847: , p_workflow_name IN VARCHAR2

Line 844: , p_old_eam_iso_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type

840: PROCEDURE RAISE_WORKFLOW_EVENTS
841: ( p_api_version IN NUMBER
842: , p_validation_level IN NUMBER
843: , p_eam_iso_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
844: , p_old_eam_iso_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
845: , p_approval_required IN BOOLEAN
846: , p_new_system_status IN NUMBER
847: , p_workflow_name IN VARCHAR2
848: , p_workflow_process IN VARCHAR2