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 263: x_results IN OUT NOCOPY po_validation_results_type,

259: -------------------------------------------------------------------------
260: PROCEDURE type_lookup_code(
261: p_id_tbl IN po_tbl_number,
262: p_type_lookup_code_tbl IN po_tbl_varchar30,
263: x_results IN OUT NOCOPY po_validation_results_type,
264: x_result_type OUT NOCOPY VARCHAR2)
265: IS
266: d_mod CONSTANT VARCHAR2(100) := d_type_lookup_code;
267: BEGIN

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

265: IS
266: d_mod CONSTANT VARCHAR2(100) := d_type_lookup_code;
267: BEGIN
268: IF (x_results IS NULL) THEN
269: x_results := po_validation_results_type.new_instance();
270: END IF;
271:
272: IF po_log.d_proc THEN
273: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 412: x_results IN OUT NOCOPY po_validation_results_type,

408: p_rate_date_tbl IN po_tbl_date,
409: p_func_currency_code IN VARCHAR2,
410: p_set_of_books_id IN NUMBER,
411: x_result_set_id IN OUT NOCOPY NUMBER,
412: x_results IN OUT NOCOPY po_validation_results_type,
413: x_result_type OUT NOCOPY VARCHAR2)
414: IS
415: d_mod CONSTANT VARCHAR2(100) := d_rate_info;
416: x_rate NUMBER;

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

419: x_result_set_id := po_validations.next_result_set_id();
420: END IF;
421:
422: IF (x_results IS NULL) THEN
423: x_results := po_validation_results_type.new_instance();
424: END IF;
425:
426: IF po_log.d_proc THEN
427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 705: x_results IN OUT NOCOPY po_validation_results_type,

701: p_vendor_site_id_tbl IN po_tbl_number,
702: p_vendor_contact_id_tbl IN po_tbl_number,
703: p_federal_instance IN VARCHAR,
704: x_result_set_id IN OUT NOCOPY NUMBER,
705: x_results IN OUT NOCOPY po_validation_results_type,
706: x_result_type OUT NOCOPY VARCHAR2)
707: IS
708: d_mod CONSTANT VARCHAR2(100) := d_vendor_info;
709: l_return_status VARCHAR2(1);

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

724: x_result_set_id := po_validations.next_result_set_id();
725: END IF;
726:
727: IF (x_results IS NULL) THEN
728: x_results := po_validation_results_type.new_instance();
729: END IF;
730:
731: IF po_log.d_proc THEN
732: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1363: x_results IN OUT NOCOPY po_validation_results_type,

1359: PROCEDURE acceptance_due_date(
1360: p_id_tbl IN po_tbl_number,
1361: p_acceptance_reqd_flag_tbl IN po_tbl_varchar1,
1362: p_acceptance_due_date_tbl IN po_tbl_date,
1363: x_results IN OUT NOCOPY po_validation_results_type,
1364: x_result_type OUT NOCOPY VARCHAR2)
1365: IS
1366: d_mod CONSTANT VARCHAR2(100) := d_acceptance_due_date;
1367: BEGIN

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

1365: IS
1366: d_mod CONSTANT VARCHAR2(100) := d_acceptance_due_date;
1367: BEGIN
1368: IF (x_results IS NULL) THEN
1369: x_results := po_validation_results_type.new_instance();
1370: END IF;
1371:
1372: IF po_log.d_proc THEN
1373: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1417: x_results IN OUT NOCOPY po_validation_results_type,

1413: -------------------------------------------------------------------------
1414: PROCEDURE cancel_flag(
1415: p_id_tbl IN po_tbl_number,
1416: p_cancel_flag_tbl IN po_tbl_varchar1,
1417: x_results IN OUT NOCOPY po_validation_results_type,
1418: x_result_type OUT NOCOPY VARCHAR2)
1419: IS
1420: d_mod CONSTANT VARCHAR2(100) := d_cancel_flag;
1421: BEGIN

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

1419: IS
1420: d_mod CONSTANT VARCHAR2(100) := d_cancel_flag;
1421: BEGIN
1422: IF (x_results IS NULL) THEN
1423: x_results := po_validation_results_type.new_instance();
1424: END IF;
1425:
1426: IF po_log.d_proc THEN
1427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1471: x_results IN OUT NOCOPY po_validation_results_type,

1467: PROCEDURE closed_code(
1468: p_id_tbl IN po_tbl_number,
1469: p_closed_code_tbl IN po_tbl_varchar30,
1470: p_acceptance_reqd_flag_tbl IN po_tbl_varchar1,
1471: x_results IN OUT NOCOPY po_validation_results_type,
1472: x_result_type OUT NOCOPY VARCHAR2)
1473: IS
1474: d_mod CONSTANT VARCHAR2(100) := d_closed_code;
1475: BEGIN

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

