eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_INTEGRATION_LAYER_V1_GRP dependencies on HXC_TIMECARD_SUMMARY

Line 1272: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

1268: -- ----------------------------------------------------------------------------
1269: -- |-----------------< get_timecard_approval_status >------------------------|
1270: -- ----------------------------------------------------------------------------
1271: FUNCTION get_timecard_approval_status
1272: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1273: RETURN hxc_timecard_summary.approval_status%type
1274: IS
1275:
1276: l_return hxc_timecard_summary.approval_status%type;

Line 1273: RETURN hxc_timecard_summary.approval_status%type

1269: -- |-----------------< get_timecard_approval_status >------------------------|
1270: -- ----------------------------------------------------------------------------
1271: FUNCTION get_timecard_approval_status
1272: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1273: RETURN hxc_timecard_summary.approval_status%type
1274: IS
1275:
1276: l_return hxc_timecard_summary.approval_status%type;
1277:

Line 1276: l_return hxc_timecard_summary.approval_status%type;

1272: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1273: RETURN hxc_timecard_summary.approval_status%type
1274: IS
1275:
1276: l_return hxc_timecard_summary.approval_status%type;
1277:
1278: BEGIN
1279:
1280: l_return :=

Line 1292: (p_resource_id in hxc_timecard_summary.resource_id%type

1288: -- ----------------------------------------------------------------------------
1289: -- |-----------------< get_timecard_approval_status 2>------------------------|
1290: -- ----------------------------------------------------------------------------
1291: FUNCTION get_timecard_approval_status
1292: (p_resource_id in hxc_timecard_summary.resource_id%type
1293: ,p_start_time in hxc_timecard_summary.start_time%type
1294: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1295: RETURN hxc_timecard_summary.approval_status%type
1296: IS

Line 1293: ,p_start_time in hxc_timecard_summary.start_time%type

1289: -- |-----------------< get_timecard_approval_status 2>------------------------|
1290: -- ----------------------------------------------------------------------------
1291: FUNCTION get_timecard_approval_status
1292: (p_resource_id in hxc_timecard_summary.resource_id%type
1293: ,p_start_time in hxc_timecard_summary.start_time%type
1294: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1295: RETURN hxc_timecard_summary.approval_status%type
1296: IS
1297:

Line 1294: ,p_stop_time in hxc_timecard_summary.stop_time%type)

1290: -- ----------------------------------------------------------------------------
1291: FUNCTION get_timecard_approval_status
1292: (p_resource_id in hxc_timecard_summary.resource_id%type
1293: ,p_start_time in hxc_timecard_summary.start_time%type
1294: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1295: RETURN hxc_timecard_summary.approval_status%type
1296: IS
1297:
1298: l_return hxc_timecard_summary.approval_status%type;

Line 1295: RETURN hxc_timecard_summary.approval_status%type

1291: FUNCTION get_timecard_approval_status
1292: (p_resource_id in hxc_timecard_summary.resource_id%type
1293: ,p_start_time in hxc_timecard_summary.start_time%type
1294: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1295: RETURN hxc_timecard_summary.approval_status%type
1296: IS
1297:
1298: l_return hxc_timecard_summary.approval_status%type;
1299:

Line 1298: l_return hxc_timecard_summary.approval_status%type;

1294: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1295: RETURN hxc_timecard_summary.approval_status%type
1296: IS
1297:
1298: l_return hxc_timecard_summary.approval_status%type;
1299:
1300: BEGIN
1301:
1302: l_return :=

Line 1316: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

1312: -- ----------------------------------------------------------------------------
1313: -- |-----------------< get_timecard_submission_date >------------------------|
1314: -- ----------------------------------------------------------------------------
1315: FUNCTION get_timecard_submission_date
1316: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1317: RETURN hxc_timecard_summary.submission_date%type
1318: IS
1319:
1320: l_return hxc_timecard_summary.submission_date%type;

Line 1317: RETURN hxc_timecard_summary.submission_date%type

1313: -- |-----------------< get_timecard_submission_date >------------------------|
1314: -- ----------------------------------------------------------------------------
1315: FUNCTION get_timecard_submission_date
1316: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1317: RETURN hxc_timecard_summary.submission_date%type
1318: IS
1319:
1320: l_return hxc_timecard_summary.submission_date%type;
1321:

Line 1320: l_return hxc_timecard_summary.submission_date%type;

1316: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1317: RETURN hxc_timecard_summary.submission_date%type
1318: IS
1319:
1320: l_return hxc_timecard_summary.submission_date%type;
1321:
1322: BEGIN
1323:
1324: l_return :=

Line 1336: (p_resource_id in hxc_timecard_summary.resource_id%type

1332: -- ----------------------------------------------------------------------------
1333: -- |-----------------< get_timecard_submission_date 2>------------------------|
1334: -- ----------------------------------------------------------------------------
1335: FUNCTION get_timecard_submission_date
1336: (p_resource_id in hxc_timecard_summary.resource_id%type
1337: ,p_start_time in hxc_timecard_summary.start_time%type
1338: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1339: RETURN hxc_timecard_summary.submission_date%type
1340: IS

Line 1337: ,p_start_time in hxc_timecard_summary.start_time%type

1333: -- |-----------------< get_timecard_submission_date 2>------------------------|
1334: -- ----------------------------------------------------------------------------
1335: FUNCTION get_timecard_submission_date
1336: (p_resource_id in hxc_timecard_summary.resource_id%type
1337: ,p_start_time in hxc_timecard_summary.start_time%type
1338: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1339: RETURN hxc_timecard_summary.submission_date%type
1340: IS
1341:

Line 1338: ,p_stop_time in hxc_timecard_summary.stop_time%type)

1334: -- ----------------------------------------------------------------------------
1335: FUNCTION get_timecard_submission_date
1336: (p_resource_id in hxc_timecard_summary.resource_id%type
1337: ,p_start_time in hxc_timecard_summary.start_time%type
1338: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1339: RETURN hxc_timecard_summary.submission_date%type
1340: IS
1341:
1342: l_return hxc_timecard_summary.submission_date%type;

Line 1339: RETURN hxc_timecard_summary.submission_date%type

1335: FUNCTION get_timecard_submission_date
1336: (p_resource_id in hxc_timecard_summary.resource_id%type
1337: ,p_start_time in hxc_timecard_summary.start_time%type
1338: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1339: RETURN hxc_timecard_summary.submission_date%type
1340: IS
1341:
1342: l_return hxc_timecard_summary.submission_date%type;
1343:

Line 1342: l_return hxc_timecard_summary.submission_date%type;

1338: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1339: RETURN hxc_timecard_summary.submission_date%type
1340: IS
1341:
1342: l_return hxc_timecard_summary.submission_date%type;
1343:
1344: BEGIN
1345:
1346: l_return :=

Line 1361: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

1357: -- ----------------------------------------------------------------------------
1358: -- |-----------------< get_timecard_approval_date >------------------------|
1359: -- ----------------------------------------------------------------------------
1360: FUNCTION get_timecard_approval_date
1361: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1362: RETURN hxc_timecard_summary.submission_date%type
1363: IS
1364:
1365: l_return hxc_timecard_summary.submission_date%type;

Line 1362: RETURN hxc_timecard_summary.submission_date%type

1358: -- |-----------------< get_timecard_approval_date >------------------------|
1359: -- ----------------------------------------------------------------------------
1360: FUNCTION get_timecard_approval_date
1361: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1362: RETURN hxc_timecard_summary.submission_date%type
1363: IS
1364:
1365: l_return hxc_timecard_summary.submission_date%type;
1366:

Line 1365: l_return hxc_timecard_summary.submission_date%type;

1361: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
1362: RETURN hxc_timecard_summary.submission_date%type
1363: IS
1364:
1365: l_return hxc_timecard_summary.submission_date%type;
1366:
1367: BEGIN
1368:
1369: l_return :=

Line 1382: (p_resource_id in hxc_timecard_summary.resource_id%type

1378: -- |-----------------< get_timecard_approval_date 2 >------------------------|
1379: -- ----------------------------------------------------------------------------
1380:
1381: FUNCTION get_timecard_approval_date
1382: (p_resource_id in hxc_timecard_summary.resource_id%type
1383: ,p_start_time in hxc_timecard_summary.start_time%type
1384: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1385: RETURN hxc_timecard_summary.submission_date%type
1386: IS

Line 1383: ,p_start_time in hxc_timecard_summary.start_time%type

1379: -- ----------------------------------------------------------------------------
1380:
1381: FUNCTION get_timecard_approval_date
1382: (p_resource_id in hxc_timecard_summary.resource_id%type
1383: ,p_start_time in hxc_timecard_summary.start_time%type
1384: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1385: RETURN hxc_timecard_summary.submission_date%type
1386: IS
1387:

Line 1384: ,p_stop_time in hxc_timecard_summary.stop_time%type)

1380:
1381: FUNCTION get_timecard_approval_date
1382: (p_resource_id in hxc_timecard_summary.resource_id%type
1383: ,p_start_time in hxc_timecard_summary.start_time%type
1384: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1385: RETURN hxc_timecard_summary.submission_date%type
1386: IS
1387:
1388: l_return hxc_timecard_summary.submission_date%type;

Line 1385: RETURN hxc_timecard_summary.submission_date%type

1381: FUNCTION get_timecard_approval_date
1382: (p_resource_id in hxc_timecard_summary.resource_id%type
1383: ,p_start_time in hxc_timecard_summary.start_time%type
1384: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1385: RETURN hxc_timecard_summary.submission_date%type
1386: IS
1387:
1388: l_return hxc_timecard_summary.submission_date%type;
1389:

Line 1388: l_return hxc_timecard_summary.submission_date%type;

1384: ,p_stop_time in hxc_timecard_summary.stop_time%type)
1385: RETURN hxc_timecard_summary.submission_date%type
1386: IS
1387:
1388: l_return hxc_timecard_summary.submission_date%type;
1389:
1390: BEGIN
1391:
1392: l_return :=