DBA Data[Home] [Help]

APPS.CE_BANK_GROUPINGS dependencies on FND_GLOBAL

Line 284: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

280: set group_id = c_upg_id(i),
281: primary_flag = 'Y',
282: secondary_flag = 'N',
283: last_update_date = sysdate,
284: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
285: where bank_or_branch_number = c_bank_or_branch_number(i)
286: and bank_entity_type = p_bank_entity_type
287: and bank_or_branch_number is not null
288: and ce_upgrade_id = c_upg_id(i)

Line 326: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

322: and rownum = 1)),
323: primary_flag = 'N',
324: secondary_flag = 'Y',
325: last_update_date = sysdate,
326: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
327: where bank_or_branch_number = c_bank_or_branch_number(i)
328: and bank_or_branch_number is not null
329: and bank_entity_type = p_bank_entity_type
330: and ce_upgrade_id = c_upg_id(i)

Line 382: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

378: and rownum = 1)),
379: primary_flag = 'N',
380: secondary_flag = 'N',
381: last_update_date = sysdate,
382: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
383: where bank_or_branch_number = c_bank_or_branch_number(i)
384: and bank_or_branch_number is not null
385: and bank_entity_type = p_bank_entity_type
386: and ce_upgrade_id = c_upg_id(i)

Line 398: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

394: set group_id = c_upg_id(i),
395: primary_flag = 'Y',
396: secondary_flag = 'N',
397: last_update_date = sysdate,
398: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
399: where bank_or_branch_number is null
400: and bank_entity_type = p_bank_entity_type
401: and ce_upgrade_id = c_upg_id(i)
402: and not exists

Line 424: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

420: and rownum = 1),
421: primary_flag = 'N',
422: secondary_flag = 'Y',
423: last_update_date = sysdate,
424: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
425: where bank_or_branch_number is null
426: and bank_entity_type = p_bank_entity_type
427: and ce_upgrade_id = c_upg_id(i)
428: and group_id is null

Line 468: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

464: and rownum = 1),
465: primary_flag = 'N',
466: secondary_flag = 'N',
467: last_update_date = sysdate,
468: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
469: where bank_or_branch_number is null
470: and organization_name = c_org_name(i)
471: and bank_entity_type = p_bank_entity_type
472: and ce_upgrade_id = c_upg_id(i)

Line 512: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

508: forall i in c_group_id.first..c_group_id.last
509: update ce_upg_bank_rec
510: set known_as = nvl(c_known_as(i), known_as),
511: last_update_date = sysdate,
512: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
513: where ce_upgrade_id = c_group_id(i);
514:
515: end if;
516:

Line 654: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

650: update ce_upg_bank_rec b
651: set organization_name =
652: organization_name || ' ' || bank_or_branch_number,
653: last_update_date = sysdate,
654: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
655: where ce_upgrade_id = c_upg_id(i)
656: and exists
657: (select null from ce_upg_bank_rec b2
658: where b2.country = b.country

Line 724: sysdate, NVL(FND_GLOBAL.user_id,-1),

720: (ce_upgrade_id, bank_entity_type, key_error_flag, application_id,
721: message_name, creation_date, created_by, last_update_date,
722: last_updated_by)
723: values (c_upg_id(i), 'BANK', 'N', 260, p_msg_name,
724: sysdate, NVL(FND_GLOBAL.user_id,-1),
725: sysdate, NVL(FND_GLOBAL.user_id,-1));
726: end if;
727: END LOOP;
728: end loop;

Line 725: sysdate, NVL(FND_GLOBAL.user_id,-1));

721: message_name, creation_date, created_by, last_update_date,
722: last_updated_by)
723: values (c_upg_id(i), 'BANK', 'N', 260, p_msg_name,
724: sysdate, NVL(FND_GLOBAL.user_id,-1),
725: sysdate, NVL(FND_GLOBAL.user_id,-1));
726: end if;
727: END LOOP;
728: end loop;
729:

Line 736: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

732: forall i in c_upg_id.first..c_upg_id.last
733: update ce_upg_bank_rec
734: set upgrade_status = c_status(i),
735: last_update_date = sysdate,
736: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
737: where ce_upgrade_id = c_upg_id(i)
738: and c_status(i) = 'INVALID';
739:
740: c := '30';

Line 751: last_updated_by = nvl(FND_GLOBAL.user_id,-1);

747: begin
748: update ce_bank_upgrade_modes
749: set bank_upgrade_mode = 'GROUPED',
750: last_update_date = sysdate,
751: last_updated_by = nvl(FND_GLOBAL.user_id,-1);
752:
753: exception
754: when too_many_rows then
755: null;

Line 794: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

