APPS.FA_CUA_ASSET_APIS dependencies on FA_MASS_UPDATE_BATCH_HEADERS

Line 1068: FROM fa_mass_update_batch_headers

1064: RETCODE OUT NOCOPY VARCHAR2,
1065: x_batch_number IN VARCHAR2 ) IS
1066: CURSOR C_bhdrs IS
1067: SELECT *
1068: FROM fa_mass_update_batch_headers
1069: where batch_number = x_batch_number
1070: and status_code IN ( 'N', 'IP')
1071: for UPDATE NOWAIT;
1072: v_err_stack varchar2(640);

Line 1138: update fa_mass_update_batch_headers

1134: if RETCODE = '0' then
1135: if fa_cua_asset_wb_apis_pkg.check_batch_details_exists(hdr_rec.batch_id) then
1136:
1137: -- bugfix 1507759
1138: update fa_mass_update_batch_headers
1139: set status_code = 'P',
1140: rejection_reason_code = null
1141: where batch_id = hdr_rec.batch_id;
1142: else

Line 1143: update fa_mass_update_batch_headers

1139: set status_code = 'P',
1140: rejection_reason_code = null
1141: where batch_id = hdr_rec.batch_id;
1142: else
1143: update fa_mass_update_batch_headers
1144: set status_code = 'CP',
1145: rejection_reason_code = null
1146: where batch_id = hdr_rec.batch_id;
1147: end if;

Line 1161: update fa_mass_update_batch_headers

1157:
1158: fnd_message.set_name('CUA', RETCODE);
1159: v_message_name:= substrb(fnd_message.get, 1, 240);
1160:
1161: update fa_mass_update_batch_headers
1162: set status_code = 'R',
1163: rejection_reason_code = v_message_name
1164: where batch_number = x_batch_number ;
1165:

Line 1172: update fa_mass_update_batch_headers

1168:
1169: when others then
1170: v_message_name := substrb(sqlerrm(sqlcode), 1, 240);
1171:
1172: update fa_mass_update_batch_headers
1173: set status_code = 'R',
1174: rejection_reason_code = v_message_name
1175: where batch_number = x_batch_number ;
1176:

Line 1386: update fa_mass_update_batch_headers

1382: , x_err_code
1383: , x_err_stage
1384: , x_err_stack );
1385: if (x_err_code <> '0') then
1386: update fa_mass_update_batch_headers
1387: set status_code = 'R',
1388: rejection_reason_code = x_err_code
1389: where batch_id = x_batch_id;
1390: return;

Line 1819: update fa_mass_update_batch_headers

1815: if G_conc_process <> 'Y' then
1816: if fa_cua_asset_wb_apis_pkg.check_batch_details_exists(x_batch_id) then
1817: null;
1818: else
1819: update fa_mass_update_batch_headers
1820: set status_code = 'CP'
1821: where batch_id = x_batch_id;
1822: end if;
1823: end if;

Line 1910: from fa_mass_update_batch_headers

1906: x_book_type_code IN VARCHAR2,
1907: x_batch_id IN NUMBER ) IS
1908: Cursor C1 is
1909: select batch_id
1910: from fa_mass_update_batch_headers
1911: where book_type_code = x_book_type_code
1912: and batch_id = nvl(x_batch_id, batch_id)
1913: and status_code = 'C'
1914: for update NOWAIT;

Line 1923: Delete from fa_mass_update_batch_headers

1919:
1920: Delete from fa_mass_update_batch_details
1921: where batch_id = C1_rec.batch_id;
1922:
1923: Delete from fa_mass_update_batch_headers
1924: where batch_id = C1_rec.batch_id;
1925:
1926: End Loop;
1927: commit;