APPS.PO_VAL_LINES dependencies on PO_TBL_DATE

Line 1331: , p_start_date_tbl IN PO_TBL_DATE

1327: -- Shows error 'PO_SVC_ASSIGNMENT_DATES'.
1328: ------------------------------------------------------------------------
1329: PROCEDURE start_date_le_end_date(
1330: p_line_id_tbl IN PO_TBL_NUMBER
1331: , p_start_date_tbl IN PO_TBL_DATE
1332: , p_expiration_date_tbl IN PO_TBL_DATE
1333: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1334: , x_result_type OUT NOCOPY VARCHAR2
1335: )

Line 1332: , p_expiration_date_tbl IN PO_TBL_DATE

1328: ------------------------------------------------------------------------
1329: PROCEDURE start_date_le_end_date(
1330: p_line_id_tbl IN PO_TBL_NUMBER
1331: , p_start_date_tbl IN PO_TBL_DATE
1332: , p_expiration_date_tbl IN PO_TBL_DATE
1333: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1334: , x_result_type OUT NOCOPY VARCHAR2
1335: )
1336: IS

Line 1368: , p_start_date_tbl IN PO_TBL_DATE

1364: ------------------------------------------------------------------------
1365: PROCEDURE order_start_date_le_end_date
1366: (
1367: p_line_id_tbl IN PO_TBL_NUMBER
1368: , p_start_date_tbl IN PO_TBL_DATE
1369: , p_expiration_date_tbl IN PO_TBL_DATE
1370: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1371: , x_result_type OUT NOCOPY VARCHAR2
1372: )

Line 1369: , p_expiration_date_tbl IN PO_TBL_DATE

1365: PROCEDURE order_start_date_le_end_date
1366: (
1367: p_line_id_tbl IN PO_TBL_NUMBER
1368: , p_start_date_tbl IN PO_TBL_DATE
1369: , p_expiration_date_tbl IN PO_TBL_DATE
1370: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1371: , x_result_type OUT NOCOPY VARCHAR2
1372: )
1373: IS

Line 1433: , p_order_from_date_tbl IN PO_TBL_DATE

1429:
1430: PROCEDURE order_start_date_gt_sysdate
1431: (
1432: p_line_id_tbl IN PO_TBL_NUMBER
1433: , p_order_from_date_tbl IN PO_TBL_DATE
1434: , p_draft_id_tbl IN PO_TBL_NUMBER
1435: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1436: , x_result_type OUT NOCOPY VARCHAR2
1437: )

Line 1965: , p_start_date_tbl IN PO_TBL_DATE

1961: --
1962: ------------------------------------------------------------------------
1963: PROCEDURE otl_invalid_start_date_change(
1964: p_line_id_tbl IN PO_TBL_NUMBER
1965: , p_start_date_tbl IN PO_TBL_DATE
1966: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1967: , x_result_type OUT NOCOPY VARCHAR2
1968: )
1969: IS

Line 1998: , p_expiration_date_tbl IN PO_TBL_DATE

1994: --
1995: ------------------------------------------------------------------------
1996: PROCEDURE otl_invalid_end_date_change(
1997: p_line_id_tbl IN PO_TBL_NUMBER
1998: , p_expiration_date_tbl IN PO_TBL_DATE
1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2000: , x_result_type OUT NOCOPY VARCHAR2
2001: )
2002: IS

Line 2263: , p_blanket_start_date_tbl IN PO_TBL_DATE

2259: -- Agreements only.
2260: -----------------------------------------------------------------------------
2261: PROCEDURE expiration_ge_blanket_start(
2262: p_line_id_tbl IN PO_TBL_NUMBER
2263: , p_blanket_start_date_tbl IN PO_TBL_DATE
2264: , p_expiration_date_tbl IN PO_TBL_DATE
2265: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2266: , x_result_type OUT NOCOPY VARCHAR2
2267: )

Line 2264: , p_expiration_date_tbl IN PO_TBL_DATE

2260: -----------------------------------------------------------------------------
2261: PROCEDURE expiration_ge_blanket_start(
2262: p_line_id_tbl IN PO_TBL_NUMBER
2263: , p_blanket_start_date_tbl IN PO_TBL_DATE
2264: , p_expiration_date_tbl IN PO_TBL_DATE
2265: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2266: , x_result_type OUT NOCOPY VARCHAR2
2267: )
2268: IS

Line 2295: , p_blanket_end_date_tbl IN PO_TBL_DATE

