APPS.AR_GDF_VALIDATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 231

   SELECT  distinct 1
   INTO    is_there
   FROM    all_source
   WHERE   name = 'JL_ZZ_POSTBATCH'
   AND     type = 'PACKAGE BODY';

Line: 315

 |   last_update_login IN NUMBER                                           |
 |                                                                         |
 | RETURNS                                                                 |
 |    1      If validation is successful                                   |
 |    0      If error occured during validation                            |
 |                                                                         |
 | NOTES                                                                   |
 |                                                                         |
 | EXAMPLE                                                                 |
 |                                                                         |
 | MODIFICATION HISTORY                                                    |
 |    09-Sep-98  Vikram Ahluwalia           Created.                       |
 |    14-Dec-98  Josie Gazmen-Dabir         Bug 776476:  replaced reference|
 |                                          to package JG_TAXID_VAL_PKG    |
 |                                          to use JG_GLOBE_FLEX_VAL for   |
 |					    customer interface.            |
 |                                                                         |
 +-------------------------------------------------------------------------*/

FUNCTION is_gdf_taxid_valid(request_id        IN NUMBER,
                            org_id            IN NUMBER,
                            sob               IN NUMBER,
                            user_id           IN NUMBER,
                            application_id    IN NUMBER,
                            language_id       IN NUMBER,
                            program_id        IN NUMBER,
                            prog_appl_id      IN NUMBER,
                            last_update_login IN NUMBER )
RETURN NUMBER IS

 /*-------------------------------+
  |  Global variable declarations |
  +-------------------------------*/

   TRUE  CONSTANT NUMBER  := 1;

Line: 374

   SELECT  distinct 1
   INTO    is_there
   FROM    all_source
   WHERE   name = 'JG_GLOBE_FLEX_VAL'
   AND     type = 'PACKAGE BODY'
   AND     owner = l_user_schema;   /*Bug 3544086*/

Line: 399

                                           || last_update_login  || '); END;';

Line: 478

 |   last_update_login IN NUMBER                                           |
 |   int_table_name    IN VARCHAR2                                                                       |
 | RETURNS                                                                 |
 |    1      If validation is successful                                   |
 |    0      If error occured during validation                            |
 |                                                                         |
 | NOTES                                                                   |
 |                                                                         |
 | EXAMPLE                                                                 |
 |                                                                         |
 | MODIFICATION HISTORY                                                    |
 |    10-MAR-00  Chirag Mehta               Created.                       |
 |                                                                         |
 +-------------------------------------------------------------------------*/

FUNCTION is_cust_imp_valid(request_id        IN NUMBER,
                            org_id            IN NUMBER,
                            sob               IN NUMBER,
                            user_id           IN NUMBER,
                            application_id    IN NUMBER,
                            language_id       IN NUMBER,
                            program_id        IN NUMBER,
                            prog_appl_id      IN NUMBER,
                            last_update_login IN NUMBER,
                            int_table_name    IN VARCHAR2)
RETURN NUMBER IS

 /*-------------------------------+
  |  Global variable declarations |
  +-------------------------------*/

   TRUE  CONSTANT NUMBER  := 1;

Line: 534

   SELECT  distinct 1
   INTO    is_there
   FROM    all_source
   WHERE   name = 'JG_GLOBE_FLEX_VAL'
   AND     type = 'PACKAGE BODY'
   AND     owner = l_user_schema;

Line: 564

                                           || last_update_login  || ','
                                           ||'''CUSTOMER'''||'); END;';

Line: 578

                                           || last_update_login  || ','
                                           ||'''PROFILE'''||'); END;';

Line: 595

                                           || last_update_login  || ','
                                           ||'''CUSTOMER'''||'); END;';

Line: 609

                                           || last_update_login  || ','
                                           ||'''PROFILE'''||'); END;';

Line: 782

 |  insert_global_table                                                    |
 |                                                                         |
 | DESCRIPTION                                                             |
 |    This is module for insertion of address related 			   |
 |    records in globalization tables   				   |
 |    for Globalizations.                                                  |
 |									   |
 | ARGUMENTS                                                               |
 |   p_address_id      IN NUMBER                                           |
 |   p_contributor_class_code IN VARCHAR2                                  |
 |                                                                         |
 | NOTES                                                                   |
 |                                                                         |
 | EXAMPLE                                                                 |
 |                                                                         |
 | MODIFICATION HISTORY                                                    |
 |    11-JUNE-00  Chirag Mehta               Created.                      |
 |                                                                         |
 +-------------------------------------------------------------------------*/



PROCEDURE insert_global_table(p_address_id             IN NUMBER,
                              p_contributor_class_code IN VARCHAR2) IS
BEGIN

/* Call Globalization's procedue */

JL_ZZ_AR_TX_LIB_PKG.populate_cus_cls_details(p_address_id,p_contributor_class_code);

Line: 812

END insert_global_table;