APPS.GCS_WEBADI_PKG dependencies on BNE_STORED_SQL

Line 861: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||

857: -- update stored SQL
858: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
859: fnd_log.STRING(fnd_log.level_statement,
860: g_pkg_name || '.' || l_api_name,
861: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
862: gcs_utility_pkg.g_nl ||
863: ' WHERE application_id=l_app_id AND content_code=''GCS_AD_TB_CNT''');
864: END IF;
865:

Line 866: UPDATE bne_stored_sql

862: gcs_utility_pkg.g_nl ||
863: ' WHERE application_id=l_app_id AND content_code=''GCS_AD_TB_CNT''');
864: END IF;
865:
866: UPDATE bne_stored_sql
867: SET QUERY = l_query
868: --Bug Fix : 5563482
869: --last_update_date = SYSDATE
870: WHERE application_id = l_app_id

Line 929: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||

925: ' WHERE ad_transaction_id = $param$.xns_id ';
926: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
927: fnd_log.STRING(fnd_log.level_statement,
928: g_pkg_name || '.' || l_api_name,
929: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
930: gcs_utility_pkg.g_nl ||
931: ' WHERE application_id=l_app_id AND content_code=''GCS_AD_ENTRY_CNT''');
932: END IF;
933:

Line 934: UPDATE bne_stored_sql

930: gcs_utility_pkg.g_nl ||
931: ' WHERE application_id=l_app_id AND content_code=''GCS_AD_ENTRY_CNT''');
932: END IF;
933:
934: UPDATE bne_stored_sql
935: SET QUERY = l_query
936: --Bug Fix : 5563482
937: --last_update_date = SYSDATE
938: WHERE application_id = l_app_id

Line 989: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||

985:
986: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
987: fnd_log.STRING(fnd_log.level_statement,
988: g_pkg_name || '.' || l_api_name,
989: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
990: gcs_utility_pkg.g_nl ||
991: ' WHERE application_id=l_app_id AND content_code=''GCS_HRATE_RE_CNT''');
992: END IF;
993:

Line 994: UPDATE bne_stored_sql

990: gcs_utility_pkg.g_nl ||
991: ' WHERE application_id=l_app_id AND content_code=''GCS_HRATE_RE_CNT''');
992: END IF;
993:
994: UPDATE bne_stored_sql
995: SET QUERY = l_query
996: WHERE application_id = l_app_id
997: AND content_code = 'GCS_HRATE_RE_CNT';
998:

Line 1047: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||

1043:
1044: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1045: fnd_log.STRING(fnd_log.level_statement,
1046: g_pkg_name || '.' || l_api_name,
1047: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
1048: gcs_utility_pkg.g_nl ||
1049: ' WHERE application_id=l_app_id AND content_code=''GCS_HRATE_CNT''');
1050: END IF;
1051:

Line 1052: UPDATE bne_stored_sql

1048: gcs_utility_pkg.g_nl ||
1049: ' WHERE application_id=l_app_id AND content_code=''GCS_HRATE_CNT''');
1050: END IF;
1051:
1052: UPDATE bne_stored_sql
1053: SET QUERY = l_query
1054: WHERE application_id = l_app_id
1055: AND content_code = 'GCS_HRATE_CNT';
1056:

Line 1114: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||

1110:
1111: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1112: fnd_log.STRING(fnd_log.level_statement,
1113: g_pkg_name || '.' || l_api_name,
1114: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
1115: gcs_utility_pkg.g_nl ||
1116: ' WHERE application_id=l_app_id AND content_code=''GCS_ENTRY_LINES_CNT''');
1117: END IF;
1118:

Line 1119: UPDATE bne_stored_sql

1115: gcs_utility_pkg.g_nl ||
1116: ' WHERE application_id=l_app_id AND content_code=''GCS_ENTRY_LINES_CNT''');
1117: END IF;
1118:
1119: UPDATE bne_stored_sql
1120: SET QUERY = l_query
1121: --Bug Fix : 5563482
1122: --last_update_date = SYSDATE
1123: WHERE application_id = l_app_id