eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_HEADERS dependencies on PO_TBL_VARCHAR30

Line 477: , p_currency_code_tbl IN PO_TBL_VARCHAR30

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

Line 478: , p_rate_type_tbl IN PO_TBL_VARCHAR30

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

Line 588: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30

584: -- is fax.
585: ---------------------------------------------------------------------------
586: PROCEDURE fax_email_address_valid(
587: p_header_id_tbl IN PO_TBL_NUMBER
588: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
589: , p_fax_tbl IN PO_TBL_VARCHAR30
590: , p_email_address_tbl IN PO_TBL_VARCHAR2000
591: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
592: , x_result_type OUT NOCOPY VARCHAR2

Line 589: , p_fax_tbl IN PO_TBL_VARCHAR30

585: ---------------------------------------------------------------------------
586: PROCEDURE fax_email_address_valid(
587: p_header_id_tbl IN PO_TBL_NUMBER
588: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
589: , p_fax_tbl IN PO_TBL_VARCHAR30
590: , p_email_address_tbl IN PO_TBL_VARCHAR2000
591: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
592: , x_result_type OUT NOCOPY VARCHAR2
593: )

Line 701: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 776: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

772: -- the order start 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

Line 851: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

847: -- the minimum guarantee award amount
848: ---------------------------------------------------------------------------
849: PROCEDURE max_ceil_awd_amt_gt_min(
850: p_header_id_tbl IN PO_TBL_NUMBER
851: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
852: , p_amount_limit_tbl IN PO_TBL_NUMBER
853: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER
854: , x_result_set_id IN OUT NOCOPY NUMBER
855: , x_result_type OUT NOCOPY VARCHAR2

Line 925: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

921: -- Checks that Maximum Ceiling Award Amount >= Minimum Per Order Amount
922: ---------------------------------------------------------------------------
923: PROCEDURE max_ceil_amt_gt_min_ord (
924: p_header_id_tbl IN PO_TBL_NUMBER
925: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
926: , p_amount_limit_tbl IN PO_TBL_NUMBER
927: , p_min_order_amt_tbl IN PO_TBL_NUMBER
928: , x_result_set_id IN OUT NOCOPY NUMBER
929: , x_result_type OUT NOCOPY VARCHAR2

Line 998: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

994: -- Checks that Maximum Ceiling Award Amount >= Maximum Per Order Amount
995: ---------------------------------------------------------------------------
996: PROCEDURE max_ceil_amt_gt_max_ord (
997: p_header_id_tbl IN PO_TBL_NUMBER
998: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
999: , p_amount_limit_tbl IN PO_TBL_NUMBER
1000: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1001: , x_result_set_id IN OUT NOCOPY NUMBER
1002: , x_result_type OUT NOCOPY VARCHAR2

Line 1110: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

1106: -- Checks that the CLM minimum order amount should be less than maximum order amount
1107: ---------------------------------------------------------------------------
1108: PROCEDURE max_ord_amt_gt_min(
1109: p_header_id_tbl IN PO_TBL_NUMBER
1110: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1111: , p_min_order_amt_tbl IN PO_TBL_NUMBER
1112: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1113: , x_result_set_id IN OUT NOCOPY NUMBER
1114: , x_result_type OUT NOCOPY VARCHAR2

Line 1184: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

1180: -- For CLM standard form and document format cannot be null
1181: ---------------------------------------------------------------------------
1182: PROCEDURE print_form_format_valid(
1183: p_header_id_tbl IN PO_TBL_NUMBER
1184: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1185: , p_style_id_tbl IN PO_TBL_NUMBER
1186: , p_draft_type_tbl IN PO_TBL_VARCHAR30
1187: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
1188: , p_document_format_tbl IN PO_TBL_VARCHAR2000

Line 1186: , p_draft_type_tbl IN PO_TBL_VARCHAR30

1182: PROCEDURE print_form_format_valid(
1183: p_header_id_tbl IN PO_TBL_NUMBER
1184: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1185: , p_style_id_tbl IN PO_TBL_NUMBER
1186: , p_draft_type_tbl IN PO_TBL_VARCHAR30
1187: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
1188: , p_document_format_tbl IN PO_TBL_VARCHAR2000
1189: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER
1190: , p_clm_ext_idv_tbl IN PO_TBL_VARCHAR2000

Line 1191: , p_clm_award_type_tbl IN PO_TBL_VARCHAR30 -- bug 10389450

1187: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
1188: , p_document_format_tbl IN PO_TBL_VARCHAR2000
1189: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER
1190: , p_clm_ext_idv_tbl IN PO_TBL_VARCHAR2000
1191: , p_clm_award_type_tbl IN PO_TBL_VARCHAR30 -- bug 10389450
1192: , x_result_set_id IN OUT NOCOPY NUMBER
1193: , x_result_type OUT NOCOPY VARCHAR2
1194: )
1195: IS

Line 1275: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 1359: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 1443: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 1528: , p_segment1_tbl IN PO_TBL_VARCHAR30

1524: PROCEDURE doc_num_chars_valid(
1525: p_header_id_tbl IN PO_TBL_NUMBER
1526: , p_org_id_tbl IN PO_TBL_NUMBER
1527: , p_style_id_tbl IN PO_TBL_NUMBER
1528: , p_segment1_tbl IN PO_TBL_VARCHAR30
1529: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1530: , x_result_type OUT NOCOPY VARCHAR2
1531: )
1532: IS

Line 1538: l_segment1_tbl PO_TBL_VARCHAR30;

1534:
1535: l_results_count NUMBER;
1536: l_data_key NUMBER;
1537: l_header_id_tbl PO_TBL_NUMBER;
1538: l_segment1_tbl PO_TBL_VARCHAR30;
1539: l_num_test NUMBER;
1540: L_TEMP_SEGMENT PO_HEADERS_ALL.SEGMENT1%TYPE;
1541: BEGIN
1542:

Line 1661: , p_segment1_tbl IN PO_TBL_VARCHAR30

1657: ---------------------------------------------------------------------------
1658: PROCEDURE doc_num_unique(
1659: p_header_id_tbl IN PO_TBL_NUMBER
1660: , p_org_id_tbl IN PO_TBL_NUMBER
1661: , p_segment1_tbl IN PO_TBL_VARCHAR30
1662: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1663: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1664: , x_result_type OUT NOCOPY VARCHAR2
1665: )

Line 1662: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

1658: PROCEDURE doc_num_unique(
1659: p_header_id_tbl IN PO_TBL_NUMBER
1660: , p_org_id_tbl IN PO_TBL_NUMBER
1661: , p_segment1_tbl IN PO_TBL_VARCHAR30
1662: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1663: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1664: , x_result_type OUT NOCOPY VARCHAR2
1665: )
1666: IS

Line 1675: l_segment1_tbl PO_TBL_VARCHAR30;

1671:
1672: l_data_key NUMBER;
1673: l_header_id_tbl PO_TBL_NUMBER;
1674: l_org_id_tbl PO_TBL_NUMBER;
1675: l_segment1_tbl PO_TBL_VARCHAR30;
1676: l_nonunique_tbl PO_TBL_VARCHAR2000;
1677:
1678: l_check_sourcing_flag VARCHAR2(2000);
1679: l_pon_unique_status VARCHAR2(2000);

Line 2283: , p_segment1_tbl IN PO_TBL_VARCHAR30

2279: -- Ensures that the Segment1 is not null.
2280: -------------------------------------------------------------------------------
2281: PROCEDURE segment1_not_null(
2282: p_header_id_tbl IN PO_TBL_NUMBER
2283: , p_segment1_tbl IN PO_TBL_VARCHAR30
2284: , p_org_id_tbl IN PO_TBL_NUMBER
2285: , x_result_set_id IN OUT NOCOPY NUMBER
2286: , x_result_type OUT NOCOPY VARCHAR2
2287: )

Line 2327: p_ship_via_lookup_code_tbl IN po_tbl_varchar30,

2323: --
2324: -- Error when the ship_via field has an invalid value.
2325: PROCEDURE ship_via_lookup_code_valid(
2326: p_header_id_tbl IN po_tbl_number,
2327: p_ship_via_lookup_code_tbl IN po_tbl_varchar30,
2328: --Bug 12409257 start.Bug 13771850-Revert 12409257 changes
2329: p_org_id_tbl IN PO_TBL_NUMBER,
2330: --p_ship_to_location_id_tbl IN PO_TBL_NUMBER,
2331: --Bug 12409257 end.Bug 13771850 end

Line 2487: ,p_draft_type_tbl IN PO_TBL_VARCHAR30

2483: -- Mod_effective date cannot be null for Modification
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: )

Line 2546: ,p_control_action_tbl IN PO_TBL_VARCHAR30

2542: END mod_eff_dt_not_null;
2543:
2544: PROCEDURE mod_no_cancel_shp_complt(
2545: p_header_id_tbl IN PO_TBL_NUMBER
2546: ,p_control_action_tbl IN PO_TBL_VARCHAR30
2547: ,x_result_set_id IN OUT NOCOPY NUMBER
2548: ,x_result_type OUT NOCOPY VARCHAR2
2549: )
2550: IS

Line 2763: p_currency_code_tbl in PO_TBL_VARCHAR30,

2759: PROCEDURE validate_source_idv
2760: (
2761: p_intf_header_id in PO_TBL_NUMBER,
2762: p_src_doc_id_tbl IN PO_TBL_NUMBER,
2763: p_currency_code_tbl in PO_TBL_VARCHAR30,
2764: p_org_id_tbl in PO_TBL_NUMBER,
2765: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2766: x_result_type OUT NOCOPY VARCHAR2
2767: ) IS

Line 3073: p_clm_award_type_tbl IN PO_TBL_VARCHAR30,

3069:
3070: PROCEDURE validate_clm_award_type
3071: (
3072: p_intf_header_id IN PO_TBL_NUMBER,
3073: p_clm_award_type_tbl IN PO_TBL_VARCHAR30,
3074: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
3075: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3076: x_result_type OUT NOCOPY VARCHAR2
3077: ) IS

Line 3074: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,

3070: PROCEDURE validate_clm_award_type
3071: (
3072: p_intf_header_id IN PO_TBL_NUMBER,
3073: p_clm_award_type_tbl IN PO_TBL_VARCHAR30,
3074: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
3075: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3076: x_result_type OUT NOCOPY VARCHAR2
3077: ) IS
3078:

Line 3475: p_draft_type_tbl IN PO_TBL_VARCHAR30,

3471:
3472: -- : This validation avoids null PAR/MOD document Number
3473: PROCEDURE validate_mod_number(
3474: p_header_id_tbl IN PO_TBL_NUMBER,
3475: p_draft_type_tbl IN PO_TBL_VARCHAR30,
3476: p_mod_number_tbl IN PO_TBL_VARCHAR100,
3477: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3478: x_result_type OUT NOCOPY VARCHAR2
3479: )