[Home] [Help]
1010: /**************************************** 3005756 END ***************************************/
1011:
1012: /*************************************************************************
1013: routine name: prc_write_data
1014: purpose: Write data to temp table PAY_US_RPT_TOTALS
1015: parameters: IN_record_type - 'V' record is part of tax verification
1016: - 'U' record is part of unacceptable
1017: IN_gre_id -
1018: IN_org_id -
1029: IN_message - Corresponding message for each record
1030: IN_sort_code - Derived Jurisdiction code for sorting in report
1031: return: None
1032: specs: Below is the mapping that it used to write processed data to
1033: PAY_US_RPT_TOTALS table. There are two types of records, 1 is
1034: header record and the other is detail record.
1035: column mapping specs for header record:
1036: SESSION_ID := payroll_action_id (PYUGEN Payroll Action)
1037: TAX_UNIT_ID := tax_unit_id (from pay_assignment_actions)
1101:
1102: -- if assignment_action_id changed then write new header record
1103: G_asgn_action_id := IN_asgn_action_id;
1104:
1105: INSERT INTO pay_us_rpt_totals
1106: (state_code,
1107: tax_unit_id,
1108: organization_id,
1109: location_id,
1138:
1139: END IF;
1140:
1141: -- write data for taxable verification/unacceptable portion of report
1142: INSERT INTO pay_us_rpt_totals
1143: (state_code,
1144: tax_unit_id,
1145: session_id,
1146: business_group_id,
1327:
1328: /*************************************************************************
1329: routine name: prc_process_data
1330: purpose: Does the entire processing for unacceptable balance report
1331: and Dumps the data to table PAY_US_RPT_TOTALS
1332: parameters: IN_pact_id -
1333: IN_chunk_no -
1334: IN_commit_count -
1335: IN_lockingactid -
3875: WHEN OTHERS THEN
3876: -- rollback all uncommited changes
3877: ROLLBACK;
3878: -- does not matter what the error is delete all commited inserted tmp records
3879: DELETE pay_us_rpt_totals
3880: WHERE session_id = IN_pact_id
3881: AND business_group_id = IN_chunk_no
3882: AND tax_unit_id = IN_prc_tax_unit_id; -- Bug 3316599 to reduce the cost of query
3883: COMMIT;