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_DOCUMENT_CHECKS_PVT dependencies on PO_TBL_VARCHAR30

Line 118: p_vendor_order_num IN PO_TBL_VARCHAR30,

114: PROCEDURE complete_po_header_id_tbl
115: ( p_count IN NUMBER,
116: p_header_id IN PO_TBL_NUMBER,
117: p_release_id IN PO_TBL_NUMBER,
118: p_vendor_order_num IN PO_TBL_VARCHAR30,
119: p_document_num IN PO_TBL_VARCHAR30,
120: p_type_lookup_code IN PO_TBL_VARCHAR30,
121: x_header_id OUT NOCOPY PO_TBL_NUMBER
122: );

Line 119: p_document_num IN PO_TBL_VARCHAR30,

115: ( p_count IN NUMBER,
116: p_header_id IN PO_TBL_NUMBER,
117: p_release_id IN PO_TBL_NUMBER,
118: p_vendor_order_num IN PO_TBL_VARCHAR30,
119: p_document_num IN PO_TBL_VARCHAR30,
120: p_type_lookup_code IN PO_TBL_VARCHAR30,
121: x_header_id OUT NOCOPY PO_TBL_NUMBER
122: );
123: -- bug3592160 END

Line 120: p_type_lookup_code IN PO_TBL_VARCHAR30,

116: p_header_id IN PO_TBL_NUMBER,
117: p_release_id IN PO_TBL_NUMBER,
118: p_vendor_order_num IN PO_TBL_VARCHAR30,
119: p_document_num IN PO_TBL_VARCHAR30,
120: p_type_lookup_code IN PO_TBL_VARCHAR30,
121: x_header_id OUT NOCOPY PO_TBL_NUMBER
122: );
123: -- bug3592160 END
124:

Line 12673: p_document_type IN PO_TBL_VARCHAR30,

12669: PROCEDURE check_updatable (
12670: p_count IN NUMBER,
12671: p_header_id IN PO_TBL_NUMBER,
12672: p_release_id IN PO_TBL_NUMBER,
12673: p_document_type IN PO_TBL_VARCHAR30,
12674: p_document_subtype IN PO_TBL_VARCHAR30,
12675: p_document_num IN PO_TBL_VARCHAR30,
12676: p_vendor_order_num IN PO_TBL_VARCHAR30,
12677: p_line_id IN PO_TBL_NUMBER,

Line 12674: p_document_subtype IN PO_TBL_VARCHAR30,

12670: p_count IN NUMBER,
12671: p_header_id IN PO_TBL_NUMBER,
12672: p_release_id IN PO_TBL_NUMBER,
12673: p_document_type IN PO_TBL_VARCHAR30,
12674: p_document_subtype IN PO_TBL_VARCHAR30,
12675: p_document_num IN PO_TBL_VARCHAR30,
12676: p_vendor_order_num IN PO_TBL_VARCHAR30,
12677: p_line_id IN PO_TBL_NUMBER,
12678: p_line_location_id IN PO_TBL_NUMBER,

Line 12675: p_document_num IN PO_TBL_VARCHAR30,

12671: p_header_id IN PO_TBL_NUMBER,
12672: p_release_id IN PO_TBL_NUMBER,
12673: p_document_type IN PO_TBL_VARCHAR30,
12674: p_document_subtype IN PO_TBL_VARCHAR30,
12675: p_document_num IN PO_TBL_VARCHAR30,
12676: p_vendor_order_num IN PO_TBL_VARCHAR30,
12677: p_line_id IN PO_TBL_NUMBER,
12678: p_line_location_id IN PO_TBL_NUMBER,
12679: p_distribution_id IN PO_TBL_NUMBER,

Line 12676: p_vendor_order_num IN PO_TBL_VARCHAR30,

12672: p_release_id IN PO_TBL_NUMBER,
12673: p_document_type IN PO_TBL_VARCHAR30,
12674: p_document_subtype IN PO_TBL_VARCHAR30,
12675: p_document_num IN PO_TBL_VARCHAR30,
12676: p_vendor_order_num IN PO_TBL_VARCHAR30,
12677: p_line_id IN PO_TBL_NUMBER,
12678: p_line_location_id IN PO_TBL_NUMBER,
12679: p_distribution_id IN PO_TBL_NUMBER,
12680: p_lock_flag IN VARCHAR2 := 'N',

Line 12910: p_document_type IN PO_TBL_VARCHAR30,

12906: PROCEDURE check_reservable (
12907: p_count IN NUMBER,
12908: p_header_id IN PO_TBL_NUMBER,
12909: p_release_id IN PO_TBL_NUMBER,
12910: p_document_type IN PO_TBL_VARCHAR30,
12911: p_document_subtype IN PO_TBL_VARCHAR30,
12912: p_document_num IN PO_TBL_VARCHAR30,
12913: p_vendor_order_num IN PO_TBL_VARCHAR30,
12914: p_line_id IN PO_TBL_NUMBER,

Line 12911: p_document_subtype IN PO_TBL_VARCHAR30,

12907: p_count IN NUMBER,
12908: p_header_id IN PO_TBL_NUMBER,
12909: p_release_id IN PO_TBL_NUMBER,
12910: p_document_type IN PO_TBL_VARCHAR30,
12911: p_document_subtype IN PO_TBL_VARCHAR30,
12912: p_document_num IN PO_TBL_VARCHAR30,
12913: p_vendor_order_num IN PO_TBL_VARCHAR30,
12914: p_line_id IN PO_TBL_NUMBER,
12915: p_line_location_id IN PO_TBL_NUMBER,

Line 12912: p_document_num IN PO_TBL_VARCHAR30,

12908: p_header_id IN PO_TBL_NUMBER,
12909: p_release_id IN PO_TBL_NUMBER,
12910: p_document_type IN PO_TBL_VARCHAR30,
12911: p_document_subtype IN PO_TBL_VARCHAR30,
12912: p_document_num IN PO_TBL_VARCHAR30,
12913: p_vendor_order_num IN PO_TBL_VARCHAR30,
12914: p_line_id IN PO_TBL_NUMBER,
12915: p_line_location_id IN PO_TBL_NUMBER,
12916: p_distribution_id IN PO_TBL_NUMBER,

Line 12913: p_vendor_order_num IN PO_TBL_VARCHAR30,

12909: p_release_id IN PO_TBL_NUMBER,
12910: p_document_type IN PO_TBL_VARCHAR30,
12911: p_document_subtype IN PO_TBL_VARCHAR30,
12912: p_document_num IN PO_TBL_VARCHAR30,
12913: p_vendor_order_num IN PO_TBL_VARCHAR30,
12914: p_line_id IN PO_TBL_NUMBER,
12915: p_line_location_id IN PO_TBL_NUMBER,
12916: p_distribution_id IN PO_TBL_NUMBER,
12917: p_lock_flag IN VARCHAR2 := 'N',

Line 13083: p_document_type IN PO_TBL_VARCHAR30,

13079: PROCEDURE check_unreservable (
13080: p_count IN NUMBER,
13081: p_header_id IN PO_TBL_NUMBER,
13082: p_release_id IN PO_TBL_NUMBER,
13083: p_document_type IN PO_TBL_VARCHAR30,
13084: p_document_subtype IN PO_TBL_VARCHAR30,
13085: p_document_num IN PO_TBL_VARCHAR30,
13086: p_vendor_order_num IN PO_TBL_VARCHAR30,
13087: p_line_id IN PO_TBL_NUMBER,

Line 13084: p_document_subtype IN PO_TBL_VARCHAR30,

13080: p_count IN NUMBER,
13081: p_header_id IN PO_TBL_NUMBER,
13082: p_release_id IN PO_TBL_NUMBER,
13083: p_document_type IN PO_TBL_VARCHAR30,
13084: p_document_subtype IN PO_TBL_VARCHAR30,
13085: p_document_num IN PO_TBL_VARCHAR30,
13086: p_vendor_order_num IN PO_TBL_VARCHAR30,
13087: p_line_id IN PO_TBL_NUMBER,
13088: p_line_location_id IN PO_TBL_NUMBER,

Line 13085: p_document_num IN PO_TBL_VARCHAR30,

13081: p_header_id IN PO_TBL_NUMBER,
13082: p_release_id IN PO_TBL_NUMBER,
13083: p_document_type IN PO_TBL_VARCHAR30,
13084: p_document_subtype IN PO_TBL_VARCHAR30,
13085: p_document_num IN PO_TBL_VARCHAR30,
13086: p_vendor_order_num IN PO_TBL_VARCHAR30,
13087: p_line_id IN PO_TBL_NUMBER,
13088: p_line_location_id IN PO_TBL_NUMBER,
13089: p_distribution_id IN PO_TBL_NUMBER,

Line 13086: p_vendor_order_num IN PO_TBL_VARCHAR30,

13082: p_release_id IN PO_TBL_NUMBER,
13083: p_document_type IN PO_TBL_VARCHAR30,
13084: p_document_subtype IN PO_TBL_VARCHAR30,
13085: p_document_num IN PO_TBL_VARCHAR30,
13086: p_vendor_order_num IN PO_TBL_VARCHAR30,
13087: p_line_id IN PO_TBL_NUMBER,
13088: p_line_location_id IN PO_TBL_NUMBER,
13089: p_distribution_id IN PO_TBL_NUMBER,
13090: p_lock_flag IN VARCHAR2 := 'N',

Line 13253: p_document_type IN PO_TBL_VARCHAR30,

13249: PROCEDURE get_status (
13250: p_count IN NUMBER,
13251: p_header_id IN PO_TBL_NUMBER,
13252: p_release_id IN PO_TBL_NUMBER,
13253: p_document_type IN PO_TBL_VARCHAR30,
13254: p_document_subtype IN PO_TBL_VARCHAR30,
13255: p_document_num IN PO_TBL_VARCHAR30,
13256: p_vendor_order_num IN PO_TBL_VARCHAR30,
13257: p_line_id IN PO_TBL_NUMBER,

Line 13254: p_document_subtype IN PO_TBL_VARCHAR30,

13250: p_count IN NUMBER,
13251: p_header_id IN PO_TBL_NUMBER,
13252: p_release_id IN PO_TBL_NUMBER,
13253: p_document_type IN PO_TBL_VARCHAR30,
13254: p_document_subtype IN PO_TBL_VARCHAR30,
13255: p_document_num IN PO_TBL_VARCHAR30,
13256: p_vendor_order_num IN PO_TBL_VARCHAR30,
13257: p_line_id IN PO_TBL_NUMBER,
13258: p_line_location_id IN PO_TBL_NUMBER,

Line 13255: p_document_num IN PO_TBL_VARCHAR30,

13251: p_header_id IN PO_TBL_NUMBER,
13252: p_release_id IN PO_TBL_NUMBER,
13253: p_document_type IN PO_TBL_VARCHAR30,
13254: p_document_subtype IN PO_TBL_VARCHAR30,
13255: p_document_num IN PO_TBL_VARCHAR30,
13256: p_vendor_order_num IN PO_TBL_VARCHAR30,
13257: p_line_id IN PO_TBL_NUMBER,
13258: p_line_location_id IN PO_TBL_NUMBER,
13259: p_distribution_id IN PO_TBL_NUMBER,

Line 13256: p_vendor_order_num IN PO_TBL_VARCHAR30,

13252: p_release_id IN PO_TBL_NUMBER,
13253: p_document_type IN PO_TBL_VARCHAR30,
13254: p_document_subtype IN PO_TBL_VARCHAR30,
13255: p_document_num IN PO_TBL_VARCHAR30,
13256: p_vendor_order_num IN PO_TBL_VARCHAR30,
13257: p_line_id IN PO_TBL_NUMBER,
13258: p_line_location_id IN PO_TBL_NUMBER,
13259: p_distribution_id IN PO_TBL_NUMBER,
13260: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 13455: p_document_type IN PO_TBL_VARCHAR30,

13451: PROCEDURE po_status_check (
13452: p_api_version IN NUMBER,
13453: p_header_id IN PO_TBL_NUMBER,
13454: p_release_id IN PO_TBL_NUMBER,
13455: p_document_type IN PO_TBL_VARCHAR30,
13456: p_document_subtype IN PO_TBL_VARCHAR30,
13457: p_document_num IN PO_TBL_VARCHAR30,
13458: p_vendor_order_num IN PO_TBL_VARCHAR30,
13459: p_line_id IN PO_TBL_NUMBER,

Line 13456: p_document_subtype IN PO_TBL_VARCHAR30,

13452: p_api_version IN NUMBER,
13453: p_header_id IN PO_TBL_NUMBER,
13454: p_release_id IN PO_TBL_NUMBER,
13455: p_document_type IN PO_TBL_VARCHAR30,
13456: p_document_subtype IN PO_TBL_VARCHAR30,
13457: p_document_num IN PO_TBL_VARCHAR30,
13458: p_vendor_order_num IN PO_TBL_VARCHAR30,
13459: p_line_id IN PO_TBL_NUMBER,
13460: p_line_location_id IN PO_TBL_NUMBER,

Line 13457: p_document_num IN PO_TBL_VARCHAR30,

13453: p_header_id IN PO_TBL_NUMBER,
13454: p_release_id IN PO_TBL_NUMBER,
13455: p_document_type IN PO_TBL_VARCHAR30,
13456: p_document_subtype IN PO_TBL_VARCHAR30,
13457: p_document_num IN PO_TBL_VARCHAR30,
13458: p_vendor_order_num IN PO_TBL_VARCHAR30,
13459: p_line_id IN PO_TBL_NUMBER,
13460: p_line_location_id IN PO_TBL_NUMBER,
13461: p_distribution_id IN PO_TBL_NUMBER,

Line 13458: p_vendor_order_num IN PO_TBL_VARCHAR30,

13454: p_release_id IN PO_TBL_NUMBER,
13455: p_document_type IN PO_TBL_VARCHAR30,
13456: p_document_subtype IN PO_TBL_VARCHAR30,
13457: p_document_num IN PO_TBL_VARCHAR30,
13458: p_vendor_order_num IN PO_TBL_VARCHAR30,
13459: p_line_id IN PO_TBL_NUMBER,
13460: p_line_location_id IN PO_TBL_NUMBER,
13461: p_distribution_id IN PO_TBL_NUMBER,
13462: p_mode IN VARCHAR2,

Line 14710: l_period_name_tbl po_tbl_varchar30;

14706: l_line_num_tbl po_tbl_number;
14707: l_shipment_num_tbl po_tbl_number;
14708: l_distribution_num_tbl po_tbl_number;
14709:
14710: l_period_name_tbl po_tbl_varchar30;
14711: l_period_year_tbl po_tbl_number;
14712: l_period_num_tbl po_tbl_number;
14713: l_quarter_num_tbl po_tbl_number;
14714: l_invalid_period_flag VARCHAR2(1);

Line 15029: p_vendor_order_num IN PO_TBL_VARCHAR30,

15025: PROCEDURE complete_po_header_id_tbl
15026: ( p_count IN NUMBER,
15027: p_header_id IN PO_TBL_NUMBER,
15028: p_release_id IN PO_TBL_NUMBER,
15029: p_vendor_order_num IN PO_TBL_VARCHAR30,
15030: p_document_num IN PO_TBL_VARCHAR30,
15031: p_type_lookup_code IN PO_TBL_VARCHAR30,
15032: x_header_id OUT NOCOPY PO_TBL_NUMBER
15033: ) IS

Line 15030: p_document_num IN PO_TBL_VARCHAR30,

15026: ( p_count IN NUMBER,
15027: p_header_id IN PO_TBL_NUMBER,
15028: p_release_id IN PO_TBL_NUMBER,
15029: p_vendor_order_num IN PO_TBL_VARCHAR30,
15030: p_document_num IN PO_TBL_VARCHAR30,
15031: p_type_lookup_code IN PO_TBL_VARCHAR30,
15032: x_header_id OUT NOCOPY PO_TBL_NUMBER
15033: ) IS
15034:

Line 15031: p_type_lookup_code IN PO_TBL_VARCHAR30,

15027: p_header_id IN PO_TBL_NUMBER,
15028: p_release_id IN PO_TBL_NUMBER,
15029: p_vendor_order_num IN PO_TBL_VARCHAR30,
15030: p_document_num IN PO_TBL_VARCHAR30,
15031: p_type_lookup_code IN PO_TBL_VARCHAR30,
15032: x_header_id OUT NOCOPY PO_TBL_NUMBER
15033: ) IS
15034:
15035: l_api_name CONSTANT VARCHAR2(30) := 'COMPLETE_PO_HEADER_ID_TBL';