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.POS_CANCEL_ASN dependencies on DUAL

Line 539: from dual

535: from rcv_transactions_interface
536: where HEADER_INTERFACE_ID = p_header_id;
537:
538: select 'Y' into l_rti_error
539: from dual
540: where exists
541: (select 1 from rcv_transactions_interface
542: where HEADER_INTERFACE_ID = p_header_id
543: and (processing_status_code = 'ERROR' or

Line 575: from dual;

571: if (x_processing_status = 'RUNNING') then
572:
573: select fnd_message_cache.get_string('POS', 'POS_RUNNING')
574: into x_processing_dsp
575: from dual;
576:
577: elsif (x_processing_status = 'PENDING') then
578:
579: select fnd_message_cache.get_string('POS', 'POS_PENDING')

Line 581: from dual;

577: elsif (x_processing_status = 'PENDING') then
578:
579: select fnd_message_cache.get_string('POS', 'POS_PENDING')
580: into x_processing_dsp
581: from dual;
582:
583: elsif (x_processing_status = 'ERROR') then
584:
585: select fnd_message_cache.get_string('POS', 'POS_ERROR')

Line 587: from dual;

583: elsif (x_processing_status = 'ERROR') then
584:
585: select fnd_message_cache.get_string('POS', 'POS_ERROR')
586: into x_processing_dsp
587: from dual;
588:
589: elsif (x_processing_status = 'MULTIPLE') then
590:
591: select fnd_message_cache.get_string('POS', 'POS_MULTIPLE')

Line 593: from dual;

589: elsif (x_processing_status = 'MULTIPLE') then
590:
591: select fnd_message_cache.get_string('POS', 'POS_MULTIPLE')
592: into x_processing_dsp
593: from dual;
594:
595: else
596:
597: x_processing_dsp := '';

Line 664: from dual;

660: if (x_cancellation_status = 'CANCELLED') then
661:
662: select fnd_message_cache.get_string('POS', 'POS_CANCELLED')
663: into x_cancellation_dsp
664: from dual;
665:
666: elsif (x_cancellation_status = 'PENDING_CANCEL') then
667:
668: select fnd_message_cache.get_string('POS', 'POS_ASN_PENDING_CANCEL')

Line 670: from dual;

666: elsif (x_cancellation_status = 'PENDING_CANCEL') then
667:
668: select fnd_message_cache.get_string('POS', 'POS_ASN_PENDING_CANCEL')
669: into x_cancellation_dsp
670: from dual;
671:
672: elsif (x_cancellation_status = 'PARTIALLY_CANCELLED') then
673:
674: select fnd_message_cache.get_string('POS', 'POS_PARTIALLY_CANCELLED')

Line 676: from dual;

672: elsif (x_cancellation_status = 'PARTIALLY_CANCELLED') then
673:
674: select fnd_message_cache.get_string('POS', 'POS_PARTIALLY_CANCELLED')
675: into x_cancellation_dsp
676: from dual;
677:
678: else
679:
680: x_cancellation_dsp := '';

Line 801: from dual;

797: if (x_processing_status = 'RUNNING') then
798:
799: select fnd_message_cache.get_string('POS', 'POS_RUNNING')
800: into x_processing_dsp
801: from dual;
802:
803: elsif (x_processing_status = 'PENDING') then
804:
805: select fnd_message_cache.get_string('POS', 'POS_PENDING')

Line 807: from dual;

803: elsif (x_processing_status = 'PENDING') then
804:
805: select fnd_message_cache.get_string('POS', 'POS_PENDING')
806: into x_processing_dsp
807: from dual;
808:
809: elsif (x_processing_status = 'ERROR') then
810:
811: select fnd_message_cache.get_string('POS', 'POS_ERROR')

Line 813: from dual;

809: elsif (x_processing_status = 'ERROR') then
810:
811: select fnd_message_cache.get_string('POS', 'POS_ERROR')
812: into x_processing_dsp
813: from dual;
814:
815: elsif (x_processing_status = 'MULTIPLE') then
816:
817: select fnd_message_cache.get_string('POS', 'POS_MULTIPLE')

Line 819: from dual;

815: elsif (x_processing_status = 'MULTIPLE') then
816:
817: select fnd_message_cache.get_string('POS', 'POS_MULTIPLE')
818: into x_processing_dsp
819: from dual;
820:
821: else
822:
823: x_processing_dsp := '';

Line 890: from dual;

886: if (x_cancellation_status = 'CANCELLED') then
887:
888: select fnd_message_cache.get_string('POS', 'POS_CANCELLED')
889: into x_cancellation_dsp
890: from dual;
891:
892: elsif (x_cancellation_status = 'PENDING_CANCEL') then
893:
894: select fnd_message_cache.get_string('POS', 'POS_ASN_PENDING_CANCEL')

Line 896: from dual;

892: elsif (x_cancellation_status = 'PENDING_CANCEL') then
893:
894: select fnd_message_cache.get_string('POS', 'POS_ASN_PENDING_CANCEL')
895: into x_cancellation_dsp
896: from dual;
897:
898: elsif (x_cancellation_status = 'PARTIALLY_CANCELLED') then
899:
900: select fnd_message_cache.get_string('POS', 'POS_PARTIALLY_CANCELLED')

Line 902: from dual;

898: elsif (x_cancellation_status = 'PARTIALLY_CANCELLED') then
899:
900: select fnd_message_cache.get_string('POS', 'POS_PARTIALLY_CANCELLED')
901: into x_cancellation_dsp
902: from dual;
903:
904: else
905:
906: x_cancellation_dsp := '';

Line 970: -- Cancel the individual ASN line.

966: END get_line_status;
967:
968:
969: --
970: -- Cancel the individual ASN line.
971: --
972: PROCEDURE cancel_asn_line (
973: p_shipment_line_id IN NUMBER,
974: p_vendor_id IN NUMBER,

Line 1004: FROM dual;

1000:
1001: BEGIN
1002: SELECT rcv_interface_groups_s.nextval
1003: INTO x_group_id
1004: FROM dual;
1005:
1006: select
1007: RSL.PO_HEADER_ID,
1008: RSL.PO_RELEASE_ID,