837:
838: BEGIN
839: SELECT count(*)
840: INTO l_cnt_of_hdr_extns_gt
841: FROM ZX_PRVDR_HDR_EXTNS_GT;
842: EXCEPTION WHEN OTHERS THEN
843: l_cnt_of_hdr_extns_gt := 0;
844: END;
845:
5248: 'l_cnt_of_options_gt = '||l_cnt_of_options_gt);
5249: BEGIN
5250: SELECT count(*)
5251: INTO l_cnt_of_hdr_extns_gt
5252: FROM ZX_PRVDR_HDR_EXTNS_GT;
5253: EXCEPTION WHEN OTHERS THEN
5254: l_cnt_of_hdr_extns_gt := 0;
5255: END;
5256: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5257: 'l_cnt_of_hdr_extns_gt = '||l_cnt_of_hdr_extns_gt);
5258: BEGIN
5259: SELECT count(*)
5260: INTO l_cnt_of_line_extns_gt
5261: FROM ZX_PRVDR_HDR_EXTNS_GT;
5262: EXCEPTION WHEN OTHERS THEN
5263: l_cnt_of_line_extns_gt := 0;
5264: END;
5265: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,