APPS.PO_GA_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 56: RETURN PO_SYSTEM_PARAMETERS.org_id%TYPE

52: DESCRIPTION: Gets the org_id for the current session.
53:
54: =============================================================================*/
55: FUNCTION get_current_org
56: RETURN PO_SYSTEM_PARAMETERS.org_id%TYPE
57: IS
58: x_org_id PO_SYSTEM_PARAMETERS.org_id%TYPE;
59: BEGIN
60:

Line 58: x_org_id PO_SYSTEM_PARAMETERS.org_id%TYPE;

54: =============================================================================*/
55: FUNCTION get_current_org
56: RETURN PO_SYSTEM_PARAMETERS.org_id%TYPE
57: IS
58: x_org_id PO_SYSTEM_PARAMETERS.org_id%TYPE;
59: BEGIN
60:
61: SELECT org_id
62: INTO x_org_id

Line 63: FROM po_system_parameters;

59: BEGIN
60:
61: SELECT org_id
62: INTO x_org_id
63: FROM po_system_parameters;
64:
65: return (x_org_id);
66:
67: EXCEPTION

Line 220: po_system_parameters psp

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:
224: IF ( l_enabled_flag = 'Y' ) THEN

Line 844: po_system_parameters psp

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'; --
848:

Line 904: FROM po_system_parameters;

900:
901: -- Get the default Rate Type for the current org
902: SELECT default_rate_type
903: INTO x_rate_type
904: FROM po_system_parameters;
905:
906: -- Set Rate Date equal to current date
907: x_rate_date := sysdate;
908:

Line 948: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;

944: RETURN BOOLEAN
945: IS
946: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
947: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
948: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
949: x_rate PO_HEADERS_ALL.rate%TYPE;
950:
951: BEGIN
952:

Line 964: FROM po_system_parameters;

960: FROM financials_system_parameters;
961:
962: SELECT default_rate_type
963: INTO l_rate_type
964: FROM po_system_parameters;
965:
966: x_rate := PO_CORE_S.get_conversion_rate( l_sob_id ,
967: l_currency_code ,
968: sysdate ,

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 1808: po_system_parameters psp

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'
1812: AND rownum = 1;

Line 1930: po_system_parameters psp

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';
1934: