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.PO_VALIDATION_HELPER dependencies on PO_TBL_DATE

Line 570: , p_date_tbl IN PO_TBL_DATE

566: --End of Comments
567: -------------------------------------------------------------------------------
568: PROCEDURE open_period(
569: p_calling_module IN VARCHAR2
570: , p_date_tbl IN PO_TBL_DATE
571: , p_org_id_tbl IN PO_TBL_NUMBER
572: , p_entity_id_tbl IN PO_TBL_NUMBER
573: , p_entity_type IN VARCHAR2
574: , p_column_name IN VARCHAR2

Line 1362: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL

1358: -------------------------------------------------------------------------------
1359: PROCEDURE no_timecards_exist(
1360: p_calling_module IN VARCHAR2
1361: , p_line_id_tbl IN PO_TBL_NUMBER
1362: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
1363: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
1364: , p_column_name IN VARCHAR2
1365: , p_message_name IN VARCHAR2
1366: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1363: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL

1359: PROCEDURE no_timecards_exist(
1360: p_calling_module IN VARCHAR2
1361: , p_line_id_tbl IN PO_TBL_NUMBER
1362: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
1363: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
1364: , p_column_name IN VARCHAR2
1365: , p_message_name IN VARCHAR2
1366: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1367: , x_result_type OUT NOCOPY VARCHAR2

Line 1378: l_start_date_tbl PO_TBL_DATE;

1374:
1375: l_ignore_start_date_flag VARCHAR2(1);
1376: l_ignore_expiration_date_flag VARCHAR2(1);
1377:
1378: l_start_date_tbl PO_TBL_DATE;
1379: l_expiration_date_tbl PO_TBL_DATE;
1380:
1381: l_data_key NUMBER;
1382: l_line_id_tbl PO_TBL_NUMBER;

Line 1379: l_expiration_date_tbl PO_TBL_DATE;

1375: l_ignore_start_date_flag VARCHAR2(1);
1376: l_ignore_expiration_date_flag VARCHAR2(1);
1377:
1378: l_start_date_tbl PO_TBL_DATE;
1379: l_expiration_date_tbl PO_TBL_DATE;
1380:
1381: l_data_key NUMBER;
1382: l_line_id_tbl PO_TBL_NUMBER;
1383: l_end_date_tbl PO_TBL_DATE;

Line 1383: l_end_date_tbl PO_TBL_DATE;

1379: l_expiration_date_tbl PO_TBL_DATE;
1380:
1381: l_data_key NUMBER;
1382: l_line_id_tbl PO_TBL_NUMBER;
1383: l_end_date_tbl PO_TBL_DATE;
1384:
1385: l_timecard_exists BOOLEAN;
1386: l_return_status VARCHAR2(10);
1387:

Line 1410: l_start_date_tbl := PO_TBL_DATE();

1406: l_input_count := p_line_id_tbl.COUNT;
1407:
1408: IF (p_start_date_tbl IS NULL) THEN
1409: l_ignore_start_date_flag := 'Y';
1410: l_start_date_tbl := PO_TBL_DATE();
1411: l_start_date_tbl.extend(l_input_count);
1412: ELSE
1413: l_ignore_start_date_flag := 'N';
1414: l_start_date_tbl := p_start_date_tbl;

Line 1419: l_expiration_date_tbl := PO_TBL_DATE();

1415: END IF;
1416:
1417: IF (p_expiration_date_tbl IS NULL) THEN
1418: l_ignore_expiration_date_flag := 'Y';
1419: l_expiration_date_tbl := PO_TBL_DATE();
1420: l_expiration_date_tbl.extend(l_input_count);
1421: ELSE
1422: l_ignore_expiration_date_flag := 'N';
1423: l_expiration_date_tbl := p_expiration_date_tbl;

Line 2162: , p_start_date_tbl IN PO_TBL_DATE

2158: -- NULL - null
2159: -------------------------------------------------------------------
2160: PROCEDURE start_date_le_end_date(
2161: p_calling_module IN VARCHAR2
2162: , p_start_date_tbl IN PO_TBL_DATE
2163: , p_end_date_tbl IN PO_TBL_DATE
2164: , p_entity_id_tbl IN PO_TBL_NUMBER
2165: , p_entity_type IN VARCHAR2
2166: , p_column_name IN VARCHAR2

Line 2163: , p_end_date_tbl IN PO_TBL_DATE

2159: -------------------------------------------------------------------
2160: PROCEDURE start_date_le_end_date(
2161: p_calling_module IN VARCHAR2
2162: , p_start_date_tbl IN PO_TBL_DATE
2163: , p_end_date_tbl IN PO_TBL_DATE
2164: , p_entity_id_tbl IN PO_TBL_NUMBER
2165: , p_entity_type IN VARCHAR2
2166: , p_column_name IN VARCHAR2
2167: , p_column_val_selector IN VARCHAR2

Line 3571: , p_start_date_tbl IN PO_TBL_DATE

3567: --------------------------------------------------------------------------------
3568:
3569: PROCEDURE start_date_ge_sys_date(
3570: p_calling_module IN VARCHAR2
3571: , p_start_date_tbl IN PO_TBL_DATE
3572: , p_entity_id_tbl IN PO_TBL_NUMBER
3573: , p_entity_type IN VARCHAR2
3574: , p_column_name IN VARCHAR2
3575: , p_message_name IN VARCHAR2