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 157: l_secondary_quantity_ordered PO_TBL_NUMBER := p_secondary_quantity;

153: l_so_request_unit_of_measure mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
154: l_so_request_secondary_uom mtl_units_of_measure.UNIT_OF_MEASURE_TL%TYPE;
155: l_uom_conversion_rate NUMBER := 1;
156: l_suom_conversion_rate NUMBER := 1;
157: l_secondary_quantity_ordered PO_TBL_NUMBER := p_secondary_quantity;
158: l_item_id po_lines.item_id%TYPE;
159:
160: --Bug# 4640038 End
161:

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

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

Line 478: req_line_id => PO_TBL_NUMBER(),

474: l_req_changes := PO_REQ_CHANGES_REC_TYPE (
475: req_header_id => l_cur_req_header_id,
476: line_changes =>
477: PO_REQ_LINES_REC_TYPE (
478: req_line_id => PO_TBL_NUMBER(),
479: unit_price => PO_TBL_NUMBER(),
480: currency_unit_price => PO_TBL_NUMBER(),
481: quantity => PO_TBL_NUMBER(),
482: secondary_quantity => PO_TBL_NUMBER(),

Line 479: unit_price => PO_TBL_NUMBER(),

475: req_header_id => l_cur_req_header_id,
476: line_changes =>
477: PO_REQ_LINES_REC_TYPE (
478: req_line_id => PO_TBL_NUMBER(),
479: unit_price => PO_TBL_NUMBER(),
480: currency_unit_price => PO_TBL_NUMBER(),
481: quantity => PO_TBL_NUMBER(),
482: secondary_quantity => PO_TBL_NUMBER(),
483: -- preferred_grade => PO_TBL_VARCHAR240(), --

Line 480: currency_unit_price => PO_TBL_NUMBER(),

476: line_changes =>
477: PO_REQ_LINES_REC_TYPE (
478: req_line_id => PO_TBL_NUMBER(),
479: unit_price => PO_TBL_NUMBER(),
480: currency_unit_price => PO_TBL_NUMBER(),
481: quantity => PO_TBL_NUMBER(),
482: secondary_quantity => PO_TBL_NUMBER(),
483: -- preferred_grade => PO_TBL_VARCHAR240(), --
484: need_by_date => PO_TBL_DATE(),

Line 481: quantity => PO_TBL_NUMBER(),

477: PO_REQ_LINES_REC_TYPE (
478: req_line_id => PO_TBL_NUMBER(),
479: unit_price => PO_TBL_NUMBER(),
480: currency_unit_price => PO_TBL_NUMBER(),
481: quantity => PO_TBL_NUMBER(),
482: secondary_quantity => PO_TBL_NUMBER(),
483: -- preferred_grade => PO_TBL_VARCHAR240(), --
484: need_by_date => PO_TBL_DATE(),
485: deliver_to_location_id => PO_TBL_NUMBER(),

Line 482: secondary_quantity => PO_TBL_NUMBER(),

478: req_line_id => PO_TBL_NUMBER(),
479: unit_price => PO_TBL_NUMBER(),
480: currency_unit_price => PO_TBL_NUMBER(),
481: quantity => PO_TBL_NUMBER(),
482: secondary_quantity => PO_TBL_NUMBER(),
483: -- preferred_grade => PO_TBL_VARCHAR240(), --
484: need_by_date => PO_TBL_DATE(),
485: deliver_to_location_id => PO_TBL_NUMBER(),
486: assignment_start_date => PO_TBL_DATE(),

Line 485: deliver_to_location_id => PO_TBL_NUMBER(),

481: quantity => PO_TBL_NUMBER(),
482: secondary_quantity => PO_TBL_NUMBER(),
483: -- preferred_grade => PO_TBL_VARCHAR240(), --
484: need_by_date => PO_TBL_DATE(),
485: deliver_to_location_id => PO_TBL_NUMBER(),
486: assignment_start_date => PO_TBL_DATE(),
487: assignment_end_date => PO_TBL_DATE(),
488: amount => PO_TBL_NUMBER() ),
489: distribution_changes => null );

Line 488: amount => PO_TBL_NUMBER() ),

484: need_by_date => PO_TBL_DATE(),
485: deliver_to_location_id => PO_TBL_NUMBER(),
486: assignment_start_date => PO_TBL_DATE(),
487: assignment_end_date => PO_TBL_DATE(),
488: amount => PO_TBL_NUMBER() ),
489: distribution_changes => null );
490:
491: -- Add the line changes for this requisition to the change object.
492: l_progress := '230';

Line 790: p_req_header_id IN PO_TBL_NUMBER,

786:
787: PROCEDURE cancel_req_po
788: (
789: p_api_version IN NUMBER,
790: p_req_header_id IN PO_TBL_NUMBER,
791: p_req_line_id IN PO_TBL_NUMBER,
792: p_po_header_id IN PO_TBL_NUMBER := NULL,
793: p_po_release_id IN PO_TBL_NUMBER := NULL,
794: p_po_line_id IN PO_TBL_NUMBER := NULL,

Line 791: p_req_line_id IN PO_TBL_NUMBER,

787: PROCEDURE cancel_req_po
788: (
789: p_api_version IN NUMBER,
790: p_req_header_id IN PO_TBL_NUMBER,
791: p_req_line_id IN PO_TBL_NUMBER,
792: p_po_header_id IN PO_TBL_NUMBER := NULL,
793: p_po_release_id IN PO_TBL_NUMBER := NULL,
794: p_po_line_id IN PO_TBL_NUMBER := NULL,
795: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

Line 792: p_po_header_id IN PO_TBL_NUMBER := NULL,

788: (
789: p_api_version IN NUMBER,
790: p_req_header_id IN PO_TBL_NUMBER,
791: p_req_line_id IN PO_TBL_NUMBER,
792: p_po_header_id IN PO_TBL_NUMBER := NULL,
793: p_po_release_id IN PO_TBL_NUMBER := NULL,
794: p_po_line_id IN PO_TBL_NUMBER := NULL,
795: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
796: x_return_status OUT NOCOPY VARCHAR2,

Line 793: p_po_release_id IN PO_TBL_NUMBER := NULL,

789: p_api_version IN NUMBER,
790: p_req_header_id IN PO_TBL_NUMBER,
791: p_req_line_id IN PO_TBL_NUMBER,
792: p_po_header_id IN PO_TBL_NUMBER := NULL,
793: p_po_release_id IN PO_TBL_NUMBER := NULL,
794: p_po_line_id IN PO_TBL_NUMBER := NULL,
795: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,

Line 794: p_po_line_id IN PO_TBL_NUMBER := NULL,

790: p_req_header_id IN PO_TBL_NUMBER,
791: p_req_line_id IN PO_TBL_NUMBER,
792: p_po_header_id IN PO_TBL_NUMBER := NULL,
793: p_po_release_id IN PO_TBL_NUMBER := NULL,
794: p_po_line_id IN PO_TBL_NUMBER := NULL,
795: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,
798: x_msg_data OUT NOCOPY VARCHAR2

Line 795: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

791: p_req_line_id IN PO_TBL_NUMBER,
792: p_po_header_id IN PO_TBL_NUMBER := NULL,
793: p_po_release_id IN PO_TBL_NUMBER := NULL,
794: p_po_line_id IN PO_TBL_NUMBER := NULL,
795: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,
798: x_msg_data OUT NOCOPY VARCHAR2
799: )

Line 819: l_req_header_id PO_TBL_NUMBER;

815:
816: -- Bug 3639067 START
817: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
818: l_session_gt_key PO_SESSION_GT.key%TYPE;
819: l_req_header_id PO_TBL_NUMBER;
820: l_req_line_id PO_TBL_NUMBER;
821: -- Bug 3639067 END
822:
823: BEGIN

Line 820: l_req_line_id PO_TBL_NUMBER;

816: -- Bug 3639067 START
817: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
818: l_session_gt_key PO_SESSION_GT.key%TYPE;
819: l_req_header_id PO_TBL_NUMBER;
820: l_req_line_id PO_TBL_NUMBER;
821: -- Bug 3639067 END
822:
823: BEGIN
824:

Line 1206: ,p_entity_id_tbl IN PO_TBL_NUMBER

1202: ,x_return_status OUT NOCOPY VARCHAR2
1203: ,x_msg_count OUT NOCOPY NUMBER
1204: ,x_msg_data OUT NOCOPY VARCHAR2
1205: ,p_entity IN VARCHAR2
1206: ,p_entity_id_tbl IN PO_TBL_NUMBER
1207: )
1208: IS
1209: l_api_name VARCHAR2(50) := 'Purge';
1210: l_api_version NUMBER := 1.0;

Line 1390: ,p_entity_id_tbl IN PO_TBL_NUMBER

1386: ,x_return_status OUT NOCOPY VARCHAR2
1387: ,x_msg_count OUT NOCOPY NUMBER
1388: ,x_msg_data OUT NOCOPY VARCHAR2
1389: ,p_entity IN VARCHAR2
1390: ,p_entity_id_tbl IN PO_TBL_NUMBER
1391: ,x_purge_allowed_tbl OUT NOCOPY PO_TBL_VARCHAR1
1392: )
1393: IS
1394: l_api_name VARCHAR2(50) := 'Validate_Purge';

Line 1401: l_order_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1397: l_log_head CONSTANT VARCHAR2(100) := c_log_head || '.' || l_api_name;
1398:
1399: l_seq_id NUMBER;
1400:
1401: l_order_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1402: BEGIN
1403: l_progress := '000';
1404:
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;