DBA Data[Home] [Help]

APPS.PO_GA_PVT dependencies on PO_HEADERS

Line 11: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

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;

Line 12: ) RETURN PO_HEADERS_ALL.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:

Line 18: ( p_po_header_id IN PO_HEADERS.po_header_id%TYPE

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

Line 27: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

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

Line 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 ,

Line 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

Line 36: p_owning_org_id IN PO_HEADERS_ALL.org_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
40: ( p_po_line_id IN PO_LINES_ALL.from_line_id%TYPE

Line 60: ( p_po_header_id IN PO_HEADERS_ALL.po_header_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

Line 65: ( 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
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 >

Line 90: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

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

Line 91: x_currency_code OUT NOCOPY PO_HEADERS_ALL.currency_code%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: );

Line 92: x_rate_type OUT NOCOPY PO_HEADERS_ALL.rate_type%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: );
96:

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

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>

Line 94: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE

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

Line 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(

Line 103: p_po_header_id IN po_headers_all.po_header_id%TYPE,

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: