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

Line 301: p_dist_id_tbl IN PO_TBL_NUMBER

297: -- @depends get_award_id(),
298: -- GMS_PO_API_GRP.validate_transaction()
299: ---------------------------------------------------------------------
300: PROCEDURE validate_award_data(
301: p_dist_id_tbl IN PO_TBL_NUMBER
302: , p_project_id_tbl IN PO_TBL_NUMBER
303: , p_task_id_tbl IN PO_TBL_NUMBER
304: , p_award_number_tbl IN PO_TBL_VARCHAR2000
305: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

Line 302: , p_project_id_tbl IN PO_TBL_NUMBER

298: -- GMS_PO_API_GRP.validate_transaction()
299: ---------------------------------------------------------------------
300: PROCEDURE validate_award_data(
301: p_dist_id_tbl IN PO_TBL_NUMBER
302: , p_project_id_tbl IN PO_TBL_NUMBER
303: , p_task_id_tbl IN PO_TBL_NUMBER
304: , p_award_number_tbl IN PO_TBL_VARCHAR2000
305: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
306: , p_expenditure_item_date_tbl IN PO_TBL_DATE

Line 303: , p_task_id_tbl IN PO_TBL_NUMBER

299: ---------------------------------------------------------------------
300: PROCEDURE validate_award_data(
301: p_dist_id_tbl IN PO_TBL_NUMBER
302: , p_project_id_tbl IN PO_TBL_NUMBER
303: , p_task_id_tbl IN PO_TBL_NUMBER
304: , p_award_number_tbl IN PO_TBL_VARCHAR2000
305: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
306: , p_expenditure_item_date_tbl IN PO_TBL_DATE
307: , x_failure_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 307: , x_failure_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER

303: , p_task_id_tbl IN PO_TBL_NUMBER
304: , p_award_number_tbl IN PO_TBL_VARCHAR2000
305: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
306: , p_expenditure_item_date_tbl IN PO_TBL_DATE
307: , x_failure_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER
308: , x_failure_message_tbl OUT NOCOPY PO_TBL_VARCHAR4000
309: )
310: IS
311:

Line 312: l_award_id_tbl PO_TBL_NUMBER;

308: , x_failure_message_tbl OUT NOCOPY PO_TBL_VARCHAR4000
309: )
310: IS
311:
312: l_award_id_tbl PO_TBL_NUMBER;
313: l_msg_count NUMBER;
314: l_msg_data VARCHAR2(4000);
315: l_return_status VARCHAR2(1);
316: l_localized_message VARCHAR2(4000);

Line 322: x_failure_dist_id_tbl := PO_TBL_NUMBER();

318: l_failure_index NUMBER;
319:
320: BEGIN
321:
322: x_failure_dist_id_tbl := PO_TBL_NUMBER();
323: x_failure_message_tbl := PO_TBL_VARCHAR4000();
324: l_failure_index := 0;
325:
326: -- Get the corresponding IDs for the supplied award numbers

Line 396: , x_award_id_tbl OUT NOCOPY PO_TBL_NUMBER

392: -- @depends GMS_PO_API_GRP.get_award_id()
393: ---------------------------------------------------------------------
394: PROCEDURE get_award_id(
395: p_award_number_tbl IN PO_TBL_VARCHAR2000
396: , x_award_id_tbl OUT NOCOPY PO_TBL_NUMBER
397: )
398: IS
399: l_msg_count NUMBER;
400: l_msg_data VARCHAR2(4000);

Line 407: x_award_id_tbl := PO_TBL_NUMBER();

403: BEGIN
404:
405: IF p_award_number_tbl IS NOT NULL THEN
406:
407: x_award_id_tbl := PO_TBL_NUMBER();
408: x_award_id_tbl.extend(p_award_number_tbl.COUNT);
409:
410: FOR i IN 1 .. p_award_number_tbl.COUNT LOOP
411: IF(p_award_number_tbl(i) IS NOT NULL) THEN