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_CONTROL_ACTION_VALIDATIONS dependencies on PO_HEADERS

Line 529: 'DOC_NUM',(SELECT segment1 FROM po_headers WHERE po_header_id=pol.po_header_id)),

525: WHERE poll.po_line_id = pol.po_line_id ),
526: (SELECT sum(poll.amount - nvl(poll.amount_cancelled,0))
527: FROM po_line_locations poll
528: WHERE poll.po_line_id = pol.po_line_id )),
529: 'DOC_NUM',(SELECT segment1 FROM po_headers WHERE po_header_id=pol.po_header_id)),
530: (SELECT gt.num1
531: FROM po_session_gt gt
532: WHERE gt.KEY=p_key
533: AND gt.num1 IN

Line 3022: po_headers poh,

3018: gt.num1,
3019: gt.char3
3020: FROM
3021: po_lines pol,
3022: po_headers poh,
3023: po_session_gt gt
3024: WHERE gt.key=p_key
3025: AND poh.po_header_id=pol.po_header_id
3026: AND pol.po_line_id =gt.index_num1

Line 3641: po_headers poh

3637: pgt.char1,
3638: po_document_cancel_pvt.c_doc_type_RELEASE,
3639: (SELECT poh.segment1||'-'|| por.release_num
3640: FROM po_releases por,
3641: po_headers poh
3642: WHERE por.po_release_id=poll.po_release_id
3643: AND por.po_header_id=poh.po_header_id),
3644: (SELECT segment1
3645: FROM po_headers

Line 3645: FROM po_headers

3641: po_headers poh
3642: WHERE por.po_release_id=poll.po_release_id
3643: AND por.po_header_id=poh.po_header_id),
3644: (SELECT segment1
3645: FROM po_headers
3646: WHERE po_header_id=poll.po_header_id)
3647: ),
3648: date1
3649: FROM po_line_locations poll,

Line 3699: FROM po_headers

3695: char3,
3696: char4,
3697: 'Y',
3698: (SELECT segment1
3699: FROM po_headers
3700: WHERE po_header_id=pol.po_header_id
3701: ),
3702: date1
3703: FROM

Line 3742: FROM po_headers

3738: char3,
3739: char4,
3740: 'Y',
3741: (SELECT segment1
3742: FROM po_headers
3743: WHERE po_header_id=num1
3744: ),
3745: date1
3746: FROM po_session_gt pgt

Line 4423: p_agent_id IN PO_HEADERS.agent_id%TYPE,

4419: p_key IN po_session_gt.key%TYPE,
4420: p_user_id IN po_lines.last_updated_by%TYPE,
4421: p_login_id IN po_lines.last_update_login%TYPE,
4422: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4423: p_agent_id IN PO_HEADERS.agent_id%TYPE,
4424: x_return_status OUT NOCOPY VARCHAR2,
4425: x_return_msg OUT NOCOPY VARCHAR2)
4426:
4427:

Line 4484: FROM po_headers poh,

4480: PO_CORE_S.get_translated_text('PO_CAN_CONTROL_SECURITY_FAILED',
4481: 'DOC_NUM', gt.char6),
4482: gt.num1,
4483: gt.char3
4484: FROM po_headers poh,
4485: po_session_gt gt
4486: WHERE gt.key=p_key
4487: AND poh.po_header_id = gt.char4
4488: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_RELEASE

Line 4621: p_agent_id IN PO_HEADERS.agent_id%TYPE,

4617:
4618: PROCEDURE val_doc_state_check(
4619: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
4620: p_online_report_id IN NUMBER,
4621: p_agent_id IN PO_HEADERS.agent_id%TYPE,
4622: p_user_id IN po_lines.last_updated_by%TYPE,
4623: p_login_id IN po_lines.last_update_login%TYPE,
4624: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4625: p_source IN VARCHAR2 DEFAULT NULL,

Line 4839: po_headers poh

4835: Decode(p_entity_rec_tbl(i).document_type,
4836: po_document_cancel_pvt.c_doc_type_RELEASE,
4837: (SELECT poh.segment1||'-'|| por.release_num
4838: FROM po_releases por,
4839: po_headers poh
4840: WHERE por.po_release_id=p_entity_rec_tbl(i).doc_id
4841: AND por.po_header_id=poh.po_header_id),
4842: (SELECT segment1
4843: FROM po_headers

Line 4843: FROM po_headers

4839: po_headers poh
4840: WHERE por.po_release_id=p_entity_rec_tbl(i).doc_id
4841: AND por.po_header_id=poh.po_header_id),
4842: (SELECT segment1
4843: FROM po_headers
4844: WHERE po_header_id=p_entity_rec_tbl(i).doc_id)
4845: ),
4846: 'ACTION',
4847: 'CANCEL',

Line 5748: -- valid po_header_id/po_release_id in po_headers/po_releases

5744: -- valid line_location_id in po_line_locations
5745: -- - If the entity level is LINE, then the entity_id should a
5746: -- valid po_line_id in po_lines
5747: -- - If the entity level is HEADER, then the entity_id should a
5748: -- valid po_header_id/po_release_id in po_headers/po_releases
5749: -- 2. Validate the parameter doc_id
5750: -- - doc_id should always be po_header_id
5751: -- 3. Validate doc_type and doc_subtype combination
5752: -- ex: doc_type=PO and doc_subtype=STANADARD/PLANNED is valid

Line 5964: -- then the entity_id should a valid po_header_id in po_headers

5960: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;
5961: l_progress := '004';
5962:
5963: -- Validate : If the entity level is HEADER and docuemnt type is PO/PA,
5964: -- then the entity_id should a valid po_header_id in po_headers
5965: INSERT INTO PO_ONLINE_REPORT_TEXT(
5966: ONLINE_REPORT_ID,
5967: LAST_UPDATE_LOGIN,
5968: LAST_UPDATED_BY,

Line 6001: FROM po_headers poh

5997: WHERE gt.key=p_key
5998: AND gt.char3 =po_document_cancel_pvt.c_entity_level_HEADER
5999: AND gt.char1<>po_document_cancel_pvt.c_doc_type_RELEASE
6000: AND NOT EXISTS (SELECT '1'
6001: FROM po_headers poh
6002: WHERE poh.po_header_id = gt.num1
6003: ));
6004:
6005: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;

Line 6055: -- Validate :doc_id parametr should be a valid po_header_id in po_headers

6051:
6052: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;
6053: l_progress := '006';
6054:
6055: -- Validate :doc_id parametr should be a valid po_header_id in po_headers
6056: -- or valid po_release_id in po_releases
6057:
6058: INSERT INTO PO_ONLINE_REPORT_TEXT(
6059: ONLINE_REPORT_ID,

Line 6094: FROM po_headers poh

6090: po_session_gt gt
6091: WHERE gt.key=p_key
6092: AND GT.char3 <> PO_Document_Cancel_PVT.c_entity_level_HEADER
6093: AND NOT EXISTS (SELECT '1'
6094: FROM po_headers poh
6095: WHERE poh.po_header_id = gt.char4
6096: UNION ALL
6097: SELECT '1'
6098: FROM po_releases prh

Line 6109: FROM po_headers,

6105:
6106: -- Validate : All documents should belong to same OU
6107: SELECT Count(DISTINCT OPERATING_UNIT)
6108: INTO l_org_count
6109: FROM po_headers,
6110: org_organization_definitions ood
6111: WHERE ood.organization_id=org_id
6112: AND po_header_id IN
6113: (SELECT pol.po_header_id

Line 6206: -- valid po_header_id/po_release_id in po_headers/po_releases

6202: -- valid line_location_id in po_line_locations
6203: -- - If the entity level is LINE, then the entity_id should a valid
6204: -- po_line_id in po_lines
6205: -- - If the entity level is HEADER, then the entity_id should a
6206: -- valid po_header_id/po_release_id in po_headers/po_releases
6207: -- 2. Validate the parameter doc_id
6208: -- - doc_id should always be po_header_id
6209: -- 3. Validate doc_type and doc_subtype combination
6210: -- ex: doc_type=PO and doc_subtype=STANADARD/PLANNED is valid

Line 6727: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;

6723: l_key po_session_gt.key%TYPE;
6724:
6725:
6726:
6727: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;
6728: l_sequence po_online_report_text.sequence%TYPE ;
6729:
6730: d_api_name CONSTANT VARCHAR2(30) := 'validate_cancel_action';
6731: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;