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 1266: p_reject_line_id_list IN PO_TBL_NUMBER,

1262: --End of Comments
1263: ------------------------------------------------------------------------
1264: PROCEDURE record_disposition
1265: ( p_draft_id IN NUMBER,
1266: p_reject_line_id_list IN PO_TBL_NUMBER,
1267: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1268: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1269: x_return_status OUT NOCOPY VARCHAR2
1270: ) IS

Line 1267: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544

1263: ------------------------------------------------------------------------
1264: PROCEDURE record_disposition
1265: ( p_draft_id IN NUMBER,
1266: p_reject_line_id_list IN PO_TBL_NUMBER,
1267: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1268: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1269: x_return_status OUT NOCOPY VARCHAR2
1270: ) IS
1271:

Line 1268: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544

1264: PROCEDURE record_disposition
1265: ( p_draft_id IN NUMBER,
1266: p_reject_line_id_list IN PO_TBL_NUMBER,
1267: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1268: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER, -- bug5187544
1269: x_return_status OUT NOCOPY VARCHAR2
1270: ) IS
1271:
1272: d_api_name CONSTANT VARCHAR2(30) := 'record_disposition';

Line 1482: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1478: l_over_tolerance VARCHAR2(1);
1479:
1480: l_check_tolerance_index_tbl DBMS_SQL.NUMBER_TABLE;
1481:
1482: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1483: l_vendor_id_tbl PO_TBL_NUMBER;
1484: l_po_line_id_tbl PO_TBL_NUMBER;
1485: l_po_header_id_tbl PO_TBL_NUMBER;
1486: l_item_id_tbl PO_TBL_NUMBER;

Line 1483: l_vendor_id_tbl PO_TBL_NUMBER;

1479:
1480: l_check_tolerance_index_tbl DBMS_SQL.NUMBER_TABLE;
1481:
1482: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1483: l_vendor_id_tbl PO_TBL_NUMBER;
1484: l_po_line_id_tbl PO_TBL_NUMBER;
1485: l_po_header_id_tbl PO_TBL_NUMBER;
1486: l_item_id_tbl PO_TBL_NUMBER;
1487: l_category_id_tbl PO_TBL_NUMBER;

Line 1484: l_po_line_id_tbl PO_TBL_NUMBER;

1480: l_check_tolerance_index_tbl DBMS_SQL.NUMBER_TABLE;
1481:
1482: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1483: l_vendor_id_tbl PO_TBL_NUMBER;
1484: l_po_line_id_tbl PO_TBL_NUMBER;
1485: l_po_header_id_tbl PO_TBL_NUMBER;
1486: l_item_id_tbl PO_TBL_NUMBER;
1487: l_category_id_tbl PO_TBL_NUMBER;
1488: l_new_price_tbl PO_TBL_NUMBER;

Line 1485: l_po_header_id_tbl PO_TBL_NUMBER;

1481:
1482: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1483: l_vendor_id_tbl PO_TBL_NUMBER;
1484: l_po_line_id_tbl PO_TBL_NUMBER;
1485: l_po_header_id_tbl PO_TBL_NUMBER;
1486: l_item_id_tbl PO_TBL_NUMBER;
1487: l_category_id_tbl PO_TBL_NUMBER;
1488: l_new_price_tbl PO_TBL_NUMBER;
1489: l_old_price_tbl PO_TBL_NUMBER;

Line 1486: l_item_id_tbl PO_TBL_NUMBER;

1482: l_autoaccept_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1483: l_vendor_id_tbl PO_TBL_NUMBER;
1484: l_po_line_id_tbl PO_TBL_NUMBER;
1485: l_po_header_id_tbl PO_TBL_NUMBER;
1486: l_item_id_tbl PO_TBL_NUMBER;
1487: l_category_id_tbl PO_TBL_NUMBER;
1488: l_new_price_tbl PO_TBL_NUMBER;
1489: l_old_price_tbl PO_TBL_NUMBER;
1490: l_new_line_flag_tbl PO_TBL_VARCHAR1;

Line 1487: l_category_id_tbl PO_TBL_NUMBER;

1483: l_vendor_id_tbl PO_TBL_NUMBER;
1484: l_po_line_id_tbl PO_TBL_NUMBER;
1485: l_po_header_id_tbl PO_TBL_NUMBER;
1486: l_item_id_tbl PO_TBL_NUMBER;
1487: l_category_id_tbl PO_TBL_NUMBER;
1488: l_new_price_tbl PO_TBL_NUMBER;
1489: l_old_price_tbl PO_TBL_NUMBER;
1490: l_new_line_flag_tbl PO_TBL_VARCHAR1;
1491: l_price_update_tolerance_tbl PO_TBL_NUMBER;

Line 1488: l_new_price_tbl PO_TBL_NUMBER;

1484: l_po_line_id_tbl PO_TBL_NUMBER;
1485: l_po_header_id_tbl PO_TBL_NUMBER;
1486: l_item_id_tbl PO_TBL_NUMBER;
1487: l_category_id_tbl PO_TBL_NUMBER;
1488: l_new_price_tbl PO_TBL_NUMBER;
1489: l_old_price_tbl PO_TBL_NUMBER;
1490: l_new_line_flag_tbl PO_TBL_VARCHAR1;
1491: l_price_update_tolerance_tbl PO_TBL_NUMBER;
1492:

Line 1489: l_old_price_tbl PO_TBL_NUMBER;

1485: l_po_header_id_tbl PO_TBL_NUMBER;
1486: l_item_id_tbl PO_TBL_NUMBER;
1487: l_category_id_tbl PO_TBL_NUMBER;
1488: l_new_price_tbl PO_TBL_NUMBER;
1489: l_old_price_tbl PO_TBL_NUMBER;
1490: l_new_line_flag_tbl PO_TBL_VARCHAR1;
1491: l_price_update_tolerance_tbl PO_TBL_NUMBER;
1492:
1493: l_return_status VARCHAR2(1);

Line 1491: l_price_update_tolerance_tbl PO_TBL_NUMBER;

1487: l_category_id_tbl PO_TBL_NUMBER;
1488: l_new_price_tbl PO_TBL_NUMBER;
1489: l_old_price_tbl PO_TBL_NUMBER;
1490: l_new_line_flag_tbl PO_TBL_VARCHAR1;
1491: l_price_update_tolerance_tbl PO_TBL_NUMBER;
1492:
1493: l_return_status VARCHAR2(1);
1494:
1495: BEGIN

Line 3182: p_line_id_list IN PO_TBL_NUMBER,

3178: --End of Comments
3179: ------------------------------------------------------------------------
3180: PROCEDURE cascade_change_acceptance
3181: ( p_draft_id IN NUMBER,
3182: p_line_id_list IN PO_TBL_NUMBER,
3183: p_change_accepted_value IN VARCHAR2,
3184: x_return_status OUT NOCOPY VARCHAR2
3185: ) IS
3186:

Line 3307: p_reject_line_id_list IN PO_TBL_NUMBER,

3303: --End of Comments
3304: ------------------------------------------------------------------------
3305: PROCEDURE validate_disposition
3306: ( p_draft_id IN NUMBER,
3307: p_reject_line_id_list IN PO_TBL_NUMBER,
3308: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
3309: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
3310: x_return_status OUT NOCOPY VARCHAR2
3311: ) IS

Line 3308: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,

3304: ------------------------------------------------------------------------
3305: PROCEDURE validate_disposition
3306: ( p_draft_id IN NUMBER,
3307: p_reject_line_id_list IN PO_TBL_NUMBER,
3308: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
3309: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
3310: x_return_status OUT NOCOPY VARCHAR2
3311: ) IS
3312:

Line 3309: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,

3305: PROCEDURE validate_disposition
3306: ( p_draft_id IN NUMBER,
3307: p_reject_line_id_list IN PO_TBL_NUMBER,
3308: x_invalid_line_id_list OUT NOCOPY PO_TBL_NUMBER,
3309: x_invalid_line_num_list OUT NOCOPY PO_TBL_NUMBER,
3310: x_return_status OUT NOCOPY VARCHAR2
3311: ) IS
3312:
3313: d_api_name CONSTANT VARCHAR2(30) := 'validate_disposition';

Line 3329: x_invalid_line_id_list := PO_TBL_NUMBER();

3325: IF (PO_LOG.d_proc) THEN
3326: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
3327: END IF;
3328:
3329: x_invalid_line_id_list := PO_TBL_NUMBER();
3330:
3331: IF (p_reject_line_id_list IS NULL OR
3332: p_reject_line_id_list.COUNT = 0) THEN
3333: RETURN;