2327: p_return_status OUT NOCOPY VARCHAR2)
2328: IS
2329: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
2330: l_functional_currency gl_sets_of_books.currency_code%type;
2331: l_base_precision fnd_currencies.precision%type;
2332: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2333: l_master_org_id oe_system_parameters_all.master_organization_id%type;
2334: l_sob_test gl_sets_of_books.set_of_books_id%type;
2335:
2328: IS
2329: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
2330: l_functional_currency gl_sets_of_books.currency_code%type;
2331: l_base_precision fnd_currencies.precision%type;
2332: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2333: l_master_org_id oe_system_parameters_all.master_organization_id%type;
2334: l_sob_test gl_sets_of_books.set_of_books_id%type;
2335:
2336: CURSOR c_ar_product_options (c_org_id NUMBER,
2477: p_return_status OUT NOCOPY VARCHAR2)
2478: IS
2479: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
2480: l_functional_currency gl_sets_of_books.currency_code%type;
2481: l_base_precision fnd_currencies.precision%type;
2482: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2483: l_master_org_id oe_system_parameters_all.master_organization_id%type;
2484: l_sob_test gl_sets_of_books.set_of_books_id%type;
2485:
2478: IS
2479: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
2480: l_functional_currency gl_sets_of_books.currency_code%type;
2481: l_base_precision fnd_currencies.precision%type;
2482: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2483: l_master_org_id oe_system_parameters_all.master_organization_id%type;
2484: l_sob_test gl_sets_of_books.set_of_books_id%type;
2485:
2486: CURSOR c_pa_product_options (c_org_id NUMBER,