2291: -- Agreements only.
2292: -----------------------------------------------------------------------------
2293: PROCEDURE expiration_le_blanket_end(
2294: p_line_id_tbl IN PO_TBL_NUMBER
2295: , p_blanket_end_date_tbl IN PO_TBL_DATE
2296: , p_expiration_date_tbl IN PO_TBL_DATE
2297: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2298: , x_result_type OUT NOCOPY VARCHAR2
2299: )

Line 2296: , p_expiration_date_tbl IN PO_TBL_DATE

2292: -----------------------------------------------------------------------------
2293: PROCEDURE expiration_le_blanket_end(
2294: p_line_id_tbl IN PO_TBL_NUMBER
2295: , p_blanket_end_date_tbl IN PO_TBL_DATE
2296: , p_expiration_date_tbl IN PO_TBL_DATE
2297: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2298: , x_result_type OUT NOCOPY VARCHAR2
2299: )
2300: IS

Line 3030: , p_start_date_tbl IN PO_TBL_DATE

3026: -- Ensures that the Start Date is not null for TEMP LABOR lines.
3027: -------------------------------------------------------------------------------
3028: PROCEDURE temp_lbr_start_date_not_null(
3029: p_line_id_tbl IN PO_TBL_NUMBER
3030: , p_start_date_tbl IN PO_TBL_DATE
3031: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
3032: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3033: , x_result_type OUT NOCOPY VARCHAR2
3034: )

Line 3420: , p_option_from_date_tbl IN PO_TBL_DATE

3416:
3417: PROCEDURE option_from_date_not_null (
3418: p_line_id_tbl IN PO_TBL_NUMBER
3419: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3420: , p_option_from_date_tbl IN PO_TBL_DATE
3421: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3422: , x_result_type OUT NOCOPY VARCHAR2
3423: )
3424: IS

Line 3475: ,p_option_to_Date_tbl IN PO_TBL_DATE

3471:
3472: PROCEDURE option_to_date_not_null (
3473: p_line_id_tbl IN PO_TBL_NUMBER
3474: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3475: ,p_option_to_Date_tbl IN PO_TBL_DATE
3476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3477: , x_result_type OUT NOCOPY VARCHAR2
3478: )
3479: IS

Line 3530: ,p_option_from_date_tbl IN PO_TBL_DATE

3526:
3527: PROCEDURE option_to_date_le_from_date (
3528: p_line_id_tbl IN PO_TBL_NUMBER
3529: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3530: ,p_option_from_date_tbl IN PO_TBL_DATE
3531: ,p_option_to_Date_tbl IN PO_TBL_DATE
3532: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3533: , x_result_type OUT NOCOPY VARCHAR2
3534: )

Line 3531: ,p_option_to_Date_tbl IN PO_TBL_DATE

3527: PROCEDURE option_to_date_le_from_date (
3528: p_line_id_tbl IN PO_TBL_NUMBER
3529: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3530: ,p_option_from_date_tbl IN PO_TBL_DATE
3531: ,p_option_to_Date_tbl IN PO_TBL_DATE
3532: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3533: , x_result_type OUT NOCOPY VARCHAR2
3534: )
3535: IS

Line 3591: ,p_option_from_date_tbl IN PO_TBL_DATE

3587:
3588: PROCEDURE option_from_date_le_sysdate (
3589: p_line_id_tbl IN PO_TBL_NUMBER
3590: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3591: ,p_option_from_date_tbl IN PO_TBL_DATE
3592: , p_draft_id_tbl IN PO_TBL_NUMBER
3593: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3594: , x_result_type OUT NOCOPY VARCHAR2
3595: )

Line 3675: , p_option_from_date_tbl IN PO_TBL_DATE

3671:
3672: PROCEDURE option_fm_date_le_ex_date (
3673: p_line_id_tbl IN PO_TBL_NUMBER
3674: , p_exer_flag_tbl IN PO_TBL_VARCHAR1
3675: , p_option_from_date_tbl IN PO_TBL_DATE
3676: , p_option_exer_date_tbl IN PO_TBL_DATE
3677: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3678: , x_result_type OUT NOCOPY VARCHAR2
3679: )

Line 3676: , p_option_exer_date_tbl IN PO_TBL_DATE

3672: PROCEDURE option_fm_date_le_ex_date (
3673: p_line_id_tbl IN PO_TBL_NUMBER
3674: , p_exer_flag_tbl IN PO_TBL_VARCHAR1
3675: , p_option_from_date_tbl IN PO_TBL_DATE
3676: , p_option_exer_date_tbl IN PO_TBL_DATE
3677: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3678: , x_result_type OUT NOCOPY VARCHAR2
3679: )
3680: IS