1473: IS
1474: d_mod CONSTANT VARCHAR2(100) := d_closed_code;
1475: BEGIN
1476: IF (x_results IS NULL) THEN
1477: x_results := po_validation_results_type.new_instance();
1478: END IF;
1479:
1480: IF po_log.d_proc THEN
1481: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1526: x_results IN OUT NOCOPY po_validation_results_type,

1522: PROCEDURE print_count(
1523: p_id_tbl IN po_tbl_number,
1524: p_print_count_tbl IN po_tbl_number,
1525: p_approval_status_tbl IN po_tbl_varchar30,
1526: x_results IN OUT NOCOPY po_validation_results_type,
1527: x_result_type OUT NOCOPY VARCHAR2)
1528: IS
1529: d_mod CONSTANT VARCHAR2(100) := d_print_count;
1530: BEGIN

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

1528: IS
1529: d_mod CONSTANT VARCHAR2(100) := d_print_count;
1530: BEGIN
1531: IF (x_results IS NULL) THEN
1532: x_results := po_validation_results_type.new_instance();
1533: END IF;
1534:
1535: IF po_log.d_proc THEN
1536: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1580: x_results IN OUT NOCOPY po_validation_results_type,

1576: -------------------------------------------------------------------------
1577: PROCEDURE approval_status(
1578: p_id_tbl IN po_tbl_number,
1579: p_approval_status_tbl IN po_tbl_varchar30,
1580: x_results IN OUT NOCOPY po_validation_results_type,
1581: x_result_type OUT NOCOPY VARCHAR2)
1582: IS
1583: d_mod CONSTANT VARCHAR2(100) := d_approval_status;
1584: BEGIN

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

1582: IS
1583: d_mod CONSTANT VARCHAR2(100) := d_approval_status;
1584: BEGIN
1585: IF (x_results IS NULL) THEN
1586: x_results := po_validation_results_type.new_instance();
1587: END IF;
1588:
1589: IF po_log.d_proc THEN
1590: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1628: x_results IN OUT NOCOPY po_validation_results_type,

1624: -------------------------------------------------------------------------
1625: PROCEDURE amount_to_encumber(
1626: p_id_tbl IN po_tbl_number,
1627: p_amount_to_encumber_tbl IN po_tbl_number,
1628: x_results IN OUT NOCOPY po_validation_results_type,
1629: x_result_type OUT NOCOPY VARCHAR2)
1630: IS
1631: d_mod CONSTANT VARCHAR2(100) := d_amount_to_encumber;
1632: BEGIN

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

1630: IS
1631: d_mod CONSTANT VARCHAR2(100) := d_amount_to_encumber;
1632: BEGIN
1633: IF (x_results IS NULL) THEN
1634: x_results := po_validation_results_type.new_instance();
1635: END IF;
1636:
1637: IF po_log.d_proc THEN
1638: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 1787: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

1783: PROCEDURE acceptance_required_flag
1784: ( p_id_tbl IN PO_TBL_NUMBER,
1785: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
1786: p_acceptance_required_flag_tbl IN PO_TBL_VARCHAR1,
1787: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1788: x_result_type OUT NOCOPY VARCHAR2
1789: )
1790: IS
1791:

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

1791:
1792: d_mod CONSTANT VARCHAR2(100) := d_acceptance_required_flag;
1793: BEGIN
1794: IF (x_results IS NULL) THEN
1795: x_results := po_validation_results_type.new_instance();
1796: END IF;
1797:
1798: x_result_type := po_validations.c_result_type_success;
1799:

Line 1868: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

1864: PROCEDURE amount_limit
1865: ( p_id_tbl IN PO_TBL_NUMBER,
1866: p_amount_limit_tbl IN PO_TBL_NUMBER,
1867: p_amount_agreed_tbl IN PO_TBL_NUMBER,
1868: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1869: x_result_type OUT NOCOPY VARCHAR2
1870: ) IS
1871: d_mod CONSTANT VARCHAR2(100) := d_amount_limit;
1872: BEGIN

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

1871: d_mod CONSTANT VARCHAR2(100) := d_amount_limit;
1872: BEGIN
1873:
1874: IF (x_results IS NULL) THEN
1875: x_results := po_validation_results_type.new_instance();
1876: END IF;
1877:
1878: x_result_type := po_validations.c_result_type_success;
1879: