[Home] [Help]
PACKAGE: APPS.GL_XML_JOURNAL_RPT_PKG
Source
1 PACKAGE GL_XML_JOURNAL_RPT_PKG AS
2 /* $Header: glumlrxs.pls 120.1 2005/12/02 19:54:27 spala noship $ */
3
4
5
6
7
8 Function Net_Line_Balance (P_ACCT_SEG_WHERE VARCHAR2,
9 P_STATUS VARCHAR2,
10 P_START_DATE DATE,
11 P_CURRENCY VARCHAR2,
12 P_LED_ID NUMBER,
13 P_BAL_SEG_NAME VARCHAR2,
14 P_BAL_SEG_VAL VARCHAR2,
15 P_ACCT_SEG_NAME VARCHAR2,
16 P_ACCT_SEG_VAL VARCHAR2,
17 P_SEC_SEG_NAME VARCHAR2,
18 P_SEC_SEG_VAL VARCHAR2) RETURN NUMBER;
19
20 Function Net_Begin_Balance (P_ACCT_SEG_WHERE VARCHAR2,
21 P_STATUS VARCHAR2,
22 P_START_DATE DATE,
23 P_CURRENCY VARCHAR2,
24 P_LED_ID NUMBER,
25 P_BAL_SEG_NAME VARCHAR2,
26 P_BAL_SEG_VAL VARCHAR2,
27 P_ACCT_SEG_NAME VARCHAR2,
28 P_ACCT_SEG_VAL VARCHAR2,
29 P_SEC_SEG_NAME VARCHAR2,
30 P_SEC_SEG_VAL VARCHAR2) RETURN NUMBER;
31
32 FUNCTION Get_Contra_Account(P_Account_Select VARCHAR2,
33 p_Header_id NUMBER,
34 P_Sub_Doc_Seq_Id NUMBER,
35 P_Sub_Doc_SEq_Val VARCHAR2,
36 p_Accounted_Dr NUMBER,
37 P_Accounted_Cr NUMBER) RETURN VARCHAR2;
38
39 type var_t is record (prev_type VARCHAR2(50),
40 header_id_prev NUMBER,
41 sub_doc_sequence_id_prev NUMBER,
42 sub_doc_sequence_value_prev NUMBER,
43 contra_account_name_prev varchar2(240),
44 bal_seg_val_prev VARCHAR2(30),
45 acct_seg_val_prev VARCHAR2(30),
46 sec_seg_val_prev VARCHAR2(30),
47 ledger_id_prev NUMBER,
48 line_balance_prev NUMBER,
49 begin_balance_prev NUMBER);
50
51 var var_t;
52
53 END GL_XML_JOURNAL_RPT_PKG;