DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on ZX_LINES

Line 3495: | on the zx_lines with the value passed as input to this procedure |

3491: | zx_upd_legal_reporting_status() |
3492: | |
3493: | DESCRIPTION |
3494: | This procedure is used to update the legal_reporting_status value |
3495: | on the zx_lines with the value passed as input to this procedure |
3496: | |
3497: | SCOPE - Public |
3498: | |
3499: | NOTES |

Line 3518: p_legal_reporting_status_val IN zx_lines.LEGAL_REPORTING_STATUS%type,

3514: p_trx_id_tbl IN trx_id_tbl,
3515: p_trx_line_id_tbl IN trx_line_id_tbl,
3516: p_INTERNAL_ORGANIZATION_ID_tbl IN INTERNAL_ORGANIZATION_ID_TBL,
3517: p_TAX_LINE_ID_tbl IN TAX_LINE_ID_TBL,
3518: p_legal_reporting_status_val IN zx_lines.LEGAL_REPORTING_STATUS%type,
3519: x_return_status OUT NOCOPY VARCHAR2,
3520: x_msg_count OUT NOCOPY NUMBER,
3521: x_msg_data OUT NOCOPY VARCHAR2
3522: ) IS

Line 3548: UPDATE ZX_LINES

3544: LOOP
3545: IF ( l_counter_end <= l_count AND l_counter_start <= l_count ) THEN
3546:
3547: FORALL i IN l_counter_start .. l_counter_end
3548: UPDATE ZX_LINES
3549: SET LEGAL_REPORTING_STATUS = p_legal_reporting_status_val,
3550: LAST_UPDATED_BY = fnd_global.user_id ,
3551: LAST_UPDATE_DATE = SYSDATE ,
3552: LAST_UPDATE_LOGIN = fnd_global.conc_login_id ,