APPS.FA_CUA_ASSET_APIS dependencies on FA_MASS_UPDATE_BATCH_HEADERS

Line 1074: FROM fa_mass_update_batch_headers

1070: RETCODE OUT NOCOPY VARCHAR2,
1071: x_batch_number IN VARCHAR2 ) IS
1072: CURSOR C_bhdrs IS
1073: SELECT *
1074: FROM fa_mass_update_batch_headers
1075: where batch_number = x_batch_number
1076: and status_code IN ( 'N', 'IP')
1077: for UPDATE NOWAIT;
1078: v_err_stack varchar2(640);

Line 1145: update fa_mass_update_batch_headers

1141: if RETCODE = '0' then
1142: if fa_cua_asset_wb_apis_pkg.check_batch_details_exists(hdr_rec.batch_id, p_log_level_rec => g_log_level_rec) then
1143:
1144: -- bugfix 1507759
1145: update fa_mass_update_batch_headers
1146: set status_code = 'P',
1147: rejection_reason_code = null
1148: where batch_id = hdr_rec.batch_id;
1149: else

Line 1150: update fa_mass_update_batch_headers

1146: set status_code = 'P',
1147: rejection_reason_code = null
1148: where batch_id = hdr_rec.batch_id;
1149: else
1150: update fa_mass_update_batch_headers
1151: set status_code = 'CP',
1152: rejection_reason_code = null
1153: where batch_id = hdr_rec.batch_id;
1154: end if;

Line 1168: update fa_mass_update_batch_headers

1164:
1165: fnd_message.set_name('CUA', RETCODE);
1166: v_message_name:= substrb(fnd_message.get, 1, 240);
1167:
1168: update fa_mass_update_batch_headers
1169: set status_code = 'R',
1170: rejection_reason_code = v_message_name
1171: where batch_number = x_batch_number ;
1172:

Line 1179: update fa_mass_update_batch_headers

1175:
1176: when others then
1177: v_message_name := substrb(sqlerrm(sqlcode), 1, 240);
1178:
1179: update fa_mass_update_batch_headers
1180: set status_code = 'R',
1181: rejection_reason_code = v_message_name
1182: where batch_number = x_batch_number ;
1183:

Line 1393: update fa_mass_update_batch_headers

1389: , x_err_code
1390: , x_err_stage
1391: , x_err_stack , p_log_level_rec => p_log_level_rec);
1392: if (x_err_code <> '0') then
1393: update fa_mass_update_batch_headers
1394: set status_code = 'R',
1395: rejection_reason_code = x_err_code
1396: where batch_id = x_batch_id;
1397: return;

Line 1836: update fa_mass_update_batch_headers

1832: if G_conc_process <> 'Y' then
1833: if fa_cua_asset_wb_apis_pkg.check_batch_details_exists(x_batch_id, p_log_level_rec => p_log_level_rec) then
1834: null;
1835: else
1836: update fa_mass_update_batch_headers
1837: set status_code = 'CP'
1838: where batch_id = x_batch_id;
1839: end if;
1840: end if;

Line 1930: from fa_mass_update_batch_headers

1926: x_book_type_code IN VARCHAR2,
1927: x_batch_id IN NUMBER ) IS
1928: Cursor C1 is
1929: select batch_id
1930: from fa_mass_update_batch_headers
1931: where book_type_code = x_book_type_code
1932: and batch_id = nvl(x_batch_id, batch_id)
1933: and status_code = 'C'
1934: for update NOWAIT;

Line 1943: Delete from fa_mass_update_batch_headers

1939:
1940: Delete from fa_mass_update_batch_details
1941: where batch_id = C1_rec.batch_id;
1942:
1943: Delete from fa_mass_update_batch_headers
1944: where batch_id = C1_rec.batch_id;
1945:
1946: End Loop;
1947: commit;