DBA Data[Home] [Help]

APPS.PO_VAL_LINES dependencies on PO_TBL_DATE

Line 1067: , p_start_date_tbl IN PO_TBL_DATE

1063: -- Shows error 'PO_SVC_ASSIGNMENT_DATES'.
1064: ------------------------------------------------------------------------
1065: PROCEDURE start_date_le_end_date(
1066: p_line_id_tbl IN PO_TBL_NUMBER
1067: , p_start_date_tbl IN PO_TBL_DATE
1068: , p_expiration_date_tbl IN PO_TBL_DATE
1069: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1070: , x_result_type OUT NOCOPY VARCHAR2
1071: )

Line 1068: , p_expiration_date_tbl IN PO_TBL_DATE

1064: ------------------------------------------------------------------------
1065: PROCEDURE start_date_le_end_date(
1066: p_line_id_tbl IN PO_TBL_NUMBER
1067: , p_start_date_tbl IN PO_TBL_DATE
1068: , p_expiration_date_tbl IN PO_TBL_DATE
1069: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1070: , x_result_type OUT NOCOPY VARCHAR2
1071: )
1072: IS

Line 1102: , p_start_date_tbl IN PO_TBL_DATE

1098: --
1099: ------------------------------------------------------------------------
1100: PROCEDURE otl_invalid_start_date_change(
1101: p_line_id_tbl IN PO_TBL_NUMBER
1102: , p_start_date_tbl IN PO_TBL_DATE
1103: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1104: , x_result_type OUT NOCOPY VARCHAR2
1105: )
1106: IS

Line 1135: , p_expiration_date_tbl IN PO_TBL_DATE

1131: --
1132: ------------------------------------------------------------------------
1133: PROCEDURE otl_invalid_end_date_change(
1134: p_line_id_tbl IN PO_TBL_NUMBER
1135: , p_expiration_date_tbl IN PO_TBL_DATE
1136: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1137: , x_result_type OUT NOCOPY VARCHAR2
1138: )
1139: IS

Line 1388: , p_blanket_start_date_tbl IN PO_TBL_DATE

1384: -- Agreements only.
1385: -----------------------------------------------------------------------------
1386: PROCEDURE expiration_ge_blanket_start(
1387: p_line_id_tbl IN PO_TBL_NUMBER
1388: , p_blanket_start_date_tbl IN PO_TBL_DATE
1389: , p_expiration_date_tbl IN PO_TBL_DATE
1390: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1391: , x_result_type OUT NOCOPY VARCHAR2
1392: )

Line 1389: , p_expiration_date_tbl IN PO_TBL_DATE

1385: -----------------------------------------------------------------------------
1386: PROCEDURE expiration_ge_blanket_start(
1387: p_line_id_tbl IN PO_TBL_NUMBER
1388: , p_blanket_start_date_tbl IN PO_TBL_DATE
1389: , p_expiration_date_tbl IN PO_TBL_DATE
1390: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1391: , x_result_type OUT NOCOPY VARCHAR2
1392: )
1393: IS

Line 1420: , p_blanket_end_date_tbl IN PO_TBL_DATE

1416: -- Agreements only.
1417: -----------------------------------------------------------------------------
1418: PROCEDURE expiration_le_blanket_end(
1419: p_line_id_tbl IN PO_TBL_NUMBER
1420: , p_blanket_end_date_tbl IN PO_TBL_DATE
1421: , p_expiration_date_tbl IN PO_TBL_DATE
1422: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1423: , x_result_type OUT NOCOPY VARCHAR2
1424: )

Line 1421: , p_expiration_date_tbl IN PO_TBL_DATE

1417: -----------------------------------------------------------------------------
1418: PROCEDURE expiration_le_blanket_end(
1419: p_line_id_tbl IN PO_TBL_NUMBER
1420: , p_blanket_end_date_tbl IN PO_TBL_DATE
1421: , p_expiration_date_tbl IN PO_TBL_DATE
1422: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1423: , x_result_type OUT NOCOPY VARCHAR2
1424: )
1425: IS

Line 2083: , p_start_date_tbl IN PO_TBL_DATE

2079: -- Ensures that the Start Date is not null for TEMP LABOR lines.
2080: -------------------------------------------------------------------------------
2081: PROCEDURE temp_lbr_start_date_not_null(
2082: p_line_id_tbl IN PO_TBL_NUMBER
2083: , p_start_date_tbl IN PO_TBL_DATE
2084: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
2085: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2086: , x_result_type OUT NOCOPY VARCHAR2
2087: )