DBA Data[Home] [Help]

APPS.JG_GLOBE_FLEX_VAL dependencies on AR_SYSTEM_PARAMETERS

Line 1677: FROM ar_system_parameters s

1673: --
1674:
1675: CURSOR generate_number IS
1676: SELECT s.generate_customer_number
1677: FROM ar_system_parameters s
1678: WHERE s.set_of_books_id = p_sob_id;
1679: l_cust_man_numbering ar_system_parameters.generate_customer_number%TYPE;
1680:
1681: PG_DEBUG varchar2(1);

Line 1679: l_cust_man_numbering ar_system_parameters.generate_customer_number%TYPE;

1675: CURSOR generate_number IS
1676: SELECT s.generate_customer_number
1677: FROM ar_system_parameters s
1678: WHERE s.set_of_books_id = p_sob_id;
1679: l_cust_man_numbering ar_system_parameters.generate_customer_number%TYPE;
1680:
1681: PG_DEBUG varchar2(1);
1682:
1683: BEGIN

Line 1702: -- Get Customer Numbering - Automatic/Manual from AR_SYSTEM_PARAMETERS

1698: arp_standard.debug('check_attr_value: ' || 'Global Descr Flex Field Validation Begin: '
1699: || to_char(sysdate, 'DD-MON-RR HH:MI:SS'));
1700: END IF;
1701:
1702: -- Get Customer Numbering - Automatic/Manual from AR_SYSTEM_PARAMETERS
1703:
1704: IF p_int_table_name = 'CUSTOMER' THEN
1705: OPEN generate_number;
1706: FETCH generate_number INTO l_cust_man_numbering;