DBA Data[Home] [Help]

APPS.POS_TAX_REPORT_BO_PKG dependencies on ZX_REPORT_CODES_ASSOC

Line 50: FROM zx_report_codes_assoc

46: reporting_type_id,
47: reporting_code_id,
48: object_version_number) BULK COLLECT
49: INTO l_pos_tax_report_bo_tbl
50: FROM zx_report_codes_assoc
51: WHERE entity_id = l_party_id;
52:
53: x_pos_tax_report_bo_tbl := l_pos_tax_report_bo_tbl;
54: EXCEPTION

Line 108: UPDATE zx_report_codes_assoc

104:
105: FOR i IN p_pos_tax_report_bo.first .. p_pos_tax_report_bo.last LOOP
106: IF p_create_update_flag = 'U' THEN
107: --update the existing row;
108: UPDATE zx_report_codes_assoc
109: SET reporting_code_assoc_id = p_pos_tax_report_bo(i)
110: .reporting_code_assoc_id,
111: entity_code = p_pos_tax_report_bo(i).entity_code,
112: exception_code = p_pos_tax_report_bo(i)

Line 144: INSERT INTO zx_report_codes_assoc

140: FROM dual;
141: IF l_party_id IS NULL THEN
142: l_party_id := p_pos_tax_report_bo(i).entity_id;
143: END IF;
144: INSERT INTO zx_report_codes_assoc
145: (reporting_code_assoc_id,
146: entity_code,
147: entity_id,
148: exception_code,