7: g_owning_org_type CONSTANT VARCHAR2(15) := 'OWNING';
8: --< Shared Proc FPJ End >
9:
10: FUNCTION get_org_id
11: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
12: ) RETURN PO_HEADERS_ALL.org_id%TYPE;
13:
14: FUNCTION get_current_org
15: RETURN PO_SYSTEM_PARAMETERS.org_id%TYPE;
8: --< Shared Proc FPJ End >
9:
10: FUNCTION get_org_id
11: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
12: ) RETURN PO_HEADERS_ALL.org_id%TYPE;
13:
14: FUNCTION get_current_org
15: RETURN PO_SYSTEM_PARAMETERS.org_id%TYPE;
16:
14: FUNCTION get_current_org
15: RETURN PO_SYSTEM_PARAMETERS.org_id%TYPE;
16:
17: FUNCTION is_owning_org
18: ( p_po_header_id IN PO_HEADERS.po_header_id%TYPE
19: ) RETURN BOOLEAN;
20:
21: --< Shared Proc FPJ > Modified signature to remove %TYPE
22: FUNCTION get_org_name
23: ( p_org_id IN NUMBER
24: ) RETURN VARCHAR2;
25:
26: FUNCTION is_global_agreement
27: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
28: ) RETURN BOOLEAN;
29:
30: FUNCTION is_enabled
31: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
27: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
28: ) RETURN BOOLEAN;
29:
30: FUNCTION is_enabled
31: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
32: ) RETURN BOOLEAN;
33:
34: FUNCTION enabled_orgs_exist
35: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
31: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
32: ) RETURN BOOLEAN;
33:
34: FUNCTION enabled_orgs_exist
35: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
36: p_owning_org_id IN PO_HEADERS_ALL.org_id%TYPE
37: ) RETURN BOOLEAN;
38:
39: FUNCTION is_referenced
32: ) RETURN BOOLEAN;
33:
34: FUNCTION enabled_orgs_exist
35: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
36: p_owning_org_id IN PO_HEADERS_ALL.org_id%TYPE
37: ) RETURN BOOLEAN;
38:
39: FUNCTION is_referenced
40: ( p_po_line_id IN PO_LINES_ALL.from_line_id%TYPE
56: ( p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
57: ) RETURN BOOLEAN;
58:
59: FUNCTION is_ga_valid
60: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
61: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
62: ) RETURN BOOLEAN;
63:
64: FUNCTION is_date_valid
61: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
62: ) RETURN BOOLEAN;
63:
64: FUNCTION is_date_valid
65: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
66: p_date IN DATE
67: ) RETURN BOOLEAN;
68:
69: --< Shared Proc FPJ Start >
86: ( p_po_header_id IN PO_GA_ORG_ASSIGNMENTS.po_header_id%TYPE
87: ) RETURN PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE;
88:
89: PROCEDURE get_currency_info -- <2694908>
90: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
91: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
92: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
93: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
94: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
87: ) RETURN PO_GA_ORG_ASSIGNMENTS.vendor_site_id%TYPE;
88:
89: PROCEDURE get_currency_info -- <2694908>
90: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
91: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
92: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
93: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
94: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
95: );
88:
89: PROCEDURE get_currency_info -- <2694908>
90: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
91: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
92: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
93: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
94: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
95: );
96:
89: PROCEDURE get_currency_info -- <2694908>
90: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
91: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
92: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
93: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
94: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
95: );
96:
97: FUNCTION rate_exists -- <2709419>
90: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
91: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%TYPE ,
92: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%TYPE,
93: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
94: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
95: );
96:
97: FUNCTION rate_exists -- <2709419>
98: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
94: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
95: );
96:
97: FUNCTION rate_exists -- <2709419>
98: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
99: ) RETURN BOOLEAN;
100:
101: --
102: PROCEDURE sync_ga_line_attachments(
99: ) RETURN BOOLEAN;
100:
101: --
102: PROCEDURE sync_ga_line_attachments(
103: p_po_header_id IN po_headers_all.po_header_id%TYPE,
104: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_data OUT NOCOPY VARCHAR2);
107: