APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on JL_BR_SPED_EXTR_PARAM

Line 960: INSERT INTO JL_BR_SPED_EXTR_PARAM

956:
957: END IF; -- End for IF p_inscription_source = 'ZX'(EBTax);
958:
959: BEGIN
960: INSERT INTO JL_BR_SPED_EXTR_PARAM
961: (REQUEST_ID,
962: LEDGER_ID,
963: LEGAL_ENTITY_ID,
964: ESTABLISHMENT_ID,

Line 1039: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR While inserting into JL_BR_SPED_EXTR_PARAM ');

1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1039: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR While inserting into JL_BR_SPED_EXTR_PARAM ');
1040: END IF;
1041: g_errbuf := 'ERROR While inserting into JL_BR_SPED_EXTR_PARAM '||SQLERRM;
1042: g_retcode := 2;
1043: return;

Line 1041: g_errbuf := 'ERROR While inserting into JL_BR_SPED_EXTR_PARAM '||SQLERRM;

1037: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1039: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR While inserting into JL_BR_SPED_EXTR_PARAM ');
1040: END IF;
1041: g_errbuf := 'ERROR While inserting into JL_BR_SPED_EXTR_PARAM '||SQLERRM;
1042: g_retcode := 2;
1043: return;
1044: END;
1045:

Line 7394: FROM jl_br_sped_extr_param

7390: BEGIN -- Begin for checking whether the report is finally submitted or not for the period?
7391:
7392: SELECT COUNT(*)
7393: INTO l_cnt
7394: FROM jl_br_sped_extr_param
7395: WHERE legal_entity_id = g_legal_entity_id
7396: AND bookkeeping_type = g_bookkeeping_type
7397: AND estb_acct_type = g_accounting_type
7398: AND ((g_establishment_id IS NOT NULL AND establishment_id = g_establishment_id )

Line 7429: FROM jl_br_sped_extr_param

7425: BEGIN
7426:
7427: SELECT bookkeeping_type
7428: INTO l_prev_bk_type
7429: FROM jl_br_sped_extr_param
7430: WHERE legal_entity_id = g_legal_entity_id
7431: AND estb_acct_type = g_accounting_type
7432: AND ((g_establishment_id IS NOT NULL AND establishment_id = g_establishment_id)
7433: OR (g_establishment_id IS NULL AND establishment_id IS NULL))

Line 7461: FROM jl_br_sped_extr_param

7457: BEGIN
7458:
7459: SELECT bookkeeping_type
7460: INTO l_prev_bk_type
7461: FROM jl_br_sped_extr_param
7462: WHERE legal_entity_id = g_legal_entity_id
7463: AND estb_acct_type = g_accounting_type
7464: AND ((g_establishment_id IS NOT NULL AND establishment_id= g_establishment_id)
7465: OR (g_establishment_id IS NULL AND establishment_id IS NULL))

Line 8449: FROM jl_br_sped_extr_param

8445: IF p_request_id IS NULL THEN
8446:
8447: SELECT request_id
8448: INTO l_request_id
8449: FROM jl_br_sped_extr_param
8450: WHERE legal_entity_id = g_legal_entity_id
8451: AND bookkeeping_type = g_bookkeeping_type
8452: AND estb_acct_type = g_accounting_type
8453: AND ((g_establishment_id IS NULL AND establishment_id is NULL) OR

Line 8486: UPDATE jl_br_sped_extr_param

8482: DELETE --purging the data as user running the extract prg for the combination which is already existing in temp table
8483: FROM jl_br_sped_extr_data_t
8484: WHERE request_id = l_request_id;
8485:
8486: UPDATE jl_br_sped_extr_param
8487: SET data_exist = 'N'
8488: WHERE request_id = l_request_id;
8489:
8490: END IF;

Line 9219: UPDATE JL_BR_SPED_EXTR_PARAM -- After successfull data extraction, updating the data_exist column in Parameter's table.

9215: END IF;
9216: END;
9217:
9218:
9219: UPDATE JL_BR_SPED_EXTR_PARAM -- After successfull data extraction, updating the data_exist column in Parameter's table.
9220: SET data_exist = 'Y'
9221: WHERE request_id = g_concurrent_request_id;
9222:
9223: