APPS.FV_SF224_TRANSACTIONS dependencies on FV_SF224_RUN

Line 1475: p_previous_run_date OUT NOCOPY fv_sf224_run.last_run_date%TYPE,

1471: ----------------------------------------------------------------------
1472: PROCEDURE get_run_date
1473: (
1474: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1475: p_previous_run_date OUT NOCOPY fv_sf224_run.last_run_date%TYPE,
1476: p_error_code OUT NOCOPY NUMBER,
1477: p_error_desc OUT NOCOPY VARCHAR2
1478: )
1479: IS

Line 1493: FROM fv_sf224_run fsr

1489:
1490: BEGIN
1491: SELECT last_run_date
1492: INTO p_previous_run_date
1493: FROM fv_sf224_run fsr
1494: WHERE fsr.set_of_books_id = p_set_of_books_id;
1495: EXCEPTION
1496: WHEN NO_DATA_FOUND THEN
1497: /* Commented out to get the old data

Line 1511: l_location := l_module_name||'select_fv_sf224_run';

1507:
1508: WHEN OTHERS THEN
1509: p_error_code := g_FAILURE;
1510: p_error_desc := SQLERRM;
1511: l_location := l_module_name||'select_fv_sf224_run';
1512: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1513: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1514: END;
1515:

Line 1551: UPDATE fv_sf224_run

1547: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_set_of_books_id = '||p_set_of_books_id);
1548: END IF;
1549:
1550: BEGIN
1551: UPDATE fv_sf224_run
1552: SET last_run_date = g_SYSDATE
1553: WHERE set_of_books_id = p_set_of_books_id;
1554: IF (SQL%ROWCOUNT = 0) THEN
1555: l_insert_required := TRUE;

Line 1563: l_location := l_module_name||'update_fv_sf224_run';

1559: EXCEPTION
1560: WHEN OTHERS THEN
1561: p_error_code := g_FAILURE;
1562: p_error_desc := SQLERRM;
1563: l_location := l_module_name||'update_fv_sf224_run';
1564: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1565: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1566: END;
1567: IF (p_error_code = g_SUCCESS AND l_insert_required) THEN

Line 1569: INSERT INTO fv_sf224_run

1565: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1566: END;
1567: IF (p_error_code = g_SUCCESS AND l_insert_required) THEN
1568: BEGIN
1569: INSERT INTO fv_sf224_run
1570: (
1571: set_of_books_id,
1572: last_run_date
1573: )

Line 1583: l_location := l_module_name||'insert_fv_sf224_run';

1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: p_error_code := g_FAILURE;
1582: p_error_desc := SQLERRM;
1583: l_location := l_module_name||'insert_fv_sf224_run';
1584: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1585: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1586: END;
1587: END IF;

Line 1769: p_previous_run_date IN fv_sf224_run.last_run_date%TYPE,

1765: ----------------------------------------------------------------------
1766: PROCEDURE insert_sf224_batches
1767: (
1768: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1769: p_previous_run_date IN fv_sf224_run.last_run_date%TYPE,
1770: p_current_run_date IN fv_sf224_run.last_run_date%TYPE,
1771: p_currency_code IN gl_sets_of_books.currency_code%TYPE,
1772: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,
1773: p_bal_segment IN fnd_id_flex_segments.application_column_name%TYPE,

Line 1770: p_current_run_date IN fv_sf224_run.last_run_date%TYPE,

1766: PROCEDURE insert_sf224_batches
1767: (
1768: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1769: p_previous_run_date IN fv_sf224_run.last_run_date%TYPE,
1770: p_current_run_date IN fv_sf224_run.last_run_date%TYPE,
1771: p_currency_code IN gl_sets_of_books.currency_code%TYPE,
1772: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,
1773: p_bal_segment IN fnd_id_flex_segments.application_column_name%TYPE,
1774: p_error_code OUT NOCOPY NUMBER,