DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PKG dependencies on GAT_MESSAGE_TYPE

Line 67: g_payload GAT_message_type;

63: g_trc_idx NUMBER :=1;
64:
65: g_qname varchar2(80) := 'GAT_REQ_Q';
66: g_qtable varchar2(80) := 'GAT_REQ_QTBL';
67: g_payload GAT_message_type;
68:
69: g_submit_sub boolean;
70: g_req_data VARCHAR2(10);
71:

Line 114: WHERE OBJ.OBJECT_NAME = UPPER('GAT_message_type')

110: /* Added for Bug 16266481 / 16053785 */
111: cursor c_playload_mesg is
112: SELECT OWNER||'.'||OBJECT_NAME
113: FROM DBA_OBJECTS OBJ, USER_SYNONYMS SYN
114: WHERE OBJ.OBJECT_NAME = UPPER('GAT_message_type')
115: AND OBJ.OBJECT_TYPE = 'TYPE'
116: AND SYN.SYNONYM_NAME = OBJ.OBJECT_NAME
117: AND OBJ.OWNER = SYN.TABLE_OWNER
118: AND obj.object_name = syn.table_name;

Line 145: l_playload_mesg := 'GAT_message_type';

141: open c_playload_mesg;
142: fetch c_playload_mesg into l_playload_mesg;
143: close c_playload_mesg;
144: if (l_playload_mesg is NULL) then
145: l_playload_mesg := 'GAT_message_type';
146: end if;
147:
148: l_qstarted := FA_ASSET_TRACE_PUB.start_queue (p_qtable => g_qtable,
149: p_qpayload_type => l_playload_mesg,

Line 1669: g_payload := GAT_message_type(l_xla_reqID, 'S', g_book, g_asset_id, l_desc);

1665: p_subscriber => 'S'||to_char(l_xla_reqID),
1666: p_sub_rule => l_sub_rule)) THEN
1667: log(l_calling_fn,'Failed to add subscriber.');
1668: END IF;
1669: g_payload := GAT_message_type(l_xla_reqID, 'S', g_book, g_asset_id, l_desc);
1670: IF (NOT enqueue_request) THEN
1671: log(l_calling_fn,'Failed to save message to the queue.');
1672: END IF;
1673: log(l_calling_fn, 'Successfully submitted xla request '||l_xla_reqID);