DBA Data[Home] [Help]

APPS.OKC_REPORT_PVT dependencies on OKC_K_HEADERS_TL

Line 1297: from OKC_K_HEADERS_TL

1293: l_minor_version number;
1294: l_scn_id number := NVL(p_scn_id,0);
1295: cursor k_header_csr is
1296: select '!'
1297: from OKC_K_HEADERS_TL
1298: where ID = p_chr_id
1299: and LANGUAGE = userenv('LANG')
1300: for update of last_update_date, last_updated_by
1301: nowait;

Line 1332: update OKC_K_HEADERS_TL

1328: close k_header_csr;
1329: if l_dummy = '?' then
1330: raise NO_DATA_FOUND;
1331: end if;
1332: update OKC_K_HEADERS_TL
1333: set last_updated_by = fnd_global.user_id,
1334: last_update_date = sysdate+1/144
1335: where ID = p_chr_id
1336: and LANGUAGE = userenv('LANG');

Line 1369: from OKC_K_HEADERS_TL

1365: p_chr_id in NUMBER
1366: ) is
1367: cursor k_header_csr is
1368: select '!'
1369: from OKC_K_HEADERS_TL
1370: where ID = p_chr_id
1371: and LANGUAGE = userenv('LANG')
1372: and last_updated_by = fnd_global.user_id
1373: and last_update_date > sysdate

Line 1386: -- update OKC_K_HEADERS_TL

1382: if l_dummy = '?' then
1383: raise NO_DATA_FOUND;
1384: end if;
1385: -- for test commented out, later on place back
1386: -- update OKC_K_HEADERS_TL
1387: -- set last_update_date = sysdate
1388: -- where ID = p_chr_id and LANGUAGE = userenv('LANG');
1389: commit;
1390: