DBA Data[Home] [Help]

APPS.BEN_DM_DATA_UTIL dependencies on BEN_DM_TABLE_ORDER

Line 1441: from ben_dm_table_order

1437: l_table_id number ;
1438:
1439: cursor c2 is
1440: select table_order_id
1441: from ben_dm_table_order
1442: where table_id = l_table_id
1443: -- and table_order = p_Table_order
1444: ;
1445: l_table_order_id number ;

Line 1467: update ben_dm_table_order

1463: fetch c2 into l_table_order_id ;
1464: if c2%found then
1465:
1466: hr_utility.set_location(' Insert :'||p_table_name, 10);
1467: update ben_dm_table_order
1468: set table_order = p_table_order
1469: ,last_update_date = sysdate
1470: ,last_updated_by = fnd_global.user_id
1471: ,last_update_login = fnd_global.login_id

Line 1476: insert into ben_dm_table_order

1472: where table_order_id = l_table_order_id
1473: ;
1474: else
1475: hr_utility.set_location(' Update :'||p_table_name, 10);
1476: insert into ben_dm_table_order
1477: (table_order_id
1478: ,table_id
1479: ,table_order
1480: ,last_update_date

Line 1486: (ben_dm_table_order_s.nextval

1482: ,last_update_login
1483: ,created_by
1484: ,creation_date
1485: ) Values
1486: (ben_dm_table_order_s.nextval
1487: ,l_table_id
1488: ,p_table_order
1489: ,sysdate
1490: ,fnd_global.user_id