APPS.PO_VAL_HEADERS dependencies on PO_TBL_VARCHAR30

Line 387: , p_currency_code_tbl IN PO_TBL_VARCHAR30

383: ---------------------------------------------------------------------------
384: PROCEDURE rate_combination_valid(
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

Line 388: , p_rate_type_tbl IN PO_TBL_VARCHAR30

384: PROCEDURE rate_combination_valid(
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

Line 498: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30

494: -- is fax.
495: ---------------------------------------------------------------------------
496: PROCEDURE fax_email_address_valid(
497: p_header_id_tbl IN PO_TBL_NUMBER
498: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
499: , p_fax_tbl IN PO_TBL_VARCHAR30
500: , p_email_address_tbl IN PO_TBL_VARCHAR2000
501: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
502: , x_result_type OUT NOCOPY VARCHAR2

Line 499: , p_fax_tbl IN PO_TBL_VARCHAR30

495: ---------------------------------------------------------------------------
496: PROCEDURE fax_email_address_valid(
497: p_header_id_tbl IN PO_TBL_NUMBER
498: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
499: , p_fax_tbl IN PO_TBL_VARCHAR30
500: , p_email_address_tbl IN PO_TBL_VARCHAR2000
501: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
502: , x_result_type OUT NOCOPY VARCHAR2
503: )

Line 604: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

600: -- Agreements only.
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: )

Line 682: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

678: -- Agreements only.
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: )

Line 759: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

755: -- the Creation Date of any Orders referencing the Contract.
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: )

Line 843: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

839: -- the Creation Date of any Orders referencing the Contract.
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: )

Line 925: , p_segment1_tbl IN PO_TBL_VARCHAR30

921: ---------------------------------------------------------------------------
922: PROCEDURE doc_num_chars_valid(
923: p_header_id_tbl IN PO_TBL_NUMBER
924: , p_org_id_tbl IN PO_TBL_NUMBER
925: , p_segment1_tbl IN PO_TBL_VARCHAR30
926: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
927: , x_result_type OUT NOCOPY VARCHAR2
928: )
929: IS

Line 935: l_segment1_tbl PO_TBL_VARCHAR30;

931:
932: l_results_count NUMBER;
933: l_data_key NUMBER;
934: l_header_id_tbl PO_TBL_NUMBER;
935: l_segment1_tbl PO_TBL_VARCHAR30;
936: l_num_test NUMBER;
937: BEGIN
938:
939: IF PO_LOG.d_proc THEN

Line 1028: , p_segment1_tbl IN PO_TBL_VARCHAR30

1024: ---------------------------------------------------------------------------
1025: PROCEDURE doc_num_unique(
1026: p_header_id_tbl IN PO_TBL_NUMBER
1027: , p_org_id_tbl IN PO_TBL_NUMBER
1028: , p_segment1_tbl IN PO_TBL_VARCHAR30
1029: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1030: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1031: , x_result_type OUT NOCOPY VARCHAR2
1032: )

Line 1029: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

1025: PROCEDURE doc_num_unique(
1026: p_header_id_tbl IN PO_TBL_NUMBER
1027: , p_org_id_tbl IN PO_TBL_NUMBER
1028: , p_segment1_tbl IN PO_TBL_VARCHAR30
1029: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1030: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1031: , x_result_type OUT NOCOPY VARCHAR2
1032: )
1033: IS

Line 1042: l_segment1_tbl PO_TBL_VARCHAR30;

1038:
1039: l_data_key NUMBER;
1040: l_header_id_tbl PO_TBL_NUMBER;
1041: l_org_id_tbl PO_TBL_NUMBER;
1042: l_segment1_tbl PO_TBL_VARCHAR30;
1043: l_nonunique_tbl PO_TBL_VARCHAR2000;
1044:
1045: l_check_sourcing_flag VARCHAR2(2000);
1046: l_pon_unique_status VARCHAR2(2000);

Line 1650: , p_segment1_tbl IN PO_TBL_VARCHAR30

1646: -- Ensures that the Segment1 is not null.
1647: -------------------------------------------------------------------------------
1648: PROCEDURE segment1_not_null(
1649: p_header_id_tbl IN PO_TBL_NUMBER
1650: , p_segment1_tbl IN PO_TBL_VARCHAR30
1651: , p_org_id_tbl IN PO_TBL_NUMBER
1652: , x_result_set_id IN OUT NOCOPY NUMBER
1653: , x_result_type OUT NOCOPY VARCHAR2
1654: )