DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on WF_EVENT

Line 5030: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'

5026: /* Jalaj Srivastava
5027: Raise workflow event for OPM-QM */
5028: /* FOR c1_rec IN cur_get_txn_for_opm_qm
5029: LOOP
5030: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5031: ,p_event_key => c1_rec.transaction_id);
5032: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5033: ,inv_globals.g_sourcetype_rma
5034: ,inv_globals.g_sourcetype_intreq) THEN

Line 5039: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inv.po.receipt'

5035: -- Bug 5361705 - Raise the opm qm quality event for every distinct lot
5036: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)
5037: LOOP
5038:
5039: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inv.po.receipt'
5040: ,p_event_key => to_char(c2_rec.product_transaction_id)||'-'||to_Char(c2_rec.gen_object_id));
5041: END LOOP;
5042:
5043: END IF;

Line 5060: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'

5056: inv_log_util.TRACE('in cur_get_txn_for_opm_qm - c1_rec.transaction_source_type_id = ' || c1_rec.transaction_source_type_id, 'INV_LPN_TRX_PUB', 1);
5057: IF c1_rec.transaction_source_type_id <> inv_globals.G_SOURCETYPE_WIP then -- -- 9756188
5058: inv_log_util.TRACE('about to raise event oracle.apps.gmi.inventory.created for NON G_SOURCETYPE_WIP for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5059: inv_log_util.TRACE(' gen_object_id = ' || l_gen_object_id, 'INV_LPN_TRX_PUB', 1);
5060: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5061: --,p_event_key => c1_rec.transaction_id);
5062: ,p_event_key => to_char(c1_rec.transaction_id)||'-'||to_Char(l_gen_object_id)); -- pass a dummy gen_object_id as there is no lot for this pass
5063: end if;
5064: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder

Line 5076: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'

5072: LOOP
5073: IF c1_rec.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP THEN -- 9756188
5074: inv_log_util.TRACE(' about to raise event oracle.apps.gmi.inventory.created for G_SOURCETYPE_WIP for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5075: inv_log_util.TRACE(' G_SOURCETYPE_WIP gen_object_id = ' || c2_rec.gen_object_id , 'INV_LPN_TRX_PUB', 1);
5076: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5077: --,p_event_key => c1_rec.transaction_id);
5078: ,p_event_key => to_char(c1_rec.transaction_id)||'-'||to_Char(c2_rec.gen_object_id)); -- pass lot number as gen_object_id
5079: ELSE
5080: inv_log_util.TRACE(' about to raise event oracle.apps.gmi.inv.po.receipt for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);

Line 5082: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inv.po.receipt'

5078: ,p_event_key => to_char(c1_rec.transaction_id)||'-'||to_Char(c2_rec.gen_object_id)); -- pass lot number as gen_object_id
5079: ELSE
5080: inv_log_util.TRACE(' about to raise event oracle.apps.gmi.inv.po.receipt for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5081: inv_log_util.TRACE(' gen_object_id = ' || c2_rec.gen_object_id , 'INV_LPN_TRX_PUB', 1);
5082: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inv.po.receipt'
5083: ,p_event_key =>to_char(c2_rec.product_transaction_id)||'-'||to_Char(c2_rec.gen_object_id));
5084: END IF;
5085: i := i + 1; -- 13557341
5086:

Line 5096: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inv.po.receipt'

5092:
5093: IF c1_rec.transaction_source_type_id <> inv_globals.G_SOURCETYPE_WIP then -- 13686877 start added if
5094: inv_log_util.TRACE(' about to raise event oracle.apps.gmi.inv.po.receipt for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5095: inv_log_util.TRACE(' dummy gen_object_id as there is no lot for this pass gen_object_id = ' || l_gen_object_id, 'INV_LPN_TRX_PUB', 1);
5096: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inv.po.receipt'
5097: ,p_event_key =>to_char(c1_rec.transaction_id)||'-'||to_Char(l_gen_object_id)); -- pass a dummy gen_object_id as there is no lot for this pass
5098:
5099:
5100: ELSE

Line 5103: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'

5099:
5100: ELSE
5101: inv_log_util.TRACE('SO about to raise event oracle.apps.gmi.inventory.created for G_SOURCETYPE_WIP for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5102: inv_log_util.TRACE(' dummy gen_object_id as there is no lot for this pass gen_object_id = ' || l_gen_object_id, 'INV_LPN_TRX_PUB', 1);
5103: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5104: ,p_event_key => to_char(c1_rec.transaction_id)||'-'||to_Char(l_gen_object_id)); -- pass a dummy gen_object_id as there is no lot for this pass
5105:
5106: END IF; -- 13686877 end
5107: