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.

[Home] [Help]

APPS.EAM_PROCESS_FAILURE_ENTRY_PVT dependencies on EAM_ASSET_FAILURE_CODES

Line 273: FROM eam_asset_failure_codes

269: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
270: BEGIN
271: SELECT failure_code, cause_code, resolution_code
272: INTO l_old_failure_code, l_old_cause_code, l_old_resolution_code
273: FROM eam_asset_failure_codes
274: WHERE failure_entry_id = l_eam_failure_codes_record.failure_entry_id;
275: EXCEPTION
276: WHEN NO_DATA_FOUND THEN
277: x_reason_failed:='EAM_FAILURE_CHILD_NOT_EXISTS';

Line 298: FROM eam_asset_failure_codes eafc

294: ELSE
295:
296: SELECT count(1)
297: INTO l_failure_codes_exists
298: FROM eam_asset_failure_codes eafc
299: WHERE eafc.failure_id = l_eam_failure_codes_record.failure_id
300: AND nvl(eafc.failure_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.failure_code,'NULL VALUE')
301: AND nvl(eafc.cause_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.cause_code,'NULL VALUE')
302: AND nvl(eafc.resolution_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.resolution_code,'NULL VALUE');

Line 334: FROM eam_asset_failure_codes eafc

330:
331: /* Check if the record already exists corresponding to the failure_id */
332: SELECT COUNT(1)
333: INTO l_failure_codes_exists
334: FROM eam_asset_failure_codes eafc
335: WHERE eafc.failure_id = l_eam_failure_codes_record.failure_id;
336:
337: IF l_failure_codes_exists >= 1 THEN
338: x_reason_failed:='EAM_MULTIPLE_CHILD';

Line 348: FROM eam_asset_failure_codes eafc

344:
345: /* Check for the Existing Record */
346: SELECT count(1)
347: INTO l_failure_codes_exists
348: FROM eam_asset_failure_codes eafc
349: WHERE eafc.failure_id = l_eam_failure_codes_record.failure_id
350: AND nvl(eafc.failure_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.failure_code,'NULL VALUE')
351: AND nvl(eafc.cause_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.cause_code,'NULL VALUE')
352: AND nvl(eafc.resolution_code,'NULL VALUE') = nvl(l_eam_failure_codes_record.resolution_code,'NULL VALUE');

Line 366: FROM eam_asset_failure_codes eafc

362: Need to Verify Whether to Support Multiple Child Records with Comments Only
363: ELSE
364: SELECT count(1)
365: INTO l_failure_codes_exists
366: FROM eam_asset_failure_codes eafc
367: WHERE eafc.failure_id = l_eam_failure_codes_record.failure_id
368: *************/
369: END IF;
370: END IF; /* Create/ Update transaction type validation of failure codes */

Line 564: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;

560: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;
561: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;
562: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;
563:
564: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;
565:
566: l_failure_id NUMBER;
567:
568: l_inventory_item_id NUMBER;

Line 804: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failure_codes'); */

800: l_eam_failure_codes_record.combination_id := l_combination_id;
801:
802: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
803:
804: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failure_codes'); */
805:
806: SELECT eam_asset_failure_codes_s.nextval
807: INTO l_failure_entry_id
808: FROM DUAL;

Line 806: SELECT eam_asset_failure_codes_s.nextval

802: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
803:
804: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failure_codes'); */
805:
806: SELECT eam_asset_failure_codes_s.nextval
807: INTO l_failure_entry_id
808: FROM DUAL;
809: l_eam_failure_codes_record.failure_entry_id := l_failure_entry_id;
810:

Line 811: INSERT INTO eam_asset_failure_codes

807: INTO l_failure_entry_id
808: FROM DUAL;
809: l_eam_failure_codes_record.failure_entry_id := l_failure_entry_id;
810:
811: INSERT INTO eam_asset_failure_codes
812: (
813: failure_id,
814: failure_entry_id,
815: combination_id,

Line 841: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failure_codes'); */

837: SYSDATE,
838: FND_GLOBAL.user_id,
839: FND_GLOBAL.user_id
840: );
841: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failure_codes'); */
842:
843: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
844:
845: UPDATE eam_asset_failure_codes

Line 845: UPDATE eam_asset_failure_codes

841: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failure_codes'); */
842:
843: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
844:
845: UPDATE eam_asset_failure_codes
846: SET failure_code = l_eam_failure_codes_record.failure_code
847: ,cause_code = l_eam_failure_codes_record.cause_code
848: ,resolution_code = l_eam_failure_codes_record.resolution_code
849: ,combination_id = nvl( l_eam_failure_codes_record.combination_id, combination_id)