DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS2 dependencies on PO_VALIDATION_RESULTS_TYPE

Line 115: x_results IN OUT NOCOPY po_validation_results_type,

111: p_document_num_tbl IN po_tbl_varchar30,
112: p_type_lookup_code_tbl IN po_tbl_varchar30,
113: p_manual_po_num_type IN VARCHAR2,
114: p_manual_quote_num_type IN VARCHAR2,
115: x_results IN OUT NOCOPY po_validation_results_type,
116: x_result_set_id IN OUT NOCOPY NUMBER,
117: x_result_type OUT NOCOPY VARCHAR2)
118: IS
119: d_mod CONSTANT VARCHAR2(100) := d_document_num;

Line 127: x_results := po_validation_results_type.new_instance();

123: x_result_set_id := po_validations.next_result_set_id();
124: END IF;
125:
126: IF (x_results IS NULL) THEN
127: x_results := po_validation_results_type.new_instance();
128: END IF;
129:
130: IF po_log.d_proc THEN
131: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 270: x_results IN OUT NOCOPY po_validation_results_type,

266: -------------------------------------------------------------------------
267: PROCEDURE type_lookup_code(
268: p_id_tbl IN po_tbl_number,
269: p_type_lookup_code_tbl IN po_tbl_varchar30,
270: x_results IN OUT NOCOPY po_validation_results_type,
271: x_result_type OUT NOCOPY VARCHAR2)
272: IS
273: d_mod CONSTANT VARCHAR2(100) := d_type_lookup_code;
274: BEGIN

Line 276: x_results := po_validation_results_type.new_instance();

272: IS
273: d_mod CONSTANT VARCHAR2(100) := d_type_lookup_code;
274: BEGIN
275: IF (x_results IS NULL) THEN
276: x_results := po_validation_results_type.new_instance();
277: END IF;
278:
279: IF po_log.d_proc THEN
280: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 419: x_results IN OUT NOCOPY po_validation_results_type,

415: p_rate_date_tbl IN po_tbl_date,
416: p_func_currency_code IN VARCHAR2,
417: p_set_of_books_id IN NUMBER,
418: x_result_set_id IN OUT NOCOPY NUMBER,
419: x_results IN OUT NOCOPY po_validation_results_type,
420: x_result_type OUT NOCOPY VARCHAR2)
421: IS
422: d_mod CONSTANT VARCHAR2(100) := d_rate_info;
423: x_rate NUMBER;

Line 430: x_results := po_validation_results_type.new_instance();

426: x_result_set_id := po_validations.next_result_set_id();
427: END IF;
428:
429: IF (x_results IS NULL) THEN
430: x_results := po_validation_results_type.new_instance();
431: END IF;
432:
433: IF po_log.d_proc THEN
434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 713: x_results IN OUT NOCOPY po_validation_results_type,

709: p_vendor_contact_id_tbl IN po_tbl_number,
710: p_type_lookup_code_tbl IN po_tbl_varchar30, -- 8913559 bug
711: p_federal_instance IN VARCHAR,
712: x_result_set_id IN OUT NOCOPY NUMBER,
713: x_results IN OUT NOCOPY po_validation_results_type,
714: x_result_type OUT NOCOPY VARCHAR2)
715: IS
716: d_mod CONSTANT VARCHAR2(100) := d_vendor_info;
717: l_return_status VARCHAR2(1);

Line 736: x_results := po_validation_results_type.new_instance();

732: x_result_set_id := po_validations.next_result_set_id();
733: END IF;
734:
735: IF (x_results IS NULL) THEN
736: x_results := po_validation_results_type.new_instance();
737: END IF;
738:
739: IF po_log.d_proc THEN
740: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1373: x_results IN OUT NOCOPY po_validation_results_type,

1369: PROCEDURE acceptance_due_date(
1370: p_id_tbl IN po_tbl_number,
1371: p_acceptance_reqd_flag_tbl IN po_tbl_varchar1,
1372: p_acceptance_due_date_tbl IN po_tbl_date,
1373: x_results IN OUT NOCOPY po_validation_results_type,
1374: x_result_type OUT NOCOPY VARCHAR2)
1375: IS
1376: d_mod CONSTANT VARCHAR2(100) := d_acceptance_due_date;
1377: BEGIN

Line 1379: x_results := po_validation_results_type.new_instance();

1375: IS
1376: d_mod CONSTANT VARCHAR2(100) := d_acceptance_due_date;
1377: BEGIN
1378: IF (x_results IS NULL) THEN
1379: x_results := po_validation_results_type.new_instance();
1380: END IF;
1381:
1382: IF po_log.d_proc THEN
1383: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1427: x_results IN OUT NOCOPY po_validation_results_type,

1423: -------------------------------------------------------------------------
1424: PROCEDURE cancel_flag(
1425: p_id_tbl IN po_tbl_number,
1426: p_cancel_flag_tbl IN po_tbl_varchar1,
1427: x_results IN OUT NOCOPY po_validation_results_type,
1428: x_result_type OUT NOCOPY VARCHAR2)
1429: IS
1430: d_mod CONSTANT VARCHAR2(100) := d_cancel_flag;
1431: BEGIN

Line 1433: x_results := po_validation_results_type.new_instance();

