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_REQAPPROVAL_INIT1 dependencies on PO_VENDORS

Line 729: l_vendor po_vendors.vendor_name%type; --Bug 4254468

725: l_document_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 3284628
726: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;
727: l_autoapprove_retro VARCHAR2(1);
728: l_okc_doc_type VARCHAR2(20); --
729: l_vendor po_vendors.vendor_name%type; --Bug 4254468
730: l_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --Bug 4254468
731: l_new_vendor po_vendors.vendor_name%type; --multi-mod
732: l_new_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --multi-mod
733: l_multi_mod_req_id PO_MULTI_MOD_DOCS.MULTI_MOD_REQUEST_ID%TYPE; -- multi-mod

Line 731: l_new_vendor po_vendors.vendor_name%type; --multi-mod

727: l_autoapprove_retro VARCHAR2(1);
728: l_okc_doc_type VARCHAR2(20); --
729: l_vendor po_vendors.vendor_name%type; --Bug 4254468
730: l_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --Bug 4254468
731: l_new_vendor po_vendors.vendor_name%type; --multi-mod
732: l_new_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --multi-mod
733: l_multi_mod_req_id PO_MULTI_MOD_DOCS.MULTI_MOD_REQUEST_ID%TYPE; -- multi-mod
734: l_multi_mod_req_type PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE%TYPE; --multi-mod
735: l_supplier_change_note varchar2(320); --multi-mod

Line 950: FROM po_vendors pov,

946: IF ActionOriginatedFrom = 'MULTI_MOD' THEN
947:
948: SELECT pov.vendor_name, pvs.vendor_site_code
949: INTO l_vendor, l_vendor_site_code
950: FROM po_vendors pov,
951: po_headers poh,
952: po_vendor_sites_all pvs
953: WHERE pov.vendor_id = poh.vendor_id
954: AND poh.po_header_id = DocumentId

Line 975: po_vendors pv,

971:
972: SELECT pv.vendor_name, pvs.vendor_site_code
973: INTO l_new_vendor, l_new_vendor_site_code
974: FROM po_headers_draft_all phda,
975: po_vendors pv,
976: po_vendor_sites_all pvs
977: WHERE draft_id = DraftID
978: AND phda.vendor_id = pv.vendor_id
979: AND phda.vendor_site_id = pvs.vendor_site_id;

Line 1470: FROM po_vendors pov,

1466: SELECT pov.vendor_name,
1467: pvs.vendor_site_code
1468: INTO l_vendor,
1469: l_vendor_site_code
1470: FROM po_vendors pov,
1471: po_headers poh,
1472: po_vendor_sites_all pvs
1473: WHERE pov.vendor_id = poh.vendor_id
1474: AND poh.po_header_id = DocumentId

Line 1483: po_vendors pov,

1479: INTO l_vendor,
1480: l_vendor_site_code
1481: FROM po_releases por,
1482: po_headers poh,
1483: po_vendors pov,
1484: po_vendor_sites_all pvs
1485: WHERE por.po_release_id = DocumentId
1486: AND por.po_header_id = poh.po_header_id
1487: AND poh.vendor_id = pov.vendor_id

Line 3725: l_supplier_user_tbl po_vendors_grp.external_user_tbl_type;

3721: x_role_with_resp IN OUT NOCOPY VARCHAR2)
3722: IS
3723: /*CONERMS FPJ START*/
3724: -- declare local variables to hold output of get_supplier_userlist call
3725: l_supplier_user_tbl po_vendors_grp.external_user_tbl_type;
3726: l_namelist VARCHAR2(31990):=NULL;
3727: l_namelist_for_sql VARCHAR2(32000):=NULL;
3728: l_num_users NUMBER := 0;
3729: l_vendor_id NUMBER;

Line 3752: -- called po_vendors_grp.get_external_userlist. This procedure now makes a

3748: l_num_users := 0;
3749: l_step := '0';
3750: /* CONTERMS FPJ START */
3751: -- The code to create the user list has been sliced into another procedure
3752: -- called po_vendors_grp.get_external_userlist. This procedure now makes a
3753: -- call to it to retrieve, comma and space delimited userlist, and number
3754: -- of users, supplier list in a table and vendor id.
3755: /*po_doc_utl_pvt.get_supplier_userlist(p_document_id => p_document_id
3756: ,p_document_type => p_document_type

Line 3764: po_vendors_grp.get_external_userlist (

3760: ,x_supplier_userlist_for_sql => l_namelist_for_sql
3761: ,x_num_users => l_num_users
3762: ,x_vendor_id => l_vendor_id);*/
3763:
3764: po_vendors_grp.get_external_userlist (
3765: p_api_version => 1.0 , p_init_msg_list => FND_API.G_FALSE , p_document_id => p_document_id ,
3766: p_document_type => p_document_type , x_return_status => l_return_status , x_msg_count => l_msg_count ,
3767: x_msg_data => l_msg_data , x_external_user_tbl => l_supplier_user_tbl , x_supplier_userlist => l_namelist ,
3768: x_supplier_userlist_for_sql => l_namelist_for_sql , x_num_users => l_num_users , x_vendor_id => l_vendor_id);

Line 3800: FROM po_vendors

3796: END IF;
3797: BEGIN
3798: SELECT vendor_name
3799: INTO l_role_display_name
3800: FROM po_vendors
3801: WHERE vendor_id=l_vendor_id;
3802: EXCEPTION
3803: WHEN OTHERS THEN
3804: l_role_display_name:=' ';

Line 3905: l_vendor_name po_vendors.vendor_name%TYPE;

3901: l_lang_code wf_languages.code%TYPE;
3902: /*Bug 9283386*/
3903:
3904: --ER 5688144: retrieve vendor name for display name of email address
3905: l_vendor_name po_vendors.vendor_name%TYPE;
3906: --ER 5688144: End
3907: BEGIN
3908: x_progress := 'PO_REQAPPROVAL_INIT1.Email_Doc_Yes_No: 01';
3909: IF (g_po_wf_debug = 'Y') THEN

Line 3963: po_vendor_sites pvs, po_vendors pv

3959: INTO l_vendor_site_id,
3960: l_vendor_site_code,
3961: l_vendor_site_lang, l_vendor_name
3962: FROM po_headers poh,
3963: po_vendor_sites pvs, po_vendors pv
3964: WHERE pvs.vendor_site_id = poh.vendor_site_id
3965: AND pv.vendor_id = poh.vendor_id
3966: AND poh.po_header_id = l_po_header_id;
3967: --ER 5688144: End

Line 7495: x_vendor po_vendors.vendor_name%TYPE;

7491: x_user_id NUMBER;
7492: x_document_id NUMBER;
7493: x_document_type_code VARCHAR2(30);
7494: x_po_header_id po_headers_all.po_header_id%TYPE;
7495: x_vendor po_vendors.vendor_name%TYPE;
7496: /* Bug 7172641 Changing the size as equal to the column size of vendor_name in po_vendors table */
7497: x_supp_user_name VARCHAR2(100);
7498: x_supplier_displayname VARCHAR2(100);
7499: x_revision_num NUMBER; -- RDP

Line 7496: /* Bug 7172641 Changing the size as equal to the column size of vendor_name in po_vendors table */

7492: x_document_id NUMBER;
7493: x_document_type_code VARCHAR2(30);
7494: x_po_header_id po_headers_all.po_header_id%TYPE;
7495: x_vendor po_vendors.vendor_name%TYPE;
7496: /* Bug 7172641 Changing the size as equal to the column size of vendor_name in po_vendors table */
7497: x_supp_user_name VARCHAR2(100);
7498: x_supplier_displayname VARCHAR2(100);
7499: x_revision_num NUMBER; -- RDP
7500: -- x_accp_type varchar2(100);

Line 7519: FROM po_vendors pov,

7515: SELECT pov.vendor_name,
7516: poh.revision_num
7517: INTO x_vendor,
7518: x_revision_num -- RDP
7519: FROM po_vendors pov,
7520: po_headers poh
7521: WHERE pov.vendor_id = poh.vendor_id
7522: AND poh.po_header_id=x_document_id;
7523: ELSE

Line 7532: po_vendors pov

7528: x_po_header_id,
7529: x_revision_num
7530: FROM po_releases por,
7531: po_headers_all poh, --
7532: po_vendors pov
7533: WHERE por.po_release_id = x_document_id
7534: AND por.po_header_id = poh.po_header_id
7535: AND poh.vendor_id = pov.vendor_id;
7536: END IF;

Line 7655: FROM po_vendors pov,

7651: SELECT pov.vendor_name,
7652: poh.revision_num
7653: INTO x_vendor,
7654: l_revision_num
7655: FROM po_vendors pov,
7656: po_headers poh
7657: WHERE pov.vendor_id = poh.vendor_id
7658: AND poh.po_header_id=x_document_id;
7659:

Line 7669: po_vendors pov

7665: INTO x_vendor,
7666: l_revision_num
7667: FROM po_releases por,
7668: po_headers_all poh, --
7669: po_vendors pov
7670: WHERE por.po_release_id = x_document_id
7671: AND por.po_header_id = poh.po_header_id
7672: AND poh.vendor_id = pov.vendor_id;
7673: