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_VALIDATION_RESULTS_TYPE

Line 179: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

175: ---------------------------------------------------------------------------
176: PROCEDURE price_update_tol_ge_zero(
177: p_header_id_tbl IN PO_TBL_NUMBER
178: , p_price_update_tol_tbl IN PO_TBL_NUMBER
179: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
180: , x_result_type OUT NOCOPY VARCHAR2
181: )
182: IS
183: BEGIN

Line 207: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

203: ---------------------------------------------------------------------------
204: PROCEDURE amount_limit_ge_zero(
205: p_header_id_tbl IN PO_TBL_NUMBER
206: , p_amount_limit_tbl IN PO_TBL_NUMBER
207: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
208: , x_result_type OUT NOCOPY VARCHAR2
209: )
210: IS
211: BEGIN

Line 237: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

233: p_header_id_tbl IN PO_TBL_NUMBER
234: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
235: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
236: , p_amount_limit_tbl IN PO_TBL_NUMBER
237: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
238: , x_result_type OUT NOCOPY VARCHAR2
239: )
240: IS
241:

Line 283: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

279: ---------------------------------------------------------------------------
280: PROCEDURE amount_agreed_ge_zero(
281: p_header_id_tbl IN PO_TBL_NUMBER
282: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
283: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
284: , x_result_type OUT NOCOPY VARCHAR2
285: )
286: IS
287: BEGIN

Line 312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

308: PROCEDURE amount_agreed_not_null(
309: p_header_id_tbl IN PO_TBL_NUMBER
310: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
311: , p_amount_limit_tbl IN PO_TBL_NUMBER
312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
313: , x_result_type OUT NOCOPY VARCHAR2
314: )
315: IS
316: d_mod CONSTANT VARCHAR2(100) := D_amount_agreed_not_null;

Line 328: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

324: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
325: END IF;
326:
327: IF (x_results IS NULL) THEN
328: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
329: END IF;
330:
331: l_results_count := x_results.result_type.COUNT;
332:

Line 446: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

442: ---------------------------------------------------------------------------
443: PROCEDURE rate_gt_zero(
444: p_header_id_tbl IN PO_TBL_NUMBER
445: , p_rate_tbl IN PO_TBL_NUMBER
446: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
447: , x_result_type OUT NOCOPY VARCHAR2
448: )
449: IS
450: BEGIN

Line 481: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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: )
484: IS
485: d_mod CONSTANT VARCHAR2(100) := D_rate_combination_valid;

Line 501: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

497: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
498: END IF;
499:
500: IF (x_results IS NULL) THEN
501: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
502: END IF;
503:
504: l_results_count := x_results.result_type.COUNT;
505:

Line 591: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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: )
594: IS
595: d_mod CONSTANT VARCHAR2(100) := D_fax_email_address_valid;

Line 608: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
605: END IF;
606:
607: IF (x_results IS NULL) THEN
608: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
609: END IF;
610:
611: l_results_count := x_results.result_type.COUNT;
612:

Line 665: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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
669: l_message_name VARCHAR2(100);

Line 1073: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

1069: ---------------------------------------------------------------------------
1070: PROCEDURE min_guar_perc_range_check(
1071: p_header_id_tbl IN PO_TBL_NUMBER
1072: , p_min_guar_perc_tbl IN PO_TBL_NUMBER
1073: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1074: , x_result_type OUT NOCOPY VARCHAR2
1075: )
1076: IS
1077: d_mod CONSTANT VARCHAR2(100) := D_min_guar_perc_range_check;

Line 1529: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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
1533: d_mod CONSTANT VARCHAR2(100) := D_doc_num_chars_valid;

Line 1551: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1547: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1548: END IF;
1549:
1550: IF (x_results IS NULL) THEN
1551: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1552: END IF;
1553:
1554: l_results_count := x_results.result_type.COUNT;
1555:

Line 1663: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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
1667: d_mod CONSTANT VARCHAR2(100) := D_doc_num_unique;

Line 1694: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

1690:
1691: d_position := 1;
1692:
1693: IF (x_results IS NULL) THEN
1694: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1695: END IF;
1696:
1697: l_results_count := x_results.result_type.COUNT;
1698:

Line 2180: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2176: -------------------------------------------------------------------------------
2177: PROCEDURE agent_id_not_null(
2178: p_header_id_tbl IN PO_TBL_NUMBER
2179: , p_agent_id_tbl IN PO_TBL_NUMBER
2180: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2181: , x_result_type OUT NOCOPY VARCHAR2
2182: )
2183: IS
2184: BEGIN

Line 2206: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2202: -------------------------------------------------------------------------------
2203: PROCEDURE ship_to_loc_not_null(
2204: p_header_id_tbl IN PO_TBL_NUMBER
2205: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
2206: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2207: , x_result_type OUT NOCOPY VARCHAR2
2208: )
2209: IS
2210: BEGIN

Line 2232: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2228: -------------------------------------------------------------------------------
2229: PROCEDURE vendor_id_not_null(
2230: p_header_id_tbl IN PO_TBL_NUMBER
2231: , p_vendor_id_tbl IN PO_TBL_NUMBER
2232: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2233: , x_result_type OUT NOCOPY VARCHAR2
2234: )
2235: IS
2236: BEGIN

Line 2258: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

2254: -------------------------------------------------------------------------------
2255: PROCEDURE vendor_site_id_not_null(
2256: p_header_id_tbl IN PO_TBL_NUMBER
2257: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
2258: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2259: , x_result_type OUT NOCOPY VARCHAR2
2260: )
2261: IS
2262: BEGIN

Line 2613: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2609:
2610: p_intf_header_id IN PO_TBL_NUMBER,
2611: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2612: p_style_id_tbl IN PO_TBL_NUMBER,
2613: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2614: x_result_type OUT NOCOPY VARCHAR2
2615: ) IS
2616:
2617: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_standard_form;

Line 2683: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2679: p_intf_header_id IN PO_TBL_NUMBER,
2680: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2681: p_clm_document_format_tbl IN PO_TBL_VARCHAR2000,
2682: p_style_id_tbl IN PO_TBL_NUMBER,
2683: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2684: x_result_type OUT NOCOPY VARCHAR2
2685: ) IS
2686:
2687: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_document_format;

Line 2765: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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
2768:
2769: d_mod CONSTANT VARCHAR2(100) := D_validate_source_idv;

Line 2869: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2865: PROCEDURE validate_award_admin
2866: (
2867: p_intf_header_id IN PO_TBL_NUMBER,
2868: p_award_admin_tbl IN PO_TBL_VARCHAR2000,
2869: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2870: x_result_type OUT NOCOPY VARCHAR2
2871: )IS
2872:
2873: d_mod CONSTANT VARCHAR2(100) := D_validate_award_admin;

Line 2937: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

2933: PROCEDURE validate_contract_officer
2934: (
2935: p_intf_header_id IN PO_TBL_NUMBER,
2936: p_contract_officer_tbl IN PO_TBL_NUMBER,
2937: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2938: x_result_type OUT NOCOPY VARCHAR2
2939: )IS
2940:
2941: d_mod CONSTANT VARCHAR2(100) := D_validate_award_admin;

Line 3006: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

3002: (
3003: p_intf_header_id IN PO_TBL_NUMBER,
3004: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,
3005: p_src_doc_id_tbl IN PO_TBL_NUMBER,
3006: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3007: x_result_type OUT NOCOPY VARCHAR2
3008: ) IS
3009:
3010: d_mod CONSTANT VARCHAR2(100) := D_validate_umbrella_program_id;

Line 3075: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_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:
3079: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_award_type;

Line 3095: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

3091: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
3092: PO_LOG.proc_begin(d_mod,'p_clm_award_type_tbl',p_clm_award_type_tbl);
3093: END IF;
3094: IF (x_results IS NULL) THEN
3095: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3096: END IF;
3097:
3098: FOR i IN 1..p_intf_header_id.Count
3099: LOOP

Line 3173: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

3169: PROCEDURE validate_style_id
3170: (
3171: p_intf_header_id IN PO_TBL_NUMBER,
3172: p_style_id_tbl IN PO_TBL_NUMBER,
3173: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3174: x_result_type OUT NOCOPY VARCHAR2
3175: ) IS
3176:
3177: d_mod CONSTANT VARCHAR2(100) := D_validate_style_id;

Line 3195: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

3191: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3192: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
3193: END IF;
3194: IF (x_results IS NULL) THEN
3195: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3196: END IF;
3197:
3198: SELECT style_id
3199: BULK COLLECT INTO l_clm_style_id_tbl

Line 3265: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

3261: (
3262: p_intf_header_id IN PO_TBL_NUMBER,
3263: p_style_id_tbl IN PO_TBL_NUMBER,
3264: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3265: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3266: x_result_type OUT NOCOPY VARCHAR2
3267: ) IS
3268:
3269: d_mod CONSTANT VARCHAR2(100) := D_validate_idv_style_id;

Line 3280: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

3276: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3277: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
3278: END IF;
3279: IF (x_results IS NULL) THEN
3280: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3281: END IF;
3282:
3283: l_data_key := PO_CORE_S.get_session_gt_nextval();
3284:

Line 3335: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

3331: (
3332: p_intf_header_id IN PO_TBL_NUMBER,
3333: p_vendor_id_tbl IN PO_TBL_NUMBER,
3334: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3335: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3336: x_result_type OUT NOCOPY VARCHAR2
3337: ) IS
3338:
3339: d_mod CONSTANT VARCHAR2(100) := D_validate_po_idv_vendor_id;

Line 3350: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

3346: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3347: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_vendor_id_tbl);
3348: END IF;
3349: IF (x_results IS NULL) THEN
3350: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3351: END IF;
3352:
3353: l_data_key := PO_CORE_S.get_session_gt_nextval();
3354:

Line 3407: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

3403: (
3404: p_intf_header_id IN PO_TBL_NUMBER,
3405: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
3406: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3407: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3408: x_result_type OUT NOCOPY VARCHAR2
3409: ) IS
3410:
3411: d_mod CONSTANT VARCHAR2(100) := D_val_po_idv_vendor_site_id;

Line 3422: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

3418: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3419: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_vendor_site_id_tbl);
3420: END IF;
3421: IF (x_results IS NULL) THEN
3422: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3423: END IF;
3424:
3425: l_data_key := PO_CORE_S.get_session_gt_nextval();
3426:

Line 3477: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: )
3480: IS
3481: d_mod CONSTANT VARCHAR2(100) := D_validate_mod_number;

Line 3492: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

3488: PO_LOG.proc_begin(d_mod,'p_mod_number_tbl',p_mod_number_tbl);
3489: END IF;
3490:
3491: IF (x_results IS NULL) THEN
3492: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3493: END IF;
3494:
3495: l_results_count := x_results.result_type.COUNT;
3496: