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

Line 5645: p_vendor_id_list IN po_tbl_number,

5641: --End of Comments
5642: --------------------------------------------------------------------------------
5643: FUNCTION is_dup_vendor_record(p_vendor_id IN NUMBER,
5644: p_vendor_site_id IN NUMBER,
5645: p_vendor_id_list IN po_tbl_number,
5646: p_vendor_site_id_list IN po_tbl_number)
5647: RETURN BOOLEAN
5648: IS
5649: BEGIN

Line 5646: p_vendor_site_id_list IN po_tbl_number)

5642: --------------------------------------------------------------------------------
5643: FUNCTION is_dup_vendor_record(p_vendor_id IN NUMBER,
5644: p_vendor_site_id IN NUMBER,
5645: p_vendor_id_list IN po_tbl_number,
5646: p_vendor_site_id_list IN po_tbl_number)
5647: RETURN BOOLEAN
5648: IS
5649: BEGIN
5650: IF (p_vendor_id_list.FIRST IS NOT NULL) THEN

Line 5720: PROCEDURE validate_vendor_sites(px_vendor_site_id_list IN OUT NOCOPY po_tbl_number)

5716: --Notes : None
5717: --Testing : None
5718: --End of Comments
5719: --------------------------------------------------------------------------------
5720: PROCEDURE validate_vendor_sites(px_vendor_site_id_list IN OUT NOCOPY po_tbl_number)
5721: IS
5722: l_vendor_site_status VARCHAR2(20);
5723: BEGIN
5724: IF (px_vendor_site_id_list.FIRST IS NULL) THEN

Line 5815: x_vendor_id OUT NOCOPY po_tbl_number,

5811: p_destination_org_id IN NUMBER,
5812: p_api_version IN NUMBER,
5813: -- Bug# 3404477: Follow the API standards
5814: p_init_msg_list IN VARCHAR2,
5815: x_vendor_id OUT NOCOPY po_tbl_number,
5816: x_vendor_site_id OUT NOCOPY po_tbl_number,
5817: x_vendor_contact_id OUT NOCOPY po_tbl_number,
5818: x_src_doc_header_id OUT NOCOPY po_tbl_number,
5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,

Line 5816: x_vendor_site_id OUT NOCOPY po_tbl_number,

5812: p_api_version IN NUMBER,
5813: -- Bug# 3404477: Follow the API standards
5814: p_init_msg_list IN VARCHAR2,
5815: x_vendor_id OUT NOCOPY po_tbl_number,
5816: x_vendor_site_id OUT NOCOPY po_tbl_number,
5817: x_vendor_contact_id OUT NOCOPY po_tbl_number,
5818: x_src_doc_header_id OUT NOCOPY po_tbl_number,
5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,
5820: x_src_doc_line_num OUT NOCOPY po_tbl_number,

Line 5817: x_vendor_contact_id OUT NOCOPY po_tbl_number,

5813: -- Bug# 3404477: Follow the API standards
5814: p_init_msg_list IN VARCHAR2,
5815: x_vendor_id OUT NOCOPY po_tbl_number,
5816: x_vendor_site_id OUT NOCOPY po_tbl_number,
5817: x_vendor_contact_id OUT NOCOPY po_tbl_number,
5818: x_src_doc_header_id OUT NOCOPY po_tbl_number,
5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,
5820: x_src_doc_line_num OUT NOCOPY po_tbl_number,
5821: x_src_doc_type_code OUT NOCOPY po_tbl_varchar30,

Line 5818: x_src_doc_header_id OUT NOCOPY po_tbl_number,

5814: p_init_msg_list IN VARCHAR2,
5815: x_vendor_id OUT NOCOPY po_tbl_number,
5816: x_vendor_site_id OUT NOCOPY po_tbl_number,
5817: x_vendor_contact_id OUT NOCOPY po_tbl_number,
5818: x_src_doc_header_id OUT NOCOPY po_tbl_number,
5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,
5820: x_src_doc_line_num OUT NOCOPY po_tbl_number,
5821: x_src_doc_type_code OUT NOCOPY po_tbl_varchar30,
5822: x_base_price OUT NOCOPY po_tbl_number,

Line 5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,

5815: x_vendor_id OUT NOCOPY po_tbl_number,
5816: x_vendor_site_id OUT NOCOPY po_tbl_number,
5817: x_vendor_contact_id OUT NOCOPY po_tbl_number,
5818: x_src_doc_header_id OUT NOCOPY po_tbl_number,
5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,
5820: x_src_doc_line_num OUT NOCOPY po_tbl_number,
5821: x_src_doc_type_code OUT NOCOPY po_tbl_varchar30,
5822: x_base_price OUT NOCOPY po_tbl_number,
5823: x_currency_price OUT NOCOPY po_tbl_number,

Line 5820: x_src_doc_line_num OUT NOCOPY po_tbl_number,

5816: x_vendor_site_id OUT NOCOPY po_tbl_number,
5817: x_vendor_contact_id OUT NOCOPY po_tbl_number,
5818: x_src_doc_header_id OUT NOCOPY po_tbl_number,
5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,
5820: x_src_doc_line_num OUT NOCOPY po_tbl_number,
5821: x_src_doc_type_code OUT NOCOPY po_tbl_varchar30,
5822: x_base_price OUT NOCOPY po_tbl_number,
5823: x_currency_price OUT NOCOPY po_tbl_number,
5824: x_currency_code OUT NOCOPY po_tbl_varchar15,

Line 5822: x_base_price OUT NOCOPY po_tbl_number,

5818: x_src_doc_header_id OUT NOCOPY po_tbl_number,
5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,
5820: x_src_doc_line_num OUT NOCOPY po_tbl_number,
5821: x_src_doc_type_code OUT NOCOPY po_tbl_varchar30,
5822: x_base_price OUT NOCOPY po_tbl_number,
5823: x_currency_price OUT NOCOPY po_tbl_number,
5824: x_currency_code OUT NOCOPY po_tbl_varchar15,
5825: x_unit_of_measure OUT NOCOPY po_tbl_varchar25,
5826: x_price_override_flag OUT NOCOPY po_tbl_varchar1,

Line 5823: x_currency_price OUT NOCOPY po_tbl_number,

5819: x_src_doc_line_id OUT NOCOPY po_tbl_number,
5820: x_src_doc_line_num OUT NOCOPY po_tbl_number,
5821: x_src_doc_type_code OUT NOCOPY po_tbl_varchar30,
5822: x_base_price OUT NOCOPY po_tbl_number,
5823: x_currency_price OUT NOCOPY po_tbl_number,
5824: x_currency_code OUT NOCOPY po_tbl_varchar15,
5825: x_unit_of_measure OUT NOCOPY po_tbl_varchar25,
5826: x_price_override_flag OUT NOCOPY po_tbl_varchar1,
5827: x_not_to_exceed_price OUT NOCOPY po_tbl_number,

Line 5827: x_not_to_exceed_price OUT NOCOPY po_tbl_number,

5823: x_currency_price OUT NOCOPY po_tbl_number,
5824: x_currency_code OUT NOCOPY po_tbl_varchar15,
5825: x_unit_of_measure OUT NOCOPY po_tbl_varchar25,
5826: x_price_override_flag OUT NOCOPY po_tbl_varchar1,
5827: x_not_to_exceed_price OUT NOCOPY po_tbl_number,
5828: x_price_break_id OUT NOCOPY po_tbl_number,
5829: x_price_differential_flag OUT NOCOPY po_tbl_varchar1,
5830: x_rate_type OUT NOCOPY po_tbl_varchar30,
5831: x_rate_date OUT NOCOPY po_tbl_date,

Line 5828: x_price_break_id OUT NOCOPY po_tbl_number,

5824: x_currency_code OUT NOCOPY po_tbl_varchar15,
5825: x_unit_of_measure OUT NOCOPY po_tbl_varchar25,
5826: x_price_override_flag OUT NOCOPY po_tbl_varchar1,
5827: x_not_to_exceed_price OUT NOCOPY po_tbl_number,
5828: x_price_break_id OUT NOCOPY po_tbl_number,
5829: x_price_differential_flag OUT NOCOPY po_tbl_varchar1,
5830: x_rate_type OUT NOCOPY po_tbl_varchar30,
5831: x_rate_date OUT NOCOPY po_tbl_date,
5832: x_rate OUT NOCOPY po_tbl_number,

Line 5832: x_rate OUT NOCOPY po_tbl_number,

5828: x_price_break_id OUT NOCOPY po_tbl_number,
5829: x_price_differential_flag OUT NOCOPY po_tbl_varchar1,
5830: x_rate_type OUT NOCOPY po_tbl_varchar30,
5831: x_rate_date OUT NOCOPY po_tbl_date,
5832: x_rate OUT NOCOPY po_tbl_number,
5833: x_return_status OUT NOCOPY VARCHAR2,
5834: -- Bug# 3404477: Return msg count and data
5835: x_msg_count OUT NOCOPY NUMBER,
5836: x_msg_data OUT NOCOPY VARCHAR2

Line 6077: x_asl_id po_tbl_number;

6073: l_api_name VARCHAR2(60) := 'get_services_asl_list';
6074: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
6075: l_progress VARCHAR2(3) := '000';
6076:
6077: x_asl_id po_tbl_number;
6078: l_sysdate DATE := trunc(sysdate); -- Bug 3282423
6079:
6080: -- Bug# 3379053
6081: l_supplier_site_status VARCHAR2(20);

Line 6082: l_vendor_id_list po_tbl_number := po_tbl_number();

6078: l_sysdate DATE := trunc(sysdate); -- Bug 3282423
6079:
6080: -- Bug# 3379053
6081: l_supplier_site_status VARCHAR2(20);
6082: l_vendor_id_list po_tbl_number := po_tbl_number();
6083: l_vendor_site_id_list po_tbl_number := po_tbl_number();
6084: l_asl_id_list po_tbl_number := po_tbl_number();
6085: l_count NUMBER;
6086: l_prev_vendor_id NUMBER;

Line 6083: l_vendor_site_id_list po_tbl_number := po_tbl_number();

6079:
6080: -- Bug# 3379053
6081: l_supplier_site_status VARCHAR2(20);
6082: l_vendor_id_list po_tbl_number := po_tbl_number();
6083: l_vendor_site_id_list po_tbl_number := po_tbl_number();
6084: l_asl_id_list po_tbl_number := po_tbl_number();
6085: l_count NUMBER;
6086: l_prev_vendor_id NUMBER;
6087: l_prev_vendor_site_id NUMBER;

Line 6084: l_asl_id_list po_tbl_number := po_tbl_number();

6080: -- Bug# 3379053
6081: l_supplier_site_status VARCHAR2(20);
6082: l_vendor_id_list po_tbl_number := po_tbl_number();
6083: l_vendor_site_id_list po_tbl_number := po_tbl_number();
6084: l_asl_id_list po_tbl_number := po_tbl_number();
6085: l_count NUMBER;
6086: l_prev_vendor_id NUMBER;
6087: l_prev_vendor_site_id NUMBER;
6088: l_current_vendor_id NUMBER;

Line 6105: x_vendor_id := po_tbl_number(); -- Bug# 3379053: Initialize x_vendor_id and

6101: PO_DEBUG.debug_var(l_log_head,l_progress,'p_api_version',p_api_version);
6102: END IF;
6103:
6104: -- Initialize the out parameter tables
6105: x_vendor_id := po_tbl_number(); -- Bug# 3379053: Initialize x_vendor_id and
6106: x_vendor_site_id := po_tbl_number(); -- x_vendor_site_id collections
6107: x_base_price := po_tbl_number();
6108: x_currency_price := po_tbl_number();
6109: x_currency_code := po_tbl_varchar15();

Line 6106: x_vendor_site_id := po_tbl_number(); -- x_vendor_site_id collections

6102: END IF;
6103:
6104: -- Initialize the out parameter tables
6105: x_vendor_id := po_tbl_number(); -- Bug# 3379053: Initialize x_vendor_id and
6106: x_vendor_site_id := po_tbl_number(); -- x_vendor_site_id collections
6107: x_base_price := po_tbl_number();
6108: x_currency_price := po_tbl_number();
6109: x_currency_code := po_tbl_varchar15();
6110: x_price_break_id := po_tbl_number();

Line 6107: x_base_price := po_tbl_number();

6103:
6104: -- Initialize the out parameter tables
6105: x_vendor_id := po_tbl_number(); -- Bug# 3379053: Initialize x_vendor_id and
6106: x_vendor_site_id := po_tbl_number(); -- x_vendor_site_id collections
6107: x_base_price := po_tbl_number();
6108: x_currency_price := po_tbl_number();
6109: x_currency_code := po_tbl_varchar15();
6110: x_price_break_id := po_tbl_number();
6111: x_price_differential_flag := po_tbl_varchar1();

Line 6108: x_currency_price := po_tbl_number();

6104: -- Initialize the out parameter tables
6105: x_vendor_id := po_tbl_number(); -- Bug# 3379053: Initialize x_vendor_id and
6106: x_vendor_site_id := po_tbl_number(); -- x_vendor_site_id collections
6107: x_base_price := po_tbl_number();
6108: x_currency_price := po_tbl_number();
6109: x_currency_code := po_tbl_varchar15();
6110: x_price_break_id := po_tbl_number();
6111: x_price_differential_flag := po_tbl_varchar1();
6112: x_rate_type := po_tbl_varchar30();

Line 6110: x_price_break_id := po_tbl_number();

6106: x_vendor_site_id := po_tbl_number(); -- x_vendor_site_id collections
6107: x_base_price := po_tbl_number();
6108: x_currency_price := po_tbl_number();
6109: x_currency_code := po_tbl_varchar15();
6110: x_price_break_id := po_tbl_number();
6111: x_price_differential_flag := po_tbl_varchar1();
6112: x_rate_type := po_tbl_varchar30();
6113: x_rate_date := po_tbl_date();
6114: x_rate := po_tbl_number();

Line 6114: x_rate := po_tbl_number();

6110: x_price_break_id := po_tbl_number();
6111: x_price_differential_flag := po_tbl_varchar1();
6112: x_rate_type := po_tbl_varchar30();
6113: x_rate_date := po_tbl_date();
6114: x_rate := po_tbl_number();
6115: x_vendor_contact_id := po_tbl_number();
6116: x_src_doc_header_id := po_tbl_number();
6117: x_src_doc_line_id := po_tbl_number();
6118: x_src_doc_line_num := po_tbl_number();

Line 6115: x_vendor_contact_id := po_tbl_number();

6111: x_price_differential_flag := po_tbl_varchar1();
6112: x_rate_type := po_tbl_varchar30();
6113: x_rate_date := po_tbl_date();
6114: x_rate := po_tbl_number();
6115: x_vendor_contact_id := po_tbl_number();
6116: x_src_doc_header_id := po_tbl_number();
6117: x_src_doc_line_id := po_tbl_number();
6118: x_src_doc_line_num := po_tbl_number();
6119: x_src_doc_type_code := po_tbl_varchar30();

Line 6116: x_src_doc_header_id := po_tbl_number();

6112: x_rate_type := po_tbl_varchar30();
6113: x_rate_date := po_tbl_date();
6114: x_rate := po_tbl_number();
6115: x_vendor_contact_id := po_tbl_number();
6116: x_src_doc_header_id := po_tbl_number();
6117: x_src_doc_line_id := po_tbl_number();
6118: x_src_doc_line_num := po_tbl_number();
6119: x_src_doc_type_code := po_tbl_varchar30();
6120: x_price_override_flag := po_tbl_varchar1();

Line 6117: x_src_doc_line_id := po_tbl_number();

6113: x_rate_date := po_tbl_date();
6114: x_rate := po_tbl_number();
6115: x_vendor_contact_id := po_tbl_number();
6116: x_src_doc_header_id := po_tbl_number();
6117: x_src_doc_line_id := po_tbl_number();
6118: x_src_doc_line_num := po_tbl_number();
6119: x_src_doc_type_code := po_tbl_varchar30();
6120: x_price_override_flag := po_tbl_varchar1();
6121: x_not_to_exceed_price := po_tbl_number();

Line 6118: x_src_doc_line_num := po_tbl_number();

6114: x_rate := po_tbl_number();
6115: x_vendor_contact_id := po_tbl_number();
6116: x_src_doc_header_id := po_tbl_number();
6117: x_src_doc_line_id := po_tbl_number();
6118: x_src_doc_line_num := po_tbl_number();
6119: x_src_doc_type_code := po_tbl_varchar30();
6120: x_price_override_flag := po_tbl_varchar1();
6121: x_not_to_exceed_price := po_tbl_number();
6122: x_unit_of_measure := po_tbl_varchar25();

Line 6121: x_not_to_exceed_price := po_tbl_number();

6117: x_src_doc_line_id := po_tbl_number();
6118: x_src_doc_line_num := po_tbl_number();
6119: x_src_doc_type_code := po_tbl_varchar30();
6120: x_price_override_flag := po_tbl_varchar1();
6121: x_not_to_exceed_price := po_tbl_number();
6122: x_unit_of_measure := po_tbl_varchar25();
6123:
6124: l_progress := '010';
6125: