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.ISG_XMLG_UTIL dependencies on AQ$_JMS_USERPROPERTY

Line 83: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_NAME',100,'oracle.apps.fnd.wf.ws.inbound.xmltx.receive', NULL, 27),

79: SELECT SUBSTR(ADDRESS,INSTR(ADDRESS,'.',1,1)+1) INTO agent_name FROM WF_AGENTS WHERE NAME = 'WF_WS_JMS_IN';
80:
81: R_ECX_HEADER := sys.AQ$_JMS_HEADER(NULL, NULL, NULL, NULL, NULL, NULL,
82: sys.AQ$_JMS_USERPROPARRAY(
83: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_NAME',100,'oracle.apps.fnd.wf.ws.inbound.xmltx.receive', NULL, 27),
84: --sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, '-621902048', NULL, 27),
85: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, date_time, NULL, 27),
86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),
87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),

Line 84: --sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, '-621902048', NULL, 27),

80:
81: R_ECX_HEADER := sys.AQ$_JMS_HEADER(NULL, NULL, NULL, NULL, NULL, NULL,
82: sys.AQ$_JMS_USERPROPARRAY(
83: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_NAME',100,'oracle.apps.fnd.wf.ws.inbound.xmltx.receive', NULL, 27),
84: --sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, '-621902048', NULL, 27),
85: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, date_time, NULL, 27),
86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),
87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),
88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),

Line 85: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, date_time, NULL, 27),

81: R_ECX_HEADER := sys.AQ$_JMS_HEADER(NULL, NULL, NULL, NULL, NULL, NULL,
82: sys.AQ$_JMS_USERPROPARRAY(
83: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_NAME',100,'oracle.apps.fnd.wf.ws.inbound.xmltx.receive', NULL, 27),
84: --sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, '-621902048', NULL, 27),
85: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, date_time, NULL, 27),
86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),
87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),
88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),
89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),

Line 86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),

82: sys.AQ$_JMS_USERPROPARRAY(
83: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_NAME',100,'oracle.apps.fnd.wf.ws.inbound.xmltx.receive', NULL, 27),
84: --sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, '-621902048', NULL, 27),
85: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, date_time, NULL, 27),
86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),
87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),
88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),
89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),
90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),

Line 87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),

83: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_NAME',100,'oracle.apps.fnd.wf.ws.inbound.xmltx.receive', NULL, 27),
84: --sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, '-621902048', NULL, 27),
85: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, date_time, NULL, 27),
86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),
87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),
88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),
89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),
90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),
91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),

Line 88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),

84: --sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, '-621902048', NULL, 27),
85: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, date_time, NULL, 27),
86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),
87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),
88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),
89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),
90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),
91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),
92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),

Line 89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),

85: sys.AQ$_JMS_USERPROPERTY('BES_EVENT_KEY', 100, date_time, NULL, 27),
86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),
87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),
88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),
89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),
90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),
91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),
92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),
93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),

Line 90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),

86: sys.AQ$_JMS_USERPROPERTY('BES_PRIORITY', 200, NULL, 1, 23),
87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),
88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),
89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),
90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),
91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),
92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),
93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),
94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),

Line 91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),

87: sys.AQ$_JMS_USERPROPERTY('BES_PAYLOAD_OBJECT', 100, 'false', NULL, 27),
88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),
89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),
90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),
91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),
92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),
93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),
94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),
95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),

Line 92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),

88: --sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,'[email protected]', NULL, 27),
89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),
90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),
91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),
92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),
93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),
94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),
95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),
96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),

Line 93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),

89: sys.AQ$_JMS_USERPROPERTY('BES_FROM_AGENT', 100,agent_name, NULL, 27),
90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),
91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),
92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),
93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),
94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),
95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),
96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),
97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),

Line 94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),

90: --sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,'[email protected]', NULL, 27),
91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),
92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),
93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),
94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),
95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),
96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),
97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),
98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),

Line 95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),

91: sys.AQ$_JMS_USERPROPERTY('BES_TO_AGENT', 100,agent_name, NULL, 27),
92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),
93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),
94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),
95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),
96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),
97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),
98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),
99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),

Line 96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),

92: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_TYPE', 100, R_ECX_MESSAGE_TYPE, NULL, 27),
93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),
94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),
95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),
96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),
97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),
98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),
99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),
100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),

Line 97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),

93: sys.AQ$_JMS_USERPROPERTY('ECX_MESSAGE_STANDARD', 100,R_ECX_MESSAGE_STANDARD, NULL, 27),
94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),
95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),
96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),
97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),
98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),
99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),
100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),
101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),

Line 98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),

94: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, R_ECX_TRANSACTION_TYPE, NULL, 27),
95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),
96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),
97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),
98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),
99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),
100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),
101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),
102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),

