APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on FND_GLOBAL

Line 1241: 'FND_GLOBAL.user_id, ';

1237: 'location_id )';
1238: l_store_insert_sql := l_store_insert_sql ||
1239: ' SELECT OZF_TP_TERRUSG_MAP_S.nextval, '||
1240: 'SYSDATE, '||
1241: 'FND_GLOBAL.user_id, ';
1242: l_store_insert_sql := l_store_insert_sql ||
1243: 'SYSDATE, '||
1244: 'FND_GLOBAL.user_id, '||
1245: 'FND_GLOBAL.conc_login_id, ';

Line 1244: 'FND_GLOBAL.user_id, '||

1240: 'SYSDATE, '||
1241: 'FND_GLOBAL.user_id, ';
1242: l_store_insert_sql := l_store_insert_sql ||
1243: 'SYSDATE, '||
1244: 'FND_GLOBAL.user_id, '||
1245: 'FND_GLOBAL.conc_login_id, ';
1246: l_store_insert_sql := l_store_insert_sql ||
1247: 'party_id, '||
1248: 'SYSDATE, '||

Line 1245: 'FND_GLOBAL.conc_login_id, ';

1241: 'FND_GLOBAL.user_id, ';
1242: l_store_insert_sql := l_store_insert_sql ||
1243: 'SYSDATE, '||
1244: 'FND_GLOBAL.user_id, '||
1245: 'FND_GLOBAL.conc_login_id, ';
1246: l_store_insert_sql := l_store_insert_sql ||
1247: 'party_id, '||
1248: 'SYSDATE, '||
1249: 'NULL, ';

Line 1404: 'FND_GLOBAL.user_id, ';

1400: 'site_use_code )';
1401: l_final_sql := l_final_sql ||
1402: ' SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL, '||
1403: 'SYSDATE, '||
1404: 'FND_GLOBAL.user_id, ';
1405: l_final_sql := l_final_sql ||
1406: 'SYSDATE, '||
1407: 'FND_GLOBAL.user_id, '||
1408: 'FND_GLOBAL.conc_login_id, '||

Line 1407: 'FND_GLOBAL.user_id, '||

1403: 'SYSDATE, '||
1404: 'FND_GLOBAL.user_id, ';
1405: l_final_sql := l_final_sql ||
1406: 'SYSDATE, '||
1407: 'FND_GLOBAL.user_id, '||
1408: 'FND_GLOBAL.conc_login_id, '||
1409: '1, '||
1410: '0, ';
1411: l_final_sql := l_final_sql ||

Line 1408: 'FND_GLOBAL.conc_login_id, '||

1404: 'FND_GLOBAL.user_id, ';
1405: l_final_sql := l_final_sql ||
1406: 'SYSDATE, '||
1407: 'FND_GLOBAL.user_id, '||
1408: 'FND_GLOBAL.conc_login_id, '||
1409: '1, '||
1410: '0, ';
1411: l_final_sql := l_final_sql ||
1412: ' ''N'', '||

Line 1498: FND_GLOBAL.user_id,

1494: )
1495: select
1496: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL,
1497: SYSDATE,
1498: FND_GLOBAL.user_id,
1499: SYSDATE,
1500: FND_GLOBAL.user_id,
1501: FND_GLOBAL.conc_login_id,
1502: 0,

Line 1500: FND_GLOBAL.user_id,

1496: AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL,
1497: SYSDATE,
1498: FND_GLOBAL.user_id,
1499: SYSDATE,
1500: FND_GLOBAL.user_id,
1501: FND_GLOBAL.conc_login_id,
1502: 0,
1503: 'N',
1504: PARTY_ID,

Line 1501: FND_GLOBAL.conc_login_id,

1497: SYSDATE,
1498: FND_GLOBAL.user_id,
1499: SYSDATE,
1500: FND_GLOBAL.user_id,
1501: FND_GLOBAL.conc_login_id,
1502: 0,
1503: 'N',
1504: PARTY_ID,
1505: START_DATE_ACTIVE,

Line 1568: , FND_GLOBAL.user_id

1564: VALUES
1565: (
1566: l_party_mkt_seg_id
1567: , SYSDATE
1568: , FND_GLOBAL.user_id
1569: , SYSDATE
1570: , FND_GLOBAL.user_id
1571: , FND_GLOBAL.conc_login_id
1572: , 1

Line 1570: , FND_GLOBAL.user_id

1566: l_party_mkt_seg_id
1567: , SYSDATE
1568: , FND_GLOBAL.user_id
1569: , SYSDATE
1570: , FND_GLOBAL.user_id
1571: , FND_GLOBAL.conc_login_id
1572: , 1
1573: , 0
1574: , 'N'

Line 1571: , FND_GLOBAL.conc_login_id

1567: , SYSDATE
1568: , FND_GLOBAL.user_id
1569: , SYSDATE
1570: , FND_GLOBAL.user_id
1571: , FND_GLOBAL.conc_login_id
1572: , 1
1573: , 0
1574: , 'N'
1575: , l_party_id

Line 1731: , FND_GLOBAL.user_id

1727: VALUES
1728: (
1729: l_index
1730: , SYSDATE
1731: , FND_GLOBAL.user_id
1732: , SYSDATE
1733: , FND_GLOBAL.user_id
1734: , FND_GLOBAL.conc_login_id
1735: , 1

Line 1733: , FND_GLOBAL.user_id

1729: l_index
1730: , SYSDATE
1731: , FND_GLOBAL.user_id
1732: , SYSDATE
1733: , FND_GLOBAL.user_id
1734: , FND_GLOBAL.conc_login_id
1735: , 1
1736: , 0
1737: , 'N'

Line 1734: , FND_GLOBAL.conc_login_id

1730: , SYSDATE
1731: , FND_GLOBAL.user_id
1732: , SYSDATE
1733: , FND_GLOBAL.user_id
1734: , FND_GLOBAL.conc_login_id
1735: , 1
1736: , 0
1737: , 'N'
1738: , p_bg_id

Line 1807: , FND_GLOBAL.user_id

1803: VALUES
1804: (
1805: l_party_mkt_seg_id(I)
1806: , SYSDATE
1807: , FND_GLOBAL.user_id
1808: , SYSDATE
1809: , FND_GLOBAL.user_id
1810: , FND_GLOBAL.conc_login_id
1811: , 1

Line 1809: , FND_GLOBAL.user_id

1805: l_party_mkt_seg_id(I)
1806: , SYSDATE
1807: , FND_GLOBAL.user_id
1808: , SYSDATE
1809: , FND_GLOBAL.user_id
1810: , FND_GLOBAL.conc_login_id
1811: , 1
1812: , 0
1813: , 'N'

Line 1810: , FND_GLOBAL.conc_login_id

1806: , SYSDATE
1807: , FND_GLOBAL.user_id
1808: , SYSDATE
1809: , FND_GLOBAL.user_id
1810: , FND_GLOBAL.conc_login_id
1811: , 1
1812: , 0
1813: , 'N'
1814: , l_all_obj_list(I)

Line 1852: , FND_GLOBAL.user_id

1848: VALUES
1849: (
1850: l_party_mkt_seg_id(I)
1851: , SYSDATE
1852: , FND_GLOBAL.user_id
1853: , SYSDATE
1854: , FND_GLOBAL.user_id
1855: , FND_GLOBAL.conc_login_id
1856: , 1

Line 1854: , FND_GLOBAL.user_id

1850: l_party_mkt_seg_id(I)
1851: , SYSDATE
1852: , FND_GLOBAL.user_id
1853: , SYSDATE
1854: , FND_GLOBAL.user_id
1855: , FND_GLOBAL.conc_login_id
1856: , 1
1857: , 0
1858: , 'N'

Line 1855: , FND_GLOBAL.conc_login_id

1851: , SYSDATE
1852: , FND_GLOBAL.user_id
1853: , SYSDATE
1854: , FND_GLOBAL.user_id
1855: , FND_GLOBAL.conc_login_id
1856: , 1
1857: , 0
1858: , 'N'
1859: , p_bg_id