809:
810: -- First Try to Update the Row in the Interface Table
811:
812: UPDATE
813: PA_EXP_TYPES_IT
814: SET
815: ALL_EXPENDITURE_TYPES = EXPENDITURE_TYPES_R.ALL_EXPENDITURE_TYPES,
816: EXPENDITURE_CATEGORY = EXPENDITURE_TYPES_R.EXPENDITURE_CATEGORY,
817: REVENUE_CATEGORY_CODE = EXPENDITURE_TYPES_R.REVENUE_CATEGORY_CODE,
843: -- Check If Any row was updated
844:
845: IF (SQL%ROWCOUNT = 0) THEN
846: -- No row was updated, So Insert a new row into the interface table
847: INSERT INTO PA_EXP_TYPES_IT
848: (
849: EXPENDITURE_TYPE,
850: ALL_EXPENDITURE_TYPES,
851: EXPENDITURE_CATEGORY,