DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_TBL_DATE

Line 479: , p_rate_date_tbl IN PO_TBL_DATE

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: )

Line 663: , p_start_date_tbl IN PO_TBL_DATE

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: )

Line 664: , p_end_date_tbl IN PO_TBL_DATE

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

Line 702: , p_start_date_tbl IN PO_TBL_DATE

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

Line 777: , p_start_date_tbl IN PO_TBL_DATE

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: )

Line 778: , p_clm_effective_date_tbl IN PO_TBL_DATE

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

Line 1276: , p_end_date_tbl IN PO_TBL_DATE

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

Line 1360: , p_start_date_tbl IN PO_TBL_DATE

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

Line 1444: , p_end_date_tbl IN PO_TBL_DATE

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

Line 2422: ,p_mod_eff_date_tbl IN PO_TBL_DATE

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

Line 2488: ,p_mod_eff_date_tbl IN PO_TBL_DATE

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