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

Line 1689: L_DIST_ID_TBL PO_TBL_NUMBER;

1685: L_HEADER_ID NUMBER,
1686: L_DRAFT_ID NUMBER
1687: )
1688: IS
1689: L_DIST_ID_TBL PO_TBL_NUMBER;
1690: L_CHARGE_ACC_TBL PO_TBL_NUMBER;
1691: L_ACRN_TBL PO_TBL_VARCHAR30;
1692: X_ACRN_TBL PO_TBL_VARCHAR30;
1693: X_RETURN_STATUS VARCHAR2(1);

Line 1690: L_CHARGE_ACC_TBL PO_TBL_NUMBER;

1686: L_DRAFT_ID NUMBER
1687: )
1688: IS
1689: L_DIST_ID_TBL PO_TBL_NUMBER;
1690: L_CHARGE_ACC_TBL PO_TBL_NUMBER;
1691: L_ACRN_TBL PO_TBL_VARCHAR30;
1692: X_ACRN_TBL PO_TBL_VARCHAR30;
1693: X_RETURN_STATUS VARCHAR2(1);
1694: X_RETURN_MESSAGE PO_TBL_VARCHAR2000;

Line 1804: L_LINE_LOC_ID_TBL PO_TBL_NUMBER;

1800: L_ORG_ID NUMBER;
1801: l_is_ACRN_enabled VARCHAR2(1);
1802:
1803:
1804: L_LINE_LOC_ID_TBL PO_TBL_NUMBER;
1805: L_LINE_ID_TBL PO_TBL_NUMBER;
1806: L_DIST_ID_TBL PO_TBL_NUMBER;
1807:
1808: L_JL_INSTALLED VARCHAR2(30);

Line 1805: L_LINE_ID_TBL PO_TBL_NUMBER;

1801: l_is_ACRN_enabled VARCHAR2(1);
1802:
1803:
1804: L_LINE_LOC_ID_TBL PO_TBL_NUMBER;
1805: L_LINE_ID_TBL PO_TBL_NUMBER;
1806: L_DIST_ID_TBL PO_TBL_NUMBER;
1807:
1808: L_JL_INSTALLED VARCHAR2(30);
1809:

Line 1806: L_DIST_ID_TBL PO_TBL_NUMBER;

1802:
1803:
1804: L_LINE_LOC_ID_TBL PO_TBL_NUMBER;
1805: L_LINE_ID_TBL PO_TBL_NUMBER;
1806: L_DIST_ID_TBL PO_TBL_NUMBER;
1807:
1808: L_JL_INSTALLED VARCHAR2(30);
1809:
1810: BEGIN

Line 2468: p_requisition_line_id IN PO_TBL_NUMBER,

2464: --END OF COMMENTS
2465:
2466: PROCEDURE REMOVE_FROM_REQ_POOL
2467: (
2468: p_requisition_line_id IN PO_TBL_NUMBER,
2469: p_requisition_header_id IN PO_TBL_NUMBER,
2470: x_return_status OUT NOCOPY VARCHAR2,
2471: x_error_msg OUT NOCOPY VARCHAR2
2472: ) IS

Line 2469: p_requisition_header_id IN PO_TBL_NUMBER,

2465:
2466: PROCEDURE REMOVE_FROM_REQ_POOL
2467: (
2468: p_requisition_line_id IN PO_TBL_NUMBER,
2469: p_requisition_header_id IN PO_TBL_NUMBER,
2470: x_return_status OUT NOCOPY VARCHAR2,
2471: x_error_msg OUT NOCOPY VARCHAR2
2472: ) IS
2473:

Line 2561: po_line_loc_id_tbl PO_TBL_NUMBER;

2557: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2558: d_position NUMBER;
2559:
2560: l_draft_id NUMBER;
2561: po_line_loc_id_tbl PO_TBL_NUMBER;
2562: po_line_id_tbl PO_TBL_NUMBER;
2563: draft_id_tbl PO_TBL_NUMBER;
2564: delete_flag_tbl PO_TBL_VARCHAR1;
2565: x_record_already_exist_tbl PO_TBL_VARCHAR1;

Line 2562: po_line_id_tbl PO_TBL_NUMBER;

2558: d_position NUMBER;
2559:
2560: l_draft_id NUMBER;
2561: po_line_loc_id_tbl PO_TBL_NUMBER;
2562: po_line_id_tbl PO_TBL_NUMBER;
2563: draft_id_tbl PO_TBL_NUMBER;
2564: delete_flag_tbl PO_TBL_VARCHAR1;
2565: x_record_already_exist_tbl PO_TBL_VARCHAR1;
2566:

Line 2563: draft_id_tbl PO_TBL_NUMBER;

2559:
2560: l_draft_id NUMBER;
2561: po_line_loc_id_tbl PO_TBL_NUMBER;
2562: po_line_id_tbl PO_TBL_NUMBER;
2563: draft_id_tbl PO_TBL_NUMBER;
2564: delete_flag_tbl PO_TBL_VARCHAR1;
2565: x_record_already_exist_tbl PO_TBL_VARCHAR1;
2566:
2567: BEGIN

Line 2715: L_REQ_LINE_ID_TBL PO_TBL_NUMBER;

2711: IS
2712: D_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_AND_VAL_LINKED_REQ_DIST';
2713: D_MODULE CONSTANT VARCHAR2(2000) := D_PKG_NAME || D_API_NAME || '.';
2714: D_POSITION NUMBER;
2715: L_REQ_LINE_ID_TBL PO_TBL_NUMBER;
2716: L_REQ_HEADER_ID_TBL PO_TBL_NUMBER;
2717:
2718: L_RESULT_TYPE VARCHAR2(20);
2719:

Line 2716: L_REQ_HEADER_ID_TBL PO_TBL_NUMBER;

2712: D_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_AND_VAL_LINKED_REQ_DIST';
2713: D_MODULE CONSTANT VARCHAR2(2000) := D_PKG_NAME || D_API_NAME || '.';
2714: D_POSITION NUMBER;
2715: L_REQ_LINE_ID_TBL PO_TBL_NUMBER;
2716: L_REQ_HEADER_ID_TBL PO_TBL_NUMBER;
2717:
2718: L_RESULT_TYPE VARCHAR2(20);
2719:
2720: BEGIN