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_ASL_API_GRP dependencies on PO_ASL_DOCUMENTS

Line 129: UPDATE po_asl_documents_gt PAD

125:
126: l_progress := 20;
127: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
128:
129: UPDATE po_asl_documents_gt PAD
130: SET asl_id = (SELECT asl_id
131: FROM po_approved_supplier_list_gt PASL
132: WHERE PASL.user_key = PAD.user_key
133: AND ROWNUM < 2);

Line 300: 'po_asl_documents_gt' ,

296: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
297: --Reject records if document mode is add, asl mode is update and
298: --document already exists for that org
299: SELECT DOCGT.user_key ,
300: 'po_asl_documents_gt' ,
301: fnd_message.get_string('PO','DUPLICATE_DOCUMENT')
302: BULK COLLECT INTO
303: l_user_key_tbl ,
304: l_entity_name ,

Line 306: FROM po_asl_documents_gt DOCGT,

302: BULK COLLECT INTO
303: l_user_key_tbl ,
304: l_entity_name ,
305: l_reject_reason
306: FROM po_asl_documents_gt DOCGT,
307: po_approved_supplier_list_gt ASLGT
308: WHERE EXISTS
309: (SELECT 1
310: FROM po_asl_documents PAD

Line 310: FROM po_asl_documents PAD

306: FROM po_asl_documents_gt DOCGT,
307: po_approved_supplier_list_gt ASLGT
308: WHERE EXISTS
309: (SELECT 1
310: FROM po_asl_documents PAD
311: WHERE DOCGT.document_header_id = PAD.document_header_id
312: AND DOCGT.asl_id = PAD.asl_id
313: AND DOCGT.using_organization_id = PAD.using_organization_id)
314: AND ASLGT.user_key = DOCGT.user_key

Line 325: 'po_asl_documents_gt' ,

321: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
322: --Reject records if document mode is delete, asl mode is update and
323: --document doesn't exists for that org
324: SELECT DOCGT.user_key ,
325: 'po_asl_documents_gt' ,
326: fnd_message.get_string('PO','DOCUMENT_NOT_EXIST')
327: BULK COLLECT INTO
328: l_user_key_tbl ,
329: l_entity_name ,

Line 331: FROM po_asl_documents_gt DOCGT,

327: BULK COLLECT INTO
328: l_user_key_tbl ,
329: l_entity_name ,
330: l_reject_reason
331: FROM po_asl_documents_gt DOCGT,
332: po_approved_supplier_list_gt ASLGT
333: WHERE NOT EXISTS
334: (SELECT 1
335: FROM po_asl_documents PAD

Line 335: FROM po_asl_documents PAD

331: FROM po_asl_documents_gt DOCGT,
332: po_approved_supplier_list_gt ASLGT
333: WHERE NOT EXISTS
334: (SELECT 1
335: FROM po_asl_documents PAD
336: WHERE DOCGT.document_header_id = PAD.document_header_id
337: AND DOCGT.asl_id = PAD.asl_id
338: AND DOCGT.using_organization_id = PAD.using_organization_id)
339: AND ASLGT.user_key = DOCGT.user_key

Line 351: 'po_asl_documents_gt' ,

347: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
348: --Reject records if document mode is add, asl mode is create and
349: --document already exists for that org
350: SELECT DOCGT.user_key ,
351: 'po_asl_documents_gt' ,
352: fnd_message.get_string('PO','DUPLICATE_DOCUMENT')
353: BULK COLLECT INTO
354: l_user_key_tbl ,
355: l_entity_name ,

Line 357: FROM po_asl_documents_gt DOCGT,

353: BULK COLLECT INTO
354: l_user_key_tbl ,
355: l_entity_name ,
356: l_reject_reason
357: FROM po_asl_documents_gt DOCGT,
358: po_approved_supplier_list_gt ASLGT
359: WHERE 2 <=
360: (SELECT Count(user_key)
361: FROM po_asl_documents_gt PAD

Line 361: FROM po_asl_documents_gt PAD

357: FROM po_asl_documents_gt DOCGT,
358: po_approved_supplier_list_gt ASLGT
359: WHERE 2 <=
360: (SELECT Count(user_key)
361: FROM po_asl_documents_gt PAD
362: WHERE DOCGT.document_header_id = PAD.document_header_id
363: AND DOCGT.asl_id = PAD.asl_id
364: AND DOCGT.using_organization_id = PAD.using_organization_id)
365: AND ASLGT.user_key = DOCGT.user_key

Line 821: FROM po_asl_documents_gt PAD

817: AND CHV.user_key = ASLGT.user_key)
818: OR
819: EXISTS
820: (SELECT 1
821: FROM po_asl_documents_gt PAD
822: WHERE PAD.asl_id = ASLGT.asl_id
823: AND PAD.user_key = ASLGT.user_key)
824: OR
825: EXISTS

Line 1516: -- This will validate data in po_asl_documents_gt table

1512:
1513: --Name: validate_asl_doc_gt
1514:
1515: --Function:
1516: -- This will validate data in po_asl_documents_gt table
1517:
1518: --Parameters:
1519:
1520: --OUT:

Line 1550: 'po_asl_documents_gt' AS entity ,

1546: l_reject_reason
1547: FROM (
1548: --Reject records if sequence number is empty or lessthan 1
1549: SELECT user_key ,
1550: 'po_asl_documents_gt' AS entity ,
1551: fnd_message.get_string('PO','INVALID_DOC_SEQUENCE') AS msg
1552: FROM po_asl_documents_gt DOCGT
1553: WHERE DOCGT.sequence_num IS NULL
1554: OR DOCGT.sequence_num < 1

Line 1552: FROM po_asl_documents_gt DOCGT

1548: --Reject records if sequence number is empty or lessthan 1
1549: SELECT user_key ,
1550: 'po_asl_documents_gt' AS entity ,
1551: fnd_message.get_string('PO','INVALID_DOC_SEQUENCE') AS msg
1552: FROM po_asl_documents_gt DOCGT
1553: WHERE DOCGT.sequence_num IS NULL
1554: OR DOCGT.sequence_num < 1
1555:
1556: UNION ALL

Line 1559: 'po_asl_documents_gt' AS entity ,

1555:
1556: UNION ALL
1557: --Reject records if document type is null
1558: SELECT user_key ,
1559: 'po_asl_documents_gt' AS entity ,
1560: fnd_message.get_string('PO','DOC_TYPE_MANDATORY') AS msg
1561: FROM po_asl_documents_gt DOCGT
1562: WHERE DOCGT.document_type_code IS NULL
1563:

Line 1561: FROM po_asl_documents_gt DOCGT

1557: --Reject records if document type is null
1558: SELECT user_key ,
1559: 'po_asl_documents_gt' AS entity ,
1560: fnd_message.get_string('PO','DOC_TYPE_MANDATORY') AS msg
1561: FROM po_asl_documents_gt DOCGT
1562: WHERE DOCGT.document_type_code IS NULL
1563:
1564: UNION ALL
1565: --Reject records if header id is null

Line 1567: 'po_asl_documents_gt' AS entity ,

1563:
1564: UNION ALL
1565: --Reject records if header id is null
1566: SELECT user_key ,
1567: 'po_asl_documents_gt' AS entity ,
1568: fnd_message.get_string('PO','DOC_HEADER_MANDATORY') AS msg
1569: FROM po_asl_documents_gt DOCGT
1570: WHERE DOCGT.document_header_id IS NULL
1571:

Line 1569: FROM po_asl_documents_gt DOCGT

1565: --Reject records if header id is null
1566: SELECT user_key ,
1567: 'po_asl_documents_gt' AS entity ,
1568: fnd_message.get_string('PO','DOC_HEADER_MANDATORY') AS msg
1569: FROM po_asl_documents_gt DOCGT
1570: WHERE DOCGT.document_header_id IS NULL
1571:
1572: UNION ALL
1573: --Reject records if document type is Not CONTRACT, 'LINE_NUM' is null

Line 1575: 'po_asl_documents_gt' AS entity ,

1571:
1572: UNION ALL
1573: --Reject records if document type is Not CONTRACT, 'LINE_NUM' is null
1574: SELECT user_key ,
1575: 'po_asl_documents_gt' AS entity ,
1576: fnd_message.get_string('PO','LINE_NUM_MANDATORY') AS msg
1577: FROM po_asl_documents_gt DOCGT
1578: WHERE DOCGT.document_type_code <> 'CONTRACT'
1579: AND DOCGT.document_line_id IS NULL

Line 1577: FROM po_asl_documents_gt DOCGT

1573: --Reject records if document type is Not CONTRACT, 'LINE_NUM' is null
1574: SELECT user_key ,
1575: 'po_asl_documents_gt' AS entity ,
1576: fnd_message.get_string('PO','LINE_NUM_MANDATORY') AS msg
1577: FROM po_asl_documents_gt DOCGT
1578: WHERE DOCGT.document_type_code <> 'CONTRACT'
1579: AND DOCGT.document_line_id IS NULL
1580: AND DOCGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1581: );