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.PV_REFERRAL_GENERAL_PUB dependencies on PV_GE_HISTORY_LOG_B

Line 91: -- (2) To log a message in pv_ge_history_log_b table to record the fact that

87: -- (1) Update the status of referrals/deal registration to the following status
88: -- codes: CLOSED_LOST_OPPTY, CLOSED_OPPTY_WON, CLOSED_DEAD_LEAD,
89: -- EXPIRED.
90: --
91: -- (2) To log a message in pv_ge_history_log_b table to record the fact that
92: -- an order has been created as a result of a quote, which is linked to an
93: -- opportunity, being generated.
94: --
95: --==============================================================================

Line 189: FROM pv_ge_history_log_b b

185: WHERE REF.entity_type IN ('LEAD') AND
186: REF.entity_id_linked_to IS NOT NULL AND
187: NOT EXISTS (
188: SELECT 'x'
189: FROM pv_ge_history_log_b b
190: WHERE REF.entity_id_linked_to = b.history_for_entity_id AND
191: b.arc_history_for_entity_code = 'OPPORTUNITY' AND
192: b.history_category_code = 'GENERAL' AND
193: b.message_code = 'PV_LG_OPPTY_ORDER_PLACED'

Line 233: FROM pv_ge_history_log_b LOG

229: a.lead_id = c.lead_id AND
230: c.customer_id = d.party_id AND
231: NOT EXISTS (
232: SELECT 'x'
233: FROM pv_ge_history_log_b LOG
234: WHERE c.lead_id = LOG.history_for_entity_id AND
235: LOG.arc_history_for_entity_code = 'OPPORTUNITY' AND
236: LOG.history_category_code = 'GENERAL' AND
237: LOG.message_code = 'PV_LG_OPPTY_ORDER_PLACED'

Line 704: -- Log records in pv_ge_history_log_b for

700: END LOOP;
701:
702:
703: -- -----------------------------------------------------------------------
704: -- Log records in pv_ge_history_log_b for
705: -- opportunity --> quote --> order links.
706: -- -----------------------------------------------------------------------
707: Debug('-------------------------------------------------------------------------');
708: Debug('Log records in pv_ge_history_log_b to report the fact that');

Line 708: Debug('Log records in pv_ge_history_log_b to report the fact that');

704: -- Log records in pv_ge_history_log_b for
705: -- opportunity --> quote --> order links.
706: -- -----------------------------------------------------------------------
707: Debug('-------------------------------------------------------------------------');
708: Debug('Log records in pv_ge_history_log_b to report the fact that');
709: Debug('an order has been created as the result of generating a quote linked');
710: Debug('to an opportunity.');
711:
712: FOR x IN c_opportunity_order LOOP