DBA Data[Home] [Help]

APPS.JTF_IH_BULK_Q_PKG dependencies on IH_BULK_TYPE

Line 10: enq_userdata system.IH_BULK_TYPE;

6: p_bulkBatchType in VARCHAR2,
7: p_bulkBatchId in NUMBER,
8: p_bulkInteractionId in NUMBER,
9: enq_msgid out NOCOPY RAW) as
10: enq_userdata system.IH_BULK_TYPE;
11: enqopt dbms_aq.enqueue_options_t;
12: msgprop dbms_aq.message_properties_t;
13:
14: queue_disabled_exception exception;

Line 21: enq_userdata := system.IH_BULK_TYPE(p_bulkWriterCode, p_bulkBatchType, p_bulkBatchId, p_bulkInteractionId, empty_clob());

17:
18:
19: BEGIN
20:
21: enq_userdata := system.IH_BULK_TYPE(p_bulkWriterCode, p_bulkBatchType, p_bulkBatchId, p_bulkInteractionId, empty_clob());
22: dbms_aq.enqueue('JTF_IH_BULK_Q', enqopt, msgprop, enq_userdata, enq_msgid);
23:
24: EXCEPTION
25: WHEN queue_disabled_exception THEN

Line 36: pload system.IH_BULK_TYPE;

32:
33: dequeue_options dbms_aq.dequeue_options_t;
34: message_properties dbms_aq.message_properties_t;
35: mid raw(16);
36: pload system.IH_BULK_TYPE;
37: lob_loc clob;
38: l_amount number;
39: n_amount number;
40: buffer raw(4096);