DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_TBL_DATE

Line 257: , p_need_by_date_tbl IN PO_TBL_DATE

253: -- are both null.
254: -------------------------------------------------------------------------
255: PROCEDURE planned_item_null_date_check (
256: p_line_loc_id_tbl IN PO_TBL_NUMBER
257: , p_need_by_date_tbl IN PO_TBL_DATE
258: , p_promised_date_tbl IN PO_TBL_DATE
259: , p_item_id_tbl IN PO_TBL_NUMBER
260: , x_result_set_id IN OUT NOCOPY NUMBER
261: , x_result_type OUT NOCOPY VARCHAR2

Line 258: , p_promised_date_tbl IN PO_TBL_DATE

254: -------------------------------------------------------------------------
255: PROCEDURE planned_item_null_date_check (
256: p_line_loc_id_tbl IN PO_TBL_NUMBER
257: , p_need_by_date_tbl IN PO_TBL_DATE
258: , p_promised_date_tbl IN PO_TBL_DATE
259: , p_item_id_tbl IN PO_TBL_NUMBER
260: , x_result_set_id IN OUT NOCOPY NUMBER
261: , x_result_type OUT NOCOPY VARCHAR2
262: )

Line 462: , p_need_by_date_tbl IN PO_TBL_DATE

458: -------------------------------------------------------------------------
459: PROCEDURE need_by_date_open_period_check(
460: p_line_loc_id_tbl IN PO_TBL_NUMBER
461: , p_line_id_tbl IN PO_TBL_NUMBER
462: , p_need_by_date_tbl IN PO_TBL_DATE
463: , p_org_id_tbl IN PO_TBL_NUMBER
464: , x_result_set_id IN OUT NOCOPY NUMBER
465: , x_result_type OUT NOCOPY VARCHAR2
466: )

Line 496: , p_promised_date_tbl IN PO_TBL_DATE

492: -------------------------------------------------------------------------
493: PROCEDURE promise_date_open_period_check(
494: p_line_loc_id_tbl IN PO_TBL_NUMBER
495: , p_line_id_tbl IN PO_TBL_NUMBER
496: , p_promised_date_tbl IN PO_TBL_DATE
497: , p_org_id_tbl IN PO_TBL_NUMBER
498: , x_result_set_id IN OUT NOCOPY NUMBER
499: , x_result_type OUT NOCOPY VARCHAR2
500: )

Line 1563: , p_start_date_tbl IN PO_TBL_DATE

1559:
1560: PROCEDURE pop_start_date_le_end_date
1561: (
1562: p_line_id_tbl IN PO_TBL_NUMBER
1563: , p_start_date_tbl IN PO_TBL_DATE
1564: , p_expiration_date_tbl IN PO_TBL_DATE
1565: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1566: , x_result_type OUT NOCOPY VARCHAR2
1567: )

Line 1564: , p_expiration_date_tbl IN PO_TBL_DATE

1560: PROCEDURE pop_start_date_le_end_date
1561: (
1562: p_line_id_tbl IN PO_TBL_NUMBER
1563: , p_start_date_tbl IN PO_TBL_DATE
1564: , p_expiration_date_tbl IN PO_TBL_DATE
1565: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1566: , x_result_type OUT NOCOPY VARCHAR2
1567: )
1568: IS

Line 1624: , p_start_date_tbl IN PO_TBL_DATE

1620:
1621: PROCEDURE pop_date_need_by_date
1622: (
1623: p_line_id_tbl IN PO_TBL_NUMBER
1624: , p_start_date_tbl IN PO_TBL_DATE
1625: , p_end_date_tbl IN PO_TBL_DATE
1626: , p_need_by_date_tbl IN PO_TBL_DATE
1627: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1628: , x_result_type OUT NOCOPY VARCHAR2

Line 1625: , p_end_date_tbl IN PO_TBL_DATE

1621: PROCEDURE pop_date_need_by_date
1622: (
1623: p_line_id_tbl IN PO_TBL_NUMBER
1624: , p_start_date_tbl IN PO_TBL_DATE
1625: , p_end_date_tbl IN PO_TBL_DATE
1626: , p_need_by_date_tbl IN PO_TBL_DATE
1627: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1628: , x_result_type OUT NOCOPY VARCHAR2
1629: )

Line 1626: , p_need_by_date_tbl IN PO_TBL_DATE

1622: (
1623: p_line_id_tbl IN PO_TBL_NUMBER
1624: , p_start_date_tbl IN PO_TBL_DATE
1625: , p_end_date_tbl IN PO_TBL_DATE
1626: , p_need_by_date_tbl IN PO_TBL_DATE
1627: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1628: , x_result_type OUT NOCOPY VARCHAR2
1629: )
1630: IS