eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_EXTRACT_PKG dependencies on ZX_LINES

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

3987: | zx_upd_legal_reporting_status() |
3988: | |
3989: | DESCRIPTION |
3990: | This procedure is used to update the legal_reporting_status value |
3991: | on the zx_lines with the value passed as input to this procedure |
3992: | |
3993: | SCOPE - Public |
3994: | |
3995: | NOTES |

Line 4014: p_legal_reporting_status_val IN zx_lines.LEGAL_REPORTING_STATUS%type,

4010: p_trx_id_tbl IN trx_id_tbl,
4011: p_trx_line_id_tbl IN trx_line_id_tbl,
4012: p_INTERNAL_ORGANIZATION_ID_tbl IN INTERNAL_ORGANIZATION_ID_TBL,
4013: p_TAX_LINE_ID_tbl IN TAX_LINE_ID_TBL,
4014: p_legal_reporting_status_val IN zx_lines.LEGAL_REPORTING_STATUS%type,
4015: x_return_status OUT NOCOPY VARCHAR2,
4016: x_msg_count OUT NOCOPY NUMBER,
4017: x_msg_data OUT NOCOPY VARCHAR2
4018: ) IS

Line 4044: UPDATE ZX_LINES

4040: LOOP
4041: IF ( l_counter_end <= l_count AND l_counter_start <= l_count ) THEN
4042:
4043: FORALL i IN l_counter_start .. l_counter_end
4044: UPDATE ZX_LINES
4045: SET LEGAL_REPORTING_STATUS = p_legal_reporting_status_val,
4046: LAST_UPDATED_BY = fnd_global.user_id ,
4047: LAST_UPDATE_DATE = SYSDATE ,
4048: LAST_UPDATE_LOGIN = fnd_global.conc_login_id ,

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

4105: | 02-Dec-2009 Taniya Sen Modified |
4106: | |
4107: +===========================================================================*/
4108: FUNCTION get_legal_message
4109: (p_trx_id IN zx_lines.trx_id%TYPE,
4110: p_trx_line_id IN zx_lines.trx_line_id%TYPE,
4111: p_delimiter IN VARCHAR2 DEFAULT NULL)
4112: RETURN VARCHAR2 IS
4113:

Line 4110: p_trx_line_id IN zx_lines.trx_line_id%TYPE,

4106: | |
4107: +===========================================================================*/
4108: FUNCTION get_legal_message
4109: (p_trx_id IN zx_lines.trx_id%TYPE,
4110: p_trx_line_id IN zx_lines.trx_line_id%TYPE,
4111: p_delimiter IN VARCHAR2 DEFAULT NULL)
4112: RETURN VARCHAR2 IS
4113:
4114: /*----------------------------------------+

Line 4128: zx_lines zxl

4124: FROM (
4125: SELECT DISTINCT rep_codes.reporting_code_name, zxl.trx_line_id, zxl.tax_line_id,1 order_num
4126: FROM zx_reporting_types_b rep_types,
4127: zx_reporting_codes_vl rep_codes,
4128: zx_lines zxl
4129: WHERE zxl.application_id = 222
4130: AND zxl.entity_code = 'TRANSACTIONS'
4131: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
4132: AND zxl.trx_id = p_trx_id

Line 4141: zx_lines zxl

4137: SELECT DISTINCT rep_codes.reporting_code_name, zxl.trx_line_id,zxl.tax_line_id, 2 order_num
4138: FROM zx_report_codes_assoc rep_assoc,
4139: zx_reporting_types_b rep_types,
4140: zx_reporting_codes_vl rep_codes,
4141: zx_lines zxl
4142: WHERE zxl.application_id = 222
4143: AND zxl.entity_code = 'TRANSACTIONS'
4144: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
4145: AND zxl.trx_id = p_trx_id

Line 4158: zx_lines zxl

4154: UNION
4155: SELECT DISTINCT rep_codes.reporting_code_name, zxl.trx_line_id,zxl.tax_line_id, 3 order_num
4156: FROM zx_reporting_types_b rep_types,
4157: zx_reporting_codes_vl rep_codes,
4158: zx_lines zxl
4159: WHERE zxl.application_id = 222
4160: AND zxl.entity_code = 'TRANSACTIONS'
4161: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
4162: AND zxl.trx_id = p_trx_id

Line 4183: zx_lines zxl

4179: FROM (
4180: SELECT DISTINCT rep_codes.reporting_code_name, zxl.tax_line_id,1 order_num
4181: FROM zx_reporting_types_b rep_types,
4182: zx_reporting_codes_vl rep_codes,
4183: zx_lines zxl
4184: WHERE zxl.application_id = 222
4185: AND zxl.entity_code = 'TRANSACTIONS'
4186: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
4187: AND zxl.trx_id = p_trx_id

Line 4197: zx_lines zxl

4193: SELECT DISTINCT rep_codes.reporting_code_name, zxl.tax_line_id, 2 order_num
4194: FROM zx_report_codes_assoc rep_assoc,
4195: zx_reporting_types_b rep_types,
4196: zx_reporting_codes_vl rep_codes,
4197: zx_lines zxl
4198: WHERE zxl.application_id = 222
4199: AND zxl.entity_code = 'TRANSACTIONS'
4200: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
4201: AND zxl.trx_id = p_trx_id

Line 4215: zx_lines zxl

4211: UNION
4212: SELECT DISTINCT rep_codes.reporting_code_name, zxl.tax_line_id, 3 order_num
4213: FROM zx_reporting_types_b rep_types,
4214: zx_reporting_codes_vl rep_codes,
4215: zx_lines zxl
4216: WHERE zxl.application_id = 222
4217: AND zxl.entity_code = 'TRANSACTIONS'
4218: AND zxl.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
4219: AND zxl.trx_id = p_trx_id

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

4281:
4282: END get_legal_message;
4283:
4284: FUNCTION get_vat_transaction_code_name
4285: (p_tax_line_id IN zx_lines.tax_line_id%TYPE,
4286: p_esl_eu_trx_type IN VARCHAR2,
4287: p_esl_eu_goods IN VARCHAR2,
4288: p_esl_eu_services IN VARCHAR2,
4289: p_esl_eu_addl_code1 IN VARCHAR2,

Line 4308: zx_lines zxl

4304: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 1 order_num
4305: FROM zx_report_codes_assoc rep_assoc,
4306: zx_reporting_types_b rep_types,
4307: zx_reporting_codes_vl rep_codes,
4308: zx_lines zxl
4309: WHERE zxl.tax_line_id = p_tax_line_id
4310: AND rep_types.reporting_type_id = p_esl_eu_trx_type
4311: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id
4312: AND rep_assoc.entity_id = NVL(zxl.direct_rate_result_id, zxl.rate_result_id)

Line 4330: zx_lines zxl

4326: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 2 order_num
4327: FROM zx_report_codes_assoc rep_assoc,
4328: zx_reporting_types_b rep_types,
4329: zx_reporting_codes_vl rep_codes,
4330: zx_lines zxl
4331: WHERE zxl.tax_line_id = p_tax_line_id
4332: AND rep_types.reporting_type_id = p_esl_eu_trx_type
4333: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id
4334: AND rep_assoc.entity_id = zxl.tax_rate_id

Line 4352: zx_lines zxl

4348: SELECT rep_codes.reporting_code_name, rep_codes.reporting_code_char_value, 3 order_num
4349: FROM zx_report_codes_assoc rep_assoc,
4350: zx_reporting_types_b rep_types,
4351: zx_reporting_codes_vl rep_codes,
4352: zx_lines zxl
4353: WHERE zxl.tax_line_id = p_tax_line_id
4354: AND rep_types.reporting_type_id = p_esl_eu_trx_type
4355: AND rep_types.reporting_type_id = rep_assoc.reporting_type_id
4356: AND rep_assoc.entity_id = zxl.status_result_id