Line 99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),

95: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_TYPE', 100, 'ECX', NULL, 27),
96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),
97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),
98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),
99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),
100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),
101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),
102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),
103: sys.AQ$_JMS_USERPROPERTY('WS_PORT_OPERATION', 100, 'ReceiveDocument' , NULL, 27)

Line 100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),

96: sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, R_ECX_TRANSACTION_SUBTYPE, NULL, 27),
97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),
98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),
99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),
100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),
101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),
102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),
103: sys.AQ$_JMS_USERPROPERTY('WS_PORT_OPERATION', 100, 'ReceiveDocument' , NULL, 27)
104: --sys.AQ$_JMS_USERPROPERTY('ECX_ATTACHMENTS',100, NULL, NULL, 27)

Line 101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),

97: --sys.AQ$_JMS_USERPROPERTY('ECX_TRANSACTION_SUBTYPE', 100, 'CBODO', NULL, 27),
98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),
99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),
100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),
101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),
102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),
103: sys.AQ$_JMS_USERPROPERTY('WS_PORT_OPERATION', 100, 'ReceiveDocument' , NULL, 27)
104: --sys.AQ$_JMS_USERPROPERTY('ECX_ATTACHMENTS',100, NULL, NULL, 27)
105: --sys.AQ$_JMS_USERPROPERTY('ECX_TRIGGER_ID', 100, '37192', NULL, 27)

Line 102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),

98: sys.AQ$_JMS_USERPROPERTY('ECX_DOCUMENT_NUMBER', 100,R_ECX_DOCUMENT_NUMBER, NULL, 27),
99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),
100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),
101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),
102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),
103: sys.AQ$_JMS_USERPROPERTY('WS_PORT_OPERATION', 100, 'ReceiveDocument' , NULL, 27)
104: --sys.AQ$_JMS_USERPROPERTY('ECX_ATTACHMENTS',100, NULL, NULL, 27)
105: --sys.AQ$_JMS_USERPROPERTY('ECX_TRIGGER_ID', 100, '37192', NULL, 27)
106: )

Line 103: sys.AQ$_JMS_USERPROPERTY('WS_PORT_OPERATION', 100, 'ReceiveDocument' , NULL, 27)

99: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_ID', 100, R_ECX_PARTYID, NULL, 27),
100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),
101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),
102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),
103: sys.AQ$_JMS_USERPROPERTY('WS_PORT_OPERATION', 100, 'ReceiveDocument' , NULL, 27)
104: --sys.AQ$_JMS_USERPROPERTY('ECX_ATTACHMENTS',100, NULL, NULL, 27)
105: --sys.AQ$_JMS_USERPROPERTY('ECX_TRIGGER_ID', 100, '37192', NULL, 27)
106: )
107: );

Line 104: --sys.AQ$_JMS_USERPROPERTY('ECX_ATTACHMENTS',100, NULL, NULL, 27)

100: sys.AQ$_JMS_USERPROPERTY('ECX_PARTY_SITE_ID', 100,R_ECX_PARTY_SITE_ID , NULL, 27),
101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),
102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),
103: sys.AQ$_JMS_USERPROPERTY('WS_PORT_OPERATION', 100, 'ReceiveDocument' , NULL, 27)
104: --sys.AQ$_JMS_USERPROPERTY('ECX_ATTACHMENTS',100, NULL, NULL, 27)
105: --sys.AQ$_JMS_USERPROPERTY('ECX_TRIGGER_ID', 100, '37192', NULL, 27)
106: )
107: );
108: --R_ECX_MSG_BODY_PAYLOAD := xmltype(R_ECX_PAYLOAD).getClobVal();

Line 105: --sys.AQ$_JMS_USERPROPERTY('ECX_TRIGGER_ID', 100, '37192', NULL, 27)

101: sys.AQ$_JMS_USERPROPERTY('ECX_USERNAME', 100,R_ECX_USERNAME , NULL, 27),
102: sys.AQ$_JMS_USERPROPERTY('UserId', 100, '0', NULL, 27),
103: sys.AQ$_JMS_USERPROPERTY('WS_PORT_OPERATION', 100, 'ReceiveDocument' , NULL, 27)
104: --sys.AQ$_JMS_USERPROPERTY('ECX_ATTACHMENTS',100, NULL, NULL, 27)
105: --sys.AQ$_JMS_USERPROPERTY('ECX_TRIGGER_ID', 100, '37192', NULL, 27)
106: )
107: );
108: --R_ECX_MSG_BODY_PAYLOAD := xmltype(R_ECX_PAYLOAD).getClobVal();
109: R_ECX_MSG_BODY_PAYLOAD := R_ECX_PAYLOAD;