APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_ACCT_PMT_PROFILES_B

Line 1226: UPDATE iby_acct_pmt_profiles_b

1222: -- input seq1
1223: IF l_seq_name1 IS NOT NULL AND l_seq_name1 = trim(p_seq_name1)
1224: AND p_last_val1 IS NOT NULL AND nvl(l_seq_last1, -99) <> p_last_val1 THEN
1225:
1226: UPDATE iby_acct_pmt_profiles_b
1227: SET
1228: last_used_number_1 = p_last_val1
1229: WHERE
1230: payment_profile_id = l_payment_profile_id;

Line 1237: UPDATE iby_acct_pmt_profiles_b

1233:
1234: ELSIF l_seq_name2 IS NOT NULL AND l_seq_name2 = trim(p_seq_name1)
1235: AND p_last_val1 IS NOT NULL AND nvl(l_seq_last2, -99) <> p_last_val1 THEN
1236:
1237: UPDATE iby_acct_pmt_profiles_b
1238: SET
1239: last_used_number_2 = p_last_val1
1240: WHERE
1241: payment_profile_id = l_payment_profile_id;

Line 1248: UPDATE iby_acct_pmt_profiles_b

1244:
1245: ELSIF l_seq_name3 IS NOT NULL AND l_seq_name3 = trim(p_seq_name1)
1246: AND p_last_val1 IS NOT NULL AND nvl(l_seq_last3, -99) <> p_last_val1 THEN
1247:
1248: UPDATE iby_acct_pmt_profiles_b
1249: SET
1250: last_used_number_3 = p_last_val1
1251: WHERE
1252: payment_profile_id = l_payment_profile_id;

Line 1262: UPDATE iby_acct_pmt_profiles_b

1258: -- input seq2
1259: IF l_seq_name1 IS NOT NULL AND l_seq_name1 = trim(p_seq_name2)
1260: AND p_last_val2 IS NOT NULL AND nvl(l_seq_last1, -99) <> p_last_val2 THEN
1261:
1262: UPDATE iby_acct_pmt_profiles_b
1263: SET
1264: last_used_number_1 = p_last_val2
1265: WHERE
1266: payment_profile_id = l_payment_profile_id;

Line 1273: UPDATE iby_acct_pmt_profiles_b

1269:
1270: ELSIF l_seq_name2 IS NOT NULL AND l_seq_name2 = trim(p_seq_name2)
1271: AND p_last_val2 IS NOT NULL AND nvl(l_seq_last2, -99) <> p_last_val2 THEN
1272:
1273: UPDATE iby_acct_pmt_profiles_b
1274: SET
1275: last_used_number_2 = p_last_val2
1276: WHERE
1277: payment_profile_id = l_payment_profile_id;

Line 1284: UPDATE iby_acct_pmt_profiles_b

1280:
1281: ELSIF l_seq_name3 IS NOT NULL AND l_seq_name3 = trim(p_seq_name2)
1282: AND p_last_val2 IS NOT NULL AND nvl(l_seq_last3, -99) <> p_last_val2 THEN
1283:
1284: UPDATE iby_acct_pmt_profiles_b
1285: SET
1286: last_used_number_3 = p_last_val2
1287: WHERE
1288: payment_profile_id = l_payment_profile_id;

Line 1298: UPDATE iby_acct_pmt_profiles_b

1294: -- input seq3
1295: IF l_seq_name1 IS NOT NULL AND l_seq_name1 = trim(p_seq_name3)
1296: AND p_last_val3 IS NOT NULL AND nvl(l_seq_last1, -99) <> p_last_val3 THEN
1297:
1298: UPDATE iby_acct_pmt_profiles_b
1299: SET
1300: last_used_number_1 = p_last_val3
1301: WHERE
1302: payment_profile_id = l_payment_profile_id;

Line 1309: UPDATE iby_acct_pmt_profiles_b

1305:
1306: ELSIF l_seq_name2 IS NOT NULL AND l_seq_name2 = trim(p_seq_name3)
1307: AND p_last_val3 IS NOT NULL AND nvl(l_seq_last2, -99) <> p_last_val3 THEN
1308:
1309: UPDATE iby_acct_pmt_profiles_b
1310: SET
1311: last_used_number_2 = p_last_val3
1312: WHERE
1313: payment_profile_id = l_payment_profile_id;

Line 1320: UPDATE iby_acct_pmt_profiles_b

1316:
1317: ELSIF l_seq_name3 IS NOT NULL AND l_seq_name3 = trim(p_seq_name3)
1318: AND p_last_val3 IS NOT NULL AND nvl(l_seq_last3, -99) <> p_last_val3 THEN
1319:
1320: UPDATE iby_acct_pmt_profiles_b
1321: SET
1322: last_used_number_3 = p_last_val3
1323: WHERE
1324: payment_profile_id = l_payment_profile_id;

Line 1332: UPDATE iby_acct_pmt_profiles_b

1328: END IF;
1329:
1330: IF l_obj_updated THEN
1331:
1332: UPDATE iby_acct_pmt_profiles_b
1333: SET
1334: object_version_number = object_version_number + 1,
1335: last_updated_by = fnd_global.user_id,
1336: last_update_date = SYSDATE,

Line 1918: UPDATE iby_acct_pmt_profiles_b

1914: END IF;
1915:
1916: IF p_sequence_number = 1 THEN
1917:
1918: UPDATE iby_acct_pmt_profiles_b
1919: SET
1920: reset_value_1 = nvl(p_reset_value, reset_value_1),
1921: last_used_number_1 = nvl(p_reset_value, reset_value_1),
1922: reset_request_1 = fnd_global.CONC_REQUEST_ID,

Line 1932: UPDATE iby_acct_pmt_profiles_b

1928: payment_profile_id = p_payment_profile_id;
1929:
1930: ELSIF p_sequence_number = 2 THEN
1931:
1932: UPDATE iby_acct_pmt_profiles_b
1933: SET
1934: reset_value_2 = nvl(p_reset_value, reset_value_2),
1935: last_used_number_2 = nvl(p_reset_value, reset_value_2),
1936: reset_request_2 = fnd_global.CONC_REQUEST_ID,

Line 1946: UPDATE iby_acct_pmt_profiles_b

1942: payment_profile_id = p_payment_profile_id;
1943:
1944: ELSIF p_sequence_number = 3 THEN
1945:
1946: UPDATE iby_acct_pmt_profiles_b
1947: SET
1948: reset_value_3 = nvl(p_reset_value, reset_value_3),
1949: last_used_number_3 = nvl(p_reset_value, reset_value_3),
1950: reset_request_3 = fnd_global.CONC_REQUEST_ID,