DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on ZX_LINES

Line 1588: --EMEA : Changes for EMEA/Updation of Legal_Reporting_Status on the zx_lines

1584: p_rows_deleted out NOCOPY number);
1585:
1586: procedure purge(p_request_id in number);
1587:
1588: --EMEA : Changes for EMEA/Updation of Legal_Reporting_Status on the zx_lines
1589:
1590: PROCEDURE zx_upd_legal_reporting_status(
1591: p_api_version IN NUMBER,
1592: p_init_msg_list IN VARCHAR2,

Line 1602: p_legal_reporting_status_val IN zx_lines.LEGAL_REPORTING_STATUS%type,

1598: p_trx_id_tbl IN trx_id_tbl,
1599: p_trx_line_id_tbl IN trx_line_id_tbl,
1600: p_INTERNAL_ORGANIZATION_ID_tbl IN INTERNAL_ORGANIZATION_ID_TBL,
1601: p_TAX_LINE_ID_tbl IN TAX_LINE_ID_TBL,
1602: p_legal_reporting_status_val IN zx_lines.LEGAL_REPORTING_STATUS%type,
1603: x_return_status OUT NOCOPY VARCHAR2,
1604: x_msg_count OUT NOCOPY NUMBER,
1605: x_msg_data OUT NOCOPY VARCHAR2
1606: );

Line 1632: (p_trx_id IN zx_lines.trx_id%TYPE,

1628:
1629: function purge(p_request_id in number) return number;
1630:
1631: FUNCTION get_legal_message
1632: (p_trx_id IN zx_lines.trx_id%TYPE,
1633: p_trx_line_id IN zx_lines.trx_line_id%TYPE,
1634: p_delimiter IN VARCHAR2 DEFAULT NULL)
1635: RETURN VARCHAR2;
1636:

Line 1633: p_trx_line_id IN zx_lines.trx_line_id%TYPE,

1629: function purge(p_request_id in number) return number;
1630:
1631: FUNCTION get_legal_message
1632: (p_trx_id IN zx_lines.trx_id%TYPE,
1633: p_trx_line_id IN zx_lines.trx_line_id%TYPE,
1634: p_delimiter IN VARCHAR2 DEFAULT NULL)
1635: RETURN VARCHAR2;
1636:
1637: FUNCTION get_vat_transaction_code_name

Line 1638: (p_tax_line_id IN zx_lines.tax_line_id%TYPE,

1634: p_delimiter IN VARCHAR2 DEFAULT NULL)
1635: RETURN VARCHAR2;
1636:
1637: FUNCTION get_vat_transaction_code_name
1638: (p_tax_line_id IN zx_lines.tax_line_id%TYPE,
1639: p_esl_eu_trx_type IN VARCHAR2,
1640: p_esl_eu_goods IN VARCHAR2,
1641: p_esl_eu_services IN VARCHAR2,
1642: p_esl_eu_addl_code1 IN VARCHAR2,