1 PACKAGE PO_DOCUMENT_UTIL_PVT AUTHID CURRENT_USER as
2 -- $Header: PO_DOCUMENT_UTIL_PVT.pls 120.4.12020000.3 2013/02/10 13:17:32 vegajula ship $
3
4 /*==================================================================
5 PROCEDURE NAME: synchronize_gt_tables
6
7 DESCRIPTION: Inserts the values into PO_SESSION_GT at
8 the specified key.
9
10 PARAMETERS: p_key - the GT Key at which the values should be
11 inserted.
12 p_index_num1_vals - the values to be inserted into
13 the GT Table's index_num1 column.
14 p_index_num2_vals - the values to be inserted into
15 the GT Table's index_num2 column.
16 ====================================================================*/
17 PROCEDURE synchronize_gt_tables (
18 p_key IN NUMBER
19 , p_index_num1_vals IN PO_TBL_NUMBER
20 , p_index_num2_vals IN PO_TBL_NUMBER);
21
22 /*==================================================================
23 FUNCTION NAME: initialize_gt_table
24
25 DESCRIPTION: Inserts the values into PO_SESSION_GT at
26 a new key, returning the key.
27
28 PARAMETERS: p_index_num1_vals - the values to be inserted into
29 the GT Table's index_num1 column.
30 p_index_num2_vals - the values to be inserted into
31 the GT Table's index_num2 column.
32 ====================================================================*/
33 FUNCTION initialize_gt_table (
34 p_index_num1_vals IN PO_TBL_NUMBER
35 , p_index_num2_vals IN PO_TBL_NUMBER)
36 RETURN NUMBER;
37
38
39 /*For bug 12534184*/
40 FUNCTION get_plc_status(
41 p_header_id IN NUMBER)
42 RETURN VARCHAR2;
43
44 /* bug 12932650 */
45 FUNCTION get_prorated_tax(x_header_id IN NUMBER, x_line_id IN NUMBER,
46 x_line_location_id IN NUMBER) return NUMBER;
47 FUNCTION get_amount_billed(x_header_id IN NUMBER, x_line_id IN NUMBER) return NUMBER;
48
49 END PO_DOCUMENT_UTIL_PVT;