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_GA_PVT dependencies on PO_GA_ORG_ASSIGNMENTS

Line 209: l_enabled_flag PO_GA_ORG_ASSIGNMENTS.enabled_flag%TYPE;

205: --=============================================================================
206: FUNCTION is_enabled ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE )
207: RETURN BOOLEAN
208: IS
209: l_enabled_flag PO_GA_ORG_ASSIGNMENTS.enabled_flag%TYPE;
210:
211: BEGIN
212:
213: --SQL Gets the 'enabled_flag' to determine if

Line 219: FROM po_ga_org_assignments pgoa,

215: --SQL Global Agreement.
216: --
217: SELECT pgoa.enabled_flag
218: INTO l_enabled_flag
219: FROM po_ga_org_assignments pgoa,
220: po_system_parameters psp
221: WHERE pgoa.po_header_id = p_po_header_id -- input GA ID
222: AND pgoa.organization_id = psp.org_id; -- current OU
223:

Line 258: FROM po_ga_org_assignments

254: BEGIN
255:
256: SELECT 'Y'
257: INTO l_enabled_orgs_exist
258: FROM po_ga_org_assignments
259: WHERE po_header_id = p_po_header_id -- for the current GA
260: AND organization_id <> p_owning_org_id -- for OUs besides Owning OU
261: AND enabled_flag = 'Y' -- that are enabled
262: HAVING count(*) > 0;

Line 833: p_po_header_id PO_GA_ORG_ASSIGNMENTS.po_header_id%TYPE

829:
830: =============================================================================*/
831: FUNCTION get_vendor_site_id
832: (
833: p_po_header_id PO_GA_ORG_ASSIGNMENTS.po_header_id%TYPE
834: )
835: RETURN PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE
836: IS
837: x_vendor_site_id PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE;

Line 835: RETURN PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE

831: FUNCTION get_vendor_site_id
832: (
833: p_po_header_id PO_GA_ORG_ASSIGNMENTS.po_header_id%TYPE
834: )
835: RETURN PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE
836: IS
837: x_vendor_site_id PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE;
838:
839: BEGIN

Line 837: x_vendor_site_id PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE;

833: p_po_header_id PO_GA_ORG_ASSIGNMENTS.po_header_id%TYPE
834: )
835: RETURN PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE
836: IS
837: x_vendor_site_id PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE;
838:
839: BEGIN
840:
841: SELECT pgoa.vendor_site_id

Line 843: FROM po_ga_org_assignments pgoa,

839: BEGIN
840:
841: SELECT pgoa.vendor_site_id
842: INTO x_vendor_site_id
843: FROM po_ga_org_assignments pgoa,
844: po_system_parameters psp
845: WHERE pgoa.po_header_id = p_po_header_id
846: AND pgoa.organization_id = psp.org_id
847: AND pgoa.enabled_flag = 'Y'; --

Line 1287: FROM po_ga_org_assignments PGOA

1283: INTO l_is_enabled
1284: FROM po_headers_all POH
1285: WHERE POH.po_header_id = p_po_header_id
1286: AND EXISTS (SELECT 1
1287: FROM po_ga_org_assignments PGOA
1288: WHERE PGOA.po_header_id = p_po_header_id
1289: AND PGOA.vendor_site_id = p_vendor_site_id
1290: AND PGOA.enabled_flag = 'Y');
1291:

Line 1383: x_purchasing_org_id po_ga_org_assignments.purchasing_org_id%TYPE;

1379: p_po_header_id IN NUMBER
1380: )
1381: RETURN NUMBER
1382: IS
1383: x_purchasing_org_id po_ga_org_assignments.purchasing_org_id%TYPE;
1384: BEGIN
1385: --SQL WHAT: Join to psp to get current org
1386: --SQL WHY: Need to get purchasing org_id
1387: SELECT pgoa.purchasing_org_id

Line 1389: FROM po_ga_org_assignments pgoa, po_system_parameters psp

1385: --SQL WHAT: Join to psp to get current org
1386: --SQL WHY: Need to get purchasing org_id
1387: SELECT pgoa.purchasing_org_id
1388: INTO x_purchasing_org_id
1389: FROM po_ga_org_assignments pgoa, po_system_parameters psp
1390: WHERE pgoa.po_header_id = p_po_header_id
1391: AND pgoa.organization_id = psp.org_id
1392: AND pgoa.enabled_flag = 'Y';
1393:

Line 1807: FROM po_ga_org_assignments pgoa,

1803: l_progress := '010';
1804:
1805: SELECT pgoa.purchasing_org_id
1806: INTO x_purchasing_org_id
1807: FROM po_ga_org_assignments pgoa,
1808: po_system_parameters psp
1809: WHERE pgoa.po_header_id = p_po_header_id
1810: AND pgoa.purchasing_org_id = psp.org_id
1811: AND pgoa.enabled_flag = 'Y'

Line 1819: FROM po_ga_org_assignments

1815: l_progress := '020';
1816:
1817: SELECT 'Y'
1818: INTO l_valid_flag
1819: FROM po_ga_org_assignments
1820: WHERE po_header_id = p_po_header_id
1821: AND purchasing_org_id = x_purchasing_org_id
1822: AND enabled_flag = 'Y'
1823: AND rownum = 1;

Line 1895: -- (PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE)

1891: -- FALSE otherwise.
1892: --x_purchasing_org_id
1893: -- The Purchasing Org ID for the org assignment of the Requesting Org. Only
1894: -- has a valid value if x_is_valid is TRUE.
1895: -- (PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE)
1896: --End of Comments
1897: --------------------------------------------------------------------------------
1898: PROCEDURE val_enabled_requesting_org
1899: (

Line 1929: FROM po_ga_org_assignments pgoa,

1925: SELECT pgoa.purchasing_org_id,
1926: pgoa.organization_id
1927: INTO x_purchasing_org_id,
1928: x_requesting_org_id
1929: FROM po_ga_org_assignments pgoa,
1930: po_system_parameters psp
1931: WHERE pgoa.po_header_id = p_po_header_id
1932: AND pgoa.organization_id = psp.org_id
1933: AND pgoa.enabled_flag = 'Y';

Line 1940: FROM po_ga_org_assignments

1936: l_progress := '020';
1937:
1938: SELECT purchasing_org_id
1939: INTO x_purchasing_org_id
1940: FROM po_ga_org_assignments
1941: WHERE po_header_id = p_po_header_id
1942: AND organization_id = x_requesting_org_id
1943: AND enabled_flag = 'Y';
1944:

Line 2042: PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE := p_purchasing_org_id;

2038: )
2039: IS
2040:
2041: l_purchasing_org_id
2042: PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE := p_purchasing_org_id;
2043: l_item_revision MTL_ITEM_REVISIONS_B.revision%TYPE;
2044: l_progress VARCHAR2(3);
2045:
2046: BEGIN

Line 2184: PO_GA_ORG_ASSIGNMENTS.organization_id%TYPE := p_requesting_org_id;

2180: )
2181: IS
2182:
2183: l_requesting_org_id
2184: PO_GA_ORG_ASSIGNMENTS.organization_id%TYPE := p_requesting_org_id;
2185: l_purchasing_org_id PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE;
2186: l_dummy_revision MTL_ITEM_REVISIONS_B.revision%TYPE;
2187: l_progress VARCHAR2(3);
2188:

Line 2185: l_purchasing_org_id PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE;

2181: IS
2182:
2183: l_requesting_org_id
2184: PO_GA_ORG_ASSIGNMENTS.organization_id%TYPE := p_requesting_org_id;
2185: l_purchasing_org_id PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE;
2186: l_dummy_revision MTL_ITEM_REVISIONS_B.revision%TYPE;
2187: l_progress VARCHAR2(3);
2188:
2189: BEGIN