790: set group_id = c_upg_id(i),
791: primary_flag = 'Y',
792: secondary_flag = 'N',
793: last_update_date = sysdate,
794: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
795: where ce_upgrade_id = c_upg_id(i)
796: and bank_or_branch_number is not null
797: and not exists
798: (select null from ce_upg_bank_rec b, ce_upg_bank_rec bb2

Line 846: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

842: and rownum = 1)),
843: primary_flag = 'N',
844: secondary_flag = 'Y',
845: last_update_date = sysdate,
846: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
847: where bank_or_branch_number = c_bank_or_branch_number(i)
848: and bank_or_branch_number is not null
849: and ce_upgrade_id = c_upg_id(i)
850: and bank_entity_type = p_bank_entity_type

Line 925: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

921: and rownum = 1)),
922: primary_flag = 'N',
923: secondary_flag = 'N',
924: last_update_date = sysdate,
925: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
926: where bank_or_branch_number = c_bank_or_branch_number(i)
927: and bank_or_branch_number is not null
928: and ce_upgrade_id = c_upg_id(i)
929: and group_id is null;

Line 940: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

936: set group_id = c_upg_id(i),
937: primary_flag = 'Y',
938: secondary_flag = 'N',
939: last_update_date = sysdate,
940: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
941: where bank_or_branch_number is null
942: and ce_upgrade_id = c_upg_id(i)
943: and not exists
944: (select null

Line 973: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

969: and rownum = 1),
970: primary_flag = 'N',
971: secondary_flag = 'Y',
972: last_update_date = sysdate,
973: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
974: where bank_or_branch_number is null
975: and ce_upgrade_id = c_upg_id(i)
976: and group_id is null
977: and organization_name = c_org_name(i)

Line 1016: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1012: and rownum = 1),
1013: primary_flag = 'N',
1014: secondary_flag = 'N',
1015: last_update_date = sysdate,
1016: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1017: where bank_or_branch_number is null
1018: and organization_name = c_org_name(i)
1019: and ce_upgrade_id = c_upg_id(i)
1020: and group_id is null;

Line 1059: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1055: forall i in c_group_id.first..c_group_id.last
1056: update ce_upg_bank_rec
1057: set known_as = nvl(c_known_as(i), known_as),
1058: last_update_date = sysdate,
1059: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1060: where ce_upgrade_id = c_group_id(i);
1061:
1062: forall i in c_group_id.first..c_group_id.last
1063: insert into ce_upg_cont_point_rec

Line 1337: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1333: update ce_upg_bank_rec bb
1334: set organization_name =
1335: organization_name || ' ' || bank_or_branch_number,
1336: last_update_date = sysdate,
1337: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1338: where ce_upgrade_id = c_upg_id(i)
1339: and exists
1340: (select null from ce_upg_bank_rec b, ce_upg_bank_rec bb2
1341: where b.ce_upgrade_id = bb2.parent_upgrade_id

Line 1408: sysdate, NVL(FND_GLOBAL.user_id,-1),

1404: (ce_upgrade_id, bank_entity_type, key_error_flag, application_id,
1405: message_name, creation_date, created_by, last_update_date,
1406: last_updated_by)
1407: values (c_upg_id(i), 'BRANCH', 'N', 260, p_msg_name,
1408: sysdate, NVL(FND_GLOBAL.user_id,-1),
1409: sysdate, NVL(FND_GLOBAL.user_id,-1));
1410: end if;
1411: END LOOP;
1412: end loop;

Line 1409: sysdate, NVL(FND_GLOBAL.user_id,-1));

1405: message_name, creation_date, created_by, last_update_date,
1406: last_updated_by)
1407: values (c_upg_id(i), 'BRANCH', 'N', 260, p_msg_name,
1408: sysdate, NVL(FND_GLOBAL.user_id,-1),
1409: sysdate, NVL(FND_GLOBAL.user_id,-1));
1410: end if;
1411: END LOOP;
1412: end loop;
1413:

Line 1420: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1416: forall i in c_upg_id.first..c_upg_id.last
1417: update ce_upg_bank_rec
1418: set upgrade_status = c_status(i),
1419: last_update_date = sysdate,
1420: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1421: where ce_upgrade_id = c_upg_id(i)
1422: and c_status(i) = 'INVALID';
1423:
1424: c := '78';

Line 1435: last_updated_by = nvl(FND_GLOBAL.user_id,-1);

1431: begin
1432: update ce_bank_upgrade_modes
1433: set branch_upgrade_mode = 'GROUPED',
1434: last_update_date = sysdate,
1435: last_updated_by = nvl(FND_GLOBAL.user_id,-1);
1436:
1437: exception
1438: when too_many_rows then
1439: null;

Line 1480: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1476: set group_id = c_upg_id(i),
1477: primary_acct_flag = 'Y',
1478: secondary_acct_flag = 'N',
1479: last_update_date = sysdate,
1480: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1481: where ce_upgrade_id = c_upg_id(i)
1482: and not exists
1483: (select null from ce_upg_bank_rec bb, ce_upg_bank_accounts ba2
1484: where bb.ce_upgrade_id = ba2.parent_upgrade_id

Line 1515: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1511: and rownum = 1),
1512: primary_acct_flag = 'N',
1513: secondary_acct_flag = 'Y',
1514: last_update_date = sysdate,
1515: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1516: where ce_upgrade_id = c_upg_id(i)
1517: and group_id is null
1518: and not exists
1519: (select null

Line 1563: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1559: and rownum = 1),
1560: primary_acct_flag = 'N',
1561: secondary_acct_flag = 'N',
1562: last_update_date = sysdate,
1563: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1564: where ce_upgrade_id = c_upg_id(i)
1565: and group_id is null;
1566:
1567: c := '108';

Line 1630: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1626: pay_percent_tolerance = decode(c_app_id(i), 801, c_pay_percent(i)),
1627: cashflow_display_order = decode(c_app_id(i), 185,c_cashflow_order(i)),
1628: target_balance = decode(c_app_id(i), 185, c_target_balance(i)),
1629: last_update_date = sysdate,
1630: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1631: where ce_upgrade_id = c_group_id(i);
1632:
1633: end if;
1634:

Line 1721: sysdate, NVL(FND_GLOBAL.user_id,-1),

1717: (ce_upgrade_id, bank_entity_type, key_error_flag, application_id,
1718: message_name, creation_date, created_by, last_update_date,
1719: last_updated_by)
1720: values (c_upg_id(i), 'ACCOUNT', 'N', 260, p_msg_name,
1721: sysdate, NVL(FND_GLOBAL.user_id,-1),
1722: sysdate, NVL(FND_GLOBAL.user_id,-1));
1723: end if;
1724: END LOOP;
1725: end loop;

Line 1722: sysdate, NVL(FND_GLOBAL.user_id,-1));

1718: message_name, creation_date, created_by, last_update_date,
1719: last_updated_by)
1720: values (c_upg_id(i), 'ACCOUNT', 'N', 260, p_msg_name,
1721: sysdate, NVL(FND_GLOBAL.user_id,-1),
1722: sysdate, NVL(FND_GLOBAL.user_id,-1));
1723: end if;
1724: END LOOP;
1725: end loop;
1726:

Line 1733: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1729: forall i in c_upg_id.first..c_upg_id.last
1730: update ce_upg_bank_accounts
1731: set upgrade_status = c_status(i),
1732: last_update_date = sysdate,
1733: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1734: where ce_upgrade_id = c_upg_id(i)
1735: and c_status(i) = 'INVALID';
1736:
1737: c := '123';

Line 1772: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1768: set group_id = c_upg_id(i),
1769: primary_acct_use_flag = 'Y',
1770: secondary_acct_use_flag = 'N',
1771: last_update_date = sysdate,
1772: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1773: where ce_upgrade_id = c_upg_id(i)
1774: and not exists
1775: (select null
1776: from ce_upg_bank_accounts ba, ce_upg_ba_uses_all bau2

Line 1798: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1794: and bau2.primary_acct_use_flag = 'Y'),
1795: primary_acct_use_flag = 'N',
1796: secondary_acct_use_flag = 'Y',
1797: last_update_date = sysdate,
1798: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1799: where ce_upgrade_id = c_upg_id(i)
1800: and group_id is null
1801: and source_application_id = 801
1802: and not exists

Line 1835: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1831: and rownum = 1),
1832: primary_acct_use_flag = 'N',
1833: secondary_acct_use_flag = 'N',
1834: last_update_date = sysdate,
1835: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1836: where ce_upgrade_id = c_upg_id(i)
1837: and group_id is null;
1838:
1839: c := '130';

Line 1846: last_updated_by = nvl(FND_GLOBAL.user_id,-1)

1842: update ce_upg_ba_uses_all bau
1843: set pay_use_enable_flag = c_pay_flag(i),
1844: payroll_bank_account_id = c_pay_ba_id(i),
1845: last_update_date = sysdate,
1846: last_updated_by = nvl(FND_GLOBAL.user_id,-1)
1847: where source_application_id = 200
1848: and primary_acct_use_flag = 'Y'
1849: and exists
1850: (select null

Line 1884: last_updated_by = nvl(FND_GLOBAL.user_id,-1);

1880: begin
1881: update ce_bank_upgrade_modes
1882: set account_upgrade_mode = 'GROUPED',
1883: last_update_date = sysdate,
1884: last_updated_by = nvl(FND_GLOBAL.user_id,-1);
1885:
1886: exception
1887: when too_many_rows then
1888: null;