DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_TBL_DATE

Line 389: , p_rate_date_tbl IN PO_TBL_DATE

385: p_header_id_tbl IN PO_TBL_NUMBER
386: , p_org_id_tbl IN PO_TBL_NUMBER
387: , p_currency_code_tbl IN PO_TBL_VARCHAR30
388: , p_rate_type_tbl IN PO_TBL_VARCHAR30
389: , p_rate_date_tbl IN PO_TBL_DATE
390: , p_rate_tbl IN PO_TBL_NUMBER
391: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
392: , x_result_type OUT NOCOPY VARCHAR2
393: )

Line 573: , p_start_date_tbl IN PO_TBL_DATE

569: -- Agreements only.
570: ---------------------------------------------------------------------------
571: PROCEDURE effective_le_expiration(
572: p_header_id_tbl IN PO_TBL_NUMBER
573: , p_start_date_tbl IN PO_TBL_DATE
574: , p_end_date_tbl IN PO_TBL_DATE
575: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
576: , x_result_type OUT NOCOPY VARCHAR2
577: )

Line 574: , p_end_date_tbl IN PO_TBL_DATE

570: ---------------------------------------------------------------------------
571: PROCEDURE effective_le_expiration(
572: p_header_id_tbl IN PO_TBL_NUMBER
573: , p_start_date_tbl IN PO_TBL_DATE
574: , p_end_date_tbl IN PO_TBL_DATE
575: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
576: , x_result_type OUT NOCOPY VARCHAR2
577: )
578: IS

Line 605: , p_start_date_tbl IN PO_TBL_DATE

601: ---------------------------------------------------------------------------
602: PROCEDURE effective_from_le_order_date(
603: p_header_id_tbl IN PO_TBL_NUMBER
604: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
605: , p_start_date_tbl IN PO_TBL_DATE
606: , x_result_set_id IN OUT NOCOPY NUMBER
607: , x_result_type OUT NOCOPY VARCHAR2
608: )
609: IS

Line 683: , p_end_date_tbl IN PO_TBL_DATE

679: ---------------------------------------------------------------------------
680: PROCEDURE effective_to_ge_order_date(
681: p_header_id_tbl IN PO_TBL_NUMBER
682: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
683: , p_end_date_tbl IN PO_TBL_DATE
684: , x_result_set_id IN OUT NOCOPY NUMBER
685: , x_result_type OUT NOCOPY VARCHAR2
686: )
687: IS

Line 760: , p_start_date_tbl IN PO_TBL_DATE

756: ---------------------------------------------------------------------------
757: PROCEDURE contract_start_le_order_date(
758: p_header_id_tbl IN PO_TBL_NUMBER
759: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
760: , p_start_date_tbl IN PO_TBL_DATE
761: , x_result_set_id IN OUT NOCOPY NUMBER
762: , x_result_type OUT NOCOPY VARCHAR2
763: )
764: IS

Line 844: , p_end_date_tbl IN PO_TBL_DATE

840: ---------------------------------------------------------------------------
841: PROCEDURE contract_end_ge_order_date(
842: p_header_id_tbl IN PO_TBL_NUMBER
843: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
844: , p_end_date_tbl IN PO_TBL_DATE
845: , x_result_set_id IN OUT NOCOPY NUMBER
846: , x_result_type OUT NOCOPY VARCHAR2
847: )
848: IS