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 121: p_vendor_order_num IN PO_TBL_VARCHAR30,

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

Line 122: p_document_num IN PO_TBL_VARCHAR30,

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

Line 123: p_type_lookup_code IN PO_TBL_VARCHAR30,

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

Line 16192: p_document_type IN PO_TBL_VARCHAR30,

16188: PROCEDURE check_updatable (
16189: p_count IN NUMBER,
16190: p_header_id IN PO_TBL_NUMBER,
16191: p_release_id IN PO_TBL_NUMBER,
16192: p_document_type IN PO_TBL_VARCHAR30,
16193: p_document_subtype IN PO_TBL_VARCHAR30,
16194: p_document_num IN PO_TBL_VARCHAR30,
16195: p_vendor_order_num IN PO_TBL_VARCHAR30,
16196: p_line_id IN PO_TBL_NUMBER,

Line 16193: p_document_subtype IN PO_TBL_VARCHAR30,

16189: p_count IN NUMBER,
16190: p_header_id IN PO_TBL_NUMBER,
16191: p_release_id IN PO_TBL_NUMBER,
16192: p_document_type IN PO_TBL_VARCHAR30,
16193: p_document_subtype IN PO_TBL_VARCHAR30,
16194: p_document_num IN PO_TBL_VARCHAR30,
16195: p_vendor_order_num IN PO_TBL_VARCHAR30,
16196: p_line_id IN PO_TBL_NUMBER,
16197: p_line_location_id IN PO_TBL_NUMBER,

Line 16194: p_document_num IN PO_TBL_VARCHAR30,

16190: p_header_id IN PO_TBL_NUMBER,
16191: p_release_id IN PO_TBL_NUMBER,
16192: p_document_type IN PO_TBL_VARCHAR30,
16193: p_document_subtype IN PO_TBL_VARCHAR30,
16194: p_document_num IN PO_TBL_VARCHAR30,
16195: p_vendor_order_num IN PO_TBL_VARCHAR30,
16196: p_line_id IN PO_TBL_NUMBER,
16197: p_line_location_id IN PO_TBL_NUMBER,
16198: p_distribution_id IN PO_TBL_NUMBER,

Line 16195: p_vendor_order_num IN PO_TBL_VARCHAR30,

16191: p_release_id IN PO_TBL_NUMBER,
16192: p_document_type IN PO_TBL_VARCHAR30,
16193: p_document_subtype IN PO_TBL_VARCHAR30,
16194: p_document_num IN PO_TBL_VARCHAR30,
16195: p_vendor_order_num IN PO_TBL_VARCHAR30,
16196: p_line_id IN PO_TBL_NUMBER,
16197: p_line_location_id IN PO_TBL_NUMBER,
16198: p_distribution_id IN PO_TBL_NUMBER,
16199: p_lock_flag IN VARCHAR2 := 'N',

Line 16429: p_document_type IN PO_TBL_VARCHAR30,

16425: PROCEDURE check_reservable (
16426: p_count IN NUMBER,
16427: p_header_id IN PO_TBL_NUMBER,
16428: p_release_id IN PO_TBL_NUMBER,
16429: p_document_type IN PO_TBL_VARCHAR30,
16430: p_document_subtype IN PO_TBL_VARCHAR30,
16431: p_document_num IN PO_TBL_VARCHAR30,
16432: p_vendor_order_num IN PO_TBL_VARCHAR30,
16433: p_line_id IN PO_TBL_NUMBER,

Line 16430: p_document_subtype IN PO_TBL_VARCHAR30,

16426: p_count IN NUMBER,
16427: p_header_id IN PO_TBL_NUMBER,
16428: p_release_id IN PO_TBL_NUMBER,
16429: p_document_type IN PO_TBL_VARCHAR30,
16430: p_document_subtype IN PO_TBL_VARCHAR30,
16431: p_document_num IN PO_TBL_VARCHAR30,
16432: p_vendor_order_num IN PO_TBL_VARCHAR30,
16433: p_line_id IN PO_TBL_NUMBER,
16434: p_line_location_id IN PO_TBL_NUMBER,

Line 16431: p_document_num IN PO_TBL_VARCHAR30,

16427: p_header_id IN PO_TBL_NUMBER,
16428: p_release_id IN PO_TBL_NUMBER,
16429: p_document_type IN PO_TBL_VARCHAR30,
16430: p_document_subtype IN PO_TBL_VARCHAR30,
16431: p_document_num IN PO_TBL_VARCHAR30,
16432: p_vendor_order_num IN PO_TBL_VARCHAR30,
16433: p_line_id IN PO_TBL_NUMBER,
16434: p_line_location_id IN PO_TBL_NUMBER,
16435: p_distribution_id IN PO_TBL_NUMBER,

Line 16432: p_vendor_order_num IN PO_TBL_VARCHAR30,

16428: p_release_id IN PO_TBL_NUMBER,
16429: p_document_type IN PO_TBL_VARCHAR30,
16430: p_document_subtype IN PO_TBL_VARCHAR30,
16431: p_document_num IN PO_TBL_VARCHAR30,
16432: p_vendor_order_num IN PO_TBL_VARCHAR30,
16433: p_line_id IN PO_TBL_NUMBER,
16434: p_line_location_id IN PO_TBL_NUMBER,
16435: p_distribution_id IN PO_TBL_NUMBER,
16436: p_lock_flag IN VARCHAR2 := 'N',

Line 16607: p_document_type IN PO_TBL_VARCHAR30,

16603: PROCEDURE check_unreservable (
16604: p_count IN NUMBER,
16605: p_header_id IN PO_TBL_NUMBER,
16606: p_release_id IN PO_TBL_NUMBER,
16607: p_document_type IN PO_TBL_VARCHAR30,
16608: p_document_subtype IN PO_TBL_VARCHAR30,
16609: p_document_num IN PO_TBL_VARCHAR30,
16610: p_vendor_order_num IN PO_TBL_VARCHAR30,
16611: p_line_id IN PO_TBL_NUMBER,

Line 16608: p_document_subtype IN PO_TBL_VARCHAR30,

16604: p_count IN NUMBER,
16605: p_header_id IN PO_TBL_NUMBER,
16606: p_release_id IN PO_TBL_NUMBER,
16607: p_document_type IN PO_TBL_VARCHAR30,
16608: p_document_subtype IN PO_TBL_VARCHAR30,
16609: p_document_num IN PO_TBL_VARCHAR30,
16610: p_vendor_order_num IN PO_TBL_VARCHAR30,
16611: p_line_id IN PO_TBL_NUMBER,
16612: p_line_location_id IN PO_TBL_NUMBER,

Line 16609: p_document_num IN PO_TBL_VARCHAR30,

16605: p_header_id IN PO_TBL_NUMBER,
16606: p_release_id IN PO_TBL_NUMBER,
16607: p_document_type IN PO_TBL_VARCHAR30,
16608: p_document_subtype IN PO_TBL_VARCHAR30,
16609: p_document_num IN PO_TBL_VARCHAR30,
16610: p_vendor_order_num IN PO_TBL_VARCHAR30,
16611: p_line_id IN PO_TBL_NUMBER,
16612: p_line_location_id IN PO_TBL_NUMBER,
16613: p_distribution_id IN PO_TBL_NUMBER,

Line 16610: p_vendor_order_num IN PO_TBL_VARCHAR30,

16606: p_release_id IN PO_TBL_NUMBER,
16607: p_document_type IN PO_TBL_VARCHAR30,
16608: p_document_subtype IN PO_TBL_VARCHAR30,
16609: p_document_num IN PO_TBL_VARCHAR30,
16610: p_vendor_order_num IN PO_TBL_VARCHAR30,
16611: p_line_id IN PO_TBL_NUMBER,
16612: p_line_location_id IN PO_TBL_NUMBER,
16613: p_distribution_id IN PO_TBL_NUMBER,
16614: p_lock_flag IN VARCHAR2 := 'N',

Line 16777: p_document_type IN PO_TBL_VARCHAR30,

16773: PROCEDURE get_status (
16774: p_count IN NUMBER,
16775: p_header_id IN PO_TBL_NUMBER,
16776: p_release_id IN PO_TBL_NUMBER,
16777: p_document_type IN PO_TBL_VARCHAR30,
16778: p_document_subtype IN PO_TBL_VARCHAR30,
16779: p_document_num IN PO_TBL_VARCHAR30,
16780: p_vendor_order_num IN PO_TBL_VARCHAR30,
16781: p_line_id IN PO_TBL_NUMBER,

Line 16778: p_document_subtype IN PO_TBL_VARCHAR30,

16774: p_count IN NUMBER,
16775: p_header_id IN PO_TBL_NUMBER,
16776: p_release_id IN PO_TBL_NUMBER,
16777: p_document_type IN PO_TBL_VARCHAR30,
16778: p_document_subtype IN PO_TBL_VARCHAR30,
16779: p_document_num IN PO_TBL_VARCHAR30,
16780: p_vendor_order_num IN PO_TBL_VARCHAR30,
16781: p_line_id IN PO_TBL_NUMBER,
16782: p_line_location_id IN PO_TBL_NUMBER,

Line 16779: p_document_num IN PO_TBL_VARCHAR30,

16775: p_header_id IN PO_TBL_NUMBER,
16776: p_release_id IN PO_TBL_NUMBER,
16777: p_document_type IN PO_TBL_VARCHAR30,
16778: p_document_subtype IN PO_TBL_VARCHAR30,
16779: p_document_num IN PO_TBL_VARCHAR30,
16780: p_vendor_order_num IN PO_TBL_VARCHAR30,
16781: p_line_id IN PO_TBL_NUMBER,
16782: p_line_location_id IN PO_TBL_NUMBER,
16783: p_distribution_id IN PO_TBL_NUMBER,

Line 16780: p_vendor_order_num IN PO_TBL_VARCHAR30,

16776: p_release_id IN PO_TBL_NUMBER,
16777: p_document_type IN PO_TBL_VARCHAR30,
16778: p_document_subtype IN PO_TBL_VARCHAR30,
16779: p_document_num IN PO_TBL_VARCHAR30,
16780: p_vendor_order_num IN PO_TBL_VARCHAR30,
16781: p_line_id IN PO_TBL_NUMBER,
16782: p_line_location_id IN PO_TBL_NUMBER,
16783: p_distribution_id IN PO_TBL_NUMBER,
16784: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 16979: p_document_type IN PO_TBL_VARCHAR30,

16975: PROCEDURE po_status_check (
16976: p_api_version IN NUMBER,
16977: p_header_id IN PO_TBL_NUMBER,
16978: p_release_id IN PO_TBL_NUMBER,
16979: p_document_type IN PO_TBL_VARCHAR30,
16980: p_document_subtype IN PO_TBL_VARCHAR30,
16981: p_document_num IN PO_TBL_VARCHAR30,
16982: p_vendor_order_num IN PO_TBL_VARCHAR30,
16983: p_line_id IN PO_TBL_NUMBER,

Line 16980: p_document_subtype IN PO_TBL_VARCHAR30,

16976: p_api_version IN NUMBER,
16977: p_header_id IN PO_TBL_NUMBER,
16978: p_release_id IN PO_TBL_NUMBER,
16979: p_document_type IN PO_TBL_VARCHAR30,
16980: p_document_subtype IN PO_TBL_VARCHAR30,
16981: p_document_num IN PO_TBL_VARCHAR30,
16982: p_vendor_order_num IN PO_TBL_VARCHAR30,
16983: p_line_id IN PO_TBL_NUMBER,
16984: p_line_location_id IN PO_TBL_NUMBER,

Line 16981: p_document_num IN PO_TBL_VARCHAR30,

16977: p_header_id IN PO_TBL_NUMBER,
16978: p_release_id IN PO_TBL_NUMBER,
16979: p_document_type IN PO_TBL_VARCHAR30,
16980: p_document_subtype IN PO_TBL_VARCHAR30,
16981: p_document_num IN PO_TBL_VARCHAR30,
16982: p_vendor_order_num IN PO_TBL_VARCHAR30,
16983: p_line_id IN PO_TBL_NUMBER,
16984: p_line_location_id IN PO_TBL_NUMBER,
16985: p_distribution_id IN PO_TBL_NUMBER,

Line 16982: p_vendor_order_num IN PO_TBL_VARCHAR30,

16978: p_release_id IN PO_TBL_NUMBER,
16979: p_document_type IN PO_TBL_VARCHAR30,
16980: p_document_subtype IN PO_TBL_VARCHAR30,
16981: p_document_num IN PO_TBL_VARCHAR30,
16982: p_vendor_order_num IN PO_TBL_VARCHAR30,
16983: p_line_id IN PO_TBL_NUMBER,
16984: p_line_location_id IN PO_TBL_NUMBER,
16985: p_distribution_id IN PO_TBL_NUMBER,
16986: p_mode IN VARCHAR2,

Line 18313: l_period_name_tbl po_tbl_varchar30;

18309: l_line_num_tbl po_tbl_number;
18310: l_shipment_num_tbl po_tbl_number;
18311: l_distribution_num_tbl po_tbl_number;
18312:
18313: l_period_name_tbl po_tbl_varchar30;
18314: l_period_year_tbl po_tbl_number;
18315: l_period_num_tbl po_tbl_number;
18316: l_quarter_num_tbl po_tbl_number;
18317: l_invalid_period_flag VARCHAR2(1);

Line 18639: p_vendor_order_num IN PO_TBL_VARCHAR30,

18635: PROCEDURE complete_po_header_id_tbl
18636: ( p_count IN NUMBER,
18637: p_header_id IN PO_TBL_NUMBER,
18638: p_release_id IN PO_TBL_NUMBER,
18639: p_vendor_order_num IN PO_TBL_VARCHAR30,
18640: p_document_num IN PO_TBL_VARCHAR30,
18641: p_type_lookup_code IN PO_TBL_VARCHAR30,
18642: x_header_id OUT NOCOPY PO_TBL_NUMBER
18643: ) IS

Line 18640: p_document_num IN PO_TBL_VARCHAR30,

18636: ( p_count IN NUMBER,
18637: p_header_id IN PO_TBL_NUMBER,
18638: p_release_id IN PO_TBL_NUMBER,
18639: p_vendor_order_num IN PO_TBL_VARCHAR30,
18640: p_document_num IN PO_TBL_VARCHAR30,
18641: p_type_lookup_code IN PO_TBL_VARCHAR30,
18642: x_header_id OUT NOCOPY PO_TBL_NUMBER
18643: ) IS
18644:

Line 18641: p_type_lookup_code IN PO_TBL_VARCHAR30,

18637: p_header_id IN PO_TBL_NUMBER,
18638: p_release_id IN PO_TBL_NUMBER,
18639: p_vendor_order_num IN PO_TBL_VARCHAR30,
18640: p_document_num IN PO_TBL_VARCHAR30,
18641: p_type_lookup_code IN PO_TBL_VARCHAR30,
18642: x_header_id OUT NOCOPY PO_TBL_NUMBER
18643: ) IS
18644:
18645: l_api_name CONSTANT VARCHAR2(30) := 'COMPLETE_PO_HEADER_ID_TBL';