APPS.PO_VALIDATION_HELPER dependencies on PO_TBL_DATE

Line 560: , p_date_tbl IN PO_TBL_DATE

556: --End of Comments
557: -------------------------------------------------------------------------------
558: PROCEDURE open_period(
559: p_calling_module IN VARCHAR2
560: , p_date_tbl IN PO_TBL_DATE
561: , p_org_id_tbl IN PO_TBL_NUMBER
562: , p_entity_id_tbl IN PO_TBL_NUMBER
563: , p_entity_type IN VARCHAR2
564: , p_column_name IN VARCHAR2

Line 1208: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL

1204: -------------------------------------------------------------------------------
1205: PROCEDURE no_timecards_exist(
1206: p_calling_module IN VARCHAR2
1207: , p_line_id_tbl IN PO_TBL_NUMBER
1208: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
1209: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
1210: , p_column_name IN VARCHAR2
1211: , p_message_name IN VARCHAR2
1212: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1209: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL

1205: PROCEDURE no_timecards_exist(
1206: p_calling_module IN VARCHAR2
1207: , p_line_id_tbl IN PO_TBL_NUMBER
1208: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
1209: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
1210: , p_column_name IN VARCHAR2
1211: , p_message_name IN VARCHAR2
1212: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1213: , x_result_type OUT NOCOPY VARCHAR2

Line 1224: l_start_date_tbl PO_TBL_DATE;

1220:
1221: l_ignore_start_date_flag VARCHAR2(1);
1222: l_ignore_expiration_date_flag VARCHAR2(1);
1223:
1224: l_start_date_tbl PO_TBL_DATE;
1225: l_expiration_date_tbl PO_TBL_DATE;
1226:
1227: l_data_key NUMBER;
1228: l_line_id_tbl PO_TBL_NUMBER;

Line 1225: l_expiration_date_tbl PO_TBL_DATE;

1221: l_ignore_start_date_flag VARCHAR2(1);
1222: l_ignore_expiration_date_flag VARCHAR2(1);
1223:
1224: l_start_date_tbl PO_TBL_DATE;
1225: l_expiration_date_tbl PO_TBL_DATE;
1226:
1227: l_data_key NUMBER;
1228: l_line_id_tbl PO_TBL_NUMBER;
1229: l_end_date_tbl PO_TBL_DATE;

Line 1229: l_end_date_tbl PO_TBL_DATE;

1225: l_expiration_date_tbl PO_TBL_DATE;
1226:
1227: l_data_key NUMBER;
1228: l_line_id_tbl PO_TBL_NUMBER;
1229: l_end_date_tbl PO_TBL_DATE;
1230:
1231: l_timecard_exists BOOLEAN;
1232: l_return_status VARCHAR2(10);
1233:

Line 1256: l_start_date_tbl := PO_TBL_DATE();

1252: l_input_count := p_line_id_tbl.COUNT;
1253:
1254: IF (p_start_date_tbl IS NULL) THEN
1255: l_ignore_start_date_flag := 'Y';
1256: l_start_date_tbl := PO_TBL_DATE();
1257: l_start_date_tbl.extend(l_input_count);
1258: ELSE
1259: l_ignore_start_date_flag := 'N';
1260: l_start_date_tbl := p_start_date_tbl;

Line 1265: l_expiration_date_tbl := PO_TBL_DATE();

1261: END IF;
1262:
1263: IF (p_expiration_date_tbl IS NULL) THEN
1264: l_ignore_expiration_date_flag := 'Y';
1265: l_expiration_date_tbl := PO_TBL_DATE();
1266: l_expiration_date_tbl.extend(l_input_count);
1267: ELSE
1268: l_ignore_expiration_date_flag := 'N';
1269: l_expiration_date_tbl := p_expiration_date_tbl;

Line 1977: , p_start_date_tbl IN PO_TBL_DATE

1973: -- NULL - null
1974: -------------------------------------------------------------------
1975: PROCEDURE start_date_le_end_date(
1976: p_calling_module IN VARCHAR2
1977: , p_start_date_tbl IN PO_TBL_DATE
1978: , p_end_date_tbl IN PO_TBL_DATE
1979: , p_entity_id_tbl IN PO_TBL_NUMBER
1980: , p_entity_type IN VARCHAR2
1981: , p_column_name IN VARCHAR2

Line 1978: , p_end_date_tbl IN PO_TBL_DATE

1974: -------------------------------------------------------------------
1975: PROCEDURE start_date_le_end_date(
1976: p_calling_module IN VARCHAR2
1977: , p_start_date_tbl IN PO_TBL_DATE
1978: , p_end_date_tbl IN PO_TBL_DATE
1979: , p_entity_id_tbl IN PO_TBL_NUMBER
1980: , p_entity_type IN VARCHAR2
1981: , p_column_name IN VARCHAR2
1982: , p_column_val_selector IN VARCHAR2