475: p_header_id_tbl IN PO_TBL_NUMBER
476: , p_org_id_tbl IN PO_TBL_NUMBER
477: , p_currency_code_tbl IN PO_TBL_VARCHAR30
478: , p_rate_type_tbl IN PO_TBL_VARCHAR30
479: , p_rate_date_tbl IN PO_TBL_DATE
480: , p_rate_tbl IN PO_TBL_NUMBER
481: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
482: , x_result_type OUT NOCOPY VARCHAR2
483: )
659: -- Agreements only.
660: ---------------------------------------------------------------------------
661: PROCEDURE effective_le_expiration(
662: p_header_id_tbl IN PO_TBL_NUMBER
663: , p_start_date_tbl IN PO_TBL_DATE
664: , p_end_date_tbl IN PO_TBL_DATE
665: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
666: , x_result_type OUT NOCOPY VARCHAR2
667: )
660: ---------------------------------------------------------------------------
661: PROCEDURE effective_le_expiration(
662: p_header_id_tbl IN PO_TBL_NUMBER
663: , p_start_date_tbl IN PO_TBL_DATE
664: , p_end_date_tbl IN PO_TBL_DATE
665: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
666: , x_result_type OUT NOCOPY VARCHAR2
667: )
668: IS
698: ---------------------------------------------------------------------------
699: PROCEDURE effective_from_le_order_date(
700: p_header_id_tbl IN PO_TBL_NUMBER
701: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
702: , p_start_date_tbl IN PO_TBL_DATE
703: , x_result_set_id IN OUT NOCOPY NUMBER
704: , x_result_type OUT NOCOPY VARCHAR2
705: )
706: IS
773: ---------------------------------------------------------------------------
774: PROCEDURE clm_eff_from_le_order_date(
775: p_header_id_tbl IN PO_TBL_NUMBER
776: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
777: , p_start_date_tbl IN PO_TBL_DATE
778: , p_clm_effective_date_tbl IN PO_TBL_DATE
779: , x_result_set_id IN OUT NOCOPY NUMBER
780: , x_result_type OUT NOCOPY VARCHAR2
781: )
774: PROCEDURE clm_eff_from_le_order_date(
775: p_header_id_tbl IN PO_TBL_NUMBER
776: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
777: , p_start_date_tbl IN PO_TBL_DATE
778: , p_clm_effective_date_tbl IN PO_TBL_DATE
779: , x_result_set_id IN OUT NOCOPY NUMBER
780: , x_result_type OUT NOCOPY VARCHAR2
781: )
782: IS
1272: ---------------------------------------------------------------------------
1273: PROCEDURE effective_to_ge_order_date(
1274: p_header_id_tbl IN PO_TBL_NUMBER
1275: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1276: , p_end_date_tbl IN PO_TBL_DATE
1277: , x_result_set_id IN OUT NOCOPY NUMBER
1278: , x_result_type OUT NOCOPY VARCHAR2
1279: )
1280: IS
1356: ---------------------------------------------------------------------------
1357: PROCEDURE contract_start_le_order_date(
1358: p_header_id_tbl IN PO_TBL_NUMBER
1359: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1360: , p_start_date_tbl IN PO_TBL_DATE
1361: , x_result_set_id IN OUT NOCOPY NUMBER
1362: , x_result_type OUT NOCOPY VARCHAR2
1363: )
1364: IS
1440: ---------------------------------------------------------------------------
1441: PROCEDURE contract_end_ge_order_date(
1442: p_header_id_tbl IN PO_TBL_NUMBER
1443: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1444: , p_end_date_tbl IN PO_TBL_DATE
1445: , x_result_set_id IN OUT NOCOPY NUMBER
1446: , x_result_type OUT NOCOPY VARCHAR2
1447: )
1448: IS
2418: -- Mod_effective date is less then earlist need_by_date
2419: -------------------------------------------------------------------------------
2420: PROCEDURE mod_eff_dt_lt_need_by_dt(
2421: p_header_id_tbl IN PO_TBL_NUMBER
2422: ,p_mod_eff_date_tbl IN PO_TBL_DATE
2423: ,x_result_set_id IN OUT NOCOPY NUMBER
2424: ,x_result_type OUT NOCOPY VARCHAR2
2425: )
2426: IS
2484: -------------------------------------------------------------------------------
2485: PROCEDURE mod_eff_dt_not_null(
2486: p_header_id_tbl IN PO_TBL_NUMBER
2487: ,p_draft_type_tbl IN PO_TBL_VARCHAR30
2488: ,p_mod_eff_date_tbl IN PO_TBL_DATE
2489: ,x_result_set_id IN OUT NOCOPY NUMBER
2490: ,x_result_type OUT NOCOPY VARCHAR2
2491: )
2492: IS