DBA Data[Home] [Help]

APPS.CSM_UTIL_PKG dependencies on FND_GLOBAL

Line 1131: || '), LAST_UPDATED_BY = fnd_global.user_id WHERE '

1127: l_upd_dsql := 'UPDATE ' || l_acc_table_name
1128: || ' SET LAST_UPDATE_DATE = (SELECT LAST_UPDATE_DATE FROM '
1129: || l_backend_table_name
1130: || ' WHERE ' || l_primary_key_column || ' = ' || l_pk_value
1131: || '), LAST_UPDATED_BY = fnd_global.user_id WHERE '
1132: || ' access_id = ' || l_access_id;
1133:
1134: --open database cursor
1135: l_cursorid := DBMS_SQL.open_cursor;

Line 1198: || '), LAST_UPDATED_BY = fnd_global.user_id WHERE '

1194: l_upd_dsql := 'UPDATE ' || l_acc_table_name
1195: || ' SET LAST_UPDATE_DATE = (SELECT LAST_UPDATE_DATE FROM '
1196: || l_tl_table_name
1197: || ' WHERE ' || l_primary_key_column || ' = ' || l_pk_value
1198: || '), LAST_UPDATED_BY = fnd_global.user_id WHERE '
1199: || ' access_id = ' || l_access_id;
1200:
1201: --open database cursor
1202: l_cursorid := DBMS_SQL.open_cursor;

Line 1278: || ', fnd_global.user_id,

1274: LAST_UPDATE_DATE,
1275: LAST_UPDATE_LOGIN)
1276: SELECT ' || l_access_id || ', b.'
1277: || l_primary_key_column
1278: || ', fnd_global.user_id,
1279: sysdate,
1280: fnd_global.user_id,
1281: NVL(b.LAST_UPDATE_DATE, sysdate),
1282: fnd_global.user_id

Line 1280: fnd_global.user_id,

1276: SELECT ' || l_access_id || ', b.'
1277: || l_primary_key_column
1278: || ', fnd_global.user_id,
1279: sysdate,
1280: fnd_global.user_id,
1281: NVL(b.LAST_UPDATE_DATE, sysdate),
1282: fnd_global.user_id
1283: FROM '
1284: || l_backend_table_name

Line 1282: fnd_global.user_id

1278: || ', fnd_global.user_id,
1279: sysdate,
1280: fnd_global.user_id,
1281: NVL(b.LAST_UPDATE_DATE, sysdate),
1282: fnd_global.user_id
1283: FROM '
1284: || l_backend_table_name
1285: || ' b '
1286: || ' WHERE '

Line 1467: l_fnd_message := l_fnd_message || FND_GLOBAL.Newline || l_msg_data;

1463: , p_encoded => FND_API.G_FALSE
1464: , p_data => l_msg_data
1465: , p_msg_index_out => l_msg_dummy
1466: );
1467: l_fnd_message := l_fnd_message || FND_GLOBAL.Newline || l_msg_data;
1468: END LOOP;
1469: END IF;
1470: END IF;
1471: