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.ECX_TRANSACTIONS_API dependencies on ECX_EXT_PROCESSES

Line 393: ecx_ext_processes eep

389: -- make sure that is no TP using this process first.
390: select count(*)
391: into num
392: from ecx_tp_details etd,
393: ecx_ext_processes eep
394: where eep.ext_process_id = etd.ext_process_id
395: and eep.transaction_id = p_transaction_id;
396:
397: if (num > 0)

Line 404: delete from ecx_ext_processes

400: x_return_status := ECX_UTIL_API.G_REFER_ERROR;
401: return;
402: end if;
403:
404: delete from ecx_ext_processes
405: where transaction_id = p_transaction_id;
406:
407: /* Call table handler API for deletion */
408: ECX_TRANSACTIONS_PKG.DELETE_ROW(x_transaction_id => p_transaction_id);

Line 423: process definition from the ECX_EXT_PROCESSES table.

419: end delete_transaction;
420:
421: /**
422: Overloaded Procedure.This Retrieve_Ext_Process API is used to retrieve an existing external
423: process definition from the ECX_EXT_PROCESSES table.
424: **/
425: /* Bug #2183619, Added two additional input parameters for
426: External Type and Subtype */
427: procedure retrieve_external_transaction

Line 514: -- select data from ECX_EXT_PROCESSES

510: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
511: return;
512: end;
513:
514: -- select data from ECX_EXT_PROCESSES
515: /* Bug #2183619,Modified to add check for External Type and Sub type */
516: select EXT_PROCESS_ID,
517: EXT_TYPE,
518: EXT_SUBTYPE,

Line 532: from ECX_EXT_PROCESSES

528: x_created_by,
529: x_creation_date,
530: x_last_updated_by,
531: x_last_update_date
532: from ECX_EXT_PROCESSES
533: where transaction_id = x_transaction_id
534: and standard_id = x_standard_id
535: and direction = p_direction
536: and (p_ext_type is null or ext_type=p_ext_type)

Line 563: process definition from the ECX_EXT_PROCESSES table.

559: end retrieve_external_transaction;
560:
561: /**
562: This Retrieve_Ext_Process API is used to retrieve an existing external
563: process definition from the ECX_EXT_PROCESSES table.
564: **/
565: /* Bug #2183619, Added two additional input parameters for
566: External Type and Subtype */
567: procedure retrieve_external_transaction

Line 638: -- select data from ECX_EXT_PROCESSES

634: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
635: return;
636: end;
637:
638: -- select data from ECX_EXT_PROCESSES
639: /* Bug #2183619,Modified to add check for External Type and Sub type */
640: select TRANSACTION_DESCRIPTION,
641: EXT_PROCESS_ID,
642: EXT_TYPE,

Line 658: from ECX_EXT_PROCESSES eep,

654: x_created_by,
655: x_creation_date,
656: x_last_updated_by,
657: x_last_update_date
658: from ECX_EXT_PROCESSES eep,
659: ECX_TRANSACTIONS_VL et
660: where et.transaction_id = p_transaction_id
661: and et.transaction_id = eep.transaction_id
662: and eep.standard_id = x_standard_id

Line 687: This Create_Ext_Process API is used to create a new external process definition in the ECX_EXT_PROCESSES table.

683: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
684: end retrieve_external_transaction;
685:
686: /**
687: This Create_Ext_Process API is used to create a new external process definition in the ECX_EXT_PROCESSES table.
688: If the transaction doesnt exists, then create one.
689: **/
690:
691: procedure create_external_transaction

Line 794: select ecx_ext_processes_s.nextval

790: -- make sure the ext_type and ext_subtype doesnt exists.
791: -- If the code is already exists, then
792: -- return an error status G_DUP_ERROR and return.
793:
794: select ecx_ext_processes_s.nextval
795: into x_ext_process_id
796: from dual;
797:
798: if p_owner = 'SEED'

Line 805: -- Insert data into ECX_EXT_PROCESSES

801: else
802: i_last_updated_by :=0;
803: end if;
804:
805: -- Insert data into ECX_EXT_PROCESSES
806: insert into ecx_ext_processes
807: (
808: EXT_PROCESS_ID,
809: EXT_TYPE,

Line 806: insert into ecx_ext_processes

802: i_last_updated_by :=0;
803: end if;
804:
805: -- Insert data into ECX_EXT_PROCESSES
806: insert into ecx_ext_processes
807: (
808: EXT_PROCESS_ID,
809: EXT_TYPE,
810: EXT_SUBTYPE,

Line 836: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESSES_EXISTS',

832: );
833:
834: exception
835: when dup_val_on_index then
836: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESSES_EXISTS',
837: 'p_transaction_id', p_transaction_id,
838: 'p_ext_type', p_ext_type,
839: 'p_ext_subtype', p_ext_subtype
840: );

Line 848: This Create_Ext_Process API is used to create a new external process definition in the ECX_EXT_PROCESSES table.

844: x_msg := substr(SQLERRM,1,200);
845: end create_external_transaction;
846:
847: /**
848: This Create_Ext_Process API is used to create a new external process definition in the ECX_EXT_PROCESSES table.
849: If the transaction doesnt exists, then create one.
850: **/
851:
852: procedure create_external_transaction

Line 920: Update_Ext_Process API is used to update an existing external process definition in the ECX_EXT_PROCESSES table.

916: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
917: end create_external_transaction;
918:
919: /**
920: Update_Ext_Process API is used to update an existing external process definition in the ECX_EXT_PROCESSES table.
921: This API allows users to update the ext_type, ext_subtype, standard, queue_name and direction by
922: specifying the ext_process_id.
923: **/
924: procedure update_external_transaction

Line 1027: -- update data into ECX_EXT_PROCESSES

1023: else
1024: i_last_updated_by :=0;
1025: end if;
1026:
1027: -- update data into ECX_EXT_PROCESSES
1028: -- SHould we allow to update the Unqiue itself?
1029: update ECX_EXT_PROCESSES
1030: set ext_type = p_ext_type,
1031: ext_subtype = p_ext_subtype,

Line 1029: update ECX_EXT_PROCESSES

1025: end if;
1026:
1027: -- update data into ECX_EXT_PROCESSES
1028: -- SHould we allow to update the Unqiue itself?
1029: update ECX_EXT_PROCESSES
1030: set ext_type = p_ext_type,
1031: ext_subtype = p_ext_subtype,
1032: standard_id = I_stand_id,
1033: queue_name = p_queue_name,

Line 1043: 'p_table', 'ecx_ext_processes', 'p_key', p_ext_process_id);

1039: if (sql%rowcount = 0)
1040: then
1041: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1042: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
1043: 'p_table', 'ecx_ext_processes', 'p_key', p_ext_process_id);
1044: return;
1045: end if;
1046:
1047: exception

Line 1061: This Delete_Ext_Process API is used to delete an existing external process definition in the ECX_EXT_PROCESSES table.

1057: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
1058: end update_external_transaction;
1059:
1060: /**
1061: This Delete_Ext_Process API is used to delete an existing external process definition in the ECX_EXT_PROCESSES table.
1062: This API allows users to delete a process definition by specifying the ext_process_id.
1063: **/
1064: procedure delete_external_transaction
1065: (

Line 1095: delete from ecx_ext_processes

1091: x_return_status := ECX_UTIL_API.G_REFER_ERROR;
1092: return;
1093: end if;
1094:
1095: delete from ecx_ext_processes
1096: where ext_process_id = p_ext_process_id;
1097:
1098: if (sql%rowcount = 0)
1099: then

Line 1102: 'p_table', 'ECX_EXT_PROCESSES', 'p_key', p_ext_process_id);

1098: if (sql%rowcount = 0)
1099: then
1100: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1101: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
1102: 'p_table', 'ECX_EXT_PROCESSES', 'p_key', p_ext_process_id);
1103: return;
1104: end if;
1105:
1106: exception