APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_ACCT_PMT_PROFILES_B

Line 1435: UPDATE iby_acct_pmt_profiles_b

1431: -- input seq1
1432: IF l_seq_name1 IS NOT NULL AND l_seq_name1 = trim(p_seq_name1)
1433: AND p_last_val1 IS NOT NULL AND nvl(l_seq_last1, -99) <> p_last_val1 THEN
1434:
1435: UPDATE iby_acct_pmt_profiles_b
1436: SET
1437: last_used_number_1 = p_last_val1
1438: WHERE
1439: payment_profile_id = l_payment_profile_id;

Line 1446: UPDATE iby_acct_pmt_profiles_b

1442:
1443: ELSIF l_seq_name2 IS NOT NULL AND l_seq_name2 = trim(p_seq_name1)
1444: AND p_last_val1 IS NOT NULL AND nvl(l_seq_last2, -99) <> p_last_val1 THEN
1445:
1446: UPDATE iby_acct_pmt_profiles_b
1447: SET
1448: last_used_number_2 = p_last_val1
1449: WHERE
1450: payment_profile_id = l_payment_profile_id;

Line 1457: UPDATE iby_acct_pmt_profiles_b

1453:
1454: ELSIF l_seq_name3 IS NOT NULL AND l_seq_name3 = trim(p_seq_name1)
1455: AND p_last_val1 IS NOT NULL AND nvl(l_seq_last3, -99) <> p_last_val1 THEN
1456:
1457: UPDATE iby_acct_pmt_profiles_b
1458: SET
1459: last_used_number_3 = p_last_val1
1460: WHERE
1461: payment_profile_id = l_payment_profile_id;

Line 1471: UPDATE iby_acct_pmt_profiles_b

1467: -- input seq2
1468: IF l_seq_name1 IS NOT NULL AND l_seq_name1 = trim(p_seq_name2)
1469: AND p_last_val2 IS NOT NULL AND nvl(l_seq_last1, -99) <> p_last_val2 THEN
1470:
1471: UPDATE iby_acct_pmt_profiles_b
1472: SET
1473: last_used_number_1 = p_last_val2
1474: WHERE
1475: payment_profile_id = l_payment_profile_id;

Line 1482: UPDATE iby_acct_pmt_profiles_b

1478:
1479: ELSIF l_seq_name2 IS NOT NULL AND l_seq_name2 = trim(p_seq_name2)
1480: AND p_last_val2 IS NOT NULL AND nvl(l_seq_last2, -99) <> p_last_val2 THEN
1481:
1482: UPDATE iby_acct_pmt_profiles_b
1483: SET
1484: last_used_number_2 = p_last_val2
1485: WHERE
1486: payment_profile_id = l_payment_profile_id;

Line 1493: UPDATE iby_acct_pmt_profiles_b

1489:
1490: ELSIF l_seq_name3 IS NOT NULL AND l_seq_name3 = trim(p_seq_name2)
1491: AND p_last_val2 IS NOT NULL AND nvl(l_seq_last3, -99) <> p_last_val2 THEN
1492:
1493: UPDATE iby_acct_pmt_profiles_b
1494: SET
1495: last_used_number_3 = p_last_val2
1496: WHERE
1497: payment_profile_id = l_payment_profile_id;

Line 1507: UPDATE iby_acct_pmt_profiles_b

1503: -- input seq3
1504: IF l_seq_name1 IS NOT NULL AND l_seq_name1 = trim(p_seq_name3)
1505: AND p_last_val3 IS NOT NULL AND nvl(l_seq_last1, -99) <> p_last_val3 THEN
1506:
1507: UPDATE iby_acct_pmt_profiles_b
1508: SET
1509: last_used_number_1 = p_last_val3
1510: WHERE
1511: payment_profile_id = l_payment_profile_id;

Line 1518: UPDATE iby_acct_pmt_profiles_b

1514:
1515: ELSIF l_seq_name2 IS NOT NULL AND l_seq_name2 = trim(p_seq_name3)
1516: AND p_last_val3 IS NOT NULL AND nvl(l_seq_last2, -99) <> p_last_val3 THEN
1517:
1518: UPDATE iby_acct_pmt_profiles_b
1519: SET
1520: last_used_number_2 = p_last_val3
1521: WHERE
1522: payment_profile_id = l_payment_profile_id;

Line 1529: UPDATE iby_acct_pmt_profiles_b

1525:
1526: ELSIF l_seq_name3 IS NOT NULL AND l_seq_name3 = trim(p_seq_name3)
1527: AND p_last_val3 IS NOT NULL AND nvl(l_seq_last3, -99) <> p_last_val3 THEN
1528:
1529: UPDATE iby_acct_pmt_profiles_b
1530: SET
1531: last_used_number_3 = p_last_val3
1532: WHERE
1533: payment_profile_id = l_payment_profile_id;

Line 1541: UPDATE iby_acct_pmt_profiles_b

1537: END IF;
1538:
1539: IF l_obj_updated THEN
1540:
1541: UPDATE iby_acct_pmt_profiles_b
1542: SET
1543: object_version_number = object_version_number + 1,
1544: last_updated_by = fnd_global.user_id,
1545: last_update_date = SYSDATE,

Line 2127: UPDATE iby_acct_pmt_profiles_b

2123: END IF;
2124:
2125: IF p_sequence_number = 1 THEN
2126:
2127: UPDATE iby_acct_pmt_profiles_b
2128: SET
2129: reset_value_1 = nvl(p_reset_value, reset_value_1),
2130: last_used_number_1 = nvl(p_reset_value, reset_value_1),
2131: reset_request_1 = fnd_global.CONC_REQUEST_ID,

Line 2141: UPDATE iby_acct_pmt_profiles_b

2137: payment_profile_id = p_payment_profile_id;
2138:
2139: ELSIF p_sequence_number = 2 THEN
2140:
2141: UPDATE iby_acct_pmt_profiles_b
2142: SET
2143: reset_value_2 = nvl(p_reset_value, reset_value_2),
2144: last_used_number_2 = nvl(p_reset_value, reset_value_2),
2145: reset_request_2 = fnd_global.CONC_REQUEST_ID,

Line 2155: UPDATE iby_acct_pmt_profiles_b

2151: payment_profile_id = p_payment_profile_id;
2152:
2153: ELSIF p_sequence_number = 3 THEN
2154:
2155: UPDATE iby_acct_pmt_profiles_b
2156: SET
2157: reset_value_3 = nvl(p_reset_value, reset_value_3),
2158: last_used_number_3 = nvl(p_reset_value, reset_value_3),
2159: reset_request_3 = fnd_global.CONC_REQUEST_ID,