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

Line 99: p_req_header_id IN PO_TBL_NUMBER,

95:
96: PROCEDURE update_req_po
97: (
98: p_api_version IN NUMBER,
99: p_req_header_id IN PO_TBL_NUMBER,
100: p_req_line_id IN PO_TBL_NUMBER,
101: p_po_header_id IN PO_TBL_NUMBER := NULL,
102: p_po_release_id IN PO_TBL_NUMBER := NULL,
103: p_po_line_id IN PO_TBL_NUMBER := NULL,

Line 100: p_req_line_id IN PO_TBL_NUMBER,

96: PROCEDURE update_req_po
97: (
98: p_api_version IN NUMBER,
99: p_req_header_id IN PO_TBL_NUMBER,
100: p_req_line_id IN PO_TBL_NUMBER,
101: p_po_header_id IN PO_TBL_NUMBER := NULL,
102: p_po_release_id IN PO_TBL_NUMBER := NULL,
103: p_po_line_id IN PO_TBL_NUMBER := NULL,
104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

Line 101: p_po_header_id IN PO_TBL_NUMBER := NULL,

97: (
98: p_api_version IN NUMBER,
99: p_req_header_id IN PO_TBL_NUMBER,
100: p_req_line_id IN PO_TBL_NUMBER,
101: p_po_header_id IN PO_TBL_NUMBER := NULL,
102: p_po_release_id IN PO_TBL_NUMBER := NULL,
103: p_po_line_id IN PO_TBL_NUMBER := NULL,
104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
105: p_quantity IN PO_TBL_NUMBER := NULL,

Line 102: p_po_release_id IN PO_TBL_NUMBER := NULL,

98: p_api_version IN NUMBER,
99: p_req_header_id IN PO_TBL_NUMBER,
100: p_req_line_id IN PO_TBL_NUMBER,
101: p_po_header_id IN PO_TBL_NUMBER := NULL,
102: p_po_release_id IN PO_TBL_NUMBER := NULL,
103: p_po_line_id IN PO_TBL_NUMBER := NULL,
104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
105: p_quantity IN PO_TBL_NUMBER := NULL,
106: p_secondary_quantity IN PO_TBL_NUMBER := NULL,

Line 103: p_po_line_id IN PO_TBL_NUMBER := NULL,

99: p_req_header_id IN PO_TBL_NUMBER,
100: p_req_line_id IN PO_TBL_NUMBER,
101: p_po_header_id IN PO_TBL_NUMBER := NULL,
102: p_po_release_id IN PO_TBL_NUMBER := NULL,
103: p_po_line_id IN PO_TBL_NUMBER := NULL,
104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
105: p_quantity IN PO_TBL_NUMBER := NULL,
106: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
107: p_need_by_date IN PO_TBL_DATE := NULL,

Line 104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

100: p_req_line_id IN PO_TBL_NUMBER,
101: p_po_header_id IN PO_TBL_NUMBER := NULL,
102: p_po_release_id IN PO_TBL_NUMBER := NULL,
103: p_po_line_id IN PO_TBL_NUMBER := NULL,
104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
105: p_quantity IN PO_TBL_NUMBER := NULL,
106: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
107: p_need_by_date IN PO_TBL_DATE := NULL,
108: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,

Line 105: p_quantity IN PO_TBL_NUMBER := NULL,

101: p_po_header_id IN PO_TBL_NUMBER := NULL,
102: p_po_release_id IN PO_TBL_NUMBER := NULL,
103: p_po_line_id IN PO_TBL_NUMBER := NULL,
104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
105: p_quantity IN PO_TBL_NUMBER := NULL,
106: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
107: p_need_by_date IN PO_TBL_DATE := NULL,
108: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,
109: p_sales_order_update_date IN PO_TBL_DATE := NULL,

Line 106: p_secondary_quantity IN PO_TBL_NUMBER := NULL,

102: p_po_release_id IN PO_TBL_NUMBER := NULL,
103: p_po_line_id IN PO_TBL_NUMBER := NULL,
104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
105: p_quantity IN PO_TBL_NUMBER := NULL,
106: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
107: p_need_by_date IN PO_TBL_DATE := NULL,
108: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,
109: p_sales_order_update_date IN PO_TBL_DATE := NULL,
110: p_preferred_grade IN PO_TBL_VARCHAR240 := NULL, --

Line 108: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,

104: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
105: p_quantity IN PO_TBL_NUMBER := NULL,
106: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
107: p_need_by_date IN PO_TBL_DATE := NULL,
108: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,
109: p_sales_order_update_date IN PO_TBL_DATE := NULL,
110: p_preferred_grade IN PO_TBL_VARCHAR240 := NULL, --
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,

Line 138: l_quantity_ordered PO_TBL_NUMBER := p_quantity;

134: l_errors PO_API_ERRORS_REC_TYPE;
135: l_req_changes PO_REQ_CHANGES_REC_TYPE;
136: -- Bug 3292895 END
137:
138: l_quantity_ordered PO_TBL_NUMBER := p_quantity;
139:
140: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; -- added
141: l_document_org_id PO_HEADERS.ORG_ID%TYPE;
142: l_count NUMBER;

Line 152: l_secondary_quantity_ordered PO_TBL_NUMBER := p_secondary_quantity;

148: l_so_request_unit_of_measure mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
149: l_so_request_secondary_uom mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
150: l_uom_conversion_rate NUMBER := 1;
151: l_suom_conversion_rate NUMBER := 1;
152: l_secondary_quantity_ordered PO_TBL_NUMBER := p_secondary_quantity;
153: l_item_id po_lines.item_id%TYPE;
154:
155: --Bug# 4640038 End
156:

Line 468: -- Bug 3331194 Set unit_price, etc. to PO_TBL_NUMBER() instead of NULL.

464: EXIT WHEN (l_cur_req_header_id IS NULL);
465:
466: -- Create a change object for the requisition.
467: l_progress := '220';
468: -- Bug 3331194 Set unit_price, etc. to PO_TBL_NUMBER() instead of NULL.
469: l_req_changes := PO_REQ_CHANGES_REC_TYPE (
470: req_header_id => l_cur_req_header_id,
471: line_changes =>
472: PO_REQ_LINES_REC_TYPE (

Line 473: req_line_id => PO_TBL_NUMBER(),

469: l_req_changes := PO_REQ_CHANGES_REC_TYPE (
470: req_header_id => l_cur_req_header_id,
471: line_changes =>
472: PO_REQ_LINES_REC_TYPE (
473: req_line_id => PO_TBL_NUMBER(),
474: unit_price => PO_TBL_NUMBER(),
475: currency_unit_price => PO_TBL_NUMBER(),
476: quantity => PO_TBL_NUMBER(),
477: secondary_quantity => PO_TBL_NUMBER(),

Line 474: unit_price => PO_TBL_NUMBER(),

470: req_header_id => l_cur_req_header_id,
471: line_changes =>
472: PO_REQ_LINES_REC_TYPE (
473: req_line_id => PO_TBL_NUMBER(),
474: unit_price => PO_TBL_NUMBER(),
475: currency_unit_price => PO_TBL_NUMBER(),
476: quantity => PO_TBL_NUMBER(),
477: secondary_quantity => PO_TBL_NUMBER(),
478: -- preferred_grade => PO_TBL_VARCHAR240(), --

Line 475: currency_unit_price => PO_TBL_NUMBER(),

471: line_changes =>
472: PO_REQ_LINES_REC_TYPE (
473: req_line_id => PO_TBL_NUMBER(),
474: unit_price => PO_TBL_NUMBER(),
475: currency_unit_price => PO_TBL_NUMBER(),
476: quantity => PO_TBL_NUMBER(),
477: secondary_quantity => PO_TBL_NUMBER(),
478: -- preferred_grade => PO_TBL_VARCHAR240(), --
479: need_by_date => PO_TBL_DATE(),

Line 476: quantity => PO_TBL_NUMBER(),

472: PO_REQ_LINES_REC_TYPE (
473: req_line_id => PO_TBL_NUMBER(),
474: unit_price => PO_TBL_NUMBER(),
475: currency_unit_price => PO_TBL_NUMBER(),
476: quantity => PO_TBL_NUMBER(),
477: secondary_quantity => PO_TBL_NUMBER(),
478: -- preferred_grade => PO_TBL_VARCHAR240(), --
479: need_by_date => PO_TBL_DATE(),
480: deliver_to_location_id => PO_TBL_NUMBER(),

Line 477: secondary_quantity => PO_TBL_NUMBER(),

473: req_line_id => PO_TBL_NUMBER(),
474: unit_price => PO_TBL_NUMBER(),
475: currency_unit_price => PO_TBL_NUMBER(),
476: quantity => PO_TBL_NUMBER(),
477: secondary_quantity => PO_TBL_NUMBER(),
478: -- preferred_grade => PO_TBL_VARCHAR240(), --
479: need_by_date => PO_TBL_DATE(),
480: deliver_to_location_id => PO_TBL_NUMBER(),
481: assignment_start_date => PO_TBL_DATE(),

Line 480: deliver_to_location_id => PO_TBL_NUMBER(),

476: quantity => PO_TBL_NUMBER(),
477: secondary_quantity => PO_TBL_NUMBER(),
478: -- preferred_grade => PO_TBL_VARCHAR240(), --
479: need_by_date => PO_TBL_DATE(),
480: deliver_to_location_id => PO_TBL_NUMBER(),
481: assignment_start_date => PO_TBL_DATE(),
482: assignment_end_date => PO_TBL_DATE(),
483: amount => PO_TBL_NUMBER() ),
484: distribution_changes => null );

Line 483: amount => PO_TBL_NUMBER() ),

479: need_by_date => PO_TBL_DATE(),
480: deliver_to_location_id => PO_TBL_NUMBER(),
481: assignment_start_date => PO_TBL_DATE(),
482: assignment_end_date => PO_TBL_DATE(),
483: amount => PO_TBL_NUMBER() ),
484: distribution_changes => null );
485:
486: -- Add the line changes for this requisition to the change object.
487: l_progress := '230';

Line 664: p_req_header_id IN PO_TBL_NUMBER,

660:
661: PROCEDURE cancel_req_po
662: (
663: p_api_version IN NUMBER,
664: p_req_header_id IN PO_TBL_NUMBER,
665: p_req_line_id IN PO_TBL_NUMBER,
666: p_po_header_id IN PO_TBL_NUMBER := NULL,
667: p_po_release_id IN PO_TBL_NUMBER := NULL,
668: p_po_line_id IN PO_TBL_NUMBER := NULL,

Line 665: p_req_line_id IN PO_TBL_NUMBER,

661: PROCEDURE cancel_req_po
662: (
663: p_api_version IN NUMBER,
664: p_req_header_id IN PO_TBL_NUMBER,
665: p_req_line_id IN PO_TBL_NUMBER,
666: p_po_header_id IN PO_TBL_NUMBER := NULL,
667: p_po_release_id IN PO_TBL_NUMBER := NULL,
668: p_po_line_id IN PO_TBL_NUMBER := NULL,
669: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

Line 666: p_po_header_id IN PO_TBL_NUMBER := NULL,

662: (
663: p_api_version IN NUMBER,
664: p_req_header_id IN PO_TBL_NUMBER,
665: p_req_line_id IN PO_TBL_NUMBER,
666: p_po_header_id IN PO_TBL_NUMBER := NULL,
667: p_po_release_id IN PO_TBL_NUMBER := NULL,
668: p_po_line_id IN PO_TBL_NUMBER := NULL,
669: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
670: x_return_status OUT NOCOPY VARCHAR2,

Line 667: p_po_release_id IN PO_TBL_NUMBER := NULL,

663: p_api_version IN NUMBER,
664: p_req_header_id IN PO_TBL_NUMBER,
665: p_req_line_id IN PO_TBL_NUMBER,
666: p_po_header_id IN PO_TBL_NUMBER := NULL,
667: p_po_release_id IN PO_TBL_NUMBER := NULL,
668: p_po_line_id IN PO_TBL_NUMBER := NULL,
669: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
670: x_return_status OUT NOCOPY VARCHAR2,
671: x_msg_count OUT NOCOPY NUMBER,

Line 668: p_po_line_id IN PO_TBL_NUMBER := NULL,

664: p_req_header_id IN PO_TBL_NUMBER,
665: p_req_line_id IN PO_TBL_NUMBER,
666: p_po_header_id IN PO_TBL_NUMBER := NULL,
667: p_po_release_id IN PO_TBL_NUMBER := NULL,
668: p_po_line_id IN PO_TBL_NUMBER := NULL,
669: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
670: x_return_status OUT NOCOPY VARCHAR2,
671: x_msg_count OUT NOCOPY NUMBER,
672: x_msg_data OUT NOCOPY VARCHAR2

Line 669: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

665: p_req_line_id IN PO_TBL_NUMBER,
666: p_po_header_id IN PO_TBL_NUMBER := NULL,
667: p_po_release_id IN PO_TBL_NUMBER := NULL,
668: p_po_line_id IN PO_TBL_NUMBER := NULL,
669: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
670: x_return_status OUT NOCOPY VARCHAR2,
671: x_msg_count OUT NOCOPY NUMBER,
672: x_msg_data OUT NOCOPY VARCHAR2
673: )

Line 693: l_req_header_id PO_TBL_NUMBER;

689:
690: -- Bug 3639067 START
691: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
692: l_session_gt_key PO_SESSION_GT.key%TYPE;
693: l_req_header_id PO_TBL_NUMBER;
694: l_req_line_id PO_TBL_NUMBER;
695: -- Bug 3639067 END
696:
697: BEGIN

Line 694: l_req_line_id PO_TBL_NUMBER;

690: -- Bug 3639067 START
691: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
692: l_session_gt_key PO_SESSION_GT.key%TYPE;
693: l_req_header_id PO_TBL_NUMBER;
694: l_req_line_id PO_TBL_NUMBER;
695: -- Bug 3639067 END
696:
697: BEGIN
698:

Line 1080: ,p_entity_id_tbl IN PO_TBL_NUMBER

1076: ,x_return_status OUT NOCOPY VARCHAR2
1077: ,x_msg_count OUT NOCOPY NUMBER
1078: ,x_msg_data OUT NOCOPY VARCHAR2
1079: ,p_entity IN VARCHAR2
1080: ,p_entity_id_tbl IN PO_TBL_NUMBER
1081: )
1082: IS
1083: l_api_name VARCHAR2(50) := 'Purge';
1084: l_api_version NUMBER := 1.0;

Line 1264: ,p_entity_id_tbl IN PO_TBL_NUMBER

1260: ,x_return_status OUT NOCOPY VARCHAR2
1261: ,x_msg_count OUT NOCOPY NUMBER
1262: ,x_msg_data OUT NOCOPY VARCHAR2
1263: ,p_entity IN VARCHAR2
1264: ,p_entity_id_tbl IN PO_TBL_NUMBER
1265: ,x_purge_allowed_tbl OUT NOCOPY PO_TBL_VARCHAR1
1266: )
1267: IS
1268: l_api_name VARCHAR2(50) := 'Validate_Purge';

Line 1275: l_order_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1271: l_log_head CONSTANT VARCHAR2(100) := c_log_head || '.' || l_api_name;
1272:
1273: l_seq_id NUMBER;
1274:
1275: l_order_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1276: BEGIN
1277: l_progress := '000';
1278:
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;