APPS.PAY_US_MWR_REPORTING_PKG dependencies on PAY_US_RPT_TOTALS

Line 1107: UPDATE pay_us_rpt_totals prt

1103: hr_utility.set_location(gv_package || '.' || l_procedure , 80);
1104:
1105: IF i = 1 THEN -- UPDATING / INSERTING into column value1
1106: hr_utility.set_location(gv_package || '.' || l_procedure , 90);
1107: UPDATE pay_us_rpt_totals prt
1108: SET prt.value1 = NVL(prt.value1,0) + 1
1109: WHERE prt.session_id = v_session_id
1110: AND prt.organization_id = p_payroll_action_id
1111: AND prt.location_id = l_worksite

Line 1120: INSERT into pay_us_rpt_totals

1116:
1117: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
1118: hr_utility.set_location(gv_package || '.' || l_procedure , 100);
1119:
1120: INSERT into pay_us_rpt_totals
1121: ( session_id
1122: ,organization_id
1123: ,location_id
1124: ,state_abbrev

Line 1141: UPDATE pay_us_rpt_totals prt

1137: ,1);
1138: END IF;
1139: ELSIF i = 2 THEN -- UPDATING / INSERTING into Column value2
1140: hr_utility.set_location(gv_package || '.' || l_procedure , 110);
1141: UPDATE pay_us_rpt_totals prt
1142: SET prt.value2 = NVL(prt.value2,0) + 1
1143: WHERE prt.session_id = v_session_id
1144: AND prt.organization_id = p_payroll_action_id
1145: AND prt.location_id = l_worksite

Line 1154: INSERT into pay_us_rpt_totals

1150:
1151: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
1152: hr_utility.set_location(gv_package || '.' || l_procedure , 120);
1153:
1154: INSERT into pay_us_rpt_totals
1155: ( session_id
1156: ,organization_id
1157: ,location_id
1158: ,state_abbrev

Line 1175: UPDATE pay_us_rpt_totals prt

1171: ,1);
1172: END IF;
1173: ELSIF i = 3 THEN -- UPDATING / INSERTING into column value3
1174: hr_utility.set_location(gv_package || '.' || l_procedure , 130);
1175: UPDATE pay_us_rpt_totals prt
1176: SET prt.value3 = NVL(prt.value3,0) + 1
1177: WHERE prt.session_id = v_session_id
1178: AND prt.organization_id = p_payroll_action_id
1179: AND prt.location_id = l_worksite

Line 1188: INSERT into pay_us_rpt_totals

1184:
1185: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
1186: hr_utility.set_location(gv_package || '.' || l_procedure , 140);
1187:
1188: INSERT into pay_us_rpt_totals
1189: ( session_id
1190: ,organization_id
1191: ,location_id
1192: ,state_abbrev

Line 1210: UPDATE pay_us_rpt_totals prt

1206: END IF;
1207: ELSE -- UPDATING / INSERTING into column value4
1208: hr_utility.set_location(gv_package || '.' || l_procedure , 150);
1209:
1210: UPDATE pay_us_rpt_totals prt
1211: SET prt.value4 = NVL(prt.value4,0) + l_archive_value
1212: WHERE prt.session_id = v_session_id
1213: AND prt.organization_id = p_payroll_action_id
1214: AND prt.location_id = l_worksite

Line 1223: INSERT into pay_us_rpt_totals

1219:
1220: IF SQL%ROWCOUNT = 0 THEN --- Row doesn't exist in table must insert.
1221: hr_utility.set_location(gv_package || '.' || l_procedure , 160);
1222:
1223: INSERT into pay_us_rpt_totals
1224: ( session_id
1225: ,organization_id
1226: ,location_id
1227: ,state_abbrev

Line 1282: -- sum the counts from pay_us_rpt_totals

1278: INTO l_state_code
1279: FROM pay_state_rules
1280: where fips_code = to_number(p_fips_code);
1281:
1282: -- sum the counts from pay_us_rpt_totals
1283: SELECT nvl(sum(prt.value1),0),
1284: nvl(sum(prt.value2),0),
1285: nvl(sum(prt.value3),0),
1286: nvl(sum(prt.value4),0)

Line 1291: FROM pay_us_rpt_totals prt

1287: INTO l_month_1_count,
1288: l_month_2_count,
1289: l_month_3_count,
1290: l_est_wages
1291: FROM pay_us_rpt_totals prt
1292: WHERE prt.organization_id = p_payroll_action_id
1293: AND prt.location_id = to_number(p_est_id)
1294: AND prt.state_abbrev = l_state_code
1295: AND prt.attribute2 = p_sui_id

Line 1321: FROM pay_us_rpt_totals prt

1317: RETURN NUMBER
1318: IS
1319: BEGIN
1320: DELETE
1321: FROM pay_us_rpt_totals prt
1322: WHERE prt.organization_id = p_payroll_action_id
1323: AND prt.attribute1 = 'MWS_EST';
1324:
1325: return (1);