[Home] [Help]
1: PACKAGE GL_LEDGERS_PKG AS
2: /* $Header: glistlds.pls 120.37.12010000.2 2008/11/26 04:10:39 phmullap ship $ */
3:
4: -- **********************************************************************
5:
255: -- Arguments
256: -- x_rowid The ID of the row to be checked
257: -- x_name The category name to be checked
258: -- Example
259: -- GL_LEDGERS_PKG.check_unique_name( '12345', 'LEDGER 1' );
260: -- Notes
261: --
262: PROCEDURE check_unique_name(x_rowid VARCHAR2, x_name VARCHAR2);
263: --
270: -- Arguments
271: -- x_rowid The ID of the row to be checked
272: -- x_short_name The short name to be checked
273: -- Example
274: -- GL_LEDGERS_PKG.check_unique_short_name( '12345', 'LEDGER 1' );
275: -- Notes
276: --
277: PROCEDURE check_unique_short_name(x_rowid VARCHAR2, x_short_name VARCHAR2);
278: --
284: -- 02/08/01 O Monnier Created from old sets of books package.
285: -- Arguments
286: -- none
287: -- Example
288: -- :ledger.ledger_id := GL_LEDGERS_PKG.get_unique_id;
289: -- Notes
290: --
291: FUNCTION get_unique_id
292: RETURN NUMBER;
299: -- 02/08/01 O Monnier Created
300: -- Arguments
301: -- X_Chart_Of_Accounts_Id Key Flexfield Structure Num
302: -- Example
303: -- test := GL_LEDGERS_PKG.is_coa_frozen ( 101 );
304: -- Notes
305: --
306: FUNCTION is_coa_frozen(x_chart_of_accounts_id NUMBER)
307: RETURN BOOLEAN;
319: -- X_Mgt_Seg_Column_Name Retrieve the balancing segment column name
320: -- X_Mgt_Seg_Value_Set_Id Retrieve the balancing segment value set id
321: -- X_Chart_Of_Accounts_Id Key Flexfield Structure Num
322: -- Example
323: -- GL_LEDGERS_PKG.get_bal_seg_info(X_Bal_Seg_Column_Name,
324: -- X_Bal_Seg_Value_Set_Id,
325: -- X_Mgt_Seg_Column_Name,
326: -- X_Mgt_Seg_Value_Set_Id,
327: -- 1);
569: -- Example
570: -- select_row(recinfo);
571: -- Notes
572: --
573: PROCEDURE select_row(recinfo IN OUT NOCOPY gl_ledgers%ROWTYPE);
574: --
575: -- Procedure
576: -- select_column
577: -- Purpose
844: -- 01/13/06 Jen Wu Created
845: -- Arguments
846: -- x_le_id legal entity id
847: -- Example
848: -- GL_LEDGERS_PKG.remove_lgr_bsv_for_le(1);
849: -- Notes
850: --
851:
852: PROCEDURE remove_lgr_bsv_for_le(x_le_id NUMBER);
860: -- 21/01/05 C Ma Created
861: -- Arguments
862: -- x_le_id legal entity id
863: -- Example
864: -- GL_LEDGERS_PKG.process_le_bsv_assign(1, 1, '01','I',null,null);
865: -- Notes
866: --
867: PROCEDURE process_le_bsv_assign(x_le_id NUMBER,
868: x_value_set_id NUMBER,
882: -- Arguments
883: -- x_flex_value_set_id
884: -- x_bal_seg_value
885: -- Example
886: -- GL_LEDGERS_PKG.get_bsv_desc(1002472, '01');
887: -- Notes
888: --
889: FUNCTION get_bsv_desc( x_object_type VARCHAR2,
890: x_object_id NUMBER,
904: -- Arguments
905: -- x_period_set_name
906: -- x_period_type
907: -- Example
908: -- GL_LEDGERS_PKG.check_calendar_gap('Accounting', 'Month',
909: -- x_gap_flag, x_start_date, x_end_date);
910: -- Notes
911: --
912: PROCEDURE check_calendar_gap (
929: -- Arguments
930: -- x_period_set_name
931: -- x_period_type
932: -- Example
933: -- GL_LEDGERS_PKG.check_duplicate_ledger('Accounting', 1,
934: -- x_dupl_flag);
935: -- Notes
936: --
937: PROCEDURE check_duplicate_ledger (
974: FUNCTION get_short_name ( x_primary_ledger_short_name VARCHAR2,
975: x_suffix_length number)
976: RETURN VARCHAR2;
977: -- *********************************************************************
978: END gl_ledgers_pkg;