1429: IS
1430: d_mod CONSTANT VARCHAR2(100) := d_cancel_flag;
1431: BEGIN
1432: IF (x_results IS NULL) THEN
1433: x_results := po_validation_results_type.new_instance();
1434: END IF;
1435:
1436: IF po_log.d_proc THEN
1437: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1481: x_results IN OUT NOCOPY po_validation_results_type,

1477: PROCEDURE closed_code(
1478: p_id_tbl IN po_tbl_number,
1479: p_closed_code_tbl IN po_tbl_varchar30,
1480: p_acceptance_reqd_flag_tbl IN po_tbl_varchar1,
1481: x_results IN OUT NOCOPY po_validation_results_type,
1482: x_result_type OUT NOCOPY VARCHAR2)
1483: IS
1484: d_mod CONSTANT VARCHAR2(100) := d_closed_code;
1485: BEGIN

Line 1487: x_results := po_validation_results_type.new_instance();

1483: IS
1484: d_mod CONSTANT VARCHAR2(100) := d_closed_code;
1485: BEGIN
1486: IF (x_results IS NULL) THEN
1487: x_results := po_validation_results_type.new_instance();
1488: END IF;
1489:
1490: IF po_log.d_proc THEN
1491: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1536: x_results IN OUT NOCOPY po_validation_results_type,

1532: PROCEDURE print_count(
1533: p_id_tbl IN po_tbl_number,
1534: p_print_count_tbl IN po_tbl_number,
1535: p_approval_status_tbl IN po_tbl_varchar30,
1536: x_results IN OUT NOCOPY po_validation_results_type,
1537: x_result_type OUT NOCOPY VARCHAR2)
1538: IS
1539: d_mod CONSTANT VARCHAR2(100) := d_print_count;
1540: BEGIN

Line 1542: x_results := po_validation_results_type.new_instance();

1538: IS
1539: d_mod CONSTANT VARCHAR2(100) := d_print_count;
1540: BEGIN
1541: IF (x_results IS NULL) THEN
1542: x_results := po_validation_results_type.new_instance();
1543: END IF;
1544:
1545: IF po_log.d_proc THEN
1546: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1590: x_results IN OUT NOCOPY po_validation_results_type,

1586: -------------------------------------------------------------------------
1587: PROCEDURE approval_status(
1588: p_id_tbl IN po_tbl_number,
1589: p_approval_status_tbl IN po_tbl_varchar30,
1590: x_results IN OUT NOCOPY po_validation_results_type,
1591: x_result_type OUT NOCOPY VARCHAR2)
1592: IS
1593: d_mod CONSTANT VARCHAR2(100) := d_approval_status;
1594: BEGIN

Line 1596: x_results := po_validation_results_type.new_instance();

1592: IS
1593: d_mod CONSTANT VARCHAR2(100) := d_approval_status;
1594: BEGIN
1595: IF (x_results IS NULL) THEN
1596: x_results := po_validation_results_type.new_instance();
1597: END IF;
1598:
1599: IF po_log.d_proc THEN
1600: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1638: x_results IN OUT NOCOPY po_validation_results_type,

1634: -------------------------------------------------------------------------
1635: PROCEDURE amount_to_encumber(
1636: p_id_tbl IN po_tbl_number,
1637: p_amount_to_encumber_tbl IN po_tbl_number,
1638: x_results IN OUT NOCOPY po_validation_results_type,
1639: x_result_type OUT NOCOPY VARCHAR2)
1640: IS
1641: d_mod CONSTANT VARCHAR2(100) := d_amount_to_encumber;
1642: BEGIN

Line 1644: x_results := po_validation_results_type.new_instance();

1640: IS
1641: d_mod CONSTANT VARCHAR2(100) := d_amount_to_encumber;
1642: BEGIN
1643: IF (x_results IS NULL) THEN
1644: x_results := po_validation_results_type.new_instance();
1645: END IF;
1646:
1647: IF po_log.d_proc THEN
1648: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1799: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

1795: PROCEDURE acceptance_required_flag
1796: ( p_id_tbl IN PO_TBL_NUMBER,
1797: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
1798: p_acceptance_required_flag_tbl IN PO_TBL_VARCHAR1,
1799: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1800: x_result_type OUT NOCOPY VARCHAR2
1801: )
1802: IS
1803:

Line 1807: x_results := po_validation_results_type.new_instance();

1803:
1804: d_mod CONSTANT VARCHAR2(100) := d_acceptance_required_flag;
1805: BEGIN
1806: IF (x_results IS NULL) THEN
1807: x_results := po_validation_results_type.new_instance();
1808: END IF;
1809:
1810: x_result_type := po_validations.c_result_type_success;
1811:

Line 1880: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

1876: PROCEDURE amount_limit
1877: ( p_id_tbl IN PO_TBL_NUMBER,
1878: p_amount_limit_tbl IN PO_TBL_NUMBER,
1879: p_amount_agreed_tbl IN PO_TBL_NUMBER,
1880: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1881: x_result_type OUT NOCOPY VARCHAR2
1882: ) IS
1883: d_mod CONSTANT VARCHAR2(100) := d_amount_limit;
1884: BEGIN

Line 1887: x_results := po_validation_results_type.new_instance();

1883: d_mod CONSTANT VARCHAR2(100) := d_amount_limit;
1884: BEGIN
1885:
1886: IF (x_results IS NULL) THEN
1887: x_results := po_validation_results_type.new_instance();
1888: END IF;
1889:
1890: x_result_type := po_validations.c_result_type_success;
1891: