6: ----------------------------------------
7:
8: TYPE OrgIDTable IS TABLE OF hr_organization_information.organization_id%TYPE;
9: TYPE AutoSiteNumberingTable IS TABLE OF
10: ar_system_parameters_all.auto_site_numbering%TYPE;
11: TYPE DefaultCountryTable IS TABLE OF
12: ar_system_parameters_all.default_country%TYPE;
13: TYPE SetOfBooksIDTable is TABLE OF gl_sets_of_books.set_of_books_id%TYPE;
14: TYPE ChartOfAccountsIDTable IS TABLE OF
8: TYPE OrgIDTable IS TABLE OF hr_organization_information.organization_id%TYPE;
9: TYPE AutoSiteNumberingTable IS TABLE OF
10: ar_system_parameters_all.auto_site_numbering%TYPE;
11: TYPE DefaultCountryTable IS TABLE OF
12: ar_system_parameters_all.default_country%TYPE;
13: TYPE SetOfBooksIDTable is TABLE OF gl_sets_of_books.set_of_books_id%TYPE;
14: TYPE ChartOfAccountsIDTable IS TABLE OF
15: gl_sets_of_books.chart_of_accounts_id%TYPE;
16: TYPE LocationStructureIDTable is TABLE OF ar_system_parameters_all.location_structure_id%TYPE;
12: ar_system_parameters_all.default_country%TYPE;
13: TYPE SetOfBooksIDTable is TABLE OF gl_sets_of_books.set_of_books_id%TYPE;
14: TYPE ChartOfAccountsIDTable IS TABLE OF
15: gl_sets_of_books.chart_of_accounts_id%TYPE;
16: TYPE LocationStructureIDTable is TABLE OF ar_system_parameters_all.location_structure_id%TYPE;
17: TYPE TaxMethodTable is TABLE OF ar_system_parameters_all.tax_method%TYPE;
18: TYPE AddressValTable is TABLE OF ar_system_parameters_all.address_validation%TYPE;
19: -- Bug 5002547 : Added for Reciprocal Flag field
20: TYPE ReciprocalFlagTable is TABLE OF
13: TYPE SetOfBooksIDTable is TABLE OF gl_sets_of_books.set_of_books_id%TYPE;
14: TYPE ChartOfAccountsIDTable IS TABLE OF
15: gl_sets_of_books.chart_of_accounts_id%TYPE;
16: TYPE LocationStructureIDTable is TABLE OF ar_system_parameters_all.location_structure_id%TYPE;
17: TYPE TaxMethodTable is TABLE OF ar_system_parameters_all.tax_method%TYPE;
18: TYPE AddressValTable is TABLE OF ar_system_parameters_all.address_validation%TYPE;
19: -- Bug 5002547 : Added for Reciprocal Flag field
20: TYPE ReciprocalFlagTable is TABLE OF
21: ar_system_parameters_all.create_reciprocal_flag%TYPE;
14: TYPE ChartOfAccountsIDTable IS TABLE OF
15: gl_sets_of_books.chart_of_accounts_id%TYPE;
16: TYPE LocationStructureIDTable is TABLE OF ar_system_parameters_all.location_structure_id%TYPE;
17: TYPE TaxMethodTable is TABLE OF ar_system_parameters_all.tax_method%TYPE;
18: TYPE AddressValTable is TABLE OF ar_system_parameters_all.address_validation%TYPE;
19: -- Bug 5002547 : Added for Reciprocal Flag field
20: TYPE ReciprocalFlagTable is TABLE OF
21: ar_system_parameters_all.create_reciprocal_flag%TYPE;
22: ----------------------------------------
17: TYPE TaxMethodTable is TABLE OF ar_system_parameters_all.tax_method%TYPE;
18: TYPE AddressValTable is TABLE OF ar_system_parameters_all.address_validation%TYPE;
19: -- Bug 5002547 : Added for Reciprocal Flag field
20: TYPE ReciprocalFlagTable is TABLE OF
21: ar_system_parameters_all.create_reciprocal_flag%TYPE;
22: ----------------------------------------
23: -- declaration of global record types.
24: ----------------------------------------
25:
23: -- declaration of global record types.
24: ----------------------------------------
25:
26: TYPE GlobalsRecord IS RECORD (
27: Auto_site_numbering AR_SYSTEM_PARAMETERS_ALL.AUTO_SITE_NUMBERING%TYPE,
28: Default_country AR_SYSTEM_PARAMETERS_ALL.DEFAULT_COUNTRY%TYPE,
29: Chart_of_accounts_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
30: Set_of_books_ID GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE,
31: Location_structure_ID AR_SYSTEM_PARAMETERS_ALL.LOCATION_STRUCTURE_ID%TYPE,
24: ----------------------------------------
25:
26: TYPE GlobalsRecord IS RECORD (
27: Auto_site_numbering AR_SYSTEM_PARAMETERS_ALL.AUTO_SITE_NUMBERING%TYPE,
28: Default_country AR_SYSTEM_PARAMETERS_ALL.DEFAULT_COUNTRY%TYPE,
29: Chart_of_accounts_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
30: Set_of_books_ID GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE,
31: Location_structure_ID AR_SYSTEM_PARAMETERS_ALL.LOCATION_STRUCTURE_ID%TYPE,
32: Tax_method AR_SYSTEM_PARAMETERS_ALL.TAX_METHOD%TYPE,
27: Auto_site_numbering AR_SYSTEM_PARAMETERS_ALL.AUTO_SITE_NUMBERING%TYPE,
28: Default_country AR_SYSTEM_PARAMETERS_ALL.DEFAULT_COUNTRY%TYPE,
29: Chart_of_accounts_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
30: Set_of_books_ID GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE,
31: Location_structure_ID AR_SYSTEM_PARAMETERS_ALL.LOCATION_STRUCTURE_ID%TYPE,
32: Tax_method AR_SYSTEM_PARAMETERS_ALL.TAX_METHOD%TYPE,
33: Address_val AR_SYSTEM_PARAMETERS_ALL.ADDRESS_VALIDATION%TYPE,
34: Reciprocal_flag AR_SYSTEM_PARAMETERS_ALL.CREATE_RECIPROCAL_FLAG%TYPE
35: );
28: Default_country AR_SYSTEM_PARAMETERS_ALL.DEFAULT_COUNTRY%TYPE,
29: Chart_of_accounts_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
30: Set_of_books_ID GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE,
31: Location_structure_ID AR_SYSTEM_PARAMETERS_ALL.LOCATION_STRUCTURE_ID%TYPE,
32: Tax_method AR_SYSTEM_PARAMETERS_ALL.TAX_METHOD%TYPE,
33: Address_val AR_SYSTEM_PARAMETERS_ALL.ADDRESS_VALIDATION%TYPE,
34: Reciprocal_flag AR_SYSTEM_PARAMETERS_ALL.CREATE_RECIPROCAL_FLAG%TYPE
35: );
36:
29: Chart_of_accounts_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
30: Set_of_books_ID GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE,
31: Location_structure_ID AR_SYSTEM_PARAMETERS_ALL.LOCATION_STRUCTURE_ID%TYPE,
32: Tax_method AR_SYSTEM_PARAMETERS_ALL.TAX_METHOD%TYPE,
33: Address_val AR_SYSTEM_PARAMETERS_ALL.ADDRESS_VALIDATION%TYPE,
34: Reciprocal_flag AR_SYSTEM_PARAMETERS_ALL.CREATE_RECIPROCAL_FLAG%TYPE
35: );
36:
37: TYPE GlobalsTable is RECORD (
30: Set_of_books_ID GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE,
31: Location_structure_ID AR_SYSTEM_PARAMETERS_ALL.LOCATION_STRUCTURE_ID%TYPE,
32: Tax_method AR_SYSTEM_PARAMETERS_ALL.TAX_METHOD%TYPE,
33: Address_val AR_SYSTEM_PARAMETERS_ALL.ADDRESS_VALIDATION%TYPE,
34: Reciprocal_flag AR_SYSTEM_PARAMETERS_ALL.CREATE_RECIPROCAL_FLAG%TYPE
35: );
36:
37: TYPE GlobalsTable is RECORD (
38: org_id_t OrgIDTable,
46: reciprocal_flag_t ReciprocalFlagTable
47: );
48:
49: TYPE cust_num_gen_rec IS RECORD (
50: Default_Org AR_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE,
51: Generate_customer_number
52: AR_SYSTEM_PARAMETERS_ALL.generate_customer_number%TYPE,
53: -- Bug 5002547 : Added for Grouping Rule, Autocash Rule Set field
54: Default_grouping_rule_ID
48:
49: TYPE cust_num_gen_rec IS RECORD (
50: Default_Org AR_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE,
51: Generate_customer_number
52: AR_SYSTEM_PARAMETERS_ALL.generate_customer_number%TYPE,
53: -- Bug 5002547 : Added for Grouping Rule, Autocash Rule Set field
54: Default_grouping_rule_ID
55: AR_SYSTEM_PARAMETERS_ALL.default_grouping_rule_id%TYPE,
56: Autocash_hierarchy_ID AR_SYSTEM_PARAMETERS_ALL.autocash_hierarchy_id%TYPE
51: Generate_customer_number
52: AR_SYSTEM_PARAMETERS_ALL.generate_customer_number%TYPE,
53: -- Bug 5002547 : Added for Grouping Rule, Autocash Rule Set field
54: Default_grouping_rule_ID
55: AR_SYSTEM_PARAMETERS_ALL.default_grouping_rule_id%TYPE,
56: Autocash_hierarchy_ID AR_SYSTEM_PARAMETERS_ALL.autocash_hierarchy_id%TYPE
57: );
58:
59: --------------------------------------
52: AR_SYSTEM_PARAMETERS_ALL.generate_customer_number%TYPE,
53: -- Bug 5002547 : Added for Grouping Rule, Autocash Rule Set field
54: Default_grouping_rule_ID
55: AR_SYSTEM_PARAMETERS_ALL.default_grouping_rule_id%TYPE,
56: Autocash_hierarchy_ID AR_SYSTEM_PARAMETERS_ALL.autocash_hierarchy_id%TYPE
57: );
58:
59: --------------------------------------
60: -- declaration of public procedures and functions