879:
880: l_sla_hdr_event_id NUMBER;
881: l_sla_hdr_creation_date DATE;
882: l_sla_entity_id NUMBER;
883: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
884:
885: BEGIN
886: l_module_name := g_module_name || 'journal_process';
887: l_sob := g_set_of_books_id;
2070: l_category = 'Debit Memos')
2071: ) THEN
2072: BEGIN
2073: --Bug 7121539
2074: --customer_trx_line_id will be null in ra_cust_trx_line_gl_dist_all
2075: --for account class 'REC', hence using customer_trx_id to get
2076: --details instead of customer_trx_line_id for these distributions
2077: SELECT account_class
2078: INTO l_account_class
2075: --for account class 'REC', hence using customer_trx_id to get
2076: --details instead of customer_trx_line_id for these distributions
2077: SELECT account_class
2078: INTO l_account_class
2079: FROM ra_cust_trx_line_gl_dist_all
2080: WHERE cust_trx_line_gl_dist_id = l_source_distribution_id_num_1;
2081:
2082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2083: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2090: rcth.customer_trx_id
2091: INTO l_reference_4,
2092: l_reference_7,
2093: l_reference_2
2094: FROM ra_cust_trx_line_gl_dist_all rctgl,
2095: ra_customer_trx_lines_all rctl,
2096: ra_customer_trx_all rcth
2097: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2098: AND rctl.customer_trx_line_id = rctgl.customer_trx_line_id
2103: rcth.customer_trx_id
2104: INTO l_reference_4,
2105: l_reference_7,
2106: l_reference_2
2107: FROM ra_cust_trx_line_gl_dist_all rctgl,
2108: ra_customer_trx_all rcth
2109: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2110: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2111: END IF;