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_HEADERS_ALL

Line 25: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE

21:
22: =============================================================================*/
23: FUNCTION get_org_id
24: (
25: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
26: )
27: RETURN PO_HEADERS_ALL.org_id%TYPE
28: IS
29: x_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 27: RETURN PO_HEADERS_ALL.org_id%TYPE

23: FUNCTION get_org_id
24: (
25: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
26: )
27: RETURN PO_HEADERS_ALL.org_id%TYPE
28: IS
29: x_org_id PO_HEADERS_ALL.org_id%TYPE;
30:
31: BEGIN

Line 29: x_org_id PO_HEADERS_ALL.org_id%TYPE;

25: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
26: )
27: RETURN PO_HEADERS_ALL.org_id%TYPE
28: IS
29: x_org_id PO_HEADERS_ALL.org_id%TYPE;
30:
31: BEGIN
32:
33: SELECT org_id

Line 35: FROM po_headers_all

31: BEGIN
32:
33: SELECT org_id
34: INTO x_org_id
35: FROM po_headers_all
36: WHERE po_header_id = p_po_header_id;
37:
38: return (x_org_id);
39:

Line 163: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE

159:
160: =============================================================================*/
161: FUNCTION is_global_agreement
162: (
163: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
164: )
165: RETURN BOOLEAN
166: IS
167: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

Line 167: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

163: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
164: )
165: RETURN BOOLEAN
166: IS
167: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
168:
169: BEGIN
170: SELECT global_agreement_flag
171: INTO l_global_agreement_flag

Line 172: FROM po_headers_all

168:
169: BEGIN
170: SELECT global_agreement_flag
171: INTO l_global_agreement_flag
172: FROM po_headers_all
173: WHERE po_header_id = p_po_header_id;
174:
175: IF (l_global_agreement_flag = 'Y') THEN
176: return (TRUE);

Line 206: FUNCTION is_enabled ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE )

202: -- Exceptions : -
203: -- Notes : Functionality changed due to new column purchasing_org_id added
204: -- in Shared Proc FPJ.
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:

Line 248: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

244:
245: =============================================================================*/
246: FUNCTION enabled_orgs_exist
247: (
248: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
249: p_owning_org_id IN PO_HEADERS_ALL.org_id%TYPE
250: )
251: RETURN BOOLEAN
252: IS

Line 249: p_owning_org_id IN PO_HEADERS_ALL.org_id%TYPE

245: =============================================================================*/
246: FUNCTION enabled_orgs_exist
247: (
248: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
249: p_owning_org_id IN PO_HEADERS_ALL.org_id%TYPE
250: )
251: RETURN BOOLEAN
252: IS
253: l_enabled_orgs_exist VARCHAR2(1) := 'N';

Line 347: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

343: x_owning_org_id OUT NOCOPY NUMBER,
344: x_owning_org_name OUT NOCOPY VARCHAR2
345: )
346: IS
347: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
348:
349: BEGIN
350: SELECT nvl(poh.global_agreement_flag, 'N'),
351: decode(poh.global_agreement_flag, -- only return values

Line 360: FROM po_headers_all poh,

356: NULL )
357: INTO x_global_agreement_flag,
358: x_owning_org_id,
359: x_owning_org_name
360: FROM po_headers_all poh,
361: hr_all_organization_units_tl hrou
362: WHERE poh.po_header_id = p_po_header_id
363: AND hrou.organization_id = poh.org_id
364: AND hrou.language = USERENV('LANG');

Line 397: l_header_end_date PO_HEADERS_ALL.end_date%TYPE;

393: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
394: )
395: RETURN BOOLEAN
396: IS
397: l_header_end_date PO_HEADERS_ALL.end_date%TYPE;
398: l_line_expiration_date PO_LINES_ALL.expiration_date%TYPE;
399:
400: BEGIN
401:

Line 409: FROM po_headers_all poh,

405: SELECT poh.end_date,
406: pol.expiration_date
407: INTO l_header_end_date,
408: l_line_expiration_date
409: FROM po_headers_all poh,
410: po_lines_all pol
411: WHERE poh.po_header_id = pol.po_header_id -- JOIN
412: AND pol.po_line_id = p_po_line_id;
413:

Line 473: FROM po_headers_all poh,

469: --SQL Else, count should return 0.
470: --
471: SELECT count('Line exists with following conditions.')
472: INTO l_count
473: FROM po_headers_all poh,
474: po_lines_all pol
475: WHERE
476: nvl(poh.cancel_flag, 'N') = 'N'
477: AND nvl(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 527: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

523: -- enabled org assignment validation.
524: --=============================================================================
525: FUNCTION is_ga_valid
526: (
527: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
528: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
529: )
530: RETURN BOOLEAN
531: IS

Line 572: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

568: -- Exceptions : -
569: --=============================================================================
570: FUNCTION is_date_valid
571: (
572: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
573: p_date IN DATE
574: )
575: RETURN BOOLEAN
576: IS

Line 577: l_start_date PO_HEADERS_ALL.start_date%TYPE;

573: p_date IN DATE
574: )
575: RETURN BOOLEAN
576: IS
577: l_start_date PO_HEADERS_ALL.start_date%TYPE;
578: l_end_date PO_HEADERS_ALL.end_date%TYPE;
579:
580: BEGIN
581:

Line 578: l_end_date PO_HEADERS_ALL.end_date%TYPE;

574: )
575: RETURN BOOLEAN
576: IS
577: l_start_date PO_HEADERS_ALL.start_date%TYPE;
578: l_end_date PO_HEADERS_ALL.end_date%TYPE;
579:
580: BEGIN
581:
582: -- If the input date is NULL, then treat as valid.

Line 594: FROM po_headers_all

590: SELECT start_date,
591: end_date
592: INTO l_start_date,
593: l_end_date
594: FROM po_headers_all
595: WHERE po_header_id = p_po_header_id;
596:
597: --< NBD TZ/Timestamp FPJ Start >
598: -- The IN parameter p_date would be the need-by-date which is now

Line 880: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

876: -- GL_CURRENCY_API.invalid_currency - Invalid currency
877: --=============================================================================
878: PROCEDURE get_currency_info
879: (
880: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
881: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
882: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
883: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
884: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE

Line 881: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,

877: --=============================================================================
878: PROCEDURE get_currency_info
879: (
880: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
881: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
882: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
883: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
884: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
885: )

Line 882: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,

878: PROCEDURE get_currency_info
879: (
880: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
881: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
882: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
883: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
884: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
885: )
886: IS

Line 883: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,

879: (
880: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
881: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
882: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
883: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
884: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
885: )
886: IS
887: l_set_of_books_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

Line 884: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE

880: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
881: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
882: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
883: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
884: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
885: )
886: IS
887: l_set_of_books_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
888: BEGIN

Line 893: FROM po_headers_all

889:
890: -- Get Currency Code specifically for the Global Agreement
891: SELECT currency_code
892: INTO x_currency_code
893: FROM po_headers_all
894: WHERE po_header_id = p_po_header_id;
895:
896: -- Get the current Set of Books ID
897: SELECT set_of_books_id

Line 942: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

938: -- and functional currency. FALSE otherwise.
939: --=============================================================================
940: FUNCTION rate_exists
941: (
942: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
943: )
944: RETURN BOOLEAN
945: IS
946: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

Line 946: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

942: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
943: )
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:

Line 949: x_rate PO_HEADERS_ALL.rate%TYPE;

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:
953: SELECT currency_code

Line 955: FROM po_headers_all

951: BEGIN
952:
953: SELECT currency_code
954: INTO l_currency_code
955: FROM po_headers_all
956: WHERE po_header_id = p_po_header_id;
957:
958: SELECT set_of_books_id
959: INTO l_sob_id

Line 1003: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

999: ---
1000: -- EXCEPTIONS : -
1001: --==========================================================================
1002: PROCEDURE sync_ga_line_attachments(
1003: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1004: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
1005: x_return_status OUT NOCOPY VARCHAR2,
1006: x_msg_data OUT NOCOPY VARCHAR2) IS
1007:

Line 1284: FROM po_headers_all POH

1280: BEGIN
1281:
1282: SELECT 'Y'
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

Line 1333: FROM po_headers_all POH

1329: BEGIN
1330:
1331: SELECT NVL(POH.global_agreement_flag, 'N')
1332: INTO l_global
1333: FROM po_headers_all POH
1334: WHERE POH.po_header_id = p_po_header_id
1335: AND POH.type_lookup_code = p_type_lookup_code;
1336:
1337: IF (l_global = 'Y') THEN -- global doc

Line 2359: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

2355: --
2356:
2357: --Bug 12838070
2358: PROCEDURE sync_all_ga_line_attachments(
2359: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
2360: p_draft_id IN PO_LINES_DRAFT_ALL.draft_id%TYPE, --Bug 13540474
2361: x_return_status OUT NOCOPY VARCHAR2,
2362: x_msg_data OUT NOCOPY VARCHAR2) IS
2363:

Line 2375: l_src_doc_id PO_HEADERS_ALL.po_header_id%TYPE;

2371: cursor lines_csr is
2372: select from_line_id, decode(from_header_id, NULL,contract_id, from_header_id ) from po_lines_merge_v where po_header_id = p_po_header_id and draft_id = p_draft_id; --Bug 13540474
2373:
2374: l_po_line_id PO_LINES_ALL.po_line_id%type;
2375: l_src_doc_id PO_HEADERS_ALL.po_header_id%TYPE;
2376:
2377:
2378: BEGIN
2379: