APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on FND_GLOBAL

Line 1234: 'FND_GLOBAL.user_id, ';

1230: 'location_id )';
1231: l_store_insert_sql := l_store_insert_sql ||
1232: ' SELECT OZF_TP_TERRUSG_MAP_S.nextval, '||
1233: 'SYSDATE, '||
1234: 'FND_GLOBAL.user_id, ';
1235: l_store_insert_sql := l_store_insert_sql ||
1236: 'SYSDATE, '||
1237: 'FND_GLOBAL.user_id, '||
1238: 'FND_GLOBAL.conc_login_id, ';

Line 1237: 'FND_GLOBAL.user_id, '||

1233: 'SYSDATE, '||
1234: 'FND_GLOBAL.user_id, ';
1235: l_store_insert_sql := l_store_insert_sql ||
1236: 'SYSDATE, '||
1237: 'FND_GLOBAL.user_id, '||
1238: 'FND_GLOBAL.conc_login_id, ';
1239: l_store_insert_sql := l_store_insert_sql ||
1240: 'party_id, '||
1241: 'SYSDATE, '||

Line 1238: 'FND_GLOBAL.conc_login_id, ';

1234: 'FND_GLOBAL.user_id, ';
1235: l_store_insert_sql := l_store_insert_sql ||
1236: 'SYSDATE, '||
1237: 'FND_GLOBAL.user_id, '||
1238: 'FND_GLOBAL.conc_login_id, ';
1239: l_store_insert_sql := l_store_insert_sql ||
1240: 'party_id, '||
1241: 'SYSDATE, '||
1242: 'NULL, ';

Line 1391: 'FND_GLOBAL.user_id, ';

1387: 'site_use_code )';
1388: l_final_sql := l_final_sql ||
1389: ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, '||
1390: 'SYSDATE, '||
1391: 'FND_GLOBAL.user_id, ';
1392: l_final_sql := l_final_sql ||
1393: 'SYSDATE, '||
1394: 'FND_GLOBAL.user_id, '||
1395: 'FND_GLOBAL.conc_login_id, '||

Line 1394: 'FND_GLOBAL.user_id, '||

1390: 'SYSDATE, '||
1391: 'FND_GLOBAL.user_id, ';
1392: l_final_sql := l_final_sql ||
1393: 'SYSDATE, '||
1394: 'FND_GLOBAL.user_id, '||
1395: 'FND_GLOBAL.conc_login_id, '||
1396: '1, '||
1397: '0, ';
1398: l_final_sql := l_final_sql ||

Line 1395: 'FND_GLOBAL.conc_login_id, '||

1391: 'FND_GLOBAL.user_id, ';
1392: l_final_sql := l_final_sql ||
1393: 'SYSDATE, '||
1394: 'FND_GLOBAL.user_id, '||
1395: 'FND_GLOBAL.conc_login_id, '||
1396: '1, '||
1397: '0, ';
1398: l_final_sql := l_final_sql ||
1399: ' ''N'', '||

Line 1485: FND_GLOBAL.user_id,

1481: )
1482: select
1483: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL,
1484: SYSDATE,
1485: FND_GLOBAL.user_id,
1486: SYSDATE,
1487: FND_GLOBAL.user_id,
1488: FND_GLOBAL.conc_login_id,
1489: 0,

Line 1487: FND_GLOBAL.user_id,

1483: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL,
1484: SYSDATE,
1485: FND_GLOBAL.user_id,
1486: SYSDATE,
1487: FND_GLOBAL.user_id,
1488: FND_GLOBAL.conc_login_id,
1489: 0,
1490: 'N',
1491: PARTY_ID,

Line 1488: FND_GLOBAL.conc_login_id,

1484: SYSDATE,
1485: FND_GLOBAL.user_id,
1486: SYSDATE,
1487: FND_GLOBAL.user_id,
1488: FND_GLOBAL.conc_login_id,
1489: 0,
1490: 'N',
1491: PARTY_ID,
1492: START_DATE_ACTIVE,

Line 1555: , FND_GLOBAL.user_id

1551: VALUES
1552: (
1553: l_party_mkt_seg_id
1554: , SYSDATE
1555: , FND_GLOBAL.user_id
1556: , SYSDATE
1557: , FND_GLOBAL.user_id
1558: , FND_GLOBAL.conc_login_id
1559: , 1

Line 1557: , FND_GLOBAL.user_id

1553: l_party_mkt_seg_id
1554: , SYSDATE
1555: , FND_GLOBAL.user_id
1556: , SYSDATE
1557: , FND_GLOBAL.user_id
1558: , FND_GLOBAL.conc_login_id
1559: , 1
1560: , 0
1561: , 'N'

Line 1558: , FND_GLOBAL.conc_login_id

1554: , SYSDATE
1555: , FND_GLOBAL.user_id
1556: , SYSDATE
1557: , FND_GLOBAL.user_id
1558: , FND_GLOBAL.conc_login_id
1559: , 1
1560: , 0
1561: , 'N'
1562: , l_party_id

Line 1718: , FND_GLOBAL.user_id

1714: VALUES
1715: (
1716: l_index
1717: , SYSDATE
1718: , FND_GLOBAL.user_id
1719: , SYSDATE
1720: , FND_GLOBAL.user_id
1721: , FND_GLOBAL.conc_login_id
1722: , 1

Line 1720: , FND_GLOBAL.user_id

1716: l_index
1717: , SYSDATE
1718: , FND_GLOBAL.user_id
1719: , SYSDATE
1720: , FND_GLOBAL.user_id
1721: , FND_GLOBAL.conc_login_id
1722: , 1
1723: , 0
1724: , 'N'

Line 1721: , FND_GLOBAL.conc_login_id

1717: , SYSDATE
1718: , FND_GLOBAL.user_id
1719: , SYSDATE
1720: , FND_GLOBAL.user_id
1721: , FND_GLOBAL.conc_login_id
1722: , 1
1723: , 0
1724: , 'N'
1725: , p_bg_id

Line 1794: , FND_GLOBAL.user_id

1790: VALUES
1791: (
1792: l_party_mkt_seg_id(I)
1793: , SYSDATE
1794: , FND_GLOBAL.user_id
1795: , SYSDATE
1796: , FND_GLOBAL.user_id
1797: , FND_GLOBAL.conc_login_id
1798: , 1

Line 1796: , FND_GLOBAL.user_id

1792: l_party_mkt_seg_id(I)
1793: , SYSDATE
1794: , FND_GLOBAL.user_id
1795: , SYSDATE
1796: , FND_GLOBAL.user_id
1797: , FND_GLOBAL.conc_login_id
1798: , 1
1799: , 0
1800: , 'N'

Line 1797: , FND_GLOBAL.conc_login_id

1793: , SYSDATE
1794: , FND_GLOBAL.user_id
1795: , SYSDATE
1796: , FND_GLOBAL.user_id
1797: , FND_GLOBAL.conc_login_id
1798: , 1
1799: , 0
1800: , 'N'
1801: , l_all_obj_list(I)

Line 1839: , FND_GLOBAL.user_id

1835: VALUES
1836: (
1837: l_party_mkt_seg_id(I)
1838: , SYSDATE
1839: , FND_GLOBAL.user_id
1840: , SYSDATE
1841: , FND_GLOBAL.user_id
1842: , FND_GLOBAL.conc_login_id
1843: , 1

Line 1841: , FND_GLOBAL.user_id

1837: l_party_mkt_seg_id(I)
1838: , SYSDATE
1839: , FND_GLOBAL.user_id
1840: , SYSDATE
1841: , FND_GLOBAL.user_id
1842: , FND_GLOBAL.conc_login_id
1843: , 1
1844: , 0
1845: , 'N'

Line 1842: , FND_GLOBAL.conc_login_id

1838: , SYSDATE
1839: , FND_GLOBAL.user_id
1840: , SYSDATE
1841: , FND_GLOBAL.user_id
1842: , FND_GLOBAL.conc_login_id
1843: , 1
1844: , 0
1845: , 'N'
1846: , p_bg_id