APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on FV_IPAC_BATCH_S

Line 1549: --* : fv_ipac_batch_s *--

1545: --* Called from : process_data *--
1546: --* Calls : fv_utility.debug_mesg *--
1547: --* : fv_utility.log_mesg *--
1548: --* Sequence Used : ap_interface_groups_s *--
1549: --* : fv_ipac_batch_s *--
1550: --* Tables Used : fv_ipac_import DELETE, UPDATE *--
1551: --* Logic : 1. Get sequence number from fv_ipac_batch_s *--
1552: --* : 2. Get sequence number from ap_interface_groups_s *--
1553: --* : 3. Delete records from fv_ipac_import which does not belong to the *--

Line 1551: --* Logic : 1. Get sequence number from fv_ipac_batch_s *--

1547: --* : fv_utility.log_mesg *--
1548: --* Sequence Used : ap_interface_groups_s *--
1549: --* : fv_ipac_batch_s *--
1550: --* Tables Used : fv_ipac_import DELETE, UPDATE *--
1551: --* Logic : 1. Get sequence number from fv_ipac_batch_s *--
1552: --* : 2. Get sequence number from ap_interface_groups_s *--
1553: --* : 3. Delete records from fv_ipac_import which does not belong to the *--
1554: --* : parameter alc code. *--
1555: --* : 4. Delete records from fv_ipac_import where transction type is in *--

Line 1590: SELECT 'IPAC'||TO_CHAR(fv_ipac_batch_s.NEXTVAL),

1586: BEGIN
1587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1588: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting ap_interface_groups_s');
1589: END IF;
1590: SELECT 'IPAC'||TO_CHAR(fv_ipac_batch_s.NEXTVAL),
1591: ap_interface_groups_s.NEXTVAL
1592: INTO p_batch_name,
1593: p_group_id
1594: FROM dual;

Line 1604: l_location := l_module_name||'.select_fv_ipac_batch_s_nextval';

1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: p_error_code := g_FAILURE;
1603: p_error_desc := SQLERRM;
1604: l_location := l_module_name||'.select_fv_ipac_batch_s_nextval';
1605: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1606: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1607: END;
1608: END IF;