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_DIFF_SUMMARY_PKG dependencies on PO_TBL_NUMBER

Line 36: p_line_id_list IN PO_TBL_NUMBER,

32: );
33:
34: PROCEDURE cascade_change_acceptance
35: ( p_draft_id IN NUMBER,
36: p_line_id_list IN PO_TBL_NUMBER,
37: p_change_accepted_value IN VARCHAR2,
38: x_return_status OUT NOCOPY VARCHAR2
39: );
40:

Line 43: p_reject_line_id_list IN PO_TBL_NUMBER,

39: );
40:
41: PROCEDURE validate_disposition
42: ( p_draft_id IN NUMBER,
43: p_reject_line_id_list IN PO_TBL_NUMBER,
44: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
45: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
46: x_return_status OUT NOCOPY VARCHAR2
47: );

Line 44: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,

40:
41: PROCEDURE validate_disposition
42: ( p_draft_id IN NUMBER,
43: p_reject_line_id_list IN PO_TBL_NUMBER,
44: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
45: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
46: x_return_status OUT NOCOPY VARCHAR2
47: );
48:

Line 45: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,

41: PROCEDURE validate_disposition
42: ( p_draft_id IN NUMBER,
43: p_reject_line_id_list IN PO_TBL_NUMBER,
44: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
45: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
46: x_return_status OUT NOCOPY VARCHAR2
47: );
48:
49: --==========================================================================

Line 748: l_reject_list PO_TBL_NUMBER;

744:
745: l_draft_id PO_DRAFTS.draft_id%TYPE;
746: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
747: l_created_language PO_HEADERS_ALL.created_language%TYPE;
748: l_reject_list PO_TBL_NUMBER;
749:
750: l_return_status VARCHAR2(1);
751:
752: BEGIN

Line 1285: p_reject_line_id_list IN PO_TBL_NUMBER,

1281: --End of Comments
1282: ------------------------------------------------------------------------
1283: PROCEDURE record_disposition
1284: ( p_draft_id IN NUMBER,
1285: p_reject_line_id_list IN PO_TBL_NUMBER,
1286: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1287: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1288: x_return_status OUT NOCOPY VARCHAR2
1289: ) IS

Line 1286: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544

1282: ------------------------------------------------------------------------
1283: PROCEDURE record_disposition
1284: ( p_draft_id IN NUMBER,
1285: p_reject_line_id_list IN PO_TBL_NUMBER,
1286: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1287: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1288: x_return_status OUT NOCOPY VARCHAR2
1289: ) IS
1290:

Line 1287: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544

1283: PROCEDURE record_disposition
1284: ( p_draft_id IN NUMBER,
1285: p_reject_line_id_list IN PO_TBL_NUMBER,
1286: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1287: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1288: x_return_status OUT NOCOPY VARCHAR2
1289: ) IS
1290:
1291: d_api_name CONSTANT VARCHAR2(30) := 'record_disposition';

Line 1508: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1504: l_over_tolerance VARCHAR2(1);
1505:
1506: l_check_tolerance_index_tbl DBMS_SQL.NUMBER_TABLE;
1507:
1508: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1509: l_vendor_id_tbl PO_TBL_NUMBER;
1510: l_po_line_id_tbl PO_TBL_NUMBER;
1511: l_po_header_id_tbl PO_TBL_NUMBER;
1512: l_item_id_tbl PO_TBL_NUMBER;

Line 1509: l_vendor_id_tbl PO_TBL_NUMBER;

1505:
1506: l_check_tolerance_index_tbl DBMS_SQL.NUMBER_TABLE;
1507:
1508: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1509: l_vendor_id_tbl PO_TBL_NUMBER;
1510: l_po_line_id_tbl PO_TBL_NUMBER;
1511: l_po_header_id_tbl PO_TBL_NUMBER;
1512: l_item_id_tbl PO_TBL_NUMBER;
1513: l_category_id_tbl PO_TBL_NUMBER;

Line 1510: l_po_line_id_tbl PO_TBL_NUMBER;

1506: l_check_tolerance_index_tbl DBMS_SQL.NUMBER_TABLE;
1507:
1508: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1509: l_vendor_id_tbl PO_TBL_NUMBER;
1510: l_po_line_id_tbl PO_TBL_NUMBER;
1511: l_po_header_id_tbl PO_TBL_NUMBER;
1512: l_item_id_tbl PO_TBL_NUMBER;
1513: l_category_id_tbl PO_TBL_NUMBER;
1514: l_new_price_tbl PO_TBL_NUMBER;

Line 1511: l_po_header_id_tbl PO_TBL_NUMBER;

1507:
1508: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1509: l_vendor_id_tbl PO_TBL_NUMBER;
1510: l_po_line_id_tbl PO_TBL_NUMBER;
1511: l_po_header_id_tbl PO_TBL_NUMBER;
1512: l_item_id_tbl PO_TBL_NUMBER;
1513: l_category_id_tbl PO_TBL_NUMBER;
1514: l_new_price_tbl PO_TBL_NUMBER;
1515: l_old_price_tbl PO_TBL_NUMBER;

Line 1512: l_item_id_tbl PO_TBL_NUMBER;

1508: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1509: l_vendor_id_tbl PO_TBL_NUMBER;
1510: l_po_line_id_tbl PO_TBL_NUMBER;
1511: l_po_header_id_tbl PO_TBL_NUMBER;
1512: l_item_id_tbl PO_TBL_NUMBER;
1513: l_category_id_tbl PO_TBL_NUMBER;
1514: l_new_price_tbl PO_TBL_NUMBER;
1515: l_old_price_tbl PO_TBL_NUMBER;
1516: l_new_line_flag_tbl PO_TBL_VARCHAR1;

Line 1513: l_category_id_tbl PO_TBL_NUMBER;

1509: l_vendor_id_tbl PO_TBL_NUMBER;
1510: l_po_line_id_tbl PO_TBL_NUMBER;
1511: l_po_header_id_tbl PO_TBL_NUMBER;
1512: l_item_id_tbl PO_TBL_NUMBER;
1513: l_category_id_tbl PO_TBL_NUMBER;
1514: l_new_price_tbl PO_TBL_NUMBER;
1515: l_old_price_tbl PO_TBL_NUMBER;
1516: l_new_line_flag_tbl PO_TBL_VARCHAR1;
1517: l_price_update_tolerance_tbl PO_TBL_NUMBER;

Line 1514: l_new_price_tbl PO_TBL_NUMBER;

1510: l_po_line_id_tbl PO_TBL_NUMBER;
1511: l_po_header_id_tbl PO_TBL_NUMBER;
1512: l_item_id_tbl PO_TBL_NUMBER;
1513: l_category_id_tbl PO_TBL_NUMBER;
1514: l_new_price_tbl PO_TBL_NUMBER;
1515: l_old_price_tbl PO_TBL_NUMBER;
1516: l_new_line_flag_tbl PO_TBL_VARCHAR1;
1517: l_price_update_tolerance_tbl PO_TBL_NUMBER;
1518:

Line 1515: l_old_price_tbl PO_TBL_NUMBER;

1511: l_po_header_id_tbl PO_TBL_NUMBER;
1512: l_item_id_tbl PO_TBL_NUMBER;
1513: l_category_id_tbl PO_TBL_NUMBER;
1514: l_new_price_tbl PO_TBL_NUMBER;
1515: l_old_price_tbl PO_TBL_NUMBER;
1516: l_new_line_flag_tbl PO_TBL_VARCHAR1;
1517: l_price_update_tolerance_tbl PO_TBL_NUMBER;
1518:
1519: l_return_status VARCHAR2(1);

Line 1517: l_price_update_tolerance_tbl PO_TBL_NUMBER;

1513: l_category_id_tbl PO_TBL_NUMBER;
1514: l_new_price_tbl PO_TBL_NUMBER;
1515: l_old_price_tbl PO_TBL_NUMBER;
1516: l_new_line_flag_tbl PO_TBL_VARCHAR1;
1517: l_price_update_tolerance_tbl PO_TBL_NUMBER;
1518:
1519: l_return_status VARCHAR2(1);
1520:
1521: BEGIN

Line 3208: p_line_id_list IN PO_TBL_NUMBER,

3204: --End of Comments
3205: ------------------------------------------------------------------------
3206: PROCEDURE cascade_change_acceptance
3207: ( p_draft_id IN NUMBER,
3208: p_line_id_list IN PO_TBL_NUMBER,
3209: p_change_accepted_value IN VARCHAR2,
3210: x_return_status OUT NOCOPY VARCHAR2
3211: ) IS
3212:

Line 3333: p_reject_line_id_list IN PO_TBL_NUMBER,

3329: --End of Comments
3330: ------------------------------------------------------------------------
3331: PROCEDURE validate_disposition
3332: ( p_draft_id IN NUMBER,
3333: p_reject_line_id_list IN PO_TBL_NUMBER,
3334: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
3335: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
3336: x_return_status OUT NOCOPY VARCHAR2
3337: ) IS

Line 3334: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,

3330: ------------------------------------------------------------------------
3331: PROCEDURE validate_disposition
3332: ( p_draft_id IN NUMBER,
3333: p_reject_line_id_list IN PO_TBL_NUMBER,
3334: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
3335: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
3336: x_return_status OUT NOCOPY VARCHAR2
3337: ) IS
3338:

Line 3335: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,

3331: PROCEDURE validate_disposition
3332: ( p_draft_id IN NUMBER,
3333: p_reject_line_id_list IN PO_TBL_NUMBER,
3334: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
3335: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
3336: x_return_status OUT NOCOPY VARCHAR2
3337: ) IS
3338:
3339: d_api_name CONSTANT VARCHAR2(30) := 'validate_disposition';

Line 3355: x_invalid_line_id_list := PO_TBL_NUMBER();

3351: IF (PO_LOG.d_proc) THEN
3352: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
3353: END IF;
3354:
3355: x_invalid_line_id_list := PO_TBL_NUMBER();
3356:
3357: IF (p_reject_line_id_list IS NULL OR
3358: p_reject_line_id_list.COUNT = 0) THEN
3359: RETURN;